CAL_RUN_IDGP_PAYGROUPPrompt Table: GP_PYGRP
CAL_IDPrompt Table: GP_CALENDAR
GP_CALENDAR3_VW(SQL View) |
Index Back |
|---|---|
Payroll Calendars in RUN DTLView Payroll Calendars |
| SELECT DISTINCT A.CAL_RUN_ID , B.GP_PAYGROUP , B.CAL_ID FROM PS_GP_CAL_RUN_DTL A , PS_GP_CALENDAR B , PS_GP_RUN_TYPE C WHERE A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID = B.CAL_ID AND B.RUN_TYPE = C.RUN_TYPE AND C.CALC_TYPE = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP |
| 3 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL |
calendar id
Prompt Table: GP_CALENDAR |