LM_LPLN_IDLM_PERSON_IDLM_PRG_REG_IDLM_ENRLMT_IDLM_ADHC_LRN_IDLANGUAGE_CDLM_LPLN_ADHCLVW(SQL View) |
Index Back |
|---|---|
Learning Plan Adhoc Rel LangRelated language for Learning Plan with Adhoc enrollments |
| SELECT A1.LM_LPLN_ID , A1.LM_PERSON_ID , A1.LM_PRG_REG_ID , A1.LM_ENRLMT_ID , A1.LM_ADHC_LRN_ID , LLG1.LANGUAGE_CD , LLG1.LM_PER_TRN_NM , TLG.LM_ADHC_TYPE FROM PS_LM_LPLN_DTL A1 , PS_LM_ADHC_LRN_TBL L1 , PS_LM_ADHC_LRN_LNG LLG1 , PS_LM_ADHC_TBL T1 , PS_LM_ADHC_LNG_TBL TLG WHERE L1.LM_ADHC_ID = T1.LM_ADHC_ID AND L1.LM_ENRL_DT BETWEEN T1.EFFDT AND T1.LM_END_EFFDT AND A1.LM_ADHC_LRN_ID = L1.LM_ADHC_LRN_ID AND A1.LM_PERSON_ID = L1.LM_PERSON_ID AND L1.LM_ADHC_LRN_ID = LLG1.LM_ADHC_LRN_ID AND T1.LM_ADHC_ID = TLG.LM_ADHC_ID AND T1.EFFDT = TLG.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_LPLN_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Learning Plan ID |
| 2 | LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 3 | LM_PRG_REG_ID |
Number(10,0) | DECIMAL(10) NOT NULL | The Program Registration ID is a unique identifier for a learner's program enrollment. |
| 4 | LM_ENRLMT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
| 5 | LM_ADHC_LRN_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Learning Id |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | LM_PER_TRN_NM | Character(254) | VARCHAR2(254) NOT NULL | Personal Training Name. This field is used in case of Adhoc training. This field will carry the name of the Course / Catalog Item the person took training. |
| 8 | LM_ADHC_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Type |