RD_NON_REP_VW

(SQL View)
 Index Back

Persons w/o Contact Role

This view returns persons who do not have the contact role.

SELECT A.PERSON_ID , A.BO_ID , B.FIRST_NAME , B.LAST_NAME , B.FIRST_NAME_SRCH , B.LAST_NAME_SRCH , A.TITLE , A.EMPLID , A.MARKET 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 C.ROLE_START_DT <= %CurrentDateIn AND C.ROLE_END_DT > %CurrentDateIn) AND B.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RD_PERSON

2 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
5 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
6 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
7 TITLE Character(35) VARCHAR2(35) NOT NULL Title
8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
9 MARKET Character(3) VARCHAR2(3) NOT NULL Market