EMPLIDPERIOD_END_DTTRCPrompt Table: TL_TRC_TBL
WM_PERS_TIME(SQL Table) |
Index Back |
|---|---|
WO Personal Time |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | PERIOD_END_DT |
Date(10) | DATE | Represents the date termination point for a given time set utilized in cash worksheet processing. |
| 3 | TRC |
Character(5) | VARCHAR2(5) NOT NULL |
Time Reporting Code
Prompt Table: TL_TRC_TBL |
| 4 | TIME1 | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | TIME1 |
| 5 | TIME2 | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | TIME2 |
| 6 | TIME3 | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | TIME3 |
| 7 | TIME4 | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | TIME4 |
| 8 | TIME5 | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | TIME5 |
| 9 | TIME6 | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | TIME6 |
| 10 | TIME7 | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | TIME7 |
| 11 | TOTAL | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Row Total |