Patients list having no insurance

dkdipak1 wrote on Wednesday, April 22, 2015:

Hello team,

Is there any way I can get a list of patients, who don’t have insurance. There are two separate table in DB to figure that. Any help?

Thanks,
DK

fsgl wrote on Thursday, April 23, 2015:

None of the Reports are of any help. Too bad the Indigent Report could not be used.

There are the patient_data & insurance_data tables.

Can you run a query to have the the names on the second table subtracted from the first giving patients with no insurance? I’ve never done one, thus unable to elaborate.

Hopefully you don’t need this quickie tutorial.

dkdipak1 wrote on Friday, April 24, 2015:

Thanks fsgl, IN fact I had to used third table as well, I have figured this out may be, it will be useful for some other user as well, here is the sql,

SELECT patient_data.fname, patient_data.lname, insurance_companies.name
FROM openemr.insurance_companies insurance_companies INNER JOIN (openemr.patient_data patient_data INNER JOIN openemr.insurance_data insurance_data ON patient_data.pid=insurance_data.pid) ON insurance_companies.id=insurance_data.provider.

By the way this gives the list for patient having insurance.

fsgl wrote on Friday, April 24, 2015:

Thanks for the feedback.

With just a tiny bit more research, found this & in plain English, no less!

blankev wrote on Friday, April 24, 2015:

Last line, would it work ?? if changed into " " meaning empty? Or “NE”, (i.e. Not Equal to), or EMPTY

insurance_companies.id=" "

aethelwulffe wrote on Tuesday, March 15, 2016:

				<?php if ($_POST['form_refresh']) { ?>
                Change line 172 in the indigents report to the above.

aethelwulffe wrote on Tuesday, March 15, 2016:

Someone accidentally changed the indigent report’s form name and post statement around and broke it sometime in the past apparently. Found this while testing the “search and destroy SQL Ledger” project.

bradymiller wrote on Monday, March 21, 2016:

Hi,
Terry just fixed this issue on the code that was just committed to the main codebase for the SQL Ledger removal project.
-brady
OpenEMR