Census Exceptions
Data problems are found before the census leaves the building, not after the carrier questions it.
Open Exceptions
15
15 raised in total
High Severity
5
Resolve before release
Benefits Without Active Employment
4
Terminated employees still carrying coverage
Cost Impact
$248,483
Annualized employer cost at risk
Exceptions by rule
Validation rules run across employment, election, dependent and rate data.
| Terminated employee receiving active benefits | 4 | 4 | 4 | $129,523 |
|---|---|---|---|---|
| Coverage tier does not agree with dependent record | 7 | 7 | 0 | $76,156 |
| Missing dependent relationship detail | 3 | 3 | 0 | $0 |
| Employee-only coverage with covered dependents | 1 | 1 | 1 | $42,804 |
Exception queue as of 2025-12-31
15 records
| CEX-1 | Terminated employee receiving active benefits | High | E1005 | Restricted | Terminated 2025-11-14 but medical election High Deductible + HSA remains in force on 2025-12-31. | $27,216 | Open | — |
|---|---|---|---|---|---|---|---|---|
| CEX-2 | Coverage tier does not agree with dependent record | Medium | E1005 | Restricted | Declared Employee + Children; dependent record derives Employee + Child. Employer cost billed on the derived tier. | $9,121 | Open | — |
| CEX-3 | Coverage tier does not agree with dependent record | Medium | E1013 | Restricted | Declared Employee + Children; dependent record derives Employee + Child. Employer cost billed on the derived tier. | $10,476 | Open | — |
| CEX-4 | Coverage tier does not agree with dependent record | Medium | E1025 | Restricted | Declared Employee + Children; dependent record derives Employee + Child. Employer cost billed on the derived tier. | $10,476 | Open | — |
| CEX-5 | Missing dependent relationship detail | Low | E1027 | Restricted | Dependent D-1035 is recorded as "Other Eligible Dependent" without supporting relationship documentation. | — | Open | — |
| CEX-6 | Coverage tier does not agree with dependent record | Medium | E1034 | Restricted | Declared Employee + Children; dependent record derives Employee + Child. Employer cost billed on the derived tier. | $10,476 | Open | — |
| CEX-7 | Missing dependent relationship detail | Low | E1050 | Restricted | Dependent D-1078 is recorded as "Other Eligible Dependent" without supporting relationship documentation. | — | Open | — |
| CEX-8 | Terminated employee receiving active benefits | High | E1056 | Restricted | Terminated 2025-11-14 but medical election High Deductible + HSA remains in force on 2025-12-31. | $29,246 | Open | — |
| CEX-9 | Coverage tier does not agree with dependent record | Medium | E1071 | Restricted | Declared Employee + Children; dependent record derives Employee + Child. Employer cost billed on the derived tier. | $9,121 | Open | — |
| CEX-10 | Terminated employee receiving active benefits | High | E1073 | Restricted | Terminated 2025-08-29 but medical election Select HMO remains in force on 2025-12-31. | $32,806 | Open | — |
| CEX-11 | Coverage tier does not agree with dependent record | Medium | E1073 | Restricted | Declared Employee + Spouse; dependent record derives Employee + Family. Employer cost billed on the derived tier. | $15,064 | Open | — |
| CEX-12 | Terminated employee receiving active benefits | High | E1090 | Restricted | Terminated 2025-11-14 but medical election Core PPO remains in force on 2025-12-31. | $40,255 | Open | — |
| CEX-13 | Employee-only coverage with covered dependents | High | E1096 | Restricted | 1 covered dependent(s) exist but the election is recorded as Employee Only. | $42,804 | Open | — |
| CEX-14 | Missing dependent relationship detail | Low | E1096 | Restricted | Dependent D-1156 is recorded as "Other Eligible Dependent" without supporting relationship documentation. | — | Open | — |
| CEX-15 | Coverage tier does not agree with dependent record | Medium | E1099 | Restricted | Declared Employee + Children; dependent record derives Employee + Child. Employer cost billed on the derived tier. | $11,422 | Open | — |
Open items block the annual census releaseResolutions are retained with the census version
Validation engine run against Oracle HCM employment segments, Oracle Benefits elections, the dependent register and the effective-dated rate table for 2025-12-31.