GPNZ_PDR_ER_VW

(SQL View)
 Index Back

IRD Employee Details

Search Record for Header Review page

SELECT DISTINCT ER.PAY_ENTITY , ER.GPNZ_PDR_YEAR , ER.PYMT_DT , ER.GPNZ_PDR_RNTYP , ER.GPNZ_PDR_VERSION , ER.GPNZ_PDR_STATUS , ER.GPNZ_IRD_NUMBER FROM PS_GPNZ_PDR_ER_DTL ER WHERE ER.GPNZ_PDR_VERSION = ( SELECT MAX(VR.GPNZ_PDR_VERSION) FROM PS_GPNZ_PDR_ER_DTL VR WHERE VR.PAY_ENTITY = ER.PAY_ENTITY AND VR.GPNZ_PDR_YEAR = ER.GPNZ_PDR_YEAR AND VR.PYMT_DT = ER.PYMT_DT AND VR.GPNZ_PDR_RNTYP = ER.GPNZ_PDR_RNTYP)

# 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 PYMT_DT Date(10) DATE Payment Date
4 GPNZ_PDR_RNTYP Character(3) VARCHAR2(3) NOT NULL PDR Run Type
AMD=Amendment
NRM=Original
OVR=Override

Default Value: NRM

5 GPNZ_PDR_VERSION Number(10,0) DECIMAL(10) NOT NULL New Field - Version added for PDR
6 GPNZ_PDR_STATUS Character(1) VARCHAR2(1) NOT NULL Issue status describes the level of the report.PDR Issued status
3=PDR File Generated
4=PDR Ready
7 GPNZ_IRD_NUMBER Character(9) VARCHAR2(9) NOT NULL New Zealand IRD Number