icd count
icd_cntDefinition
ISO-11179 Definition
Total number of times a specific ICD diagnosis code appears within a defined dataset, patient record, or reporting period. Used in population health analytics, disease prevalence measurement, utilization management, and quality reporting to quantify the frequency of documented clinical conditions across healthcare populations.
Standard Abbreviation
icd_cnt
Category
Production DDL — FACT_CLINICAL_EVENT
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
Related Definitions
Looking for more healthcare terms?
Browse our complete library of 100,000+ standardized healthcare data terms
Browse All Terms