CCMDB.accdb Data Integrity Checks
From CCMDB Wiki
Jump to navigationJump to searchThis page lists pages that have CCMDB Data Integrity Checks on them, the status of those checks if available, and the page's last modification date.
See Template:Data Integrity Check for how to get things on this list.
CCMDB Data Integrity Checks (SMW)
Current number of CCMDB.accdb Data Integrity Checks: 99
Status | questions | who | |
---|---|---|---|
Check APACHE physiological variable high low | implemented | ||
Query check minimal data set incomplete | implemented | ||
Function Validate Previous Location | implemented | ||
Query check previous location vs service inconsistent | implemented | ||
Query check prev pre-admit consistent | implemented | ||
Function Validate previous service | implemented | ||
Query s tmp project item consistent | implemented | ||
Query s tmp apostrophe in comment | implemented | ||
Function Validate PHIN | implemented | ||
Function PHIN same as Chart | implemented | ||
Function Validate Province | implemented | ||
Date of Birth | implemented | ||
Function Validate Dispo | implemented | ||
Query check dx primary not exactly one | implemented | ||
Query check dx primary lowest priority | implemented | ||
Query check ICD10 date | implemented | ||
Query check ICD10 unfilled | implemented | ||
Query check CCI no admin entries | implemented | ||
Query check CCI Date | implemented | ||
Query check CCI Component unfilled | implemented | ||
Query check CCI Picklist unfilled | implemented | ||
Query check CCI component 1 and 2 compatible | implemented | ||
Check AcceptDtTm entered or missing checked | implemented | ||
Check Function Validate PostalCode | implemented | ||
Check function Validate Last name | implemented | ||
Check function Validate First name | implemented | ||
Check function location NE dispo | implemented | ||
Check function previous NE Location | implemented | ||
Check Accept Loc Park | implemented | ||
Check Sub PharmCheck | implemented | ||
Check duplicate patient | implemented | ||
Check function Validate Pre Acute Living Situation | implemented | ||
Query check cooling vs arrest | implemented | ||
Query check hernia type vs complication | implemented | ||
Query check AIDS vs HIV | implemented | ||
Query s tmp QASeptic tmp no dx | implemented | ||
Query s tmp IICU consult DtTm | implemented | ||
Query check ICD10 Comorbids NoComo code but others | implemented | ||
Query check ICD10 Comorbids Dx present | implemented | ||
Check Inf Pathogens must have Infection requiring pathogen or Potential Infection | implemented | ||
Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogen | implemented | ||
Check Inf Infection with implied pathogen must not have a pathogen combined code | implemented | ||
Function Validate Chart | implemented | ||
Sub Dx Checker | implemented | ||
Query check ICD10 ESRD vs kidney transplant | implemented | ||
Function Validate Pre admit Inpatient Institution | implemented | ||
Query check CCI Picklist duplicates | implemented | ||
Query check CCI Component duplicates | implemented | ||
Query s tmp QASeptic Dx no tmp ICD10 | implemented | ||
Query s tmp comfort care gt one | implemented | ||
Query s tmp ABO TEE checks | implemented | ||
Check function preAdmit NE Location | implemented | ||
Query s tmp IICU consult dispo to IICU but no tmp | implemented | ||
Query send check centralized is owner | implemented | ||
Function Dispo Chronological() | implemented | ||
Query check ICD10 mechanism vs trauma | implemented | ||
Query check ICD10 Inf Infection req Pathogen must have one | implemented | ||
Query check ICD10 only 1 stage of renal failure | implemented | ||
Query check ICD10 chronic vent acute resp failure | implemented | ||
Query check CCI from OR no CCI | implemented | ||
Query check tmp generate allowed | implemented | ||
Query s tmp Boarding Loc date item | implemented |
| Julie |
Query s tmp Boarding Loc no borrow but entry | implemented | ||
Query check tmp service or location duplicate | implemented | ||
Query check tmp service and program consistency | implemented | ||
Query check tmp ER Boarding Loc should exist if from ER | implemented | ||
Query check CCI if no then none | implemented | ||
Query check CCI TISS NrDays GT LOS | implemented | ||
Query check CCI TISS NrDays LT LOS | implemented | ||
Query check CCI TISS if no then none | implemented | ||
Query check ICD10 dx implying death must have appropriate dispo | implemented | ||
Query check CCI TISS Intubation vs Intubated | implemented | ||
Query check ICD10 awaiting has Transfer Ready DtTm | implemented | ||
Query check CCI TISS Vented without mechanism | implemented | ||
Query check transfer DtTm during admission | implemented | ||
Query check CCI TISS Pharm Vasoactive | implemented | ||
Query check ICD10 Inf Potential Infection must have pathogen or alt | implemented |
| Task |
Query s tmp check combined Boarding Loc and TransferReadyDtTm | implemented | ||
Query query s tmp check Boarding Loc and TransferReadyDtTm pairs | implemented | ||
Query check long transfer delay | needs review |
| Julie |
Controlling Dx Type for ICD10 codes | needs review | Como Admit Acquired Primary Limits 1/ Dx grouping - this is part of both of those discussion
| Allan |
Check pre acute consistent | needs review | what exactly do we want to check for? Please also have a look at the stuff below that doesn't specifically have your name. This requested check ties into a bunch of things and if we want the check we need to be sure that instructions stay consistent and lose ends are tied up. Integrity check
How does Chronic Health Facility fit into this? Or Imprisonment/incarceration and other info in Prison / Jail / Correctional Institution? There was talk about comparing Postal Codes to known PCH Postal Codes. Since these might include other buildings at the same site that are not PCHs, this check can at best be a soft check. Please add the list of these postal codes here. | Julie |
Check ICD10 some cant be primary | needs review | Como Admit Acquired Primary Limits - Category:Mechanism would need to be excluded as well, and so would past history, and quickly the list gets so large again that we are back at discussing Controlling Dx Type for ICD10 codes where we should simply include "Primary"-ability.
| Allan |
Query check CCI must have entry | needs review |
| Pagasa |
Query check ICD10 duplicates | needs review | ||
Query TISS Errors ETT consistent | needs review |
| Julie |
Check CCI CXR vs LOS | needs review | would we not use Accept DtTm here? Because we could have CXRs on days before arrival... | Julie |
Query check ER Delay not too big | needs review | ||
Query check ICD10 trach dxs consistent | needs review | ||
Query TISS Errors NrTISSDays NE LOS | needs review | Is this check actually needed?
| all |
Query NDC Dxs vs TISS Dialysis | needs review | Would we need to add COVID to this before implementing? | all |
Function long LOS() | needs review | Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry changed Service/Location to aggregate values for the whole stay in a program. The values used in s_dispo table for the longest likely LOS were filled with previous entries from the same program, but should likely be longer now, since an aggregate stay would on average be longer. Once we have some data with the new aggregate model we should update these values. | Julie |
Query check tmp Service and Boarding Loc during admission timeframe | needs review |
| all |
Query TISS Errors CAM positive vs Dx | needs review | AJTT
| Task |
Query check has service entry | needs review |
| Julie |
Query NDC Trach Dx TISS | needs review | ||
Query check has transfer ready date or checkbox | needs review |
| Task |
Query NDC cardioversion dx vs TISS | needs review |
| Task |
Query NDC CLI vs DX but no TISS17 CentralLine | needs review |
| all |
Click here to see all checks including retired and declined ones