Back to search

review entered by

rvw_ent_by
claims·Updated Jun 23, 2026

Definition

ISO-11179 Definition

The username or identifier of the staff member who entered or submitted the clinical or utilization review record into the system. Used for audit trail purposes, accountability tracking, and quality assurance in care management and utilization management workflows.

Standard Abbreviation

rvw_ent_by

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