GPCH_RC_PAY_YEARGPCH_AL_CPAY_ENDDTGPCH_CAL_DT_VW(SQL View) |
Index Back |
|---|---|
Calendar DatesCalendar Dates |
| SELECT CALENDAR_YEAR ,THE_DATE FROM PS_TL_DATES_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPCH_RC_PAY_YEAR |
Number(4,0) | SMALLINT NOT NULL | Pay Year |
| 2 | GPCH_AL_CPAY_ENDDT |
Date(10) | DATE | Current Pay End Date |