GP_PAYGROUPPrompt Table: GP_PYGRP
CAL_IDPrompt Table: GP_CAL_OPR_VW
GPMX_REV_VW(SQL View) |
Index Back |
|---|---|
Reversed Payees ViewReversed Payees View |
| SELECT A.GP_PAYGROUP , A.CAL_ID FROM PS_GPMX_REVERSAL 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 | 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_CAL_OPR_VW |