GPAU_SUPCON_TMP (SQL Table)	Index Back
GPAU - SuperEC Gross Fund Amt This temporary table stores the Gross Fund amount for a SuperFund for the current SuperEC period being processed. The details are then written to the SuperEC message file.

GPAU_SUPCON_TMP

(SQL Table)

GPAU - SuperEC Gross Fund Amt

This temporary table stores the Gross Fund amount for a SuperFund for the current SuperEC period being processed. The details are then written to the SuperEC message file.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

3 DATE_FROM Date(10) DATE Date From

4 DATE_TO Date(10) DATE Previous Period Date To

5 GPAU_GROSSFUND_AMT Number(16,2) DECIMAL(15,2) NOT NULL GPAUS - Used to store the Gross Superannuation Payment amount for the SuperEC (Superannuation Reporting) period being processed.

6 GPAU_DIFF_REASON Character(10) VARCHAR2(10) NOT NULL GPAUS - If there is a difference between the net and gross contributions amounts reported as part of SuperEC processing, this field will store text to explain the reason for the difference.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
3	DATE_FROM	Date(10)	DATE	Date From
4	DATE_TO	Date(10)	DATE	Previous Period Date To
5	GPAU_GROSSFUND_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	GPAUS - Used to store the Gross Superannuation Payment amount for the SuperEC (Superannuation Reporting) period being processed.
6	GPAU_DIFF_REASON	Character(10)	VARCHAR2(10) NOT NULL	GPAUS - If there is a difference between the net and gross contributions amounts reported as part of SuperEC processing, this field will store text to explain the reason for the difference.