GPAU_STP_RPT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
3	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
4	SOVR_VAL_CHAR	Character(25)	VARCHAR2(25) NOT NULL	Supporting Element Character Value
5	PIN_SOVR_NUM	Number(8,0)	INTEGER NOT NULL	Supporting Element PIN Number
6	PIN_MBR_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
7	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
8	BGN_DT	Date(10)	DATE	Begin Date
9	END_DT	Date(10)	DATE	end date
10	GPAU_STP_CAT	Character(30)	VARCHAR2(30) NOT NULL	Category Information - Single Touch Payroll
11	GPAU_STP_SUB_CAT	Character(30)	VARCHAR2(30) NOT NULL	STP Sub-Category
12	GPAU_STP_SUB_CAT_1	Character(30)	VARCHAR2(30) NOT NULL	STP Sub-Category to maintain Key Structure
13	GPAU_STP_S_CAT_DES	Character(40)	VARCHAR2(40) NOT NULL	STP Category Description
14	ACM_SIGN	Character(1)	VARCHAR2(1) NOT NULL	Accumulator Sign A=Add S=Subtract
15	BEGIN_DT	Date(10)	DATE	Begin Date
16	END_DATE	Date(10)	DATE	End Date
17	ACM_PRD_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Accumulator Period 1=Segment 2=Calendar Period 3=Month to Date 4=Quarter to Date 5=Year to Date 6=Custom Period
18	GPAU_ETP_PY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ETP Payment Type. N=Non Transitional O=Non-Excluded ETP R=Excluded ETP T=Transitional