icd_diagnosis_lookup

List of ICD Diagnosis codes from CMS. (https://www.cms.gov/medicare/coding-billing/icd-10-codes)

Primary Key:

• icd_diagnosis_id

Checks:

• icd_diagnosis_lookup_diagnosis_code_check - (diagnosis_code = upper(diagnosis_code))

Indexes:

• diagnosis_code_prefix_idx - "left"(diagnosis_code, 4)
• icd_diagnosis_lookup_diagnosis_code_release_date_idx (Unique) - diagnosis_code, release_date

Column	Data Type	Nullable	Indexed	Description
icd_diagnosis_id	bigint	No	Yes	Snowflake ID for ICD Diagnosis. Generated through expression:
diagnosis_code	text	No	Yes	The ICD diagnosis code. Generated through expression:
description	text	No	No	ICD diagnosis description. For example: 'Chronic migraine with aura, intractable'. Generated through expression:
icd_version	text	No	No	Version of ICD (e.g. 9 for ICD-9 and 10 for ICD-10) Generated through expression:
release_date	date	No	Yes	Release date of ICD Generated through expression: