GP_PAYGROUPPrompt Table: GP_PYGRP
CAL_IDGP_CALENDAR9_VW(SQL View) |
Index Back |
|---|---|
Calendars that are calculatedView of calendars that are included in a calendar run that has been calculated. Used when prompting for results component |
| SELECT DISTINCT GP_PAYGROUP , CAL_ID FROM PS_GP_CAL_RUN_DTL WHERE CAL_RUN_ID IN ( SELECT CAL_RUN_ID FROM PS_GP_CAL_RUN_STRM WHERE STRM_IDNT_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 |