GPUS_RCP_VW

(SQL View)
Index Back

Recipient View for GPUS

Recipient View used for GPUS EFT

SELECT A.RECIPIENT_ID , A.DESCR , A.EFF_STATUS , A.RECIPIENT_CATEGORY , A.PAYMENT_MTHD , A.COUNTRY_CD , A.BANK_CD , A.ACCOUNT_EC_ID , A.ACCOUNT_NAME , A.CURRENCY_CD , B.BANK_NM FROM PS_RECIPIENT A , PS_BANK_EC_TBL B WHERE A.EFF_STATUS ='A' AND A.BANK_CD = B.BANK_CD AND A.COUNTRY_CD = 'USA'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

4 RECIPIENT_CATEGORY Character(1) VARCHAR2(1) NOT NULL Recipient Category
G=General
I=Individual

Default Value: G

5 PAYMENT_MTHD Character(1) VARCHAR2(1) NOT NULL Payment Method
A=Cash
C=Check
O=Pay Primary Account Only
P=Postal Order
T=Bank Transfer
U=Use Normal Distribution
W=Wire Transfer
6 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code

Default Value: OPR_DEF_TBL_HR.COUNTRY

Prompt Table: COUNTRY_TBL

7 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID

Prompt Table: BANK_EC_TBL

8 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.
9 ACCOUNT_NAME Character(50) VARCHAR2(50) NOT NULL Account Name
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

11 BANK_NM Character(40) VARCHAR2(40) NOT NULL Bank Name