Skip to main content
Health Atlas Clinical knowledge graph search
  • Home
  • How records connect

How records connect

Every kind of record and how they link, in two groups: care delivery and insurance.

Relationship map
How to read this map
  • Read an arrow as a sentence, from the box it leaves to the box its head points at: Patient has visit Visit.
  • Arrows run the way the relationship reads, not where the id is stored: a visit row holds its patient’s id, yet the arrow starts at Patient.
  • Click a box for that kind’s schema page, or an arrow’s label for its row in the table below.
  • Solid arrow: pages show it, and the neighborhood graph follows it.
  • Dashed arrow: in the data only. Pages and figures read it; the neighborhood graph does not follow it.
  • Dotted line: leads into a concept, the top half of a split box. Pages and figures read it; the neighborhood graph does not follow it. A split box holds one subject twice: its concept on top, the records filed under it below.
  • Each box’s caption says what one row is:
    • fact · event grain: one dated event.
    • fact · year rollup: one patient’s costs with one payer over one annual cycle.
    • dim · actor grain: one person or institution, there whether or not anything happened to it.
    • dim · code grain: one clinical code, shared by many patients’ events.
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
Record kinds

Relationships
Relationships between record kinds, grouped by hub, with where each one is drawn
Relationship Reads back as Between Explore
Care delivery
Has visit Made by Patient Each patient has one or many visits; each visit has exactly one patient. Visit Open a visit and see the patient who made it
Attended by Attended Visit Each visit has exactly one provider; each provider has zero or many visits. Provider Open a visit and see who attended it
At care site Hosted Visit Each visit has exactly one care site; each care site has zero or many visits. Care site Open a visit and see the care site where it took place
Recorded diagnosis Diagnosed during Visit Each visit has zero or many diagnoses; each diagnosis has exactly one visit. Diagnosis Open a visit and see the diagnoses recorded during it
Prescribed Prescribed in Visit Each visit has zero or many medications; each medication has exactly one visit. Medication Open a visit and see the medications prescribed in it
Included procedure Performed during Visit Each visit has zero or many procedures; each procedure has exactly one visit. Procedure Open a visit and see the procedures performed during it
Has care plan Belongs to Patient Each patient has zero or many care plans; each care plan has exactly one patient. Care plan Open a care plan and see the patient it belongs to
Addresses diagnosis Addressed by Care plan Each care plan has zero or one diagnosis; each diagnosis has zero or one care plan. Diagnosis Open a care plan and see the diagnosis it addresses, if one was recorded at its visit
Practices at Staffed by Provider Each provider has exactly one care site; each care site has one or many providers. Care site Neither kind opens a neighborhood — browse providers or care sites instead
Started care plan Started during Visit Each visit has zero or many care plans; each care plan has exactly one visit. Care plan Open a care plan and see the visit it started during
Has diagnosis Diagnosis of Patient Each patient has one or many diagnoses; each diagnosis has exactly one patient. Diagnosis Open a diagnosis and see the patient it belongs to
Has diagnosis concept Diagnosed in Patient Each patient has one or many diagnosis concepts; each diagnosis concept has one or many patients. Diagnosis concept Neither kind opens a neighborhood — browse patients or diagnosis concepts instead
Coded as Code for Diagnosis Each diagnosis has exactly one diagnosis concept; each diagnosis concept has one or many diagnoses. Diagnosis concept Open a diagnosis and see its visit and patient; its page names the code
Has medication Medication of Patient Each patient has zero or many medications; each medication has exactly one patient. Medication Open a medication and see the patient it belongs to
Has medication concept Prescribed to Patient Each patient has zero or many medication concepts; each medication concept has one or many patients. Medication concept Neither kind opens a neighborhood — browse patients or medication concepts instead
Coded as Code for Medication Each medication has exactly one medication concept; each medication concept has one or many medications. Medication concept Open a medication and see its visit and patient; its page names the code
Has procedure Procedure of Patient Each patient has zero or many procedures; each procedure has exactly one patient. Procedure Open a procedure and see the patient it belongs to
Has procedure concept Performed on Patient Each patient has zero or many procedure concepts; each procedure concept has one or many patients. Procedure concept Neither kind opens a neighborhood — browse patients or procedure concepts instead
Coded as Code for Procedure Each procedure has exactly one procedure concept; each procedure concept has one or many procedures. Procedure concept Open a procedure and see its visit and patient; its page names the code
Insurance
Billed as Billed for visit Visit Each visit has one or many claims; each claim has exactly one visit. Claim Open a claim and see the visit it was billed for
Has claim Billed for Patient Each patient has one or many claims; each claim has exactly one patient. Claim Open a claim and see the patient it belongs to
Billed to Was billed for Visit Each visit has exactly one payer; each payer has one or many visits. Payer Open a visit and see the payer it was billed to
Covered by (primary) Covers (primary) Claim Each claim has zero or one payer; each payer has zero or many claims. Payer Open a claim and see its primary payer, if it has one
Covered by (secondary) Covers (secondary) Claim Each claim has zero or one payer; each payer has zero or many claims. Payer Open a claim and see its secondary payer, if it has one
Has expense year Costs of Patient Each patient has zero or many expense years; each expense year has exactly one patient. Expense year Open an expense year and see the patient whose costs it records
Covered by Covered Expense year Each expense year has exactly one payer; each payer has one or many expense years. Payer Open an expense year and see the payer that covered it