LM_TRN_PLN_IDLM_TRNG_PLN_ITM_IDLM_TPITM_LRNR_IDY/N Table Edit
LM_TPLNITM_LRNR(SQL Table) |
Index Back |
|---|---|
Training Plan Item LearnerStores Training Plan Item Learners from a training plan 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_TPITM_LRNR_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Training Plan Item Learner Id |
| 4 | LM_NO_OF_LRNRS | Number(5,0) | INTEGER NOT NULL | no of learners field. |
| 5 | LM_ENRLMT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
| 6 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 7 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 8 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |
| 9 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Environment ID - System Generated number |
| 10 | LM_HR_COMPANY | Character(3) | VARCHAR2(3) NOT NULL | HR's Company ID brought over during synchronization. |
| 11 | LM_ORGANIZATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Organization ID |
| 12 | LM_IN_PLAN | Character(1) | VARCHAR2(1) NOT NULL |
Field to indicate if the learner is in the training plan
Y/N Table Edit |
| 13 | LM_ENRL_DT | Date(10) | DATE | Enrollment/Registration Date |
| 14 | LM_FORECASTED_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | stores Forecasted Cost |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 16 | LM_TRAINCLASS_DESC | Character(50) | VARCHAR2(50) NOT NULL | Training class description |
| 17 | LM_LRNR_PROF_CAT | Character(30) | VARCHAR2(30) NOT NULL | Learner's professional category description |
| 18 | LM_LRNR_PROF_CAT_2 | Character(30) | VARCHAR2(30) NOT NULL | Learner's professional category description |
| 19 | LM_LRNR_PROF_CAT_3 | Character(30) | VARCHAR2(30) NOT NULL | Learner's professional category description |
| 20 | LM_LRNR_PROF_CAT_4 | Character(30) | VARCHAR2(30) NOT NULL | Learner's professional category description |
| 21 | LM_SETID_LAGR_DESC | Character(30) | VARCHAR2(30) NOT NULL | Learner's professional category description |
| 22 | LM_JOB_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 23 | LM_ATT_STTS_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Attendance Status Label |
| 24 | LM_ACT_DIF_FLG | Character(1) | VARCHAR2(1) NOT NULL | DIF Enrollment |
| 25 | LM_LRNR_AGE | Number(4,0) | SMALLINT NOT NULL | Learner's Age |
| 26 | LM_PRG_REG_ID | Number(10,0) | DECIMAL(10) NOT NULL | The Program Registration ID is a unique identifier for a learner's program enrollment. |
| 27 | LM_ADHC_LRN_ID | Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Learning Id |
| 28 | LM_FROM_LRQ | Character(1) | VARCHAR2(1) NOT NULL | From Learning Request |