Back to packs

ACORD Insurance Data Exchange

ACORDfree

10 data-quality rules for property & casualty insurance data exchanged in the ACORD standard (policy, party, coverage, and claim messages) between carriers, agencies, and partners. Covers required policy/party elements, line-of-business and state value sets, non-negative premium/limit, policy date logic, currency, and duplicate suppression. Use it to validate ACORD messages before exchange.

10 rules 0 downloadsNo ratings yet
acordinsurancep-and-cpolicydata-exchange
0.0(0 ratings)

Sign in to rate this pack

Test this pack with your data

Download the template, fill in your data, and see quality results instantly.

Test This Pack

Download & Install

Choose your tool — get a ready-to-run file

Run this on your data? Upload your CSV — we'll auto-map the columns, validate, and report the bad rows.Test my dataWant this certified on your data? Book a 30-min demo.Book a demo
Or use the CLI
$ npx dqhub install acord-insurance --format soda --table YOUR_TABLE

Reference data required

This contract's checks join against 2 reference tables. Load them into your warehouse — DQHub ships the public ones, the rest link to their source. All reference data →

About this pack

10 data-quality rules for property & casualty insurance data exchanged in the ACORD standard (policy, party, coverage, and claim messages) between carriers, agencies, and partners. Covers required policy/party elements, line-of-business and state value sets, non-negative premium/limit, policy date logic, currency, and duplicate suppression. Use it to validate ACORD messages before exchange.

What's included

3referential integrity rules
2completeness rules
2range rules
1format rules
1consistency rules
1uniqueness rules

Checks included (10)

Risk State Is Valid

The risk/governing state must be a valid US state code.

Currency Is Valid ISO 4217

Monetary amounts must use a valid ISO 4217 currency code.

Coverage References an Existing Policy

Every coverage must reference a policy that exists in the policy data.

Required Policy Fields Present

Each policy message must carry the policy number, named insured, line of business, and effective/expiration dates.

Policy Number Present(policy_number)

Each policy record must carry a policy number.

Premium Is Non-Negative(written_premium)

Written premium cannot be negative.

Coverage Limit Is Non-Negative(coverage_limit)

Coverage limits cannot be negative.

Line of Business Is Valid(line_of_business)

The line of business must be a recognized ACORD LOB code (e.g. AUTOP, HOME, CGL, WORK, CPKGE, UMBRL).

Effective Date Before Expiration

The policy effective date cannot be after its expiration date.

No Duplicate Policy Terms(policy_term_key)

A policy number + term (effective date) should appear once.