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

experience rangeexp_rng

Defines the minimum and maximum value boundaries for a patient experience survey metric or satisfaction score. Used in patient experience reporting to establish acceptable score thresholds and flag outlier responses that fall outside expected performance benchmarks for quality improvement analysis.

experience resultexp_rslt

Records the quantitative or qualitative outcome of a patient experience survey or satisfaction assessment. Captures the actual measured score or response value tied to a specific care encounter, used in quality reporting to evaluate service delivery performance and patient-reported care perceptions.

experience routeexp_rte

Identifies the channel or method through which a patient experience survey was administered, such as phone, mail, email, or in-person. Used in patient satisfaction data management to track survey distribution methods and analyze whether delivery channel influences response rates or outcome scores.

experience surgery dateexp_surg_dt

Captures the calendar date on which a surgical procedure was performed that is associated with a patient experience survey response. Used to correlate post-surgical satisfaction scores with specific operative events, enabling quality teams to evaluate care perception relative to surgical timing.

extract dateextract_dt

The date on which data was extracted from a source system for loading into a healthcare data warehouse. May differ from load date when extraction and loading occur at different times. Used in ETL pipeline monitoring and data freshness SLA tracking for healthcare data integration.

facility admission datefac_admn_dt

The date on which a patient was formally admitted to a healthcare facility such as a hospital or skilled nursing facility. Stored in EHR and claims systems as a critical encounter attribute used to calculate length of stay, apply DRG grouping logic, trigger utilization management rules, and support inpatient claims adjudication and quality reporting.

facility discharge datefac_dsch_dt

The calendar date on which a patient is formally released from a hospital or institutional care setting. Captured in EHR, claims, and UB-04 billing systems to calculate length of stay, trigger post-discharge workflows, and support readmission analytics and facility reimbursement processing.

facility labelfac_lbl

Stores the human-readable display name assigned to a healthcare service location such as a hospital, clinic, or outpatient center. Used in reporting and member-facing documents to identify where services were rendered, linking claims and encounter records to a recognizable facility name.

facility procedure datefac_proc_dt

Records the calendar date on which a clinical procedure was performed at a specific healthcare facility. Used in claims processing and encounter data to establish the service date for outpatient or inpatient procedures, supporting adjudication, utilization review, and episode-of-care analysis.

facility surgery datefac_surg_dt

Captures the calendar date on which a surgical procedure was performed at a healthcare facility. Used in inpatient and outpatient claims data to document the operative service date, supporting surgical utilization tracking, reimbursement adjudication, and quality outcome measurement.

finding active indicatorfndg_actv_ind

A binary flag indicating whether a clinical finding, such as a diagnosis, observation, or test result, is currently active in the patient's record. Used in clinical data systems to distinguish actionable or ongoing findings from resolved or historical entries during care planning and documentation review.

finding active statusfndg_actv_sts

Specifies the current lifecycle state of a clinical finding, indicating whether it is active, inactive, resolved, or pending. Used in clinical data management to support care coordination, problem list maintenance, and longitudinal tracking of patient health conditions across encounters.

finding admission datefndg_admn_dt

Records the calendar date a patient was formally admitted to a healthcare facility in connection with a specific clinical finding. Used in inpatient encounter and claims data to establish the start of a hospital stay, supporting length-of-stay calculations, DRG assignment, and utilization review.

finding agefndg_age

Records the patient's age at the time a clinical finding was documented or first identified. Used in clinical and claims data analysis to support age-stratified quality reporting, risk adjustment modeling, and population health analytics tied to specific diagnoses or observed health conditions.

finding allowed amountfndg_alwd_amt

Captures the maximum dollar amount a health plan will reimburse for services associated with a specific clinical finding, based on contracted rates or fee schedules. Used in claims adjudication to determine payment limits after applying plan benefits, coordination of benefits, and member cost-sharing.

finding amountfndg_amt

Records the monetary value associated with a clinical finding, representing either a charge, payment, or adjustment tied to the related healthcare service. Used in claims and financial reporting to track the cost attributed to specific diagnoses or clinical observations across encounters and payment cycles.

finding approved byfndg_appr_by

Identifies the clinician, reviewer, or system user who authorized or validated a clinical finding in the patient record. Used in clinical workflow and audit trail documentation to establish accountability for finding approval, supporting compliance, peer review, and quality assurance processes.

finding arrival timefndg_arrv_tm

Records the time of day a patient arrived at a healthcare facility in connection with a documented clinical finding. Used in emergency department and inpatient encounter data to support door-to-treatment time calculations, throughput analysis, and care quality metrics tied to timely intervention.

finding arrived datefndg_arrv_dt

Records the calendar date a patient arrived at a healthcare facility associated with a documented clinical finding. Used in encounter and claims data to establish the initial contact date for an episode of care, supporting admission timelines, utilization review, and care coordination workflows.

finding assessmentfndg_asmt

Contains the clinician's written evaluation or interpretive narrative associated with a clinical finding, summarizing the significance of the observed result in the context of the patient's condition. Used in clinical documentation to support diagnosis coding, care planning, and longitudinal patient record review.

PreviousPage 259 of 806Next