GP_PAYGROUPCAL_IDGP_CAL_DTLP_VW(SQL View) |
Index Back |
|---|---|
View Payroll CalendarsCalendar View used for selection in Off-Cycle Shows Payroll Calendars associated with a Calendar Group |
| SELECT CAL.GP_PAYGROUP , CAL.CAL_ID , PRD.PRD_BGN_DT , PRD.PRD_END_DT FROM PS_GP_CALENDAR CAL , PS_GP_RUN_TYPE RT , PS_GP_CAL_PRD PRD WHERE CAL.RUN_TYPE=RT.RUN_TYPE AND CAL.CAL_PRD_ID=PRD.CAL_PRD_ID AND RT.CALC_TYPE='P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 2 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 3 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 4 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |