CCMDB.accdb Data Integrity Checks

This 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: 159

	Status	questions	who
Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days	declined
Query check ICD10 stroke	declined
Can't check ICD10 ARF vs APACHE ARF	declined
Query NDC Dialysis TISS CCI	declined
Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm	declined
Query check CCI TISS spont breath no tube	declined
Query check ICD10 Inf Potential Infection must have pathogen or alt	declined
Query check TISS each day	declined
Query TISS Errors NrTISSDays NE LOS	declined
Check pre acute consistent	declined	JALT Julie found data discrepancies and asked if we could review doing cross checks at least on records with the same Visit Admit DtTm for the following fields: Pre acute living situation Province field Postal Code We reviewed a broader cross check proposal (link below) in some detail in a version available in the history of this page], so if we consider adding this we should confirm that none of those apply to any checks. Or we can ignore and just implement as soft-checks. Thoughts? Ttenbergen 12:28, 17 December 2025 (CST)	all
Query check ICD10 duplicates	declined
Query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER	declined
Controlling Dx Type for ICD10 codes	declined
Query check CCI TISS time means must be two	declined
Query check CCI TISS CAM positive vs Dx	declined
Check APACHE physiological variable high low	implemented
Query check minimal data set incomplete	implemented
Function Validate Previous Location	implemented
Query check prev pre-admit consistent	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 Date	implemented
Query check CCI Component unfilled	implemented
Query check CCI Picklist unfilled	implemented
Query check CCI component 1 and 2 compatible	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 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 check ICD10 Comorbids NoComo code but others	implemented
Query check ICD10 Comorbids Dx present	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 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
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
Query check tmp service or location duplicate	implemented
Query check tmp service and program consistency	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 CCI TISS Vented without mechanism	implemented
Query check transfer DtTm during admission	implemented
Query check CCI TISS Pharm Vasoactive	implemented
Query s tmp check combined Boarding Loc and TransferReadyDtTm	implemented	This doesn't catch duplicate Transfer Ready DtTm tmp entry for Boarding Loc on incompletes. That is probably fine since we don't use the incompletes, but it could be added the next time the check is worked on anyway.	Tina
Query s tmp check Boarding Loc and TransferReadyDtTm pairs	implemented
Query check tmp Boarding Loc Service first same	implemented
Query check has transfer ready date or checkbox	implemented	This check doesn't seem to catch when a time is entered without a date. It would be good to update that. Don't have time right now, so leaving a note. Email exchange 2024-11-14. Ttenbergen 12:12, 2024 November 15 (CST)	Tina
Query Check Inf Pathogens must have Infection requiring pathogen or Potential Infection	implemented
Query check ICD10 awaiting has Transfer Ready DtTm	implemented
Query check eliminated ICD10	implemented
Query check eliminated CCI Pick	implemented
Query check eliminated CCI Comp	implemented
Query check tmp 2 BL TR S same tm	implemented
Query check tmp Service and Boarding Loc during admission timeframe	implemented
Query check pt from ER	implemented
Query check CCI ICD10 Dialysis no Dx	implemented
Query check CCI must have entry	implemented
Query check CCI vs LOS count days component	implemented
Query check CCI vs LOS count days picklist	implemented
Query check CCI TISS discontinuous ETT	implemented
Query check CCI TISS matching BoardingLoc time	implemented
Query s tmp Boarding Loc ER delay reasonable	implemented
Query Check BL TR combiner null	implemented
Query check no consecutive same BL or Service	implemented
Query check Transfer DtTm after paired BL and before later BL	implemented
Query check CCI Component no admin entries	implemented
Query check ICD10 trach has trach but no TISS	implemented
Query check ICD10 trach create but no TISS	implemented
Query check ICD10 CLI vs CCI CentralLine	implemented
Query check ICD10 trach dxs consistent	implemented
Query check_ICD10_ESRD_and_AKI_only_if_transplant	implemented
Query check tmp BedHeld	implemented
Query s tmp EuroSCORE II checks	implemented
Query check CCI Picklist if no admin entries	implemented
Query s_tmp_AHC_consistent	implemented
Query check LAU collection readmission data	implemented
query check_Project_Consults_data	implemented
Query check_Project_OT_PT_Consults	implemented
Function Validate DOB	implemented
Query check ACP Status Collection	implemented
Query check long transfer delay	needs review
Function long LOS()	needs review
Query check CCI each count vs LOS	needs review
Query s_tmp_MR	needs review
Query check_tmp_AHC	needs review	if there is referral sent there must be a referral received entry and a consult dealt with entryLisa 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? item must not be "not entered" I implemented this one and 40 records in my test data have a "not entered" in complete data. Did I misunderstand the instructions?	Lisa
Query check_tmp_Overstay2	needs review	others?	Julie
Query Check_VADT_too_close_to_first_boarding_loc	needs review	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) So this is also about Patients who appear to transfer from in-patient situation to Emergency Room, which would be checked by Query Check_from_ED_and_prev_location_same_site. If the patient is from anywhere else there would be no such thing as vadt being too close to first boarding loc, right? So what is this cut-off, then? Is it a hard check? SMW Cargo Categories 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) So this is also about Patients who appear to transfer from in-patient situation to Emergency Room, which would be checked by Query Check_from_ED_and_prev_location_same_site. If the patient is from anywhere else there would be no such thing as vadt being too close to first boarding loc, right? So what is this cut-off, then? Is it a hard check?	Julie Lisa
Check organ donors must be dead	not feasible
Query s tmp Borrow no borrow on own unit	not feasible
Query check ICD10 ESRD vs ARF	not feasible
Query Check_from_ED_and_prev_location_same_site	ready to implement
Check BRR/XBR vs cardiac arrest dx	retired
Check Function Panelling admit transfer same	retired
Query check ApARF CRF	retired
Query Check Renal IncompatibleDxs	retired
Query check trach dx task	retired
Query s tmp QAInf basic	retired
Query s tmp QAInf dx no tmp	retired
Query s tmp QAInf tmp no dx	retired
Query s tmp QAInf LT 48 hrs after admit	retired
Query check VAP admit must be from ICU	retired
Check eliminated dx	retired
Query check CCI CRRT vs Tmp	retired
Query s tmp Borrow sensible DtTm vs no borrow	retired
Query s tmp Borrow duplicates	retired
Query check overstay not entered	retired
Query check overstay pt from our med	retired
Query check overstay no colour	retired
Query check dispo lower acuity than location	retired
Function Transfer Ready DtTm vs status	retired
Function Validate Transfer Ready DtTm	retired
Query check transfer ready tmp for each Boarding Loc	retired
Query s tmp Boarding Loc no borrow but entry	retired
Query check tmp Transfer Ready not before Boarding Loc	retired
Query s tmp IICU consult DtTm	retired
Check Accept Loc Park	retired
Check AcceptDtTm entered or missing checked	retired
Function Dispo Chronological()	retired
Query s tmp check combined BL and TRDtTm nonsequential	retired
Function Validate previous service	retired
Query check previous location vs service inconsistent	retired
Query s tmp comfort care gt one	retired