TL_SRCH_EXCP_VW(SQL View) |
Index Back |
---|---|
Timesheet Global SearchException View |
SELECT A.EMPLID , A.EMPL_RCD , A.DUR , A.SEQ_NBR , MAX(A.ACTION_DTTM) FROM PS_TL_EXCEPTION A GROUP BY A.EMPLID ,A.EMPL_RCD ,A.DUR ,A.SEQ_NBR |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
2 | Number(3,0) | SMALLINT NOT NULL | Empl Record | |
3 | Date(10) | DATE NOT NULL | Date Under Report associates time being reported, scheduled or paid, to a specific date. | |
4 | Number(15,0) | DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 1 |
|
5 | ACTION_DTTM | DateTime(26) | TIMESTAMP | Override Date Time |