The Employment Terminations report provides detailed data for all member 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/2020 through 9/30/2020, the report will contain all records that contain a status termination date that is on or after 9/1/2020, but no later than 9/30/2020.

If a member record contains a status termination date prior to 9/30/2020 such as 8/31/2020 or a status termination date after 9/30/2020 such as 10/1/2020, the record will not be included in the report. The report lists records in alphabetical order by last name and includes demographics, status termination date, terminated coverages, etc.

The Employment Terminations report will include the following columns:

• Demographic Information: Columns will provide each member's personal information (Social Security Number, First Name, Last Name, Date of Birth, Address, etc.)
• Employment Status / Employee Termination: The Employee Termination column will provide the date of termination for each member listed and the Status column will indicate if the member was an Active employee, a Retiree, or COBRA member.
• Coverage Information: Each coverage that is terminated due to a member'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.

To run this report expand the Status & Eligibility Reports category and select Employment Terminations.
Enter appropriate Start and End Date, and Run.
Open report by selecting the Download icon.