GPAU_STP_TMPSS

#	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_INC_TYPE	Character(4)	VARCHAR2(4) NOT NULL	STP Income Types CHP=Closely Held Payees FEI=Foreign Employment IAA=Inbound Assignees to Australia LAB=Labour-Hire OSP=Other Specified Payments SAW=Salary and Wages SWP=Seasonal Worker Programme VOL=Voluntary Agreement WHM=Working Holiday Makers
13	GPAU_STP_CAT_3	Character(30)	VARCHAR2(30) NOT NULL	Category Information - Single Touch Payroll
14	GPAU_STP_SUB_CAT_3	Character(30)	VARCHAR2(30) NOT NULL	STP Sub-Category to maintain Key Structure
15	GPAU_STP_VERSION	Number(3,0)	SMALLINT NOT NULL	Version for STP Update Event Default Value: 0
16	GPAU_STP_SUB_CAT	Character(30)	VARCHAR2(30) NOT NULL	STP Sub-Category
17	USER_KEY1	Character(25)	VARCHAR2(25) NOT NULL	User Key 1
18	USER_KEY2	Character(25)	VARCHAR2(25) NOT NULL	User Key 2
19	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
20	PRD_END_DT	Date(10)	DATE	Pay Period End Date
21	PYMT_DT	Date(10)	DATE	Payment Date
22	GPAU_STP_S_CAT_DES	Character(40)	VARCHAR2(40) NOT NULL	STP Category Description
23	GPAU_STP_SS_CD	Character(25)	VARCHAR2(25) NOT NULL	Salary Sacrifice Code - Single Touch Payroll
24	GPAU_STP_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Amount of Iterative Categories - Single Touch Payroll
25	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
26	GPAU_STP_EVENT	Character(1)	VARCHAR2(1) NOT NULL	Event Type is used to determine if it is Update Event or Payee Override. P=Payee Override U=Update Event