Hi all! I am a data analyst for an MSO that is now working with a group on Centricity. I have been using Crystal Reports to try and create some export friendly reports that we can use to gather charge and payment data.
Unfortunately it seems that our database does not match up with the lovely table/view document I found somewhere in the help module. So I am searching for appropriate fields on my own. I have a decent charge detail report built out, but have one snag there. Is anyone aware of a way to map the diagnosis code ID to the actual code and/or description? I'm struggling with the fields that have multiple items on a report. So for example - I can pull four modifiers into the chart detail line. The fields are labeled Modifier 1MId, Modifier2 MId, etc. But the table that has the modifier detail (i.e. number and description) has one choice to match up to - Modifier MId. Nowhere can I find a table that has the variable versions for me to link up to. (and maybe there is a simple Crystal way around it, but if there is I just don't know about it!). My workaround was to create an "if else" formula where I manually mapped the ID's. (as in "if the ID is 100, display 25, else if the ID is 200, display 51, etc.). Since there are a limited number of modifiers, this worked. But....not so much for the diagnoses. Love to hear if there is a table somewhere for DX's that I could use!
The bigger challenge I'm facing right now is payment detail. So I found a table called PaymentMethod, and another called VisitTransactions. The problem is that I'm getting "duplicate" payments across lines in both versions.
PaymentMethod seems to give me the total amount paid. So if a patient pays on their balance, and they have three claims they need to pay off ($30 each), the total payment of $90 appears on each claim (inflating my actual payment collected x 3). VisitTransactions improves it slightly by giving me the total amount paid on the claim. So in the scenario above, each claim shows a payment of $30 (which is good); but if the claim had two charge lines with a balance of $15 each, the report is giving me $30 on each line (again inflating, at least this time only by x 2, but still problematic).
I need to be able to report on each payment made down to the individual CPT level. The same will be true of adjustments (I haven't even started looking at that one yet).
If anyone has a report built that they're willing to share, or any info about fields/tables that might solve my problems, I would be eternally grateful for the help!
Tina Englert
Data Analyst
US Digestive Health
[email protected]
Posted : November 19, 2020 2:31 am
