Reference Tables

Reference tables are normalized tables that store FHIR resource references in a structured format. They provide a consistent way to link resources across the Metriport data model. Reference Tables: Each reference table contains the following columns:

Column	Data Type	Description
{resource_id_field}	varchar	The ID of the parent resource (e.g., diagnostic_report_id, encounter_id)
property	varchar	The FHIR property name that contains the reference (e.g., ‘performer’, ‘result’, ‘subject’)
reference_id	varchar	The extracted reference ID from the FHIR reference string
reference_type	varchar	The resource type being referenced (e.g., ‘Patient’, ‘Practitioner’, ‘Observation’)

​

Reference Tables by Resource Type

​

Condition References

The condition_references table supports the following reference properties:

• subject (required): links to the patient who has the condition
• encounter: links to the encounter where the condition was recorded
• recorder: links to the practitioner who recorded the condition

​

Diagnostic Report References

The diagnostic_report_references table supports the following reference properties:

• subject (required): links to the patient who is the subject of the diagnostic report
• encounter: links to the encounter where the diagnostic report was generated
• performer: links to practitioners who performed the diagnostic procedure
• result: links to observations or other diagnostic results referenced in the report

​

Encounter References

The encounter_references table supports the following reference properties:

• subject (required): links to the patient who is the subject of the encounter
• participant.individual: links to practitioners involved in the encounter
• location.location: links to locations where the encounter occurred
• diagnosis.condition: links to conditions diagnosed during the encounter

​

Immunization References

The immunization_references table supports the following reference properties:

• patient (required): links to the patient who received the immunization
• encounter: links to the encounter where the immunization was given
• location: links to the location where the immunization was given
• performer.actor: links to practitioners who administered the immunization

​

Observation References

The observation_references table supports the following reference properties:

• subject (required): links to the patient who is the subject of the observation
• encounter: links to the encounter where the observation was made
• performer: links to practitioners who performed the observation

​

Procedure References

The procedure_references table supports the following reference properties:

• subject (required): links to the patient who is the subject of the procedure
• encounter: links to the encounter where the procedure was performed
• performer.actor: links to practitioners who performed the procedure
• location: links to the location where the procedure was performed
• report: links to diagnostic reports or other reports related to the procedure

​

Medication Administration References

The medication_administration_references table supports the following reference properties:

• medication_reference (required): links to the medication that was administered
• subject (required): links to the patient who received the medication
• performer.actor: links to practitioners who administered the medication

​

Medication Dispense References

The medication_dispense_references table supports the following reference properties:

• medication_reference (required): links to the medication that was dispensed
• subject (required): links to the patient who received the medication
• performer.actor: links to practitioners who dispensed the medication
• location: links to the location where the medication was dispensed

​

Medication Request References

The medication_request_references table supports the following reference properties:

• medication_reference (required): links to the medication that was requested
• subject (required): links to the patient for whom the medication was requested
• encounter: links to the encounter where the medication was requested
• requester: links to the practitioner who requested the medication
• reason_reference: links to conditions or other reasons for the medication request

​

Medication Statement References

The medication_statement_references table supports the following reference properties:

• medication_reference (required): links to the medication referenced in the statement
• subject (required): links to the patient who made the statement about the medication