Back to search

regulation claim date

reg_clm_dt
claims·Updated Jun 23, 2026

Definition

ISO-11179 Definition

The date a claim was submitted in connection with a regulatory compliance requirement, such as a state mandate or federal program obligation. Used in compliance reporting systems to verify that claims tied to regulated benefits or services were submitted within required filing timeframes.

Standard Abbreviation

reg_clm_dt

Category

claims

Production DDL — FACT_CLAIM_HEADER

FACT_CLAIM_HEADER.sql
CREATE OR REPLACE TABLE FACT_CLAIM_HEADER (
    clm_key        INTEGER        NOT NULL  -- surrogate key,
    clm_id         VARCHAR(50)    NOT NULL  -- claim identifier,
    mbr_key        INTEGER        NOT NULL  -- FK to DIM_MEMBER,
    prvdr_key      INTEGER        NOT NULL  -- FK to DIM_PROVIDER,
    clm_typ_cd     VARCHAR(10)              -- claim type code,
    clm_stat_cd    VARCHAR(10)              -- claim status code,
    svc_from_dt    DATE                     -- service from date,
    svc_to_dt      DATE                     -- service to date,
    diag_cd_1      VARCHAR(10)              -- principal diagnosis,
    proc_cd        VARCHAR(10)              -- procedure code,
    clm_bill_amt   DECIMAL(18,2)            -- billed amount,
    clm_alwd_amt   DECIMAL(18,2)            -- allowed amount,
    clm_pd_amt     DECIMAL(18,2)            -- paid amount,
    denial_rsn_cd  VARCHAR(10)              -- denial reason code,
    load_dt        TIMESTAMP_NTZ  NOT NULL  -- load timestamp
);

Standard Snowflake DDL for the canonical claims table. Convert to BigQuery or Databricks →

Why This Term Matters

Claims data is the financial backbone of the US healthcare system, and understanding claims terminology is essential for building accurate revenue cycle and reimbursement analytics. Data engineers who know this terminology can correctly parse 837 transactions, identify adjudication errors, and model denial patterns that represent real revenue recovery opportunities. A single misunderstood claims field can result in millions in underpayments identified only after external audits.

Related Content

Looking for more healthcare terms?

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

Browse All Terms