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	The CPT code that the hierarchy applies to Generated through expression:
release_date	date	No	Yes	The release date for the CPT hierarchy Generated through expression:
concept_hierarchy1_id	integer	No	No	Links to the concept ID of the first level hierarchy Generated through expression:
concept_hierarchy2_id	integer	Yes	No	Links to the concept ID of the second level hierarchy Generated through expression:
concept_hierarchy3_id	integer	Yes	No	Links to the concept ID of the third level hierarchy Generated through expression:
concept_hierarchy4_id	integer	Yes	No	Links to the concept ID of the fourth level hierarchy Generated through expression:
concept_hierarchy5_id	integer	Yes	No	Links to the concept ID of the fifth level hierarchy Generated through expression:
concept_hierarchy6_id	integer	Yes	No	Links to the concept ID of the sixth level hierarchy Generated through expression: