GPNZ_LST_PAY_VW (SQL View)	Index Back
Finds the Last Finalized Pay This view is used by the NZL array LVE_AR_RECON_OVDUE to find the last finalized pay period end date for an employee. This is required to determine if the employee was not active or on Leave in Advance when their anniversary fell due.

GPNZ_LST_PAY_VW

(SQL View)

Finds the Last Finalized Pay

This view is used by the NZL array LVE_AR_RECON_OVDUE to find the last finalized pay period end date for an employee. This is required to determine if the employee was not active or on Leave in Advance when their anniversary fell due.

SELECT A.EMPLID ,A.EMPL_RCD ,A.CAL_RUN_ID ,A.PRD_BGN_DT ,A.PRD_END_DT ,A.PRC_BGN_DT ,A.PRC_END_DT FROM PS_GP_PYE_PRC_STAT A WHERE A.PRD_END_DT = ( SELECT MAX(B.PRD_END_DT) FROM PS_GP_PYE_PRC_STAT B WHERE B.EMPLID = A.EMPLID AND B.PRD_END_DT <= ( SELECT MAX(D.PRD_END_DT) FROM PS_GP_CAL_RUN_DTL D WHERE D.GP_PAYGROUP = A.GP_PAYGROUP AND D.CALC_TYPE = 'P' AND D.CAL_FINAL_TS IS NOT NULL )) AND A.PRD_TYPE = 'C' AND A.CALC_TYPE = 'P'

# 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 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

4 PRD_BGN_DT Date(10) DATE Period Begin Date

5 PRD_END_DT Date(10) DATE Pay Period End Date

6 PRC_BGN_DT Date(10) DATE The Processing Begin Date is the Beginning Date of the Period when Processing is taking place. It usually is the same as the Period Begin Date (PRD_BGN_DT), except in cases of Advance Payment.

7 PRC_END_DT Date(10) DATE The Processing End Date is the End Date of the Period when Processing is taking place. It usually is the same as the Period End Date (PRD_END_DT), except in cases of Advance Payment.

#	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	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
5	PRD_END_DT	Date(10)	DATE	Pay Period End Date
6	PRC_BGN_DT	Date(10)	DATE	The Processing Begin Date is the Beginning Date of the Period when Processing is taking place. It usually is the same as the Period Begin Date (PRD_BGN_DT), except in cases of Advance Payment.
7	PRC_END_DT	Date(10)	DATE	The Processing End Date is the End Date of the Period when Processing is taking place. It usually is the same as the Period End Date (PRD_END_DT), except in cases of Advance Payment.