Back to search

infectious disease chief complaint

id_cc
clinical·Updated Jun 23, 2026

Definition

ISO-11179 Definition

The primary symptom or reason for visit documented at the start of an infectious disease encounter, as reported by the patient. Common examples include fever, productive cough, skin lesions, or night sweats, which guide initial clinical assessment and diagnostic workup for infectious conditions.

Standard Abbreviation

id_cc

Category

clinical

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.

Related Content

Looking for more healthcare terms?

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

Browse All Terms