TRN_TRAIN_MAP(SQL Table) |
Index Back |
|---|---|
Training Information Map TableThis table map ELM enrollment ID with Training record. |
| # | 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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | COURSE_START_DT | Date(10) | DATE | Course Start Date |
| 5 | COURSE | Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: COURSE_TBL |
| 6 | SESSION_NBR | Character(4) | VARCHAR2(4) NOT NULL |
Course Session Nbr
Prompt Table: CRSE_ALL_SSN_VW |
| 7 | COURSE_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Course Title |
| 8 | LM_CST_TRACK_STTS | Character(1) | VARCHAR2(1) NOT NULL |
Student Cost Status
1=Ready to Sent to HR/TA 2=Sent to HR/TA successfully 3=Cancelled 4=Publish Error 5=Processed by HR/TA 6=Processed by HR/TA with Errors 9=New Default Value: 9 |
| 9 | TRN_SCUT_STATUS_SW | Character(1) | VARCHAR2(1) NOT NULL |
Session Cut Status
0=Awaiting Review 1=Appr by Training Administrator 2=Appr by Payroll Administrator 3=Finalized 9=Not Processed X=123456789012345678901234567890 Default Value: 1 |