!!!P2K_SMGLX

!Functionality
This database function will return the displayed value associated to a lexicon, given the value in the data base

!Parameters
|LEXICON_NAME  |The lexicon name (usually starts with X_ for provided lexicons)
|LEXICON_VALUE |the value for the lexicon that is stored in the data base (aka saved value or low value)

!Returns:
Varchar2(30)

!Errors:
If an invalid parameter is passed, then NULL is returned\\
If there is no value or record for that lexicon and value paid, then NULL is returned

!Examples:

{{P2K_SMGLX('X_GENDER','01')}} will retrieve the displayed value of the lexicon X_GENDER for a saved value (in the data base) indicated by the field '10'.

In a [Derivation Expression|DERIVATION_EXPRESSION] on [IDIF] you could specify the variable as the "Gender (EID)" and then replace it in the reference to this function as {{P2K_SMGLX('X_GENDER',~)}}





----
![Notes|Edit:Internal.P2K_SMGLX] 	
[{InsertPage page='Internal.P2K_SMGLX' default='Click to create a new notes page'}]