cpt_hierarchy_crosswalk
Crosswalk between cpt and cpt hierarchy..
Primary Key:Foreign Keys:concept_hierarchy1_id=>cpt_concept_description.concept_id,release_date=>cpt_concept_description.release_dateconcept_hierarchy2_id=>cpt_concept_description.concept_id,release_date=>cpt_concept_description.release_dateconcept_hierarchy3_id=>cpt_concept_description.concept_id,release_date=>cpt_concept_description.release_dateconcept_hierarchy4_id=>cpt_concept_description.concept_id,release_date=>cpt_concept_description.release_dateconcept_hierarchy5_id=>cpt_concept_description.concept_id,release_date=>cpt_concept_description.release_dateconcept_hierarchy6_id=>cpt_concept_description.concept_id,release_date=>cpt_concept_description.release_date
cpt_hierarchy_crosswalk_concept_hierarchy1_id_release_date_idx-concept_hierarchy1_id,release_datecpt_hierarchy_crosswalk_concept_hierarchy2_id_release_date_idx-concept_hierarchy2_id,release_datecpt_hierarchy_crosswalk_concept_hierarchy3_id_release_date_idx-concept_hierarchy3_id,release_datecpt_hierarchy_crosswalk_concept_hierarchy4_id_release_date_idx-concept_hierarchy4_id,release_datecpt_hierarchy_crosswalk_concept_hierarchy5_id_release_date_idx-concept_hierarchy5_id,release_datecpt_hierarchy_crosswalk_concept_hierarchy6_id_release_date_idx-concept_hierarchy6_id,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 | Yes | Links to the concept ID of the first level hierarchy Generated through expression: |
concept_hierarchy2_id | integer | Yes | Yes | Links to the concept ID of the second level hierarchy Generated through expression: |
concept_hierarchy3_id | integer | Yes | Yes | Links to the concept ID of the third level hierarchy Generated through expression: |
concept_hierarchy4_id | integer | Yes | Yes | Links to the concept ID of the fourth level hierarchy Generated through expression: |
concept_hierarchy5_id | integer | Yes | Yes | Links to the concept ID of the fifth level hierarchy Generated through expression: |
concept_hierarchy6_id | integer | Yes | Yes | Links to the concept ID of the sixth level hierarchy Generated through expression: |