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 countryobs_ctry

Country in which a clinical observation was recorded or where the associated patient encounter took place. Used in cross-border care scenarios, international patient records, and population health systems to support geographic stratification and regulatory compliance across jurisdictions.

observation created byobs_crtd_by

Username or system identifier of the clinician, technician, or automated process that initially entered the observation record into the clinical data system. Supports audit trail requirements by establishing accountability for data origination in EHR and clinical data warehouse environments.

observation created dateobs_crtd_dt

Captures the system timestamp when a clinical observation record was first written to the EHR or clinical data repository. Critical for audit trails, data lineage tracking, and distinguishing record creation from the actual observation date in HL7 FHIR and CDW pipelines.

observation created timeobs_crtd_tm

Timestamp capturing the exact date and time an observation record was first entered into the clinical system, distinct from the observation's actual clinical date. Used for audit trail integrity, data lineage tracking, and identifying potential documentation delays in clinical workflows.

observation creatinineobs_cr

Measured serum or urine creatinine value recorded as a clinical observation, used to assess kidney filtration function. Reported in mg/dL or micromol/L, this lab result is critical for calculating eGFR, monitoring chronic kidney disease progression, and adjusting medication dosing safely.

observation dateobs_dt

Represents the calendar date on which a clinical finding, vital sign, or diagnostic measurement was collected or recorded. Used in EHR systems, clinical data warehouses, and FHIR-based pipelines to index LOINC-coded observations for longitudinal patient timeline analysis and cohort queries.

observation datetimeobs_dttm

Stores the precise date and time a clinical finding or measurement was captured, typically in ISO 8601 format. Used in EHR systems and HL7 FHIR Observation resources to differentiate same-day events, support time-series analytics, and ensure accurate sequencing of vitals and lab results.

observation dea numberobs_dea_nbr

Drug Enforcement Administration registration number associated with a prescribing clinician linked to a clinical observation involving controlled substances. Captured in EHR and pharmacy systems to ensure regulatory compliance when observations relate to controlled substance ordering or administration documentation.

observation death dateobs_death_dt

Records the date of patient death as documented within a clinical observation or encounter record. Used in EHR and clinical data warehouse systems to reconcile mortality data with claims, support survival analysis, and align with NCHS death certificate feeds in population health pipelines.

observation deductible amountobs_ded_amt

Dollar value applied toward a patient's annual insurance deductible for an observation-status encounter or service. Recorded in claims and billing systems to track cumulative patient cost-sharing, informing both payer adjudication and patient financial responsibility calculations under their health plan.

observation deleted dateobs_del_dt

Date on which an observation record was marked as deleted or inactivated within the clinical system, supporting soft-delete data management practices. Retained for audit and legal hold purposes, this field enables historical reconstruction of record states without permanent data loss.

observation deleted indicatorobs_del_ind

Boolean flag indicating that an observation record has been logically removed from active clinical use without physical deletion from the database. Enables soft-delete functionality so downstream reporting systems can exclude voided observations while preserving the complete audit history of clinical documentation changes.

observation descriptionobs_desc

Contains the human-readable textual explanation of a clinical finding or measurement, often mapped to LOINC or SNOMED CT display names. Used in EHR systems and clinical data marts to provide context for coded observations and support downstream NLP processing and reporting interfaces.

observation detailobs_dtl

Holds granular, supplementary information associated with a specific clinical observation, such as specimen source, method, or result interpretation. Used in laboratory information systems, EHRs, and clinical data warehouses to enrich LOINC-coded results and support detailed clinical and regulatory reporting.

observation discharge dateobs_dsch_dt

The date a patient is released from observation status in a hospital setting, distinct from an inpatient discharge. Used in EHR and claims systems to calculate observation stay duration, determine Medicare three-day inpatient qualifying stay eligibility, and populate UB-04 claim form date fields.

observation due dateobs_due_dt

Scheduled target date by which a clinical observation, follow-up measurement, or monitoring activity is expected to be completed. Used in care management workflows and preventive care tracking to trigger reminders, flag overdue clinical actions, and support quality measure compliance reporting.

observation durationobs_dur

Length of time over which a clinical observation was measured, monitored, or remained clinically relevant, expressed in standardized units such as minutes, hours, or days. Contextualizes findings such as continuous monitoring readings, extended lab incubation periods, or symptom persistence windows.

observation effective dateobs_eff_dt

Marks the date on which a clinical observation or measurement becomes clinically valid or actionable within the patient record. Used in EHR systems and clinical data warehouses to manage observation versioning, support temporal queries, and align with FHIR effectiveDateTime semantics in data integration pipelines.

observation emailobs_eml

Stores the electronic mail address associated with a clinical observation record, typically linked to the ordering provider, reporting lab, or responsible clinician. Used in EHR and care coordination systems to route result notifications and support provider directory lookups in clinical data integration workflows.

observation emergency indicatorobs_emerg_ind

Flag designating that a clinical observation was obtained in an emergency context or that the resulting value requires immediate clinical intervention. Triggers priority routing in clinical decision support systems and ensures urgent findings are escalated to care teams without delay.

PreviousPage 439 of 806Next