DBO.EQ_STD_COMPANY_SEGMENT_CODE_FROM_ASSIGNMENT(Parameter1, Parameter2, Parameter3)
This function will accept the display value of the assignment id, segment level, and the value of ‘FROM’ or ‘TO’. It will return the Code as listed on the Segment Lookups detail screen for a given assignment. This may be useful for systems integration.
Parameter(s)
Parameter1: [Assignment: ID]
Parameter2: Segment Level number e.g. 1,2,3,4
Parameter3: Value of 'FROM' or 'TO'
Example(s)
Example 1: Return the Code as listed on the Company Segment Lookups detail screen for the 'From' Segment 2 (Office Location) level for an assignment
DBO.EQ_STD_COMPANY_SEGMENT_CODE_FROM_ASSIGNMENT([Assignment: ID], 2, 'FROM')
Example of field output
Company Segment Lookup by Office Location (segment 2) screen
