GPAU_COMSUP_BD1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GPAU_COMSUPR_AGCY	Character(20)	VARCHAR2(20) NOT NULL	GPAUS - Stores the Scheme ID for ComSuper Employees - CSS or PSS.
3	GPAU_PAY_RUN_NBR	Number(8,0)	INTEGER NOT NULL	This is the Payroll run number for com-super
4	END_DATE	Date(10)	DATE	End Date
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	GPAU_MEMBER_ID	Character(18)	VARCHAR2(18) NOT NULL	The Membership Group ID is required for the file generated by GPAU_RCPFILE.
7	GPAU_COMSUP_SCM_ID	Character(5)	VARCHAR2(5) NOT NULL	Stores the scheme ID for ComSuper
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
9	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
10	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
11	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
12	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
13	GPAU_PREVIOUS_NAME	Character(30)	VARCHAR2(30) NOT NULL	This stores the Previous Name for an employee and is used by
14	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
15	GPAU_COMSUP_PYCENT	Character(10)	VARCHAR2(10) NOT NULL	Stores the Paycentre Number. This is the GP PAYGROUP
16	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.
17	DATE_OF_BIRTH	Date(10)	DATE	Date of Birth
18	GPAU_EMPL_START_DT	Date(10)	DATE	Stores the Employment Start Date for ComSuper
19	GPAU_SCH_COM_DT	Date(10)	DATE	Stores the scheme Commencement Date for ComSuper