SPB_PJROL_LG_VW

(SQL View)
 Index Back

Project Role Lang View

Project Role Related Language View

SELECT A.SETID AS SETID_PROJROLE , A.ROLE_TYPE , A.PROJ_ROLE ,B.LANGUAGE_CD , B.DESCR FROM PS_SPB_ROLESBYTYPE A , PS_SPB_ROLE_ATTRIB D , PS_SPB_RATTRIB_LNG B , PS_SET_CNTRL_GROUP S WHERE S.SETCNTRLVALUE = A.SETID AND S.REC_GROUP_ID = 'PC_18' AND S.SETID = D.SETID AND A.PROJ_ROLE = B.PROJ_ROLE AND B.SETID = D.SETID AND B.PROJ_ROLE = D.PROJ_ROLE AND B.SERVICE_METHOD = D.SERVICE_METHOD

  • Related Language Record for SPB_JCODE_VW SPB_JOBCODE_DVW SPB_JOBCODE_MVW SPB_JOBCODE_RVW SPB_PJROLE_DVW SPB_PJROLE_MVW SPB_PJROLE_RVW SPB_PJROLE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_PROJROLE Character(5) VARCHAR2(5) NOT NULL Project Role Setid
    2 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
    APR=Approver
    MGR=Manager
    OPR=Operator
    3 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description