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 resolution datederm_resol_dt

Date on which a dermatological condition, such as a skin infection, acute flare, or post-procedure wound, was documented as resolved. Used in longitudinal clinical records to calculate episode duration and evaluate treatment effectiveness in skin specialty care.

dermatology respirationderm_resp

Respiratory rate recorded as breaths per minute during a dermatology encounter. Relevant when monitoring patients undergoing sedation for extensive procedures, or when systemic conditions such as drug hypersensitivity reactions or severe eczema may compromise respiratory status.

dermatology resultderm_rslt

Outcome of a dermatology-related clinical test, procedure, or intervention, such as a biopsy pathology finding, patch test result, or treatment response assessment. Used to drive subsequent care decisions, including diagnosis confirmation and therapy modification.

dermatology revisionderm_rev

Version number indicating an update to a dermatology clinical document, treatment plan, or procedure note. Tracks amendments made to records such as pathology interpretations, care protocols, or prior authorization requests within the skin specialty care workflow.

dermatology riskderm_rsk

Assessed likelihood of adverse outcomes for a dermatology patient, including risk of malignancy for atypical lesions, infection risk following procedures, or adverse drug reactions from systemic therapies such as immunosuppressants or biologics used in skin specialty care.

dermatology routederm_rte

Method by which a dermatological treatment or medication is administered, such as topical, intralesional, subcutaneous injection, or oral. Critical for accurate medication reconciliation, clinical documentation, and pharmacy dispensing in skin specialty care settings.

dermatology scorederm_scr

Standardized numeric value derived from a validated dermatology assessment tool, such as the PASI score for psoriasis, EASI for eczema, or DLQI for quality of life impact. Used to measure disease severity, guide biologic eligibility, and monitor treatment response.

dermatology sequencederm_seq

Numeric ordering value that defines the position of a dermatology record, procedure, or treatment step within a series. Used to maintain the correct order of multiple skin procedures performed during a single encounter or across a structured treatment regimen.

dermatology severityderm_sev

Clinical classification of the seriousness of a dermatological condition, typically categorized as mild, moderate, or severe. Drives treatment pathway selection, biologic therapy authorization thresholds, and reporting for conditions such as psoriasis, atopic dermatitis, or acne.

dermatology sexderm_sex

Biological sex recorded in the dermatology clinical record, used to contextualize diagnosis and treatment decisions. Relevant because skin conditions such as rosacea, lupus-related skin manifestations, and androgenic alopecia have sex-specific prevalence, presentation, and treatment responses.

dermatology sourcederm_src

Identifies the originating system, facility, or referral pathway for a dermatology encounter or record. Tracks whether skin condition data was captured via primary care referral, telehealth, urgent care, or direct specialist visit in clinical data systems.

dermatology start datederm_start_dt

The calendar date on which a dermatology treatment, condition episode, or care plan was initiated. Used in clinical data systems to establish the onset timeline for skin conditions, therapies, or specialist care authorization periods for longitudinal tracking.

dermatology start timederm_start_tm

The precise time at which a dermatology procedure, consultation, or treatment session began. Captured in clinical scheduling and EHR systems to support accurate duration calculations, resource utilization reporting, and chronological ordering of skin care events.

dermatology statederm_st

The US state or territory where a dermatology service was rendered or where the treating dermatologist is licensed. Used in claims processing and credentialing systems to apply state-specific billing rules, licensure validation, and geographic utilization reporting.

dermatology statusderm_sts

Indicates the current processing or clinical state of a dermatology record, such as active, pending, completed, or cancelled. Used in care management and claims systems to track the lifecycle of skin condition treatment episodes, referrals, or prior authorizations.

dermatology strengthderm_str

The concentration or potency of a topical or systemic medication prescribed within a dermatology treatment plan, such as betamethasone 0.05%. Captured in pharmacy and clinical records to ensure accurate dispensing, dosage tracking, and therapeutic monitoring for skin conditions.

dermatology subtotalderm_subtot

A partial sum of charges, units, or services rendered within a dermatology claim or encounter before final adjustments, taxes, or additional line items are applied. Used in claims adjudication systems to support cost transparency and reimbursement calculations for skin care services.

dermatology surgery datederm_surg_dt

The calendar date on which a dermatologic surgical procedure was performed, such as excision, Mohs surgery, or laser resurfacing. Captured in operative and claims records to support surgical episode tracking, post-operative follow-up scheduling, and procedure-based reimbursement.

dermatology targetderm_tgt

The intended recipient system, anatomical site, or treatment goal associated with a dermatology record or clinical workflow. Used in care management and interoperability contexts to route skin condition data to the correct downstream system or specialist for follow-up.

dermatology taxonomy codederm_tax_cd

The NUCC Health Care Provider Taxonomy code identifying the specific dermatology specialty classification of the rendering clinician, such as 207N00000X for Dermatology. Used in claims and credentialing systems to validate provider specialty and determine appropriate reimbursement rates.

PreviousPage 158 of 806Next