RD_NON_WORK_VW

(SQL View)

SELECT DISTINCT A.PERSON_ID , A.BO_ID , B.FIRST_NAME , B.LAST_NAME , A.TITLE , 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 = 4 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 TITLE Character(35) VARCHAR2(35) NOT NULL Title

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

#	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	TITLE	Character(35)	VARCHAR2(35) NOT NULL	Title
6	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market