DBO.EQ_STD_CLASSIFICATION_CODE_FROM_DESCRIPTION_UNIQUE_NAME(Parameter1, Parameter2)
This function will accept the display value of a classification lookup and the unique name of the field. It will return the Code as listed on the Lookup Maintenance page. This may be useful for systems integration.
Parameter(s)
Parameter1: classification lookup display value e.g. [Employee: Gender]
Parameter2: field unique name e.g. 'EMPLOYEE!GENDER' - this can be found using the DDMO function
Example(s) of use:
Example 1: Return the Code as listed on the Lookup Maintenance screen using the display value of a classification lookup and the unique name of the field.
DBO.EQ_STD_CLASSIFICATION_CODE_FROM_DESCRIPTION_UNIQUE_NAME([Employee: Gender], 'EMPLOYEE!GENDER')
