Cross checks that need review
Current number of Data Integrity Checks: 5
| check summary | question | app |
---|
Function long LOS() | LOS/Length of Stay should not be unlikely long based on historical LOS for a given ward (Service/Location field). | | CCMDB.accdb |
Query Import request matcher | Records in for which we have patients in L_Log but no lab records from DSM | | DSM Labs Consistency check.accdb |
Query cardiac arrest throughout admission | Any patient who is admitted to ICU from Med or another ICU with a #Cardiac Arrest dx should have one in their immediately preceeding Med or ICU record also. | JALT Review after 2023-09-15
- Lisa flagged that, if we do this for Cardiac Arrest, we should really do it for other dxs as well. And if we did that, it could result in a lot of work since it would need to be mediated by Pagasa for now. So we decided to see where the SF implementation goes and review the definition of this check once we have a centralized tool where the data collector would not need to mediate this. Ttenbergen 15:43, 2023 July 13 (CDT)
| Centralized data front end.accdb |
Query check CCI CXR vs LOS | Confirm that a Category:Labs Imaging count is not unreasonably high |
Just came across this... the started query includes additional dxs now, as per #CCI collect count each. Does the proposed accepted count make sense for all the dxs? Your validation table was for CXR. Ttenbergen 11:50, 2023 May 3 (CDT)
- Did some checking on all 13 LAB Imaging from CCI picklist and found counts more than the LOS only in ECHO, AXR and CXR. Emailed Lisa and Pagasa March 14, 2024 to check if correct or not. Waiting for their feedbacks. In the email, I also propose another query (e.g. the counts per calendar day per patient must not be more than one) as alternative to the threshold limits LOS +- 3 STD shown below. --JMojica 10:55, 2024 March 18 (CDT)
- That query is tighter and would therefore have more false positives. What does Lisa think about that? Ttenbergen 09:51, 2024 March 20 (CDT)
- I made some limits per LOS group for CXR, AXR, ECHO and Blood gases and emailed the results to Tina and Lisa 3/25/2024 for discussion. ---JMojica 13:28, 2024 March 25 (CDT)
- Further emails with Julie and Lisa about details. Discussed with Lisa who is reviewing some of the errors and will hold off until she is done. Ttenbergen 12:46, 2024 April 8 (CDT)
| CCMDB.accdb |
Query check long transfer delay | Is the Transfer Delay (Critical Care) or Transfer Delay (Medicine) unreasonably long? | | CCMDB.accdb |