GPAU_STP_ALLOW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
4	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
5	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
6	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
7	EMPLID_BGRP	Character(14)	VARCHAR2(14) NOT NULL	Emplid
8	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
9	GPAU_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Tax Year - End of Year Processing
10	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.
11	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
12	GPAU_STP_VERSION	Number(3,0)	SMALLINT NOT NULL	Version for STP Update Event Default Value: 0
13	GPAU_STP_UPDEVT_DT	Date(10)	DATE	Update Event Date
14	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
15	GPAU_STP_CAT	Character(30)	VARCHAR2(30) NOT NULL	Category Information - Single Touch Payroll
16	GPAU_STP_SUB_CAT_1	Character(30)	VARCHAR2(30) NOT NULL	STP Sub-Category to maintain Key Structure Prompt Table: GPAU_STP_SUB_VW
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	GPAU_STP_SUB_CAT	Character(30)	VARCHAR2(30) NOT NULL	STP Sub-Category
20	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
21	PRD_END_DT	Date(10)	DATE	Pay Period End Date
22	PYMT_DT	Date(10)	DATE	Payment Date
23	GPAU_STP_S_CAT_DES	Character(40)	VARCHAR2(40) NOT NULL	STP Category Description
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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
27	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
28	PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp