EMPLIDPERIOD_END_DTTRCPrompt Table: TL_TRC_TBL
Default Value: WM_WO_HDR.DESCR254
WM_PERS_TIME_VW(SQL View) |
Index Back |
|---|---|
WO Time Detail Lines View |
| SELECT A.EMPLID , A.PERIOD_END_DT , A.TRC , B.SETID , B.DESCR , A.TIME1 , A.TIME2 , A.TIME3 , A.TIME4 , A.TIME5 , A.TIME6 , A.TIME7 , A.TOTAL FROM PS_WM_PERS_TIME A , PS_EX_TRC_MAP_VW B WHERE A.TRC = B.TRC |
| # | 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 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL |
Description of length 254
Default Value: WM_WO_HDR.DESCR254 |
| 6 | TIME1 | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | TIME1 |
| 7 | TIME2 | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | TIME2 |
| 8 | TIME3 | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | TIME3 |
| 9 | TIME4 | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | TIME4 |
| 10 | TIME5 | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | TIME5 |
| 11 | TIME6 | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | TIME6 |
| 12 | TIME7 | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | TIME7 |
| 13 | TOTAL | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Row Total |