Back to search

claim rate

clm_rt
claims·Updated Jun 23, 2026

Definition

ISO-11179 Definition

Contractual or negotiated rate applied to a claim line in payer, PBM, and provider billing systems, reflecting fee schedule, capitation, or per-diem reimbursement amounts. Data engineers map this field to rate tables and fee schedule dimensions when building claims adjudication models and provider payment analytics pipelines.

Standard Abbreviation

clm_rt

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