GP_PKG_AT2_VW(SQL View) |
Index Back |
---|---|
Absence Take Entitlement DayAllows to combine multiple takes for one day |
SELECT PIN_NUM + 50000000 , EFFDT , PIN_TAKE_NUM FROM PS_GP_ABS_TAKE_DAY |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
2 | EFFDT | Date(10) | DATE | Effective Date |
3 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take |