LM_PERSON_IDLM_ADHC_LRN_IDLANGUAGE_CDLM_ADHC_PELG_VW(SQL View) |
Index Back |
|---|---|
Adhoc Learning ViewAdhoc Learning View |
| SELECT A.LM_PERSON_ID , A.LM_ADHC_LRN_ID , B.LANGUAGE_CD , A.LM_PER_TRN_NM , A.LM_PER_TRN_DESCR , A.LM_PER_TRN_LOC , A.LM_PER_TRN_INST , B.LM_ADHC_TYPE FROM PS_LM_ADHC_LRN_TBL A , PS_LM_ADHC_LNG_TBL B , PS_LM_ADHC_TBL C WHERE A.LM_ADHC_ID = C.LM_ADHC_ID AND A.LM_ENRL_DT BETWEEN C.EFFDT AND C.LM_END_EFFDT AND C.LM_ADHC_ID = B.LM_ADHC_ID |
| # | 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 | LM_ADHC_LRN_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Learning Id |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | 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. |
| 5 | LM_PER_TRN_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Personal Training Comments. This field is used in case of Adhoc training. This field will carry the comments on the Course / Catalog Item training the person took. |
| 6 | LM_PER_TRN_LOC | Character(50) | VARCHAR2(50) NOT NULL | Adhoc Learning Location |
| 7 | LM_PER_TRN_INST | Character(50) | VARCHAR2(50) NOT NULL | Adhoc Learning Institution |
| 8 | LM_ADHC_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Type |