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

assessment countasmt_cnt

The total number of clinical evaluations completed for a member within a defined period or program. Used in population health analytics, care management reporting, and quality measurement to assess member engagement frequency and intensity of clinical oversight across programs.

assessment countryasmt_ctry

The country associated with the location where a clinical evaluation occurred or the patient's address on record at the time of assessment. Supports international member reporting, cross-border care coordination, and geographic segmentation in global health plan administration systems.

assessment created byasmt_crtd_by

The unique identifier of the user, clinician, or system that initially created the clinical evaluation record. Provides an audit trail for data governance, accountability tracking, and workflow management within EHR, care management, and clinical data warehouse environments.

assessment created dateasmt_crtd_dt

The calendar date on which the clinical evaluation record was first entered into the system, which may differ from the date of the actual assessment encounter. Supports audit trail requirements, data lineage tracking, and workflow timestamp analysis in care management systems.

assessment created timeasmt_crtd_tm

The exact clock time at which a clinical evaluation record was first created in the system. Used alongside the created date to establish a precise audit timestamp for data governance, workflow sequencing analysis, and system integration logging across clinical and administrative platforms.

assessment creatinineasmt_cr

Serum or plasma creatinine value recorded during a clinical assessment, used to evaluate kidney filtration function. Elevated levels indicate impaired renal function and inform care planning decisions, medication dosing adjustments, and chronic kidney disease staging in clinical documentation.

assessment dateasmt_dt

Calendar date on which a clinical assessment was conducted or documented. Used to establish the temporal context of patient evaluations, track assessment frequency, measure gaps in care, and align findings with corresponding clinical encounters, care plans, or quality reporting periods.

assessment datetimeasmt_dttm

Combined date and timestamp recording the exact moment a clinical assessment was performed or entered into the system. Supports precise sequencing of clinical events, audit trail requirements, time-sensitive condition monitoring, and longitudinal patient record accuracy across care settings.

assessment dea numberasmt_dea_nbr

Drug Enforcement Administration registration number associated with the clinician who conducted or authorized a clinical assessment, particularly relevant when the assessment involves controlled substance prescribing. Used to verify prescriber authority and maintain regulatory compliance in clinical documentation.

assessment death dateasmt_death_dt

Date of patient death as recorded within or linked to a clinical assessment record. Used to close active care plans, terminate ongoing assessments, support mortality reporting, and align clinical documentation with vital status updates in population health and quality measurement workflows.

assessment deleted dateasmt_del_dt

Date on which a clinical assessment record was marked as deleted or voided within the system. Supports audit trail integrity, data governance, and soft-delete workflows where records are retained for historical reference but excluded from active clinical reporting and care planning views.

assessment deleted indicatorasmt_del_ind

Boolean or coded flag identifying whether a clinical assessment record has been voided, retracted, or soft-deleted. Allows downstream systems to exclude invalidated assessments from active reporting while preserving the record for audit, compliance, and historical data integrity purposes.

assessment descriptionasmt_desc

Free-text or standardized narrative explaining the nature, purpose, or findings of a clinical assessment. Provides human-readable context for the evaluation type, observed conditions, or clinical conclusions, supporting care coordination, clinical decision-making, and documentation completeness in patient records.

assessment detailasmt_dtl

Granular clinical findings, responses, scored items, or structured observations captured within a specific assessment. Represents the underlying data points that comprise the full assessment record, supporting clinical interpretation, quality scoring, risk stratification, and longitudinal outcome tracking.

assessment discharge dateasmt_dsch_dt

Date on which a patient was discharged from a facility or episode of care that is associated with a clinical assessment. Used to determine post-discharge follow-up requirements, measure length of stay, and link inpatient assessments to transitions of care and readmission risk workflows.

assessment due dateasmt_due_dt

Target date by which a scheduled clinical assessment must be completed for a patient. Used in care management workflows to trigger outreach, ensure compliance with assessment intervals required by clinical guidelines, regulatory programs, or payer contracts, and track overdue evaluations.

assessment durationasmt_dur

Length of time elapsed during the completion of a clinical assessment, typically measured in minutes. Used to support clinical workflow analytics, billing documentation for time-based services, clinician productivity reporting, and quality review of assessment thoroughness and patient engagement.

assessment emailasmt_eml

Email address associated with the patient, caregiver, or clinician linked to a clinical assessment record. Used to facilitate assessment delivery, result notification, follow-up communication, and patient engagement workflows in digital health platforms and care management programs.

assessment emergency indicatorasmt_emerg_ind

Flag identifying whether a clinical assessment was conducted under emergency or urgent care circumstances. Distinguishes routine from emergent evaluations for clinical prioritization, billing classification, triage reporting, and analysis of acute care utilization patterns within population health data.

assessment end dateasmt_end_dt

Date on which a clinical assessment was completed or closed. Marks the conclusion of the evaluation period, supports measurement of assessment duration, and enables reporting on timely completion of assessments relative to scheduled due dates and care management program requirements.

PreviousPage 59 of 806Next