VladaOmega
Sign inStart free
Medicare Advantage, Part D, Medicaid

MA network intelligence: active grade per listed provider (Medicare billing and enrollment)

medicare_silver.ma_network_active_v1·partial·mart
Rows
N/A
Columns
8
History
N/A
Card
nocolumns only
Typed tools
1

What it is

  1. 1The network lockdown's active check (docs/data-tracker/network-intel/LOCKDOWN-LEDGER.md N1): whether Medicare's own files confirm a listed provider is active.
  2. 22027: 1,570,066 billing-type providers, A 52.9%, B 39.8%, C 7.4%.

Grain

KeyGrain
N/A
  1. 1One row per plan_year x listed NPI: provider_class, specialty, enrolled_medicare (PECOS), billed_medicare_year (CMS billing file), contracts_listing, medicare_billing_type, active_grade (A billed Medicare in the newest year, B enrolled only, C neither, n/a a type that does not bill Medicare).
  2. 2Partitioned by dataset_id, plan_year.

Columns (8)

ColumnTypeMeaning
npistring
provider_classstring
specialtystring
enrolled_medicareboolean
billed_medicare_yearint
contracts_listingbigint
medicare_billing_typeboolean
active_gradestring

Query it

describe_data_source(source_fqn="medicare_silver.ma_network_active_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.ma_network_active_v1 WHERE <filter> LIMIT 100")
ItemValue
Typed tools that read itget_plan_network
Identity keynpi
Joinhow_to_join(source_fqn="medicare_silver.ma_network_active_v1")
Raw doorAthena (read-only via query_substrate): medicare_silver.ma_network_active_v1 (pin dataset_id and plan_year; read active_grade only where medicare_billing_type)

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