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 paid datestd_pd_dt

The normalized date on which payment was issued by a payer for a processed claim or encounter, standardized for consistency across claims adjudication, provider remittance, and financial reporting systems. Used in cash flow analysis, prompt payment compliance tracking, and accounts receivable reconciliation within healthcare billing operations.

standard parentstd_prnt

The higher-level entity in a hierarchical data relationship within healthcare reference data structures, such as a parent diagnosis category, benefit plan tier, organizational unit, or formulary class. Used to support roll-up reporting, hierarchical grouping, and navigation within clinical coding systems, benefit plan configurations, and provider network taxonomies.

standard percentagestd_pct

The normalized ratio value expressed as a percentage within a healthcare data context, such as coinsurance rates, network discount percentages, quality measure performance scores, or formulary tier cost-sharing levels. Used in benefit plan configuration, claims adjudication, provider contract management, and population health reporting workflows.

standard periodstd_prd

The normalized time interval associated with a benefit plan cycle, coverage term, authorization window, or reporting period within the healthcare data system. Used in eligibility management, utilization tracking, claims adjudication, and quality measure calculation to define boundaries for accumulator resets, benefit limits, and performance measurement.

standard phonestd_ph

The normalized telephone number associated with a patient, member, insured individual, or facility contact record, standardized in format for consistent use across enrollment, claims, care coordination, and patient engagement systems. Supports outreach workflows, prior authorization communications, and directory services across health plan and clinical platforms.

standard preferred namestd_pref_nm

The normalized, human-readable display name assigned to a healthcare standard, coding system, or classification scheme. Used in data dictionaries, terminology servers, and clinical data warehouses to ensure consistent labeling across reporting, integration, and interoperability workflows.

standard pricestd_prc

The established benchmark cost value associated with a healthcare service, procedure, or item as defined by a pricing standard or fee schedule. Used in claims processing, contract management, and reimbursement workflows to validate billed amounts against expected payment rates.

standard primary indicatorstd_prim_ind

A flag identifying whether a given standard, code, or classification is designated as the primary reference among multiple applicable options. Used in terminology management and claims adjudication to resolve conflicts when multiple standards apply to a single encounter or transaction.

standard prioritystd_prty

A numeric or categorical ranking that defines the order of precedence for applying a healthcare standard, rule, or guideline when multiple options are valid. Used in claims adjudication, utilization management, and clinical decision support systems to resolve competing rules or protocols.

standard pulsestd_pulse

The reference or benchmark heart rate value, measured in beats per minute, established by clinical guidelines for a defined patient population or condition. Used in clinical documentation and quality measurement to compare individual patient vital signs against evidence-based normal ranges.

standard quantitystd_qty

The defined benchmark count or volume associated with a healthcare item, drug dispensing event, or procedure as established by clinical or formulary guidelines. Used in pharmacy management and claims processing to validate dispensed amounts against expected therapeutic quantities.

standard racestd_race

The normalized racial classification assigned to a patient or member using an established coding standard such as OMB categories or CDC race codes. Used in member enrollment, population health reporting, and health equity analytics to ensure consistent demographic data capture across systems.

standard ratestd_rt

The established unit payment amount defined by a contract, fee schedule, or reimbursement methodology for a specific healthcare service or procedure. Used in claims adjudication and provider contract management to calculate expected reimbursement and identify payment variances.

standard ratingstd_rtg

A normalized assessment score or classification applied to a health plan, provider, facility, or clinical measure using a defined rating methodology such as NCQA or CMS Star Ratings. Used in quality reporting, accreditation, and member-facing plan comparison tools.

standard ratiostd_ratio

A benchmark proportional value established by clinical guidelines or actuarial standards, such as a staff-to-patient ratio or drug concentration ratio. Used in quality measurement, utilization review, and population health analytics to compare observed performance against expected reference values.

standard reasonstd_rsn

A normalized code or description that explains the basis for a healthcare decision, transaction, or event using a defined standard such as ANSI X12 claim adjustment reason codes. Used in claims processing, denial management, and remittance advice workflows to communicate actionable information.

standard received datestd_rcvd_dt

The date on which a healthcare transaction, document, authorization request, or claim was formally received and logged according to a standardized intake process. Used in claims management and utilization review to calculate processing timeframes and ensure compliance with regulatory response deadlines.

standard referencestd_ref

A pointer or identifier linking a healthcare record, transaction, or data element to an authoritative external standard, guideline, or source document such as an ICD code set or CPT manual. Used in coding validation, audit support, and interoperability mapping across clinical and administrative systems.

standard resolution datestd_resol_dt

The date on which a healthcare issue, clinical condition, grievance, or authorization request was formally closed or resolved according to defined standard turnaround requirements. Used in case management, appeals processing, and regulatory compliance tracking to measure adherence to required resolution timeframes.

standard respirationstd_resp

The reference or benchmark respiratory rate value, measured in breaths per minute, established by clinical guidelines for a defined patient population or condition. Used in clinical documentation and quality measurement to compare individual patient vital signs against evidence-based normal ranges.

PreviousPage 246 of 325Next