GM_PT_PROJ_VW

(SQL View)
 Index Back

SELECT DISTINCT %Substring(A.TEAM_MEMBER, 1, 11) , A.PROJECT_ID , C.DESCR , B.ACCESS_CD FROM PS_PROJECT_TEAM A , PS_GM_PT_ACCESS B , PS_PROJECT C WHERE A.TEAM_MEMBER_CLASS = 'L' AND A.TEAM_MEMBER_IND = 'E' AND A.PLAN_PROJROLE = B.PROJ_ROLE AND B.PROJECT_FLG = 'Y' AND B.ACCESS_CD <> 'N' AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.PROJECT_ID = A.PROJECT_ID UNION SELECT DISTINCT A1.CONTACT_ID , A1.PROJECT_ID , A1.TITLE56 , B1.ACCESS_CD FROM PS_GM_PROP_PROJ A1 , PS_GM_PT_ACCESS B1 , PS_GM_AWARD C1 , PS_GM_PROPOSAL D1 WHERE B1.PROJ_ROLE = 'DADM' AND B1.PROJECT_FLG = 'Y' AND B1.ACCESS_CD <> 'N' AND A1.CONTACT_ID <> ' ' AND A1.BUSINESS_UNIT = C1.BUSINESS_UNIT AND A1.PROPOSAL_ID = C1.PROPOSAL_ID AND A1.BUSINESS_UNIT = D1.BUSINESS_UNIT AND A1.PROPOSAL_ID = D1.PROPOSAL_ID AND D1.PROPOSAL_STATUS_GR = 'AWD'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
N=No Access
R=Read Only Access
Y=Read/Write Access