GP_PAYGROUPPrompt Table: GP_PYGRP
CAL_IDPrompt Table: GP_CALENDAR
GP_CALENDAR2_VW(SQL View) |
Index Back |
|---|---|
All Absence CalendarsAll Absence Calendars Processed or NOT |
| SELECT CAL.GP_PAYGROUP , CAL.CAL_ID FROM PS_GP_CALENDAR CAL , PS_GP_RUN_TYPE RT WHERE CAL.RUN_TYPE = RT.RUN_TYPE AND RT.CALC_TYPE='A' |
| # | 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 |