Plan ID Crosswalk PUF

data.healthcare.gov | Last Updated 11 Dec 2017

The Plan ID Crosswalk PUF (CW-PUF) is one of the seven files that make up the Marketplace PUF. The purpose of the CW-PUF is to map QHPs and SADPs offered through the Marketplaces in 2014 to plans that will be offered through the Marketplaces in 2015. These data either originate from the Plan Crosswalk template (i.e., template field), an Excel-based form used by issuers to describe their plans in the QHP application process, or were generated by CCIIO for use in data processing (i.e., system-generated).This data dictionary describes the variables contained in the CW-PUF. Each record relates to a mapping between a plan offered in 2014 and a plan offered in 2015 at the county or county-zip code level.

This dataset has the following 21 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
StatestatetextTwo-character state abbreviation indicating the state where the plan is offered
Dental PlandentalplantextCategorical indicator that plan is a stand-alone dental plan (SADP)
2014 Plan IDplanid_2014textFourteen-character alpha-numeric code that identifies the 2014 insurance plan in the Health Insurance Oversight System (HIOS)
2014 Issuer IDissuerid_2014textFive-digit numeric code that identifies the issuer organization in HIOS for the 2014 plan
2014 Multistate Planmultistateplan_2014textCategorical indicator of whether the 2014 plan is a multi-state plan
2014 Metal Levelmetallevel_2014textMetal level, or coverage category, of the 2014 plan based on its actuarial value
2014 Child Adult Onlychildadultonly_2014textThe types of child enrollment options for the 2014 plan
FIPS CodefipscodetextFederal Information Processing Standards (FIPS) code assigned to the county within a state that is included in the plan’s service area
Zip CodeszipcodetextFive-digit zip code within the partial-county region included in the plan’s service area
Crosswalk LevelcrosswalkleveltextCategorical indicator of the crosswalk level
Reason for CrosswalkreasonforcrosswalktextCategorical indicator of the reason for the crosswalk
2015 Plan IDplanid_2015textFourteen-character alpha-numeric code that identifies the 2015 insurance plan in HIOS
2015 Issuer IDissuerid_2015textFive-digit numeric code that identifies the issuer organization in HIOS for the 2015 plan
2015 Multistate Planmultistateplan_2015textCategorical indicator of whether the 2015 plan is a multi-state plan
2015 Metal Levelmetallevel_2015textMetal level, or coverage category, of the 2015 plan based on its actuarial value
2015 Child Adult Onlychildadultonly_2015textThe types of child enrollment options for the 2015 plan
2015 Age Off Plan IDageoffplanid_2015textFourteen-character alpha-numeric code that identifies the plan available to enrollees who will age-off (i.e., no longer meet the criteria for continued eligibility) the 2014 plan prior to January 1, 2015
Issuer ID for 2015 Age Off Planissuerid_ageoff2015textFive-digit numeric code that identifies the issuer organization in HIOS for the 2015 plan identified in the AgeOffPlanID_2015 field
2015 Age Off Multistate Planmultistateplan_ageoff2015textCategorical indicator of whether the 2015 age off plan is a multi-state plan
2015 Age Off Metal Levelmetallevel_ageoff2015textMetal level of the 2015 age off plan based on its actuarial value
2015 Age Off Child Adult Onlychildadultonly_ageoff2015textThe types of child enrollment options for the 2015 age off plan