RD_PRSN_NM_VW2 (SQL View)	Index Back
Person Name Search View This view returns persons that have the role of 1, 8, or 9 (person, contact, consumer)

RD_PRSN_NM_VW2

(SQL View)

Person Name Search View

This view returns persons that have the role of 1, 8, or 9 (person, contact, consumer)

SELECT DISTINCT A.BO_ID ,%Substring(B.BO_NAME_DISPLAY, 1, 50) ,B.LAST_NAME_SRCH ,B.NAME_AC ,A.TITLE ,A.PERSON_ID FROM PS_RD_PERSON A ,PS_BO_NAME B , PS_BO_ROLE C WHERE A.BO_ID = B.BO_ID AND A.BO_ID = C.BO_ID AND B.PRIMARY_IND = 'Y' AND C.ROLE_TYPE_ID = 8

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID_MGR Signed Number(32,0) DECIMAL(31) NOT NULL Manager BO_ID for Change Management

2 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Business Name Display. BO_NAME.NAME_DISPLAY

3 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

4 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)

5 TITLE Character(35) VARCHAR2(35) NOT NULL Title

6 PRSN_ID_MGR Character(15) VARCHAR2(15) NOT NULL Manager Person ID. It is used in RD_NAME_WRK and RD_PRSN_NM_VW2.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID_MGR	Signed Number(32,0)	DECIMAL(31) NOT NULL	Manager BO_ID for Change Management
2	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Business Name Display. BO_NAME.NAME_DISPLAY
3	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
4	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name (Alternate Character)
5	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title
6	PRSN_ID_MGR	Character(15)	VARCHAR2(15) NOT NULL	Manager Person ID. It is used in RD_NAME_WRK and RD_PRSN_NM_VW2.