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

Operations

Scheduling, facilities, departments, workflows, and staff

6,492 operations terms

standard codestd_cd

A unique alphanumeric identifier assigned to a clinical protocol, administrative policy, or regulatory guideline within a healthcare information system. Serves as the primary reference key for linking standard records across claims, clinical documentation, and compliance systems, ensuring consistent application and cross-system traceability.

standard commentstd_cmt

A free-text annotation field used to capture supplementary notes, exceptions, or contextual information related to a clinical protocol or administrative standard. Recorded in healthcare governance and documentation systems to provide additional detail that structured data fields cannot fully capture, supporting audit trails and workflow clarification.

standard completed datestd_cmpl_dt

The calendar date on which a clinical service, care protocol step, or administrative process was fully completed as defined by an operational or clinical standard. Used in care management, utilization review, and quality reporting systems to measure adherence to timelines, close care gaps, and support outcomes analysis.

standard confidential indicatorstd_conf_ind

A flag that designates whether a clinical record, standard, or administrative document is subject to restricted access due to privacy regulations such as HIPAA or sensitive condition policies. Used in healthcare information systems to enforce role-based access controls and prevent unauthorized disclosure of protected health information.

standard countstd_cnt

A numeric value representing the total number of occurrences, instances, or records associated with a specific clinical protocol, service event, or administrative standard within a defined period. Used in operational analytics, quality measurement, and utilization reporting to quantify activity volume and assess standard compliance across populations.

standard countrystd_ctry

The standardized country name or code associated with a reference guideline or coding standard in healthcare data systems. Used to identify geographic origin or jurisdiction of standards such as ICD, CPT, or formulary guidelines across claims, enrollment, and clinical datasets.

standard created bystd_crtd_by

The username or system identifier of the individual or automated process that initially created a reference standard or coding guideline record. Used in audit trails within claims processing, clinical data warehouses, and health information systems to ensure data accountability and traceability.

standard created datestd_crtd_dt

The calendar date on which a reference standard or coding guideline record was first entered into the healthcare data system. Used to establish data lineage and support version control of clinical standards, payer policies, or formulary guidelines across health information platforms.

standard created timestd_crtd_tm

The timestamp indicating the exact time a reference standard or coding guideline record was first created in the healthcare data system. Used alongside the created date to provide precise audit trail information for version control, compliance tracking, and data governance workflows.

standard creatininestd_cr

The normalized or reference creatinine value used as a baseline kidney function marker in clinical laboratory standards. Applied in healthcare data systems to compare patient lab results against established renal function benchmarks for diagnosis, medication dosing adjustments, and chronic kidney disease staging.

standard datestd_dt

A normalized calendar date value associated with a reference guideline or standard record in a healthcare data system. Used to align clinical, claims, or administrative events to a consistent date format, supporting accurate cross-system comparisons, reporting, and longitudinal data analysis.

standard datetimestd_dttm

A normalized combined date and time value associated with a reference standard record in a healthcare data system. Used to precisely timestamp clinical events, claims transactions, or administrative actions, ensuring consistent chronological ordering and accurate cross-system data reconciliation and reporting.

standard dea numberstd_dea_nbr

The Drug Enforcement Administration registration number associated with a prescribing clinician or dispensing pharmacy, normalized to a reference standard format. Used in pharmacy claims and prescription data systems to validate controlled substance prescribing authority and ensure regulatory compliance.

standard death datestd_death_dt

The standardized date of death recorded for a member or patient within a healthcare data system, normalized to a consistent format. Used in member enrollment, claims adjudication, and population health analytics to terminate coverage, reconcile benefits, and support mortality reporting and actuarial analysis.

standard deleted datestd_del_dt

The calendar date on which a reference standard or guideline record was marked as deleted within a healthcare data system. Used in audit trails and data governance processes to track record lifecycle, support soft-delete workflows, and maintain historical integrity of clinical and administrative datasets.

standard deleted indicatorstd_del_ind

A flag or boolean value indicating whether a reference standard or guideline record has been logically removed from active use in a healthcare data system. Used in soft-delete workflows to retain historical data integrity while excluding retired standards from active claims processing, clinical decision support, and reporting.

standard descriptionstd_desc

A human-readable textual explanation of a reference standard or coding guideline used in healthcare data systems. Provides context for coded values such as diagnosis codes, procedure codes, or payer policies, supporting accurate interpretation in clinical documentation, claims processing, and analytics reporting.

standard detailstd_dtl

Granular supplementary information associated with a reference standard or guideline record in a healthcare data system. Captures specific attributes, sub-classifications, or contextual metadata that clarify how a standard applies to clinical coding, claims adjudication, formulary management, or health plan policy administration.

standard due datestd_due_dt

The deadline date by which a payment, action, or compliance requirement associated with a healthcare standard or guideline must be fulfilled. Used in claims processing, payer billing cycles, and regulatory reporting workflows to track obligation timelines and trigger escalation or penalty calculations.

standard effective datestd_eff_dt

The date on which a reference standard, coding guideline, or payer policy becomes active and applicable within a healthcare data system. Used in claims adjudication, benefit administration, and clinical decision support to determine which version of a standard governs a specific transaction or clinical event.

PreviousPage 243 of 325Next