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 end timeasmt_end_tm

Timestamp recording the exact time a clinical assessment was completed. Combined with start time, enables precise calculation of assessment duration, supports time-based billing documentation, and contributes to workflow efficiency analysis and clinician scheduling optimization in care settings.

assessment entered byasmt_ent_by

Identifier of the user, clinician, or staff member who entered or submitted a clinical assessment into the system. Supports accountability, audit trail documentation, data quality review, and workflow tracking to determine who is responsible for assessment data capture and completion.

assessment ethnicityasmt_ethn

Patient-reported or recorded ethnicity captured as part of a clinical assessment. Used to support health equity analysis, population stratification, culturally informed care planning, and compliance with federal and payer reporting requirements for demographic data collection in clinical programs.

assessment expiration dateasmt_exp_dt

Date after which a completed clinical assessment is considered outdated and no longer valid for clinical decision-making or regulatory reporting. Drives reassessment scheduling, care plan updates, and compliance monitoring in programs requiring assessments to be refreshed at defined intervals.

assessment external identifierasmt_ext_id

Unique identifier assigned to a clinical assessment by an external system, partner organization, or upstream data source. Enables cross-system record linkage, data reconciliation, and interoperability between EHR platforms, care management systems, health information exchanges, and payer data repositories.

assessment faxasmt_fax

The facsimile number associated with the clinical assessment site or administering clinician. Used to route completed assessment documents, referral results, or follow-up care plans to the appropriate clinical contact in care management workflows.

assessment feeasmt_fee

The charge amount billed for conducting a clinical assessment, such as a health risk assessment or functional evaluation. Captured in care management and claims systems to track reimbursement, cost allocation, and vendor payment for assessment services rendered.

assessment first nameasmt_first_nm

The given name of the individual associated with a clinical assessment record, typically the patient or member being evaluated. Used to identify and match assessment records to the correct person across care management, EHR, and population health platforms.

assessment flagasmt_flg

A binary or coded indicator applied to a clinical assessment record to denote a specific condition, priority, or processing status. Common uses include flagging incomplete assessments, high-risk findings, or records requiring clinical follow-up or quality review.

assessment full nameasmt_full_nm

The complete concatenated name of the patient, member, or clinician associated with a clinical assessment record. Combines first, middle, and last name components to support display, reporting, and identity matching across care management and clinical data systems.

assessment genderasmt_gndr

The sex or gender classification of the patient or member recorded at the time of a clinical assessment. Used in health risk stratification, clinical screening protocols, and population health reporting where gender-specific assessment criteria or normative values apply.

assessment glucoseasmt_gluc

The blood glucose measurement recorded during a clinical assessment, typically expressed in mg/dL. Used in chronic disease management programs, diabetes risk stratification, and health risk assessments to evaluate metabolic status and trigger appropriate care interventions.

assessment hemoglobinasmt_hgb

The hemoglobin measurement captured during a clinical assessment, often recorded as HbA1c for diabetes monitoring or as g/dL for anemia screening. Used in chronic condition management programs to evaluate disease control and inform care plan adjustments.

assessment history present illnessasmt_hpi

The narrative description of a patient's current symptoms, condition onset, and progression as documented during a clinical assessment. Forms a core component of the clinical evaluation record and supports diagnosis coding, care planning, and clinical documentation in EHR systems.

assessment identifierasmt_id

The unique alphanumeric key assigned to a specific clinical assessment record within a healthcare system. Used to link assessment data across care management platforms, EHRs, and data warehouses, enabling longitudinal tracking of evaluations for individual patients or members.

assessment indexasmt_idx

A numeric position or sequence value assigned to a clinical assessment within a series or ordered set of evaluations. Used in longitudinal care management programs to order multiple assessments chronologically and reference specific evaluation instances in reporting and analysis.

assessment indicatorasmt_ind

A coded value that signals the presence, absence, or status of a specific clinical condition or program criterion identified during an assessment. Used in care management and quality reporting to trigger workflows, risk stratification rules, or population health interventions.

assessment instructionasmt_instr

Directional guidance text associated with a clinical assessment, such as preparation requirements, administration protocols, or completion instructions for the patient or clinician. Ensures standardized delivery of assessment tools across care management and clinical programs.

assessment keyasmt_key

A reference value used to uniquely identify or look up a clinical assessment record in a database or data warehouse. Functions as a relational join field linking assessment data to related clinical, member, or claims records across integrated healthcare information systems.

assessment labelasmt_lbl

The human-readable display text assigned to a clinical assessment type or record, such as 'Annual Health Risk Assessment' or 'Depression Screening PHQ-9'. Used in care management platforms and reporting tools to present assessment data in a clinically meaningful format.

PreviousPage 60 of 806Next