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

anesthesiologist temperatureanes_temp

Records the patient's body temperature, in Celsius or Fahrenheit, as monitored by the anesthesiologist during the perioperative period. Used in anesthesia records to detect hypothermia or hyperthermia, which can affect anesthetic metabolism, drug dosing, and surgical outcomes.

anesthesiologist termination dateanes_term_dt

The date on which an anesthesiologist's privileges, contract, or affiliation with a facility or health system ended. Used in credentialing and provider roster systems to determine active status, validate claims, and ensure anesthesia services were rendered by credentialed personnel.

anesthesiologist timeanes_tm

The specific time of day associated with an anesthesia-related event, such as the start or end of anesthetic administration during a surgical procedure. Used in operative and anesthesia records to calculate duration, support billing accuracy, and document clinical timelines for quality review.

anesthesiologist timestampanes_ts

The combined date and time value marking a specific anesthesia-related event, such as induction, intubation, or case completion. Captured in perioperative systems to support precise billing using anesthesia time units, audit trails, and clinical documentation for surgical encounters.

anesthesiologist titleanes_ttl

The professional designation or credential title of the anesthesiologist, such as MD, DO, or FASA. Stored in credentialing and provider directory systems to ensure accurate identification, proper claim submission, and compliance with payer requirements for anesthesia service billing.

anesthesiologist totalanes_tot

The aggregate numeric value associated with an anesthesiologist's activity, such as total anesthesia time units, total cases performed, or total reimbursement amounts. Used in claims analytics, surgical scheduling, and workforce productivity reporting within anesthesia billing systems.

anesthesiologist total countanes_tot_cnt

The cumulative number of anesthesia cases, procedures, or events attributed to a specific anesthesiologist within a defined period. Used in productivity analysis, surgical volume reporting, and quality metrics to assess anesthesiologist workload and operational capacity within a facility.

anesthesiologist typeanes_typ

The classification of the anesthesia provider, distinguishing roles such as physician anesthesiologist, Certified Registered Nurse Anesthetist (CRNA), or anesthesiologist assistant. Critical for claims adjudication, supervision billing rules, and determining applicable reimbursement rates under Medicare and commercial payer policies.

anesthesiologist updated dateanes_upd_dt

The most recent date on which an anesthesiologist's record was modified in a credentialing, provider directory, or claims system. Used to track data currency, trigger re-credentialing workflows, and ensure payer rosters reflect accurate anesthesia provider information for billing and compliance.

anesthesiologist urgencyanes_urg

The clinical urgency classification assigned to an anesthesia case, such as elective, urgent, or emergent. Captured in anesthesia records and surgical scheduling systems to prioritize operative cases, allocate anesthesia resources appropriately, and document case acuity for quality reporting.

anesthesiologist versionanes_ver

The sequential version number of an anesthesiologist's record within a credentialing or provider management system, incremented each time the record is updated. Supports audit trails, historical data retrieval, and data integrity validation in provider enrollment and claims processing systems.

anesthesiologist zipanes_zip

The postal zip code of the anesthesiologist's practice or billing address. Used in provider directory management, claims routing, and geographic analysis to verify network participation, support state licensure validation, and assess anesthesia provider distribution across service areas.

appointment active indicatorappt_actv_ind

A binary flag indicating whether a scheduled patient appointment is currently active and not cancelled, completed, or voided. Used in scheduling systems to filter valid upcoming appointments, support reminder workflows, and generate accurate patient access and utilization reports.

appointment active statusappt_actv_sts

The current lifecycle state of a scheduled patient appointment, such as scheduled, checked-in, in-progress, completed, or cancelled. Used in scheduling and EHR systems to manage patient flow, track no-shows, and support operational reporting on appointment utilization and slot efficiency.

appointment admission dateappt_admn_dt

The date on which a patient is formally admitted to a facility in connection with a scheduled appointment, typically for inpatient or observation services. Used to link outpatient scheduling records to inpatient encounters and support continuity of care documentation and claims coordination.

appointment assessmentappt_asmt

The structured or free-text clinical evaluation documented by a clinician during or after a scheduled patient appointment, summarizing findings, diagnoses, and care decisions. Captured in EHR systems as part of the SOAP note framework to support clinical decision-making and care continuity.

appointment discharge dateappt_dsch_dt

The date on which a patient was formally discharged from a facility following an inpatient or observation stay associated with a scheduled appointment. Used in care management and claims systems to calculate length of stay, trigger post-discharge follow-up, and support billing reconciliation.

appointment durationappt_dur

The total length of time, typically in minutes, allocated or actually elapsed for a scheduled patient appointment. Used in scheduling systems to optimize provider templates, analyze visit efficiency, reduce patient wait times, and support capacity planning across clinical departments.

appointment emergency indicatorappt_emerg_ind

A flag identifying whether a scheduled appointment was initiated due to an emergency or urgent clinical need rather than routine care. Used in scheduling and triage systems to prioritize patient access, track emergency visit patterns, and support reporting on urgent care utilization across facilities.

appointment history present illnessappt_hpi

The narrative documentation of a patient's current symptoms, onset, duration, and relevant history as recorded during a scheduled appointment. This HPI section of the clinical note supports diagnostic coding, medical necessity determination, and payer requirements for evaluation and management service billing.

PreviousPage 56 of 806Next