GPAU_STP_HR_WA

#	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	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
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_ABN	Character(11)	VARCHAR2(11) NOT NULL	A unique number used by the ATO to identify a contractor.
12	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
13	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
14	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
15	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
16	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
17	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
18	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type
19	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
20	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
21	DAY1	Number(2,0)	SMALLINT NOT NULL	Day 1
22	MONTH	Number(2,0)	SMALLINT NOT NULL	Month
23	YEAR_DISPLAY	Number(4,0)	SMALLINT NOT NULL	Year Display
24	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
25	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
26	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
27	BIRTHDATE	Date(10)	DATE	Date of Birth
28	REHIRE_DT	Date(10)	DATE	Rehire Date
29	TERMINATION_DT	Date(10)	DATE	Termination Date
30	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
31	PRD_END_DT	Date(10)	DATE	Pay Period End Date
32	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
33	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.
34	GPAU_SFSS_YN	Character(1)	VARCHAR2(1) NOT NULL	Yes/No flag. This will identify if payee should be paying SFSS contributions or not.
35	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.
36	GPAU_TFN_DECL_DT	Character(1)	VARCHAR2(1) NOT NULL	Date declaration signed by Payee
37	GPAU_PAYEE_SIGN	Character(1)	VARCHAR2(1) NOT NULL	Payee signature present
38	GPAU_RES_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payee residency status
39	GPAU_TXFRE_CLAIMED	Character(1)	VARCHAR2(1) NOT NULL	Tax free treshold claimed
40	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.