Back to search

adjustment datetime

adj_dttm
claims·Updated Jun 23, 2026

Definition

ISO-11179 Definition

The combined date and timestamp recording the exact moment a financial adjustment was created, modified, or processed in a claims adjudication or revenue cycle system. Used for precise audit trail logging, sequencing of adjustment transactions, and time-based reconciliation across payer, EHR, and billing data pipelines.

Standard Abbreviation

adj_dttm

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