GPAU_STP_HR_STG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON_NAME
2	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.
3	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GP_PYENT_SGPAU
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group Prompt Table: GPAU_PYGRP_VW
5	GPAU_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Tax Year - End of Year Processing
6	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id Prompt Table: GPAU_UPD_CALRUN
7	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
8	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
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_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	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number Default Value: 0
15	GPAU_ABN	Character(11)	VARCHAR2(11) NOT NULL	A unique number used by the ATO to identify a contractor.
16	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
17	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
18	ADDRESS_150	Character(150)	VARCHAR2(150) NOT NULL	Preparer's Address
19	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
20	COUNTRY_2CHAR	Character(2)	VARCHAR2(2) NOT NULL	2-Char Country Code
21	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_AUS_VW
22	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
23	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
24	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type
25	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
26	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
27	DAY1	Number(2,0)	SMALLINT NOT NULL	Day 1
28	MONTH1	Number(2,0)	SMALLINT NOT NULL	Month 1
29	YEAR_DISPLAY	Number(4,0)	SMALLINT NOT NULL	Year Display
30	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
31	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
32	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
33	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
34	BIRTHDATE	Date(10)	DATE	Date of Birth
35	REHIRE_DT	Date(10)	DATE	Rehire Date
36	TERMINATION_DT	Date(10)	DATE	Termination Date
37	GPAU_CESSATION_TYP	Character(1)	VARCHAR2(1) NOT NULL	Cessation Type indicator C=Contract Cessation D=Deceased F=Dismissed I=Ill Health R=Redundancy T=Transfer V=Voluntary
38	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
39	PRD_END_DT	Date(10)	DATE	Pay Period End Date
40	GPAU_PAYMENT_BASIS	Character(2)	VARCHAR2(2) NOT NULL	This is the payee's basis of payment. It identiy whether the payment was made from full time, part time, casual, or labour hire employment, This field is part of the TFN Declaration form to be filled in by the employee. 10=Casual 20=Full Time 30=Labour Hire 40=Part Time 50=Pension/Annuity
41	GPAU_PREV_PAYID	Character(14)	VARCHAR2(14) NOT NULL	Previous Payroll Identifier - STP
42	GPAU_TAX_OFFSET	Signed Number(12,0)	DECIMAL(11) NOT NULL	Tax Offset - Single Touch Payroll
43	GPAU_HECS_YN	Character(1)	VARCHAR2(1) NOT NULL	Yes/No flag. This will identify if the payee should be paying HECS payments or not. Y/N Table Edit
44	GPAU_SFSS_YN	Character(1)	VARCHAR2(1) NOT NULL	Yes/No flag. This will identify if payee should be paying SFSS contributions or not. Y/N Table Edit
45	GPAU_TFN	Character(9)	VARCHAR2(9) NOT NULL	This is the payee's tax file number. This is the payee's unique identification number for tax purposes.
46	GPAU_TFN_SIGNED_DT	Date(10)	DATE	This is the date when the employee has signed the TFN Declaration Form.
47	GPAU_TFN_SIGNED_YN	Character(1)	VARCHAR2(1) NOT NULL	Yes/No flag. This will determine whether the payee has signed the TFN Declaration form that was submitted to the employer.
48	GPAU_RES_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payee residency status
49	GPAU_TXFRE_CLAIMED	Character(1)	VARCHAR2(1) NOT NULL	Tax free treshold claimed Y/N Table Edit
50	GPAU_TFN_TERM_IND	Character(1)	VARCHAR2(1) NOT NULL	Payee terminated indicator
51	GPAU_STP_FINAL_PAY	Character(1)	VARCHAR2(1) NOT NULL	Final Event Indicator - Single Touch Payroll A=All Payees N=Not Applicable T=Terminated Payees Y=Active Payees Y/N Table Edit
52	GPAU_TAX_SCALE	Character(3)	VARCHAR2(3) NOT NULL	This is used to identify the rates, thresholds, and other factors that will be used in the calculation of the payee's tax.
53	PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp
54	FINAL_PAY_CAL_RUN	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
55	OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Y/N Table Edit Default Value: N
56	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
57	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
58	GPAU_TAX_TRMT_CODE	Character(6)	VARCHAR2(6) NOT NULL	Tax Treatment Code - Single Touch Payroll
59	GPAU_SPOUSE_YN	Character(1)	VARCHAR2(1) NOT NULL	Yes/No flag. This will identify if the payee is claiming medicare levy exemptions only for his/her spouse.
60	GPAU_NOOF_DPNDNTS	Number(2,0)	SMALLINT NOT NULL	This is the number of dependents that will affect the payee's medicare levy adjustments
61	GPAU_MED_LEV_SRCHG	Character(1)	VARCHAR2(1) NOT NULL	Yes/No flag. This will identify if the payee is claiming medicare levy exemptions only for his/her spouse. 1=1 2=2 3=3
62	PYMT_DT	Date(10)	DATE	Payment Date