cpt_hierarchy

Hierarchy for CPT codes.

Checks:

• cpt_hierarchy_null_id_check - ((cpt_id IS NOT NULL) OR (hcpcs_id IS NOT NULL))

Foreign Keys:

• concept_hierarchy1_id => cpt_concept_description.concept_id, hierarchy_release_date => cpt_concept_description.release_date
• concept_hierarchy2_id => cpt_concept_description.concept_id, hierarchy_release_date => cpt_concept_description.release_date
• concept_hierarchy3_id => cpt_concept_description.concept_id, hierarchy_release_date => cpt_concept_description.release_date
• concept_hierarchy4_id => cpt_concept_description.concept_id, hierarchy_release_date => cpt_concept_description.release_date
• concept_hierarchy5_id => cpt_concept_description.concept_id, hierarchy_release_date => cpt_concept_description.release_date
• concept_hierarchy6_id => cpt_concept_description.concept_id, hierarchy_release_date => cpt_concept_description.release_date
• cpt_id => cpt_lookup.cpt_id
• hcpcs_id => hcpcs_lookup.hcpcs_id

Indexes:

• cpt_hierarchy_unique_id_index (Unique) - cpt_id, hcpcs_id

Column	Data Type	Nullable	Indexed	Description
cpt_id	bigint	Yes	Yes	-
concept_hierarchy1_id	integer	No	No	-
concept_hierarchy2_id	integer	Yes	No	-
concept_hierarchy3_id	integer	Yes	No	-
concept_hierarchy4_id	integer	Yes	No	-
concept_hierarchy5_id	integer	Yes	No	-
concept_hierarchy6_id	integer	Yes	No	-
hierarchy_release_date	date	No	No	-
hcpcs_id	bigint	Yes	Yes	-