GPAU_STP_TMPDED

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
5	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
8	BALANCE_GRP_NUM	Character(3)	VARCHAR2(3) NOT NULL	This field will be used to determine the grouping of balances from the different jobs of the employee.
9	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
10	EMPLID_BGRP	Character(14)	VARCHAR2(14) NOT NULL	Emplid
11	GPAU_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Tax Year - End of Year Processing
12	GPAU_STP_CAT_6	Character(30)	VARCHAR2(30) NOT NULL	Category Information - Single Touch Payroll
13	GPAU_STP_SUB_CAT_6	Character(30)	VARCHAR2(30) NOT NULL	STP Sub-Category to maintain Key Structure
14	GPAU_STP_VERSION	Number(3,0)	SMALLINT NOT NULL	Version for STP Update Event
15	USER_KEY1	Character(25)	VARCHAR2(25) NOT NULL	User Key 1
16	USER_KEY2	Character(25)	VARCHAR2(25) NOT NULL	User Key 2
17	GPAU_STP_SUB_CAT	Character(30)	VARCHAR2(30) NOT NULL	STP Sub-Category
18	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
19	PRD_END_DT	Date(10)	DATE	Pay Period End Date
20	PYMT_DT	Date(10)	DATE	Payment Date
21	GPAU_STP_S_CAT_DES	Character(40)	VARCHAR2(40) NOT NULL	STP Category Description
22	GPAU_STP_DED_CD	Character(25)	VARCHAR2(25) NOT NULL	Supporting Element Character Value
23	GPAU_STP_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Amount of Iterative Categories - Single Touch Payroll
24	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