cpt_hierarchy_crosswalk

Crosswalk between cpt and cpt hierarchy..

Primary Key:

• cpt_code
• release_date

Foreign Keys:

• concept_hierarchy1_id => cpt_concept_description.concept_id, release_date => cpt_concept_description.release_date
• concept_hierarchy2_id => cpt_concept_description.concept_id, release_date => cpt_concept_description.release_date
• concept_hierarchy3_id => cpt_concept_description.concept_id, release_date => cpt_concept_description.release_date
• concept_hierarchy4_id => cpt_concept_description.concept_id, release_date => cpt_concept_description.release_date
• concept_hierarchy5_id => cpt_concept_description.concept_id, release_date => cpt_concept_description.release_date
• concept_hierarchy6_id => cpt_concept_description.concept_id, release_date => cpt_concept_description.release_date

Column	Data Type	Nullable	Indexed	Description
cpt_code	text	No	Yes	-
release_date	date	No	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	-