AI Benefits Census Generator

How Cassidy automates this using AI

Step 1: Trigger on census file upload

The Workflow activates when a broker uploads a census spreadsheet—whether it arrives via email, shared drive, or direct upload—regardless of format or layout.

Step 2: Parse and map to canonical schema

Cassidy's AI detects column headers across tabs and variations (e.g., "Birthdate," "DOB," "Date of Birth"), then normalizes employee and dependent records into a standardized data model with fields for name, DOB, gender, address, hire date, class, salary, tobacco status, and dependent relationships.

Step 3: Deduplicate and link records

Cassidy matches individuals across multiple files using name, DOB, and address, merging duplicates and linking dependents to the correct employees to create a single source of truth.

Step 4: Validate against eligibility and carrier rules

The Workflow applies business rules—waiting periods, FT/PT thresholds, class definitions, and line-of-coverage requirements—flagging missing salaries for LTD, incomplete dependent DOBs, or participation issues that would block quoting.

Step 5: Enrich and compute rating fields

Cassidy calculates rating ages based on effective date, derives tier assignments (EE/ES/EC/EF), and applies state-specific tobacco and sitused rules to prepare data for accurate quoting.

Step 6: Generate carrier-specific templates

The Workflow transforms the validated census into each carrier or GA portal's exact format—mapping fields, translating codes, and structuring employee vs. dependent rows as required—producing quote-ready files for medical, dental, vision, life, and ancillary lines.

Step 7: Deliver submission packet with Human-in-the-Loop review

Cassidy packages the carrier templates with validation summaries, exception reports, and participation counts, then routes to the broker for final review before submission—ensuring accuracy without sacrificing speed.