LM_TRN_PLN_IDLM_TRNG_PLN_ITM_IDLM_BUDGET_MODEL_ID1=Class
2=Learning Request
3=Program Registration
4=Supplemental Learning
LM_BUDGET_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_BUDGET_MODEL_ID |
Character(15) | VARCHAR2(15) NOT NULL | Budget Model Id |
| 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_LRQ_ID | Number(10,0) | DECIMAL(10) NOT NULL | New field for ELM 9.0, stores unique identifier for a single learning request. |
| 6 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 7 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 8 | LM_START_DT | Date(10) | DATE | Start Date |
| 9 | LM_END_DT | Date(10) | DATE | End Date |
| 10 | LM_INSTR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Instructor ID |
| 11 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |
| 12 | LM_OBJV_ID | Number(10,0) | DECIMAL(10) NOT NULL | Objective ID. System Generated ID Number associated with each Objective. |
| 13 | LM_OBJV_DESC | Character(100) | VARCHAR2(100) NOT NULL | Objective description. |
| 14 | LM_ACT_HOURS | Number(13,2) | DECIMAL(12,2) NOT NULL | Activity Hours |
| 15 | LM_INTERNAL_OFF | Character(30) | VARCHAR2(30) NOT NULL | Internal/External Offering |
| 16 | LM_VENDOR_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Description |
| 17 | LM_PRG_ID | Number(10,0) | DECIMAL(10) NOT NULL | Program ID is a unique identifier for curriculum and certification Programs. |
| 18 | LM_ADHC_LRN_ID | Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Learning Id |
| 19 | LM_TP_ITM_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Training Plan Item Cost |
| 20 | LM_EST_SAL_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Estimated Salary Cost |
| 21 | LM_FROM_LRQ | Character(1) | VARCHAR2(1) NOT NULL | From Learning Request |
| 22 | LM_WHATIF_DEMAND | Number(3,0) | SMALLINT NOT NULL | What If Demand |
| 23 | LM_LRQ_CRIT_1 | Number(3,0) | SMALLINT NOT NULL | Budget Criteria |
| 24 | LM_LRQ_CRIT_2 | Number(3,0) | SMALLINT NOT NULL | Budget Criteria |
| 25 | LM_LRQ_CRIT_3 | Number(3,0) | SMALLINT NOT NULL | Budget Criteria |
| 26 | LM_LRQ_CRIT_4 | Number(3,0) | SMALLINT NOT NULL | Budget Criteria |
| 27 | LM_LRQ_CRIT_5 | Number(3,0) | SMALLINT NOT NULL | Budget Criteria |
| 28 | LM_LRQ_CRIT_6 | Number(3,0) | SMALLINT NOT NULL | Budget Criteria |
| 29 | LM_LRQ_CRIT_7 | Number(3,0) | SMALLINT NOT NULL | Budget Criteria |
| 30 | LM_LRQ_CRIT_8 | Number(3,0) | SMALLINT NOT NULL | Budget Criteria |
| 31 | LM_LRQ_CRIT_9 | Number(3,0) | SMALLINT NOT NULL | Budget Criteria |
| 32 | LM_LRQ_CRIT_10 | Number(3,0) | SMALLINT NOT NULL | Budget Criteria |
| 33 | LM_LRQ_CRIT_11 | Number(3,0) | SMALLINT NOT NULL | Budget Criteria |
| 34 | LM_LRQ_CRIT_12 | Number(3,0) | SMALLINT NOT NULL | Budget Criteria |
| 35 | LM_LRQ_CRIT_13 | Number(3,0) | SMALLINT NOT NULL | Budget Criteria |
| 36 | LM_LRQ_CRIT_14 | Number(3,0) | SMALLINT NOT NULL | Budget Criteria |
| 37 | LM_LRQ_CRIT_15 | Number(3,0) | SMALLINT NOT NULL | Budget Criteria |
| 38 | LM_LRQ_CRIT_16 | Number(3,0) | SMALLINT NOT NULL | Budget Criteria |
| 39 | LM_LRQ_CRIT_17 | Number(3,0) | SMALLINT NOT NULL | Criteria |
| 40 | LM_LRQ_CRIT_18 | Number(3,0) | SMALLINT NOT NULL | Criteria |
| 41 | LM_LRQ_CRIT_19 | Number(3,0) | SMALLINT NOT NULL | Criteria |
| 42 | LM_LRQ_CRIT_20 | Number(3,0) | SMALLINT NOT NULL | Criteria |
| 43 | LM_LRQ_CRIT_21 | Number(3,0) | SMALLINT NOT NULL | Criteria |
| 44 | LM_LRQ_CRIT_22 | Number(3,0) | SMALLINT NOT NULL | Criteria |
| 45 | LM_LRQ_CRIT_23 | Number(3,0) | SMALLINT NOT NULL | Criteria |
| 46 | LM_LRQ_CRIT_24 | Number(3,0) | SMALLINT NOT NULL | Criteria |