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

dermatology arrived datederm_arrv_dt

The calendar date on which a patient physically arrived at a dermatology facility or clinic for evaluation or treatment. Used in scheduling, operational reporting, and claims data to confirm appointment attendance and establish the date of service for skin specialty encounters.

dermatology assessmentderm_asmt

Free-text or structured clinical evaluation content documented by a dermatologist during a patient encounter, including findings related to skin conditions, lesions, or diagnoses. Used in clinical documentation systems to record the provider's clinical judgment and inform treatment planning.

dermatology balancederm_bal

The remaining dollar amount owed on a dermatology account after insurance payments and adjustments have been applied. Used in healthcare revenue cycle management to track outstanding patient or payer financial obligations for skin specialty care services.

dermatology billed amountderm_bill_amt

The total dollar amount submitted by a dermatology provider on a claim to the payer for skin care services rendered. Used in claims processing as the starting value from which contractual adjustments, allowed amounts, and patient cost-sharing are calculated.

dermatology birth datederm_birth_dt

The date of birth of a patient receiving dermatological care, used to verify member identity, calculate age at time of service, and support age-specific clinical decision-making. Referenced in claims and enrollment data to confirm demographic accuracy for skin specialty visits.

dermatology blood pressurederm_bp

The systolic and diastolic arterial pressure measurement recorded during a dermatology encounter as part of routine vital sign documentation. Used in clinical records to monitor patient cardiovascular status, which may be relevant when prescribing systemic medications for skin conditions.

dermatology cancelled datederm_cncl_dt

The date on which a scheduled dermatology appointment, procedure, or authorization was formally cancelled. Used in scheduling and utilization management systems to track access-to-care gaps, reschedule workflows, and measure no-show or cancellation rates for skin specialty services.

dermatology categoryderm_cat

A classification code or label that groups dermatology services, diagnoses, or records into defined types such as medical dermatology, surgical dermatology, or cosmetic procedures. Used in reporting and analytics to segment skin care utilization, costs, and outcomes by service type.

dermatology charge amountderm_chrg_amt

The fee charged by a dermatology provider for a specific skin care service or procedure before any insurance adjustments or discounts are applied. Used in revenue cycle management and claims data as the gross charge that initiates the adjudication and reimbursement process.

dermatology chief complaintderm_cc

The primary symptom, skin concern, or reason for visit documented in the patient's own words or as recorded by clinical staff at the start of a dermatology encounter. Used in clinical documentation to guide examination focus and support diagnosis coding for skin conditions.

dermatology childderm_chld

Identifies a subordinate dermatology record linked to a parent entry in hierarchical skin specialty data structures. Used to represent nested relationships such as sub-conditions, follow-up procedures, or dependent treatment records within dermatology clinical workflows.

dermatology cityderm_city

The municipality name associated with a dermatology service location, patient address, or referring facility. Used in skin specialty care data to support geographic reporting, care coordination, and network analysis across dermatology service sites and clinical systems.

dermatology classderm_cls

The classification tier assigned to a dermatology record, procedure, or condition. Used to categorize skin specialty care encounters, diagnoses, or treatments into defined groupings that support clinical decision-making, reporting hierarchies, and reimbursement workflows in dermatology data systems.

dermatology codederm_cd

The standardized alphanumeric code identifying a dermatology condition, procedure, or service. Maps to coding systems such as ICD or CPT to enable consistent classification, billing, and reporting of skin specialty care encounters across clinical and administrative healthcare data systems.

dermatology commentderm_cmt

Free-text notation entered by clinical or administrative staff related to a dermatology record, encounter, or patient condition. Captures supplemental skin specialty care details not accommodated by structured fields, supporting clinical documentation and care continuity in dermatology workflows.

dermatology completed datederm_cmpl_dt

The calendar date on which a dermatology service, procedure, or treatment was completed. Used to track care delivery timelines, measure treatment duration, and support quality reporting for skin specialty care encounters across clinical and claims-based data systems.

dermatology confidential indicatorderm_conf_ind

A flag designating a dermatology record as confidential, restricting access to authorized users only. Applied in skin specialty care workflows where sensitive diagnoses such as infectious or stigmatized conditions require privacy protections in compliance with HIPAA or organizational data governance policies.

dermatology countderm_cnt

A numeric value representing the total number of dermatology occurrences, procedures, visits, or related records within a defined period or population. Used in skin specialty care analytics, utilization reporting, and clinical quality measurement across healthcare data systems.

dermatology countryderm_ctry

The nation associated with a dermatology service location, patient address, or referring facility record. Used in skin specialty care data to support international patient tracking, geographic reporting, and cross-border care coordination within clinical and administrative healthcare systems.

dermatology created byderm_crtd_by

The unique identifier of the user or system that originally created a dermatology record. Supports audit trail requirements, data governance, and accountability tracking in skin specialty care clinical and administrative systems, enabling traceability of record origination across dermatology workflows.

PreviousPage 153 of 806Next