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 paid dateasmt_pd_dt

The date on which payment was received or posted for a clinical assessment service. Used in revenue cycle management to track reimbursement timelines, reconcile outstanding balances, and report on days-to-payment metrics for assessment-related billing transactions.

assessment parentasmt_prnt

The reference to a higher-level assessment record or evaluation category to which a sub-assessment belongs within a hierarchical clinical assessment structure. Used to organize composite or multi-domain assessments, such as linking individual domain scores to an overall care needs evaluation.

assessment percentageasmt_pct

A percentage value derived from or associated with a clinical assessment, such as a score expressed as a proportion of the maximum possible score. Used for normalized reporting of patient risk levels, functional status ratings, or clinical measure performance across assessment tools.

assessment periodasmt_prd

The defined time interval over which a clinical assessment applies or was conducted, such as the past two weeks for a PHQ-9 depression screen. Used to ensure scoring accuracy, establish clinical relevance of findings, and support longitudinal comparison of repeated assessments.

assessment phoneasmt_ph

The primary telephone contact number associated with the patient or responsible party linked to the clinical assessment record. Used for scheduling follow-up appointments, conducting telephonic assessments, and supporting care coordination outreach following the initial evaluation.

assessment preferred nameasmt_pref_nm

The clinician-designated display name for a clinical assessment instrument or evaluation tool. Used in clinical documentation systems to present assessments in a standardized, human-readable format across care settings, ensuring consistent identification in patient records and clinical workflows.

assessment priceasmt_prc

The monetary cost assigned to administering or processing a specific clinical assessment. Used in revenue cycle management and clinical billing workflows to capture charges associated with structured evaluations such as cognitive screenings, functional assessments, or standardized diagnostic tools.

assessment primary indicatorasmt_prim_ind

A boolean or coded flag identifying whether a clinical assessment is designated as the primary evaluation among multiple assessments recorded for a patient encounter. Used to distinguish the principal assessment driving clinical decision-making from supplementary or secondary evaluations in the patient record.

assessment priorityasmt_prty

A ranked value indicating the urgency or clinical importance assigned to completing or reviewing a patient assessment. Used in care coordination and clinical workflow management to sequence assessments by medical necessity, ensuring critical evaluations such as fall risk or pain screening are addressed within required timeframes.

assessment procedure dateasmt_proc_dt

The calendar date on which a specific clinical assessment procedure was performed on a patient. Used in longitudinal care tracking and clinical reporting to establish temporal relationships between assessments and treatments, supporting care plan evaluation and regulatory compliance documentation.

assessment pulseasmt_pulse

The patient's heart rate, measured in beats per minute, recorded as part of a clinical assessment or vital signs evaluation. Captured during nursing assessments or structured clinical encounters to monitor cardiovascular status, establish baselines, and detect abnormalities requiring clinical intervention.

assessment quantityasmt_qty

The numeric count or measurable volume associated with a clinical assessment element, such as the number of assessment instruments administered, dosage units evaluated, or frequency of observations recorded during a patient evaluation within a defined clinical encounter or care episode.

assessment raceasmt_race

The patient's self-reported or clinician-recorded racial identity captured during a clinical assessment. Used in population health analytics, health equity reporting, and social determinants of health documentation to identify care disparities and ensure compliance with federal and accreditation demographic data collection requirements.

assessment rangeasmt_rng

The defined minimum and maximum boundary values for an acceptable or expected clinical assessment result. Used to contextualize patient measurements against established clinical norms, flagging values that fall outside reference intervals for conditions such as lab results, vital signs, or standardized scoring scales.

assessment rateasmt_rt

The calculated per-unit or per-time-period value associated with a clinical assessment metric, such as a respiratory rate per minute or a billing rate per assessment encounter. Used in clinical measurement interpretation and healthcare financial systems to standardize assessment data for comparison and reimbursement purposes.

assessment ratingasmt_rtg

A scored or categorical value assigned to a patient based on structured clinical evaluation criteria, such as a pain intensity scale, functional status score, or risk stratification level. Used in care planning and outcomes tracking to quantify patient condition severity and monitor changes across assessment intervals.

assessment ratioasmt_ratio

A proportional value derived from two or more clinical assessment measurements, such as a waist-to-hip ratio or an observed-to-expected outcome ratio. Used in clinical analytics and population health management to express relationships between assessment variables and support risk scoring or clinical benchmarking.

assessment reasonasmt_rsn

The documented clinical justification or triggering condition that prompted the initiation of a patient assessment. Used in care management and utilization review to record why a specific evaluation was ordered, supporting medical necessity determinations, care plan development, and regulatory audit documentation.

assessment received dateasmt_rcvd_dt

The date on which a completed clinical assessment was received by the care team, facility, or data system, particularly relevant for externally administered or mailed assessments such as patient-reported outcome measures. Used to track assessment submission timeliness and establish data processing timelines in care management workflows.

assessment referenceasmt_ref

An identifier or pointer linking a clinical assessment record to an external source, related document, or standardized instrument, such as a validated screening tool version, prior assessment record, or external clinical guideline. Used to maintain data lineage and traceability across clinical documentation and reporting systems.

PreviousPage 62 of 806Next