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

surgery typesurg_typ

Category classification identifying the nature or specialty of an operative procedure, such as elective, emergency, inpatient, or outpatient, in EHR and claims systems. Data engineers use this to segment surgical populations, apply procedure-specific edit rules, and route claims to appropriate adjudication logic.

surgery unitsurg_unt

Measurement unit applied to an operative procedure service, such as minutes of anesthesia, procedure units, or relative value units in EHR and claims billing systems. Data engineers use this to validate unit-based reimbursement calculations, anesthesia billing conversions, and surgical fee schedule comparisons.

surgery valuesurg_val

Measured data point associated with an operative procedure, such as a clinical metric, charge amount, or quality indicator captured in EHR, claims, or surgical registry systems. Data engineers use this field to populate surgical analytics pipelines, outcome tracking models, and value-based payment performance reports.

survey active indicatorsurv_actv_ind

A flag indicating whether a patient satisfaction or clinical survey is currently active and available for distribution or response collection. Used in quality measurement programs, CAHPS reporting, and patient experience initiatives to control which surveys are live within healthcare data management systems.

survey active statussurv_actv_sts

A categorical value representing the current operational state of a patient satisfaction or outcomes survey, such as active, inactive, or retired. Used in quality improvement programs and patient experience reporting to manage survey lifecycle stages across healthcare data collection platforms.

survey admission datesurv_admn_dt

The date a patient was admitted to a healthcare facility, captured in association with a patient satisfaction or outcomes survey. Used in CAHPS and post-discharge surveys to link patient feedback to specific inpatient episodes and support quality measurement and accreditation reporting.

survey assessmentsurv_asmt

A structured evaluation or scored response set captured through a patient satisfaction, outcomes, or clinical survey instrument. Used in quality improvement initiatives, HEDIS reporting, and patient experience programs to summarize and interpret patient-reported feedback linked to specific care encounters.

survey discharge datesurv_dsch_dt

The date on which a patient was discharged from a facility, recorded in connection with a patient satisfaction or post-discharge survey. Used in CAHPS and outcomes measurement programs to associate survey responses with specific inpatient episodes and calculate survey distribution timing windows.

survey durationsurv_dur

The total elapsed time between a survey's open and close dates, or the average time a respondent takes to complete it. Used in patient experience program management and quality reporting to evaluate survey design efficiency, response burden, and data collection window adequacy across healthcare surveys.

survey emergency indicatorsurv_emerg_ind

A flag denoting whether a survey was triggered by or associated with an emergency care encounter, such as an ED visit. Used in patient experience and outcomes measurement programs to segment survey results by care setting and support emergency department-specific quality analysis and reporting.

survey history present illnesssurv_hpi

A narrative field capturing a patient's description of their current symptoms and illness progression as recorded within a clinical survey or intake instrument. Used in pre-visit assessments and telehealth workflows to document patient-reported history prior to clinical evaluation and care documentation.

survey instructionsurv_instr

Directional text provided to survey respondents explaining how to complete a patient satisfaction, clinical outcomes, or health assessment survey. Used in patient experience programs and quality initiatives to standardize response collection, reduce ambiguity, and improve data validity across survey administration platforms.

survey labelsurv_lbl

A human-readable name or title assigned to a patient satisfaction, clinical outcomes, or health assessment survey for identification within data systems and reporting tools. Used in quality measurement programs to distinguish individual surveys, facilitate reporting configurations, and support display in patient-facing and administrative interfaces.

survey notesurv_nt

Free-text annotation capturing additional context, observations, or qualifications recorded alongside a patient satisfaction or outcomes survey. Documents clarifying information about survey responses, administration conditions, or patient feedback that cannot be captured in structured survey fields.

survey procedure datesurv_proc_dt

The date on which a clinical procedure referenced within a patient survey was performed. Used in post-procedure satisfaction surveys and outcomes assessments to establish the temporal relationship between care delivery and the survey administration, enabling time-based analysis of patient experience.

survey rangesurv_rng

The defined minimum and maximum allowable values for a scored or scaled question within a patient survey instrument. Establishes the valid response boundaries for Likert scales, numeric rating systems, or composite scoring models used in standardized patient experience or outcomes surveys.

survey resultsurv_rslt

The recorded outcome or score captured from a completed patient satisfaction, clinical outcomes, or quality-of-life survey. Represents individual question responses or aggregate scores used to evaluate care quality, patient experience, and population health metrics across clinical programs.

survey routesurv_rte

The delivery channel or method through which a patient survey was administered, such as in-person, telephone, mail, online portal, or electronic kiosk. Tracks how patient feedback was collected to support analysis of response bias and survey methodology effectiveness across programs.

survey strengthsurv_str

A measure of statistical reliability or confidence associated with a survey result, reflecting sample size adequacy, response rate, or scoring validity for a given patient population. Used in quality reporting to assess whether survey findings meet thresholds required for public reporting or performance benchmarking.

survey surgery datesurv_surg_dt

The date of a surgical procedure referenced in a post-operative patient experience or outcomes survey. Anchors the survey response to the specific operative encounter, enabling analysis of recovery experience, surgical outcomes, and patient satisfaction relative to the time elapsed since the operation.

PreviousPage 696 of 806Next