Drugs and formularies

Form 5500 filings (DOL EFAST2 main filing)

drug_silver.fact_form5500_filing·live·silver·Form 5500 Filings & Service Providers

Rows

4,330,525

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1DOL EBSA public Form 5500 main-filing rows.
2The 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

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

Columns (72)

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

Query it

describe_data_source(source_fqn="drug_silver.fact_form5500_filing")     # the card, live
query_substrate(sql="SELECT * FROM drug_silver.fact_form5500_filing WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	pbm_compensation_rollup
Identity key	`ack_id`
Join	`how_to_join(source_fqn="drug_silver.fact_form5500_filing")`
Raw door	Athena: drug_silver.fact_form5500_filing (filter is_current = true)
Note	Terminal state complete_and_served with a documented pre-EFAST2 source limit; legacy archive inventory and S3 manifest: docs/reference/source-audit/source-mastery/manifests/large-wave/form5500.json.

This page as markdown: /docs-md/data/drug_silver_fact_form5500_filing.md · every page in one file: /llms-full.txt