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

procedure scheduled timeproc_sched_tm

The clock time at which a medical procedure is planned to begin, recorded during the scheduling process. Used alongside the scheduled date in operating room management, procedure unit scheduling systems, and patient notification workflows to coordinate clinical resources and staff.

procedure scoreproc_scr

Calculated numeric rating derived from clinical criteria or risk models associated with a medical procedure. Used in EHR, utilization management, and clinical decision support systems to stratify patient risk and support prior authorization workflows in payer platforms.

procedure sequenceproc_seq

Ordering number indicating the position of a procedure within a series of related medical interventions on a claim or clinical record. Used in claims adjudication and EHR systems to ensure correct processing order and support multi-procedure billing logic.

procedure service dateproc_svc_dt

The calendar date on which a medical procedure or clinical intervention was rendered to the patient. A critical field in claims, EHR, and encounter data systems used for adjudication timelines, coordination of benefits, eligibility verification, and reporting period alignment.

procedure severityproc_sev

Classification indicating the seriousness or complexity of a medical procedure or associated clinical condition. Used in EHR, case management, and payer systems to drive utilization review decisions, DRG assignment, and risk-adjusted quality reporting analytics.

procedure sexproc_sex

Captures the patient's biological sex as recorded in the context of a specific procedure encounter. Used to apply sex-specific clinical guidelines, determine procedure eligibility, support demographic reporting, and ensure appropriate coding on claims submitted for reimbursement.

procedure sourceproc_src

Source system or channel for procedure within Eligibility processes in Healthcare implementations. Used for reporting, integrations, and downstream analytics.

procedure start dateproc_start_dt

The date on which a medical procedure or treatment episode was initiated. Used in EHR, inpatient, and surgical records to calculate procedure duration, support episode-of-care analytics, and align with claims adjudication windows in payer data systems.

procedure start timeproc_start_tm

The actual clock time at which a medical procedure began, recorded by clinical staff at the point of care. Used in operative documentation, anesthesia records, and procedure billing to calculate duration, measure efficiency, and support accurate claims adjudication.

procedure stateproc_st

The US state or territory where a medical procedure was performed or where the performing facility is located. Used in claims processing, provider credentialing validation, and geographic reporting to support state-level regulatory compliance and network adequacy analysis.

procedure statusproc_sts

Lifecycle status indicator tracking the current state of a procedure within claims processing workflows, such as pending, approved, denied, or completed. Used in healthcare payer systems for adjudication tracking, provider communications, and operational reporting dashboards.

procedure street addressproc_st_addr

The physical street address of the facility or location where a medical procedure was performed. Used in claims processing to identify the place of service, support provider directory accuracy, and validate billing address information against credentialing and enrollment records.

procedure strengthproc_str

The concentration or dosage strength of a drug or agent administered as part of a medical procedure, such as anesthetic or contrast media. Captured in pharmacy and clinical records to ensure appropriate dosing documentation, support medication reconciliation, and meet billing requirements.

procedure subtotalproc_subtot

A partial sum of charges associated with a specific medical procedure prior to the application of adjustments, discounts, or additional fees. Used in claims adjudication and revenue cycle management to calculate intermediate billing amounts before final reimbursement determination.

procedure surgery dateproc_surg_dt

The actual calendar date on which a surgical procedure was performed. Distinct from the scheduled date, this field records the operative date used in surgical documentation, post-operative care planning, claims submission, and outcomes reporting for quality measurement programs.

procedure system identifierproc_sys_id

A system-generated unique identifier assigned to a specific procedure record within a clinical or administrative system. Serves as the primary key for linking procedure data across EHR, claims, and data warehouse platforms to ensure accurate record matching and longitudinal tracking.

procedure targetproc_tgt

Destination reference identifying the anatomical site, system, or clinical goal associated with a medical procedure. Captured in EHR and surgical documentation systems to support clinical coding accuracy, outcome tracking, and procedure-level analytics in healthcare data platforms.

procedure taxonomy codeproc_tax_cd

The National Uniform Claim Committee (NUCC) taxonomy code identifying the specialty classification of the clinician who performed a procedure. Used in claims adjudication to validate provider credentials, apply appropriate reimbursement rates, and support network participation verification.

procedure temperatureproc_temp

The patient's body temperature measurement recorded in association with a specific procedure encounter, typically as part of pre- or post-procedure vital signs documentation. Used in clinical assessments to monitor patient status, detect infection risk, and meet documentation standards.

procedure termination dateproc_term_dt

The date on which a procedure authorization, order, or recurring treatment plan was ended or discontinued. Used in utilization management, prior authorization tracking, and care plan management systems to mark the effective end of approved or ordered clinical interventions.

PreviousPage 521 of 806Next