RD_NWORK_G_VW (SQL View)	Index Back
Non Worker View Retrieving all People who are not Worker.

RD_NWORK_G_VW

(SQL View)

Non Worker View

Retrieving all People who are not Worker.

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

# 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 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

#	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	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID