GPNZ_RCN_PD_VW (SQL View)	Index Back
Payment Date of PDR PDR Payment dates for reconciliaiton process

GPNZ_RCN_PD_VW

(SQL View)

Payment Date of PDR

PDR Payment dates for reconciliaiton process

SELECT DISTINCT C.OPRID , ER.PAY_ENTITY , ER.PYMT_DT FROM PS_GP_CAL_RUN CR , PS_GP_OPR_RULE_PRF C , PS_GPNZ_PDR_ER_DTL ER WHERE (C.USED_BY= 'A' OR (C.USED_BY = 'C' AND CR.COUNTRY = C.COUNTRY)) AND CR.CAL_RUN_ID = ER.CAL_RUN_ID AND EXISTS ( SELECT 1 FROM PS_GP_PYE_PRC_STAT PPS WHERE CALC_TYPE='P' AND CR.CAL_RUN_ID=PPS.CAL_RUN_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

3 PYMT_DT Date(10) DATE Payment Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
3	PYMT_DT	Date(10)	DATE	Payment Date