SPB_ROLEBYTY_VW

(SQL View)
 Index Back

Roles by roletype

Date Initials Reference # Description 07/28/09: MRAD 1904050002 Ensured that WO entry gets created through delivered (SPF_AUTO_WO_GEN_CI) CI. 02/28/13 BHUSHAN 16346289 Ensured performance gain while loading MANAGE SERVICE WORK ORDER Component

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

  • Related Language Record: SPB_RLBYTY_LG_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL 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 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
    D=Deliverable
    M=Multi Resource
    R=Resource
    5 SETID_PROJROLE Character(5) VARCHAR2(5) NOT NULL Project Role Setid

    Prompt Table: SETID_TBL

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