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 created datederm_crtd_dt

The calendar date on which a dermatology record was first entered into the clinical or administrative system. Used to establish data lineage, support audit trail requirements, and track record origination timelines across skin specialty care workflows and healthcare data systems.

dermatology created timederm_crtd_tm

The timestamp recording the exact time a dermatology record was first created in the system. Combined with the created date, this provides precise audit trail data supporting data governance, record traceability, and workflow sequencing within skin specialty care clinical systems.

dermatology creatininederm_cr

The serum creatinine laboratory value recorded in the context of a dermatology encounter. Used to assess kidney function prior to prescribing systemic medications such as retinoids or immunosuppressants used in skin specialty care treatment, ensuring safe medication management and monitoring.

dermatology datederm_dt

A general calendar date value associated with a dermatology record, encounter, or clinical event. Provides temporal context for skin specialty care activities including diagnoses, treatments, and administrative transactions, supporting chronological reporting and timeline analysis in healthcare data systems.

dermatology datetimederm_dttm

A combined date and time value capturing the precise moment of a dermatology event, encounter, or data transaction. Supports accurate sequencing of skin specialty care activities, clinical decision timestamps, and audit trail requirements across dermatology clinical and administrative systems.

dermatology dea numberderm_dea_nbr

The Drug Enforcement Administration registration number associated with a dermatologist authorized to prescribe controlled substances. Used in skin specialty care workflows to validate prescriber credentials when issuing prescriptions for controlled medications such as certain pain or sedation agents used in dermatologic procedures.

dermatology death datederm_death_dt

The recorded date of death for a patient associated with a dermatology record. Used in skin specialty care data systems to close active treatment records, update population health registries, and support mortality reporting and longitudinal outcome analysis for dermatology patient cohorts.

dermatology deleted datederm_del_dt

The calendar date on which a dermatology record was marked as deleted within the clinical or administrative system. Supports soft-delete audit trails, data retention compliance, and record lifecycle management in skin specialty care data environments without permanently removing historical information.

dermatology deleted indicatorderm_del_ind

A flag indicating that a dermatology record has been logically removed from active use without physical deletion. Used in skin specialty care data systems to maintain audit integrity, exclude inactive records from reporting, and support data retention policies while preserving historical record access.

dermatology descriptionderm_desc

A human-readable textual explanation of a dermatology record, condition, procedure, or service. Provides clinical context for coded skin specialty care data, supporting end-user display, clinical documentation clarity, and reporting legibility across dermatology workflows and healthcare data systems.

dermatology detailderm_dtl

Supplemental clinical information captured for a dermatology encounter or referral, including lesion characteristics, biopsy findings, treatment notes, or procedure specifics. Used in EHR systems to document skin condition assessments and support continuity of dermatologic care.

dermatology discharge datederm_dsch_dt

The calendar date on which a patient was discharged from an inpatient or outpatient dermatology facility following treatment for a skin condition. Used in claims processing and utilization management to calculate length of stay and validate billing for dermatologic procedures.

dermatology due datederm_due_dt

The date by which a dermatology-related action must be completed, such as a follow-up appointment, authorization renewal, or treatment milestone. Used in care management workflows to track compliance with dermatologic treatment plans and referral timelines.

dermatology durationderm_dur

The measured length of time associated with a dermatology encounter, treatment course, or skin condition episode. Used in clinical documentation and claims analytics to assess treatment intensity, procedure time, or the persistence of a diagnosed dermatologic condition across episodes of care.

dermatology emailderm_eml

The electronic mail address associated with a patient, referring provider, or dermatology clinic contact record. Used in care coordination workflows to facilitate secure communications regarding referrals, appointment scheduling, and follow-up instructions for dermatologic conditions.

dermatology emergency indicatorderm_emerg_ind

A flag indicating whether a dermatology encounter or referral was classified as emergent, requiring immediate clinical attention for acute skin conditions such as Stevens-Johnson syndrome, severe burns, or rapidly progressing infections. Used in triage and claims adjudication workflows.

dermatology end datederm_end_dt

The date marking the conclusion of a dermatology treatment episode, authorization period, or referral window. Used in utilization management and claims processing to define the boundary of covered dermatologic services and ensure accurate adjudication of time-limited authorizations.

dermatology end timederm_end_tm

The recorded time at which a dermatology procedure, clinical encounter, or treatment session concluded. Used in facility and professional billing to calculate procedure duration, support operating room scheduling, and validate time-based billing codes for dermatologic services.

dermatology entered byderm_ent_by

The identifier of the user, clinician, or system responsible for entering a dermatology record into the healthcare information system. Used in audit trails and data governance workflows to track accountability, support compliance reviews, and identify data entry patterns in dermatologic documentation.

dermatology ethnicityderm_ethn

The self-reported or assigned ethnicity of a patient receiving dermatologic care. Used in population health analytics and clinical research to identify disparities in skin condition prevalence, treatment outcomes, and access to dermatology services across ethnic demographic groups.

PreviousPage 154 of 806Next