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 | GPAU_STP_RPT | Character(30) | VARCHAR2(30) NOT NULL |
STP Report Values
1=PAYEVNT 2=PAYEVNTEMP 3=ALL |
2 | EFFDT | Date(10) | DATE | Effective Date |
3 | GPAU_STP_IS_CAT | Character(30) | VARCHAR2(30) NOT NULL | Category Information - Single Touch Payroll |
4 | GPAU_STP_SUB_CAT | Character(30) | VARCHAR2(30) NOT NULL | STP Sub-Category |
5 | GPAU_STP_S_CAT_DES | Character(40) | VARCHAR2(40) NOT NULL | STP Category Description |
6 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
7 | PIN_NUM | 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 |