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

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

termination emergency indicatorterm_emerg_ind

A flag identifying whether a member's coverage termination is associated with or occurred during an emergency medical event. Used in enrollment and claims systems to apply appropriate protections, such as retroactive eligibility reinstatement or emergency claims payment rules required under state and federal continuation of coverage regulations.

termination history present illnessterm_hpi

Documents the clinical narrative describing a member's presenting condition at the time a coverage termination event occurred. Used in retrospective eligibility reviews and appeals to assess whether a termination interrupted treatment for an active illness, which may support reinstatement or retroactive coverage determinations.

termination instructionterm_instr

Contains the administrative or procedural guidance associated with processing a member's coverage termination, including required notifications, effective date rules, or special handling steps. Used by enrollment operations staff to ensure terminations are executed in compliance with plan policies and regulatory requirements such as COBRA or state continuation laws.

termination labelterm_lbl

A human-readable display identifier or descriptive tag assigned to a coverage termination record within enrollment or benefits administration systems. Used in reporting interfaces, member correspondence, and system user interfaces to clearly identify and distinguish termination transactions by type, reason, or processing status.

termination noteterm_nt

A free-text annotation field capturing supplemental information about a member's coverage termination event, such as member-provided context, staff observations, or follow-up actions required. Used in enrollment case management to document details not captured in structured fields, supporting audit reviews and member appeals processing.

termination procedure dateterm_proc_dt

Records the date on which a specific medical procedure was performed in relation to a member's coverage termination event. Used in enrollment and claims coordination to determine whether procedures were rendered while coverage was active, supporting retroactive eligibility reviews and medical claims continuity assessments.

termination rangeterm_rng

Defines the permissible or expected date span or value boundaries associated with a coverage termination record, such as valid effective date windows or lookback periods. Used in enrollment system validations and eligibility audits to ensure termination dates fall within acceptable ranges per plan rules and regulatory guidelines.

termination resultterm_rslt

Captures the final outcome of a coverage termination transaction or associated appeals process, such as termination upheld, reversed, or modified. Used in member enrollment reporting and regulatory compliance tracking to document resolution of disenrollment actions and measure the frequency and cause of overturned termination decisions.

termination routeterm_rte

Identifies the channel or method through which a member's coverage termination was initiated, such as employer group notification, member voluntary disenrollment, non-payment of premium, or regulatory involuntary disenrollment. Used in enrollment analytics to categorize termination sources and support downstream reporting and member outreach workflows.

termination strengthterm_str

Indicates the degree or basis of evidence supporting a coverage termination decision, such as whether the disenrollment reason is well-documented, contested, or pending verification. Used in enrollment quality review and appeals management to assess the robustness of termination justification and inform reinstatement eligibility determinations.

termination surgery dateterm_surg_dt

Records the date of a surgical procedure performed in proximity to or coinciding with a member's coverage termination event. Used in enrollment and claims systems to evaluate whether surgical services were provided during an active coverage period, supporting retroactive eligibility determinations and continuity of care protections under applicable plan rules.

test active indicatortst_actv_ind

Binary flag indicating whether a diagnostic test order or record is currently active within the clinical system. Used in laboratory and radiology workflows to distinguish active test orders from cancelled, completed, or expired ones, enabling accurate queue management and result tracking.

test active statustst_actv_sts

Categorical status value describing the current activity state of a diagnostic test throughout its lifecycle, such as ordered, in-progress, resulted, or inactive. Used in clinical data warehouses and LIS systems to monitor test workflow progression and support operational reporting.

test admission datetst_admn_dt

Date on which a patient was admitted to a facility specifically for a diagnostic examination or testing procedure, recorded in EHR and institutional claims systems. Data engineers use this field to calculate pre-authorization windows, align UB-04 claim spans, and construct episode-of-care timelines for diagnostic utilization analysis.

test agetst_age

The elapsed time since a diagnostic test was ordered or collected, typically expressed in hours, days, or another unit. Used in laboratory information systems to monitor turnaround time compliance, identify stale pending orders, and prioritize processing queues for time-sensitive specimens.

test allowed amounttst_alwd_amt

The maximum dollar amount a payer will reimburse for a specific diagnostic test based on the contracted fee schedule or plan benefit design. Used in claims adjudication to calculate member cost-sharing, apply contractual adjustments, and determine provider payment for laboratory or imaging services.

test amounttst_amt

Monetary value associated with a diagnostic test record in healthcare data systems such as EHR, claims, or lab platforms. Used by data engineers to validate financial fields, reconcile billing amounts, and ensure accurate cost capture across adjudication pipelines.

test approved bytst_appr_by

Identifier of the clinician or authorized user who approved or authorized the diagnostic test order, result release, or associated clinical action. Used in laboratory and EHR audit trails to enforce ordering privileges, support result verification workflows, and maintain regulatory compliance documentation.

test arrival timetst_arrv_tm

The recorded timestamp indicating when a patient or specimen arrived at the testing facility or collection site for a diagnostic examination. Used in laboratory and radiology systems to calculate pre-analytical turnaround metrics, monitor service level compliance, and support operational efficiency reporting.

test arrived datetst_arrv_dt

The calendar date on which a patient or biological specimen arrived at the diagnostic testing location. Used in laboratory information systems to establish the start of the pre-analytical phase, track specimen chain of custody, and calculate total processing turnaround time for quality reporting.

PreviousPage 720 of 806Next