TRN_SCUT_STATUS(SQL Table) |
Index Back |
|---|---|
Training Session Cut DetailsTraining Session Cut Details |
| # | 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_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: 0 |
| 8 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: TRN_VAL_PAY_VW |
| 9 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL |
calendar id
Prompt Table: TRN_COL_CAL_VW |
| 10 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |