BN_RATE_TBL

(SQL Table)
 Index Back

Benefit Rate Table

This table defines the Benefit Rate IDs (sets of rate data) and associates them with a Rate Type.

  • Related Language Record: BN_RATE_TBL_LNG

  • Parent Record Of BN_OTH_RATE_VW BN_RATE_DATA UPG_BN_RATE_DTA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RATE_TBL_ID Character(6) VARCHAR2(6) NOT NULL This is used as the record key that identifies a specific set of benefit rates.
    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 RATE_TYPE Character(4) VARCHAR2(4) NOT NULL This is used to identify the type of benefit rate in use - the keys, usage, and high-level attributes the govern how a rate behaves.

    Prompt Table: BN_RATE_TYPE

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 PAY_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Pay Frequency
    A=Annual
    B=Biweekly
    D=Daily
    M=Monthly
    Q=Quarterly
    S=Semimonthly
    W=Weekly

    Default Value: M

    Prompt Table: BEN_FREQ_VW

    8 RATE_UNIT Character(1) VARCHAR2(1) NOT NULL Rate per Unit
    1=None
    2=Per Thousand
    3=Per Hundred

    Default Value: 2

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

    Default Value: INSTALLATION.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    10 RATE_LIMIT_CD Character(1) VARCHAR2(1) NOT NULL RATE_LIMIT_CD determines how the amount of a rate subject to the % Gross Pay limit is calculated
    A=Entire Rate Amount
    F=Flat Amount
    N=Not Applicable
    P=Percent of Rate

    Default Value: N

    11 FLAT_AMT_LIMIT Number(9,4) DECIMAL(8,4) NOT NULL Flat Amount Limit
    12 PCT_RATE_LIMIT Number(6,3) DECIMAL(5,3) NOT NULL Percent of Rate Limit