dose status

dose_sts

clinical·Updated Jun 23, 2026

Definition

ISO-11179 Definition

Dose status represents the administration outcome of a single, individual dose event — recording whether a specific scheduled dose was given, missed, held, or refused at the point of care. It captures dose-level clinical detail and is distinct from the broader dosage regimen status.

EHR & Clinical Context

dose-status (dose_sts) is primarily used in EHR systems, Medication Administration Records (MAR), and clinical data warehouses. It answers the question: "Was this specific dose administered?" — tracking individual dose events rather than the overall prescription status.

Example Values

Common enum values for this column

GIVENMISSEDHELDREFUSEDLATEPARTIAL

Standard Abbreviation

dose_sts

Production DDL — FACT_CLINICAL_EVENT

FACT_CLINICAL_EVENT.sql

CREATE OR REPLACE TABLE FACT_CLINICAL_EVENT (
    clin_evt_key  INTEGER        NOT NULL  -- surrogate key,
    mbr_key       INTEGER        NOT NULL  -- FK to DIM_MEMBER,
    prvdr_key     INTEGER        NOT NULL  -- FK to DIM_PROVIDER,
    diag_cd       VARCHAR(10)              -- ICD-10 diagnosis code,
    hcc_cd        VARCHAR(10)              -- HCC category code,
    proc_cd       VARCHAR(10)              -- procedure code,
    svc_dt        DATE                     -- service date,
    pos_cd        VARCHAR(2)               -- place of service,
    raf_scr       DECIMAL(10,3)            -- RAF score,
    admit_dt      DATE                     -- admission date,
    dsch_dt       DATE                     -- discharge date,
    drg_cd        VARCHAR(10)              -- DRG code,
    los_days      SMALLINT                 -- length of stay,
    readmt_ind    CHAR(1)                  -- readmission indicator,
    load_dt       TIMESTAMP_NTZ  NOT NULL  -- load timestamp
);

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

Why This Term Matters

Clinical terms are the building blocks of risk adjustment, quality measurement, and value-based care analytics. A data engineer who understands this terminology can design schemas that correctly capture patient conditions, procedures, and encounters — enabling accurate HCC scoring, HEDIS measure attribution, and CMS reporting. Misclassifying clinical fields in a data warehouse cascades into incorrect RAF scores and failed regulatory submissions.

Looking for more healthcare terms?

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

Browse All Terms