GPAU_SUPEC_TRAN (SQL Table)	Index Back
GPAU - SuperEC Trans Details This record is created by the SuperEC Process each time a message file is created. It contains information related to the payment.

GPAU_SUPEC_TRAN

(SQL Table)

GPAU - SuperEC Trans Details

This record is created by the SuperEC Process each time a message file is created. It contains information related to the payment.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID

2 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

3 DATE_FROM Date(10) DATE Date From

4 DATE_TO Date(10) DATE Previous Period Date To

5 GPAU_PAYREFNUM Character(18) VARCHAR2(18) NOT NULL GPAU - Payment reference number used in SuperEC processing.

6 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.

7 GPAU_INTERCHANGEID Character(30) VARCHAR2(30) NOT NULL GPAUS - Used as an identifier on a SuperEC message file.

8 GPAU_SENDTRANSDATE DateTime(26) TIMESTAMP GPAUS - Unique reference used in SuperEC processing to identify the message file to the receiver and the sender.

9 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.

10 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.
Y/N Table Edit
Default Value: N

11 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.
Y/N Table Edit
Default Value: N

12 GPAU_PYMNT_AMT Number(16,2) DECIMAL(15,2) NOT NULL GPAUS - Used to store the payment amount of Super Contributions made to a Super Fund Administrator in the period for which SuperEC reporting is being undertaken.

13 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.

14 GPAU_TESTINDICATOR Character(1) VARCHAR2(1) NOT NULL GPAUS - Indicates if a SuperEC message file is a test file only. Used in SuperEC processing.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
2	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
3	DATE_FROM	Date(10)	DATE	Date From
4	DATE_TO	Date(10)	DATE	Previous Period Date To
5	GPAU_PAYREFNUM	Character(18)	VARCHAR2(18) NOT NULL	GPAU - Payment reference number used in SuperEC processing.
6	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.
7	GPAU_INTERCHANGEID	Character(30)	VARCHAR2(30) NOT NULL	GPAUS - Used as an identifier on a SuperEC message file.
8	GPAU_SENDTRANSDATE	DateTime(26)	TIMESTAMP	GPAUS - Unique reference used in SuperEC processing to identify the message file to the receiver and the sender.
9	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.
10	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. Y/N Table Edit Default Value: N
11	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. Y/N Table Edit Default Value: N
12	GPAU_PYMNT_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	GPAUS - Used to store the payment amount of Super Contributions made to a Super Fund Administrator in the period for which SuperEC reporting is being undertaken.
13	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.
14	GPAU_TESTINDICATOR	Character(1)	VARCHAR2(1) NOT NULL	GPAUS - Indicates if a SuperEC message file is a test file only. Used in SuperEC processing.