Requested CCMDB changes for the next version: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 30: | Line 30: | ||
===== Exclude peer audit serials from regular tmp sending query ===== | ===== Exclude peer audit serials from regular tmp sending query ===== | ||
* '''Fix built as per [[Log]]. [[User:Ttenbergen|Ttenbergen]]'''[[User:Ttenbergen|Ttenbergen]] 11:35, 1 December 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) | * 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) | ||
Any tmp entries being sent immediately rather than upon finalcheck will send for audit as well. | Any tmp entries being sent immediately rather than upon finalcheck will send for audit as well. | ||
*Required Fix: fix the regular audit query to exclude serials < 111 and serials > '''140'''.--[[User:TOstryzniuk|TOstryzniuk]] 14:40, 30 November 2009 (CST) | *Required Fix: fix the regular audit query to exclude serials < 111 and serials > '''140'''.--[[User:TOstryzniuk|TOstryzniuk]] 14:40, 30 November 2009 (CST) | ||
* | The following are entry errors for which I can't think of a check. Suggestions anyone? | ||
*Missing MOVE date in [[TmpV2_1_ audit.mdb]] because audit file was sent with CSV batch. | |||
** sorry, still no idea what that means; was only the date missing? What does that have to do with the audit file being sent in csv batch? Are they not all sent in a csv batch? [[User:Ttenbergen|Ttenbergen]] 14:56, 30 November 2009 (CST) | |||
***A [[Peer Audit]] patient was sent with REGULAR batch of non [[Peer Audit]] files. It was not sent by itself. I suspect because it was not sent as an 'a' for audit batch by itself, that is why no move data made it into [[TmpV2_1_audit.mdb]].--[[User:TOstryzniuk|TOstryzniuk]] 18:50, 30 November 2009 (CST) | |||
**** I suspect this is another case of mixing audit patients into regular and vice versa. The queries should now take care of that. | |||
===== pending.mdb ===== | ===== pending.mdb ===== | ||