TRGT_PAYGROUPCAL_IDGP_UNFIN_CAL_VW(SQL View) |
Index Back |
|---|---|
Unfinalized Calendar(calendar)This view selects Calendar entry from calendars that have not yet been 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 | TRGT_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Pay group to which retro deltas are targeted or forwarded |
| 2 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |