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

instrument discharge dateinst_dsch_dt

Records the date on which a medical instrument or device was released from active clinical deployment or removed from a patient encounter, as tracked in EHR or facility asset management systems. Used in equipment utilization reporting, billing reconciliation, and device lifecycle management workflows within healthcare operations.

instrument due dateinst_due_dt

The deadline by which a clinical instrument, assessment tool, or standardized questionnaire must be completed or administered to a patient. Used in care management workflows to track outstanding assessments, surveys, and diagnostic instruments within clinical and care coordination systems.

instrument durationinst_dur

The total elapsed time from initiation to completion of a clinical instrument, assessment tool, or standardized questionnaire administered to a patient. Used to monitor administration efficiency, patient engagement, and compliance with timed clinical assessment protocols in care management systems.

instrument emailinst_eml

Stores the electronic mail address associated with a medical instrument, device vendor, or responsible clinical contact within healthcare asset management or EHR systems. Used to facilitate automated maintenance notifications, regulatory recall communications, and vendor coordination in medical device lifecycle management workflows.

instrument emergency indicatorinst_emerg_ind

A flag indicating that a clinical instrument or assessment tool requires urgent administration due to an emergent patient condition or critical care situation. Used in clinical workflows to prioritize and escalate outstanding assessments requiring immediate attention within care management systems.

instrument end dateinst_end_dt

Records the date on which a medical instrument or device completed its assigned clinical use, service contract, or operational deployment within healthcare asset management or EHR systems. Used to calculate device utilization periods, trigger maintenance scheduling, and support equipment lifecycle reporting in clinical operations data pipelines.

instrument end timeinst_end_tm

The timestamp recording when a patient completed or when administration concluded for a clinical instrument, assessment tool, or standardized questionnaire. Used to calculate total duration, track completion compliance, and audit clinical assessment workflows in care management and EHR systems.

instrument entered byinst_ent_by

The identifier of the clinician, care manager, or system user who recorded or submitted responses for a clinical instrument or patient assessment tool. Used for audit trail, accountability tracking, and quality review of assessment data entry within clinical and care management workflows.

instrument ethnicityinst_ethn

The patient ethnicity value captured as part of a clinical instrument or standardized demographic assessment tool. Used to support population health stratification, health equity reporting, and culturally appropriate care interventions when instruments include demographic data collection components.

instrument expiration dateinst_exp_dt

Captures the date after which a medical instrument or device is no longer certified for safe clinical use, as recorded in healthcare asset management, EHR, or supply chain systems. Critical for regulatory compliance, Joint Commission audits, and automated alerts that prevent the use of expired sterile or calibrated medical equipment.

instrument external identifierinst_ext_id

A unique reference identifier assigned to a clinical instrument or assessment tool by an external system, vendor, or standards body. Used to cross-reference assessments across disparate clinical systems, interoperability platforms, and third-party assessment vendors within healthcare data integration workflows.

instrument faxinst_fax

The facsimile number associated with the administering entity or contact responsible for a clinical instrument or assessment tool. Used to route completed paper-based assessments, coordinate instrument distribution, and support communication workflows within clinical and care coordination systems.

instrument feeinst_fee

The charge or licensing cost associated with administering a proprietary clinical instrument, standardized assessment tool, or validated questionnaire. Used in healthcare financial tracking to account for per-use fees, licensing costs, and reimbursement associated with billable clinical assessments.

instrument first nameinst_first_nm

The first name of the patient or respondent associated with a clinical instrument or assessment tool record. Used to identify and match assessment results to the correct patient when demographic information is captured as part of the instrument administration and documentation workflow.

instrument flaginst_flg

A binary indicator applied to a medical instrument or device record within EHR, asset management, or claims systems to denote a specific condition such as recall status, contamination risk, calibration failure, or regulatory hold. Used to trigger downstream workflow alerts and exclude flagged devices from active clinical use inventories.

instrument frequencyinst_freq

The prescribed or recommended interval at which a clinical instrument or standardized assessment tool should be re-administered to a patient over a care episode. Used in care management to schedule recurring assessments such as depression screenings, functional assessments, and chronic disease monitoring tools.

instrument full nameinst_full_nm

The complete formal name of a clinical instrument, validated assessment tool, or standardized questionnaire as recognized by its governing standards body or vendor. Used to accurately identify, reference, and report on specific assessment tools across clinical, care management, and quality reporting systems.

instrument genderinst_gndr

The patient gender value recorded as part of a clinical instrument or standardized demographic assessment. Used to apply gender-specific scoring algorithms, support population health stratification, and ensure accurate interpretation of assessment results within clinical and care management workflows.

instrument glucoseinst_gluc

The blood glucose measurement captured as part of a clinical instrument or point-of-care assessment for patients with diabetes or metabolic conditions. Used to track glycemic values collected during structured assessments, supporting chronic disease management and clinical decision-making workflows.

instrument group numberinst_grp_nbr

A numeric identifier that categorizes a clinical instrument or assessment tool within a defined grouping such as a care program, assessment battery, or clinical protocol. Used to organize, filter, and report on related instruments administered within structured care management or clinical research workflows.

PreviousPage 335 of 806Next