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 taxonomy codesat_tax_cd

The standardized specialty classification code assigned to a clinician or service associated with a patient satisfaction record. Used in patient experience reporting to segment satisfaction scores by provider specialty, enabling specialty-level performance analysis and benchmarking.

satisfaction temperaturesat_temp

The recorded body temperature measurement associated with a patient satisfaction encounter, linking a clinical vital sign to the experience record. Used in inpatient and emergency care analytics to contextualize patient condition at the time satisfaction data was captured.

satisfaction termination datesat_term_dt

The date on which a patient satisfaction survey, program enrollment, or related data collection period officially ended. Used in patient experience management systems to define the close of a satisfaction measurement window for reporting, auditing, and trend analysis.

satisfaction timesat_tm

The specific time of day at which a patient satisfaction survey was administered, submitted, or recorded. Used in patient experience analytics to identify patterns in response timing, assess survey distribution workflows, and ensure temporal accuracy of satisfaction data.

satisfaction timestampsat_ts

The precise date and time at which a patient satisfaction record was created, submitted, or last modified. Used in patient experience data systems to establish an authoritative chronological record for audit trails, response tracking, and longitudinal satisfaction reporting.

satisfaction titlesat_ttl

The formal name or label assigned to a patient satisfaction survey, program, or assessment instrument. Used in patient experience management systems to identify and distinguish between multiple satisfaction initiatives, questionnaire versions, or care setting-specific measurement tools.

satisfaction totalsat_tot

The fully aggregated composite score representing the sum of all patient satisfaction responses or weighted domain scores for an encounter or reporting period. Used in quality reporting and value-based purchasing programs to calculate overall patient experience performance.

satisfaction total countsat_tot_cnt

The total number of patient satisfaction responses, surveys, or records captured within a defined period or cohort. Used in patient experience analytics to measure survey volume, calculate response rates, and ensure statistically valid sample sizes for performance reporting.

satisfaction typesat_typ

The categorical classification identifying the nature or domain of a patient satisfaction assessment, such as inpatient, outpatient, surgical, or emergency care. Used in experience reporting systems to segment and compare satisfaction data across distinct care settings and service lines.

satisfaction updated datesat_upd_dt

The most recent date on which a patient satisfaction record was modified, corrected, or supplemented with additional data. Used in patient experience data governance to support audit trails, track record maintenance activity, and ensure data currency in satisfaction reporting.

satisfaction urgencysat_urg

The priority or time-sensitivity level assigned to a patient satisfaction follow-up action or complaint resolution. Used in patient relations and service recovery workflows to triage negative experience feedback and ensure timely intervention based on severity of the reported concern.

satisfaction versionsat_ver

The iteration number identifying which version of a patient satisfaction survey instrument or data record is in use. Used in patient experience systems to manage survey updates, maintain historical comparability, and distinguish between different questionnaire revisions across reporting periods.

satisfaction zipsat_zip

The five-digit postal code associated with a patient's residence at the time of a satisfaction survey, used to geographically segment patient experience data. Supports population health and market analysis by linking satisfaction outcomes to specific geographic regions or service areas.

scan active indicatorscn_actv_ind

A binary flag indicating whether a medical imaging scan record is currently active and valid within the clinical data system. Used in radiology and diagnostic imaging workflows to distinguish usable scan records from those that have been voided, superseded, or administratively inactivated.

scan active statusscn_actv_sts

The current operational state of a medical imaging scan record, indicating whether it is active, pending, archived, or cancelled within the imaging system. Used in radiology information systems to manage scan lifecycle and ensure only valid records are referenced in clinical decision-making.

scan admission datescn_admn_dt

Records the date a patient was admitted or registered for a diagnostic imaging scan such as MRI, CT, or PET within EHR, radiology, and RIS systems. scn_admn_dt is used by data engineers to align imaging events with clinical encounters, calculate scheduling lead times, and support radiology workflow analytics.

scan agescn_age

The calculated age of the patient at the time a medical imaging scan was performed, derived from date of birth and scan date. Used in radiology analytics and diagnostic imaging research to stratify scan utilization, dosage parameters, and clinical findings by patient age group.

scan allowed amountscn_alwd_amt

The maximum dollar amount a payer will reimburse for a diagnostic imaging scan procedure. Established by contract or fee schedule, this ceiling drives payment calculations in claims adjudication, determining patient cost-sharing obligations such as coinsurance and deductible application.

scan amountscn_amt

Monetary value associated with a scanned document or medical image capture in EHR and claims systems. Used by data engineers to reconcile payment records, EOBs, and remittance data where physical documents are digitized and indexed for processing.

scan approval statusscn_appr_sts

Indicates the current authorization state of a diagnostic imaging scan request, such as pending, approved, or denied. Used in prior authorization workflows to confirm payer approval before imaging services are rendered, reducing claim denials and ensuring coverage compliance.

PreviousPage 610 of 806Next