SPB_PROJ_SVS_VW

(SQL View)
 Index Back

View for getting project roles


SELECT A.SETID , A.PROJ_ROLE , A.DESCR , B.ROLE_TYPE , B.DFLT_ROLE_TYPE , C.SERVICE_METHOD , C.CATEGORY_CD FROM PS_SPB_PROJROLE_VW A , PS_SPB_ROLESBYTYPE B , PS_SPB_ROLE_TYPE C , PS_SET_CNTRL_GROUP S WHERE B.SETID = C.SETID AND A.PROJ_ROLE = B.PROJ_ROLE AND B.ROLE_TYPE = C.ROLE_TYPE AND B.DFLT_ROLE_TYPE = 'Y' AND S.SETCNTRLVALUE = A.SETID AND S.REC_GROUP_ID = 'SP_04' AND S.SETID = B.SETID

  • Related Language Record: SPB_PR_SV_LG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    2 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: PROJ_ROLE
    Set Control Field: SETID

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
    APR=Approver
    MGR=Manager
    OPR=Operator
    5 DFLT_ROLE_TYPE Character(1) VARCHAR2(1) NOT NULL Default Role Type
    N=No
    Y=Yes
    6 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
    D=Deliverable
    M=Multi Resource
    R=Resource
    7 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code