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 classinst_cls

FDA or facility-defined classification tier assigned to a medical instrument indicating its regulatory risk level and oversight requirements. Stored in EHR device management and biomedical engineering systems to drive compliance workflows, maintenance protocols, and reporting aligned with FDA 21 CFR classification for medical devices.

instrument codeinst_cd

Standardized alphanumeric identifier assigned to a medical instrument within EHR device registries, biomedical engineering systems, or laboratory information management systems (LIMS). Used to uniquely classify instruments across procurement, maintenance, and claims workflows, supporting interoperability and traceability with FDA UDI and facility asset databases.

instrument commentinst_cmt

Free-text notation field attached to a medical instrument record within biomedical engineering platforms, EHR device management modules, or laboratory systems. Captures operational notes, maintenance observations, or incident details that supplement structured data fields and support audit trail documentation for regulatory inspections and device incident reporting.

instrument completed dateinst_cmpl_dt

Records the calendar date on which a clinical instrument assessment, procedure, or associated service was fully completed. Used in clinical documentation and workflow tracking to confirm closure of instrument-related activities and support reporting on assessment completion rates and turnaround times.

instrument confidential indicatorinst_conf_ind

A flag that designates whether a clinical instrument record contains sensitive or restricted information requiring enhanced privacy protections. When set, this indicator limits access to authorized users only, supporting HIPAA compliance and confidentiality policies for sensitive clinical assessments or documentation.

instrument contactinst_cntct

Designated communication point, such as a biomedical technician, vendor representative, or department coordinator, associated with a medical instrument record in EHR asset management or device tracking systems. Used to route maintenance requests, service escalations, and recall notifications within hospital operations and regulatory compliance workflows.

instrument countinst_cnt

Numeric value representing the total number of a specific medical instrument type within a facility's asset management system or EHR device registry. Used in hospital inventory management, supply chain platforms, and biomedical engineering systems to support procurement planning, utilization tracking, and regulatory inventory audits.

instrument countryinst_ctry

Stores the country associated with the location where a clinical instrument is deployed, registered, or serviced. Used in asset management, regulatory compliance, and international healthcare operations to maintain accurate geographic data for instruments across multinational or multi-site healthcare systems.

instrument created byinst_crtd_by

Identifies the user who initially created or entered the clinical instrument record into the healthcare system. Captures the originating user's identifier to support audit trail requirements, data governance, and accountability in clinical documentation and instrument management workflows.

instrument created dateinst_crtd_dt

Timestamp recording when a medical instrument's record was first entered into a biomedical engineering database, EHR device registry, or laboratory asset management system. Critical for audit trail integrity, data lineage tracking, and regulatory compliance reporting, ensuring accurate device lifecycle documentation from initial system entry onward.

instrument created timeinst_crtd_tm

Records the exact timestamp when a clinical instrument record was initially created in the healthcare system. Used in audit trail tracking, data governance, and workflow monitoring to establish a precise chronological reference for when the instrument entry was first recorded in the system.

instrument creatinineinst_cr

Stores the serum or urine creatinine value measured using a clinical laboratory instrument during a patient encounter. Used in clinical documentation and lab result tracking to assess kidney function, monitor renal health, and inform dosing decisions for renally-cleared medications.

instrument dateinst_dt

Generic calendar date value associated with a medical instrument event or record within EHR device management, biomedical engineering, or laboratory information systems. Context-dependent field used to capture key milestones such as calibration dates, inspection dates, or service events supporting device lifecycle tracking and regulatory compliance.

instrument datetimeinst_dttm

Combined date and timestamp field capturing a precise moment associated with a medical instrument event in EHR device management, LIMS, or biomedical engineering systems. Used for high-resolution audit trail logging, calibration event recording, and regulatory compliance documentation where date-only granularity is insufficient for operational or legal requirements.

instrument dea numberinst_dea_nbr

Stores the Drug Enforcement Administration registration number associated with a clinical instrument or the practitioner linked to controlled substance dispensing activities. Used in pharmacy and controlled substance management workflows to ensure regulatory compliance and proper tracking of DEA-registered entities.

instrument death dateinst_death_dt

Records the date on which a medical instrument or device was decommissioned, destroyed, or rendered permanently inactive within healthcare asset management or device tracking systems. Used to maintain accurate medical equipment inventory records, support regulatory compliance audits, and ensure retired devices are excluded from active clinical use workflows.

instrument deleted dateinst_del_dt

Records the calendar date on which a clinical instrument record was marked as deleted or logically removed from the active dataset. Used in data governance and audit trail workflows to track record lifecycle events and maintain a historical log of instrument data removals within the healthcare system.

instrument deleted indicatorinst_del_ind

A flag that identifies whether a clinical instrument record has been logically deleted or removed from active use within the healthcare system. Used in data management and reporting workflows to filter out voided records while preserving the historical data for audit, compliance, and analytical purposes.

instrument descriptioninst_desc

Contains the human-readable textual explanation of a medical instrument or device, including its name, function, and clinical application, as stored in EHR, asset management, or supply chain systems. Used to support clinical documentation, device procurement workflows, and cross-referencing with FDA device classification databases.

instrument detailinst_dtl

Captures granular specifications or supplementary information about a medical instrument or device, such as model number, manufacturer, or configuration settings, within EHR or clinical asset management systems. Used to support device traceability, adverse event reporting, and integration with FDA UDI registry data pipelines.

PreviousPage 334 of 806Next