GP_PAYGROUPPrompt Table: GP_PYGRP
CAL_IDPrompt Table: GP_PAY_CAL_VW
GP_PI_CAL_VW(SQL View) |
Index Back |
|---|---|
Componetnt search record PISearch record for Posisitve INput by Calendar. |
| SELECT C.GP_PAYGROUP ,C.CAL_ID ,PRD.PRD_BGN_DT ,PRD.PRD_END_DT ,OP.OPRID , PE.PAY_ENTITY , PE.COUNTRY FROM PS_GP_CALENDAR C , PS_GP_PYGRP PG , PS_GP_OPR_RULE_PRF OP , PS_GP_PYENT PE , PS_GP_CAL_PRD PRD , PS_GP_RUN_TYPE R WHERE C.GP_PAYGROUP=PG.GP_PAYGROUP AND PG.PAY_ENTITY=PE.PAY_ENTITY AND C.RUN_TYPE=R.RUN_TYPE AND R.CALC_TYPE='P' AND C.CAL_PRD_ID=PRD.CAL_PRD_ID 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
Prompt Table: GP_PAY_CAL_VW |
| 3 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 4 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 7 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |