SP_MER_INCR_TBL

(SQL Table)
Index Back

Merit Increase Table

The Merit Increase Table is used to set up salary increases (in Salary Planning) based on employee appraisal results (in ePerformance Management).

  • Related Language Record: SP_MER_INCR_LNG
  • Parent Record Of SP_MER_INCR_RNG SP_MER_INCR_RTG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SP_MER_INCR_ID Character(5) VARCHAR2(5) NOT NULL Merit Increase ID
    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 SP_MER_INC_DESCR50 Character(50) VARCHAR2(50) NOT NULL Merit Increase - Description
    5 SP_MER_INC_DESCR20 Character(20) VARCHAR2(20) NOT NULL Merit Increase - Short Description
    6 SP_MER_INCR_TYPE Character(1) VARCHAR2(1) NOT NULL Merit Increase Type
    G=Merit Increase by Revw Rating
    P=Merit Increase by Point
    R=Merit Increase by Points Range

    Default Value: P

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

    Prompt Table: BASE_RATECD_VW

    8 AMOUNT_PER_POINT Number(19,6) DECIMAL(18,6) NOT NULL Amount per point
    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    10 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

    11 AMOUNT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Percent Amount
    12 PCT_PER_POINT Number(6,2) DECIMAL(5,2) NOT NULL Percent per point
    13 RATE_CODE_GROUP Character(6) VARCHAR2(6) NOT NULL Rate Code Group Name

    Prompt Table: COMPRT_GRP_TBL

    14 SAL_PTS_PER_POINT Number(5,0) INTEGER NOT NULL Salary Points Per Point
    15 SAL_PTS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Salary Points Frequency

    Prompt Table: COMP_FREQ_VW

    16 POINT_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Percent of Points
    17 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model

    Prompt Table: RATING_MDL_TBL