BN105 - Plan Update Run BN105 (Benefit Plan Update) to update all benefits for plans in which coverage, contributions, or general ledger overrides have been added or changed. You can update employee, COBRA participant, and retiree benefits. Run BN105 before the payroll cycle in which the new coverage, contribution, or general ledger override records become effective. When a benefit is affected by a new coverage, contribution, or general ledger override record, the system does the following: 1. Stops the original benefit and deductions the day before the change is effective. 2. Re-adds the benefit and deductions with a start date equal to the effective date of the change. 3. For benefits under a flex plan, the system can create or update standard time records. If an existing employee group used to vary a part of a plan changes, BN105 changes benefits based on the change. If a new employee group assigned to a coverage, contribution, or general ledger override was added after employees have enrolled in the plan, BN105 evaluates all benefits in effect under the plan to determine how each employee's benefits should change. For example, on 01/01/95 a plan has coverage for HOURLY and SALARIED employee groups. If coverage for the HOURLY employee group changes on 01/01/96, BN105 evaluates benefits for employees in the HOURLY group only. If on 01/01/96 coverage was also added for the employee group TEMP, BN105 evaluates all employees in the plan to determine which coverage applies to which employees. For each updated benefit, BN105 lists the employee; the original contribution, coverage, or general ledger override parameters; the new contribution, coverage, and general ledger override parameters. You can include deductions on the report. Updated Files BENEFIT - The Employee Benefit file contains employee benefit records for all benefit types. BNACCOUNTS - The Benefit Accounts file validates general ledger override account information. BNCOMMENTS - Comments are deleted from the Benefit Comments file when an employee benefit is deleted. BNCOVDFT - The Benefit Coverage Default file verifies whether a Coverage Option is needed and that Coverage Defaults exist. BNCOVERAGE - The Benefit Coverage file verifies that coverage exists for an Employee and Date. CKPOINT - The Check Point file is used to allow recovery. EMDEDMASTR - The Employee Deduction Master file is updated when benefits are added, changed, or deleted. EMPFLEXDOL - The Employee Flex Plan file is updated with flex plan information. EMPFLEXREM - The Employee Flex Period Dollars file is updated with flex plans. EMPINVEST - The Employee Benefit Investment Distribution is updated with the stop date when a benefit is stopped on a defined contribution plan. The file is also updated when benefits are deleted. EMPLOYEE - The Employee file is updated with the last deduction sequence when a benefit is added. The file also verifies the employee. HRDEPBEN - The Dependent Benefits file is accessed by this program. HRHISTORY - The HR History file is accessed to retrieve annual salary for "as of" dates. PARTBEN - The COBRA Participant Benefit file is updated with benefit changes. PREMIUM - The Benefit Plan Premium file is updated with status changes. It is also accessed to retrieve the company contribution for flat rates and to retrieve other premium information. PRTAXGRP - The Tax Group file is accessed. STANDTIME - The Payroll Standard Time Record file is updated for defined contribution plans when employee benefits are deleted or when contributions are changed or added. Referenced Files BENEFICRY - The Beneficiary file is accessed to ensure disability, employee life, defined contribution, and defined benefit plans are not deleted if beneficiaries exist. BNANNENR - BNCOMPANY - The Benefit Company Parameters file validates the company. BNCOVOPT - The Benefit Coverage Options file is accessed to validate the coverage option. BNFAMSTS - BNINVDETL - The Benefit Invoice Detail file ensures plans are not deleted if an invoice exists. BNNEWHIRE - BNPLNENR - BNPOSTCODE - The Benefits Postal Code file is updated with postal codes for the company. BNPRMOPT - The Benefit Premium Options file is accessed to validate contributions. BNWAIT - The Benefit Plan Waiting Period file contains waiting period data. CODA - The Cash Or Deferred Account History file contains employee account balances for defined contribution and defined benefit plans. COMPHIST - The Employee Compensation History file contains employee compensation history data. CONTRDETL - The Contribution Schedule Detail file is accessed verify company match information and to retrieve contribution limits and company match information. DEDCODE - The Deduction Code file is accessed to verify deductions. DEDFREQTBL - The Frequency Table is accessed to verify the deduction frequency table. DEPTCODE - The Department file is accessed to retrieve the department name. EMDEPEND - The Employee Dependent file is accessed to verify dependent information. EMTAMASTR - The Employee Time Accrual Master file is accessed to verify vacation maximum hours and costs. FLEXDOLLAR - The Flex Dollars file is used to verify flex dollar records. FLEXPLAN - The Flex Plan file is accessed to verify that flex plans exist. GLINTCO - HRHISTORY - The HR History file is accessed to retrieve annual salary for "as of" dates. HRSECLEV - The Employee Security Level file is accessed to verify the user security for updates. JOBCODE - The Job Code Parameters file is accessed to retrieve the job's annual hours for computing the salary. NAVIGATE - The Benefit Process Order file is accessed to display plan types in the user-defined order. ONETMDED - The Payroll One-Time Deduction file is accessed to ensure benefits are not deleted if a one-time deduction exists. PADICT - PAEMPLOYEE - The Employee Personnel Information file is accessed verify that the employee exists. PARTICIPNT - The Participant file is accessed to retrieve COBRA participant information. PASCRTY - The Data Item Attribute Parameters file is accessed to determine if a change should be logged. PAYDEDUCTN - The Employee Payment Deductions file is accessed to ensure benefits are not deleted if payments exist. PAYMASTR - PGEMPLOYEE - The Employee Group Employees file is accessed to retrieve all the employees in a group and to verify if an employee is in the group. PGSELECT - The Employee Group Selection Criteria file is accessed to retrieve the selection criteria for the employee group. PLAN - The Benefits Plan file is used to verify that a plan exists. PREMDEDHST - The Employee Deduction History file is accessed to ensure a benefit is not deleted if a deduction was taken. PROTPAYPRD - The Overtime Pay Periods file is accessed to retrieve the pay period start and end dates for entry verification. PROTWRKPRD - The Overtime Work Periods file is accessed to retrieve the work period start and stop dates for entry verification. PROVERTIME - The Overtime Pay Plan file is accessed to verify that the pay plan exists. PRRATEHIST - The Employee Rate History file is accessed to retrieve the salary for the "as of" date. PRSAGDTL - The Step and Grade Schedule Detail file is accessed to retrieve the salary if there is a pay step. PRSAGHEAD - The Step and Pay Schedule Header file is accessed to retrieve the salary for an employee with a pay step. PRSYSTEM - The HR Company and Process Levels file is accessed to verify that the company exists. PRTAXGRP - The Tax Group file is accessed. PRTAXLEVY - The Payroll Tax Levy file is accessed to verify the IRS levy table for the effective year. PRTIME - The Employee Pay/Hours History file is accessed to calculate the waiting period. PSGRELATE - The Pay Class/Pay Summary Group Relation file is accessed to determine if hours should be added or subtracted. RATETBLDTL - The Rate Table Detail file is accessed to retrieve the current rate. RATETBLHDR - The Rate Table Header file is used to verify rate table codes. RESTRANS - The Spending Account Transactions file is accessed to ensure benefits are not deleted if a spending account plan still exists. INVOKED Programs HRFN HRHI HRLO IFAC ACAC IFCR IFSG IFCU IFAU SLSE SLSU IFOB |