GPDE_AL_CAL_VW(SQL View) |
Index Back |
---|---|
Calendar ViewCalendar View |
SELECT CAL_RUN_ID ,MAX(PRD_END_DT) FROM PS_GP_CAL_RUN_DTL GROUP BY CAL_RUN_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
2 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |