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 start timeobs_start_tm

Records the precise clock time at which a clinical observation period or measurement collection began, such as the start of a continuous glucose monitor reading or timed urine collection. Supports duration calculations, temporal trend analysis, and clinical event sequencing in EHR data systems.

observation stateobs_st

Captures the US state or territory associated with the location where a clinical observation was recorded or the ordering facility is located. Used in population health reporting, jurisdictional disease surveillance, and geographic analysis of clinical findings across regional health systems.

observation statusobs_sts

A coded value representing the current state of a clinical observation, such as preliminary, final, amended, or cancelled. Used in HL7 FHIR, lab, and EHR systems to communicate result readiness, workflow stage, and validity to downstream clinical and reporting consumers.

observation street addressobs_st_addr

Records the physical street address of the facility or care setting where a clinical observation was documented or collected. Used for site-level reporting, care coordination, and linking observations to specific clinical locations within multi-site health systems and data warehouses.

observation strengthobs_str

Documents the concentration or potency of a drug or substance associated with a clinical observation, such as medication dose administered during a pharmacokinetic study or therapeutic drug monitoring event. Essential for medication management, adverse event tracking, and clinical trial data capture.

observation subtotalobs_subtot

Represents an intermediate aggregated value derived from a subset of clinical observations within a defined grouping, such as a partial composite score for a multi-component assessment tool. Used in clinical analytics and quality reporting to support staged scoring methodologies and partial result calculations.

observation surgery dateobs_surg_dt

Records the calendar date on which a surgical procedure linked to a clinical observation was performed, such as a post-operative wound assessment or surgical pathology result. Used to establish clinical timelines, calculate post-operative intervals, and correlate findings with operative events in clinical data systems.

observation system identifierobs_sys_id

The unique system-generated key assigned to a specific clinical observation record within a healthcare information system or data warehouse. Serves as the primary reference for linking observation data across EHR, lab, and clinical data platforms, ensuring accurate record retrieval and cross-system data integrity.

observation targetobs_tgt

The specific anatomical site, body system, organism, or subject entity to which a clinical observation is directed or attributed. Used in EHR and diagnostic systems to provide clinical context, support coded terminology mapping, and enable precise interpretation of measurement results.

observation taxonomy codeobs_tax_cd

Stores a standardized classification code, such as LOINC or SNOMED CT, used to categorize a clinical observation by type, discipline, or measurement domain. Enables consistent cross-system interpretation of observation data, supports interoperability standards, and facilitates clinical decision support rule mapping.

observation temperatureobs_temp

Records the measured body temperature value captured as a clinical vital sign observation, expressed in Fahrenheit or Celsius. Used to detect fever, hypothermia, or perioperative temperature changes, and feeds clinical alerting rules, sepsis screening protocols, and longitudinal vital sign trend analysis in EHR systems.

observation termination dateobs_term_dt

Captures the calendar date on which a clinical observation period, monitoring episode, or data collection activity officially ended. Used to define the closed interval of an observation window, calculate monitoring durations, and support longitudinal analysis of patient conditions in clinical data warehouses.

observation timeobs_tm

The time-of-day component (HH:MM:SS) recorded for a clinical finding or measurement in EHR and clinical data systems. Enables precise sequencing of vitals, lab results, and nursing assessments within a single encounter date, critical for time-series analysis and clinical event correlation.

observation timestampobs_ts

The full datetime value (date plus time) capturing when a clinical finding or measurement was recorded in EHR, lab, or clinical data systems. Used in data pipelines to sequence clinical events, detect duplicate records, and support longitudinal patient timeline construction across encounters.

observation titleobs_ttl

Stores the formal human-readable name or label assigned to a clinical observation type, such as Fasting Blood Glucose or Systolic Blood Pressure. Used to display and identify observations in clinical documentation, reporting interfaces, and data exchange payloads including HL7 FHIR and CDA documents.

observation totalobs_tot

The aggregated sum of clinical findings or measurements across a defined period or encounter in EHR and clinical analytics systems. Used by data engineers to compute cumulative values such as total fluid intake, aggregate lab result counts, or summarized vital sign readings within reporting pipelines.

observation total countobs_tot_cnt

Represents the aggregate number of discrete clinical observation instances recorded within a specified time period, patient encounter, or reporting cohort. Used in quality metrics, utilization analysis, and clinical research to quantify observation frequency and support population-level performance measurement.

observation typeobs_typ

The categorical classification distinguishing the nature of a clinical finding in EHR and clinical data systems, such as vital sign, laboratory result, imaging finding, or nursing assessment. Used to filter, route, and transform observation records during ETL processing and clinical data warehouse loading.

observation updated dateobs_upd_dt

Records the most recent calendar date on which a clinical observation record was modified, corrected, or supplemented after its initial entry. Used to track data currency, support audit compliance, and identify amendments to lab results, vital signs, or clinical assessments in EHR and clinical data warehouse systems.

observation urgencyobs_urg

Indicates the clinician-assigned or system-derived time sensitivity level for acting on a clinical observation result, such as routine, urgent, or STAT. Drives clinical alerting workflows, result routing priorities, and care escalation protocols when critical lab values or abnormal findings require immediate intervention.

PreviousPage 444 of 806Next