This report shows patient chart number, first & last name, date of service, DOB, age, and billed CPT code.
A sample image of this SQL report run in the Database Viewer is shown below:
- Age is the age on the date of service, not necessarily the patient’s current age.
- It does not include voided CPT codes.
To highlight and copy the code below to your clipboard, simply click the Copy button.
select patno, date1, birthdat, floor(datediff(month, dateadd(day,-extract(day from birthdat)+1,birthdat), dateadd(day,-extract (day from birthdat)+1,date1))/12) as age_on_dos, cptcode from register inner join archive_transactions on archive_transactions.patno = register.patno where date1 between :start_date and :end_date and archive_flag = 1 and cptcode not in ('1','2','3','4')