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 active statusinst_actv_sts

The current operational state of a clinical instrument or diagnostic device, such as active, inactive, retired, or under maintenance, used in biomedical equipment management systems to track device availability, regulatory compliance, and readiness for patient care use.

instrument admission dateinst_admn_dt

Date a medical instrument or device was formally entered into a healthcare facility's asset inventory or device management system. Used in EHR equipment tracking, biomedical engineering databases, and hospital information systems to establish device lifecycle timelines, warranty tracking, and regulatory compliance audit trails.

instrument ageinst_age

The elapsed time since a clinical instrument or diagnostic device was placed into service, typically measured in years or months, used in biomedical equipment management to assess device lifecycle stage, plan preventive maintenance, and support capital replacement decisions.

instrument allowed amountinst_alwd_amt

The maximum reimbursable dollar amount approved by a payer for a specific clinical instrument charge on a medical claim, used in revenue cycle management to reconcile billed charges against contracted rates and calculate patient cost-sharing obligations and write-off amounts.

instrument amountinst_amt

Monetary value associated with a medical instrument or device, representing purchase price, lease value, or billable charge recorded in hospital financial and asset management systems. Used in EHR-integrated cost accounting, procurement databases, and claims processing to support charge capture and capital equipment reporting.

instrument approval statusinst_appr_sts

Indicates the current authorization state of a clinical instrument or assessment tool within a healthcare workflow. Tracks whether the instrument record has been reviewed, approved, pending, or rejected by an authorized clinical or administrative user in the system.

instrument approved byinst_appr_by

Identifies the user who granted authorization or approval for a clinical instrument or assessment tool record. Captures the approving clinician or administrator's identifier, supporting audit trails and accountability within clinical documentation and quality assurance workflows.

instrument arrival timeinst_arrv_tm

Records the specific time a clinical instrument or standardized assessment tool arrived at a facility or was received into inventory. Used in supply chain, sterile processing, or clinical operations workflows to track instrument logistics and turnaround timing.

instrument arrived dateinst_arrv_dt

Records the calendar date a clinical instrument or standardized assessment tool was received at a healthcare facility. Used in supply chain management, sterile processing, and equipment tracking workflows to monitor delivery timelines and inventory replenishment cycles.

instrument assessmentinst_asmt

Contains the clinical evaluation or structured assessment findings associated with a standardized clinical instrument or tool. Captures narrative or coded results from assessments such as screening tools, scoring instruments, or diagnostic evaluations documented in the patient record.

instrument balanceinst_bal

Outstanding financial amount owed or remaining on a medical instrument account within hospital financial systems or leasing platforms. Referenced in healthcare ERP, accounts payable modules, and asset management systems to track depreciation schedules, lease obligations, and capital equipment financial reporting for medical devices.

instrument billed amountinst_bill_amt

Represents the total dollar amount billed to a payer or patient for services or items associated with a clinical instrument. Used in claims processing and revenue cycle management to track charges submitted for reimbursement related to instrument-based procedures or assessments.

instrument birth dateinst_birth_dt

Manufacture date or initial commissioning date assigned to a medical instrument within biomedical engineering and asset management systems. Used in EHR-integrated device registries, maintenance tracking platforms, and regulatory compliance records to calculate device age, schedule lifecycle replacements, and support FDA UDI reporting.

instrument blood pressureinst_bp

Stores the systolic and diastolic blood pressure values captured using a clinical measurement instrument during a patient encounter. Used in clinical documentation and vital signs tracking to monitor cardiovascular health and support diagnostic and treatment decisions.

instrument cancelled dateinst_cncl_dt

Records the calendar date on which a clinical instrument order, assessment, or associated service was cancelled. Used in clinical operations and order management workflows to track cancellation events and support downstream reporting on incomplete or voided instrument activities.

instrument categoryinst_cat

High-level grouping classification assigned to a medical instrument within device management and biomedical engineering systems, such as diagnostic imaging, laboratory analyzer, or surgical tool. Used in EHR asset registries and hospital inventory systems to organize equipment for maintenance scheduling and regulatory reporting.

instrument charge amountinst_chrg_amt

Represents the gross charge applied for use of a clinical instrument or instrument-based service prior to payer adjustments or patient responsibility calculations. Used in revenue cycle and claims management to capture the billed charge before contractual discounts or write-offs are applied.

instrument chief complaintinst_cc

Captures the primary symptom or clinical concern documented in association with a clinical instrument or assessment encounter. Reflects the patient's presenting reason for the visit or evaluation as recorded at the time the instrument-based assessment was initiated in the clinical workflow.

instrument childinst_chld

Subordinate device or component linked to a parent medical instrument within a hierarchical asset management or device registry structure. Used in EHR-integrated biomedical engineering systems to track attachments, modules, or accessories and maintain parent-child relationships for maintenance records, calibration logs, and FDA UDI compliance reporting.

instrument cityinst_city

Stores the city associated with the location of a clinical instrument, such as the facility or site where the instrument is deployed or serviced. Used in equipment management, asset tracking, and regulatory compliance workflows to maintain accurate geographic location data for clinical instruments.

PreviousPage 333 of 806Next