Notifications
Clear all
Topic starter
I am trying to get an accurate idea of what this is counting for the numerator and denominator. According to GE report handbook, it says the denominator is count 1 for every qualified observation contained in a linked document. Count 1 for every lab report document that does not contain structured data. Numerator is count 1 for every structured data.
However, I manually counted every thing for an entire month and am not getting the same number the report is. Not even close. We have a provider who is dropping below the 95% confidence level and I need to figure out why but I can't even figure out what its counting and not counting.
For example, we are scanning drug testing with the document type of lab report, however, it is not counting these at all. I thought maybe this was the issue, but it's not even a factor one way or the other.
Any ideas?
Posted : August 1, 2013 5:04 am
The report counts each result seperate. So a Basic Metabolic Panel will count as 12 seperate results (sodium, potassium, chloride, ect) instead of just 1 test. Is this were your count differs from the GE report?
Posted : August 1, 2013 5:32 am
Topic starter
I counted each result as an individual and it still wasn't even close. The denom on the report is 1276 but the individual count is 892. If i add the scanned documents, those would only count as 1 per doc, then that only adds 50. It doesn't look like it counts the venipuncture though or the scanned because one day there was a scanned lab report, a venipuncture and a protime. The protime has 2 results (pt, inr), venipuncture never results, and the scanned report doesnt populate. The report was 2/2 for that day. So I excluded venipuncture and scanned labs from the count.
Posted : August 1, 2013 9:10 pm
The GE MU Crystal Report also limits the available flowsheet lab choices (heirgrps) since you can't be expected to store a non-numerical (positive/negative) clinical result as a numerical value. Those would be excluded. If you've got Crystal, you can always open the report and see their logic:
{VMU_DOCUMENT_PVID.Clinical_ID_Date} >= EMR_date_to_id({?startdate}) and
{VMU_DOCUMENT_PVID.Clinical_ID_Date} <= EMR_date_to_id({?enddate}+1) and
{VMU_DOCUMENT_PVID.PUBTIME} >= EMR_date_to_id({?startdate}) and
{VMU_DOCUMENT_PVID.PUBTIME} <= EMR_date_to_id({?enddate}+1) and
{VMU_DOCUMENT_PVID.STATUS} = 'S' and
{VMU_DOCUMENT_PVID.DOCTYPE} <> 24 and
{VMU_DOCUMENT_PVID.DOCTYPE} <> 30 and
{RPTOBS.CHANGE} =2 and
( {HIERGRPS.GROUPID} = 1103 OR {HIERGRPS.PARENTID} = 1103 OR {RPTOBS.HDID} = -1 ) and
(
LowerCase ({RPTOBS.OBSVALUE}) in ['positive', 'negative', 'pos', 'neg', 'y', 'n', 'yes', 'no', 'true', 'false', 't', 'f'] OR
NumericText ({RPTOBS.OBSVALUE})
) and
{LOCREG.LOCID} in {?Location} and
{USRINFO.JOBTITLE} = {?Job Title}
Posted : August 2, 2013 5:54 am
