This report looks at all patient charts who do not have a guarantor assigned. It also lists if they have a balance and the status of the account.
A sample image of this SQL report run in the Database Viewer is shown below:
To highlight and copy the code below to your clipboard, simply click the Copy button.
select patno, fname, lname, guarantor_id,copaybal, status_pat from register where patno >99 and fname is not null and guarantor_id = 0 order by guarantor_id