GP_PAYGROUPPrompt Table: GP_PYGRP
CAL_IDOPRIDGP_CAL_OPR_VW(SQL View) |
Index Back |
|---|---|
View of CAL based on OPR PRFView of GP CALENDAR that limits the user to see CALENDARs for the country of their user profile (unless their profile is for "ALL Countries") |
| SELECT CAL.GP_PAYGROUP ,CAL.CAL_ID ,OP.OPRID , PE.PAY_ENTITY , PE.COUNTRY FROM PS_GP_CALENDAR CAL , PS_GP_PYGRP PG , PS_GP_OPR_RULE_PRF OP , PS_GP_PYENT PE WHERE CAL.GP_PAYGROUP=PG.GP_PAYGROUP AND PG.PAY_ENTITY=PE.PAY_ENTITY AND (PE.COUNTRY=OP.COUNTRY OR OP.USED_BY='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 |
| 3 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 5 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |