!!!P2K_SMGLXMN

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

!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(50)

!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_SMGLXMN('X_GENDER',GENDER)}} will retrieve the meaning field, in [IMLN] of the lexicon X_GENDER for a saved value (in the data base) indicated by the field GENDER.

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


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