SPB_PR_SV_LG_VW

(SQL View)
 Index Back

View for getting project roles

View for getting project roles

SELECT A.SETID , A.PROJ_ROLE , LANGUAGE_CD , A.DESCR FROM PS_SPB_PROLE_LG_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 for SPB_PROJ_SVS_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description