EP_LM_LEARNING(SQL Table) |
Index Back |
|---|---|
ePerformance LearningThis is empty record for Learning |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EP_LM_LRN_ID |
Number(10,0) | DECIMAL(10) NOT NULL | This field is used for ELM integration: ELM Learning ID |
| 2 | EP_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. This is used for ELM integration |
| 3 | EP_LM_LRN_TYPEDESC | Character(15) | VARCHAR2(15) NOT NULL | This field is used for ELM integration: ELM Learning Type Description |
| 4 | EP_LM_STTS | Character(4) | VARCHAR2(4) NOT NULL |
This field is used for ELM integration: Status Field for Learning Progress
CANC=Dropped COMP=Completed ENRL=Enrolled INCO=Not Completed INPO=In-Progress MACT=Moved to New Activity PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval RQST=Moved to Learning Request WAIV=Waived WTLT=Waitlisted |
| 5 | EP_LM_STTS_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Description for Learning Status, this field is use for ELM integration |
| 6 | EP_LM_COMPL_DT | Date(10) | DATE | This field is used for ELM integration:The date on which this Enrollment was marked Completed / InComplete |
| 7 | EP_LM_TARGETCMPLDT | Date(10) | DATE | This field is used for ELM integration: Target Completion Date |
| 8 | EP_LM_ENRL_DT | Date(10) | DATE | This Field is used for ELM integration: Learning Enrollment Date |
| 9 | EP_LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | This field is used for ELM integration: Name Display field |
| 10 | EP_LM_REQUESTOR_ID | Number(15,0) | DECIMAL(15) NOT NULL | This Field is used for ELM Integration: Requestor ID |
| 11 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 12 | EP_LM_CONFIRM_ID | Number(10,0) | DECIMAL(10) NOT NULL | Confirmation ID for Activity, Program and Adhoc, use for ELM integration |
| 13 | EP_LM_INITIATED_DT | Date(10) | DATE | The Date on which the course was launched by the student. This applies only for WBT |
| 14 | EP_LM_PLANNED_DATE | Date(10) | DATE | Date Planned, this field is used for ELM integration |
| 15 | EP_LM_STATUS_DT | Date(10) | DATE | Status Date: This field is used for ELM integration |