icd_procedure_lookup

List of ICD Procedure codes from CMS. See: https://www.cms.gov/medicare/coding-billing/icd-10-codes

Primary Key:

• icd_procedure_id

Checks:

• icd_procedure_lookup_procedure_code_check - (procedure_code = upper(procedure_code))

Indexes:

• icd_procedure_lookup_procedure_code_release_date_idx (Unique) - procedure_code, release_date
• procedure_code_prefix_idx - "left"(procedure_code, 3)

Column	Data Type	Nullable	Indexed	Description
icd_procedure_id	bigint	No	Yes	Snowflake ID for ICD procedure. Generated through expression:
procedure_code	text	No	Yes	ICD procedure code. For example, '0FB00ZX' 'Excision of Liver, Open Approach, 'Diagnostic. Generated through expression:
description	text	No	No	Description of ICD procedure code. For example '0FB00ZX' 'Excision of Liver, Open Approach, Diagnostic'. Generated through expression:
icd_version	text	No	No	ICD version, usually 10 for ICD-10. Generated through expression:
release_date	date	No	Yes	Release date of ICD procedure code. Generated through expression: