FO_HRL_COMPRTCD

(SQL View)
 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.

SELECT COMP_RATECD , EFFDT , EFF_STATUS , DESCR , DESCRSHORT , COMP_RATE_TYPE , COMP_FREQUENCY , CURRENCY_CD , ERNCD , FTE_INDICATOR , RATE_CODE_CLASS FROM PS_COMP_RATECD_TBL WHERE COMP_RATE_TYPE = 'HR' AND CMP_NON_UPD_IND = 'N' AND COMP_BASE_PAY_SW = 'Y'

  • 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_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
    7 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

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

    Prompt Table: CURRENCY_CD_TBL

    9 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

    Prompt Table: COMP_RT_ERNS_VW

    10 FTE_INDICATOR Character(1) VARCHAR2(1) NOT NULL Apply FTE for Annualization

    Y/N Table Edit

    Default Value: N

    11 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