GPAU_MBRINS_TMP (SQL Table)	Index Back
GPAU - SuperEC Insurance Dtls This temporary table stores Insurance details of the member prior to writing the details out to the SuperEC message file.

GPAU_MBRINS_TMP

(SQL Table)

GPAU - SuperEC Insurance Dtls

This temporary table stores Insurance 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_INSURANCETYP Character(2) VARCHAR2(2) NOT NULL GPAUS - Stores the type of insurance that an employee has with their SuperFund.
DO=Death Only
DT=Death/TPD
N=None

5 GPAU_SCIFLAG Character(1) VARCHAR2(1) NOT NULL GPAUS - Indicates whether or not an employee has SCI (Salary Continuance Insurance) cover. Is reported to an Employee's Super Fund during SuperEC processing.
N=No
Y=Yes

#	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_INSURANCETYP	Character(2)	VARCHAR2(2) NOT NULL	GPAUS - Stores the type of insurance that an employee has with their SuperFund. DO=Death Only DT=Death/TPD N=None
5	GPAU_SCIFLAG	Character(1)	VARCHAR2(1) NOT NULL	GPAUS - Indicates whether or not an employee has SCI (Salary Continuance Insurance) cover. Is reported to an Employee's Super Fund during SuperEC processing. N=No Y=Yes