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

acuity childacu_chld

A subordinate acuity record linked to a parent acuity assessment in a hierarchical clinical data structure. Used in healthcare information systems to represent dependent severity classifications, such as sub-assessments or reassessments associated with a primary acuity event, supporting longitudinal tracking of patient condition changes.

acuity cityacu_city

The name of the municipality associated with a patient's address at the time an acuity severity assessment was recorded. Used in clinical and administrative data systems to support geographic analysis of acuity patterns, population health reporting, and identification of regional care utilization trends across patient demographics.

acuity classacu_cls

A tiered classification value assigned to a patient acuity severity assessment, representing the overall intensity level of care required. Used in clinical and operational systems to drive staffing models, care prioritization workflows, and reimbursement determinations based on standardized acuity classification frameworks such as ESI or RAPS.

acuity codeacu_cd

Standardized code classifying a patient's condition severity level within clinical assessment systems. Used in triage, care management, and utilization review workflows to stratify patients by clinical complexity and assign appropriate levels of care and resource allocation.

acuity commentacu_cmt

Free-text narrative entered by a clinician or care manager to document supplemental observations about a patient's condition severity assessment. Captures nuanced clinical context that structured acuity codes cannot convey, supporting care planning and clinical decision-making workflows.

acuity completed dateacu_cmpl_dt

The calendar date on which a patient's acuity or condition severity assessment was finalized by a clinician or care team. Used in care management and utilization review systems to track assessment cycle completion, measure timeliness, and ensure compliance with clinical protocols.

acuity confidential indicatoracu_conf_ind

Boolean flag indicating whether a patient's condition severity assessment record is designated as confidential and subject to restricted access. Applied in clinical data systems to enforce privacy controls for sensitive diagnoses such as behavioral health or substance use-related acuity evaluations.

acuity countacu_cnt

Numeric value representing the total number of acuity or condition severity assessments recorded for a patient within a defined period. Used in care management analytics and population health reporting to identify high-frequency assessment patterns and monitor patient clinical instability over time.

acuity countryacu_ctry

Country associated with the location where a patient's condition severity assessment was conducted or documented. Used in multinational health systems and global care management platforms to support geographic reporting, regulatory compliance, and cross-border patient care coordination.

acuity created byacu_crtd_by

Identifier of the user, clinician, or system that initially created the acuity or condition severity assessment record. Used for audit trail purposes in clinical and care management systems to establish accountability, support data governance, and enable record provenance tracking.

acuity created dateacu_crtd_dt

The calendar date on which the acuity or condition severity assessment record was first entered into the clinical or care management system. Used to establish record provenance, support audit trails, and measure lag time between patient encounter events and documentation completion.

acuity created timeacu_crtd_tm

The timestamp indicating when the acuity or condition severity assessment record was first created in the clinical or care management system. Combined with the created date to provide precise record provenance, supporting audit logging, workflow monitoring, and data lineage tracking.

acuity creatinineacu_cr

Serum or urine creatinine laboratory value recorded as part of a patient's acuity or condition severity assessment. Used in clinical decision support and care management systems to evaluate kidney function, identify acute kidney injury risk, and inform severity scoring models such as APACHE or SOFA.

acuity dateacu_dt

The calendar date on which a patient's condition severity level was formally assessed or assigned by a clinician or care manager. Used in clinical workflows and care management systems to track when acuity determinations were made, enabling trend analysis and care escalation monitoring.

acuity datetimeacu_dttm

Combined date and time value recording the precise moment a patient's condition severity assessment was conducted or documented. Used in clinical and care management systems to support time-sensitive workflows such as triage sequencing, escalation tracking, and regulatory reporting requirements.

acuity dea numberacu_dea_nbr

Drug Enforcement Administration registration number associated with a prescribing clinician involved in a patient's acuity-related care episode. Recorded in clinical systems to maintain prescriber identity linkage when controlled substances are part of the treatment plan tied to the severity assessment.

acuity death dateacu_death_dt

The recorded date of patient death associated with an acuity or condition severity episode. Used in clinical outcome tracking, mortality analytics, and population health reporting to correlate severity levels with patient outcomes and evaluate the predictive validity of acuity classification systems.

acuity deleted dateacu_del_dt

The calendar date on which an acuity or condition severity assessment record was marked as deleted within the clinical or care management system. Retained for audit trail and data governance purposes to document when and why a record was removed from active use without physical deletion.

acuity deleted indicatoracu_del_ind

Boolean flag identifying whether an acuity or condition severity assessment record has been logically deleted from active clinical or care management workflows. Enables soft-delete functionality, preserving historical data integrity for audit, compliance, and retrospective clinical analysis purposes.

acuity descriptionacu_desc

Human-readable text label describing the acuity or condition severity classification assigned to a patient. Displayed in clinical dashboards, care management tools, and reports to communicate severity levels clearly to clinicians, care coordinators, and administrative staff without requiring code interpretation.

PreviousPage 20 of 806Next