SAL_RATECD_VW

(SQL View)
 Index Back

Salary Ratecd View

This view joins the sal_ratecd_tbl with the comp_ratecd_tbl for multiple component step defaulting on job.

SELECT A.SETID ,A.SAL_ADMIN_PLAN ,A.GRADE ,A.EFFDT ,B.EFF_STATUS ,A.STEP ,A.COMP_RATECD ,A.COMPRATE ,A.COMP_FREQUENCY ,A.CURRENCY_CD ,A.ANNUAL_RT ,A.COMP_RATE_POINTS ,A.COMP_PCT ,A.RATE_CODE_GROUP ,B.DESCRSHORT ,B.COMP_BASE_PAY_SW ,B.USE_HIGHEST_RT_SW FROM PS_SAL_RATECD_TBL A , PS_COMP_RATECD_TBL B WHERE A.COMP_RATECD = B.COMP_RATECD AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_COMP_RATECD_TBL C WHERE B.COMP_RATECD = C.COMP_RATECD AND C.EFFDT <= A.EFFDT)

  • Related Language Record: SAL_RATVW_LNG

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

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SETID_TBL

    2 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: SAL_PLAN_TBL

    3 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 STEP Number(2,0) SMALLINT NOT NULL Step
    7 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

    Prompt Table: BASE_RATECD_VW

    8 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    9 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
    A=Annual
    B=Biweekly
    C=Contract
    D=Daily
    H=Hourly
    M=Monthly
    S=Semimonthly
    W=Weekly

    Prompt Table: COMP_FREQ_VW

    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: SAL_STEP_TBL.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    11 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
    12 COMP_RATE_POINTS Number(5,0) INTEGER NOT NULL Comp Rate Points
    13 COMP_PCT Number(7,3) DECIMAL(6,3) NOT NULL Comp Percent
    14 RATE_CODE_GROUP Character(6) VARCHAR2(6) NOT NULL Rate Code Group Name

    Prompt Table: COMPRT_GRP_TBL

    15 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    16 COMP_BASE_PAY_SW Character(1) VARCHAR2(1) NOT NULL Comp Base Pay Switch
    17 USE_HIGHEST_RT_SW Character(1) VARCHAR2(1) NOT NULL Use Highest Rate