RECIPIENT_IDG=General
I=Individual
RECIPIENT_G_VW(SQL View) |
Index Back |
|---|---|
General Recipient ViewGeneral Recipient View |
| SELECT A.RECIPIENT_ID , A.DESCR , A.RECIPIENT_CATEGORY FROM PS_RECIPIENT A WHERE A.RECIPIENT_CATEGORY = 'G' |
| # | 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 |