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 last namederm_last_nm

Family surname of a patient or dermatology provider recorded in specialty care systems. Used for patient identification, appointment scheduling, clinical documentation, and accurate matching of dermatology records across registration, billing, and electronic health record systems.

dermatology legal namederm_legal_nm

Official government-registered name of a patient or dermatology provider as recorded for clinical, billing, and credentialing purposes. Used to ensure accurate identity verification, insurance claims submission, and compliance with regulatory requirements in dermatology specialty care settings.

dermatology levelderm_lvl

Hierarchical classification value indicating the severity, complexity, or organizational tier associated with a dermatology condition, service, or care pathway. Used to stratify patient acuity, assign appropriate service codes, and route cases within dermatology specialty care management workflows.

dermatology license numberderm_lic_nbr

State-issued professional license identifier for a licensed dermatologist or skin care provider. Used for credentialing verification, provider enrollment, regulatory compliance, and accurate attribution of dermatology services on clinical records and insurance claims submissions.

dermatology marital statusderm_mar_sts

Recorded legal relationship status of a patient receiving dermatology specialty care. Used in demographic data collection to support insurance eligibility determination, dependent coverage verification, and population health reporting within dermatology clinical and administrative data systems.

dermatology master identifierderm_mstr_id

Enterprise master record identifier that uniquely resolves a patient or entity across multiple dermatology and health system data sources. Used for master patient index matching, record deduplication, and longitudinal skin care tracking across affiliated clinics, hospitals, and specialty networks.

dermatology maximumderm_max

Upper threshold or limit value defined within a dermatology clinical or administrative context, such as maximum allowable dosage for a topical treatment, highest covered visit count under a dermatology benefit, or upper boundary for a clinical measurement used in skin condition severity scoring.

dermatology medical record numberderm_mrn

Unique patient medical record number assigned within a dermatology practice or health system. Used to retrieve clinical history, link encounter documentation, track skin condition progression, and coordinate care across dermatology visits, pathology labs, and referring provider systems.

dermatology middle namederm_mid_nm

Middle name or initial of a patient or dermatology provider recorded to support accurate identity matching and disambiguation. Used alongside first and last name fields in clinical registration, insurance eligibility verification, and dermatology records management to prevent duplicate or mismatched records.

dermatology minimumderm_min

Lower threshold or baseline value defined within a dermatology clinical or administrative context, such as minimum treatment frequency, lowest covered benefit threshold, or baseline measurement for a clinical parameter used to assess skin condition status and guide dermatology care decisions.

dermatology mobilederm_mob

The mobile phone number associated with a dermatology encounter, patient, or specialist contact record. Used in clinical workflows to support direct communication regarding skin condition diagnoses, treatment follow-ups, biopsy results, and appointment scheduling within dermatology care settings.

dermatology modified byderm_mod_by

The unique identifier of the user who last updated a dermatology record, such as a skin condition diagnosis, treatment plan, or procedure note. Supports audit trail requirements and accountability tracking across clinical data systems managing dermatological care documentation.

dermatology modified datederm_mod_dt

The calendar date on which a dermatology record was most recently updated. Used in audit logging and data governance workflows to track when skin condition assessments, treatment plans, biopsy findings, or clinical documentation were last revised within the health information system.

dermatology modified timederm_mod_tm

The timestamp indicating the exact time a dermatology record was last updated. Combined with the modified date, this field supports precise audit trail logging for changes to skin condition diagnoses, treatment protocols, or procedural documentation in clinical data systems.

dermatology namederm_nm

The human-readable label assigned to a dermatology record, condition, procedure, or specialist entity. Used to identify and display skin-related diagnoses, treatment categories, or dermatology service line entries in clinical interfaces, reports, and patient-facing documentation.

dermatology notederm_nt

Free-text annotation capturing clinical observations, treatment rationale, follow-up instructions, or procedural details associated with a dermatology encounter. Used by clinicians to document skin condition findings, biopsy interpretations, or care plan modifications not captured in structured data fields.

dermatology numberderm_nbr

A unique numeric reference identifier assigned to a dermatology record, encounter, or case within the healthcare information system. Used to track and cross-reference skin condition cases, specialist referrals, and dermatological procedures across clinical and administrative systems.

dermatology onset datederm_onset_dt

The calendar date on which a dermatological condition or skin-related symptom first appeared or was first reported by the patient. Used in clinical documentation to establish disease progression timelines, evaluate treatment response, and support diagnostic coding for skin conditions.

dermatology oxygen saturationderm_o2sat

The recorded blood oxygen saturation level captured during a dermatology encounter or procedure. Relevant in dermatological procedures requiring sedation or in patients with systemic conditions affecting the skin, where monitoring SpO2 is required to ensure patient safety during treatment.

dermatology paid amountderm_pd_amt

The monetary amount reimbursed or paid for a dermatology service, procedure, or claim. Used in healthcare financial systems to track payments made by payers or patients for skin condition treatments, biopsies, excisions, or specialist consultations within the revenue cycle.

PreviousPage 156 of 806Next