The d_cpt table
Table source: Online definitions.
Table purpose: High-level definitions for current procedural terminology (CPT) codes.
Number of rows: 134
- CPTEVENTS on
This table gives some high level information regarding current procedural terminology (CPT) codes. Unfortunately, detailed information for individual codes is unavailable.
- Unlike all other definition tables,
D_CPTdoes not have a one to one mapping with the corresponding
CPTEVENTS, rather each row of
D_CPTmaps to a range of
|Name||Postgres data type|
D_CPT provides information about CPT codes, specifically it provides the overall purpose of the procedure and in some cases the body system related to the procedure.
CATEGORY is a integer which identifies the category of the CPT code.
SECTIONRANGE defines the range of codes for the given section, and
SECTIONHEADER provides the description of the given section. There are 8 possible sections:
- Evaluation and management
- Emerging technology
- Pathology and laboratory
- Performance measurement
Note that the evaluation and management tends to represent administrative or generic costs.
Similarly as for the sections,
SUBSECTIONRANGE defines the range of codes for the given subsection, and
SUBSECTIONHEADER provides the description of the given subsection. The subsection provides extra detail which can be useful, for example, when the section header is ‘Anesthesia’ the subsection provides information on the general anatomical region for the anesthesia.
These columns provide numeric representations of minimum and maximum value in the
SUBSECTIONRANGE column. This facilitates joining the
CPTEVENTS table to the
D_CPT table on