Commonly Used Reports

This article lists actions that Administrators are commonly trying to accomplish, and how to accomplish those actions using Maxwell system reports, including:

For more general information, read an overview of the reports functionality and a list of Maxwell system reports

To access reports, click Tools > Reports > Library.

Generate a list of employees and their dependents

Use the "Demographic Census Report" to pull a simple list of all employees, their dependents, and their basic demographic and employment information.

The report includes:

  • SSN
  • Prefix
  • First Name
  • Middle Name
  • Last Name
  • Suffix
  • SSN
  • Role
  • Date of Birth
  • Email
  • Gender
  • Disabled (yes or no)
  • Full-Time Student (yes or no)
  • Street Address
  • Suite / #
  • City
  • State
  • Zip Code
  • Eligibility Group
  • Date of Hire
  • Rehire Date
  • Termination Date
  • Termination Reason
  • Employee ID
  • Employment Status (active or inactive)
  • Employment Class
  • Title
  • Annual Salary
  • Home Phone
  • Work Phone
  • Cell Phone
  • First Login Date
  • Last Login Date
  • Plus any custom fields that have been created for your employer

Track employee progress through Open Enrollment

To track employee progress through and after Open Enrollment, in addition to viewing your Dashboard, run the “Enrollment Status Report.” This report is also helpful to run before your Open Enrollment starts to ensure eligible products have correct dates and are in the correct status.

This report includes a list of all employees and their:

  • First Name
  • Middle Name
  • Last Name
  • SSN
  • Eligibility Group
  • Employment Status (active or inactive)
  • Any custom fields  that have been created for your employer
  • Date of Hire
  • Rehire Date (if applicable)
  • Termination Date (if applicable)
  • Last Login Date
  • Product Open Enrollment Start Date
  • Product Open Enrollment End Date
  • Vendor Name
  • Product Name
  • Product Effective Date
  • Product End Date
  • Product Status
  • Product Intent
  • Product Checkout Date (date the employee submitted their enrollment)

Generate a list of terminated employees

To generate a list of terminated employees, head to the “Cost & Other Additional Reports” section and run the “Termination Report” (see a sample report).   

This report includes a list of all employees who have been terminated within a specified date range, and their:

  • Employee ID
  • Last Name
  • First Name
  • SSN
  • Eligibility Group
  • Date of Birth
  • Date of Hire
  • Termination Date
  • Termination Reason
  • Product information including covered dependents (for medical, dental, vision, FSA, and limited FSA products)

Note: this report will display all employees who had at least one enrolled product at the time they were terminated. If you need to identify terminated employees who were not enrolled in products (for example, because they were terminated during a new hire waiting period), run the "Qualifying Life Event Report," and set the filters to show only inactive employees.

Generate a list of new hires

To generate a list of new hires, head to the “Cost & Other Additional Reports” section and run the “Qualifying Life Event Report” (see a sample report). This report includes a list of QLEs experienced by employees within a specified date range. If no range is specified, it will include all QLEs (past, current, and future). If an employee has had several QLEs in the date range defined, there may be several rows for that employee. All types of QLEs will be listed, but to view just New Hire QLEs, filter the QLE Type column by highlighting the column, and clicking Data > Filter > check the New Hire box.  

The following information is included:

  • Employment Status (active or inactive)
  • Eligibility Group
  • Last Name
  • First Name
  • Middle Initial
  • Phone Number
  • SSN
  • Gender
  • Date of Birth
  • Date of Hire
  • Street Address & Suite/#
  • City
  • State
  • Zip Code
  • QLE Type
  • Date of Change
  • Date Admin Ended Change (by closing the QLE)
  • Termination Date (if applicable)
  • Termination Reason (if applicable)

Find the per pay period cost for products employees are currently enrolled in

To find the per pay period cost for products employees are currently enrolled in, head to the “Cost & Other Additional Reports,” run the “Product Cost Report - Total Cost per Pay Period (Currently Enrolled)” (see sample report).

This report includes:

  • Last Name
  • First Name
  • Email
  • SSN
  • Address / Suite/#
  • City
  • State
  • Zip Code
  • DOH
  • Eligibility Group
  • Pay Period Frequency
  • Employee and employer cost per pay period for each currently enrolled product
  • Tax status of a particular product (this can be helpful when reconciling payroll)

Note: this report will not include information on any products with pending elections. Run the “Product Cost Report - Total Cost per Pay Period - Pending Enrollment” for this information. 

Find the volume coverage for life and/or disability products 
To find the volume coverage for life and/or disability products, run either the “Coverage Report - Ancillary, Financial, Fitness, Extra - Horizontal” or “Coverage Report - All Products - Vertical” depending on the format you prefer.

These reports include a list of all employees and dependents currently enrolled in ancillary products, as well as their:

  • First Name
  • Last Name
  • SSN
  • Role (employee, child, or spouse)
  • DOB
  • Gender
  • Street Address
  • Suite / #
  • City
  • State
  • Zip Code
  • Disabled (yes or no)
  • Full-Time Student (yes or no)
  • Annual Salary
  • Eligibility Group
  • Title
  • Employment Status (active or inactive)
  • Any custom fields added to your employer
  • DOH
  • Rehire Date (if applicable)
  • Termination Date (if applicable)
  • Pay Frequency
  • Product information including effective dates, coverage level, disability benefit amount (if applicable), and volumes (including spouse and child volume if applicable)

Please note that this report will not include information on any ancillary products with pending elections. Run the “Pending Elections Report - Ancillary, Financial, Fitness, Extra - Horizontal” or “Pending Elections Report - All Products - Vertical.”

Access pending election information after Open Enrollment ends

Regardless of how you plan to submit Open Enrollment election information to the carrier, you’ll probably find it helpful to run Maxwell reports to get information out of the portal.

To see all pending elections (not just what has been changed or is new), go to Tools > Reports > Run Reports, choose the appropriate Pending Elections Report. For one with all products, select “Pending Elections Report - All Products - Vertical.”

So that you have less to do in Excel once your report is ready, set the following filters:

  • “Employment Status” to “active”
  • “Product Status” to “confirmed” and “selected”
  • “Coverage Dates” to the future effective date
  • Set the “Vendor” to the carrier you’re planning to submit the report to (if applicable)

To see just the changes and new additions from last year’s annual Open Enrollment, you should run the “Change Report.” The “Consolidated Changes” tab shows a full file of demographic and product changes and is great to send right to a carrier.  Learn more about Change Report here >

 

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