How do I write a report that shows patients with secondary insurance? We only have a handful of patients with secondary insurance and we want a report of just these secondary insurance patients.
This report can be created via Reports>Patient>User-Selected. You will need to include in your selection the Sec. Plan like below:
...and also make sure that you only include active patients and remove prim. plan print option from your report.
There should be no "X" next to Prim. Plan like you see in the above picture. You make sure only active patients show up on the report by making sure your report setup also include this:
User-Selected reports can be confusing if you've never messed with them, so if this is not clear please don't hesitate to let me know.
The only items in your User-Selected Report setup that should have an "X" next to them are the following items:
User Codes*EQ or NE
Not sure what I am doing wrong. It is generating a report with all patients who have no insurance, and secondary insurance. It is excluding patients with primary insurance though.
I appreciate your help.
Oh wow I'm so sorry. I totally ignored the Ops of the Sec. Plan selection. In your report setup, double click the Sec. Plan item and make yours look like this...
Your results should not list any Plan 1 info, but only info for Plan 2 with Plan IDs. At the bottom of the report, you will have a total of patients on the report as well.
The user-generated reports will give you EXACTLY what you ask for. In the case @bccarestreamrep suggested, it will provide you ALL the patients with NO primary insurance and with secondary insurance. That is what data you provided. Unfortunately you assume that Softdent will provide the other information, namely those patients with primary and secondary insurance, but that is not what you asked it to do.
In fairness, when we do such type of user generated reports, we run to print screen, evaluate if what is provided is what we want. If not, go back and readjust, then rerun. Even the most "seasoned" Softdent offices can get reports a little off kilter at times.