Bentek AdminBentek Administrator Guide ReportingHow to Run the Employment Terminations Report

How to Run the Employment Terminations Report

The Employment Terminations report provides detailed data for all employee records that have a status termination date that matches a date within the specified date range entered to generate the report. If the date range is set for 9/1/2012 through 9/30/2012, the report will contain all employee records that contain a status termination date that is on or after 9/1/2012, but no later than 9/30/2012. If an employee record contains a status termination date prior to 9/30/2012 such as 8/31/2012 or a status termination date after 9/30/2012 such as 10/1/2012, the employee record will not be included in the report. The report lists employee records in alphabetical order by last name and includes employee demographics, status termination date, terminated coverages, etc.

Please follow these steps to run an Employee Terminations Report:

Expand the "Status & Eligibility Reports" category.

Click on "Employee Terminations" from the left panel.

Select a format for the generated file (Excel, CSV, PDF).

Enter the desired date range using the Start Date and End Date fields.

Click "Run".

The Employment Terminations report will include the following columns:

  • Demographic Information: Columns will provide each employee's personal information (Social Security Number, First Name, Last Name, Date of Birth, Address, etc.)
  • Employment Status: The Employee Termination column will provide the date of termination for each employee listed and the Status column will indicate if the employee was an Active employee, a Retiree, or a COBRA employee.
  • Coverage Information: Each coverage that is terminated due to an employee's termination will be listed on a separate row within the report. The coverage name and tier will be listed under the Coverage and Tier columns, respectively.
  • Dependent Information: Dependent information for each dependent that is impacted by a terminated coverage listed within the report will be listed on a separate row. The dependent's full name, Social Security Number, and date of birth will be provided within the report.