EX_PROJ_MGR_VW2 (SQL View)	Index Back
Project Managers This view selects a list of project managers as defined on the PROJECT_MGR table.

EX_PROJ_MGR_VW2

(SQL View)

Project Managers

This view selects a list of project managers as defined on the PROJECT_MGR table.

SELECT DISTINCT A.BUSINESS_UNIT AS BUSINESS_UNIT_PC , A.PROJECT_MANAGER , B.NAME FROM PS_PROJECT_MGR A , PS_PERSONAL_DATA B WHERE A.PROJECT_MANAGER = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

2 PROJECT_MANAGER Character(11) VARCHAR2(11) NOT NULL Project Manager

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
2	PROJECT_MANAGER	Character(11)	VARCHAR2(11) NOT NULL	Project Manager
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name