OPRIDPrompt Table: GP_WC_LISTID_VW
Prompt Table: GP_WC_OPRPYG_DV
GP_WC_PYRL_STG(SQL Table) |
Index Back |
|---|---|
Work Centre Payroll SettingsWork Centre Payroll Settings |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | PTAI_LIST_ID | Character(31) | VARCHAR2(31) NOT NULL |
Action Items - Action Item List ID
Prompt Table: GP_WC_LISTID_VW |
| 3 | GP_WC_HIST_PRDS | Number(3,0) | SMALLINT NOT NULL | days in a period |
| 4 | GP_WC_CLD_GRP_SEL | Character(4) | VARCHAR2(4) NOT NULL | Calendar Group for work centre |
| 5 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_WC_OPRPYG_DV |