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 numberobs_nbr

The unique numeric reference identifier assigned to a specific observation record within an EHR, LIS, or claims system. Used to link observation results to orders, encounters, and claims transactions, and to support deduplication and audit trail tracking across HL7 v2 OBX-1 sequence fields.

observation onset dateobs_onset_dt

Captures the date when a clinical condition, symptom, or finding first appeared or was first recognized. Used in EHR systems to establish the clinical timeline of a patient's condition, supporting diagnosis documentation, chronic disease tracking, and longitudinal patient care management.

observation oxygen saturationobs_o2sat

Records a patient's peripheral oxygen saturation (SpO2) percentage as measured by pulse oximetry or arterial blood gas analysis. This vital sign observation is critical for monitoring respiratory status, guiding oxygen therapy decisions, and tracking cardiopulmonary conditions in clinical care settings.

observation paid amountobs_pd_amt

Records the actual dollar amount reimbursed for a clinical observation service or procedure by a payer. Used in claims adjudication and revenue cycle management to track payment against billed charges, supporting financial reconciliation and remittance analysis for observation-level encounters.

observation paid dateobs_pd_dt

Captures the date on which payment was issued by a payer for a clinical observation service or procedure. Used in revenue cycle management and claims reconciliation to track reimbursement timing, measure days in accounts receivable, and support financial reporting for observation encounters.

observation parentobs_prnt

The superior observation record in a hierarchical data structure to which one or more child observations are linked, such as a lab panel grouping individual analyte results. Used in HL7 FHIR Observation.derivedFrom and LIS systems to maintain structured result relationships and panel integrity.

observation percentageobs_pct

A ratio-based numeric value expressed as a percentage within a clinical observation record, such as percent saturation, ejection fraction, or differential count. Used in EHR, LIS, and population health systems with LOINC-coded units of measure to support clinical decision rules and quality metric calculations.

observation periodobs_prd

The defined time span during which a clinical observation or measurement is considered valid or was actively collected. Used in EHR, claims, and HEDIS analytics systems to establish lookback windows, define measurement year boundaries, and determine observation stay duration for Medicare billing purposes.

observation phoneobs_ph

The telephone number associated with a clinical observation record, typically referencing the reporting laboratory, ordering provider, or patient contact point. Used in LIS and EHR systems to facilitate critical value callbacks, result communication, and provider contact routing per CLIA and accreditation standards.

observation planobs_pln

Contains the clinician's documented treatment or management plan associated with a specific clinical observation or finding. Used in EHR systems to record intended interventions, follow-up actions, or care strategies, forming a critical component of SOAP notes and clinical decision documentation.

observation policy numberobs_pol_nbr

Stores the insurance policy identifier associated with billing or coverage for a clinical observation encounter. Used in claims processing and revenue cycle systems to link observation services to the correct payer contract, supporting accurate claim submission and adjudication for observation-level care.

observation preferred nameobs_pref_nm

Stores the standardized or clinician-preferred display label for a clinical observation or measurement within the EHR. Used to present observations in a consistent, human-readable format across clinical interfaces, reports, and patient records, reducing ambiguity when multiple synonymous terms exist for the same finding.

observation priceobs_prc

Represents the billed or standard charge amount associated with a clinical observation service or procedure. Used in revenue cycle and charge master management to establish the list price before contractual adjustments, payer discounts, or patient cost-sharing calculations are applied during claims processing.

observation primary indicatorobs_prim_ind

A flag that designates whether a clinical observation is the principal finding or the primary reason for the patient encounter. Used in clinical documentation and coding workflows to distinguish primary observations from secondary or incidental findings, supporting accurate diagnosis coding and care prioritization.

observation priorityobs_prty

The urgency ranking assigned to a clinical observation, such as STAT, ASAP, or routine, indicating required turnaround time for collection, processing, and result reporting. Used in HL7 v2 OBR-5 and EHR order entry systems to drive LIS workflow queuing and critical value escalation protocols.

observation procedure dateobs_proc_dt

Records the date on which a clinical procedure or intervention associated with an observation was performed. Used in EHR and claims systems to establish the service date for billing, link procedures to clinical findings, and support longitudinal tracking of interventions within a patient's care timeline.

observation pulseobs_pulse

Records a patient's heart rate in beats per minute as measured during a clinical encounter. This vital sign observation is used to monitor cardiovascular status, detect arrhythmias or hemodynamic instability, and track patient response to treatment within EHR and clinical monitoring systems.

observation quantityobs_qty

The discrete count or volume measurement recorded within a clinical observation, such as specimen volume, colony count, or tablet quantity. Used in HL7 v2 OBX-5 and FHIR Observation.valueQuantity fields across EHR, LIS, and pharmacy systems to capture measurable clinical data with associated units.

observation raceobs_race

Captures the patient's self-reported racial identity as recorded at the time of a clinical observation or encounter. Used in population health analytics, health equity reporting, and clinical research to identify disparities in care outcomes, align with OMB standards, and support demographic stratification in quality metrics.

observation rangeobs_rng

The defined minimum and maximum reference interval for a clinical observation value, indicating expected normal limits based on age, sex, or population. Used in HL7 v2 OBX-7 and FHIR Observation.referenceRange fields within LIS and EHR systems to flag abnormal results and trigger clinical alerts.

PreviousPage 442 of 806Next