GPAU_OTE_AMT (SQL Table)	Index Back
ComSuper OTE amount Store Comsuper OTE amounts

GPAU_OTE_AMT

(SQL Table)

ComSuper OTE amount

Store Comsuper OTE amounts

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 GPAU_OTE_AMT Number(11,2) DECIMAL(10,2) NOT NULL GPAUS - Used to store the OTEamount of Super Contributions made to a Super Fund Administrator in the period for which ComSuper reporting is being undertaken.

4 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	GPAU_OTE_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	GPAUS - Used to store the OTEamount of Super Contributions made to a Super Fund Administrator in the period for which ComSuper reporting is being undertaken.
4	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time