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

requirement master identifierreq_mstr_id

Enterprise-level master identifier that uniquely links a mandatory specification across multiple healthcare systems and data domains. Enables consistent tracking, deduplication, and cross-system reconciliation of requirements spanning enrollment, claims, clinical, and compliance platforms.

requirement maximumreq_max

Upper boundary value for a mandatory specification, defining the highest permissible quantity, duration, cost, or frequency allowed under a plan rule or clinical guideline. Used in benefits administration and claims adjudication to enforce coverage limits and utilization thresholds.

requirement medical record numberreq_mrn

Facility-assigned medical record number linking a mandatory clinical specification to a specific patient encounter or longitudinal health record. Used in clinical documentation and care management workflows to associate treatment requirements with the correct patient chart.

requirement middle namereq_mid_nm

Middle name or initial of the individual associated with a mandatory specification. Used alongside first and last name fields in member enrollment, credentialing, and authorization records to accurately identify individuals and reduce identity matching errors across healthcare systems.

requirement minimumreq_min

Lower boundary value for a mandatory specification, defining the least permissible quantity, duration, cost, or frequency required under a plan rule or clinical guideline. Used in benefits administration and claims adjudication to enforce minimum compliance thresholds and coverage obligations.

requirement mobilereq_mob

Mobile phone number associated with the individual or entity linked to a mandatory specification. Used in member outreach, care management, and compliance notification workflows to deliver time-sensitive communications such as authorization decisions, enrollment confirmations, or regulatory alerts.

requirement modified byreq_mod_by

User identifier of the individual or system process that last updated a mandatory specification record. Supports audit trail requirements by capturing accountability for changes made to requirement definitions, thresholds, or statuses within healthcare compliance and data governance systems.

requirement modified datereq_mod_dt

Calendar date on which a mandatory specification record was most recently updated. Used in audit logging, version control, and regulatory compliance tracking to establish the effective timeline of changes to requirement definitions within healthcare data governance systems.

requirement modified timereq_mod_tm

Timestamp indicating the precise time a mandatory specification record was last updated. Combined with the modified date, supports granular audit trail requirements and change history tracking within healthcare compliance, data governance, and workflow management systems.

requirement namereq_nm

Human-readable label assigned to a mandatory specification, providing a descriptive title used in reporting, user interfaces, and documentation. Enables staff and systems to identify and reference specific rules, obligations, or conditions within healthcare operations without relying solely on numeric identifiers.

requirement numberreq_nbr

Sequentially or systematically assigned numeric identifier for a mandatory specification. Used across healthcare compliance, contract management, and claims editing systems to uniquely reference and track individual requirements, enabling consistent cross-system reporting and audit documentation.

requirement onset datereq_onset_dt

Date on which a mandatory specification or clinical obligation first became applicable, such as when a condition-based requirement was triggered by a diagnosis or treatment event. Used in care management and utilization review workflows to establish timelines for compliance and clinical intervention.

requirement oxygen saturationreq_o2sat

The minimum or threshold blood oxygen saturation level (SpO2) specified as a clinical requirement, used in care management protocols, prior authorization criteria, or home health eligibility rules to define acceptable patient oxygen levels before initiating or continuing treatment.

requirement paid amountreq_pd_amt

The actual dollar amount disbursed to satisfy a mandatory financial obligation associated with a claim, authorization, or benefit requirement. Used in claims adjudication and payment reconciliation to confirm that required payment thresholds or cost-sharing conditions have been met.

requirement paid datereq_pd_dt

The calendar date on which payment was issued to fulfill a mandatory financial obligation tied to a claim, benefit, or authorization requirement. Used in claims processing and financial audit trails to confirm timely payment and track compliance with contractual payment deadlines.

requirement parentreq_prnt

The higher-level requirement to which a subordinate requirement belongs within a hierarchical care management, utilization review, or benefit structure. Enables grouping of related conditions or criteria under a common parent node for rules-based processing and reporting.

requirement percentagereq_pct

The proportional rate expressed as a percentage that defines a threshold or calculation component within a mandatory specification, such as a coinsurance rate, clinical improvement benchmark, or benefit eligibility ratio used in utilization management or claims adjudication rules.

requirement periodreq_prd

The defined timeframe or duration within which a mandatory requirement must be fulfilled, such as a prior authorization validity window, a benefit accumulation period, or a clinical review cycle used in care management and utilization review workflows.

requirement phonereq_ph

The telephone contact number associated with a mandatory requirement record, such as the number for a clinical reviewer, authorizing entity, or case management contact responsible for validating or processing the requirement in utilization management workflows.

requirement preferred namereq_pref_nm

The human-readable display label assigned to a mandatory requirement record, used to identify and distinguish requirements in care management systems, utilization review platforms, and benefit configuration tools where a standardized or user-friendly name improves clarity and reporting.

PreviousPage 205 of 325Next