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

satisfaction countrysat_ctry

The country associated with a patient experience survey record, typically reflecting the geographic location of the care facility or the patient's country of residence. Used in multi-national health system reporting to segment satisfaction results by geographic region or regulatory jurisdiction.

satisfaction created bysat_crtd_by

The system username or user identifier of the individual who initially entered or generated a patient experience survey record in the data system. Used for audit trail purposes to track data entry accountability and support quality assurance reviews of patient feedback records.

satisfaction created datesat_crtd_dt

The calendar date on which a patient experience survey or feedback record was first entered into the data system. Used for audit tracking, data lineage, and quality reporting workflows to establish when satisfaction data was captured relative to the care encounter.

satisfaction created timesat_crtd_tm

The timestamp indicating the precise time of day a patient experience survey or feedback record was first entered into the data system. Combined with the created date, this value supports detailed audit logging and data lineage tracking for patient relations and quality management workflows.

satisfaction creatininesat_cr

A clinical lab value representing serum creatinine level, a key biomarker of kidney function, recorded in the context of a patient satisfaction or care quality record. Used to correlate clinical outcomes with patient experience data in chronic kidney disease or post-procedure quality reviews.

satisfaction datesat_dt

The primary date associated with a patient experience survey event, representing when the satisfaction assessment occurred or was administered. Used in quality analytics to align patient feedback with specific care encounters, reporting periods, and performance measurement timeframes.

satisfaction datetimesat_dttm

The combined date and time value recording the precise moment a patient experience survey event occurred or was administered. Used in patient relations and quality analytics systems to sequence feedback events accurately and associate them with specific care encounters or staff shifts.

satisfaction dea numbersat_dea_nbr

The Drug Enforcement Administration registration number associated with a provider or entity referenced within a patient experience or satisfaction record. Used to uniquely identify licensed prescribers or facilities in cases where satisfaction data is linked to pharmacy or controlled substance care episodes.

satisfaction death datesat_death_dt

The recorded date of a patient's death as referenced within a satisfaction or patient experience record. Used in quality and outcomes analytics to exclude deceased patients from follow-up survey workflows and to support mortality-linked care experience analysis in inpatient quality programs.

satisfaction deleted datesat_del_dt

The date on which a patient experience survey or feedback record was marked as deleted or removed from active reporting. Used in data governance and audit workflows to maintain a historical record of when satisfaction data was retracted, corrected, or purged from the system.

satisfaction deleted indicatorsat_del_ind

A flag that identifies whether a patient experience survey or feedback record has been logically removed from active reporting without being physically purged. Used in data governance workflows to filter inactive records from quality dashboards while preserving the data for audit and compliance purposes.

satisfaction descriptionsat_desc

A human-readable text field providing contextual explanation of a patient experience survey type, category, or feedback entry. Used in quality reporting and patient relations systems to label and differentiate survey instruments, response categories, or satisfaction program types for end-user display and analysis.

satisfaction detailsat_dtl

Granular data elements associated with an individual patient experience survey record, capturing specific question responses, sub-scores, or supplemental feedback attributes. Used in quality analytics to support disaggregated reporting on satisfaction domains such as communication, environment, and care coordination.

satisfaction discharge datesat_dsch_dt

The date a patient was discharged from an inpatient or outpatient facility, recorded in relation to a satisfaction survey record. Used to time the distribution of post-discharge patient experience surveys and to correlate satisfaction responses with specific hospitalization or care transition episodes.

satisfaction due datesat_due_dt

The target date by which a patient experience survey must be distributed, completed, or processed within a quality management workflow. Used in patient relations and quality programs to enforce survey administration timelines, ensure regulatory compliance, and monitor completion rates against established benchmarks.

satisfaction durationsat_dur

The measured length of time associated with a patient experience survey event, care encounter, or feedback collection period. Used in patient relations analytics to assess how the duration of a care episode or survey window correlates with satisfaction scores and response rates across service lines.

satisfaction emailsat_eml

The email address captured in patient satisfaction survey records, used to contact respondents for follow-up, distribute survey invitations, or link survey responses back to patient experience management systems and CAHPS reporting workflows.

satisfaction emergency indicatorsat_emerg_ind

A flag identifying whether a patient satisfaction survey was triggered by an emergency department encounter. Used in patient experience analytics to segment ED visit feedback from routine care surveys and support Press Ganey or HCAHPS emergency-specific reporting requirements.

satisfaction end datesat_end_dt

The date on which a patient satisfaction survey cycle, data collection window, or feedback campaign concluded. Used in patient experience reporting systems to define measurement periods, close survey batches, and align results with specific care episodes or reporting quarters.

satisfaction end timesat_end_tm

The timestamp marking when a patient satisfaction survey session, data collection window, or feedback submission period ended. Used alongside end date in patient experience platforms to precisely bound survey response windows and support time-sensitive CAHPS reporting workflows.

PreviousPage 605 of 806Next