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 |