JOBCD_COMP_RATE

(SQL Table)
 Index Back

Job Code Comp Rate Table

In this table, the user will define rates which apply to only those employees sharing the same job code. All rates that are to be used by payroll processing at the job code level must first be defined in this table.

  • Parent record: JOBCODE_TBL

    • # 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 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

    Prompt Table: COMP_RATECD_TBL

    5 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: FREQUENCY_TBL

    6 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    7 COMP_PCT Number(7,3) DECIMAL(6,3) NOT NULL Comp Percent
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    9 COMP_RATE_POINTS Number(5,0) INTEGER NOT NULL Comp Rate Points
    10 RATE_CODE_GROUP Character(6) VARCHAR2(6) NOT NULL Rate Code Group Name

    Prompt Table: COMPRT_GRP_TBL

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

    Y/N Table Edit

    Default Value: N