Drugs and formularies

Form 5500 Schedule H plan financials (claims paid, admin expenses, assets)

drug_silver.fact_form5500_financials·live·silver

Rows

1,513,019

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1DOL EFAST2 Form 5500 Schedule H rows: benefits actually paid (tot_distrib_bnft_usd), carrier-paid benefits, the itemized administrative-expense block including contract-administrator/TPA fees, contributions, income and beginning/end-of-year assets.
2This is the CLAIMS-PAID denominator: Schedule C says what the plan paid its vendors, Schedule A says what it paid its carrier and broker, and only Schedule H says what it paid for CARE.
3All 1,513,019 rows join to fact_form5500_filing on ack_id.
4First loaded 2026-07-26.

Grain

Key	Grain
N/A	1One row per filing that attached a Schedule H - key ack_id ALONE (Schedule H has no FORM_ID column); served plan years 2009-2025. 2Plan year 2025 is PARTIAL.

Columns (33)

Column	Type	Meaning
`ack_id`	string
`plan_year`	int
`sch_h_tax_prd`	string
`plan_number`	string
`sponsor_ein`	string
`tot_distrib_bnft_usd`	double
`ins_carrier_bnfts_usd`	double
`tot_corrective_distrib_usd`	double
`professional_fees_usd`	double
`contract_admin_fees_usd`	double
`invst_mgmt_fees_usd`	double
`other_admin_fees_usd`	double
`tot_admin_expenses_usd`	double
`tot_expenses_usd`	double
`tot_contrib_usd`	double
`tot_income_usd`	double
`tot_assets_boy_usd`	double
`tot_assets_eoy_usd`	double
`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

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`ack_id`
Join	`how_to_join(source_fqn="drug_silver.fact_form5500_financials")`
Raw door	Athena: drug_silver.fact_form5500_financials (filter is_current = true)

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