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_dateline_item_procedure_code_id=>line_item_procedure_code_lookup.line_item_procedure_code_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
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: |
hierarchy_release_date | date | No | No | Release date of the hierarchy file Generated through expression: |
line_item_procedure_code_id | bigint | No | No | Link to the line_item_procedure_code_lookup record Generated through expression: |