RECIPIENT_IDG=General
I=Individual
A=Cash
C=Check
O=Pay Primary Account Only
P=Postal Order
T=Bank Transfer
U=Use Normal Distribution
W=Wire Transfer
RECIPIENT_I_VW(SQL View) |
Index Back |
|---|---|
Individual Recipient ViewIndividual Recipient View |
| SELECT A.RECIPIENT_ID , A.DESCR , A.RECIPIENT_CATEGORY , A.PAYMENT_MTHD FROM PS_RECIPIENT A WHERE A.RECIPIENT_CATEGORY = 'I' AND A.EFF_STATUS = 'A' |
| # | 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 | RECIPIENT_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Recipient Category
G=General I=Individual |
| 4 | 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 |