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 created byreq_crtd_by

The unique identifier of the user or system that originated a healthcare compliance, clinical, or administrative requirement record. Used for audit trail purposes within care management, health plan administration, and utilization review platforms to establish accountability and record ownership.

requirement created datereq_crtd_dt

The calendar date on which a healthcare compliance, clinical, or administrative requirement record was first entered into the system. Used for audit tracking, workflow prioritization, and reporting within care management, utilization review, and health plan administration systems.

requirement created timereq_crtd_tm

The timestamp indicating when a healthcare compliance, clinical, or administrative requirement record was first entered into the system. Used alongside the created date for precise audit trail documentation within care management, utilization review, and health plan administration platforms.

requirement creatininereq_cr

The creatinine lab value documented as part of a clinical requirement, used to assess kidney function before procedures, medication dosing, or treatment eligibility. Commonly referenced in prior authorization, care management protocols, and clinical decision support workflows requiring renal function verification.

requirement datereq_dt

The calendar date associated with a healthcare compliance, clinical, or administrative requirement, representing when the mandate becomes effective, is due, or must be acted upon. Used in care management, utilization review, and health plan workflows to manage deadlines and regulatory timelines.

requirement datetimereq_dttm

The combined date and time value associated with a healthcare compliance, clinical, or administrative requirement, capturing the precise moment a mandate becomes effective or an action is due. Used for time-sensitive workflows in care management, utilization review, and health plan operations.

requirement dea numberreq_dea_nbr

The Drug Enforcement Administration registration number associated with a controlled substance prescribing or dispensing requirement. Used in pharmacy, prior authorization, and prescriber verification workflows to validate prescriber credentials and ensure regulatory compliance with controlled substance mandates.

requirement death datereq_death_dt

The recorded date of death linked to a healthcare compliance or clinical requirement, used to close open care management cases, terminate member eligibility, or fulfill regulatory reporting obligations. Ensures accurate status updates across health plan enrollment, claims, and care coordination systems.

requirement deleted datereq_del_dt

The calendar date on which a healthcare compliance, clinical, or administrative requirement record was logically removed from active use. Used for audit trail maintenance and data governance within care management, health plan administration, and utilization review systems to track record lifecycle changes.

requirement deleted indicatorreq_del_ind

A flag denoting whether a healthcare compliance, clinical, or administrative requirement record has been logically removed from active processing. Used in care management, utilization review, and health plan systems to suppress inactive records while preserving historical data for audit and reporting purposes.

requirement descriptionreq_desc

The human-readable textual explanation of a healthcare compliance, clinical, or administrative requirement, detailing what must be fulfilled, by whom, and under what conditions. Used in care management, utilization review, and health plan operations to communicate mandate specifics to staff and systems.

requirement detailreq_dtl

Granular information elaborating on the specific conditions, criteria, or steps associated with a healthcare compliance, clinical, or administrative requirement. Used in care management, utilization review, and health plan workflows to provide staff and systems with precise instructions for fulfilling the mandate.

requirement due datereq_due_dt

The deadline by which a regulatory, accreditation, or operational requirement must be fulfilled. Used in compliance tracking systems to monitor timely completion of mandatory obligations such as credentialing renewals, quality measures, or audit submissions.

requirement effective datereq_eff_dt

The date on which a mandatory compliance, credentialing, or operational requirement becomes active and enforceable. Used in healthcare compliance systems to determine when obligations such as licensing standards or policy mandates begin to apply.

requirement emailreq_eml

The email address associated with the contact or entity responsible for fulfilling a specific mandatory requirement. Used in compliance and credentialing systems to route notifications, correspondence, and status updates related to outstanding or pending obligations.

requirement end datereq_end_dt

The date on which a mandatory compliance, credentialing, or operational requirement ceases to apply or is considered complete. Used in healthcare compliance tracking to define the closure or expiration boundary of a specific regulatory or administrative obligation.

requirement end timereq_end_tm

The specific time at which a mandatory compliance or operational requirement concludes. Used in healthcare scheduling and compliance systems to precisely define the closing timestamp of time-bound obligations, audits, or regulatory reporting windows.

requirement entered byreq_ent_by

The identifier of the user or system that originally recorded a mandatory requirement into the compliance or credentialing system. Used for audit trail and accountability purposes to track data entry ownership and support quality control reviews.

requirement ethnicityreq_ethn

The ethnicity of the individual associated with a mandatory requirement, such as a patient or member subject to a care gap or health equity measure. Used in population health and quality reporting to support demographic stratification of compliance data.

requirement expiration datereq_exp_dt

The date after which a mandatory compliance, credentialing, or licensure requirement is no longer considered valid. Used in credentialing and regulatory systems to trigger renewal workflows and flag lapsed obligations before they impact operational standing.

PreviousPage 203 of 325Next