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 start dateinst_start_dt

The calendar date marking the beginning of a clinical instrument's active period, assessment window, or device monitoring interval within EHR and care management data systems. Used as a lower bound in date range joins, eligibility overlap logic, and longitudinal clinical data pipeline queries.

instrument start timeinst_start_tm

Records the exact time a clinical instrument began operating, measuring, or administering a therapy during a patient encounter. Used in procedure documentation and device audit logs to establish precise activity timelines for clinical review, billing accuracy, and regulatory compliance.

instrument stateinst_st

Indicates the current operational or lifecycle state of a clinical instrument, such as active, decommissioned, under repair, or pending calibration. Used in biomedical equipment management systems to monitor device availability and ensure only validated instruments are used in patient care settings.

instrument statusinst_sts

The current operational or workflow state of a clinical instrument, diagnostic device, or assessment tool within EHR and clinical data systems. Common values include active, completed, cancelled, or pending, and are used to filter records during claims adjudication, quality reporting, and data pipeline processing.

instrument strengthinst_str

Records the output intensity, signal strength, or measurement sensitivity level of a clinical instrument at the time of use. Used in diagnostic and laboratory systems to document instrument operating parameters, ensuring results are interpreted within validated strength thresholds for clinical accuracy.

instrument subtotalinst_subtot

Represents a partial aggregated cost or usage count associated with a clinical instrument within a billing period, department, or service category. Used in healthcare financial and utilization reporting systems to track instrument-related expenses prior to applying adjustments, taxes, or final totals.

instrument surgery dateinst_surg_dt

Records the date on which a specific surgical instrument was used during an operative procedure. Used in perioperative documentation and sterile processing systems to link instrument usage to surgical cases for traceability, sterilization cycle verification, and implant or device tracking compliance.

instrument targetinst_tgt

The destination system, clinical goal, or patient population reference associated with a clinical instrument or diagnostic device within EHR and care management data platforms. Used to route instrument results, map assessment outputs to quality measures, and drive clinical decision support pipeline logic.

instrument taxonomy codeinst_tax_cd

Stores a standardized classification code that categorizes a clinical instrument by its type, function, or specialty application within a healthcare taxonomy framework. Used in equipment inventories and procurement systems to organize instruments for regulatory reporting, procurement, and compatibility verification.

instrument temperatureinst_temp

Records the temperature measurement captured by or associated with a specific clinical instrument, including patient body temperature readings or instrument operating environment temperature. Used in vital signs monitoring and equipment management systems to validate measurement accuracy and environmental compliance.

instrument termination dateinst_term_dt

Records the date on which a clinical instrument was formally decommissioned, retired from service, or removed from active inventory. Used in biomedical equipment lifecycle management systems to document end-of-service status for regulatory audits, asset disposal records, and replacement planning.

instrument timeinst_tm

The time-of-day value recording when a clinical instrument reading, assessment, or diagnostic device measurement was captured within EHR and lab data systems. Combined with service date fields to construct full datetime values for temporal sequencing and event-based analysis in clinical data pipelines.

instrument timestampinst_ts

The combined date and time value recording the precise moment a clinical instrument event, diagnostic device reading, or assessment result was captured or transmitted within EHR and data integration systems. Used for event ordering, latency measurement, and audit trail construction in healthcare data pipelines.

instrument titleinst_ttl

Stores the official name or descriptive title assigned to a clinical instrument within the healthcare facility's equipment inventory. Used in biomedical asset management, procurement, and maintenance systems to uniquely identify and reference the instrument across clinical documentation and service records.

instrument totalinst_tot

The aggregate sum of clinical instrument measurements, assessment scores, or diagnostic device values across a defined period or encounter within EHR, claims, and population health data systems. Used in cost rollup calculations, quality measure scoring, and financial reconciliation during data pipeline aggregation steps.

instrument total countinst_tot_cnt

The total number of occurrences or instances associated with a specific medical instrument or device record. Used in surgical services, sterile processing, and clinical inventory systems to track instrument utilization, sterilization cycles, or kit assembly quantities across care settings.

instrument typeinst_typ

A categorical classification value that designates the functional category of a medical instrument or device, such as diagnostic, therapeutic, or monitoring, within EHR, lab, and asset management systems. Maps to device type code sets including SNOMED CT and FDA device classification taxonomies.

instrument updated dateinst_upd_dt

The most recent date on which a medical instrument or device record was modified in the system. Used in sterile processing, biomedical engineering, and clinical inventory management to maintain audit trails, track maintenance history, and ensure equipment records reflect current status and compliance requirements.

instrument urgencyinst_urg

The priority or time-sensitivity classification assigned to a medical instrument or device request, preparation, or availability need. Used in surgical scheduling and sterile processing workflows to triage instrument preparation, ensuring critical or emergent procedures receive prioritized equipment readiness and turnaround.

instrument valueinst_val

A discrete or continuous measurement data point captured by a medical instrument and stored in EHR, laboratory information systems, or medical device integration platforms. Represents quantitative outputs such as sensor readings, test results, or calibration values tied to a specific device identifier.

PreviousPage 339 of 806Next