|
|
BN531 - Batch Benefit Enrollment
**Form Purpose
Run Batch Benefit Enrollment (BN531) to import benefits from CSV (Comma
Separated Value) files.
**Processing Effect
BN531 adds benefits the same way benefits are added in BN31.1 (Speed Benefit
Entry). Before you run BN531, make sure all plans have been defined for the
benefits you are loading.
**Troubleshooting
When you run BN531, the application creates an error file called BNBATCHERR.
The BNBATCHERR file contains columns for two specific types of errors:
DftPreCont and AftTaxToSpend.
DftPreCont: The negative values in this column reflect the portion of the
contribution that must be made after tax.
AftTaxToSpend: The value in this column reflects the total contribution cost.
To make corrections, fix the errors indicated in the DftPreCont and
AftTaxToSpend columns. Then delete the columns before you run the BNBATCHERR
file.
**More Information
BN531 creates a report showing which benefits were loaded, the cost of each
benefit, and an error report of benefits not loaded.
For detailed information on loading benefits, see the Human Resources
Conversion Technical Guide.
Updated Files
BENEFIT - The Employee Benefit file contains employee benefit records
for all benefit types.
BNCOMMENTS - The Benefit Comments file is updated with comments.
BNTRANS -
CKPOINT - The Check Point file is used to allow recovery.
EMDEDMASTR - The Employee Deduction file is updated.
EMPFLEXDOL - The Employee Flex Dollars file is updated.
EMPFLEXREM - The Employee Flex Period Dollars file is updated.
EMPINVEST - Employee Benefit Investment Distribution file is updated.
EMPLOYEE - The Employee file is updated with the last deduction sequence
number. The file also verifies that the employee exists.
HRDEPBEN - The Dependent Benefits file is updated.
HRHISTORY - The Garnishment Parameters file is accessed to verify that
garnishment information exists if the deduction is a
garnishment, and verify tax levy information.
PRREGPARM -
STANDTIME - The Payroll Standard Time Record is updated.
Referenced Files
BENEFICRY - The Beneficiary file is used to verify beneficiaries.
BNACCOUNTS - The Benefit Accounts file validates general ledger override
account information.
BNANNENR -
BNCOMPANY - The Benefit Company Parameters file is used to verify company
information.
BNCOVDFT - The Benefit Coverage Defaults 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.
BNCOVOPT - The Benefit Coverage Options file is accessed to validate the
coverage option.
BNFAMSTS -
BNINVEST -
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 used to verify
contribution schedule detail.
DEDCODE - The Deduction file is used to verify benefit deductions.
DEDFREQTBL - The Frequency Table file is used to verify deduction cycles
for deductions created.
EMDEPEND - The Employee Dependent file is used to access employee
dependent files.
EMTAMASTR - The Employee Time Accrual Master file is accessed by this
program.
FLEXDOLLAR - The Flex Dollars file is used to verify flex dollar records.
FLEXPLAN - The Flex Benefit Plan file is used to verify flex plans.
GLCODES -
GLINTCO -
GLSYSTEM -
HRHISTORY - The Garnishment Parameters file is accessed to verify that
garnishment information exists if the deduction is a
garnishment, and verify tax levy information.
HRSECLEV - The Employee Security Level file is accessed by this program.
JOBCODE - The Job Code Parameters file is used to verify job code annual
hours.
NAVIGATE - The Benefit Entry Navigation file contains navigation records.
OCCURTYPE -
ONETMDED - The Payroll One-time Deduction file is accessed by this
program.
PADICT -
PAEMPLOYEE - The Employee PA Information file is used to verify employees.
PARTBEN - The COBRA Participant Benefit file is accessed to retrieve the
coverage option and benefit coverage information for COBRA
participants and retirees.
PARTICIPNT -
PASCRTY - The Data Item Attribute Parameters file is used to determine
whether a field should be logged in the logfile.
PAYDEDUCTN - The Employee Payment Deductions file is accessed to ensure
benefits are not deleted if payments exist.
PAYMASTR -
PCODES -
PGEMPLOYEE - The Employee Group Employees file is used to verify employees
in an employee group.
PGSELECT - The Employee Group Selection Criteria file is accessed to
retrieve the selection criteria for the employee group.
PLAN - The Benefit Plan file is used to verify health plans.
PREMDEDHST - The Employee Deduction History file is accessed by this
program.
PREMIUM - The Benefit Plan Premium file is used to verify premium
amounts.
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 used when payroll
run flags are updated for mid-year or mid-cycle flex changes.
PRTAXAUTH -
PRTAXLEVY - The Payroll Tax Levy file is accessed by this program.
PRTAXLOC -
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 by this program.
RATETBLHDR - The Rate Table Header file is used to verify rate table codes.
RESTRANS - The Spending Account Transactions file is accessed by this
program.
SPHIST - The Stock Purchase Plan History file is accessed to retrieve
the total cost of the stock an employee has.
TAEEMASTER -
INVOKED Programs
HRHI
HRLO
IFAC
ACAC
ACCL
ACTA
API4
IFCU
IFOB
IFSG
IFLU
IFAU
SLSE
SLSU
|
