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

effective riskeff_rsk

The assessed danger or liability level associated with a member, patient, or encounter during an active coverage or treatment period. Used in risk stratification models, care management programs, and insurance underwriting to classify and prioritize clinical or financial exposure within a defined effective date range.

effective routeeff_rte

The documented administration pathway, such as oral, intravenous, or topical, for a medication or treatment that is active during a specific coverage or care period. Used in pharmacy claims, medication administration records, and clinical protocols to confirm appropriate drug delivery method within the effective timeframe.

effective scheduled dateeff_sched_dt

The planned calendar date on which a service, procedure, or encounter is formally scheduled to occur within an active coverage or authorization window. Used in appointment scheduling, prior authorization tracking, and utilization management to align planned care events with valid benefit periods.

effective scheduled timeeff_sched_tm

The planned clock time at which a service, procedure, or clinical encounter is scheduled to begin within an active coverage or authorization period. Used alongside the scheduled date in appointment management systems to coordinate care delivery and ensure alignment with valid authorization or benefit timeframes.

effective scoreeff_scr

A calculated numeric rating assigned to a member, claim, or clinical event during an active coverage or assessment period. Used in risk adjustment models, quality measurement programs, and predictive analytics to quantify outcomes, severity, or performance relative to a defined effective date range.

effective sequenceeff_seq

A numeric value indicating the ordered position of a record, transaction, or event within a series sharing the same effective date or coverage period. Used in claims adjudication, benefit coordination, and enrollment processing to establish processing priority and maintain correct chronological ordering of related records.

effective severityeff_sev

The classified level of seriousness assigned to a diagnosis, condition, or clinical event that is active within a defined coverage or treatment period. Used in inpatient coding, risk adjustment, and case management to determine resource intensity, reimbursement levels, and care prioritization during the effective timeframe.

effective sexeff_sex

The biological sex classification recorded for a member or patient that is valid and applicable during a specific coverage or clinical period. Used in eligibility verification, claims adjudication, and clinical decision support to ensure demographic accuracy for gender-specific benefit rules, coding edits, and risk adjustment calculations.

effective sourceeff_src

The originating system, organization, or data feed from which a record or transaction was received and validated as active during a specific coverage period. Used in data lineage tracking, enrollment reconciliation, and claims processing to identify where information was submitted and assess its reliability within the effective timeframe.

effective start dateeff_start_dt

The calendar date on which a coverage period, benefit, authorization, enrollment, or clinical record becomes valid and begins to apply. Serves as a foundational temporal anchor in member enrollment, claims adjudication, and contract management, determining when eligibility, benefits, or policy terms first take effect.

effective start timeeff_start_tm

The clock time at which a coverage period, clinical event, or administrative record becomes active on its effective start date. Used in encounter documentation, authorization windows, and shift-based care settings where the precise time a record or benefit becomes valid is required for accurate processing and compliance.

effective stateeff_st

The US state or territory associated with a member, contract, or benefit record that is valid during a specific coverage period. Used in eligibility determination, claims routing, network management, and regulatory compliance to apply the correct state-specific benefit rules, mandates, and reimbursement policies within the effective date range.

effective statuseff_sts

The current operational state of a member enrollment, claim, authorization, or clinical record within its active coverage period, such as active, terminated, pending, or suspended. Drives processing logic in eligibility systems, claims adjudication engines, and care management platforms to determine whether a record is actionable at a given point in time.

effective street addresseff_st_addr

The physical street-level mailing or service location address associated with a member, facility, or contract that is valid during a specific coverage or enrollment period. Used in eligibility verification, claims processing, network assignment, and correspondence generation to ensure accurate geographic placement throughout the effective date range.

effective strengtheff_str

The documented concentration or dosage amount of a medication that is prescribed or dispensed during an active coverage or treatment period. Used in pharmacy claims processing, formulary management, and medication therapy management to verify appropriate dosing, apply tier-based cost-sharing rules, and support clinical safety reviews.

effective subtotaleff_subtot

A partial financial sum calculated for a subset of charges, payments, or adjustments associated with a claim, remittance, or benefit record within an active coverage period. Used in claims adjudication, explanation of benefits generation, and financial reconciliation to itemize cost components before applying full totals or final payment amounts.

effective system identifiereff_sys_id

A unique system-generated key assigned to a record to identify and track it across multiple healthcare platforms throughout its active coverage or processing period. Used in member enrollment, claims adjudication, and data integration workflows to ensure consistent cross-system referencing, deduplication, and accurate record linkage within the effective timeframe.

effective targeteff_tgt

The designated recipient, destination system, clinical goal, or benchmark associated with a record or transaction during an active coverage or program period. Used in care management, quality reporting, and claims routing to identify where a transaction should be directed or what outcome measure applies within the defined effective date range.

effective taxonomy codeeff_tax_cd

The National Uniform Claim Committee provider specialty classification code, such as an NUCC taxonomy code, that is valid for a credentialed provider during a specific enrollment or contracting period. Used in claims adjudication, network management, and provider directory maintenance to validate specialty-specific billing privileges and reimbursement eligibility within the effective date range.

effective temperatureeff_temp

The recorded body temperature measurement associated with a specific clinical observation or encounter, capturing the patient's thermal status at a defined point in time. Used in vital signs documentation to monitor fever, hypothermia, or treatment response within clinical records.

PreviousPage 91 of 325Next