dosage status

dos_sts

clinical

Updated 5/15/2026

Definition

Dosage status represents the current state of a prescribed medication regimen as defined by its quantity and amount — for example, "500 mg twice daily." It tracks whether a dosing regimen is actively being followed, held, or completed, and is distinct from individual dose administration events.

Pharmacy & PBM Context

dosage-status (dos_sts) is primarily used in pharmacy claims processing, PBM adjudication systems, and prescription management platforms. It answers the question: "Is this prescribed regimen still active?" — not whether any specific pill was taken on a given day.

Example Values

Common enum values for this column

ACTIVEDISCONTINUEDON_HOLDTITRATINGCOMPLETED

Standard Abbreviation

dos_sts

Database Usage

-- Example column naming
CREATE TABLE claims (
  clm_id VARCHAR(50),
  dos_sts VARCHAR(20),  -- dosage status (max 20 chars)
  ...
);

-- Example in SELECT
SELECT
  clm_id,
  dos_sts as dosage_status
FROM claims;

Example database column name

ISO-11179 snake_case standard

-- Recommended column name
dos_sts

-- Example DDL
CREATE TABLE healthcare_data (
  record_id   VARCHAR(50)   NOT NULL,
  dos_sts      VARCHAR(20),  -- dosage status (max 20 chars)
  created_dt  TIMESTAMP     NOT NULL DEFAULT NOW()
);

Column names follow the ISO-11179 naming convention: lowercase, underscore-separated, using the standard abbreviation as a prefix where applicable.

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.

Common uses in healthcare data

Risk stratification and population health analytics
CMS-HCC risk adjustment and RAF score calculation
Quality measure attribution and HEDIS reporting
Clinical data warehouse schema design
Value-based care contract performance tracking
Epic MyChart and Cerner PowerChart clinical data extraction for analytics pipelines
Snowflake VARIANT column mapping for semi-structured HL7 FHIR clinical payloads
Databricks Delta Lake pipeline orchestration for longitudinal patient cohort analysis

Related Healthcare Standards

HL7 FHIR R4

Defines clinical resource models (Patient, Condition, Observation, Encounter) that map directly to clinical data warehouse schemas and interoperability pipelines.

ICD-10-CM / ICD-10-PCS

The diagnosis and procedure coding systems mandated for all clinical documentation and claims in the US healthcare system.

HEDIS (NCQA)

Specifies clinical quality measure definitions that determine how clinical data is collected, attributed, and reported for Stars and value-based care contracts.

Data Quality Considerations

ICD-10-CM codes are frequently entered with invalid trailing characters or missing decimal points — validate against the current CMS ICD code reference table before loading into your clinical data warehouse.
Clinical date fields (admit date, discharge date, procedure date) often arrive with timezone offsets stripped — standardize to UTC at ingestion and store as TIMESTAMP_NTZ in Snowflake or TIMESTAMP in Databricks.
Null vs. unknown must be distinguished in clinical data: a missing diagnosis code may mean 'not documented' rather than 'not applicable' — use explicit sentinel values and document the distinction in your data dictionary.

Looking for more healthcare terms?

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

Browse All Terms