LM_TRN_PLN_IDLM_TRNG_PLN_ITM_IDLM_LRQ_ID1=Class
2=Learning Request
3=Program Registration
4=Supplemental Learning
LM_TRPLIT_VW(SQL View) |
Index Back |
|---|---|
Training plan itemsTraining plan items generated for the report run. |
| SELECT LM_TRN_PLN_ID , LM_TRNG_PLN_ITM_ID , LM_LRQ_ID , LM_ITEM_TYPE , LM_ACT_ID , DESCR254 , LM_START_DT , LM_END_DT , LM_INSTR_ID , LM_NAME_DISPLAY , LM_OBJV_ID , LM_OBJV_DESC , LM_ACT_HOURS , LM_INTERNAL_OFF , LM_VENDOR_DESCR FROM PS_LM_TRNGPLN_ITMS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_TRN_PLN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Training Plan Id |
| 2 | LM_TRNG_PLN_ITM_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Training plan item id for the report |
| 3 | LM_LRQ_ID |
Number(10,0) | DECIMAL(10) NOT NULL | New field for ELM 9.0, stores unique identifier for a single learning request. |
| 4 | 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 |
| 5 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 7 | LM_START_DT | Date(10) | DATE | Start Date |
| 8 | LM_END_DT | Date(10) | DATE | End Date |
| 9 | LM_INSTR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Instructor ID |
| 10 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |
| 11 | LM_OBJV_ID | Number(10,0) | DECIMAL(10) NOT NULL | Objective ID. System Generated ID Number associated with each Objective. |
| 12 | LM_OBJV_DESC | Character(100) | VARCHAR2(100) NOT NULL | Objective description. |
| 13 | LM_ACT_HOURS | Number(13,2) | DECIMAL(12,2) NOT NULL | Activity Hours |
| 14 | LM_INTERNAL_OFF | Character(30) | VARCHAR2(30) NOT NULL | Internal/External Offering |
| 15 | LM_VENDOR_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Description |