GPAU_SUPER_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
6	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
7	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
8	DATE_FROM	Date(10)	DATE	Date From
9	DATE_TO	Date(10)	DATE	Previous Period Date To
10	GPAU_SENDTRANSDATE	DateTime(26)	TIMESTAMP	GPAUS - Unique reference used in SuperEC processing to identify the message file to the receiver and the sender.
11	GPAU_PAYREFNUM	Character(18)	VARCHAR2(18) NOT NULL	GPAU - Payment reference number used in SuperEC processing.
12	GPAU_ACKREQUEST	Character(1)	VARCHAR2(1) NOT NULL	GPAUS - Indicator for SuperEC processing. When checked it means that the sender wishes to receive an acknowledgement after a SuperEC message file is sent.
13	GPAU_TESTINDICATOR	Character(1)	VARCHAR2(1) NOT NULL	GPAUS - Indicates if a SuperEC message file is a test file only. Used in SuperEC processing.
14	GPAU_SNDRTRANSFUNC	Character(1)	VARCHAR2(1) NOT NULL	GPAUS - Flag to indicate if the SuperEC message file to be created is a replacement for a file with errors.
15	GPAU_SNDRPRVTRNMSG	Number(15,0)	DECIMAL(15) NOT NULL	GPAUS - used to indicate that a SuperEC file is a replacement for a previous file that had errors.
16	GPAU_DUPLICATE_IND	Character(1)	VARCHAR2(1) NOT NULL	GPAUS - In SuperEC processing, when this field is checked it indicates to the receiver of the SuperEC message file that the file is a replacement for one that was previously lost.
17	GPAU_INTERCHANGEID	Character(30)	VARCHAR2(30) NOT NULL	GPAUS - Used as an identifier on a SuperEC message file.
18	GPAU_SENDTRANSREF	Number(15,0)	DECIMAL(15) NOT NULL	GPAUS - Unique reference used in SuperEC processing to identify the SuperEC message file to both the sender and receiver.
19	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter
20	GPAU_SUPEREC_FMT	Character(1)	VARCHAR2(1) NOT NULL	This flag indicates whether a GP AUS Superannuation reporting file should be produced in SuperEC (XML) or ComSuper (flat text) format. This depends on the Super Fund that is being reported to. If the Super Fund is ComSuper, the file format should be the ComSuper file format. For all other Superannuation Fund, the format should be SuperEC format. A=Agest C=ComSuper File Format D=SuperStream File Format S=SuperEC File Format
21	GPAU_COMSUPR_RCTYP	Character(4)	VARCHAR2(4) NOT NULL	GPAUS - Store the ComSuper record type for the ComSuper CCD file.
22	GPAU_COMSUPS_RCTYP	Character(4)	VARCHAR2(4) NOT NULL	GPAUS - Stores the ComSuper record type value for the SED file.
23	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
24	GPAU_MEMBER_ID	Character(18)	VARCHAR2(18) NOT NULL	The Membership Group ID is required for the file generated by GPAU_RCPFILE.
25	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
26	GPAU_CONTACT_GV_NM	Character(45)	VARCHAR2(45) NOT NULL	Given contact name
27	STD_HRS_DEFAULT	Number(7,2)	DECIMAL(6,2) NOT NULL	Default Standard Hours
28	PYMT_DT	Date(10)	DATE	Payment Date