SPB_ROLBYTY_MVW

(SQL View)
 Index Back

Roles by roletype - Multi Reso

Roles by roletype - Multi Resource Service Method

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

  • Related Language Record: SPB_RLBYTY_LG_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_PROJROLE Character(5) VARCHAR2(5) NOT NULL Project Role Setid

    Prompt Table: SETID_TBL

    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 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