SQL: Entire CPT Code table record, including Fee Schedules

About

This report shows entire CPT code record for all CPT codes, including all fee schedules for all CPTs entered into OP.

A sample image of this SQL report run in the Database Viewer is shown below:

Caveats

ALL CPTs will be shown. To filter the report so that CPTs without a fee entered do not show, a custom filter should be created using the “greater than” filter.

Code

To highlight and copy the code below to your clipboard, simply click the Copy button.

select * from cpt_codes