OPRIDLM_ADHC_REQ_VW(SQL View) |
Index Back |
|---|---|
Training Request for AdhocAdhoc Training Requests |
| SELECT D.OPRID , A.LM_ADHC_LRN_ID , A.LM_PER_TRN_NM , A.LM_APPR_ID , A.LM_PERSON_ID , A.LM_ADHC_ID , B.LM_ADHC_TYPE , C.FIRST_NAME , C.LAST_NAME FROM PS_LM_OPRID_PER_VW D , PS_LM_ADHC_LRN_TBL A , PS_LM_ADHC_TBL B , PS_LM_PERS_DTL_VW C WHERE D.LM_PERSON_ID = A.LM_APPR_ID AND A.LM_ADHC_LRN_STTS = 'PEAP' AND A.LM_ADHC_ID = B.LM_ADHC_ID AND A.LM_PERSON_ID = C.LM_PERSON_ID AND A.LM_ENRL_DT BETWEEN B.EFFDT AND B.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_ADHC_LRN_ID | Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Learning Id |
| 3 | 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. |
| 4 | LM_APPR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Approver ID field |
| 5 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 6 | LM_ADHC_ID | Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Id |
| 7 | LM_ADHC_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Type |
| 8 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name field |
| 9 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name Field |