Clinical Status

clin_sts_cd

clinical

Updated 5/15/2026

Definition

A coded field in EHR and claims systems representing the current state of a patient diagnosis, such as Active, Relapse, Remission, or Resolved. Stored as clin_sts_cd, this field drives care management workflows, chronic disease tracking, and population health stratification in clinical data warehouses.

Standard Abbreviation

clin_sts_cd

Database Usage

-- Example column naming
CREATE TABLE claims (
  clm_id VARCHAR(50),
  clin_sts_cd VARCHAR(20),  -- Clinical Status (max 20 chars)
  ...
);

-- Example in SELECT
SELECT
  clm_id,
  clin_sts_cd as clinical_status
FROM claims;

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

Example database column name

ISO-11179 snake_case standard

-- Recommended column name
clin_sts_cd

-- Example DDL
CREATE TABLE healthcare_data (
  record_id   VARCHAR(50)   NOT NULL,
  clin_sts_cd  VARCHAR(20),  -- Clinical 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.

Looking for more healthcare terms?

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

Browse All Terms