BO_PRSN_NAME_VW

(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 , 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 FROM PS_RD_PERSON A , PS_BO_NAME B WHERE A.BO_ID = B.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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
3 NAME_TYPE Character(15) VARCHAR2(15) NOT NULL Business Object Name Type

Prompt Table: BO_PER_NM_TYP_V

4 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

5 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
6 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
7 BO_NAME_UPPER Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
8 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
9 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
10 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
11 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name