BN02.1 - Age Rate Table Use BN02.1 (Age Rate Table) to define contribution amounts based on age. The system calculates the contribution using either an amount or percent. When you assign a rate table to a benefit plan's contribution record, the rate table's start date must match the start date of the contribution record. You can use age rate tables for employee, COBRA participant, and retiree contributions. You can assign age rate tables to contributions in the following forms: - BN18.2 (Options Amount Range), - BN18.3 (Flat Contribution), and - BN18.4 (Salary or Coverage Rate Table). Updated Files BNCOVERAGE - The Premium Option file is updated to indicate premium changes PREMIUM - The Benefit Plan Premium file is accessed by this program. RATETBLDTL - The Rate Table Detail file is accessed by this program. RATETBLHDR - The Rate Table Header file is used to verify rate table codes. Referenced Files BENEFIT - The Employee Benefit file contains employee benefit records for all benefit types. The Benefits file is accessed to verify the plans. BNCOMPANY - The Benefit Company Parameters file is used to verify company information. BNPRMOPT - The Premium Option file is updated to indicate premium changes. FLEXDOLLAR - The Flex Dollars file is used to verify flex dollar records. PARTBEN - The COBRA Participant Benefits file ensures records are not deleted if COBRA participant benefits exist. PRSYSTEM - The HR Company and Process Levels file is used to verify company information. BN02.2 - Salary Rate Table Use BN02.2 (Salary Rate Table) to define contribution amounts based on salary. The system calculates the contribution using either an amount or percent. When you assign a rate table to a benefit plan's contribution record, the rate table's start date must match the start date of the contribution record. Salary rate tables are not valid for COBRA participant and retiree contributions. You can assign salary rate tables to contributions in the following forms: - BN18.2 (Options Amount Range), - BN18.3 (Flat Contribution), and - BN18.4 (Salary or Coverage Rate Table). Updated Files BNCOVERAGE - The Premium Option file is updated to indicate premium changes. PREMIUM - The Premium file is updated to indicate a rate change. RATETBLDTL - The Rate Table Detail file is updated. RATETBLHDR - The Rate Table Header file is used to determine the rate table and retrieve rate information. Referenced Files BENEFIT - The Employee Benefit file contains employee benefit records for all benefit types. The Benefit file is accessed to verify the plans. BNCOMPANY - The Benefit Company file is accessed to verify the benefit company. BNPRMOPT - The Premium Option file is updated to indicate premium changes. FLEXDOLLAR - The Flex Dollars file is used to verify flex dollar records. PARTBEN - The COBRA Participant Benefits file ensures records are not deleted if COBRA participant benefits exist. PRSYSTEM - The HR Company and Process Levels file is used to verify the company. BN02.3 - Service Rate Table Use BN02.3 (Service Rate Table) to define contribution amounts based on years of service. The system calculates the contribution using either an amount or percent. When you assign a rate table to a benefit plan's contribution record, the rate table's start date must match the start date of the contribution record. Service rate tables are not valid for COBRA participant and retiree contributions. You can assign service rate tables to contributions in the following forms: - BN18.2 (Options Amount Range), - BN18.3 (Flat Contribution), and - BN18.4 (Salary or Coverage Rate Table). Updated Files BNCOVERAGE - The Premium Option file is updated to indicate premium changes. PREMIUM - The Benefit Plan Premium file is updated to indicate a rate change. RATETBLDTL - The Rate Table Detail file is updated. RATETBLHDR - The Rate Table Header file is used to verify the rate table and to retrieve table information. Referenced Files BENEFIT - The Employee Benefit file contains employee benefit records for all benefit types. The Employee Benefit file is accessed to verify the plans. BNCOMPANY - The Benefit Company file is accessed to verify the benefit company. BNPRMOPT - The Premium Options file is updated to indicate premium changes. FLEXDOLLAR - The Flex Dollars file is used to verify flex dollar records. PARTBEN - The COBRA Participant Benefits file ensures records are not deleted if COBRA participant benefits exist. PRSYSTEM - The HR Company and Process Levels file is used to verify the company. BN02.4 - Credits Rate Table Use BN02.4 (Credits Rate Table) to define the number of flex credits employees receive based on their number of dependents or their lifestyle points. When you assign a rate table to a flex dollar record, the rate table's start date must match the start date of the flex dollar record. An employee's number of dependents and lifestyle points are defined in the Benefits form tab of HR11.1 (Employee). You assign credit rate tables to flex plans in the Dependents Credits and Lifestyle Credits subforms of BN08.1 (Flex Dollars). Updated Files BNCOVERAGE - The Premium Option file is updated to indicate premium changes. PREMIUM - The Premium file is updated to indicate a rate change. RATETBLDTL - The Rate Table Detail file is updated. RATETBLHDR - The Rate Table Header file is used to determine the rate table and retrieve rate information. Referenced Files BENEFIT - The Employee Benefit file contains employee benefit records for all benefit types. The Benefit file is accessed to verify the plans. BNCOMPANY - The Benefit Company file is accessed to verify the benefit company. BNPRMOPT - The Premium Option file is updated to indicate premium changes. FLEXDOLLAR - The Flex Dollars file is used to verify flex dollar records. PARTBEN - The COBRA Participant Benefits file ensures records are not deleted if COBRA participant benefits exist. PRSYSTEM - The HR Company and Process Levels file is used to verify the company. BN02.5 - Coverage Reduction Table Use BN02.5 (Coverage Reduction Table) to define how coverage reduces as plan participants get older. If the plan specifies both a percent and an amount reduction, the system uses the greater of the two. When you assign a rate table to a benefit plan's coverage record, the rate table's start date must match the start date of the coverage record. You assign coverage reduction tables to coverage records in the Coverage Limits subform of BN17.3 (Coverage Amounts). Updated Files BNCOVERAGE - The Premium Option file is updated to indicate premium changes. PREMIUM - The Premium file is accessed to retrieve premium information. RATETBLDTL - The Rate Table Detail file is updated. RATETBLHDR - The Rate Table Header file is used to determine the rate table and retrieve rate information. Referenced Files BENEFIT - The Employee Benefit file contains employee benefit records for all benefit types. The Benefit file is accessed to verify the plans. BNCOMPANY - The Benefit Company file is accessed to verify the benefit company. BNPRMOPT - The Premium Option file is accessed to verify the premium. FLEXDOLLAR - The Flex Dollars file is used to verify flex dollar records. PARTBEN - The COBRA Participant Benefits file ensures records are not deleted if COBRA participant benefits exist. PLAN - The Plan file is accessed to retrieve plan codes and to determine if a plan is a flex plan. PRSYSTEM - The HR Company and Process Levels file is used to verify the company. |