PC_RATE_ROL_SVW

(SQL View)
 Index Back

Rates by Role

Rates by Role view with role description (from PROJ_ROLE) and filtering effective dates (from PC_RATE_ROLE).

SELECT A.SETID , A.PROJ_ROLE , A.EFFDT , B.DESCR , A.CURRENCY_CD , A.UNIT_OF_MEASURE , A.COST_RATE , A.BILL_RATE FROM PS_PC_RATE_ROLE A , PS_PROJ_ROLE B WHERE A.SETID = B.SETID AND A.PROJ_ROLE = B.PROJ_ROLE AND A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_PC_RATE_ROLE A2 WHERE A.SETID = A2.SETID AND A.PROJ_ROLE = A2.PROJ_ROLE)

  • Related Language Record: PC_RATE_ROL_LVW

    • # 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: PROJ_ROLE

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    6 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    7 COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate
    8 BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate