LM_ADHC_LRN_IDLM_PERSON_IDLANGUAGE_CDLM_SUPP_FL_LVW(SQL View) |
Index Back |
|---|---|
Language record for supp learnLanguage record for supp learn |
| SELECT T.LM_ADHC_LRN_ID , T.LM_PERSON_ID , L.LANGUAGE_CD , L1.LM_ADHC_TYPE , L.LM_PER_TRN_NM , L.LM_PER_TRN_INST , L.LM_PER_TRN_LOC FROM PS_LM_ADHC_LRN_TBL T , PS_LM_ADHC_TBL V , PS_LM_ADHC_LRN_LNG L , PS_LM_ADHC_LNG_TBL L1 WHERE T.LM_ADHC_ID = V.LM_ADHC_ID AND T.LM_ADHC_LRN_ID = L.LM_ADHC_LRN_ID AND T.LM_ADHC_ID=L1.LM_ADHC_ID AND L.LANGUAGE_CD=L1.LANGUAGE_CD AND %CurrentDateIn BETWEEN V.EFFDT AND V.LM_END_EFFDT AND V.LM_ACTIVE = 'Y' AND T.LM_ADHC_LRN_STTS IN ('INPO','PEAP', 'PLAN', 'COMP', 'DROP', 'DECL') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ADHC_LRN_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Learning Id |
| 2 | LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | LM_ADHC_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Type |
| 5 | 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. |
| 6 | LM_PER_TRN_INST | Character(50) | VARCHAR2(50) NOT NULL | Adhoc Learning Institution |
| 7 | LM_PER_TRN_LOC | Character(50) | VARCHAR2(50) NOT NULL | Adhoc Learning Location |