transparency_plan

A plan a payer reports rates for, from the reporting_plans array of a table of contents. The rate files themselves do not name plans, so this is the only place plan identity comes from. Deduplicated across the whole table of contents, where the same plan is repeated once per reporting structure.

Primary Key:

• transparency_plan_id

Indexes:

• transparency_plan_uq (Unique) - plan_id, plan_id_type, plan_name, plan_sponsor_name, issuer_name, plan_market_type

Column	Data Type	Nullable	Indexed	Description
transparency_plan_id	bigint	No	Yes	Snowflake ID of the plan
plan_name	text	No	Yes	Payer's name for the plan
plan_id	text	No	Yes	Payer's identifier for the plan, kept as text because an EIN has meaningful leading zeros. Not unique, one employer identifier covers several named plans.
plan_id_type	transparency_plan_id_type	No	Yes	Which kind of identifier plan_id holds. The table of contents spells these in upper case and the loader lowers them.
issuer_name	text	No	Yes	Entity issuing the plan, which is the payer itself for a plan it insures and the administrator for one it only administers
plan_sponsor_name	text	Yes	Yes	Employer or other body sponsoring the plan. Blank for about 3% of plans, which name the sponsor only inside plan_name.
plan_market_type	transparency_plan_market_type	No	Yes	Market the plan is sold in