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 commentterm_cmt

Free-text narrative entered by an enrollment or clinical administrator to document additional context surrounding a coverage or record termination. Captures details not represented by structured fields, such as special circumstances, member-communicated reasons, or manual override justifications.

termination completed dateterm_cmpl_dt

The date on which all administrative processing steps associated with a coverage termination were finalized, including system updates, member notifications, and billing closure. Used in enrollment systems to distinguish processing completion from the actual coverage end effective date.

termination countterm_cnt

The total number of termination events recorded within a defined scope, such as per group, per plan, or per reporting period. Used in enrollment analytics and actuarial reporting to measure disenrollment volume, identify attrition trends, and support population health management.

termination countryterm_ctry

The country recorded as part of a member's or patient's address at the time their coverage or record was terminated. Used in enrollment systems for international member populations to support final correspondence, regulatory compliance, and demographic accuracy in disenrollment processing.

termination created byterm_crtd_by

The unique identifier of the user, system process, or integration that initiated the creation of the termination record. Used in enrollment and administrative audit trails to establish accountability, support data governance reviews, and trace the origin of coverage end transactions.

termination created dateterm_crtd_dt

The calendar date on which the termination record was first entered into the system, which may differ from the termination effective date. Used in enrollment and audit systems to track when disenrollment processing began and to establish data lineage for compliance and reconciliation purposes.

termination created timeterm_crtd_tm

The timestamp indicating the exact time a termination record was created in the system. Used alongside the created date in enrollment and audit workflows to establish precise data entry sequencing, support system reconciliation, and enable conflict resolution when multiple transactions occur on the same date.

termination creatinineterm_cr

The serum creatinine laboratory value recorded at the final clinical encounter or at the time of care termination, serving as a marker of renal function. Used in clinical data systems to document baseline kidney status at discharge or end of treatment for chronic disease management and transition of care records.

termination dateterm_dt

The date a member's health insurance coverage ends in enrollment and eligibility systems, stored in 834 transaction files and member master tables. Data engineers use this field to define coverage windows, validate claims adjudication eligibility, calculate enrollment duration metrics, and trigger downstream disenrollment workflows in PBM and EHR systems.

termination datetimeterm_dttm

The combined date and time value representing the precise moment a coverage termination or clinical record closure became effective or was processed. Used in enrollment and clinical systems where time-of-day precision is required for same-day transaction sequencing, eligibility adjudication, and audit logging.

termination dea numberterm_dea_nbr

The Drug Enforcement Administration registration number associated with a prescriber or pharmacy at the point their record or authorization was terminated. Used in pharmacy and credentialing systems to document the DEA credential on file when a prescriber's system access or controlled substance authorization ends.

termination death dateterm_death_dt

The recorded date of death for a member or patient, used to trigger coverage termination in enrollment systems and close active clinical records. Initiates downstream processes including beneficiary notifications, estate billing adjustments, Medicare coordination, and survivor benefit eligibility determinations.

termination deleted dateterm_del_dt

The date on which a termination record was logically removed or voided from the system, typically due to a retroactive reinstatement, data entry error, or enrollment correction. Used in audit trails to preserve record history and support reconciliation between current enrollment state and historical transaction logs.

termination descriptionterm_desc

A human-readable text explanation of the reason or nature of a coverage or record termination, corresponding to the associated termination code. Used in enrollment systems to provide clear, displayable context for member correspondence, customer service workflows, and reporting interfaces where coded values alone are insufficient.

termination detailterm_dtl

Supplementary information describing the circumstances of a member's coverage termination, including reason codes, disenrollment type, or carrier-specific notes recorded in enrollment systems to support audit trails and coverage reconciliation reporting.

termination due dateterm_due_dt

The deadline by which a member's coverage termination must be processed or finalized in the enrollment system. Used in health plan administration to ensure timely disenrollment, premium reconciliation, and downstream eligibility file transmission to providers and claims systems.

termination effective dateterm_eff_dt

The date on which a member's health plan coverage officially ends. Recorded in enrollment and eligibility systems to determine coverage validity during claims adjudication, ensuring benefits are not paid for services rendered after the termination date.

termination emailterm_eml

The electronic mail address associated with the contact responsible for or notified about a member's coverage termination. Used in health plan enrollment workflows to deliver disenrollment confirmations, COBRA notices, or termination acknowledgment communications.

termination end dateterm_end_dt

The final date marking the close of a coverage termination transaction or processing window within the enrollment system. Used to define the boundary of a termination record's validity period and support retrospective eligibility audits and enrollment reconciliation.

termination end timeterm_end_tm

The specific time stamp marking when a coverage termination transaction was closed or finalized in the enrollment system. Used alongside termination end date to provide precise audit logging for eligibility changes and downstream eligibility file processing.

PreviousPage 274 of 325Next