cpt_hierarchy
Hierarchy for CPT codes.
Foreign Keys:concept_hierarchy1_id=>cpt_concept_description.concept_id,hierarchy_release_date=>cpt_concept_description.release_dateconcept_hierarchy2_id=>cpt_concept_description.concept_id,hierarchy_release_date=>cpt_concept_description.release_dateconcept_hierarchy3_id=>cpt_concept_description.concept_id,hierarchy_release_date=>cpt_concept_description.release_dateconcept_hierarchy4_id=>cpt_concept_description.concept_id,hierarchy_release_date=>cpt_concept_description.release_dateconcept_hierarchy5_id=>cpt_concept_description.concept_id,hierarchy_release_date=>cpt_concept_description.release_dateconcept_hierarchy6_id=>cpt_concept_description.concept_id,hierarchy_release_date=>cpt_concept_description.release_dateproduct_service_id=>product_service_code_lookup.product_service_id
cpt_hierarchy_concept_hierarchy1_id_hierarchy_release_date_idx-concept_hierarchy1_id,hierarchy_release_datecpt_hierarchy_concept_hierarchy2_id_hierarchy_release_date_idx-concept_hierarchy2_id,hierarchy_release_datecpt_hierarchy_concept_hierarchy3_id_hierarchy_release_date_idx-concept_hierarchy3_id,hierarchy_release_datecpt_hierarchy_concept_hierarchy4_id_hierarchy_release_date_idx-concept_hierarchy4_id,hierarchy_release_datecpt_hierarchy_concept_hierarchy5_id_hierarchy_release_date_idx-concept_hierarchy5_id,hierarchy_release_datecpt_hierarchy_concept_hierarchy6_id_hierarchy_release_date_idx-concept_hierarchy6_id,hierarchy_release_datecpt_hierarchy_product_service_id_idx-product_service_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
concept_hierarchy1_id | integer | No | Yes | Links to the concept ID of the first level hierarchy |
concept_hierarchy2_id | integer | Yes | Yes | Links to the concept ID of the second level hierarchy |
concept_hierarchy3_id | integer | Yes | Yes | Links to the concept ID of the third level hierarchy |
concept_hierarchy4_id | integer | Yes | Yes | Links to the concept ID of the fourth level hierarchy |
concept_hierarchy5_id | integer | Yes | Yes | Links to the concept ID of the fifth level hierarchy |
concept_hierarchy6_id | integer | Yes | Yes | Links to the concept ID of the sixth level hierarchy |
hierarchy_release_date | date | No | Yes | Release date of the hierarchy file |
product_service_id | bigint | No | Yes | Link to the product_service_code_lookup record |