GPAU_SS_RPT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
5	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
6	GPAU_LODGEMENT_REF	Character(50)	VARCHAR2(50) NOT NULL	This field is used in the AE program GPAU_EFT_CMX.
7	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
8	GPAU_REP_DATE	Date(10)	DATE	Report End Date
9	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
10	GPAU_NEW	Character(1)	VARCHAR2(1) NOT NULL	New Default Value: N
11	GPAU_SENDERID	Character(30)	VARCHAR2(30) NOT NULL	GPAUS - Stores the ID of the Sender for SuperEC processing.
12	GPAU_RECEIVERID	Character(30)	VARCHAR2(30) NOT NULL	GPAUS - Stores the ID of the Super Fund Administrator that is to receive a SuperEC message file.
13	GPAU_PAYERID	Character(9)	VARCHAR2(9) NOT NULL	Payer ID
14	GPAU_PAYEEID	Character(20)	VARCHAR2(20) NOT NULL	Payee ID
15	GPAU_SMART_KEY	Character(90)	VARCHAR2(90) NOT NULL	Primary Key used in SuperStream reporting
16	GPAU_ER_ABN	Character(11)	VARCHAR2(11) NOT NULL	Employer ABN
17	GPAU_SFUND_ABN	Number(11,0)	DECIMAL(11) NOT NULL	Super Fund ABN
18	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.
19	GPAU_NO_TFN_ID	Character(25)	VARCHAR2(25) NOT NULL	Alternate ID when TFN is not availables
20	NAME_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Title
21	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix
22	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
23	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
24	PERSON_NAME	Character(100)	VARCHAR2(100) NOT NULL	Name
25	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
26	BIRTHDATE	Date(10)	DATE	Date of Birth
27	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
28	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
29	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
30	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
31	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
32	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
33	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
34	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
35	EMAIL_ADDR2	Character(70)	VARCHAR2(70) NOT NULL	Email Address
36	GPAU_PH_SERVICE	Character(2)	VARCHAR2(2) NOT NULL	Phone Service line used in SuperStream reporting
37	PHONE1	Character(24)	VARCHAR2(24) NOT NULL	Phone number field for discounts and perks eligibility file.
38	GPAU_TFN_DISCLOSE	Character(1)	VARCHAR2(1) NOT NULL	This will determine whether the payee has given the payer an authority to disclose its TFN to the Superannuation Funds.
39	GPAU_MEMBER_ID	Character(18)	VARCHAR2(18) NOT NULL	The Membership Group ID is required for the file generated by GPAU_RCPFILE.
40	EMPLID_PAYEE	Character(11)	VARCHAR2(11) NOT NULL	Payee EmplID
41	GPAU_DT_END_CAT	Date(10)	DATE	Scheme cease date
42	GPAU_FUNDEXITRSN	Character(4)	VARCHAR2(4) NOT NULL	Stores the reason for a member or spouse's exit from a Super Fund. Used in GPAUS SuperEC processing CH=Changed DT=Death IN=Invalidity WD=Withdrawal
43	PERIOD_BEGIN_DT	Date(10)	DATE	Period Begin Date
44	PERIOD_END_DATE	Date(10)	DATE	Period End Date
45	GPAU_DT_JOINED_CAT	Date(10)	DATE	GPAUS - stores the date that an employee joined the category of the Super Fund to which the employee belongs. Used in SuperEC processing.
46	GPAU_SUPER_BEN_AMT	Number(19,3)	DECIMAL(18,3) NOT NULL	Benefit amount
47	GPAU_YRLY_INS_SAL	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Salary insurance amount
48	GPAU_SUPEC_SAL	Number(19,3)	DECIMAL(18,3) NOT NULL	GPAUS - SuperEC Salary field. This field stores Annual or Superannuation Salary amoutn for employees enrolled in SuperEC.
49	GPAU_RPT_START_DT	Date(10)	DATE	Period of report Start Date
50	GPAU_RPT_END_DT	Date(10)	DATE	Period of report end date
51	GPAU_FUND_REG_DT	Date(10)	DATE	Fund Registration Date
52	GPAU_INS_OPT_OUT	Character(1)	VARCHAR2(1) NOT NULL	Indicates if the employee does not want the Super Fund to provide an Insurance product to them.
53	GPAU_FUND_BEN_CATG	Character(25)	VARCHAR2(25) NOT NULL	Benefit Category used in SuperStream reporting
54	GPAU_AMEND_RSN	Character(25)	VARCHAR2(25) NOT NULL	SuperStream reporting data amendment reason
55	JOB_CLASS	Character(10)	VARCHAR2(10) NOT NULL	Job Class for discounts and perks eligibility file.
56	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
57	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
58	OCCUPATION	Character(40)	VARCHAR2(40) NOT NULL	Occup
59	GPAU_SUPER_ST_DT	Date(10)	DATE	Report period start date
60	GPAU_SUPER_END_DT	Date(10)	DATE	Report period end date
61	GPAU_SGC_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Super Gurantee amount
62	GPAU_AWARD_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Award/Productivity amount
63	GPAU_PERS_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Personal Contributions Amount
64	GPAU_SACRIFICE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Salary Sacrificed contribution
65	GPAU_VOLUNTARY_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Voluntary contribution amount
66	GPAU_SPOUSE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Spouse contribution amount
67	GPAU_CHILD_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Child contributions amount
68	GPAU_THRDPARTY_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Third party contribution amount
69	GPAU_OTHER_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Other Contributions
70	TERMINATION_DT	Date(10)	DATE	Termination Date
71	HIRE_DT	Date(10)	DATE	First Start Date