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

scan approved byscn_appr_by

Records the identity of the clinician, administrator, or automated system that granted authorization for a diagnostic imaging scan. Used in audit trails and clinical workflows to establish accountability, support compliance reviews, and track approval authority within radiology ordering systems.

scan arrival timescn_arrv_tm

The timestamp recording when a patient arrived at the imaging facility or radiology department for a scheduled scan. Used to measure wait times, operational throughput, and scheduling efficiency metrics in radiology information systems and hospital performance dashboards.

scan arrived datescn_arrv_dt

The calendar date on which a patient presented at the imaging facility for a diagnostic scan procedure. Used alongside arrival time to calculate scheduling adherence, patient flow metrics, and turnaround performance in radiology department operations and quality reporting.

scan assessmentscn_asmt

The radiologist or ordering clinician's structured clinical evaluation associated with a diagnostic imaging scan, summarizing findings, impressions, or diagnostic conclusions. This narrative supports downstream care decisions, specialist referrals, and integration into the patient's longitudinal clinical record.

scan balancescn_bal

Outstanding financial amount remaining after payments are applied to a scanned claim or document in claims adjudication and PBM systems. Data engineers use this field to track unpaid liabilities and reconcile accounts receivable in billing workflows.

scan billed amountscn_bill_amt

The gross charge amount submitted by the imaging provider to the payer on a claim for a diagnostic scan service. Represents the provider's full fee before contractual adjustments, write-offs, or payer discounts are applied during the claims adjudication process.

scan birth datescn_birth_dt

Date of birth extracted or captured during document scanning in EHR intake and member enrollment systems. Data engineers use this field to validate member identity, perform deduplication, and match scanned records to existing patient or member master data.

scan blood pressurescn_bp

The patient's systolic and diastolic blood pressure reading captured at the time of a diagnostic imaging scan encounter. Critical for contrast-enhanced studies where hemodynamic stability must be confirmed, and used as a pre-procedure safety screening vital sign in radiology workflows.

scan cancelled datescn_cncl_dt

The date on which a previously scheduled diagnostic imaging scan was formally cancelled in the scheduling or radiology information system. Used to track cancellation patterns, measure no-show rates, support rescheduling workflows, and analyze operational efficiency in imaging departments.

scan categoryscn_cat

Classification grouping assigned to a scanned document during ingestion into EHR, claims, or document management systems. Data engineers use this field to route scanned files to appropriate processing queues, such as clinical records, EOBs, or prior authorization forms.

scan charge amountscn_chrg_amt

The specific service fee assessed for a diagnostic imaging scan procedure before insurance adjustments or payments are applied. Used in revenue cycle management to initiate billing transactions, reconcile patient accounts, and report gross revenue for imaging service lines.

scan chief complaintscn_cc

The primary symptom, clinical concern, or reason documented by the patient or ordering clinician that prompted the diagnostic imaging scan order. Drives medical necessity determinations for prior authorization, payer coverage decisions, and appropriate imaging protocol selection in radiology workflows.

scan childscn_chld

Identifier denoting a subordinate or dependent document relationship within a hierarchical scan batch in EHR and claims imaging systems. Data engineers use this field to reconstruct multi-page document trees and link child records to parent scan transactions during ETL processing.

scan cityscn_city

The city where the imaging facility or radiology site performing the diagnostic scan is located. Used in geographic reporting, network adequacy analysis, claims adjudication for place-of-service validation, and member access studies to assess imaging service availability by region.

scan classscn_cls

Classification tier assigned to a scanned document defining its type, priority, or processing pathway in claims and EHR document management systems. Data engineers reference this field to apply appropriate transformation rules and downstream routing logic during ingestion pipelines.

scan codescn_cd

Standardized classification code assigned to a scanned document or medical image in EHR, claims, and pharmacy systems. Data engineers use this field to categorize document types, trigger workflow routing, and map scanned records to structured data elements during claims or enrollment processing.

scan commentscn_cmt

Free-text annotation associated with a scanned document or image capture in EHR and claims document management systems. Data engineers parse this field during ingestion to extract operational notes, exception flags, or processing instructions that supplement structured scan metadata records.

scan completed datescn_cmpl_dt

The date on which a diagnostic imaging scan procedure was fully performed and finalized in the radiology information system. Used to calculate turnaround times for report delivery, measure operational efficiency, and establish the service date for claims billing and reimbursement purposes.

scan confidential indicatorscn_conf_ind

A flag designating that a diagnostic imaging scan record contains sensitive or restricted information requiring enhanced privacy controls, such as scans related to behavioral health, substance use, or reproductive care. Governs access permissions and data sharing rules under HIPAA and applicable state privacy regulations.

scan contactscn_cntct

Communication reference point, such as a name or phone number, associated with a scanned document in EHR intake and claims systems. Data engineers use this field to link scanned records to provider or member contact data for follow-up workflows and audit trail reconstruction.

PreviousPage 611 of 806Next