RUN_CNTL_IDLM_TRN_PLN_IDLM_TRNG_PLN_ITM_IDLM_TPITM_LRNR_IDPrompt Table: LM_LE_UI_VW
Prompt Table: LM_HR_COMP_TBL
1=Class
2=Learning Request
3=Program Registration
4=Supplemental Learning
Y/N Table Edit
LM_TPLAN_OBJ_VW(SQL View) |
Index Back |
|---|---|
Objectives in a training planObjectives in a training plan |
| SELECT D.RUN_CNTL_ID , SETP.LM_TRN_PLN_ID , ITMS.LM_TRNG_PLN_ITM_ID , LRNR.LM_TPITM_LRNR_ID , SETP.LM_START_DT , SETP.LM_END_DT , SETP.LM_FINALIZATION_DT , SETP.LM_AS_OF_DATE , SETP.LM_LE_ID , SETP.LM_HR_COMPANY , ITMS.LM_ITEM_TYPE , ITMS.LM_LRQ_ID , ITMS.LM_ACT_ID , ITMS.DESCR254 , ITMS.LM_START_DT , ITMS.LM_END_DT , ITMS.LM_INSTR_ID , ITMS.LM_NAME_DISPLAY , ITMS.LM_OBJV_ID , ITMS.LM_OBJV_DESC , ITMS.LM_ACT_HOURS , ITMS.LM_INTERNAL_OFF , ITMS.LM_VENDOR_DESCR , LRNR.LM_NO_OF_LRNRS , LRNR.EMPLID , LRNR.LM_NAME_DISPLAY , LRNR.LM_HR_COMPANY , COMP.LM_COMP_DESCR , LRNR.LM_ORGANIZATION_ID , ORG.LM_ORG_DESCR , LRNR.LM_IN_PLAN , LRNR.LM_ENRL_DT , LRNR.LM_TRAINCLASS_DESC , LRNR.LM_LRNR_PROF_CAT , LRNR.LM_LRNR_PROF_CAT_2 , LRNR.LM_LRNR_PROF_CAT_3 , LRNR.LM_LRNR_PROF_CAT_4 , LRNR.LM_SETID_LAGR_DESC , LRNR.LM_JOB_TITLE , LRNR.LM_ATT_STTS_LABEL , LRNR.LM_ACT_DIF_FLG , LRNR.LM_LRNR_AGE FROM PS_LM_TRN_PLN_SETP SETP , PS_LM_TRNGPLN_ITMS ITMS , PS_LM_TPLNITM_LRNR LRNR , PS_LM_ORG_VW ORG , PS_LM_HR_COMP_TBL COMP , PS_LM_TRN_PLN_RCTL D WHERE SETP.LM_TRN_PLN_ID = ITMS.LM_TRN_PLN_ID AND D.LM_TRN_PLN_ID = SETP.LM_TRN_PLN_ID AND ITMS.LM_TRN_PLN_ID = LRNR.LM_TRN_PLN_ID AND ITMS.LM_TRNG_PLN_ITM_ID = LRNR.LM_TRNG_PLN_ITM_ID AND ORG.LM_ORGANIZATION_ID = LRNR.LM_ORGANIZATION_ID AND LRNR.LM_HR_COMPANY = COMP.LM_HR_COMPANY AND %CurrentDateIn BETWEEN COMP.EFFDT AND COMP.LM_END_EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 2 | LM_TRN_PLN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Training Plan Id |
| 3 | LM_TRNG_PLN_ITM_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Training plan item id for the report |
| 4 | LM_TPITM_LRNR_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Training Plan Item Learner Id |
| 5 | LM_START_DT | Date(10) | DATE | Start Date |
| 6 | LM_END_DT | Date(10) | DATE | End Date |
| 7 | LM_FINALIZATION_DT | Date(10) | DATE | Finalization Date |
| 8 | LM_AS_OF_DATE | Date(10) | DATE | As of Date |
| 9 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Learning Environment ID - System Generated number
Prompt Table: LM_LE_UI_VW |
| 10 | LM_HR_COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
HR's Company ID brought over during synchronization.
Prompt Table: LM_HR_COMP_TBL |
| 11 | LM_ITEM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Item type to identify a training plan item. It can be of type Activity or Learning Request.
1=Class 2=Learning Request 3=Program Registration 4=Supplemental Learning |
| 12 | LM_LRQ_ID | Number(10,0) | DECIMAL(10) NOT NULL | New field for ELM 9.0, stores unique identifier for a single learning request. |
| 13 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 14 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 15 | LM_FROM_DT | Date(10) | DATE | From Date |
| 16 | LM_TO_DT | Date(10) | DATE | To Date |
| 17 | LM_INSTR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Instructor ID |
| 18 | LM_INSTR_NAME | Character(50) | VARCHAR2(50) NOT NULL | Instructor name |
| 19 | LM_OBJV_ID | Number(10,0) | DECIMAL(10) NOT NULL | Objective ID. System Generated ID Number associated with each Objective. |
| 20 | LM_OBJV_DESC | Character(100) | VARCHAR2(100) NOT NULL | Objective description. |
| 21 | LM_ACT_HOURS | Number(13,2) | DECIMAL(12,2) NOT NULL | Activity Hours |
| 22 | LM_INTERNAL_OFF | Character(30) | VARCHAR2(30) NOT NULL | Internal/External Offering |
| 23 | LM_VENDOR_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Description |
| 24 | LM_NO_OF_LRNRS | Number(5,0) | INTEGER NOT NULL | no of learners field. |
| 25 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 26 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |
| 27 | LM_HR_COMPANY_1 | Character(3) | VARCHAR2(3) NOT NULL | HR's Company ID brought over during synchronization. |
| 28 | LM_COMP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Company description. |
| 29 | LM_ORGANIZATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Organization ID |
| 30 | LM_ORG_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Customer Description |
| 31 | LM_IN_PLAN | Character(1) | VARCHAR2(1) NOT NULL |
Field to indicate if the learner is in the training plan
Y/N Table Edit |
| 32 | LM_ENRL_DT | Date(10) | DATE | Enrollment/Registration Date |
| 33 | LM_TRAINCLASS_DESC | Character(50) | VARCHAR2(50) NOT NULL | Training class description |
| 34 | LM_LRNR_PROF_CAT | Character(30) | VARCHAR2(30) NOT NULL | Learner's professional category description |
| 35 | LM_LRNR_PROF_CAT_2 | Character(30) | VARCHAR2(30) NOT NULL | Learner's professional category description |
| 36 | LM_LRNR_PROF_CAT_3 | Character(30) | VARCHAR2(30) NOT NULL | Learner's professional category description |
| 37 | LM_LRNR_PROF_CAT_4 | Character(30) | VARCHAR2(30) NOT NULL | Learner's professional category description |
| 38 | LM_SETID_LAGR_DESC | Character(30) | VARCHAR2(30) NOT NULL | Learner's professional category description |
| 39 | LM_JOB_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 40 | LM_ATT_STTS_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Attendance Status Label |
| 41 | LM_ACT_DIF_FLG | Character(1) | VARCHAR2(1) NOT NULL | DIF Enrollment |
| 42 | LM_LRNR_AGE | Number(4,0) | SMALLINT NOT NULL | Learner's Age |