GP_PAYGROUPPrompt Table: GP_PYGRP
CAL_IDPrompt Table: GP_CALENDAR
GP_CALENDAR1_VW(SQL View) |
Index Back |
|---|---|
Calendars For a Pay GroupShows all calendars not already associated with a given calendar group for a given pay group (bound in) |
| SELECT CAL.GP_PAYGROUP , CAL.CAL_ID FROM PS_GP_CALENDAR CAL WHERE NOT EXISTS ( SELECT 1 FROM PS_GP_CAL_RUN_DTL D , PS_GP_CAL_RUN E WHERE D.GP_PAYGROUP = CAL.GP_PAYGROUP AND D.CAL_ID = CAL.CAL_ID AND E.CAL_RUN_ID = D.CAL_RUN_ID AND E.USE_AS_TMPLT_IND <> 'Y') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP |
| 2 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL |
calendar id
Prompt Table: GP_CALENDAR |