GP_PMT_RCPNM_VW (SQL View)	Index Back
Pmt Recipients by CAL RUN ID Promptview used for selecting recipient name as selection criterion against the payment table

GP_PMT_RCPNM_VW

(SQL View)

Pmt Recipients by CAL RUN ID

Promptview used for selecting recipient name as selection criterion against the payment table

SELECT DISTINCT P.CAL_RUN_ID , P.RECIPIENT_NAME FROM PS_GP_PAYMENT P WHERE P.RECIPIENT_NAME<>' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

2 RECIPIENT_NAME Character(30) VARCHAR2(30) NOT NULL Recipient Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	RECIPIENT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Recipient Name