packages/data-transformation/raw-to-core). Every table has its own doc file.
Within each resource, tables follow FHIR property order where practical.
AllergyIntolerance
Patient allergies and intolerances, with reaction and manifestation details.- allergyintolerance – Main allergy/intolerance record
- allergyintolerance_code_coding
- allergyintolerance_clinicalstatus_coding
- allergyintolerance_reaction – Reactions
- allergyintolerance_reaction_substance_coding
- allergyintolerance_reaction_manifestation – Manifestations
- allergyintolerance_reaction_manifestation_coding
- allergyintolerance_extension
- allergyintolerance_extension_vcc_coding
- allergyintolerance_references – Reference Tables
Binary
Binary content (e.g., documents, images) referenced by the system.CarePlan
Patient care plans and activities.- careplan – Main care plan record
- careplan_category
- careplan_category_coding
- careplan_activity – Activities
- careplan_activity_detail_code_coding
- careplan_activity_detail_performer – Performers per activity
- careplan_extension
- careplan_extension_vcc_coding
- careplan_references – Reference Tables
Communication
Communications (e.g., messages, notifications) associated with the patient.- communication – Main communication record
- communication_category
- communication_category_coding
- communication_extension
- communication_extension_vcc_coding
- communication_references – Reference Tables
Composition
Clinical documents (e.g., discharge summary) with sections, attestation, and events.- composition – Main composition record
- composition_type_coding
- composition_section – Sections
- composition_section_code_coding
- composition_attester – Attestation
- composition_event – Event/period
- composition_section_entry – Section entries
- composition_extension
- composition_extension_vcc_coding
- composition_references – Reference Tables
Condition
Symptoms, problems, complaints, and diagnoses reported during encounters.- condition – Main condition record
- condition_clinicalstatus_coding
- condition_verificationstatus_coding
- condition_category
- condition_category_coding
- condition_code_coding
- condition_extension
- condition_extension_vcc_coding
- condition_references – Reference Tables
Consent
Patient consent and provision/category codings.- consent – Main consent record
- consent_scope_coding
- consent_policyrule_coding
- consent_category
- consent_category_coding
- consent_provision_code
- consent_provision_code_coding
- consent_extension
- consent_extension_vcc_coding
- consent_references – Reference Tables
Coverage
Insurance and payment coverage.- coverage – Main coverage record
- coverage_type_coding
- coverage_relationship_coding
- coverage_class
- coverage_class_type_coding
- coverage_extension
- coverage_extension_vcc_coding
- coverage_references – Reference Tables
Device
Devices (e.g., implants, equipment) with optional version detail.- device – Main device record
- device_type_coding
- device_version – Version information
- device_extension
- device_extension_vcc_coding
- device_references – Reference Tables
DiagnosticReport
Diagnostic reports containing test results and clinical findings.- diagnosticreport – Main diagnostic report record
- diagnosticreport_code_coding
- diagnosticreport_category_coding
- diagnosticreport_presentedform – Attachment content
- diagnosticreport_extension
- diagnosticreport_extension_vcc_coding
- diagnosticreport_references – Reference Tables
DocumentReference
References to clinical documents and their content/attachments.- documentreference – Main document reference record
- documentreference_type_coding
- documentreference_content – Attachment metadata
- documentreference_extension
- documentreference_extension_vcc_coding
- documentreference_references – Reference Tables
Encounter
Unique patient interactions with the healthcare system.- encounter – Main encounter record
- encounter_diagnosis – Diagnoses per encounter
- encounter_type
- encounter_type_coding
- encounter_reasoncode
- encounter_reasoncode_coding
- encounter_priority_coding
- encounter_hospitalization_dischargedisposition_coding
- encounter_extension
- encounter_extension_vcc_coding
- encounter_references – Reference Tables
FamilyMemberHistory
Family member history and conditions.- familymemberhistory – Main family member history record
- familymemberhistory_condition – Conditions per family member
- familymemberhistory_condition_code_coding
- familymemberhistory_relationship_coding
- familymemberhistory_sex_coding
- familymemberhistory_extension
- familymemberhistory_extension_vcc_coding
- familymemberhistory_references – Reference Tables
Goal
Patient goals and targets.- goal – Main goal record
- goal_description_coding
- goal_priority_coding
- goal_target – Targets per goal
- goal_target_measure_coding
- goal_extension
- goal_extension_vcc_coding
- goal_references – Reference Tables
Immunization
Vaccines administered to patients.- immunization – Main immunization record
- immunization_vaccinecode_coding
- immunization_statusreason_coding
- immunization_route_coding
- immunization_site_coding
- immunization_extension
- immunization_extension_vcc_coding
- immunization_references – Reference Tables
Location
Practice and facility locations where care is provided. Address is on the main location record (single in FHIR); telecom is normalized.- location – Main location record (includes address)
- location_type
- location_type_coding
- location_telecom – Contact details per location
- location_extension
- location_extension_vcc_coding
- location_references – Reference Tables
Medication
Medications ordered or administered during encounters.- medication – Main medication record
- medication_code_coding
- medication_extension
- medication_extension_vcc_coding
MedicationAdministration
Records of medications actually administered to patients.- medicationadministration – Main medication administration record
- medicationadministration_dosage_route_coding
- medicationadministration_extension
- medicationadministration_extension_vcc_coding
- medicationadministration_references – Reference Tables
MedicationDispense
Records of medications dispensed to patients.- medicationdispense – Main medication dispense record
- medicationdispense_extension
- medicationdispense_extension_vcc_coding
- medicationdispense_references – Reference Tables
MedicationRequest
Medication orders and prescriptions.- medicationrequest – Main medication request record
- medicationrequest_extension
- medicationrequest_extension_vcc_coding
- medicationrequest_references – Reference Tables
MedicationStatement
Patient-reported medication information with dosage instructions.- medicationstatement – Main medication statement record
- medicationstatement_dosage – Dosage instructions per statement
- medicationstatement_dosage_route_coding
- medicationstatement_dosage_doseandrate – Dose/rate quantities per dosage
- medicationstatement_extension
- medicationstatement_extension_vcc_coding
- medicationstatement_references – Reference Tables
Observation
Clinical measurements (e.g., blood pressure, height, weight) with reference ranges and interpretations.- observation – Main observation record
- observation_code_coding
- observation_category
- observation_category_coding
- observation_bodysite_coding
- observation_interpretation – Interpretation per observation (text)
- observation_interpretation_coding
- observation_referencerange – Reference ranges per observation
- observation_extension
- observation_extension_vcc_coding
- observation_references – Reference Tables
Organization
Healthcare organizations and facilities, with normalized addresses and telecom.- organization – Main organization record
- organization_address – Addresses per organization
- organization_telecom – Contact details per organization
- organization_extension
- organization_extension_vcc_coding
- organization_references – Reference Tables
Patient
Patient demographic information and core patient data.- patient – Main patient record
- patient_identifier
- patient_identifier_type_coding
- patient_name
- patient_telecom
- patient_address
- patient_communication – Patient communication and language
- patient_communication_language_coding
- patient_mapping – External ID mapping
- patient_extension
- patient_extension_vcc_coding
- patient_references – Reference Tables (managingOrganization)
Practitioner
Healthcare providers who deliver care, with normalized names, addresses, telecom, and qualifications.- practitioner – Main practitioner record
- practitioner_address – Addresses per practitioner
- practitioner_name – Names per practitioner
- practitioner_telecom – Contact details per practitioner
- practitioner_qualification – Qualifications per practitioner
- practitioner_qualification_code_coding
- practitioner_extension
- practitioner_extension_vcc_coding
Procedure
Procedures performed on patients.- procedure – Main procedure record
- procedure_code_coding
- procedure_bodysite
- procedure_bodysite_coding
- procedure_reasoncode
- procedure_reasoncode_coding
- procedure_note
- procedure_extension
- procedure_extension_vcc_coding
- procedure_references – Reference Tables
RelatedPerson
A person related to the patient (e.g., family) with demographics and relationship codings.- relatedperson – Main related person record
- relatedperson_relationship
- relatedperson_relationship_coding
- relatedperson_name
- relatedperson_address
- relatedperson_telecom
- relatedperson_communication
- relatedperson_communication_language_coding
- relatedperson_extension
- relatedperson_extension_vcc_coding
ServiceRequest
Orders and referrals for procedures, labs, or other services.- servicerequest – Main service request record
- servicerequest_code_coding
- servicerequest_extension
- servicerequest_extension_vcc_coding
- servicerequest_references – Reference Tables