TRN_STG_ENRDUR(SQL Table) |
Index Back |
|---|---|
Training Duration StagingThis staging table contains training duration information received from ELM. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LM_ENRLMT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
| 2 | LM_LC_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Learning Component ID - Blended Learning |
| 3 | LM_SES_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Session ID |
| 4 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 5 | LM_LC_SHRT_NM | Character(10) | VARCHAR2(10) NOT NULL | Session Name |
| 6 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 7 | LM_HR_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | EMPLID from the HR System |
| 8 | LM_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record umber |
| 9 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 10 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 11 | LM_FORVRDTDEBFOR | Date(10) | DATE | Activity Start Date Field |
| 12 | LM_FORVRDTFINFOR | Date(10) | DATE | Activity End Date Field |
| 13 | COURSE_START_DT | Date(10) | DATE | Course Start Date |
| 14 | COURSE_END_DT | Date(10) | DATE | Course End Date |
| 15 | COURSE_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Course Title |
| 16 | LM_ACT_CD | Character(30) | VARCHAR2(30) NOT NULL | Activity Code |
| 17 | LM_FORVRHRS | Number(10,3) | DECIMAL(9,3) NOT NULL | Learning Component Duration in Hours |
| 18 | LM_FORVRHRSDIF | Number(10,3) | DECIMAL(9,3) NOT NULL | Learning Component DIF Duration in Hours |
| 19 | LM_HRS_DIF_HORS | Number(10,3) | DECIMAL(9,3) NOT NULL | Learning Component DIF Duration out of working schedule in Hours |
| 20 | LM_HRSDEVHORS | Number(10,3) | DECIMAL(9,3) NOT NULL | Learning Component Duration out of working schedule in Hours |
| 21 | LM_TRAINING_CLASS | Character(1) | VARCHAR2(1) NOT NULL | Training Class |
| 22 | LM_LC_COMP_STTS | Character(4) | VARCHAR2(4) NOT NULL |
Learning Component - Completion Status
CANC=Dropped COMP=Completed INCO=Not Completed INPO=In-Progress NOAT=Not Attempted |
| 23 | LM_HRS_TRACK_STTS | Character(1) | VARCHAR2(1) NOT NULL |
Hour Tracking Status
1=Pending Review from ELM Admin 2=Approved by ELM Administrator 3=Pending Review from Payroll 4=Cancelled 5=Publish Error 6=Rejected by Payroll Admin 7=Finalized |
| 24 | LM_EXTRNL_OFRNG | Character(3) | VARCHAR2(3) NOT NULL |
Internal/External Offering - A checkbox allowing the user to select whether the course is Internal or External.
10=Internal 20=External |