GPAU_RECPNT_TMP (SQL Table)	Index Back
Temporary Recipient Table Stores details for all deduction recipients that are to be processed as part of the Super Reporting process for GP AUS.

GPAU_RECPNT_TMP

(SQL Table)

Temporary Recipient Table

Stores details for all deduction recipients that are to be processed as part of the Super Reporting process for GP AUS.

# 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 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 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

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

#	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	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	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
5	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity