Northstar Payer Operations
Environment Access
The task prompt provides the environment base URL. Substitute it for <TASK_ENV_BASE_URL> in all requests below.
Authorization — send this header with every SQL request:
Authorization: Bearer pa-review-token-014
Key endpoints:
| Method |
Path |
Purpose |
| GET |
/portal |
Portal overview |
| GET |
/api/tables |
Full database schema |
| GET |
/api/cases |
All cases |
| GET |
/api/cases/{case_id} |
Single case |
| GET |
/api/policies |
All policies |
| GET |
/api/policies/{policy_id} |
Single policy |
| GET |
/api/documents/{document_id} |
Single document |
| GET |
/api/rate-schedules |
Rate schedules |
| GET |
/api/appeals |
All appeals |
| POST |
/sql/query |
SQL access |
SQL Access
Send a POST with JSON body {"query": "<SQL>"} and the bearer header. The database is SQLite — use standard SQLite syntax.
Always read the schema first with GET /api/tables or consult schema.md. The key join anchor across most tables is case_id.
Domain Identification
Read the task prompt and task_context.json to determine the domain:
| Signal |
Domain |
Source Precedence |
| "UM nurse", prior authorization, physical therapy |
Prior Authorization |
current_clinical_records_over_stale_export |
| "pharmacy appeals", "manufacturer assistance", drug name |
Pharmacy Appeal + Assistance |
payer_appeal_before_manufacturer_assistance |
| "payment integrity", claim repricing, benchmark |
Payment Integrity |
effective_benchmark_by_plan_modifier_and_date |
| "peer-to-peer", P2P, completed discussion |
Peer-to-Peer |
new_patient_specific_p2p_information |
| "UM-finance", margin queue, revenue-to-cost |
Margin Queue |
margin_threshold_then_charge_sensitivity |
Each domain follows one of the workflows described in workflows.md. Load that file once the domain is identified.
General Pattern
- Query the database for the target business ID (case, claim, appeal, or queue row).
- Follow the joins outward to related tables (documents, criteria, benchmarks, drug trials, etc.).
- Apply the domain's decision rules using the evidence.
- Build the
basis_audit object with source_precedence, controlling_record_ids, exception_record_ids, and precedence_record_order.
- Return exactly the JSON shape required by the task's
answer_template.json.
Basis Audit
Every output includes a basis_audit. The source_precedence value is domain-specific (see table above). Construct the lists as follows:
- controlling_record_ids: The environment record IDs that directly control the result — relevant documents, criteria results, benchmarks, P2P events, or margin rows that drove the determination.
- exception_record_ids: Records that explain exclusions, denials, missing information, or route priority. Gap records (missing criteria, missing packet items) come before stale or excluded records.
- precedence_record_order: All controlling and exception records ordered by source precedence, highest priority first.
1---2name: northstar-payer-ops-253description: "Northstar Health Plan payer operations environment for utilization management, pharmacy appeals, payment integrity, peer-to-peer review, and therapy margin analysis. Use when the task involves Northstar prior authorization case review, coverage appeal and manufacturer assistance intake, cardiac imaging claim repricing, P2P authorization summaries, or UM-finance therapy margin queue analysis — any structured determination against the payer operations API and SQL backend."4license: MIT5compatibility: deepagents-code6metadata:7 source: https://skillmd.com/skills/prism-shadow/northstar-payer-ops-258---910# Northstar Payer Operations1112## Environment Access1314The task prompt provides the environment base URL. Substitute it for `<TASK_ENV_BASE_URL>` in all requests below.1516**Authorization** — send this header with every SQL request:1718```19Authorization: Bearer pa-review-token-01420```2122**Key endpoints**:2324| Method | Path | Purpose |25|--------|------|---------|26| GET | `/portal` | Portal overview |27| GET | `/api/tables` | Full database schema |28| GET | `/api/cases` | All cases |29| GET | `/api/cases/{case_id}` | Single case |30| GET | `/api/policies` | All policies |31| GET | `/api/policies/{policy_id}` | Single policy |32| GET | `/api/documents/{document_id}` | Single document |33| GET | `/api/rate-schedules` | Rate schedules |34| GET | `/api/appeals` | All appeals |35| POST | `/sql/query` | SQL access |3637## SQL Access3839Send a POST with JSON body `{"query": "<SQL>"}` and the bearer header. The database is SQLite — use standard SQLite syntax.4041Always read the schema first with `GET /api/tables` or consult [schema.md](references/schema.md). The key join anchor across most tables is `case_id`.4243## Domain Identification4445Read the task prompt and `task_context.json` to determine the domain:4647| Signal | Domain | Source Precedence |48|--------|--------|-------------------|49| "UM nurse", prior authorization, physical therapy | **Prior Authorization** | `current_clinical_records_over_stale_export` |50| "pharmacy appeals", "manufacturer assistance", drug name | **Pharmacy Appeal + Assistance** | `payer_appeal_before_manufacturer_assistance` |51| "payment integrity", claim repricing, benchmark | **Payment Integrity** | `effective_benchmark_by_plan_modifier_and_date` |52| "peer-to-peer", P2P, completed discussion | **Peer-to-Peer** | `new_patient_specific_p2p_information` |53| "UM-finance", margin queue, revenue-to-cost | **Margin Queue** | `margin_threshold_then_charge_sensitivity` |5455Each domain follows one of the workflows described in [workflows.md](references/workflows.md). Load that file once the domain is identified.5657## General Pattern58591. Query the database for the target business ID (case, claim, appeal, or queue row).602. Follow the joins outward to related tables (documents, criteria, benchmarks, drug trials, etc.).613. Apply the domain's decision rules using the evidence.624. Build the `basis_audit` object with `source_precedence`, `controlling_record_ids`, `exception_record_ids`, and `precedence_record_order`.635. Return exactly the JSON shape required by the task's `answer_template.json`.6465## Basis Audit6667Every output includes a `basis_audit`. The `source_precedence` value is domain-specific (see table above). Construct the lists as follows:6869- **controlling_record_ids**: The environment record IDs that directly control the result — relevant documents, criteria results, benchmarks, P2P events, or margin rows that drove the determination.70- **exception_record_ids**: Records that explain exclusions, denials, missing information, or route priority. Gap records (missing criteria, missing packet items) come before stale or excluded records.71- **precedence_record_order**: All controlling and exception records ordered by source precedence, highest priority first.