Requested CCMDB changes for the next version: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 23: | Line 23: | ||
==== Pending Testing / Answers ==== | ==== Pending Testing / Answers ==== | ||
==== wrong location ==== | ===== wrong location ===== | ||
*Collectors were able to send patients with R_Location <> audit_location | *Collectors were able to send patients with R_Location <> audit_location | ||
** added table "peer_audit_partners" and query "check_peer_audit_location_bad" to limit which patients can be sent as audits.[[User:Ttenbergen|Ttenbergen]] 11:18, 1 December 2009 (CST) | ** added table "peer_audit_partners" and query "check_peer_audit_location_bad" to limit which patients can be sent as audits.[[User:Ttenbergen|Ttenbergen]] 11:18, 1 December 2009 (CST) | ||
==== Pharmacy Check ==== | ===== Pharmacy Check ===== | ||
*pharmacy check for NO pharm not working in CCMDB. Email sent to Tina. | *pharmacy check for NO pharm not working in CCMDB. Email sent to Tina. | ||
** This happens because HSC doesn't collect Pharmacy and Trish and I both use HSC as the test location. If a different location is used, having no pharmacy entry will launch an error. See [[PharmCheck]]. Do you think that article should be linked into any of the collection instructions? Not really necessary since it will give proper errors, but up to you. [[User:Ttenbergen|Ttenbergen]] 15:51, 30 November 2009 (CST) | ** This happens because HSC doesn't collect Pharmacy and Trish and I both use HSC as the test location. If a different location is used, having no pharmacy entry will launch an error. See [[PharmCheck]]. Do you think that article should be linked into any of the collection instructions? Not really necessary since it will give proper errors, but up to you. [[User:Ttenbergen|Ttenbergen]] 15:51, 30 November 2009 (CST) | ||
==== Admit 1 missing ==== | ===== Admit 1 missing ===== | ||
*STB MICU was able sent a profile with the admit 1 diagnosis blank. We are not sure who she was able to achieve this. Email sent to Tina and also Laura. --[[User:TOstryzniuk|TOstryzniuk]] 20:35, 26 November 2009 (CST) | *STB MICU was able sent a profile with the admit 1 diagnosis blank. We are not sure who she was able to achieve this. Email sent to Tina and also Laura. --[[User:TOstryzniuk|TOstryzniuk]] 20:35, 26 November 2009 (CST) | ||
** Found out in troubleshooting that Laura had tried to send a non-infection diagnosis with a pathogen. Trish was trying to find out the story from Laura to see if we can replicate the problem. Waiting to hear details. [[User:Ttenbergen|Ttenbergen]] 10:22, 30 November 2009 (CST) | ** Found out in troubleshooting that Laura had tried to send a non-infection diagnosis with a pathogen. Trish was trying to find out the story from Laura to see if we can replicate the problem. Waiting to hear details. [[User:Ttenbergen|Ttenbergen]] 10:22, 30 November 2009 (CST) | ||
==== Exclude peer audit serials from regular tmp sending query ==== | ===== Exclude peer audit serials from regular tmp sending query ===== | ||
* There should not be any data in [[TmpV2_1.mdb]] for audit file 111 HSC_SICU. How did it get in there is really the question. --[[User:TOstryzniuk|TOstryzniuk]] 18:50, 30 November 2009 (CST) | * There should not be any data in [[TmpV2_1.mdb]] for audit file 111 HSC_SICU. How did it get in there is really the question. --[[User:TOstryzniuk|TOstryzniuk]] 18:50, 30 November 2009 (CST) | ||
** actually, I think I understand now and it should be fixed. [[User:Ttenbergen|Ttenbergen]] 11:32, 1 December 2009 (CST) | ** actually, I think I understand now and it should be fixed. [[User:Ttenbergen|Ttenbergen]] 11:32, 1 December 2009 (CST) | ||
| Line 42: | Line 42: | ||
* Fix built as per [[Log]]. [[User:Ttenbergen|Ttenbergen]] | * Fix built as per [[Log]]. [[User:Ttenbergen|Ttenbergen]] | ||
==== pending.mdb ==== | ===== pending.mdb ===== | ||
*Audit numbers should not go into pending.mdb--[[User:TOstryzniuk|TOstryzniuk]] 19:21, 26 November 2009 (CST) | *Audit numbers should not go into pending.mdb--[[User:TOstryzniuk|TOstryzniuk]] 19:21, 26 November 2009 (CST) | ||
* changed queries "pending_julie" and "pending_pagasa" to exclude audit serial numbers, see [[Log]] [[User:Ttenbergen|Ttenbergen]] 16:23, 30 November 2009 (CST) | * changed queries "pending_julie" and "pending_pagasa" to exclude audit serial numbers, see [[Log]] [[User:Ttenbergen|Ttenbergen]] 16:23, 30 November 2009 (CST) | ||