GPAU_COMSUP_BD2

#	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_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
8	GPAU_TOTAL_MBR_CNT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPAUS - Stores the total reportable SuperEC contribution amount for an employee during the period for which SuperEC reporting has been run.
9	GPAU_COMSUP_ADCB	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Stores the Employer Additional Contribution for ComSuper
10	GPAU_COMSUP_BSCB	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Stores Employer Basic Contribution for comsuper
11	GPAU_COMSUP_SCCB	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Stores the Salary Sacrifice Contribution for ComSuper
12	GPAU_COMSUP_SHCB	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Stores the Employer Shortfall Contributio for ComSuper
13	GPAU_COMSUP_ADIC	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	GP AUS - Stores ComSuper specific Additional Death and Invalidity Cover (ADIC)