deductible expiration date

ded_exp_dt

claims

Updated 5/16/2026

Definition

The date after which a member's accumulated deductible credits are no longer valid within a given benefit period, as tracked in payer and PBM systems. Critical for adjudication pipelines to reset accumulators and ensure accurate cost-sharing calculations in claims processing workflows.

Standard Abbreviation

ded_exp_dt

Database Usage

-- Example column naming
CREATE TABLE claims (
  clm_id VARCHAR(50),
  ded_exp_dt DATE,  -- deductible expiration date (date only, no time)
  ...
);

-- Example in SELECT
SELECT
  clm_id,
  ded_exp_dt as deductible_expiration_date
FROM claims;

Common uses in healthcare data

Claims adjudication and remittance processing
837P/837I/837D claim file parsing and validation
Revenue cycle management and denial analytics
CMS cost report and Medicare cost reporting
Payer contract performance and underpayment analysis

Example database column name

ISO-11179 snake_case standard

-- Recommended column name
ded_exp_dt

-- Example DDL
CREATE TABLE healthcare_data (
  record_id   VARCHAR(50)   NOT NULL,
  ded_exp_dt   DATE,  -- deductible expiration date (date only, no time)
  created_dt  TIMESTAMP     NOT NULL DEFAULT NOW()
);

Column names follow the ISO-11179 naming convention: lowercase, underscore-separated, using the standard abbreviation as a prefix where applicable.

Looking for more healthcare terms?

Browse our complete library of 100,000+ standardized healthcare data terms

Browse All Terms