P6_FL_NAME_VW

(SQL View)
 Index Back

Proj Mgr First / Last Name

Project Manager First Name Last Name view

SELECT DISTINCT A.BUSINESS_UNIT , %Substring(B.FIRST_NAME %Concat ' ' %Concat B.LAST_NAME, 1, 50) , B.EMPLID FROM %Table(PROJECT_MGR) A , %Table(PERSONAL_DATA) B WHERE A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM %Table(PROJECT_MGR) AA WHERE A.BUSINESS_UNIT = AA.BUSINESS_UNIT AND A.PROJECT_ID = AA.PROJECT_ID) AND A.PROJECT_MANAGER = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID