RB_PRSN_BO_VW2

(SQL View)
 Index Back

Person Name View

This view replaces the record of the same name. All references to RD_PERSON_NAME should be made to BO_NAME as this is the record that has replaced RD_PERSON_NAME

SELECT B.BO_ID , A.PERSON_ID , B.SEQ_NBR , B.NAME_TYPE , B.PRIMARY_IND , B.BO_NAME , B.BO_NAME_DISPLAY , B.BO_NAME_DISP_UPPER , B.BO_NAME_UPPER , B.FIRST_NAME , B.FIRST_NAME_SRCH , B.LAST_NAME , B.LAST_NAME_SRCH , A.CONTACT_FLAG FROM PS_RD_PERSON A , PS_BO_NAME B , PS_RD_WRKR_JOB_V C WHERE A.BO_ID = B.BO_ID AND B.BO_ID = C.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
4 NAME_TYPE Character(15) VARCHAR2(15) NOT NULL Business Object Name Type

Prompt Table: BO_PER_NM_TYP_V

5 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

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