CCMDB Wiki

Data Integrity Checks

Revision as of 10:55, 25 October 2018 by Ttenbergen (talk | contribs) (→unreviewed)

The Critical Care and Medicine Database has many data integrity checks built into our data collection process. This page is an index to our documentation for those.

We try to run the checks as early in the collection process as possible:

  1. CCMDB Data Integrity Checks - run in CCMDB.mdb and notify Data Collector during the collection process
  2. CFE Data Integrity Checks - run in Centralized data front end.accdb as part of the Data Processor's job
  3. SAS Data Integrity Checks - run in SAS as part of the Statistician's final clean up of the data before any reports or data requests are released

Template:Data Integrity Check is used to consistently document the checks so they populate our lists appropriately.

Template:Discussion We should review Category:Multiple encounter longitudinal consistency check while working this out. Ttenbergen 18:36, 2018 August 16 (CDT)

SMW List

using Template:Data Integrity Check, being applied to checks as I review them for move to ICD10/CCI.

 StatusApp
Query NDC VAP no TISSdeclinedCentralized data front end.accdb
Check CRF vs ARF across multiple encountersdeclinedCentralized data front end.accdb
Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff daysdeclinedCCMDB.accdb
Query check ICD10 strokedeclinedCCMDB.accdb
Can't check ICD10 ARF vs APACHE ARFdeclinedCCMDB.accdb
Query NDC Dialysis TISS CCIdeclinedCCMDB.accdb
Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTmdeclinedCCMDB.accdb
Query check CCI TISS spont breath no tubedeclinedCCMDB.accdb
Query check ICD10 Inf Potential Infection must have pathogen or altdeclinedCCMDB.accdb
Query check TISS each daydeclinedCCMDB.accdb
Query TISS Errors NrTISSDays NE LOSdeclinedCCMDB.accdb
Check VAP acquired only first encounterdeclinedCentralized data front end.accdb
Check pre acute consistentdeclinedCCMDB.accdb
Query check ICD10 duplicatesdeclinedCCMDB.accdb
Query check_tmp_ER_Boarding_Loc_should_exist_if_from_ERdeclinedCCMDB.accdb
Controlling Dx Type for ICD10 codesdeclinedCCMDB.accdb
Query check CCI TISS time means must be twodeclinedCCMDB.accdb
Query check CCI TISS CAM positive vs DxdeclinedCCMDB.accdb
Check APACHE physiological variable high lowimplementedCCMDB.accdb
Query check minimal data set incompleteimplementedCCMDB.accdb
Function Validate Previous LocationimplementedCCMDB.accdb
Query check prev pre-admit consistentimplementedCCMDB.accdb
query s_tmp_project_item_consistentimplementedCCMDB.accdb
Query s tmp apostrophe in commentimplementedCCMDB.accdb
Function Validate PHINimplementedCCMDB.accdb
Function PHIN same as ChartimplementedCCMDB.accdb
Function Validate ProvinceimplementedCCMDB.accdb
Date of BirthimplementedCCMDB.accdb
Function Validate DispoimplementedCCMDB.accdb
Query check dx primary not exactly oneimplementedCCMDB.accdb
Query check dx primary lowest priorityimplementedCCMDB.accdb
Query check ICD10 dateimplementedCCMDB.accdb
Query check ICD10 unfilledimplementedCCMDB.accdb
Query check CCI DateimplementedCCMDB.accdb
Query check CCI Component unfilledimplementedCCMDB.accdb
Query check CCI Picklist unfilledimplementedCCMDB.accdb
Query check CCI component 1 and 2 compatibleimplementedCCMDB.accdb
Check Function Validate PostalCodeimplementedCCMDB.accdb
Check function Validate Last nameimplementedCCMDB.accdb
Check function Validate First nameimplementedCCMDB.accdb
Check function location NE dispoimplementedCCMDB.accdb
Check function previous NE LocationimplementedCCMDB.accdb
Check Sub PharmCheckimplementedCCMDB.accdb
Check duplicate patientimplementedCCMDB.accdb
PL SameCHART Site Diff PHINimplementedCentralized data front end.accdb
PL SamePHIN Site Diff chartimplementedCentralized data front end.accdb
Link suspect negative transit time queryimplementedCentralized data front end.accdb
Link suspect dead then alive queryimplementedCentralized data front end.accdb
Link suspect mismatch from ours incomplete queryimplementedCentralized data front end.accdb
Link suspect mismatch to ours incomplete queryimplementedCentralized data front end.accdb
Check function Validate Pre Acute Living SituationimplementedCCMDB.accdb
Link_suspect_not_same_visitAdmitDtTm queryimplementedCentralized data front end.accdb
Query check cooling vs arrestimplementedCCMDB.accdb
Query check hernia type vs complicationimplementedCCMDB.accdb
Query check AIDS vs HIVimplementedCCMDB.accdb
Query s tmp QASeptic tmp no dximplementedCCMDB.accdb
PL Chart 9 DigitimplementedCentralized data front end.accdb
Query check ICD10 Comorbids NoComo code but othersimplementedCCMDB.accdb
Query check ICD10 Comorbids Dx presentimplementedCCMDB.accdb
Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogenimplementedCCMDB.accdb
Check Inf Infection with implied pathogen must not have a pathogen combined codeimplementedCCMDB.accdb
Function Validate ChartimplementedCCMDB.accdb
Sub Dx CheckerimplementedCCMDB.accdb
Query check_ICD10_ESRD_vs_kidney_transplantimplementedCCMDB.accdb
Function Validate Pre admit Inpatient InstitutionimplementedCCMDB.accdb
Query check CCI Picklist duplicatesimplementedCCMDB.accdb
Query check CCI Component duplicatesimplementedCCMDB.accdb
Query s tmp QASeptic Dx no tmp ICD10implementedCCMDB.accdb
Query s tmp ABO TEE checksimplementedCCMDB.accdb
Link suspect mismatch pre inpt ours incomplete queryimplementedCentralized data front end.accdb
Check function preAdmit NE LocationimplementedCCMDB.accdb
Query s tmp IICU consult dispo to IICU but no tmpimplementedCCMDB.accdb
Query NDC Bad Postal CodeimplementedCentralized data front end.accdb
Query send check centralized is ownerimplementedCCMDB.accdb
Query check ICD10 mechanism vs traumaimplementedCCMDB.accdb
Query check ICD10 Inf Infection req Pathogen must have oneimplementedCCMDB.accdb
Query check ICD10 only 1 stage of renal failureimplementedCCMDB.accdb
Query check ICD10 chronic vent acute resp failureimplementedCCMDB.accdb
Query check CCI from OR no CCIimplementedCCMDB.accdb
Query NDC Postal Code over timeimplementedCentralized data front end.accdb
Query check tmp generate allowedimplementedCCMDB.accdb
Query s tmp Boarding Loc date itemimplementedCCMDB.accdb
PL SamePhin Diff DOB SeximplementedCentralized data front end.accdb
Query check tmp service or location duplicateimplementedCCMDB.accdb
Query check tmp service and program consistencyimplementedCCMDB.accdb
Query check CCI if no then noneimplementedCCMDB.accdb
Query check CCI TISS NrDays GT LOSimplementedCCMDB.accdb
Query check CCI TISS NrDays LT LOSimplementedCCMDB.accdb
Query check CCI TISS if no then noneimplementedCCMDB.accdb
Query check ICD10 dx implying death must have appropriate dispoimplementedCCMDB.accdb
Query check CCI TISS Intubation vs IntubatedimplementedCCMDB.accdb
Query check CCI TISS Vented without mechanismimplementedCCMDB.accdb
Query check transfer DtTm during admissionimplementedCCMDB.accdb
Query check CCI TISS Pharm VasoactiveimplementedCCMDB.accdb
Query s tmp check combined Boarding Loc and TransferReadyDtTmimplementedCCMDB.accdb
Query s tmp check Boarding Loc and TransferReadyDtTm pairsimplementedCCMDB.accdb
Query check tmp Boarding Loc Service first sameimplementedCCMDB.accdb
Query check has transfer ready date or checkboximplementedCCMDB.accdb
Query Check Inf Pathogens must have Infection requiring pathogen or Potential InfectionimplementedCCMDB.accdb
Query check ICD10 awaiting has Transfer Ready DtTmimplementedCCMDB.accdb
PL 2Phin Fake or BlankimplementedCentralized data front end.accdb
Query check eliminated ICD10implementedCCMDB.accdb
Query check eliminated CCI PickimplementedCCMDB.accdb
Query check eliminated CCI CompimplementedCCMDB.accdb
Query check tmp 2 BL TR S same tmimplementedCCMDB.accdb
Query check tmp Service and Boarding Loc during admission timeframeimplementedCCMDB.accdb
Query check pt from ERimplementedCCMDB.accdb
Query check CCI ICD10 Dialysis no DximplementedCCMDB.accdb
Query check CCI must have entryimplementedCCMDB.accdb
Query check CCI vs LOS count days componentimplementedCCMDB.accdb
Query check CCI vs LOS count days picklistimplementedCCMDB.accdb
Query check CCI TISS discontinuous ETTimplementedCCMDB.accdb
Query check CCI TISS matching BoardingLoc timeimplementedCCMDB.accdb
Link suspect mismatch pre inpt should be ours incomplete queryimplementedCentralized data front end.accdb
Reconnect check orphans queryimplementedCentralized data front end.accdb
Reconnect check missing L Tables content queryimplementedCentralized data front end.accdb
Reconnect check Completes queryimplementedCentralized data front end.accdb
Query s tmp Boarding Loc ER delay reasonableimplementedCCMDB.accdb
Query NDC dx implying death across encountersimplementedCentralized data front end.accdb
Query Check BL TR combiner nullimplementedCCMDB.accdb
Query check no consecutive same BL or ServiceimplementedCCMDB.accdb
Query check Transfer DtTm after paired BL and before later BLimplementedCCMDB.accdb
Query check CCI Component no admin entriesimplementedCCMDB.accdb
Query check ICD10 trach has trach but no TISSimplementedCCMDB.accdb
Query check ICD10 trach create but no TISSimplementedCCMDB.accdb
Query check ICD10 CLI vs CCI CentralLineimplementedCCMDB.accdb
Query check ICD10 trach dxs consistentimplementedCCMDB.accdb
Query check_ICD10_ESRD_and_AKI_only_if_transplantimplementedCCMDB.accdb
Query check tmp BedHeldimplementedCCMDB.accdb
Query s tmp EuroSCORE II checksimplementedCCMDB.accdb
Query check CCI Picklist if no admin entriesimplementedCCMDB.accdb
Query s_tmp_AHC_consistentimplementedCCMDB.accdb
Query check LAU collection readmission dataimplementedCCMDB.accdb
query check_Project_Consults_dataimplementedCCMDB.accdb
Query check_Project_OT_PT_ConsultsimplementedCCMDB.accdb
Function Validate DOBimplementedCCMDB.accdb
Query check ACP Status CollectionimplementedCCMDB.accdb
PL DiffPhin SameLN FN DOBimplementedCentralized data front end.accdb
Query check long transfer delayneeds reviewCCMDB.accdb
Query Import request matcherneeds reviewDSM Labs Consistency check.accdb
Function long LOS()needs reviewCCMDB.accdb
Query check CCI each count vs LOSneeds reviewCCMDB.accdb
Query s_tmp_MRneeds reviewCCMDB.accdb
Query check_tmp_AHCneeds reviewCCMDB.accdb
Query check_tmp_Overstay2needs reviewCCMDB.accdb
Query Check_VADT_too_close_to_first_boarding_locneeds reviewCCMDB.accdb
Check organ donors must be deadnot feasibleCCMDB.accdb
Query s tmp Borrow no borrow on own unitnot feasibleCCMDB.accdb
Query check ICD10 ESRD vs ARFnot feasibleCCMDB.accdb
Link_suspect_visitAdmitDtTm_mult_to-from-home queryready to implementCentralized data front end.accdb
Query cardiac arrest throughout admissionready to implementCentralized data front end.accdb
Query Check_from_ED_and_prev_location_same_siteready to implementCCMDB.accdb
Check BRR/XBR vs cardiac arrest dxretiredCCMDB.accdb
Check Function Panelling admit transfer sameretiredCCMDB.accdb
Query check ApARF CRFretiredCCMDB.accdb
Query Check Renal IncompatibleDxsretiredCCMDB.accdb
Query check trach dx taskretiredCCMDB.accdb
Query s tmp QAInf basicretiredCCMDB.accdb
Query s tmp QAInf dx no tmpretiredCCMDB.accdb
Query s tmp QAInf tmp no dxretiredCCMDB.accdb
Query s tmp QAInf LT 48 hrs after admitretiredCCMDB.accdb
Query check VAP admit must be from ICUretiredCCMDB.accdb
Query NDC VAP unacceptable dateretiredCentralized data front end.accdb
Query NDC VAP AcqDX but NoVAP DateinTMPV2retiredCentralized data front end.accdb
Query NDC VAP No AcqDX but VAP DateinTMPV2retiredCentralized data front end.accdb
Check eliminated dxretiredCCMDB.accdb
Query NDC zCRRT TISS no tmpretiredCentralized data front end.accdb
Query NDC zCRRT tmp no TISSretiredCentralized data front end.accdb
Query check CCI CRRT vs TmpretiredCCMDB.accdb
Query NDC CLI unacceptable dateretiredCentralized data front end.accdb
Query s tmp Borrow sensible DtTm vs no borrowretiredCCMDB.accdb
Query s tmp Borrow duplicatesretiredCCMDB.accdb
Query check overstay not enteredretiredCCMDB.accdb
Query check overstay pt from our medretiredCCMDB.accdb
Query check overstay no colourretiredCCMDB.accdb
Query check dispo lower acuity than locationretiredCCMDB.accdb
Query check ICD10 ESRD vs AP ARFretirednot entered
Function Transfer Ready DtTm vs statusretiredCCMDB.accdb
Function Validate Transfer Ready DtTmretiredCCMDB.accdb
Query TISS Errors vent vs vent2300retiredCentralized data front end.accdb
Query TISS Errors CVC vs CVC2300retiredTISS28.accdb
Query TISS Errors BIPAP vs BIPAP2300retiredTISS28.accdb
Query TISS Errors D ID not in CFEretiredTISS28.accdb
Query NDC TISS CCI endoscopicretiredCentralized data front end.accdb
Query NDC zCRRT CCI Px but no TISSretiredCentralized data front end.accdb
Query NDC zCRRT TISS but no CCI PxretiredCentralized data front end.accdb
Query TISS Errors TISS date out of admissionretiredTISS28.accdb
Query TISS Errors duplicate ItemsretiredTISS28.accdb
Link suspect transfer ready greater than disporetiredCentralized data front end.accdb
Link suspect transfer ready before arrive dateretiredCentralized data front end.accdb
Query TISS Errors missing daysretiredTISS28.accdb
Query check transfer ready tmp for each Boarding LocretiredCCMDB.accdb
Query NDC Trach Dx TISSretiredCentralized data front end.accdb
Query s tmp Boarding Loc no borrow but entryretiredCCMDB.accdb
Query check tmp Transfer Ready not before Boarding LocretiredCCMDB.accdb
Query NDC Pacemaker acquired vs TISSretiredCentralized data front end.accdb
Query NDC cardioversion dx vs TISSretiredCentralized data front end.accdb
Query check CCI InExtubation consistentretiredCentralized data front end.accdb
Query s tmp IICU consult DtTmretiredCCMDB.accdb
Check Accept Loc ParkretiredCCMDB.accdb
Check AcceptDtTm entered or missing checkedretiredCCMDB.accdb
Function Dispo Chronological()retiredCCMDB.accdb
Query s tmp check combined BL and TRDtTm nonsequentialretiredCCMDB.accdb
Function Validate previous serviceretiredCCMDB.accdb
Query check previous location vs service inconsistentretiredCCMDB.accdb
Query s tmp comfort care gt oneretiredCCMDB.accdb

unreviewed

 StatusAppModification date"Modification date" is a predefined property that corresponds to the date of the last modification of a subject and is provided by Semantic MediaWiki.
Query check long transfer delayneeds reviewCCMDB.accdb30 July 2025 16:55:46
Query Import request matcherneeds reviewDSM Labs Consistency check.accdb23 July 2025 04:13:24
Function long LOS()needs reviewCCMDB.accdb7 October 2025 20:44:20
Query check CCI each count vs LOSneeds reviewCCMDB.accdb24 April 2024 21:50:11
Query s_tmp_MRneeds reviewCCMDB.accdb18 March 2025 16:13:46
Query check_tmp_AHCneeds reviewCCMDB.accdb22 November 2025 07:08:26
Query check_tmp_Overstay2needs reviewCCMDB.accdb7 August 2025 16:32:42
Query Check_VADT_too_close_to_first_boarding_locneeds reviewCCMDB.accdb19 August 2025 22:10:00
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Data_Integrity_Checks&oldid=121943"