GPAU_COMSUP_CCD

#	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_RCTYP	Character(4)	VARCHAR2(4) NOT NULL	GPAUS - Store the ComSuper record type for the ComSuper CCD file.
3	GPAU_COMSUPR_AGCY	Character(20)	VARCHAR2(20) NOT NULL	GPAUS - Stores the Scheme ID for ComSuper Employees - CSS or PSS.
4	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
5	END_DATE	Date(10)	DATE	End Date
6	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
7	GPAU_MEMBER_ID	Character(18)	VARCHAR2(18) NOT NULL	The Membership Group ID is required for the file generated by GPAU_RCPFILE.
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
10	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
11	GPAU_CONTACT_GV_NM	Character(45)	VARCHAR2(45) NOT NULL	Given contact name
12	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.
13	GPAU_COMSUP_EPSC	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	GP AUS - Stores ComSuper specific Employer Productivity Superannuation Contributions (EPSC)
14	GPAU_COMSUP_ADIC	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	GP AUS - Stores ComSuper specific Additional Death and Invalidity Cover (ADIC)