GM_PT_AWD_VW

(SQL View)
 Index Back

SELECT DISTINCT %Substring(A.TEAM_MEMBER, 1, 11) , C.CONTRACT_NUM , D.TITLE56 , B.ACCESS_CD FROM PS_PROJECT_TEAM A , PS_GM_PT_ACCESS B , PS_CA_DETAIL_PROJ C , PS_GM_AWARD D WHERE A.TEAM_MEMBER_CLASS = 'L' AND A.TEAM_MEMBER_IND = 'E' AND A.PLAN_PROJROLE = B.PROJ_ROLE AND B.AWARD_FLAG = 'Y' AND B.ACCESS_CD <> 'N' AND C.BUSINESS_UNIT_PC = A.BUSINESS_UNIT AND C.PROJECT_ID = A.PROJECT_ID AND D.CONTRACT_NUM = C.CONTRACT_NUM UNION SELECT DISTINCT A1.GM_ADMIN_CNTCT , A1.CONTRACT_NUM , A1.TITLE56 , B1.ACCESS_CD FROM PS_GM_AWARD A1 , PS_GM_PT_ACCESS B1 WHERE B1.PROJ_ROLE = 'ADM' AND B1.AWARD_FLAG = 'Y' AND B1.ACCESS_CD <> 'N' AND A1.GM_ADMIN_CNTCT <> ' ' UNION SELECT DISTINCT A2.CONTRACT_ADMIN , A2.CONTRACT_NUM , C2.TITLE56 , B2.ACCESS_CD FROM PS_CA_CONTR_HDR A2 , PS_GM_PT_ACCESS B2 , PS_GM_AWARD C2 WHERE B2.PROJ_ROLE = 'CADM' AND B2.AWARD_FLAG = 'Y' AND B2.ACCESS_CD <> 'N' AND A2.CONTRACT_ADMIN <> ' ' AND C2.BUSINESS_UNIT = A2.BUSINESS_UNIT AND C2.CONTRACT_NUM = A2.CONTRACT_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
3 TITLE56 Character(56) VARCHAR2(56) NOT NULL TITLE56
4 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
N=No Access
R=Read Only Access
Y=Read/Write Access