RD_NREP_G_VW

(SQL View)
 Index Back

All Persons without Role 8

This view is used in Person Search component. It list all persons without role type 8. SELECT DISTINCT A.PERSON_ID , B.FIRST_NAME , B.LAST_NAME , B.NAME_AC , A.TITLE , A.EMPLID , B.FIRST_NAME_SRCH , B.LAST_NAME_SRCH , A.BO_ID FROM PS_RD_PERSON A , PS_BO_NAME B WHERE A.BO_ID = B.BO_ID AND NOT EXISTS ( SELECT 'X' FROM PS_BO_ROLE C WHERE A.BO_ID = C.BO_ID AND ROLE_TYPE_ID = 8)

SELECT DISTINCT A.PERSON_ID , B.FIRST_NAME , B.LAST_NAME , B.NAME_AC , A.TITLE , A.EMPLID , B.FIRST_NAME_SRCH , B.LAST_NAME_SRCH , A.BO_ID FROM PS_RD_PERSON A , PS_BO_NAME B WHERE A.BO_ID = B.BO_ID AND NOT EXISTS ( SELECT 'X' FROM PS_BO_ROLE C WHERE A.BO_ID = C.BO_ID AND ROLE_TYPE_ID = 8) AND (A.MARKET = 'GBL' OR A.MARKET = ' ')

# 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 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
5 TITLE Character(35) VARCHAR2(35) NOT NULL Title
6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
7 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
8 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
9 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID