COMP_RATECD_TBL

(SQL Table)
 Index Back

Comp Rate Code Table

In this table, the user will define rates which will be available to the entire employee population for pay earnings calculations. All rates that are to be used by payroll processing at job code or employee levels must first be defined in this table.

  • Related Language Record: COMP_RATCD_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 COMP_BASE_PAY_SW Character(1) VARCHAR2(1) NOT NULL Comp Base Pay Switch

    Y/N Table Edit

    Default Value: N

    7 USE_HIGHEST_RT_SW Character(1) VARCHAR2(1) NOT NULL Use Highest Rate

    Y/N Table Edit

    Default Value: N

    8 COMP_RATE_TYPE Character(2) VARCHAR2(2) NOT NULL Comp Rate Type
    FA=Flat Amount
    HF=Hourly Rate + Flat Amount
    HR=Hourly Rate
    PC=Percent
    PT=Points
    9 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    10 COMP_PCT Number(7,3) DECIMAL(6,3) NOT NULL Comp Percent
    11 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
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    13 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
    14 FTE_INDICATOR Character(1) VARCHAR2(1) NOT NULL Apply FTE for Annualization

    Y/N Table Edit

    Default Value: N

    15 RATE_CODE_CLASS Character(6) VARCHAR2(6) NOT NULL Defines classes of rate codes. A rate code class can be used to bundle and group rate codes defined in the Comp Rate Code Table.
    16 SENIORITY_CALC Character(1) VARCHAR2(1) NOT NULL This field defines by what date seniority should be calculated for the Seniority Pay compensation component.
    B=Birth Date
    E=EdclvlaBDt (for Japan only)
    H=Hire Date
    P=Professional Experience Date
    S=Company Seniority Date