GPAU_STP_R_SRCT(SQL Table) |
Index Back |
|---|---|
SOVR Mapping in Category SetupSOVR Element Mapping in STP Reconciliation Category Setup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL |
STP Report Values
1=PAYEVNT 2=PAYEVNTEMP 3=ALL |
|
| 2 | Date(10) | DATE | Effective Date | |
| 3 | Character(30) | VARCHAR2(30) NOT NULL | Category Information - Single Touch Payroll | |
| 4 | Character(30) | VARCHAR2(30) NOT NULL | STP Sub-Category | |
| 5 | Character(40) | VARCHAR2(40) NOT NULL | STP Category Description | |
| 6 | Number(3,0) | SMALLINT NOT NULL | Sequence | |
| 7 | Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: GPAU_STP_RPN_VW |
|
| 8 | ACM_SIGN | Character(1) | VARCHAR2(1) NOT NULL |
Accumulator Sign
A=Add S=Subtract Default Value: A |
| 9 | GP_RECELEM_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Element Type
DD=Deductions ER=Earnings |