GPAU_SUPMBR_TMP (SQL Table)	Index Back
GPAU - SuperEC Super Mem dtls This temporary table stores Super Membership details for each employee involved in SuperEC processing, including status. The details are written out to the SuperEC message file.

GPAU_SUPMBR_TMP

(SQL Table)

GPAU - SuperEC Super Mem dtls

This temporary table stores Super Membership details for each employee involved in SuperEC processing, including status. The details are written out 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Default Value: 0

5 NAME Character(50) VARCHAR2(50) NOT NULL Name

6 GPAU_MEMBER_ID Character(18) VARCHAR2(18) NOT NULL The Membership Group ID is required for the file generated by GPAU_RCPFILE.

7 GPAU_MBR_TYP Character(1) VARCHAR2(1) NOT NULL GPAUS - Stores the superannuation membership type for an employee - usually Spouse or Employee.
E=Employee Membership ID
S=Spouse Membership ID

8 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

9 GPAU_STATUS_CODE Character(10) VARCHAR2(10) NOT NULL GPAUS - Used to indicate the status of the super fund member being reported as part of SuperEC processing, e.g., NEW, CHANGED, etc

10 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

#	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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Default Value: 0
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	GPAU_MEMBER_ID	Character(18)	VARCHAR2(18) NOT NULL	The Membership Group ID is required for the file generated by GPAU_RCPFILE.
7	GPAU_MBR_TYP	Character(1)	VARCHAR2(1) NOT NULL	GPAUS - Stores the superannuation membership type for an employee - usually Spouse or Employee. E=Employee Membership ID S=Spouse Membership ID
8	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
9	GPAU_STATUS_CODE	Character(10)	VARCHAR2(10) NOT NULL	GPAUS - Used to indicate the status of the super fund member being reported as part of SuperEC processing, e.g., NEW, CHANGED, etc
10	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date