CAL_RUN_IDPrompt Table: GPNL_PSLIP_R_VW
GP_PAYGROUPPrompt Table: GP_PYGRP
GPNL_PYGRP_VW(SQL View) |
Index Back |
|---|---|
Pay Group ViewGP Netherlands Pay Group View for Payslips messages |
| SELECT DISTINCT A.CAL_RUN_ID , B.GP_PAYGROUP FROM PS_GP_CAL_RUN A , PS_GP_CAL_RUN_DTL B ,PS_GP_OPR_RULE_PRF C WHERE A.CAL_RUN_ID = B.CAL_RUN_ID AND (A.RUN_FINALIZED_IND = 'Y' OR A.RUN_OPEN_IND = 'Y') AND (C.USED_BY = 'A' OR A.COUNTRY = C.COUNTRY) AND EXISTS ( SELECT 'X' FROM PS_GP_CAL_RUN_DTL DTL WHERE A.CAL_RUN_ID = DTL.CAL_RUN_ID AND DTL.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
Prompt Table: GPNL_PSLIP_R_VW |
| 2 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP |