mdatool
Healthcare Data Dictionary for the Modern Data Stack
LibraryBlogPricing
mdatool
mdatool

The healthcare data dictionary for dbt, Snowflake, Databricks, and BigQuery. 100,000+ ISO-11179 standard terms, free SQL tools, and AI data modeling.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator
  • Data Model Canvas

Library

  • Glossary
  • Guides
  • Blog

Company

  • About
  • Contact
  • Pricing

Account

  • Sign Up Free
  • Sign In
  • Upgrade to Pro
  • Dashboard

Legal

  • Privacy Policy
  • Terms of Service

© 2026 mdatool. All rights reserved.

Built for healthcare data teams.

Back to Glossary

Domain

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

observation end dateobs_end_dt

Captures the date on which a clinical observation period, monitoring window, or measurement interval concludes. Used in EHR systems and clinical data warehouses to define observation study periods, close episodic records, and support temporal range queries across LOINC-coded measurement series in analytics pipelines.

observation end timeobs_end_tm

Timestamp marking when a clinical observation or monitoring episode was concluded, such as the end of a continuous vital sign measurement period or an extended diagnostic assessment. Combined with start time, enables calculation of observation duration and supports accurate clinical timeline reconstruction.

observation entered byobs_ent_by

Identifier of the staff member or system that manually keyed or transcribed the observation data into the clinical record, which may differ from the clinician who performed the assessment. Supports accountability tracking in EHR systems where data entry and clinical authorship are performed by different roles.

observation ethnicityobs_ethn

Patient's self-reported ethnic background associated with a clinical observation record, captured per OMB classification standards. Used in population health analytics, health equity reporting, and epidemiological research to identify disparities in clinical outcomes and observation patterns across demographic groups.

observation expiration dateobs_exp_dt

Indicates the date after which a clinical observation or measurement result is no longer considered valid for clinical decision-making. Used in EHR and clinical data warehouse systems to manage result lifecycle, suppress outdated findings in reporting, and support data governance policies for LOINC-coded observation records.

observation external identifierobs_ext_id

Unique reference code assigned by an external system, such as a reference laboratory, health information exchange, or interfacing EHR, to identify a clinical observation across organizational boundaries. Enables cross-system matching, result reconciliation, and data interoperability in federated clinical data environments.

observation faxobs_fax

Facsimile transmission number associated with a facility, department, or clinician linked to a clinical observation record, used for routing result notifications or clinical correspondence. Retained in legacy clinical systems where fax remains a HIPAA-compliant method for transmitting observation results to referring providers.

observation feeobs_fee

Billed charge amount associated with the clinical service or procedure that generated the observation record, prior to insurance adjudication or contractual adjustments. Captured in revenue cycle systems to support claims submission, fee schedule validation, and cost analysis for observation-coded services.

observation first nameobs_first_nm

Given name of the patient or subject associated with a clinical observation record, used to confirm identity during result review and clinical documentation workflows. Supports patient matching processes in EHR systems and ensures observation results are accurately attributed to the correct individual in the medical record.

observation flagobs_flg

A binary or coded marker applied to a clinical observation to indicate an abnormal result, critical value, or data quality issue. Used in laboratory information systems and EHR platforms to trigger clinical alerts, filter abnormal LOINC-coded results, and support downstream data quality validation in clinical data pipelines.

observation frequencyobs_freq

Specifies how often a clinical observation or measurement is to be recorded or monitored, such as hourly, daily, or weekly. Used in EHR clinical documentation to define monitoring schedules for vital signs, lab values, and patient assessments.

observation full nameobs_full_nm

The complete, unabbreviated name of a clinical observation or measurement, such as 'Systolic Blood Pressure' or 'Fasting Plasma Glucose'. Used in clinical data systems to provide a human-readable label for display in reports, flowsheets, and patient records.

observation genderobs_gndr

The biological sex or gender classification associated with a clinical observation, used to apply gender-specific reference ranges and clinical norms. Critical in lab result interpretation and clinical decision support where normal values differ between male and female patients.

observation glucoseobs_gluc

Records the measured blood glucose concentration for a clinical observation event, typically expressed in mg/dL or mmol/L. Used in EHR flowsheets and lab result systems to track glycemic status for diabetes management, metabolic panels, and inpatient glucose monitoring protocols.

observation group numberobs_grp_nbr

A numeric identifier that categorizes a clinical observation into a logical grouping within a clinical data system, such as a panel or battery of related tests. Used to organize and retrieve related observations together in EHR flowsheets, order sets, and clinical reporting workflows.

observation hemoglobinobs_hgb

Records the measured hemoglobin concentration in a patient's blood for a clinical observation event, typically expressed in g/dL. Used in EHR and lab information systems to assess oxygen-carrying capacity, diagnose anemia, monitor transfusion thresholds, and track chronic disease management.

observation history present illnessobs_hpi

Captures the structured or narrative description of the patient's current symptoms and condition at the time of a clinical observation, as documented by the clinician. Used in EHR encounter documentation to provide clinical context for the observation within the patient's chief complaint and care episode.

observation identifierobs_id

The unique surrogate or natural key assigned to a specific clinical observation record within an EHR, clinical data warehouse, or FHIR repository. Used to link LOINC-coded findings across source systems, support patient-level joins, and maintain referential integrity in clinical data integration and analytics pipelines.

observation indexobs_idx

Represents the sequential position of a clinical observation within an ordered series or result set for a patient encounter. Used in EHR and clinical data warehouse systems to maintain ordering of repeated LOINC-coded measurements, support array-based result retrieval, and enable time-series sequencing in analytics workflows.

observation indicatorobs_ind

A boolean or enumerated flag denoting a specific clinical condition, data quality state, or processing status associated with an observation record. Used in EHR systems and clinical data pipelines to signal reviewed, amended, or preliminary LOINC-coded results and support conditional logic in reporting and alerting workflows.

PreviousPage 440 of 806Next