RB_ACCT_CONT_VW

(SQL View)
 Index Back

Account Contact View

Provides a prompt for all people in the role of account contact.

SELECT DISTINCT A.TREE_NAME , A.PERSON_ID_MANAGER , B.BO_ID , P.PERSON_ID , B.SEQ_NBR , B.NAME_TYPE , B.PRIMARY_IND , B.BO_NAME , B.BO_NAME_DISPLAY , B.BO_NAME_UPPER , B.FIRST_NAME , B.FIRST_NAME_SRCH , B.LAST_NAME , B.LAST_NAME_SRCH , P.CONTACT_FLAG FROM PS_RSF_ACC_SUSER A , PS_RD_PERSON P , PS_BO_NAME B WHERE A.PERSON_ID = P.PERSON_ID AND P.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y' AND A.TREE_NAME <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TO_TREE Character(18) VARCHAR2(18) NOT NULL New Tree Name
2 PERSON_ID_MANAGER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
3 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
4 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

Default Value: 1

6 NAME_TYPE Character(15) VARCHAR2(15) NOT NULL Business Object Name Type

Prompt Table: BO_PER_NM_TYP_V

7 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
N=No
Y=Yes

Y/N Table Edit

8 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
9 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
10 BO_NAME_UPPER Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
11 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
12 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
13 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
14 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
15 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