HR_CP_LEARNING(SQL View) |
Index Back |
|---|---|
Learning viewHR_CP_LEARNING is a view based on ePerformance Learning. This is empty record for Learning. |
| SELECT EP_LM_LRN_ID , EP_LM_PER_TRN_NM , EP_LM_LRN_TYPEDESC , EP_LM_STTS , EP_LM_STTS_DESCR , EP_LM_TARGETCMPLDT FROM PS_EP_LM_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_TARGETCMPLDT | Date(10) | DATE | This field is used for ELM integration: Target Completion Date |