LM_PERSON_IDLM_PRS_LNG_PREF(SQL View) |
Index Back |
|---|---|
Person Language PreferenceView for retrieving preferred language |
| SELECT A1.LM_PERSON_ID ,%Coalesce((SELECT A.LANGUAGE_CD FROM PSOPRDEFN A, PS_LM_PERSON_OPRID B WHERE A.OPRID = B.OPRID AND B.LM_PERSON_ID=A1.LM_PERSON_ID), (SELECT LM_LANG_CD FROM PS_LM_PERSON_EFFDT A WHERE A.LM_PERSON_ID =A1.LM_PERSON_ID AND %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT), (SELECT LM_ATTRIB_VAL_CHAR FROM PS_LM_LRNR_ATTRIBS A WHERE LM_PERSON_ID = A1.LM_PERSON_ID AND LM_ATTRIB_NAME = 'LANGUAGE_CD')) FROM PS_LM_PERSON A1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |