GPAU_STP_OTE_VW (SQL View)	Index Back
STP OTE View Ordinary Time Earnings View - Single Touch Payroll

GPAU_STP_OTE_VW

(SQL View)

STP OTE View

Ordinary Time Earnings View - Single Touch Payroll

SELECT STP.PROCESS_INSTANCE , STP.EMPLID_BGRP , STP.CAL_RUN_ID , OTE.GPAU_SUPER_BEN_AMT FROM PS_GPAU_STP_TMPSTG STP , PS_GPAU_RCPPYE OTE WHERE STP.EMPLID = OTE.EMPLID AND OTE.GPAU_OTE_FLAG = 'O' AND OTE.EMPL_RCD = ( SELECT MAX(OTE1.EMPL_RCD) FROM PS_GPAU_RCPPYE OTE1 WHERE OTE1.EMPLID = OTE.EMPLID AND OTE1.EFFDT <= STP.PRD_END_DT) AND OTE.EFFDT = ( SELECT MAX(OTE2.EFFDT) FROM PS_GPAU_RCPPYE OTE2 WHERE OTE2.EMPLID = OTE.EMPLID AND OTE2.EMPL_RCD = OTE.EMPL_RCD AND OTE2.EFFDT <= STP.PRD_END_DT) AND OTE.GPAU_RPT_START_DT <= STP.PRD_END_DT AND (OTE.GPAU_RPT_END_DT IS NULL OR OTE.GPAU_RPT_END_DT > %DateIn(%NumToChar(STP.GPAU_TAX_YEAR) %Concat '-06-30'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 EMPLID_BGRP Character(14) VARCHAR2(14) NOT NULL Emplid

3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

4 GPAU_STP_OTE_AMT Signed Number(17,2) DECIMAL(15,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 - Single Touch Payroll

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID_BGRP	Character(14)	VARCHAR2(14) NOT NULL	Emplid
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	GPAU_STP_OTE_AMT	Signed Number(17,2)	DECIMAL(15,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 - Single Touch Payroll