GPAU_MBRCAT_TMP (SQL Table)	Index Back
GPAU - SuperEC Categoy Details This temporary table stores the category details of the member prior to writing the details out to the SuperEC message file.

GPAU_MBRCAT_TMP

(SQL Table)

GPAU - SuperEC Categoy Details

This temporary table stores the category details of the member prior to writing the details 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

4 GPAU_CATEGORYID Character(15) VARCHAR2(15) NOT NULL GPAUS - Stores the Superannaution Fund Category ID for an employee. Used in SuperEC processing.

5 GPAU_DT_JOINED_CAT Date(10) DATE GPAUS - stores the date that an employee joined the category of the Super Fund to which the employee belongs. Used in SuperEC processing.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	GPAU_MEMBER_ID	Character(18)	VARCHAR2(18) NOT NULL	The Membership Group ID is required for the file generated by GPAU_RCPFILE.
4	GPAU_CATEGORYID	Character(15)	VARCHAR2(15) NOT NULL	GPAUS - Stores the Superannaution Fund Category ID for an employee. Used in SuperEC processing.
5	GPAU_DT_JOINED_CAT	Date(10)	DATE	GPAUS - stores the date that an employee joined the category of the Super Fund to which the employee belongs. Used in SuperEC processing.