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 paid datederm_pd_dt

The date on which payment was received or processed for a dermatology service or claim. Used in revenue cycle management to track reimbursement timelines for skin condition treatments, procedures, and specialist visits, supporting accounts receivable reconciliation and financial reporting.

dermatology parentderm_prnt

The higher-level hierarchical entity to which a dermatology record, category, or organizational unit is linked. Used to establish relationships between sub-specialties, condition groupings, or care programs within dermatology service lines in clinical or administrative data structures.

dermatology percentagederm_pct

A proportional ratio value associated with a dermatology metric, such as body surface area affected, treatment response rate, or cost allocation percentage. Used in clinical assessments and financial reporting to quantify skin condition severity, coverage, or reimbursement distribution.

dermatology periodderm_prd

The defined time interval associated with a dermatology record, such as a treatment duration, coverage period, or reporting cycle. Used to bound clinical or financial data related to skin condition management, enabling period-specific analysis of care delivery and outcomes.

dermatology phonederm_ph

The primary telephone number associated with a dermatology contact, clinic, or patient record. Used in clinical and administrative workflows to facilitate communication regarding skin condition consultations, biopsy results, prescription follow-ups, and appointment coordination within dermatology care settings.

dermatology preferred namederm_pref_nm

The preferred or chosen display name for a dermatology entity, such as a patient, provider, or condition label. Used in clinical interfaces and patient-facing communications to ensure accurate and respectful identification within dermatology care workflows and documentation systems.

dermatology pricederm_prc

The listed or contracted cost assigned to a dermatology service, procedure, or product. Used in healthcare billing and revenue cycle systems to capture the charge amount for skin condition treatments, excisions, phototherapy sessions, or specialist consultations prior to payer adjudication.

dermatology primary indicatorderm_prim_ind

A flag designating whether a dermatology record, diagnosis, or treatment represents the primary skin condition or principal service in a clinical encounter. Used in coding, billing, and clinical documentation to distinguish primary dermatological diagnoses from secondary or comorbid skin conditions.

dermatology priorityderm_prty

The ranked urgency or importance level assigned to a dermatology case, referral, or task. Used in clinical workflow management to triage skin condition cases by severity, guide scheduling of specialist consultations, and prioritize follow-up for high-risk dermatological findings such as melanoma screening.

dermatology procedure datederm_proc_dt

The calendar date on which a dermatological procedure, such as a biopsy, excision, cryotherapy, or phototherapy session, was performed. Used in clinical documentation, claims processing, and outcomes tracking to establish the service date for skin-related procedures within healthcare data systems.

dermatology pulsederm_pulse

Heart rate measurement recorded during a dermatology encounter, captured in beats per minute. Used to monitor cardiovascular status before procedures such as excisions, laser treatments, or biopsies where sedation or local anesthesia may affect patient vitals.

dermatology quantityderm_qty

Numeric count of dermatology-specific items within an encounter, such as lesions treated, units of biologics administered, or number of procedures performed. Used in clinical documentation and claims processing to support billing accuracy for skin specialty services.

dermatology racederm_race

Patient-reported racial identity recorded in the dermatology clinical record. Used to support health equity analysis, as skin conditions such as melanoma, vitiligo, and keloids present differently across racial groups, influencing screening protocols and treatment decisions.

dermatology rangederm_rng

Defined minimum and maximum boundaries for a clinical measurement within a dermatology encounter, such as acceptable dosing ranges for topical treatments or reference intervals for lab values like serum drug levels used in biologic therapy monitoring.

dermatology ratederm_rt

Reimbursement or service rate applied to a dermatology procedure or encounter, expressed as a unit price. Used in claims adjudication and fee schedule management to calculate allowable amounts for services such as biopsies, cryotherapy, or phototherapy sessions.

dermatology ratingderm_rtg

Structured assessment score assigned to a dermatological condition or treatment outcome, such as a psoriasis severity rating or patient satisfaction score. Supports quality measurement, clinical decision-making, and longitudinal tracking of skin condition improvement.

dermatology ratioderm_ratio

Proportional relationship between two clinical measurements in a dermatology context, such as the ratio of affected body surface area to total body area in conditions like psoriasis or eczema. Used to quantify disease extent and guide treatment intensity decisions.

dermatology reasonderm_rsn

Documented clinical justification for a dermatology visit, procedure, or treatment decision. Captures the patient-reported or clinician-identified rationale, such as a new skin lesion, medication side effect, or chronic condition flare, to support coding and authorization workflows.

dermatology received datederm_rcvd_dt

Date on which a dermatology-related document, specimen, referral, or lab result was received by the clinical team or facility. Used to track turnaround times for biopsy pathology reports and to ensure timely follow-up within skin specialty care workflows.

dermatology referencederm_ref

External identifier or pointer linking a dermatology record to a related document, order, prior authorization, or external system. Used to cross-reference pathology reports, referral sources, or clinical guidelines associated with a specific skin condition or treatment episode.

PreviousPage 157 of 806Next