Data Comparison Utility

The Data Comparison Utility provides the means to compare data within the system to an external file (data source) through a Comma Separated Value (.csv) or Microsoft Excel file.

Layout Requirements:

  • The file must be in the format as documented under the "Layout" tab on the Data Comparison Utility screen. You can also find the layouts listed below at the bottom of this article.
  • The Import File must contain Column Headers.

Layouts_-_00.png

The Data Comparison Utility provides a convenient way to audit the following data:

  • Employee Data
  • Benefit Data
  • Compare Benefit Coverages for Employees in system to external file
  • Compare Benefit Coverages for Employees in system to external file using Benefit/Plan/Coverage Codes
  • compare Benefit Coverages for Employees in system to external file using Monthly Premium
  • Deduction Data

Data_Comparison_Utility_-_00.png

Layouts

  • Benefit Comparison - Standard Comparison

    Standard_Comparison_-_00.png

  • Benefit Comparison - Code Comparison

    Benefit_Comparison_-_00.png

  • Benefit Comparison - Monthly Premium Comparison

    Benefit_Comparison_Monthly_Premium.png

  • Benefit Comparison - Monthly Premium Comparison by Carrier

    Benefit_Comparison_Monthly_Premium_by_Carrier_-_00.png

  • Employee Comparison

    Employee_Comparison_-_00.png

  • Deduction Comparison

    Deduction_Comparison_-_00.png

Was this article helpful?
0 out of 0 found this helpful