# Form 5500 filings (DOL EFAST2 main filing)

`drug_silver.fact_form5500_filing` · Drugs and formularies · status live · 4,330,525 rows

DOL EBSA public Form 5500 main-filing rows. The certified EFAST2 table is served for plan years 2009-2025 through pipelines/drug/ingest/form5500_runner.py; all pre-EFAST2 1999-2008 archive bytes are secured but remain outside the certified EFAST2 facts pending the exact deferred legacy lane.

**Grain.** One row per DOL EFAST2 Form 5500 main filing (natural key ack_id); served plan years 2009-2025. Pre-EFAST2 1999-2008 is secured but deferred to a separate legacy table family keyed by FILING_ID.

| column | type | meaning |
|---|---|---|
| ack_id | string |  |
| plan_year | int |  |
| form_plan_year_begin_date | string |  |
| form_tax_prd | string |  |
| plan_number | string |  |
| plan_name | string |  |
| plan_effective_date | string |  |
| sponsor_name | string |  |
| sponsor_dba_name | string |  |
| sponsor_ein | string |  |
| sponsor_state | string |  |
| sponsor_zip | string |  |
| business_code | string |  |
| total_participants_boy | int |  |
| type_pension_benefit_code | string |  |
| type_welfare_benefit_code | string |  |
| is_health_plan | boolean |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |
| funding_insurance_ind | boolean |  |
| funding_sec412_ind | boolean |  |
| funding_trust_ind | boolean |  |
| funding_gen_asset_ind | boolean |  |
| benefit_insurance_ind | boolean |  |
| benefit_sec412_ind | boolean |  |
| benefit_trust_ind | boolean |  |
| benefit_gen_asset_ind | boolean |  |
| admin_name | string |  |
| admin_ein | string |  |
| admin_signed_date | string |  |
| admin_signed_name | string |  |
| sponsor_signed_date | string |  |
| sponsor_signed_name | string |  |
| date_received | string |  |
| admin_name_same_as_sponsor_ind | boolean |  |
| amended_ind | boolean |  |
| final_filing_ind | boolean |  |
| short_plan_year_ind | boolean |  |
| welfare_health_ind | boolean |  |
| welfare_life_insurance_ind | boolean |  |
| welfare_supp_unemployment_ind | boolean |  |
| welfare_dental_ind | boolean |  |
| welfare_vision_ind | boolean |  |
| welfare_temp_disability_ind | boolean |  |
| welfare_prepaid_legal_ind | boolean |  |
| welfare_long_term_disability_ind | boolean |  |
| welfare_severance_pay_ind | boolean |  |
| welfare_apprenticeship_training_ind | boolean |  |
| welfare_scholarship_ind | boolean |  |
| welfare_death_benefit_ind | boolean |  |
| welfare_housing_assistance_ind | boolean |  |
| welfare_other_benefit_ind | boolean |  |
| welfare_will_not_file_next_year_ind | boolean |  |
| welfare_stopped_filing_earlier_ind | boolean |  |
| welfare_ten_or_more_employer_ind | boolean |  |
| welfare_collectively_bargained_ind | boolean |  |
| active_participants_eoy | int |  |
| retired_separated_receiving_eoy | int |  |
| total_participants_eoy | int |  |

Tools that read it: pbm_compensation_rollup

Query it: `query_substrate` with `SELECT ... FROM drug_silver.fact_form5500_filing WHERE ... LIMIT 100`; read `describe_data_source("drug_silver.fact_form5500_filing")` first.