RD_PRSN_SRCH_VW (SQL View)	Index Back
View for Person Search Basic View for Person Search. It is used in Person Search component and Person Search configurable Search Setup.

RD_PRSN_SRCH_VW

(SQL View)

View for Person Search

Basic View for Person Search. It is used in Person Search component and Person Search configurable Search Setup.

SELECT A.PERSON_ID , B.FIRST_NAME , B.LAST_NAME , B.NAME_SUFFIX , B.NAME_AC , B.BO_NAME_DISPLAY , A.TITLE , A.EMPLID , D.EBS_EMPLID , A.SETID , A.BO_ID , 'NNNN' , A.MARKET , A.SYNCID FROM PS_RD_PERSON A LEFT OUTER JOIN PS_RC_EBSEMPNAM_VW D ON A.BO_ID= D.BO_ID , PS_BO_NAME B WHERE A.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y'

Related Language Record: RD_PRSN_SRCHLVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

2 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

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

4 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix

5 BO_NAME_AC 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 TITLE Character(35) VARCHAR2(35) NOT NULL Title

8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

9 EBS_EMPLID Character(30) VARCHAR2(30) NOT NULL EBS Employee Number used in the EBS - HR HelpDesk integration.

10 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

11 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

12 ROLES Character(4) VARCHAR2(4) NOT NULL Role Combination Indicator for Individual. The characters in the fields are used to represent different combinations of roles a person could have. See the translation values defined in the field.
NNN=None
NNNN=None
NNNY=POI
NNY=Worker
NNYN=Worker
NNYY=Worker, POI
NYN=Consumer
NYNN=Consumer
NYNY=Consumer,POI
NYY=Consumer, Worker
NYYN=Consumer, Worker
NYYY=Consumer, Worker, POI
YNN=Contact
YNNN=Contact
YNNY=Contact, POI
YNY=Contact, Worker
YNYN=Contact, Worker
YNYY=Contact, Worker, POI
YYN=Contact, Consumer
YYNN=Contact, Consumer
YYNY=Contact, Consumer, POI
YYY=Contact, Consumer, Worker
YYYN=Contact, Consumer, Worker
YYYY=Contact, Consumer, Worker, POI

13 MARKET Character(3) VARCHAR2(3) NOT NULL Market

14 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
2	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
3	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
4	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix
5	BO_NAME_AC	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	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	EBS_EMPLID	Character(30)	VARCHAR2(30) NOT NULL	EBS Employee Number used in the EBS - HR HelpDesk integration.
10	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
11	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
12	ROLES	Character(4)	VARCHAR2(4) NOT NULL	Role Combination Indicator for Individual. The characters in the fields are used to represent different combinations of roles a person could have. See the translation values defined in the field. NNN=None NNNN=None NNNY=POI NNY=Worker NNYN=Worker NNYY=Worker, POI NYN=Consumer NYNN=Consumer NYNY=Consumer,POI NYY=Consumer, Worker NYYN=Consumer, Worker NYYY=Consumer, Worker, POI YNN=Contact YNNN=Contact YNNY=Contact, POI YNY=Contact, Worker YNYN=Contact, Worker YNYY=Contact, Worker, POI YYN=Contact, Consumer YYNN=Contact, Consumer YYNY=Contact, Consumer, POI YYY=Contact, Consumer, Worker YYYN=Contact, Consumer, Worker YYYY=Contact, Consumer, Worker, POI
13	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
14	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.