About this Dataset

Plan Attributes PUF - PY2024

The Plan Attributes PUF (Plan-PUF) is one of the files that comprise the Health Insurance Exchange Public Use Files. The Plan-PUF contains plan variant-level data on maximum out of pocket payments, deductibles, health savings account (HSA) eligibility, and other plan attributes.
Organization: U.S. Department of Health & Human Services
Last updated: 2023-10-30T09:52:42.905348
Tags: exchange-puf, marketplace-puf, plan-attributes, py2024

Tables

Table 1

@usgov.hhs_gov_plan_attributes_puf_py2024.table_1

1.38 MB
27374 rows
151 columns


CREATE TABLE table_1 (
  "businessyear" BIGINT,
  "statecode" VARCHAR,
  "issuerid" BIGINT,
  "issuermarketplacemarketingname" VARCHAR,
  "sourcename" VARCHAR,
  "importdate" TIMESTAMP,
  "marketcoverage" VARCHAR,
  "dentalonlyplan" VARCHAR,
  "standardcomponentid" VARCHAR,
  "planmarketingname" VARCHAR,
  "hiosproductid" VARCHAR,
  "networkid" VARCHAR,
  "serviceareaid" VARCHAR,
  "formularyid" VARCHAR,
  "isnewplan" VARCHAR,
  "plantype" VARCHAR,
  "metallevel" VARCHAR,
  "designtype" VARCHAR,
  "uniqueplandesign" VARCHAR,
  "qhpnonqhptypeid" VARCHAR,
  "isnoticerequiredforpregnancy" VARCHAR,
  "isreferralrequiredforspecialist" VARCHAR,
  "specialistrequiringreferral" VARCHAR,
  "planlevelexclusions" VARCHAR,
  "indianplanvariationestimatedadvancedpaymentamountperenrollee" VARCHAR,
  "compositeratingoffered" VARCHAR,
  "childonlyoffering" VARCHAR,
  "childonlyplanid" VARCHAR,
  "wellnessprogramoffered" VARCHAR,
  "diseasemanagementprogramsoffered" VARCHAR,
  "ehbpercenttotalpremium" DOUBLE,
  "ehbpediatricdentalapportionmentquantity" DOUBLE,
  "isguaranteedrate" VARCHAR,
  "planeffectivedate" TIMESTAMP,
  "planexpirationdate" TIMESTAMP,
  "outofcountrycoverage" VARCHAR,
  "outofcountrycoveragedescription" VARCHAR,
  "outofserviceareacoverage" VARCHAR,
  "outofserviceareacoveragedescription" VARCHAR,
  "nationalnetwork" VARCHAR,
  "urlforenrollmentpayment" VARCHAR,
  "formularyurl" VARCHAR,
  "planid" VARCHAR,
  "planvariantmarketingname" VARCHAR,
  "csrvariationtype" VARCHAR,
  "issueractuarialvalue" VARCHAR,
  "avcalculatoroutputnumber" DOUBLE,
  "medicaldrugdeductiblesintegrated" VARCHAR,
  "medicaldrugmaximumoutofpocketintegrated" VARCHAR,
  "multipleinnetworktiers" VARCHAR,
  "firsttierutilization" VARCHAR,
  "secondtierutilization" VARCHAR,
  "sbchavingababydeductible" VARCHAR,
  "sbchavingababycopayment" VARCHAR,
  "sbchavingababycoinsurance" VARCHAR,
  "sbchavingababylimit" VARCHAR,
  "sbchavingdiabetesdeductible" VARCHAR,
  "sbchavingdiabetescopayment" VARCHAR,
  "sbchavingdiabetescoinsurance" VARCHAR,
  "sbchavingdiabeteslimit" VARCHAR,
  "sbchavingsimplefracturedeductible" VARCHAR,
  "sbchavingsimplefracturecopayment" VARCHAR,
  "sbchavingsimplefracturecoinsurance" VARCHAR,
  "sbchavingsimplefracturelimit" VARCHAR,
  "specialtydrugmaximumcoinsurance" VARCHAR,
  "inpatientcopaymentmaximumdays" BIGINT,
  "beginprimarycarecostsharingafternumberofvisits" BIGINT,
  "beginprimarycaredeductiblecoinsuranceafternumberofcopays" BIGINT,
  "mehbinntier1individualmoop" VARCHAR,
  "mehbinntier1familyperpersonmoop" VARCHAR,
  "mehbinntier1familypergroupmoop" VARCHAR,
  "mehbinntier2individualmoop" VARCHAR,
  "mehbinntier2familyperpersonmoop" VARCHAR,
  "mehbinntier2familypergroupmoop" VARCHAR,
  "mehboutofnetindividualmoop" VARCHAR,
  "mehboutofnetfamilyperpersonmoop" VARCHAR,
  "mehboutofnetfamilypergroupmoop" VARCHAR,
  "mehbcombinnoonindividualmoop" VARCHAR,
  "mehbcombinnoonfamilyperpersonmoop" VARCHAR,
  "mehbcombinnoonfamilypergroupmoop" VARCHAR,
  "dehbinntier1individualmoop" VARCHAR,
  "dehbinntier1familyperpersonmoop" VARCHAR,
  "dehbinntier1familypergroupmoop" VARCHAR,
  "dehbinntier2individualmoop" VARCHAR,
  "dehbinntier2familyperpersonmoop" VARCHAR,
  "dehbinntier2familypergroupmoop" VARCHAR,
  "dehboutofnetindividualmoop" VARCHAR,
  "dehboutofnetfamilyperpersonmoop" VARCHAR,
  "dehboutofnetfamilypergroupmoop" VARCHAR,
  "dehbcombinnoonindividualmoop" VARCHAR,
  "dehbcombinnoonfamilyperpersonmoop" VARCHAR,
  "dehbcombinnoonfamilypergroupmoop" VARCHAR,
  "tehbinntier1individualmoop" VARCHAR,
  "tehbinntier1familyperpersonmoop" VARCHAR,
  "tehbinntier1familypergroupmoop" VARCHAR,
  "tehbinntier2individualmoop" VARCHAR,
  "tehbinntier2familyperpersonmoop" VARCHAR,
  "tehbinntier2familypergroupmoop" VARCHAR,
  "tehboutofnetindividualmoop" VARCHAR,
  "tehboutofnetfamilyperpersonmoop" VARCHAR
);