OPRIDLM_ENRLMT_IDLANGUAGE_CDLM_PEN_TRN_LANG(SQL View) |
Index Back |
|---|---|
Rel Lang viewRelated Language view for LM_PEN_TRN_REQ view |
| SELECT D.OPRID , A.LM_ENRLMT_ID , B1.LANGUAGE_CD , B1.LM_CS_LONG_NM , C1.LM_DM_LONG_NM FROM PS_LM_OPRID_PER_VW D , PS_LM_ENRLMT A ,PS_LM_ACT A1 , PS_LM_CI_TBL D1 , PS_LM_CI_LANG B1 , PS_LM_DMTH_TYP_LNG C1 WHERE D.LM_PERSON_ID = A.LM_APPR_ID AND A.LM_ACT_ID = A1.LM_ACT_ID AND C1.LANGUAGE_CD = B1.LANGUAGE_CD AND A.LM_STTS IN ( 'PEAP','PPYA','CANC' ) AND A1.LM_CI_ID = B1.LM_CI_ID AND A1.LM_DMTHD_TYPE_ID = C1.LM_DMTHD_TYPE_ID AND B1.LANGUAGE_CD = C1.LANGUAGE_CD AND D1.LM_CI_ID = B1.LM_CI_ID AND A.LM_ENRL_DT BETWEEN D1.EFFDT AND D1.LM_END_EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | LM_ENRLMT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | LM_CS_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - Describes the long name of an object |
| 5 | LM_DM_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - the long name of a Delivery Method Type |