The cptevents table
Table source: Hospital database.
Table purpose: Contains current procedural terminology (CPT) codes, which facilitate billing for procedures performed on patients.
Number of rows: 573146
- PATIENTS on
- ADMISSIONS on
The CPTEVENTS table contains a list of which current procedural terminology codes were billed for which patients. This can be useful for determining if certain procedures have been performed (e.g. ventilation).
- The respiratory cost center bills for ventilation regardless of duration. That means that 30 minutes of mechanical ventilation for a single day would result in same billing code as a full 24 hours of mechanical ventilation.
- Non-invasive ventilation and mechanical ventilation use the same CPT code. Differentiating these concepts requires selecting them using the
|Name||Postgres data type|
CPTEVENTS contains current procedural terminology (CPT) codes for patients as billed through either the ICU cost center or the respiratory cost center. Each code represents a distinct procedure performed on the patient during their ICU stay.
Identifiers which specify the patient:
SUBJECT_ID is unique to a patient and
HADM_ID is unique to a patient hospital stay.
COSTCENTER is the cost center which billed for the corresponding CPT codes. There are two possible cost centers: ‘ICU’ and ‘Resp’. ‘Resp’ codes correspond to mechanical or non-invasive ventilation and were billed by the respiratory therapist. ‘ICU’ codes correspond to the procedures billed for by the ICU.
The date at which the procedure occurred.
CPT_CD contains the original CPT code.
CPT_NUMBER is a numeric version of the
CPT_CD column, which allows for easier range comparisons in querying. However, note not all
CPT_CD are fully numeric. The
CPT_SUFFIX column contains the text suffix when the
CPT_CD contains non-numeric characters.
The order of the
The section headers provide a category for the given CPT code. These headers were assigned using the D_CPT table.
In the case of a
CPT_CD corresponding to the respiratory cost center, the description provides information about the meaning of the CPT code. Otherwise, the field is null.
Was this page helpful?
Glad to hear it! Please raise an issue here to tell us how we can improve.
Sorry to hear that. Please raise an issue here to tell us how we can improve.