| edit | Function long LOS() | CCMDB.accdb | needs review | complete | soft check | LOS/Length of Stay should not be unlikely long based on historical LOS for a given ward (Service/Location field). | | |
| edit | Query check CCI each count vs LOS | CCMDB.accdb | needs review | complete | soft check | Confirm that a Category:Labs Imaging count is not unreasonably high | | |
| edit | Query check long transfer delay | CCMDB.accdb | needs review | always | soft check | Is the Transfer Delay (Critical Care) or Transfer Delay (Medicine) unreasonably long? | | |
| edit | Query Import request matcher | DSM Labs Consistency check.accdb | needs review | always | not entered | Records in for which we have patients in L_Log but no lab records from DSM | | |
| edit | Query s tmp MR | CCMDB.accdb | needs review | complete | hard check | Checks for Project MR | | |
| edit | Query check tmp AHC | CCMDB.accdb | needs review | complete | hard check | For patients with Previous Location ER at same site there should be a Boarding Loc ER. |
- I implemented 'item must not be "not entered" and 40 records in the data I had at the time a "not entered" in complete data. Did I misunderstand the instructions? Or are these correct instructions and should be implemented as that?
| Lisa |
| edit | Query Check VADT too close to first boarding loc | CCMDB.accdb | needs review | always | soft check | no idea hope JM or LK remember |
|
We discussed this in our after-Task meeting 2023-07-23 and I just stumbled across it. I do not remember what this was about, nor what a reasonable delay would be. Could one of you fill in the details for the query if we still want it? No hurry. In fact I'd prefer if you not hurried ;-). Ttenbergen 21:38, 13 August 2025 (CDT)
- this came about when the Pre-admit Inpatient Institution location is own site and previous location is own ER and the VADT is too close to first boarding loc dttm. If I remember correctly you mentioned 6 hours (0.25d) gap as maybe entry error on the preadmit inpt. Is 12 hours (0.50d) reasonable? --JMojica 09:23, 14 August 2025 (CDT)
| | Lisa |
| edit | Query check tmp AHC | CCMDB.accdb | needs review | complete | hard check | For patients with Previous Location ER at same site there should be a Boarding Loc ER. | JALT
- if there is referral sent there must be a referral received entry and a consult dealt with entry Lisa Kaita 11:31, 7 August 2025 (CDT)
- pt could die in between? consult could go missing? In a way those would be really the ones we would want to know about, no? I suppose we could make it a soft check... Ttenbergen 16:26, 19 August 2025 (CDT)
- this almost sounds like the opposite of how I would have understood the current instructions. I would have thought those to mean to only enter "consult received" if there was no good data for consult sent. How do we actually want to use this?
- late answer: how did Julie analyze this? at the time all fields were mandatory, unless there was no consult, current status, collect consult sent and if no data found for this then use consult received. Lisa Kaita 12:59, 13 January 2026 (CST)
- I don't know, flagging for Julie and putting this on the JALT agenda; collection is still going, so we may still want to implement this. Ttenbergen 14:58, 13 January 2026 (CST)
| Julie |
| edit | Query check tmp Overstay2 | CCMDB.accdb | needs review | complete | hard check | Not yet filled in | others? | Julie |
| edit | Query Check VADT too close to first boarding loc | CCMDB.accdb | needs review | always | soft check | no idea hope JM or LK remember | We discussed this in our after-Task meeting 2023-07-23 and I just stumbled across it. I do not remember what this was about, nor what a reasonable delay would be. Could one of you fill in the details for the query if we still want it? No hurry. In fact I'd prefer if you not hurried ;-). Ttenbergen 21:38, 13 August 2025 (CDT)
this came about when the Pre-admit Inpatient Institution location is own site and previous location is own ER and the VADT is too close to first boarding loc dttm. If I remember correctly you mentioned 6 hours (0.25d) gap as maybe entry error on the preadmit inpt. Is 12 hours (0.50d) reasonable? --JMojica 09:23, 14 August 2025 (CDT)
| Julie |