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

Technology

Systems, databases, interfaces and data standards

428 technology terms

consent system identifiercsnt_sys_id

Unique system-generated key assigned to a patient consent document record, including informed consent for procedures or data sharing agreements. Used to verify consent status across clinical and compliance systems prior to treatment delivery or protected health information release.

consultation system identifierconsult_sys_id

Unique system-generated key assigned to a specialist consultation request and response record. Used in clinical systems to track referral initiation, specialist findings, and recommendations, linking the consulting clinician's input to the ordering encounter and care plan.

consumable system identifiercons_sys_id

Unique system-generated key assigned to a single-use clinical supply item record, such as syringes, dressings, or IV tubing. Used in supply chain and charge capture systems to track inventory consumption, cost attribution, and billing of disposable items to patient encounters.

counselor system identifiercnsl_sys_id

Unique system-generated key assigned to a licensed mental health counselor or therapist within clinical and behavioral health platforms. Enables consistent tracking of counselor-patient relationships, session history, and treatment outcomes across care coordination and EHR systems.

cpt system identifiercpt_sys_id

Unique system-generated key assigned to a Current Procedural Terminology code record within claims processing and billing systems. Links procedure codes to claims, remittance, and reimbursement workflows, enabling accurate fee schedule lookups, utilization tracking, and medical billing reconciliation.

create datecreate_dt

The date or timestamp recording when a record was first inserted into a healthcare data system. Standard audit column in all healthcare data warehouse tables following ISO-11179 naming conventions. Implemented as create_dt in physical schemas across EHR, claims, pharmacy, and member enrollment systems.

credit system identifiercr_sys_id

Unique system-generated key assigned to a credit transaction representing an overpayment, adjustment, or balance reduction in healthcare billing and accounts receivable systems. Used to track and reconcile financial credits applied against patient accounts, claims, or provider payments.

ct system identifierct_sys_id

Unique system-generated key assigned to a computed tomography imaging record within radiology information systems and clinical data warehouses. Enables tracking of CT scan orders, results, and associated diagnostic reports across imaging workflows and care episodes.

current flagcurr_flg

A boolean indicator identifying the most recent version of a record in a slowly changing dimension table in a healthcare data warehouse. Only one version of each entity has current flag set to true at any point in time. Used alongside effective date and expiration date in SCD Type 2 implementations.

data architectdata_arch

Technical professional responsible for designing and overseeing the data architecture of healthcare information systems. Data architects define data models, integration patterns, governance frameworks, and technology standards for healthcare data platforms. They bridge clinical and business requirements with technical implementations across EHR systems, data warehouses, and analytics platforms.

data architecturedata_arch_def

The design and structure of data systems including data models, storage systems, integration patterns, and governance frameworks within a healthcare organization. Healthcare data architecture encompasses source systems like EHRs and claims platforms, integration layers, data warehouses, and analytics environments. Sound data architecture ensures data quality, security, scalability, and compliance with HIPAA and CMS requirements.

debit system identifierdb_sys_id

Unique system-generated key assigned to a debit transaction representing a charge, balance due, or amount owed within healthcare billing and accounts receivable systems. Supports tracking of financial obligations across patient accounts, claims adjudication, and revenue cycle management workflows.

delete flagdel_flg

A boolean indicator marking a record as logically deleted in a healthcare data system without physically removing it from the database. Supports soft delete patterns required for HIPAA audit trail compliance. Records with delete flag set to true are excluded from active data queries but retained for historical reporting.

dermatology system identifierderm_sys_id

Unique system-generated key assigned to a dermatology specialty record or encounter within clinical and claims systems. Enables tracking of skin-related diagnoses, procedures, and specialist referrals across care management platforms, utilization reporting, and specialty network workflows.

directive system identifierdir_sys_id

Unique system-generated key assigned to a patient care directive, such as an advance directive or do-not-resuscitate order, within clinical documentation systems. Supports consistent retrieval and enforcement of patient care instructions across care settings and clinical decision-making workflows.

document system identifierdoc_sys_id

Unique system-generated key assigned to a clinical or administrative document within health information and document management systems. Enables consistent retrieval, version control, and audit tracking of records such as discharge summaries, consent forms, and clinical notes across healthcare data platforms.

dose system identifierdose_sys_id

Unique system-generated key assigned to a specific medication dose record within pharmacy and medication management systems. Supports tracking of prescribed and administered dose amounts across pharmacy dispensing, medication reconciliation, and clinical decision support workflows.

duration system identifierdur_sys_id

Unique system-generated key assigned to a treatment or therapy duration record within clinical and care management systems. Enables consistent tracking of prescribed treatment time periods across medication management, therapy planning, and longitudinal care coordination workflows.

endocrinology system identifierendo_sys_id

Unique system-generated key assigned to an endocrinology specialty record or encounter within clinical and claims systems. Enables tracking of hormone-related diagnoses, specialist visits, and treatment plans across care management platforms, utilization reporting, and specialty referral workflows.

episode system identifierepsd_sys_id

Unique system-generated key assigned to a defined care episode representing a patient's treatment period for a specific condition. Used in clinical, claims, and population health systems to group related encounters, procedures, and costs into a continuous care event for analysis and reporting.

PreviousPage 3 of 22Next