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: 154

	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
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
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 ACP Status Collection for LAU	implemented
Query check_Project_OT_PT_Consults	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
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
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 s tmp ACP	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