States M6 Ownership + subcontracting: medicaid_plan_subcontract_v1

What it is

1. 1Medicaid product M6 (Ownership + subcontracting) of the States lane: who owns each Medicaid managed care plan and who it subcontracts to: the reviewed plan-to-parent bridge, the state ownership disclosures and the plan subcontracts. vw_medicaid_mco_ownership_bridge_v1: one reviewed decision per plan identity, effective-dated (effective_start, effective_end); read the row whose interval covers your date. org_control_disclosure: one row per disclosed owner, ownership_percent as printed; a plan can list several owners and the percents need not sum to 100. medicaid_plan_subcontract_v1 (the subcontracting half): one row per state x plan (canonical id, dated parent) x function (pharmacy_pbm, dental, vision, behavioral_health, nemt) x subcontractor, dated valid_from / valid_to; arrangement says delegated_subcontract, affiliate_subcontract, plan_performs or carved_out_state_program. status = not_published rows are findings, never zero or absence.
2. 2A delegate's members are never added to the prime's, and a delegated network is not a full-risk transfer.
3. 33 state(s): FL PA TX.

Grain

Columns (41)

Query it

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