GM_CNT_PRF_VW

(SQL View)
 Index Back

GM Cont Professional View


SELECT W.BUSINESS_UNIT , W.CONTRACT_NUM , P.PROJECT_ID , %Substring(T.TEAM_MEMBER,1,11) , I.DESCR , %Substring(T.PROJ_ROLE,1,4) FROM PS_GM_AWARD W , PS_GM_AWD_PROJT_VW J , PS_PROJECT P , PS_GM_PRJ_DEPT D , PS_PC_TEAM_EMP_VW T , PS_SET_CNTRL_REC C , PS_GM_INSTITUTION I WHERE J.CONTRACT_NUM = W.CONTRACT_NUM AND P.BUSINESS_UNIT = J.BUSINESS_UNIT_PC AND P.PROJECT_ID = J.PROJECT_ID AND D.BUSINESS_UNIT = P.BUSINESS_UNIT AND D.PROJECT_ID = P.PROJECT_ID AND T.BUSINESS_UNIT = P.BUSINESS_UNIT AND T.PROJECT_ID = P.PROJECT_ID AND T.PROJ_ROLE IN ('PI', 'CPI','KEY','AUTH') AND C.SETCNTRLVALUE = D.BUSINESS_UNIT AND C.RECNAME = 'GM_INSTITUTION' AND I.SETID = C.SETID AND I.INSTID = D.INSTID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
3 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 ORG Character(30) VARCHAR2(30) NOT NULL Organization
6 PROF_ROLE_TYPE Character(4) VARCHAR2(4) NOT NULL Role Type

Prompt Table: GM_PROF_ROLE_TY