Skip to main content

/network-state-gaps

Identify network-state gaps where all rates are outliers, then update network_mappings.py to remove those states.

Usage​

/network-state-gaps

No arguments required. The skill runs an analysis query and then applies changes to the airflow DAGs repo.

What It Does​

  1. Runs an analysis query against Trino that aggregates rate data by network type, payer, network name, and state. It identifies combinations where every rate is an outlier (canonical_rate_score <= 1), meaning there are zero non-outlier rates for that network-state pair.

  2. Checks for unstaged changes in the airflow_dags repo. If there are uncommitted changes, the skill stops and alerts you before making any edits.

  3. Cross-references the gaps with the network mapping lists in network_mappings.py (PPO, HMO, Narrow, Exchange, Custom PPO, Custom HMO, Medicare Advantage). For each matching entry, it removes the gap state from the states list. If all states in an entry are gaps, the entire entry is commented out.

  4. Shows you the identified gaps before making edits, and summarizes all changes after.

Inputs​

  • None — the query and target file are predefined in the skill.

Outputs​

  • A table of identified network-state gaps (network type, payer ID, network name, state)
  • A CSV saved to research/.claude/skills/network-state-gaps/tmp/network_state_gaps.csv
  • Edits applied to airflow_dags/.../utils/network_mappings.py
  • A summary of all changes made
On this page: