LM_TRNGPLN_ITMS(SQL Table) |
Index Back |
---|---|
Training plan itemsTraining plan items generated for the report run. |
# | 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_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 |
4 | LM_LRQ_ID | Number(10,0) | DECIMAL(10) NOT NULL | New field for ELM 9.0, stores unique identifier for a single learning request. |
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 |
16 | LM_PRG_ID | Number(10,0) | DECIMAL(10) NOT NULL | Program ID is a unique identifier for curriculum and certification Programs. |
17 | LM_ADHC_LRN_ID | Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Learning Id |
18 | LM_TP_ITM_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Training Plan Item Cost |
19 | LM_EST_SAL_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Estimated Salary Cost |
20 | LM_FROM_LRQ | Character(1) | VARCHAR2(1) NOT NULL |
From Learning Request
Y/N Table Edit Default Value: N |