Data Integrity Checks

From CCMDB Wiki
Jump to navigationJump to search

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.mdb 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

Documenting a new cross check

  • search the wiki to see if this already exists
  • if not, make a new page with a self-explanatory name that follows any conventions we might use
  • add
    {{Data Integrity Check}}
    at the top of the page and save
  • click the "edit with form" tab at the top of the page to edit the Data Integrity Checks with a helpful form

List of Data Integrity Checks (SMW)

Current number of Data Integrity Checks: 155

|?DICRelatedConcepts = Related concepts
 SummaryStatusAppCategory
Minimum combined codesSome ICD10s must always be coded as Combined ICD10 codes with at least a certain number of other codes.declinedCCMDB.mdbLegacy Content
CCMDB.mdb
Data Integrity Checks
Query NDC VAP no TISSIf a patient has a Acquired Diagnosis Pneumonia, ventilator-associated (VAP) and no TISS28 items T16 - Invasive Mechanical Ventilation (TISS Item) (T18) then this is an error.declinedCentralized data front end.accdbCentralized data front end.accdb
VAP - Ventilator Associated Pneumonia
TISS28 checks
Questions
Data Processing
Data Integrity Checks
Check APACHE physiological variable high lowan APACHE physiological variable is extremely high or lowimplementedCCMDB.mdbAPACHE check
CCMDB.mdb
Data Integrity Checks
APACHE II Physiological Variables
Function long LOS()LOS/Length of Stay should not be unlikely long based on historical LOS for a given ward (Service/Location field).implementedCCMDB.mdbSite/Location check
Registry checks
CCMDB.mdb
Data Integrity Checks
Length of stay
2016 Time and Place changes
Query check minimal data set incompletemakes sure the Minimal Data Set is collected before records can be sent.implementedCCMDB.mdbRegistry checks
CCMDB.mdb
Data Integrity Checks
Query check overstay no colourMed pts must have Overstay coloursimplementedCCMDB.mdbTmp check
CCMDB.mdb
Data Integrity Checks
OverstayProject
Query check overstay pt from our medpts from a location where we collect should not have Overstay colourimplementedCCMDB.mdbTmp check
CCMDB.mdb
Data Integrity Checks
OverstayProject
Function Validate Previous Locationvalidates Previous Location field: implementedCCMDB.mdbRegistry checks
CCMDB.mdb
Data Integrity Checks
Query check previous location vs service inconsistentpatients with Previous Location field in medicine must have Previous Service field medicine; ICU (except STB ACCU, STB CICU/ICCS) must have previous service "critical care".implementedCCMDB.mdbRegistry checks
CCMDB.mdb
Data Integrity Checks
Query check prev pre-admit consistentfor inpatient transfers within the region, Previous Location field and Pre-admit Inpatient Institution field should be same.implementedCCMDB.mdbRegistry checks
CCMDB.mdb
Data Integrity Checks
Function Validate previous serviceValidates Previous Service field: can't be empty/blankimplementedCCMDB.mdbRegistry checks
CCMDB.mdb
Data Integrity Checks
Query check tmp generate allowedcheck that tmp project/item combo exists for this location in OverstayimplementedCCMDB.mdbTmp check
CCMDB.mdb
Data Integrity Checks
OverstayProject
Query s tmp project item consistentChecks that tmp project entries only contain combinations of project and item that are allowed.implementedCCMDB.mdbTmp check
CCMDB.mdb
Data Integrity Checks
TmpV2
Query s tmp apostrophe in commentThere must not be apostrophes in the comment field as they would mess with Julie's data analysis.implementedCCMDB.mdbTmp check
CCMDB.mdb
Data Integrity Checks
Function Validate PHIN
  • for patients with Province = MB, the PHIN has to be (> 100 000 000 and <= 130 000 000) or 999 999 999 (to accommodate PHIN_field#Location_Manitoba_and_no_PHIN
  • for out-of-province patients, the PHIN must be entered as blank
  • checks Function PHIN same as Chart
  • implementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    Function PHIN same as ChartPHIN can't be the same as ChartimplementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    Function Validate ProvinceValidates the Province field: implementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    Date of BirthThe minimum age allowed is 10, the maximum age allowed is 120.implementedCCMDB.mdbL Log table
    L PHI table
    CCMDB.mdb cross checks triggering for correct values
    Registry checks
    Data structure
    CCMDB.mdb
    Data Collection Guide
    Data Integrity Checks
    Registry Data
    Demographics
    Function Validate Dispodoesn't allow emptyimplementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    Function Validate Transfer Ready DtTmdoesn't allow violation of function Transfer_Ready_DtTm_vs_statusimplementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    Function Transfer Ready DtTm vs statusIf Transfer_Ready_DtTm is blank, TR_info_status must not be; if TR_info_status has content, Transfer_Ready_DtTm must be blank.implementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    Query TISS Errors NrTISSDays NE LOSLength of stay (LOS) for all ICU patients must be consistent with their number of TISS days, incl no TISS days at all (ie missing forms).implementedTISS28.mdbTISS28 checks
    Registry checks
    TISS28.mdb
    TISS28 Scanning Process
    Questions
    Data Processing
    Data Integrity Checks
    Length of stay
    Query check dx primary not exactly oneThere has to be exactly one dx per patient with Dx Primary checked, and it has to be an Admit DiagnosisimplementedCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    Query check dx primary lowest priorityThe dx with Dx Primary checked should be one of the group of Combined ICD10 codes with the lowest Dx Priority.implementedCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    Query check ICD10 dateAcquired Diagnosis / Complication must have Dx Date or Dx Date unknown, other Dx Type must have neither, and must be Arrive_DtTm<Dx_Date<Dispo_DtTmimplementedCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    ICD10
    Query check ICD10 unfilledICD10 entry with missing Dx_Type, Dx_Priority or No Dx EnteredimplementedCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    ICD10
    Query check CCI no admin entriesThere must be no No procedure entered/Blank procedure entry in CCI Picklist or CCI Component.implementedCCMDB.mdbCCI
    CCI Px check
    CCMDB.mdb
    Data Integrity Checks
    Query check CCI if no then noneIf No procedure performed in CCI Picklist there must be no other entries in CCI Picklist or CCI ComponentimplementedCCMDB.mdbCCI
    CCI Px check
    CCMDB.mdb
    Data Integrity Checks
    Query check CCI DatePx Date must be sensible when compared to Arrive_DtTm and Dispo_DtTmimplementedCCMDB.mdbCCI Px check
    CCMDB.mdb
    Data Integrity Checks
    Query check CCI Component unfilledCCI Component entry with missing px, Px_Type or Px_CountimplementedCCMDB.mdbCCI
    CCI Px check
    CCMDB.mdb
    Data Integrity Checks
    Query check CCI Picklist unfilledCCI Picklist entry with missing px, Px_Type or Px_CountimplementedCCMDB.mdbCCI
    CCI Px check
    CCMDB.mdb
    Data Integrity Checks
    Query check CCI component 1 and 2 compatibleComponent CCIs must have compatible component 1 and component 2implementedCCMDB.mdbCCI Px check
    CCMDB.mdb
    Data Integrity Checks
    Query check dispo lower acuity than locationcheck for patients going to lower level of care but without Transfer_Ready_DtTm; Check will launch an error but allow no date, ie it's just a reminder, see #hierarchy of levels of care.implementedCCMDB.mdbICD10 Dx check
    Site/Location check
    CCI Px check
    CCMDB.mdb
    Data Integrity Checks
    Check AcceptDtTm entered or missing checkedEither Accept DtTm field must have content or Accept DtTm missing field must be checked.implementedCCMDB.mdbAPACHE check
    Registry checks
    CCMDB.mdb
    Data Integrity Checks
    Check Function Validate PostalCodeValidates that Postal Code field only contains characters in format allowed for a postal codeimplementedCCMDB.mdbPostal Codes
    Registry checks
    CCMDB.mdb
    Data Integrity Checks
    Check function Validate Last name
  • can't be blank
  • can't start with a space
  • can't start with a hyphen
  • only allows letters, spaces and hyphens
  • implementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    Check function Validate First name
    • can't be blank
    • can't start with a space
    • can't start with a hyphen
    • only allows letters, spaces and hyphens
    implementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    Check function location NE dispoService/Location field can't be same as Dispo fieldimplementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    Check function previous NE LocationPrevious Location field can't be same as Service/Location fieldimplementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    Check Accept Loc Parkif Previous Location = <your hospital> ER (parked) and Pre-admit Inpatient Institution = "NA / not applicable" then there must be a Accept_Loc_park entry.
    if there is an Accept_Loc_park entry, then the Previous Location must be <your hospital> ER (parked) and Pre-admit Inpatient Institution must be "NA / not applicable"
    implementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    Check Sub PharmCheckchecks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have drug days than LOS, disallows complete check if Arrive DtTm or Dispo DtTm are missing because that would break max count check,implementedCCMDB.mdbCCMDB.mdb
    Data Integrity Checks
    Check duplicate patientthere are no dupliate entries for the same patient ward admission on the laptop at send timeimplementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    PL Diff Phin SameLN FN DOBChecks that there are no likely matches of this patient with a different PHIN (ie typos)implementedCentralized data front end.accdbCentralized data front end.accdb
    PL queries
    Registry checks
    Data Processing
    Data Integrity Checks
    PL SameCHART Site Diff PHINA record with this Chart number already exists for this service/Location and it has a different PHIN.implementedCentralized data front end.accdbCentralized data front end.accdb
    PL queries
    Registry checks
    Data Processing
    Data Integrity Checks
    PL SamePHIN Site Diff chartAnother record exists for this Service/Location with the same PHIN and a different Chart number.implementedCentralized data front end.accdbCentralized data front end.accdb
    PL queries
    Registry checks
    Questions
    Data Processing
    Data Integrity Checks
    PL SamePhin Diff LN FN DOB SexAnother record exists with the same PHIN but a different LastName field, FirstName field, Date of Birth, SeximplementedCentralized data front end.accdbCentralized data front end.accdb
    PL queries
    Registry checks
    Data Processing
    Data Integrity Checks
    PL 1orphansRecord meets following conditions implementedCentralized data front end.accdbCentralized data front end.accdb
    PL queries
    Data Processing
    Data Integrity Checks
    PL 2Phin Fake or BlankFinds blank PHINs and those entered to meet function Validate_PHIN so Data Processor can apply PseudoPHIN via Generating PseudoPHINs.implementedCentralized data front end.accdbCentralized data front end.accdb
    PL queries
    Registry checks
    Data Processing
    Data Integrity Checks
    Link suspect negative transit time queryUsed in Correcting suspect links to find records where an earlier record for a patient with that PHIN has a Dispo DtTm that is later than the next record's Arrive DtTm.implementedCentralized data front end.accdbMultiple encounter longitudinal consistency check
    Centralized data front end.accdb
    Registry checks
    Data Processing
    Data Integrity Checks
    Multiple Encounter linking
    Link suspect dead then alive queryUsed in Correcting suspect links to find records where an earlier record with that PHIN was listed as dispo field deceased, but a later entry then shows up.implementedCentralized data front end.accdbMultiple encounter longitudinal consistency check
    Centralized data front end.accdb
    Registry checks
    Data Processing
    Data Integrity Checks
    Multiple Encounter linking
    Link suspect mismatch from ours incomplete queryUsed in Correcting suspect links to find records where a later record with that PHIN has a Previous Location entry corresponding to one of our sites as per the s_dispo table.real_collection table, but an earlier corresponding entry doesn't exist for that location.implementedCentralized data front end.accdbMultiple encounter longitudinal consistency check
    Centralized data front end.accdb
    Registry checks
    Data Processing
    Data Integrity Checks
    Multiple Encounter linking
    Link suspect mismatch to ours incomplete queryUsed in Correcting suspect links to find records where an earlier record with that PHIN has a dispo entry corresponding to one of our sites as per the s_dispo table.real_collection, but a later corresponding entry doesn't exist for that location.implementedCentralized data front end.accdbMultiple encounter longitudinal consistency check
    Centralized data front end.accdb
    Registry checks
    Questions
    Data Processing
    Data Integrity Checks
    Multiple Encounter linking
    Check function Validate Pre Acute Living Situationcan't be blankimplementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    Link suspect not same visitAdmitDtTm queryChecks for records that are likely part of the same admission but have different Visit Admit DtTm field.implementedCentralized data front end.accdbCentralized data front end.accdb
    Registry checks
    Data Integrity Checks
    Query check cooling vs arrestDue to our definition of Targeted Temperature Management (TTM) that code can only be used if there is a Cardiac arrest dximplementedCCMDB.mdbCCI
    CCMDB.mdb
    Data Integrity Checks
    ICD10
    Query check hernia type vs complicationany abdominal hernia complication dx must have an abdominal hernia type dx coded.implementedCCMDB.mdbHernia
    ICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    Query check AIDS vs HIVA record can not have both AIDS (disease due to HIV) and HIV infection, asymptomaticimplementedCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    Query s tmp QASeptic tmp no dxCC pt has QA Septic Shock tmp entry and no Septic Shock/Shock, septic dximplementedCCMDB.mdbICD10 Dx check
    Old dx check
    Tmp check
    CCMDB.mdb
    Data Integrity Checks
    PL Chart 9 DigitFinds any chart numbers that have >8 digits. This would usually mean someone confused a PHIN and a Chart numberimplementedCentralized data front end.accdbCentralized data front end.accdb
    PL queries
    Registry checks
    Questions
    Data Processing
    Data Integrity Checks
    Query s tmp IICU consult DtTm"IICU consult" must have either a date or the check box checked. If they have a date, it has to be between Arrive_DtTm and Dispo_DtTm.implementedCCMDB.mdbTmp check
    CCMDB.mdb
    Data Integrity Checks
    Query check ICD10 Comorbids NoComo code but othersIf No Comorbidities (ICD10 code) is entered, there must really be no other comorbidities codedimplementedCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    ICD10
    Query check ICD10 Comorbids Dx presentAll complete patients must have at least one ICD10 entry for Dx Type Comorbid Diagnosis, which might be No Comorbidities (ICD10 code).implementedCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    ICD10
    Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTmIf an ICD10 code in Category:Awaiting/delayed transfer is Primary Admit Diagnosis/Dx Primary then Transfer Ready DtTm must equal Arrive DtTmimplementedCCMDB.mdbTransfer Ready
    Awaiting/delayed transfer
    ICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    Check Inf Pathogens must have Infection requiring pathogen or Potential InfectionDxs in Category:Pathogens (but not in Category:Double duty pathogen) must have either a Category:Infection requiring pathogen or Category:Potential infection as Combined ICD10 codes.implementedCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogenevery dx in Category:Antibiotic resistance must have a dx in Category:Infection with implied pathogen or in Category:Pathogens as Combined ICD10 codes.implementedCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    Check Inf Infection with implied pathogen must not have a pathogen combined codeevery dx in Category:Infection with implied pathogen must not have a dx in Category:Pathogens as Combined ICD10 codes.implementedCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    Check CCI vs previous locationIf from OR or PACU, must have at least 1 CCI Procedure other than No procedure performedimplementedCCMDB.mdbCCI Px check
    Registry checks
    CCMDB.mdb
    Data Integrity Checks
    Function Validate Chartvalidates the Chart number:
  • Chart must be numerical
  • chart must be
  • checks Function PHIN same as Chart
  • no further checks at this time because chart numbers are different at different hospitals
  • implementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    Sub Dx CheckerRuns most Category:Old_dx_check, Category:ICD10 Dx check, Category:CCI Px check, and a few other checks for dxsimplementedCCMDB.mdbICD10 Dx check
    Old dx check
    CCI Px check
    CCMDB.mdb
    Data Integrity Checks
    Query check ICD10 ESRD vs kidney transplantIf there is a Past history, transplanted kidney then there can only be Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15 if there is also Kidney transplant, failure or rejection or unspecified complicationimplementedCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    ICD10
    Query check ICD10 chonic vent acute resp failureChronic dependence on mechanical ventilator should not be coded with Respiratory failure (insufficiency) NOS, acuteimplementedCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    Function Validate Pre admit Inpatient Institutionvalidates Pre-admit Inpatient Institution field:
  • Can not be blank
  • Check function preAdmit NE Location
  • implementedCCMDB.mdbCCMDB.mdb
    Data Integrity Checks
    Query check ER Delay not too bigUnusually long ER DelayimplementedCCMDB.mdbCCMDB.mdb
    Data Integrity Checks
    Query check CCI Picklist duplicatesNo duplication of CCI Picklist Px_Type, Px_Date, Px_CountimplementedCCMDB.mdbCCI
    CCI Px check
    CCMDB.mdb
    Data Integrity Checks
    Query check CCI Component duplicatesNo duplication of CCI Component Px_Type, Px_DateimplementedCCMDB.mdbCCI
    CCI Px check
    CCMDB.mdb
    Data Integrity Checks
    Query s tmp QASeptic Dx no tmp ICD10CC patient has Septic Shock/Shock, septic dx and no QA Septic Shock tmp entryimplementedCCMDB.mdbICD10 Dx check
    Old dx check
    Tmp check
    CCMDB.mdb
    Data Integrity Checks
    Query s tmp comfort care gt oneOnly one entry allowed per patient.implementedCCMDB.mdbCCMDB.mdb
    Data Integrity Checks
    Query s tmp ABO TEE checksEach of the three projects must have one entry on the ITEM for patients with RecordStatus completeimplementedCCMDB.mdbSite/Location check
    Tmp check
    CCMDB.mdb
    Data Integrity Checks
    TISS Errors vent vs vent2300Any marked TISS Item T0 - Invasive mechanical ventilation at 2300 hrs (TISS Item) has to have a corresponding marked TISS Item T16 - Invasive Mechanical Ventilation (TISS Item) for the same date.implementedCentralized data front end.accdbCentralized data front end.accdb
    TISS28 checks
    Registry checks
    Data Integrity Checks
    TISS Errors Vent vs mechanismAny marked TISS Item T16 - Invasive Mechanical Ventilation (TISS Item) has to have (T18 - ETT Present (TISS Item) or T18 - Trach Tube Present (TISS Item)) for the same date.implementedCentralized data front end.accdbTracheostomy
    Centralized data front end.accdb
    TISS28 checks
    Data Integrity Checks
    Link suspect mismatch pre inpt ours incomplete queryChecks for patients where Pre-admit Inpatient Institution is one of ours but we don't have a corresponding record.implementedCentralized data front end.accdbCentralized data front end.accdb
    Registry checks
    Data Integrity Checks
    PL missing L Tables contentComplete patients must have entries in all of
  • L_ICD10 table
  • L_CCI_Picklist table
  • L_Labs_Flowsheet table
  • L_Pharm_Flowsheet table
  • implementedCentralized data front end.accdbCentralized data front end.accdb
    Questions
    Data Integrity Checks
    Query NDC Pacemaker acquired vs TISSRecords with Acquired Procedure of Pacemaker insertion, temporary that don't have date-matching Pacemaker insertion or vice versa.implementedCentralized data front end.accdbCentralized data front end.accdb
    Data Integrity Checks
    Query NDC TISS CCI endoscopicIf pt has TISS28 item Endoscopy (any type of scope) in the ICU (T43) then there must be an endoscopic CCI for that day.implementedCentralized data front end.accdbCentralized data front end.accdb
    CCI Px check
    TISS28 checks
    Data Integrity Checks
    Check function preAdmit NE LocationPre-admit Inpatient Institution field can't be same as Service/Location fieldimplementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    Check overstay not enteredcheck that all has been entered for the Overstay projectimplementedCCMDB.mdbTmp check
    CCMDB.mdb
    Data Integrity Checks
    OverstayProject
    Query check ICD10 awaiting has Transfer Ready DtTmAny patient who has code in Category:Awaiting/delayed transfer has to have a Transfer Ready DtTm on a different day than their Dispo DtTm.implementedCCMDB.mdbTransfer Ready
    ICD10 Dx check
    Registry checks
    CCMDB.mdb
    Data Integrity Checks
    Query s tmp IICU consult dispo to IICU but no tmpA patient is discharged to IICU and does not have an "IICU consult".implementedCCMDB.mdbTmp check
    CCMDB.mdb
    Data Integrity Checks
    Query check ICD10 trach dxs consistentTracheostomy related CCI and ICD10 codes must be consistent with each other.implementedCCMDB.mdbTracheostomy
    ICD10 Dx check
    CCI Px check
    CCMDB.mdb
    Data Integrity Checks
    Query s tmp Borrow sensible DtTm vs no borrowChecks that data for Project Borrow arrive follows that project'simplementedCCMDB.mdbTmp check
    CCMDB.mdb
    Data Integrity Checks
    Query s tmp Borrow duplicatesChecks that data for Project Borrow arrive follows that project'simplementedCCMDB.mdbTmp check
    CCMDB.mdb
    Data Integrity Checks
    Query NDC cardioversion dx vs TISSIf pt has Acquired Procedure Cardioversion (EXCLUDE defibrillation-we are not tracking), then the TISS28 item T26 & 27 - Cardioversion (TISS Item) (T41) must be marked.implementedCentralized data front end.accdbCentralized data front end.accdb
    CCI Px check
    TISS28 checks
    Data Integrity Checks
    Query NDC CLI vs DX but no TISS17 CentralLineChecks for patients who have a Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI) but no T15 - Central venous catheter (TISS Item).implementedCentralized data front end.accdbCentralized data front end.accdb
    ICD10 Dx check
    Old dx check
    TISS28 checks
    Questions
    Data Integrity Checks
    Query NDC Bad Postal CodeCross check of postal codes against known postal codesimplementedCentralized data front end.accdbPostal Codes
    Centralized data front end.accdb
    Registry checks
    Data Processing
    Data Integrity Checks
    Query NDC CLI AcqDX but NoCLI DateinTMPV2Checks for Patients who have a CLI but not the corresponding tmp entry.implementedCentralized data front end.accdbCentralized data front end.accdb
    ICD10 Dx check
    Old dx check
    Tmp check
    Questions
    Data Integrity Checks
    Query NDC CLI No AcqDX but CLI DateinTMPV2Checks for Patients who have a CLI tmp entry but not the corresponding dx.implementedCentralized data front end.accdbCentralized data front end.accdb
    ICD10 Dx check
    Old dx check
    Tmp check
    Questions
    Data Integrity Checks
    Query NDC TISS Spontaneous vs ETT TrachA patient with T17 - Spontaneous breathing via ETT or Trach (TISS Item)(T19) must also have (T18 - ETT Present (TISS Item)(T22) or T18 - Trach Tube Present (TISS Item)(T23))implementedCentralized data front end.accdbCentralized data front end.accdb
    TISS28 checks
    Data Processing
    Data Integrity Checks
    Query NDC Dialysis TISS CCICritical care patients who have CCI entries for dialysis must have TISS28 entries as well, and vice versa.implementedCentralized data front end.accdbCentralized data front end.accdb
    CCI Px check
    TISS28 checks
    Data Integrity Checks
    Query TISS Errors D ID not in CFEThe D_ID on a TISS28 form does not exist in CFEimplementedTISS28.mdbTISS28 checks
    TISS28.mdb
    TISS28 Scanning Process
    Data Processing
    Data Integrity Checks
    Query TISS Errors duplicate ItemsA TISS28 item exists twiceimplementedTISS28.mdbTISS28 checks
    TISS28.mdb
    TISS28 Scanning Process
    Data Processing
    Data Integrity Checks
    Query TISS Errors missing daysThere are no TISS28 entries for a day that should have at least one based on Arrive DtTm and Dispo DtTmimplementedTISS28.mdbTISS28 checks
    TISS28.mdb
    TISS28 Scanning Process
    Questions
    Data Processing
    Data Integrity Checks
    Query TISS Errors TISS date out of admissionTISS date is not during admissionimplementedTISS28.mdbTISS28 checks
    Registry checks
    TISS28.mdb
    TISS28 Scanning Process
    Data Processing
    Data Integrity Checks
    Length of stay
    Query NDC Trach Dx TISSTracheostomy ICD10s and CCIs must be consistent with Trach TISS.implementedCentralized data front end.accdbTracheostomy
    Centralized data front end.accdb
    ICD10 Dx check
    CCI Px check
    TISS28 checks
    Data Integrity Checks
    Query send check centralized is owner
  • Run automatically at the beginning of sending to ensure that no records that are already vetted or sent can be re-sent
  • implementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    Function Dispo Chronological()Checks that the registry times are in a sensible chronological order.implementedCCMDB.mdbRegistry checks
    CCMDB.mdb
    Data Integrity Checks
    2016 Time and Place changes
    Query check ICD10 mechanism vs traumaTraumas need mechanisms, and mechanisms need traumas (see also Template:ICD10 Guideline Trauma w mechanism).implementedCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Questions
    Data Integrity Checks
    Query check ICD10 Inf Infection req Pathogen must have oneevery dx in Category:Infection requiring pathogen must have a dx in Category:Pathogens as Combined ICD10 codes.implementedCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    Query NDC zCRRT CCI Px but no TISSIf there is a T22 - CRRT (TISS Item) then there should be a CRRT (incl volume removal via PRISMA device) CCI PximplementedCentralized data front end.accdbCentralized data front end.accdb
    CCI Px check
    TISS28 checks
    Data Integrity Checks
    Query NDC zCRRT TISS but no CCI PxIf there is a T22 - CRRT (TISS Item) then there should be a CRRT (incl volume removal via PRISMA device) CCI PximplementedCentralized data front end.accdbCentralized data front end.accdb
    CCI Px check
    TISS28 checks
    Data Integrity Checks
    Query check long transfer delayIs the Transfer Delay unreasonably long?needs reviewCCMDB.mdbTransfer Ready
    CCMDB.mdb
    Questions
    Admit/Discharge
    Data Integrity Checks
    Controlling Dx Type for ICD10 codesControlling Dx Type for ICD10 codesneeds reviewCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Questions
    Data Integrity Checks
    ICD10
    Check pre acute consistentconsistency of Pre acute living situation; Dispo; Postal Code and Previous Locationneeds reviewCCMDB.mdbPostal Codes
    Pre-acute living situation
    CCMDB.mdb
    Questions
    Admit/Discharge
    Data Integrity Checks
    Registry Data
    Check CRF vs ARF across multiple encountersIf a patient had a comorbid of CRF in any previous admission then ARF can not be an admit or complication in subsequent admissions.needs reviewCentralized data front end.accdbMultiple encounter longitudinal consistency check
    Centralized data front end.accdb
    ICD10 Dx check
    CCI Px check
    Questions
    Data Integrity Checks
    Check Inf Potential Infection must have pathogen or alt combined codeevery dx in Category:Potential infection must have a dx in Category:Pathogens or Not an Infection (ICD10 pathogen alternative) as Combined ICD10 codes.needs reviewCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Questions
    Data Integrity Checks
    Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff daysAny patient with a with Transfer Ready DtTm and Dispo DtTm on different days has to have one of the "awaiting" codes and vice versa.needs reviewCCMDB.mdbTransfer Ready
    Awaiting/delayed transfer
    ICD10 Dx check
    CCMDB.mdb
    Questions
    Data Integrity Checks
    Query NDC Dxs vs TISS DialysisIf there is a TISS28 entry for Hemodialysis there should be a corresponding Dx.needs reviewCentralized data front end.accdbCentralized data front end.accdb
    ICD10 Dx check
    TISS28 checks
    Data Integrity Checks
    Check ICD10 some cant be primaryDxs in Category:Pathogens or Category:Antibiotic resistance must not be Primary Admit Diagnosis.needs reviewCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Questions
    Data Integrity Checks
    Query check ICD10 ESRD vs ARFCan't have ESRD and acute renal failure, except if there was a transplant during this ward stayneeds reviewCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Questions
    Data Integrity Checks
    ICD10
    Query check ICD10 ESRD vs AP ARFARF (APACHE) and CRF - Chronic Renal Failure can not be coded together for the same patient.needs reviewCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Data Collection Guide
    Questions
    Data Integrity Checks
    Query check CCI must have entryThere must be at least 1 CCI entry in L_CCI_Picklist table (which might be No procedure performed)needs reviewCCMDB.mdbCCI
    CCI Px check
    CCMDB.mdb
    Questions
    Data Integrity Checks
    Data Integrity Checknot enteredneeds reviewnot enteredData Integrity Check wiki infrastructure
    Check VAP acquired only first encounterVAP should only be Acquired Diagnosis on the first encounter.needs reviewCentralized data front end.accdbMultiple encounter longitudinal consistency check
    Centralized data front end.accdb
    VAP - Ventilator Associated Pneumonia
    ICD10 Dx check
    Old dx check
    Registry checks
    Questions
    Data Integrity Checks
    Query TISS Errors ETT consistentChecks that ETTs are only removed if previously present and only added when not present.needs reviewCentralized data front end.accdbCentralized data front end.accdb
    TISS28 checks
    Questions
    Data Processing
    Data Integrity Checks
    Query check ICD10 duplicatesICD10 Diagnoses (except for Category:Pathogens or Category:Antibiotic resistance and Category:Mechanism) can't be entered in duplicate.needs reviewCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Questions
    Data Integrity Checks
    ICD10
    Query Import request matcherRecords in for which we have patients in L_Log but no lab records from DSMneeds reviewDSM Labs Consistency check.accdbDSM Labs Extract
    Questions
    Data Integrity Checks
    DSM Labs Consistency check.accdb
    DSM check
    Can't check ICD10 ARF vs APACHE ARFCan't have ESRD and acute renal failurenot feasibleCCMDB.mdbICD10 Dx check
    APACHE check
    CCMDB.mdb
    Questions
    Data Integrity Checks
    ICD10
    Check organ donors must be deadorgan donors must be deceasednot feasibleCCMDB.mdbLegacy Content
    CCMDB.mdb
    Questions
    Data Integrity Checks
    Query s tmp Borrow no borrow on own unitCan't have Project Borrow arrive on own unitnot feasibleCCMDB.mdbTmp check
    CCMDB.mdb
    Data Integrity Checks
    Check TISS Intubation consistentAny marked TISS Item T26 & 27 - Insertion of ETT (TISS Item) or in T18 - ETT Present (TISS Item) must have at least one marked TISS item either in T0 - Planned extubation (TISS Item) or in T0 - Unplanned extubation (TISS Item)ready to implementCentralized data front end.accdbCentralized data front end.accdb
    Questions
    Data Integrity Checks
    Query check ICD10 only 1 stage of renal failurecan only have one stage of renal failure in Comorbid Diagnosis and in Admit DiagnosisimplementedCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    ICD10
    Check drugs vs TISSCompare Vasoactive drug IV continuous-single (TISS Item)/T12 - Vasoactive drug IV continuous-multiple simultaneous (TISS Item) against Pharmacy entries for vasoactive drugs.ready to implementCentralized data front end.accdbCentralized data front end.accdb
    TISS28 checks
    Questions
    Data Integrity Checks
    Query TISS Errors CAM positive vs DxChecks that each T0 - CAM positive (TISS Item) goes with an ICD10 code from Category:Deliriumready to implementCentralized data front end.accdbCentralized data front end.accdb
    TISS28 checks
    Registry checks
    Data Processing
    Data Integrity Checks
    Length of stay
    Query NDC TISS Extubation only on TISS Intubated daysAny marked TISS Item in T0 - Planned extubation (TISS Item) or in T0 - Unplanned extubation (TISS Item) must have the T18 - ETT Present (TISS Item) on the same date.ready to implementCentralized data front end.accdbCentralized data front end.accdb
    TISS28 checks
    Data Integrity Checks
    Check CCI CXR vs LOSConfirm that a Category:Labs Imaging count is not unreasonably highready to implementCCMDB.mdbCCMDB.mdb cross checks triggering for correct values
    CCMDB.mdb
    Questions
    Data Integrity Checks
    Length of stay
    Labs
    Check dx implying death must be dispo deceasedIf dx is (Brain death;Guideline for coding organ donation after death;Medical Assistance In Dying;Questions;Sudden cardiac death (and died);User:Ttenbergen;User:Ttenbergen/questions for tina) then Dispo field must be one of the Deceased patients optionsready to implementCCMDB.mdbICD10 Dx check
    CCMDB.mdb
    Data Integrity Checks
    End-of-life related data
    Check dx implying death across encountersCategory:Diagnosis implying death across encountersready to implementCentralized data front end.accdbMultiple encounter longitudinal consistency check
    Centralized data front end.accdb
    ICD10 Dx check
    Registry checks
    Data Integrity Checks
    End-of-life related data
    Check BRR/XBR vs cardiac arrest dxIf there is an Admit Diagnosis or Acquired Diagnosis of at least one of: then there has to be a BRR collection entry.retiredCCMDB.mdbLegacy Content
    CCMDB.mdb
    Data Integrity Checks
    Check Function Panelling admit transfer sameIf patient has Panelling or Discharge Planning as Admit Diagnosis then Arrive DtTm field must be equal to Transfer Ready DtTm field.retiredCCMDB.mdbLegacy Content
    Old dx check
    CCMDB.mdb
    Data Integrity Checks
    Query check ApARF CRFARF (APACHE) and CRF - Chronic Renal Failure can not be coded together for the same patient.retiredCCMDB.mdbLegacy Content
    ICD10 Dx check
    CCMDB.mdb
    Data Collection Guide
    Data Integrity Checks
    Query Check Renal IncompatibleDxscan't have ARF and CRF in same recordretiredCCMDB.mdbLegacy Content
    Old dx check
    CCMDB.mdb
    Data Integrity Checks
    Query check trach dx taskmake sure Trach Task is entered correctlyretiredCCMDB.mdbLegacy Content
    CCMDB.mdb
    Data Integrity Checks
    Query s tmp QAInf basicchecks that none of int, float, bool fields are used in this data.retiredCCMDB.mdbLegacy Content
    CCMDB.mdb
    Data Integrity Checks
    Query s tmp QAInf dx no tmpIf Complication Diagnosis is one of:

    then there has to be a

    • L_TmpV2 entry with project "ICU Infection Audit"
    retiredCCMDB.mdbLegacy Content
    CCMDB.mdb
    Data Integrity Checks
    Query s tmp QAInf tmp no dxIf "QAInf" entry is present in L_TmpV2 then
  • program must be "CC"
  • the corresponding diagnosis must exist
  • retiredCCMDB.mdbLegacy Content
    CCMDB.mdb
    Data Integrity Checks
    Query s tmp QAInf LT 48 hrs after admitDtTm of QAInf entry has to be at least 48hrs after patient admission unless the inf_dttm is blank.retiredCCMDB.mdbLegacy Content
    CCMDB.mdb
    Data Integrity Checks
    Query s tmp ACPerror if ACP Status collection in ICU is missing part of the entry.retiredCCMDB.mdbLegacy Content
    CCMDB.mdb
    Data Integrity Checks
    Query check VAP admit must be from ICUVAP should only be Admit Diagnosis when Previous Location is an ICU.retiredCCMDB.mdbMultiple encounter longitudinal consistency check
    VAP - Ventilator Associated Pneumonia
    ICD10 Dx check
    Old dx check
    Registry checks
    CCMDB.mdb
    Data Integrity Checks
    Query NDC VAP unacceptable dateChecks for Arrive DtTm before QA Infection VAP date and Dispo DtTm after QA Infection VAP date.retiredCentralized data front end.accdbCentralized data front end.accdb
    Old dx check
    Registry checks
    Questions
    Data Integrity Checks
    Query NDC VAP AcqDX but NoVAP DateinTMPV2Checks that any record with an Acquired Diagnosis VAP has a QA Infection VAP entry with a date.retiredCentralized data front end.accdbCentralized data front end.accdb
    Old dx check
    Registry checks
    Questions
    Data Integrity Checks
    Query NDC VAP No AcqDX but VAP DateinTMPV2Checks that any record with QA Infection VAP entry with a date also has an Acquired Diagnosis VAP .retiredCentralized data front end.accdbCentralized data front end.accdb
    Old dx check
    Registry checks
    Questions
    Data Integrity Checks
    Query NDC CLI unacceptable dateChecks that the QA Infection CLI Dt is between the Arrive DtTm and Dispo DtTmretiredCentralized data front end.accdbCentralized data front end.accdb
    Old dx check
    Registry checks
    Questions
    Data Integrity Checks
    Check eliminated dxdisallows any currently entered diagnosis that has been eliminatedretiredCCMDB.mdbICD10 Dx check
    Old dx check
    CCMDB.mdb
    Data Integrity Checks
    Query NDC zCRRT TISS no tmpRecord has T22 - CRRT (TISS Item) but no CRRT tmp entryretiredCentralized data front end.accdbCentralized data front end.accdb
    Tmp check
    TISS28 checks
    Data Integrity Checks
    Query NDC zCRRT tmp no TISSRecord has CRRT tmp but no T22 - CRRT (TISS Item) entryretiredCentralized data front end.accdbCentralized data front end.accdb
    Tmp check
    TISS28 checks
    Data Integrity Checks
    Query check CCI CRRT vs TmpIf CCI CRRT (incl volume removal via PRISMA device) exists there should be a tmp CRRT entry and vice versaretiredCCMDB.mdbTmp check
    CCI Px check
    CCMDB.mdb
    Data Integrity Checks

    Checks under review

    See Data Integrity Check under review