All Payer Database

Background

New York State enacted legislation in 2011 that allowed for the creation of an All Payer Database (APD). The complexities of the health care system and the lack of comparative information about how services are accessed, provided, and paid for were the driving force behind this legislation. The goal of the APD is to serve as a key data and analytical resource for supporting policy makers and researchers.

In 2016, the New York State Department of Health (the Department) secured a warehousing and analytics vendor, issued proposed regulations, and started the implementation of the APD. The APD will house data from public and private insurance payers, including insurance carriers, health plans, third-party administrators, and pharmacy benefit managers, as well as Medicaid and Medicare. Eventually, the APD will add other health related data that includes functional assessments, surveys, public health registries, social determinants of health, and clinical data from electronic health records.

The APD is creating new capability within the Department, including more advanced and comprehensive analytics to support decision making, policy development, and research, while enhancing data security by protecting patient privacy through encryption and de-identification of potentially identifying information.

With the APD, the Department will have a comprehensive picture of the health care being provided to New Yorkers by supporting consumer transparency needs on quality, safety, and costs of care. The systematic integration of data technology and weaving of the previously fragmented sources of data will create a key resource to support data analyses that address health care trends, needs, improvements, and opportunities.

All Payer Database Guidance Manual (PDF)

APD Components

The APD consists of three main components:

Data Intake and Acquisition Warehousing Analytics
  • Encounters
  • Member
  • Provider
  • FFS Claims
  • Reference
  • Non Claims Based Data
  • Master Patient Index
  • Master Provider Index
  • Point in Time Storage
  • Data Enrichments
  • Limited Identifiable
  • Public User Files

APD Data Releases

October 31, 2018

The APD completed a second release of the All Payer Consolidated data model. The All Payer Consolidated data model now contains claims data for dates of service starting in Calendar Year 2014 through Q1 of 2017 for Medicaid, Child Health Plus, and Qualified Health Plans.

August 30, 2018

The APD completed a first release of the All Payer Consolidated data model. The All Payer Consolidated data model now contains:

  • Member data for dates of coverage starting Calendar Year 2014 through Q4 of 2017 for Medicaid, Child Health Plus, and Qualified Health Plans.
  • Issuer and plan data for Calendar Year 2014 through Q4 of 2017 for Medicaid, Child Health Plus, and Qualified Health Plans.
  • Provider data for Calendar Year 2014 through Q4 of 2017 for Medicaid, Child Health Plus, and Qualified Health Plans.

June 14, 2018

The APD completed a first release of the SPARCS and Vital Statistics Mortality data. This included SPARCS data for dates of discharge starting Calendar Year 2007 through current and Vital Statistics Mortality data for Calendar Year 2014 through 2017.

NYS Health Connector

The APD's public-facing website, the NYS Health Connector, launched on May 16, 2018. The NYS Health Connector is designed to function as a resource for consumers, researchers, and the general public by providing multiple data dashboards.

Visit the NYS Health Connector, for more information.