GP_ABS_DR_DTTM(SQL View) |
Index Back |
---|---|
Direct report AbsenceThis view is created for tracking the change in Direct report list for Absence Balance Global Search |
SELECT EMPLID ,MAX(LASTUPDDTTM) FROM PS_GP_ABS_SRC_DRVW GROUP BY EMPLID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |