Delaware Health Information Network

Delaware Health Care Claims Database

The Delaware Health Care Claims Database (HCCD), powered by DHIN, is the single largest repository of claims data Delaware has ever had.

The HCCD Makes Health Data More Useful

The HCCD collects healthcare claims, enrollment and provider data from Medicare, Medicaid and the seven largest commercial health insurers in the State of Delaware. 

The HCCD can help lawmakers and decision-makers:

An Investigation into Opioid Prescriptions and
ED Events in Delaware 2016-2020

Over the past ten years, Delaware has implemented multiple programs to combat
drug abuse, particularly opioids, due to their rising prevalence in Delaware.

HCCD Data Submission Forms

Applications for Data Element Threshold and Product Line and Line of Business Waiver

How to Request Access to the HCCD

Please use this application to submit information
regarding your request for HCCD data or data access

This agreement addresses the terms and
conditions under which DHIN will release and the
requesting organization may obtain, use, and
disclose HCCD data specified in this Agreement

Business rules for reviewing data requests

4.6 After a decision is reached by the Committee, public
notice will be posted on the DHIN website that an application
for data access was received, by whom it was submitted and
for what purposes, and the decision of the Committee to
grant or deny the application. The final determination of the
Committee shall not be subject to appeal.

Commonly used HCCD terms

Mandatory Reporting Entities

  • All Health Insurers providing healthcare coverage to a Delaware resident; and
  • All Health Insurers that provide a Delaware State Group Health Insurance Plan, regardless of the state of residence of the member. This includes any entity that receives or collects charges, contributions, or premium for, or adjusts or settles, health claims for, any State employee or their spouses or dependents, participating in the State Group Health Insurance Program.

Health Insurer

The term Health Insurer is defined in § 4004 of Title 18 and includes insurers, third-party administrators (TPA), pharmacy benefits managers (PBMs), and other carve-out payers that offer a service benefit plan. Health insurer does not include providers of casualty insurance, as defined in § 906 of Title 18; providers of group long-term care insurance or long-term care insurance, as defined in § 7103 of Title 18; or providers of a dental plan or dental plan organization,
as defined in § 3802 of Title 18.

Covered Lives

The term covered lives includes all Delaware residents; members and their dependents for employersponsored coverage; and all members of the State Group Health Insurance program regardless of state of residence. Mandatory Reporting Entities with fewer than a total of 1,000 covered lives (across all lines of business) may request an exemption from data submission but are still required to complete the Annual Registration Form.

Commonly asked questions related to HCCD data submission

Claims previously reported to the HCCD as paid and subsequently adjudicated as a wholly denied claim must be reported to the HCCD. Otherwise, wholly denied claims are not required to be included in HCCD submissions and may be included voluntarily. Wholly denied claims refer to claims in which all lines are denied.

For partially denied (i.e., some claim lines are paid), the entire claim must be submitted to the HCCD – including the denied lines. For this reason, Table B.1.F Claim Status of the DSG has been revised to include additional valid values. Information on partially-denied claims will assist in analyses of performed services and assist in claims versioning efforts.

All files submitted to the HCDD must be formatted as standard text files and must follow the format guidelines found in Section 5.1 of the DSG.

There are three sections for all four HCCD file types: the header, detail records, and trailer sections. All three sections should be submitted in a single file, and all three sections should contain the name of the data column, delimited using the pipe character, followed by the row(s) of information, also delimited using the pipe character. Below is an abridged example of how a member eligibility file should be submitted to the HCCD. The example below is for a data submitter who only has two enrolled members during the reporting period (for example purposes only). The example below also has the section names underlined; these section names SHOULD NOT appear in the actual submission and are included for clarification purposes only.

 

Header Record Example

Record Type ǀ Reporting Entity Code ǀ Reporting Entity Name ǀ Beginning Month ǀ Ending Month ǀ Record Count

ME ǀ DE100 ǀ SubmitterName ǀ 202403 ǀ 202403 ǀ 2

 

Detail Example

Reporting Entity Code ǀ Reporting Entity Name ǀ Insurance Type Code/Product ǀ Year ǀ Month ǀ Insured Group or Policy Number ǀ Coverage Level Code…….

DE100 ǀ SubmitterName ǀ MM ǀ 2024 ǀ 03 ǀ 12092284 ǀ IND

DE100 ǀ SubmitterName ǀ MM ǀ 2024 ǀ 03 ǀ 13462537 ǀ FAM

 

Trailer Record Example

Record Type ǀ Reporting Entity Code ǀ Reporting Entity Name ǀ Beginning Month ǀ Ending Month ǀ Extraction Date

ME ǀ DE100 ǀ SubmitterName ǀ 202403 ǀ 202403 ǀ 20240430

There is no prescribed format for the historic data Summary Report. The total number of members in each month of historic data can be provided to DHIN in whatever format is preferable for the Data Submitter (e.g. email, Excel document via SFTP, etc.).

As outlined in the Data Collection Regulation, dental claims are currently not required to be submitted to the HCCD. Behavioral health claims, however, fall under the definition of “Medical Claims” as per 16 Del.C. §10312(8), and therefore must be included in data submissions to the HCCD.

The Employer Tax ID and Employer Group Name are required when submitting records for the State Group Health Insurance plans and individual policies (e.g., Medicare Advantage plan) must be reported as “IND”. Reporting on any other plans is optional.

The Provider File should include information on all of the billing providers, rendering service providers, prescribing providers, and pharmacies with associated medical and pharmacy claims during the reporting period. That being said, DHIN understands that payers will not always have complete information on out-of-network providers and therefore ask that as much information as possible be included for out-of-network providers, and all information be provided for in-network providers.

In instances where a single provider has more than one “entry” in a data submitters database (e.g. they serve as both billing and performing providers, they have multiple NPIs, etc.), the data submitter should report each provider entry separately. 

In the event the same provider delivered and was reimbursed for services rendered from two different physical locations, then the provider data file shall contain two separate records for that same provider reflecting each of those physical locations. One record shall be provided for each unique physical location for a provider.

Metallic levels are the plan categories assigned to Marketplace Plans. This field is required for small group and non-group (individual) plans sold inside or outside the Marketplace. Plan categories are listed on the exchange as gold, silver, bronze, platinum, and catastrophic. The Catastrophic Plan category, previously omitted for the DSG, was added to Version 4.0 Rev. DSG.

Yes, the placeholder field ME108 was replaced with a new data element: High Deductible Plan Indicator.

The History of the HCCD

The Delaware General Assembly passed legislation in FY16 authorizing the Delaware Health Information Network to develop a healthcare claims database.

The purpose of the HCCD is to facilitate data-driven, evidence-based improvements in access, quality, and cost of healthcare and to promote and improve the public health through increased transparency of accurate claims data and information.

View Findings; purpose; creation (delaware.gov)

§ 10311 The Delaware Health Care Claims Database

Top