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 modified byinst_mod_by

The system username or user identifier of the individual who most recently updated a clinical instrument record in the biomedical equipment management or clinical data system. Used in audit trails to maintain accountability for changes to device configuration, calibration data, or maintenance documentation.

instrument modified dateinst_mod_dt

Timestamp recording the most recent update made to a medical instrument or device record within EHR, clinical inventory, or healthcare data management systems. Critical for audit trail maintenance, data lineage tracking, and ensuring downstream pipelines process only the latest instrument configuration or metadata changes.

instrument modified timeinst_mod_tm

The date and timestamp recording when a clinical instrument record was most recently updated in the biomedical equipment management or clinical data system. Used in audit logging and data governance workflows to track the history of changes to device attributes, calibration records, or maintenance status.

instrument nameinst_nm

The standardized display label assigned to a medical tool, device, or diagnostic instrument within EHR, lab, and clinical data systems. Used to map device records across HL7, FHIR Device resources, and clinical documentation workflows for accurate instrument identification.

instrument noteinst_nt

Free-text or structured annotation associated with a medical instrument record in EHR and lab information systems. Captures calibration remarks, usage warnings, or maintenance comments linked to device identifiers in clinical and laboratory data pipelines.

instrument numberinst_nbr

The unique reference or serial number assigned to a specific medical instrument or device within hospital asset management, EHR, and laboratory information systems. Used as a foreign key for linking device records to clinical events, maintenance logs, and regulatory compliance data.

instrument onset dateinst_onset_dt

The date on which a clinical instrument first became operational, was placed into service, or began producing data in a clinical setting. Used in biomedical equipment management to establish the start of the device's active use period for maintenance scheduling, warranty tracking, and lifecycle management.

instrument oxygen saturationinst_o2sat

The oxygen saturation measurement value captured or recorded by a clinical instrument such as a pulse oximeter or patient monitoring device. Used in clinical data systems to document SpO2 readings linked to specific devices, supporting equipment performance validation and patient vital sign documentation.

instrument paid amountinst_pd_amt

The monetary amount paid for a clinical instrument or diagnostic device, reflecting the actual reimbursed or settled cost recorded in financial or procurement systems. Used in capital equipment budgeting, cost accounting, and claims processing workflows to track expenditures associated with device acquisition or service.

instrument paid dateinst_pd_dt

The date on which payment was processed or settled for a clinical instrument or diagnostic device purchase, lease, or service contract. Used in healthcare procurement and accounts payable systems to record financial transaction completion and support auditing of capital equipment expenditures and vendor payments.

instrument parentinst_prnt

The hierarchical superior relationship identifier linking a medical instrument to its parent device, system, or equipment group within EHR and asset management data models. Supports parent-child device hierarchies in FHIR Device resources and clinical equipment tracking systems.

instrument percentageinst_pct

A calculated ratio or percentage value associated with a medical instrument's performance, utilization, or measurement output in clinical and laboratory data systems. Used in quality metrics, device calibration reporting, and operational analytics within EHR and lab information platforms.

instrument periodinst_prd

The defined time span during which a clinical instrument, assessment tool, or medical device is active or valid within EHR and clinical data systems. Used to bound diagnostic or monitoring intervals for data pipeline processing and longitudinal analysis.

instrument phoneinst_ph

The telephone contact number associated with a clinical instrument vendor, device support line, or assessment administrator in healthcare data systems. Referenced in EHR and vendor management tables to facilitate device troubleshooting, calibration scheduling, and service coordination workflows.

instrument preferred nameinst_pref_nm

The commonly used or preferred display name for a clinical instrument or diagnostic device, which may differ from its full legal or registered name. Used in biomedical equipment management and clinical workflow systems to present a recognizable, user-friendly label for staff when referencing devices in daily operations.

instrument priceinst_prc

The listed or contracted purchase price of a clinical instrument or diagnostic device as recorded in procurement, supply chain, or capital equipment management systems. Used in financial planning, vendor contract management, and cost allocation workflows to document and compare device acquisition costs across purchasing cycles.

instrument primary indicatorinst_prim_ind

A flag or Boolean indicator identifying whether a clinical instrument is designated as the primary device within a set of related instruments serving the same function. Used in laboratory and clinical systems to determine which device's results take precedence for reporting, quality control, and clinical decision-making purposes.

instrument priorityinst_prty

The ranked importance level assigned to a clinical instrument, diagnostic device, or assessment tool within EHR and care management systems. Governs the order of instrument-driven workflows, alert routing, and clinical decision support rules during data processing and care coordination pipelines.

instrument procedure dateinst_proc_dt

The date on which a clinical procedure, diagnostic test, or therapeutic intervention was performed using a specific instrument or medical device. Used in clinical documentation and device utilization tracking systems to associate instrument usage records with specific patient care events for billing, auditing, and outcome analysis.

instrument pulseinst_pulse

Records the pulse rate measurement captured by or associated with a specific clinical instrument during patient monitoring. Used in device-integrated vital signs workflows to link heart rate readings directly to the measuring equipment for accuracy validation and audit tracing.

PreviousPage 337 of 806Next