Skip to main content

Payer

Insurance payers named on visits, claims and expense years. Searchable by name, and reached from any of those records.

10 records · 3 data fields · 4 relationships

Explore records
Relationship map — Payer highlighted
Has visit Attended by At care site Recorded diagnosis Prescribed Included procedure Has care plan Addresses diagnosis Practices at Started care plan Billed as Has claim Billed to Primary Secondary Has expense year Covered by Has diagnosis Has medication Has procedure PatientDIM · ACTOR GRAIN VisitFACT · EVENT GRAIN Diagnosis conceptDIM · CODE GRAIN DiagnosisFACT · EVENT GRAIN Medication conceptDIM · CODE GRAIN MedicationFACT · EVENT GRAIN Procedure conceptDIM · CODE GRAIN ProcedureFACT · EVENT GRAIN ProviderDIM · ACTOR GRAIN Care planFACT · EVENT GRAIN Care siteDIM · ACTOR GRAIN ClaimFACT · EVENT GRAIN PayerDIM · ACTOR GRAIN Expense yearFACT · YEAR ROLLUP Coded as Coded as Coded as

Click any node to explore its schema. Highlighted relationships connect to or from Payer.

Field definitions

searched as a name searched as an address searched as an identifier searched as prose

Field Type Description
name string Name of the Payer.
ownership string Typically Government or Private.
record_id string This payer's source id, stored verbatim — the record's identity. Not a search term — find payers by name. Not shown on the record's own page: the page's address already carries this id.

Referenced by

Records that hold this record’s id

  • Each payer has one or many visits; each visit has exactly one payer. Visit foreign key encounter.payer on each visit
  • Each payer has zero or many claims; each claim has zero or one payer. Claim foreign key claim.primary_payer_id on each claim
  • Each payer has zero or many claims; each claim has zero or one payer. Claim foreign key claim.secondary_payer_id on each claim
  • Each payer has one or many expense years; each expense year has exactly one payer. Expense year foreign key patient_expense.payer_id on each expense year

Provenance where this row came from · 7 fields

Field Type Description
source_table string Synthea CSV this row was read from.
source_snapshot_id string Corpus generation this row belongs to.
ingest_run_id string Import run that wrote the row.
generation_run_id string Synthea run that produced the source CSV.
load_timestamp datetime When the row was written.
source_role string Role this source played for the record.
contributing_sources option<array<string>> Other rows that contributed to this record.

Collapsed here because a reader came for what payer means, not where one row came from — that question is the substance of every payer record's own Provenance page, reachable from any payer record.

Types are SurrealDB's own: option<T> means the value may be absent. Full reference: SurrealDB data types.

Try asking

Real values from Payer records. Click to search.

Beyond text search

insurers that covered dialysis

Answering this means walking payer ← billed to ← visit → underwent → procedure. The three shipped search arms — BM25, HNSW, RRF fusion — match text inside one table, so none can.