[MT-L] BarStats tables, DR 6.15
Doug Watson
We are a 6.15 site that uses DR.
I am finding that many of the tables that consume the most disk space in our Livefdb database are BarStatsList tables.
Does anyone use these tables for any reporting or find them to be of use? Also does anyone find the BarDStats or BarMStats tables to be of any use?
I have very nearly made up my mind to have these turned off and to truncate those tables as they account for over 50% of our total livefdb drive space usage and I am not using one of them for any reporting.
I had thought that perhaps I should investigate these tables for potential usefulness but without a specific reporting need at the moment that is a difficult thing to determine.
I am working on mining out some denial info and one large table “BarStatsList_Denials” caught my eye. However upon looking at it, it seems to have a lot of redundant data. For example 1 account that has 2 denials accounts for 1440 rows in this table but it
is just the same 2 denials over and over again. Until I see that this is part of a larger, more useful picture, I feel that is simply a waste of space for us.
Thanks,
Doug Watson
Systems Administrator
Decatur County Memorial Hospital
720 N Lincoln Street
Greensburg, IN 47240
812.663.1167
doug....@dcmh.net
This message and attachments may contain protected health information from Decatur County Memorial Hospital, and is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521. This information is intended only for the use of the individual or entity named in the email. Any unintended recipient is hereby notified that the information is privileged and confidential. Any use, disclosure or reproduction of this information is prohibited. Any unintended recipient should contact DCMH by phone at 812-663-4331 or by email immediately and delete/destroy the original message. Confidential health information is protected by state and federal law, including, but not limited to, The Health Insurance Portability and Accountability Act (HIPAA) of 1996 and related regulations. Please note that any views or opinions presented in the email are solely those of the author and do not represent DCMH.