BN_RATE_TYPE

(SQL Table)
 Index Back

Benefit Rate Types

This table defines a Benefit Rate Type. A Rate Type defines whether the rates are specified as amounts or percents, and what keys are required to access an individual rate.

  • Related Language Record: BN_RATETYPE_LNG

  • Parent Record Of BN_RTTYP_KEY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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.
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 BN_RATE_OR_PCT Character(1) VARCHAR2(1) NOT NULL This is used to identify the type of a Benefit Rate Table. A Rate Type defines whether the rates are specified as amounts or percents, and what keys are required to access an individual rate.
    1=Rate Amount
    2=Percentage

    Default Value: 1

    5 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N