GP_PAYGROUPCAL_IDWP_GP_CALENDAR(SQL View) |
Index Back |
|---|---|
Unfinalized GP CalendarsGlobal Payroll Calendars that are not finalized |
| SELECT A.GP_PAYGROUP , B.CAL_ID FROM PS_GP_PYGRP A , PS_GP_CALENDAR B , PS_GP_RUN_TYPE C WHERE A.GP_PAYGROUP = B.GP_PAYGROUP AND B.RUN_TYPE = C.RUN_TYPE AND C.CALC_TYPE='P' AND NOT EXISTS ( SELECT 'X' FROM PS_GP_CAL_RUN_DTL A1 WHERE A1.GP_PAYGROUP = B.GP_PAYGROUP AND A1.CAL_ID = B.CAL_ID AND A1.CAL_FINAL_TS IS NOT NULL) |
| # | 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 |