GPNZ_PDR_SR_VW (SQL View)	Index Back
PDR Data Employee Data Level for PDR

GPNZ_PDR_SR_VW

(SQL View)

PDR Data

Employee Data Level for PDR

SELECT DISTINCT A.PAY_ENTITY , A.GPNZ_PDR_YEAR , A.EMPLID , B.NAME , A.GPNZ_IRD_NUMBER FROM PS_GPNZ_PDR_EE_DTL A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID AND EXISTS( SELECT CL.CAL_RUN_ID FROM PS_GP_CAL_RUN CL WHERE CL.CAL_RUN_ID = A.CAL_RUN_ID AND (CL.RUN_OPEN_IND = 'Y' OR CL.RUN_FINALIZED_IND = 'Y'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
Prompt Table: GPNZ_PDR_PE_VW

2 GPNZ_PDR_YEAR Character(4) VARCHAR2(4) NOT NULL Year code

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

4 NAME Character(50) VARCHAR2(50) NOT NULL Name

5 GPNZ_IRD_NUMBER Character(9) VARCHAR2(9) NOT NULL New Zealand IRD Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GPNZ_PDR_PE_VW
2	GPNZ_PDR_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Year code
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
5	GPNZ_IRD_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	New Zealand IRD Number