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
Relationship map — Payer highlighted
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
-
Visit
foreign key
encounter.payeron each visit -
Claim
foreign key
claim.primary_payer_idon each claim -
Claim
foreign key
claim.secondary_payer_idon each claim -
Expense year
foreign key
patient_expense.payer_idon 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
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.