EMPLIDCOURSE_START_DTCOURSESESSION_NBRCOURSE_TITLECUT_SESSION_NBRTRN_HOUR_TYPEPrompt Table: TRN_HRS_TYP_TBL
TRN_SCUT_HRS(SQL Table) |
Index Back |
|---|---|
Training Hours tableTo Store Training Hours |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | COURSE_START_DT |
Date(10) | DATE NOT NULL | Course Start Date |
| 3 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 4 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Course Session Nbr |
| 5 | COURSE_TITLE |
Character(30) | VARCHAR2(30) NOT NULL | Course Title |
| 6 | CUT_SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL | Cut Session Nbr |
| 7 | TRN_HOUR_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Training Hours type
Prompt Table: TRN_HRS_TYP_TBL |
| 8 | TRN_SCUT_IN_HRS | Number(10,3) | DECIMAL(9,3) NOT NULL | Training Session Cut in hours |
| 9 | TRN_SCUT_OUT_HRS | Number(10,3) | DECIMAL(9,3) NOT NULL | Training Session cut out hours |