PC_RATE_JOB_SVW

(SQL View)
 Index Back

Rates by Job Code

View most recent effective dated rates by job code with job code description.

SELECT RT.SETID , RT.JOBCODE , RT.EFFDT , JC.DESCR , RT.CURRENCY_CD , RT.UNIT_OF_MEASURE , RT.COST_RATE , RT.BILL_RATE FROM PS_PC_RATE_JOBC RT , PS_JOBCODE_TBL JC WHERE JC.SETID = RT.SETID AND JC.JOBCODE = RT.JOBCODE AND JC.EFFDT = ( SELECT MAX(JC2.EFFDT) FROM PS_JOBCODE_TBL JC2 WHERE JC.SETID = JC2.SETID AND JC.JOBCODE = JC2.JOBCODE AND JC2.EFF_STATUS = 'A' AND JC2.EFFDT <= %CurrentDateIn) AND RT.EFFDT = ( SELECT MAX(RT2.EFFDT) FROM PS_PC_RATE_JOBC RT2 WHERE RT.SETID = RT2.SETID AND RT.JOBCODE = RT2.JOBCODE)

  • Related Language Record: PC_RATE_JOB_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 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    3 EFFDT Date(10) DATE 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
    6 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    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