State programs

Medicaid managed-care subcontract and delegated-function observations

medicare_silver.org_subcontract·partial·silver

Rows

506

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Source-name subcontract observations from California, Georgia, Illinois, and Minnesota, including 282 additional Minnesota December 2018 delegation-form name cells with raw function and program flags.
2Evidence URL/SHA, date basis, and reported function are preserved.
3Legal identities and member attribution remain unresolved.

Grain

Key	Grain
N/A	1One source-reported prime-to-subcontractor observation per subcontract_id; source_relationship_basis separates functional delegation reports from Georgia's thresholded business transactions.

Columns (37)

Column	Type	Meaning
`subcontract_id`	string
`state_code`	string
`prime_legal_entity_id`	string
`prime_name`	string
`subcontractor_legal_entity_id`	string
`subcontractor_name`	string
`subcontractor_parent_id`	string
`valid_from`	string
`valid_to`	string
`date_basis`	string
`members`	string
`evidence`	string
`confidence`	string
`note`	string
`county_or_region`	string
`program_type`	string
`function`	string
`members_as_of`	string
`evidence_sha256`	string
`prime_legal_entity_candidate_id`	string
`subcontractor_legal_entity_candidate_id`	string
`subcontractor_parent_candidate_id`	string
`prime_identity_status`	string
`subcontractor_identity_status`	string
`parent_identity_status`	string
`identity_status`	string
`identity_confidence`	string
`source_relationship_basis`	string
`source_report_year`	string
`reported_function`	string
`source_cell_group_id`	string
`source_cell_member_count`	string
`source_actor_class`	string
`medicaid_specificity`	string
`source_review_tier`	string
`source_csv_sha256`	string
`spine_review_status`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`subcontract_id`
Join	`how_to_join(source_fqn="medicare_silver.org_subcontract")`
Raw door	Athena read-only: medicare_silver.org_subcontract. Filter state_code, program_type, function, and source_relationship_basis; inspect date_basis and evidence_sha256.
Note	California Health Net to Molina is delegated network/services from 2024-01-01; neither risk transfer nor additive member count is established. Illinois and Minnesota rows are historical roster observations.

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