LM_TPLN_ENR_VW(SQL View) |
Index Back |
|---|---|
Training plan enrollmentTraining plan enrollment view |
| SELECT A.LM_ENRLMT_ID , A.LM_ACT_ID , C.lM_START_DT , C.LM_END_DT , A.LM_CI_ID , A.LM_PERSON_ID , A.LM_EMPL_RCD , B.LM_ORGANIZATION_ID , B.LM_LE_ID , B.LM_HR_COMPANY , B.BUSINESS_UNIT , A.LM_ENRL_DT , A.LM_STTS , A.LM_TRAINING_CLASS , A.LM_ACT_DIF_FLG , A.LM_LRQ_ID FROM PS_LM_ENRLMT A , PS_LM_PERSON_ATTRB B , PS_LM_ACT C WHERE A.LM_PERSON_ID = B.LM_PERSON_ID AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND A.LM_ACT_ID = C.LM_ACT_ID AND A.LM_EMPL_RCD = B.LM_EMPL_RCD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ENRLMT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
| 2 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 3 | LM_START_DT | Date(10) | DATE | Start Date |
| 4 | LM_END_DT | Date(10) | DATE | End Date |
| 5 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 6 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 7 | LM_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record umber |
| 8 | LM_ORGANIZATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Organization ID |
| 9 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Environment ID - System Generated number |
| 10 | LM_HR_COMPANY | Character(3) | VARCHAR2(3) NOT NULL | HR's Company ID brought over during synchronization. |
| 11 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 12 | LM_ENRL_DT | Date(10) | DATE | Enrollment/Registration Date |
| 13 | LM_STTS | Character(4) | VARCHAR2(4) NOT NULL |
Enrollment Status
CANC=Dropped COMP=Completed DECL=Denied ENRL=Enrolled INCO=Not Completed INPO=In-Progress MACT=Moved to New Activity NOTS=Not Started PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval RQST=Learning Request WAIV=Waived WTLT=Waitlisted |
| 14 | LM_TRAINING_CLASS | Character(10) | VARCHAR2(10) NOT NULL | Training Class |
| 15 | LM_ACT_DIF_FLG | Character(1) | VARCHAR2(1) NOT NULL | DIF Enrollment |
| 16 | LM_LRQ_ID | Number(10,0) | DECIMAL(10) NOT NULL | New field for ELM 9.0, stores unique identifier for a single learning request. |