SPB_ROLERATE_VW

(SQL View)
 Index Back

Rates by roles

Rates by roles

SELECT DISTINCT R.SETID , R.PROJ_ROLE , P.DESCR FROM PS_SPB_RATESHEET R , PS_PROJ_ROLE P , PS_SET_CNTRL_GROUP SC WHERE R.PROJ_ROLE = P.PROJ_ROLE AND SC.SETCNTRLVALUE = R.SETID AND SC.REC_GROUP_ID = 'PC_18' AND SC.SETID = P.SETID

  • Related Language Record: SPB_ROLRT_LG_VW

  • Parent Record Of SPB_RATESHEET_V SPB_RHTSHT_LG_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: %EDITTABLE16
    Set Control Field: SETID

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