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

GPAU_MBREMP_TMP

(SQL Table)

GPAU- SuperEC Employment Dtls

This temporary table stores the employment 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_SALARY_TYPE Character(4) VARCHAR2(4) NOT NULL GPAUS - Stores the Salary Type for the employee for Super EC reporting purposes.
AS=Annual Salary
SS=Superannuation Salary

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

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

6 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

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 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

9 JOB_ENTRY_DT Date(10) DATE Job Entry Date

10 GPAU_DATEJOINEDPC Date(10) DATE GPAU SuperEC Processing - stores the date the employee joined their pay centre (paygroup).

11 GPAU_MBR_PC_STATUS Character(1) VARCHAR2(1) NOT NULL Member PC Status Code

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

13 EMPLOYMENT_CODE Character(2) VARCHAR2(2) NOT NULL Employment Code
11=Placement Agency-Self-Employed
12=Taxi Driver/Psgr-Carry Vehicle
13=Barber or Hairdresser
14=Withdrawal-Deferred Salary Pln
15=Seasonal Agricultural Wrkr Pgm
16=Detached EE-Soc Sec Agreement
17=Fisher

14 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
Default Value: INSTALLATION.STD_HRS_DEFAULT

15 GPAU_OCCUPATION Character(15) VARCHAR2(15) NOT NULL GPAUS - Stores a text format occupation identifier for an employee who is part of SuperEC processing.

16 GPAU_SALARY_AMOUNT Number(19,6) DECIMAL(18,6) NOT NULL GPAUS - Stores the Salary Amount for an employee during SuperEC processing.

17 GPAU_SALARY_EFFDT Date(10) DATE GPAUS - Stores the date at which the current Salary for the employee became effective. 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_SALARY_TYPE	Character(4)	VARCHAR2(4) NOT NULL	GPAUS - Stores the Salary Type for the employee for Super EC reporting purposes. AS=Annual Salary SS=Superannuation Salary
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	GPAU_MEMBER_ID	Character(18)	VARCHAR2(18) NOT NULL	The Membership Group ID is required for the file generated by GPAU_RCPFILE.
6	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
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	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
9	JOB_ENTRY_DT	Date(10)	DATE	Job Entry Date
10	GPAU_DATEJOINEDPC	Date(10)	DATE	GPAU SuperEC Processing - stores the date the employee joined their pay centre (paygroup).
11	GPAU_MBR_PC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Member PC Status Code
12	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
13	EMPLOYMENT_CODE	Character(2)	VARCHAR2(2) NOT NULL	Employment Code 11=Placement Agency-Self-Employed 12=Taxi Driver/Psgr-Carry Vehicle 13=Barber or Hairdresser 14=Withdrawal-Deferred Salary Pln 15=Seasonal Agricultural Wrkr Pgm 16=Detached EE-Soc Sec Agreement 17=Fisher
14	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours Default Value: INSTALLATION.STD_HRS_DEFAULT
15	GPAU_OCCUPATION	Character(15)	VARCHAR2(15) NOT NULL	GPAUS - Stores a text format occupation identifier for an employee who is part of SuperEC processing.
16	GPAU_SALARY_AMOUNT	Number(19,6)	DECIMAL(18,6) NOT NULL	GPAUS - Stores the Salary Amount for an employee during SuperEC processing.
17	GPAU_SALARY_EFFDT	Date(10)	DATE	GPAUS - Stores the date at which the current Salary for the employee became effective. Used in SuperEC processing.