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
  • Parent Record Of COMP_RATCD_R_LN SEN_PAY_COMPRT SEN_PAY_GROUP
  • # 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 Rate Code 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

    Prompt Table: COMP_FREQ_VW

    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

    Prompt Table: COMP_RT_ERNS_VW

    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.

    Prompt Table: RATECD_CLS_TBL

    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
    17 SAL_PKG_WARN Character(1) VARCHAR2(1) NOT NULL Sal package - Maintained via Package Only

    Y/N Table Edit

    Default Value: N

    18 CMP_NON_UPD_IND Character(1) VARCHAR2(1) NOT NULL Non-Updateable Component Indicator

    Y/N Table Edit

    Default Value: N

    19 CMP_CALC_BY Character(2) VARCHAR2(2) NOT NULL Calculated By
    EX=Extended
    RM=Rate Matrix
    ZZ=None

    Default Value: ZZ

    20 CMP_PAYABLE_SW Character(1) VARCHAR2(1) NOT NULL Payable Switch

    Y/N Table Edit

    Default Value: Y

    21 LOOKUP_ID Character(15) VARCHAR2(15) NOT NULL Main unique identifier for Configurable Matrices.

    Prompt Table: WCS_RATE_MX_VW