GPAU_MBRREF_TMP

#	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	GPAU_MEMBER_ID	Character(18)	VARCHAR2(18) NOT NULL	The Membership Group ID is required for the file generated by GPAU_RCPFILE.
4	GPAU_MBR_TYP	Character(1)	VARCHAR2(1) NOT NULL	GPAUS - Stores the superannuation membership type for an employee - usually Spouse or Employee. E=Employee Membership ID S=Spouse Membership ID
5	GPAU_COMSUPER_FUND	Character(1)	VARCHAR2(1) NOT NULL	GP AUS - Stores the ComSuper Fund name for Super Contribution reporting for Aus Public Service customers who need to report contributions in ComSuper file format. A=Public Sector Super Fund Accum C=Commonwealth Super Scheme P=Public Sector Super Fund
6	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
7	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
8	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
9	NAME_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Title Prompt Table: TITLE_TBL
10	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec Default Value: U
11	BIRTHDATE	Date(10)	DATE	Date of Birth
12	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
13	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
14	GPAU_DAYTIME_PHONE	Character(24)	VARCHAR2(24) NOT NULL	GPAUS - Daytime phone number for use in SuperEC processing.
15	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.
16	GPAU_TFN_STATUS	Character(2)	VARCHAR2(2) NOT NULL	This field will be used to identify whether an employee has supplied its TFN, deliberately not supplied the TFN, applying for TFN, under 18 years of age, pensioner, etc. 10=Applied For 20=Not Supplied 30=Under 18 Years 40=Full/Part Pensioner 50=Incorrect TFN Given 60=TFN Provided 70=TFN Not Required