LM_CUR_LRNG_VW(SQL View) |
Index Back |
|---|---|
HR Learning Pagelet |
| ( SELECT ACT.LM_PERSON_ID ,ACT.OPRID , ACT.LM_ENRLMT_ID , 0 , CI.LM_CS_LONG_NM , DM.LM_DM_SHRT_NM ,'X' , ACT.LM_STTS ,0 , ACT.LM_START_DT , 'N' , 'X' , 'X' , ACT.LM_ACT_ID , ACT.LM_CI_ID , 'X' , 'X' , 0 FROM PS_LM_CURR_ACTD_VW ACT , PS_LM_ALL_CI_VW CI , PS_LM_DMTHD_TYP_VW DM WHERE ACT.LM_CI_ID = CI.LM_CI_ID AND ACT.LM_STTS IN ('INPO','ENRL','PEAP','PPYA') AND DM.LM_DMTHD_TYPE_ID = ACT.LM_DMTHD_TYPE_ID) UNION ( SELECT PRG.LM_PERSON_ID , 'X' , 0 , PRG.LM_PRG_ID , PRG.LM_PRG_LONG_NM ,'X' , PRG.LM_PRG_TYPE , PRG.LM_PRG_STTS ,0 , PRG.LM_ENRL_DT ,'N' , 'X' , 'X' , 0 , 0 , 'X' , 'X' , 0 FROM PS_LM_LRNR_PRG_VW PRG WHERE PRG.LM_PRG_STTS IN ('INPO','ENRL','PEAP','PPYA')) |
| # | 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 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | LM_ENRLMT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
| 4 | LM_PRG_ID | Number(10,0) | DECIMAL(10) NOT NULL | Program ID is a unique identifier for curriculum and certification Programs. |
| 5 | LM_PRG_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Program Long Name |
| 6 | LM_DM_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - the long name of a Delivery Method Type |
| 7 | LM_PRG_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Program Type
CE=Certification CU=Curriculum |
| 8 | 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 |
| 9 | LM_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Field to keep track of the count of id fields |
| 10 | LM_START_DT | Date(10) | DATE | Start Date |
| 11 | LM_LAUNCH_LNK | Character(1) | VARCHAR2(1) NOT NULL | Launch Content |
| 12 | LM_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description |
| 13 | LM_LC_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Component ID - Blended Learning |
| 14 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 15 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 16 | LM_REQ_LRNG_ICON | Image Reference(30) | VARCHAR2(30) | Required Learning Icon displayed on the Team Learning Pagelet for HR Manager Self Service. |
| 17 | LM_PRIMARY | Character(1) | VARCHAR2(1) NOT NULL |
Primary Contact Method
N=No Y=Yes |
| 18 | LM_SECONDARY | Number(2,0) | SMALLINT NOT NULL | Primary Contact Method |