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 amountreq_amt

The monetary value specified within a regulatory, contractual, or clinical requirement record. Used in claims processing, benefit plan administration, and prior authorization workflows to define financial thresholds, cost-sharing obligations, or minimum expenditure conditions tied to coverage or compliance requirements.

requirement approval statusreq_appr_sts

The current authorization state of a regulatory, clinical, or administrative requirement record, such as pending, approved, denied, or expired. Used in prior authorization, utilization management, and compliance tracking systems to indicate whether the requirement conditions have been reviewed and sanctioned by the appropriate authority.

requirement approved byreq_appr_by

The identifier or name of the individual, role, or system that authorized a regulatory, clinical, or administrative requirement record. Used in prior authorization, utilization management, and compliance audit trails to establish accountability and support review processes within payer and health plan operations.

requirement arrival timereq_arrv_tm

The recorded time at which a patient, document, or request arrived in relation to fulfilling a specific clinical or administrative requirement. Used in utilization management and care coordination workflows to measure timeliness compliance, track response windows, and support regulatory reporting on access and service delivery standards.

requirement arrived datereq_arrv_dt

The calendar date on which a patient, request, or supporting document arrived in relation to a specific clinical or administrative requirement. Used in utilization management and prior authorization workflows to calculate turnaround timelines, assess compliance with regulatory response windows, and support audit documentation.

requirement birth datereq_birth_dt

The date of birth associated with a member, patient, or dependent as it pertains to a specific eligibility, clinical, or regulatory requirement. Used in enrollment, benefit plan administration, and prior authorization systems to verify age-based eligibility criteria and validate demographic consistency across requirement records.

requirement blood pressurereq_bp

The systolic and diastolic blood pressure measurement documented as a qualifying clinical condition or threshold within a specific care management or prior authorization requirement. Used in utilization management and chronic disease programs to assess whether a patient meets clinical criteria defined in coverage or treatment protocols.

requirement cancelled datereq_cncl_dt

The calendar date on which a regulatory, clinical, or administrative requirement was cancelled or withdrawn. Used in prior authorization, utilization management, and compliance systems to mark the end of an active requirement, support audit trails, and ensure downstream claim adjudication reflects the correct requirement status.

requirement categoryreq_cat

The classification grouping assigned to a regulatory, clinical, or administrative requirement, such as prior authorization, coverage condition, or clinical protocol. Used in utilization management and benefit plan administration systems to organize, filter, and report on requirement records by type for operational and compliance purposes.

requirement charge amountreq_chrg_amt

The billed or assessed charge associated with a specific regulatory, contractual, or clinical requirement. Used in claims adjudication and prior authorization workflows to compare submitted charges against requirement-defined thresholds and determine appropriate reimbursement, cost-sharing allocation, or denial decisions within payer processing systems.

requirement chief complaintreq_cc

The primary symptom or clinical reason documented as the basis for a regulatory, clinical, or prior authorization requirement. Used in utilization management systems to record the patient-reported or clinician-documented presenting condition that triggered the requirement review and supports medical necessity determinations.

requirement childreq_chld

A subordinate requirement record linked hierarchically to a parent requirement within utilization management or benefit plan administration systems. Used to represent dependent or conditional requirements that are activated, evaluated, or resolved in relation to a parent requirement, enabling structured tracking of complex multi-step authorization or compliance workflows.

requirement cityreq_city

The municipality name associated with a healthcare compliance or regulatory requirement, used to capture geographic location context such as a member's city of residence, facility location, or jurisdiction enforcing a specific clinical or administrative mandate.

requirement classreq_cls

The classification tier assigned to a healthcare compliance or regulatory requirement, categorizing it by type such as clinical, administrative, or financial. Used to prioritize and route requirements across care management, utilization review, and health plan operations.

requirement codereq_cd

The standardized alphanumeric code identifying a specific healthcare compliance, clinical, or regulatory requirement. Used to consistently reference and track the requirement across care management platforms, health plan systems, and utilization management workflows.

requirement commentreq_cmt

Free-text notation capturing supplemental context or clarifying details for a healthcare compliance, clinical, or administrative requirement. Used by care managers, utilization reviewers, or health plan staff to document exceptions, rationale, or follow-up actions associated with the requirement.

requirement completed datereq_cmpl_dt

The calendar date on which a healthcare compliance, clinical, or administrative requirement was fulfilled. Used in care management and utilization review workflows to track timely completion of mandated actions such as assessments, authorizations, or member outreach activities.

requirement confidential indicatorreq_conf_ind

A flag indicating whether a healthcare compliance, clinical, or administrative requirement contains sensitive or restricted information requiring limited access. Used to enforce privacy controls and HIPAA-compliant data handling within care management and health plan systems.

requirement countreq_cnt

The total number of instances or occurrences associated with a specific healthcare compliance, clinical, or administrative requirement. Used in reporting and analytics to measure requirement volume across care management programs, health plan populations, or regulatory tracking systems.

requirement countryreq_ctry

The country associated with a healthcare compliance or regulatory requirement, used to capture the national jurisdiction for members, facilities, or regulatory mandates. Supports cross-border care management, international member enrollment, and country-specific compliance reporting.

PreviousPage 202 of 325Next