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

form surgery datefrm_surg_dt

The date a surgical procedure was recorded on a structured clinical form, such as a surgical consent or operative note template. Used to associate operative documentation with its corresponding form instance, supporting surgical scheduling, clinical records management, and billing workflows.

formulation admission dateform_admn_dt

The calendar date on which a patient was admitted to a facility in the context of a specific drug preparation type or pharmaceutical formulation. Used in pharmacy, EHR, and clinical trial data systems to correlate treatment timelines with formulation-specific therapeutic protocols and outcomes.

formulation discharge dateform_dsch_dt

The calendar date on which a patient was released from a care facility associated with a specific drug formulation episode. Used in pharmacy and EHR systems to calculate treatment duration, assess formulation-based length of stay, and support pharmaceutical outcomes and cost analysis reporting.

formulation emergency indicatorform_emerg_ind

A binary flag identifying whether a specific drug formulation was dispensed or prescribed in an emergency clinical context. Used in pharmacy systems to trigger expedited dispensing protocols, override formulary restrictions, and distinguish emergency medication events in pharmacy claims and records.

formulation history present illnessform_hpi

A narrative field capturing the clinical context or presenting condition that prompted selection of a specific drug formulation for a patient. Documents the medical rationale linking the patient's current illness history to the prescribed or dispensed drug preparation type in clinical pharmacy records.

formulation labelform_lbl

The human-readable display name for a specific drug preparation type, such as 'extended-release tablet' or 'oral suspension'. Used in pharmacy systems, medication administration records, and clinical documentation to clearly identify the physical form of a drug prescribed or dispensed to a patient.

formulation procedure dateform_proc_dt

The date a clinical procedure was associated with or necessitated a specific drug formulation, such as an injectable preparation used during a procedure. Links pharmacy dispensing records to procedural events in clinical data systems for medication utilization and procedure-level cost analysis.

formulation rangeform_rng

Defined minimum and maximum value boundaries for a drug preparation type attribute in pharmacy, PBM, or clinical drug reference systems. Used to validate dosage thresholds, enforce quantity limit edits during claims adjudication, and support clinical decision support rules tied to drug concentration or dispensing parameters.

formulation resultform_rslt

The recorded clinical or laboratory outcome associated with a specific drug preparation type administered during a care episode. Used in pharmacy, EHR, and clinical data systems to evaluate therapeutic effectiveness, support formulary decisions, and drive drug utilization and outcomes reporting.

formulation surgery dateform_surg_dt

The date a surgical procedure was associated with a specific drug formulation, such as an anesthetic agent or perioperative medication. Used in pharmacy and surgical records to link drug preparation types to operative events, supporting medication reconciliation and surgical episode documentation.

frequency active indicatorfreq_actv_ind

A binary flag indicating whether a medication administration frequency schedule is currently active and in use within a clinical or pharmacy system. Used to distinguish active dosing intervals from discontinued or superseded schedules, ensuring accurate medication administration records and prescription management.

frequency active statusfreq_actv_sts

Indicates the current operational state of a medication or treatment administration frequency schedule. Determines whether the dosing interval is active, inactive, or suspended in clinical workflow systems, directly controlling whether automated dispensing or nursing administration tasks are triggered.

frequency admission datefreq_admn_dt

Records the inpatient admission date associated with a specific medication or treatment administration frequency schedule. Used in clinical systems to align dosing intervals with the patient's hospital stay, ensuring frequency-based orders remain accurate relative to the admission episode timeline.

frequency discharge datefreq_dsch_dt

Records the inpatient discharge date linked to a medication or treatment administration frequency schedule. Used to determine when recurring dosing orders should be discontinued or transitioned to outpatient regimens, supporting safe medication reconciliation at the point of hospital departure.

frequency durationfreq_dur

Specifies the total length of time over which a medication or treatment is to be administered at a defined interval. Expressed in hours, days, or weeks, this value drives order expiration logic in pharmacy and clinical systems, ensuring time-limited therapies are automatically discontinued when the intended course ends.

frequency emergency indicatorfreq_emerg_ind

A flag denoting that a medication or treatment administration frequency is associated with an emergent clinical scenario. Triggers priority routing in pharmacy dispensing and nursing workflows, ensuring that urgent dosing schedules bypass standard queues and are executed immediately to address acute patient conditions.

frequency history present illnessfreq_hpi

Captures the clinical narrative describing the current illness or condition that established the basis for a recurring medication or treatment administration schedule. Provides contextual documentation supporting the clinical rationale for the prescribed dosing frequency within the patient's medical record.

frequency instructionfreq_instr

Contains structured or free-text guidance specifying how a medication or treatment should be administered at each scheduled interval. Includes clinician-authored directions such as timing relative to meals, patient positioning, or special preparation steps communicated to nursing staff and patients at the point of care.

frequency labelfreq_lbl

The standardized human-readable text label assigned to a medication or treatment administration frequency, such as BID, TID, or Q8H. Displayed across clinical interfaces, medication administration records, and patient-facing instructions to communicate dosing schedules in a consistent and clinically recognized format.

frequency notefreq_nt

A free-text annotation field attached to a medication or treatment administration frequency record, allowing clinicians to document exceptions, clarifications, or supplemental instructions that fall outside structured frequency fields. Supports individualized care by capturing context-specific details not accommodated by coded frequency values.

PreviousPage 267 of 806Next