SPB_PJROLE_M_VW

(SQL View)
 Index Back

Project Role View - MResource

Project Role View - Multi Resource based

SELECT A.SETID , A.ROLE_TYPE AS M_ROLE_TYPE , A.PROJ_ROLE AS M_PROJ_ROLE , B.SERVICE_METHOD , B.DESCR FROM PS_SPB_ROLESBYTYPE A , PS_SPB_ROLE_ATTRIB B , PS_SET_CNTRL_GROUP S WHERE S.SETCNTRLVALUE = A.SETID AND S.REC_GROUP_ID = 'PC_18' AND S.SETID = B.SETID AND A.PROJ_ROLE = B.PROJ_ROLE AND B.SERVICE_METHOD = 'M'

  • Related Language Record: SPB_PJR_M_LG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 M_ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Multi Resource Role Type
    3 M_PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Multi Resource Project Role
    4 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
    D=Deliverable
    M=Multi Resource
    R=Resource

    Default Value: R

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description