GPUS_RPT_SETUP(SQL Table) |
Index Back |
|---|---|
Payroll Report SetupPayroll Report Setup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PRCSJOBNAME |
Character(8) | VARCHAR2(8) NOT NULL |
Process Job Name
Prompt Table: PRCSJOBDEFN |
| 2 | PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL | Process Type |
| 3 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: USA |
| 4 | GP_RPT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Extraction Process Name
Prompt Table: GP_RPT_TBL |
| 5 | GP_ELN_APP | Character(15) | VARCHAR2(15) NOT NULL |
ELN Application
Prompt Table: GP_ELN_APP_SRCH |
| 6 | GP_ELN_SET | Character(15) | VARCHAR2(15) NOT NULL |
Element Set
Prompt Table: GP_ELN_SET_SRCH |
| 7 | GPUS_JURISDICT_TYP | Character(2) | VARCHAR2(2) NOT NULL |
Jurisdiction Type
01=All States 02=Federal 03=State 04=Territories Default Value: 01 |
| 8 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: GPUS_STATE_VW |
| 9 | GPUS_PSLP_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Payslip Temporary Table Name
Prompt Table: PSRECDEFN |