GPNZ_PDRPD_VW2 (SQL View)	Index Back
View Finalysed Calendar Record View to fetch Finalysed Calanders for Run Control

GPNZ_PDRPD_VW2

(SQL View)

View Finalysed Calendar

Record View to fetch Finalysed Calanders for Run Control

SELECT DISTINCT DTL.PAY_ENTITY , DTL.GPNZ_PDR_YEAR , DTL.GPNZ_PDR_RNTYP , DTL.PYMT_DT FROM PS_GPNZ_PDR_ER_DTL DTL , PS_GP_CAL_RUN CAL WHERE DTL.CAL_RUN_ID = CAL.CAL_RUN_ID AND CAL.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

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

3 GPNZ_PDR_RNTYP Character(3) VARCHAR2(3) NOT NULL PDR Run Type
AMD=Amendment
NRM=Original
OVR=Override

4 PYMT_DT Date(10) DATE Payment Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
2	GPNZ_PDR_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Year code
3	GPNZ_PDR_RNTYP	Character(3)	VARCHAR2(3) NOT NULL	PDR Run Type AMD=Amendment NRM=Original OVR=Override
4	PYMT_DT	Date(10)	DATE	Payment Date