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

specimen admission datespec_admn_dt

The date on which a biological specimen, such as blood, urine, or tissue, was received and logged into a laboratory information system (LIS) or biorepository. Used in EHR and LIS platforms to calculate specimen processing turnaround times, validate chain-of-custody records, and align lab results with inpatient encounter timelines in clinical data warehouses.

specimen discharge datespec_dsch_dt

The date on which a biological specimen was released, destroyed, or transferred out of a laboratory or biorepository following analysis. Used in LIS and EHR systems to manage specimen lifecycle tracking, support regulatory retention compliance, and reconcile lab event timelines with inpatient discharge records in clinical data integration pipelines.

standard active indicatorstd_actv_ind

A binary flag indicating whether a clinical or administrative standard, such as a coding guideline, care protocol, or billing rule, is currently active and applicable for use. Used in rules engines and policy management systems to control which standards are enforced during claims adjudication or clinical decision support.

standard active statusstd_actv_sts

The current lifecycle state of a clinical or administrative standard, indicating whether it is active, pending, retired, or superseded. Used in policy and compliance management systems to ensure that only approved and current standards are applied in claims processing, utilization review, and clinical documentation workflows.

standard admission datestd_admn_dt

The date on which a patient is formally admitted to an inpatient facility under a standardized care protocol or clinical pathway. Used in utilization management and claims processing to establish the start of an inpatient episode, calculate length of stay, and apply applicable DRG or per diem reimbursement rules.

standard discharge datestd_dsch_dt

The date on which a patient is formally released from an inpatient facility following care delivered under a standardized clinical protocol or pathway. Used in claims adjudication, case management, and quality reporting to calculate length of stay, trigger post-discharge follow-up, and close inpatient authorization episodes.

standard durationstd_dur

The defined length of time a clinical protocol, coverage policy, authorization approval, or administrative standard remains in effect. Used in utilization management and benefits administration to enforce time-limited approvals, treatment episode boundaries, and policy effective periods within healthcare operational workflows.

standard emergency indicatorstd_emerg_ind

A flag designating that a clinical standard or authorization was applied under emergency conditions, bypassing standard prior authorization or scheduling requirements. Used in claims adjudication and utilization review to apply appropriate reimbursement rules and ensure regulatory compliance for emergent care episodes.

standard history present illnessstd_hpi

The structured narrative documenting a patient's current symptoms, onset, duration, and progression as recorded within a standardized clinical documentation framework. Used in clinical decision support, quality measurement, and coding workflows to support accurate diagnosis assignment and ensure completeness of the medical record.

standard instructionstd_instr

The prescribed guidance or procedural direction associated with a clinical protocol, administrative policy, or coding standard that defines how it should be applied. Used in training, compliance documentation, and operational workflows to ensure consistent interpretation and execution of healthcare standards across systems and staff.

standard labelstd_lbl

The human-readable display name assigned to a clinical protocol, administrative policy, or coding standard for identification in user interfaces and reports. Used in data governance, system configuration, and reporting tools to provide consistent terminology when referencing standards across healthcare operational and analytical platforms.

standard notestd_nt

A free-text annotation associated with a clinical protocol, administrative policy, or coding standard, capturing clarifications, exceptions, or implementation guidance. Used in data governance and compliance workflows to document intent, track interpretation decisions, and communicate context to users applying the standard in operational settings.

standard procedure datestd_proc_dt

The date on which a clinical procedure was performed in accordance with an established care protocol or standardized treatment pathway. Used in claims processing, quality measurement, and outcomes reporting to establish the timeline of care delivery, validate authorization compliance, and support episode-of-care analytics.

standard rangestd_rng

The clinically accepted minimum and maximum values for a diagnostic measurement or test result, as defined by established medical guidelines. Used to flag abnormal lab or vital sign values in EHR and clinical data warehouse reporting workflows.

standard resultstd_rslt

The expected or benchmark outcome value for a clinical test, procedure, or measurement as defined by established medical or regulatory guidelines. Used in lab systems and clinical data warehouses to compare actual patient results against normative benchmarks.

standard routestd_rte

The guideline-recommended administration pathway for a medication, such as oral, intravenous, or subcutaneous, as established by clinical or pharmacy protocols. Used in pharmacy systems and EHRs to ensure medications are dispensed and administered via the approved method.

standard strengthstd_str

The guideline-approved drug concentration or dosage level for a medication, expressed in units such as mg or mcg, as defined by pharmacy formulary or clinical protocols. Used in pharmacy and medication administration systems to validate prescribed doses against established standards.

standard surgery datestd_surg_dt

The scheduled or protocol-defined date on which a surgical procedure is expected to be performed, based on clinical pathway guidelines. Used in surgical planning and clinical data systems to track compliance with recommended operative timelines and care protocols.

statement active indicatorstmt_actv_ind

A binary flag indicating whether a patient billing statement is currently active and outstanding within the revenue cycle. Used in healthcare billing and accounts receivable systems to identify statements requiring follow-up, payment processing, or collection activity.

statement active statusstmt_actv_sts

A coded or descriptive value representing the current lifecycle state of a patient billing statement, such as open, pending, or closed. Used in revenue cycle management systems to track statement workflow and prioritize accounts receivable follow-up actions.

PreviousPage 659 of 806Next