GPAU_RECPNT_VW (SQL View)	Index Back
View for AUS Dedn Recipients This view is used a search record - it returns all AUS Deduction Recipients.

GPAU_RECPNT_VW

(SQL View)

View for AUS Dedn Recipients

This view is used a search record - it returns all AUS Deduction Recipients.

SELECT DISTINCT B.PAY_ENTITY , A.RECIPIENT_ID FROM PS_GPAU_RCP_PYENT A ,PS_GPAU_PAYENT_VW B WHERE A.PAY_ENTITY=B.PAY_ENTITY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
Prompt Table: GPAU_PAYENT_VW
Set Control Field: CAL_RUN_ID

2 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GPAU_PAYENT_VW Set Control Field: CAL_RUN_ID
2	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID