Skip to main content

icd_procedure_hierarchy1_lookup

ICD procedure code hierarchy level 1 lookup.

Primary Key:Indexes:
  • icd_procedure_hierarchy1_lookup_uq (Unique) - name
ColumnData TypeNullableIndexedDescription
icd_procedure_hierarchy1_idbigintNoYesSnowflake ID for the first level of ICD Procedure Hierarchy.

Generated through expression: 
nametextNoYesHierarchy 1 name. For example, procedures beginning with '0' are 'Medical and Surgical' procedures.

Generated through expression: