GPAU_MCOINF_TMP (SQL Table)	Index Back
GPAU - SuperEC Mem Contrib Dtl This temporary table stores contribution info for the member for the period being processed prior to writing the details out to the SuperEC message file.

GPAU_MCOINF_TMP

(SQL Table)

GPAU - SuperEC Mem Contrib Dtl

This temporary table stores contribution info for the member for the period being processed 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 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID

3 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
Prompt Table: PAYGROUP_TBL

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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_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

8 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

9 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

10 BIRTHDATE Date(10) DATE Date of Birth

11 GPAU_TOTAL_MBR_CNT Signed Number(20,6) DECIMAL(18,6) NOT NULL GPAUS - Stores the total reportable SuperEC contribution amount for an employee during the period for which SuperEC reporting has been run.

12 START_DATE Date(10) DATE Start Date for Gen Standing PO

13 END_DATE Date(10) DATE End Date

14 GPAU_CONTCHNG_STAT Character(15) VARCHAR2(15) NOT NULL GPAUS - Stores the contribution status code for an employee during 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	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
3	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group Prompt Table: PAYGROUP_TBL
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
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_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
8	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
9	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
10	BIRTHDATE	Date(10)	DATE	Date of Birth
11	GPAU_TOTAL_MBR_CNT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPAUS - Stores the total reportable SuperEC contribution amount for an employee during the period for which SuperEC reporting has been run.
12	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
13	END_DATE	Date(10)	DATE	End Date
14	GPAU_CONTCHNG_STAT	Character(15)	VARCHAR2(15) NOT NULL	GPAUS - Stores the contribution status code for an employee during SuperEC processing