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

termination entered byterm_ent_by

The user ID or name of the staff member or automated process that recorded the coverage termination in the enrollment or eligibility system. Used for audit trail purposes to track accountability and support quality reviews of disenrollment transactions.

termination ethnicityterm_ethn

The self-reported or assigned ethnicity of the member whose coverage is being terminated. Captured in enrollment systems to support health equity reporting, CMS demographic analysis, and population health monitoring across disenrolled member segments.

termination expiration dateterm_exp_dt

The date after which a pending or approved coverage termination record is no longer valid for processing in the enrollment system. Used to manage time-sensitive disenrollment transactions and prevent retroactive terminations beyond allowable adjustment windows.

termination external identifierterm_ext_id

A reference ID assigned by an external system, such as a state Medicaid agency, employer group portal, or clearinghouse, that uniquely identifies a coverage termination transaction. Used to reconcile enrollment records across trading partner systems and support cross-platform eligibility audits.

termination faxterm_fax

The facsimile number associated with the contact or entity notified of or responsible for a member's coverage termination. Used in health plan enrollment workflows to route termination documentation, disenrollment confirmations, or regulatory notices via fax transmission.

termination feeterm_fee

A charge assessed in connection with the processing or administration of a member's coverage termination. May apply in certain employer-sponsored or voluntary plan arrangements and is recorded in billing and enrollment systems to support premium reconciliation and financial reporting.

termination first nameterm_first_nm

The given name of the individual associated with a coverage termination record, typically the member being disenrolled. Captured in enrollment systems to support member identification, termination correspondence generation, and eligibility reconciliation across health plan data systems.

termination flagterm_flg

A binary or coded indicator that marks whether a member's enrollment record has been terminated within the eligibility system. Used in claims adjudication and eligibility verification to quickly identify disenrolled members and prevent erroneous benefit payments.

termination full nameterm_full_nm

The complete legal name of the individual associated with a coverage termination record, typically the disenrolling member. Used in enrollment systems to support identity verification, disenrollment correspondence, regulatory reporting, and reconciliation with external eligibility data sources.

termination genderterm_gndr

The gender of the member whose health plan coverage is being terminated. Captured in enrollment systems to support demographic reporting, CMS data submissions, health equity analysis, and accurate member identification during disenrollment processing and eligibility reconciliation.

termination glucoseterm_gluc

A blood glucose measurement recorded in association with a clinical encounter or chronic condition management event at the time of or related to a care plan or program termination. Used in disease management systems to document member health status at program exit.

termination group numberterm_grp_nbr

The insurance group identifier associated with the employer or sponsor group from which a member is being terminated. Used in enrollment and billing systems to route disenrollment transactions, update carrier eligibility files, and reconcile group-level premium and membership records.

termination hemoglobinterm_hgb

A hemoglobin measurement recorded at the conclusion of a clinical program or care management episode, captured to document a member's health status at program termination. Used in chronic disease management and population health systems to evaluate outcomes at program exit.

termination identifierterm_id

A unique system-generated or assigned value that identifies a specific coverage termination transaction within the enrollment or eligibility system. Used to reference, track, and audit individual disenrollment records across health plan administrative systems and trading partner data exchanges.

termination indexterm_idx

The sequential position number assigned to a member coverage termination record within a dataset or transaction set. Used in member enrollment systems to order and reference multiple termination events for the same subscriber or dependent across benefit periods.

termination keyterm_key

The unique lookup reference value used to locate a specific member coverage termination record in enrollment or eligibility systems. Enables downstream claims adjudication and eligibility verification processes to retrieve and validate the correct end-of-coverage details for a subscriber or dependent.

termination languageterm_lang

The preferred written or spoken communication language of a member at the time their health plan coverage was terminated. Used in member enrollment systems to ensure termination notices, COBRA communications, and disenrollment correspondence are delivered in the member's preferred language.

termination last nameterm_last_nm

The family surname of the subscriber or dependent member whose health plan coverage was terminated. Captured in member enrollment records to identify the individual on disenrollment transactions, termination notices, and eligibility files submitted to payers and clearinghouses.

termination legal nameterm_legal_nm

The full official registered name of the member or subscriber as it appears on legal documentation at the time health plan coverage was terminated. Used in enrollment and disenrollment transactions to ensure identity consistency across government reporting, COBRA notices, and carrier eligibility files.

termination levelterm_lvl

The hierarchical tier at which a health plan coverage termination is applied, such as subscriber, dependent, or family unit level. Used in member enrollment systems to determine whether disenrollment affects an individual member, all dependents under a subscriber, or an entire group contract.

PreviousPage 275 of 325Next