PERSON_IDE=External Contact
I=Internal Corporate Contact
RD_ACCT_CONT_VW(SQL View) |
Index Back |
|---|---|
Account ContactsCRM Sales - View for Account Contacts |
| SELECT A.PERSON_ID , B.LAST_NAME , B.FIRST_NAME , B.BO_NAME_DISPLAY , B.NAME_AC , A.CONTACT_FLAG FROM PS_RD_PERSON A , PS_BO_NAME B WHERE A.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 3 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 4 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 5 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name (Alternate Character) |
| 6 | CONTACT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
An attribute that describes the specific purpose of a given bank/counterparty contact person.
It is also used to indicate whether a person has a Contact role.
E=External Contact I=Internal Corporate Contact |