GPAU_STP_R_SRCT

(SQL Table)
Index Back

SOVR Mapping in Category Setup

SOVR 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