RSP_WORKER_BO_V

(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 , 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 FROM PS_RB_WORKER A , PS_RD_PERSON P , PS_BO_NAME B WHERE A.PERSON_ID = P.PERSON_ID AND P.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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

Default Value: 1

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_UPPER Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
9 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
10 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
11 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
12 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name