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.
Currently active checks
| edit | page | App | Status | Timing | Firmness | Summary | question | who |
|---|---|---|---|---|---|---|---|---|
| edit | page | App | Status | Timing | Firmness | Summary | question | who |
| edit | Date of Birth | CCMDB.accdb | implemented | complete | hard check | The minimum age allowed is 10, the maximum age allowed is 120. | ||
| edit | Check duplicate patient | CCMDB.accdb | implemented | hard check | there are no duplicate entries for the same patient ward admission on the laptop at send time | |||
| edit | Query check CCI TISS Pharm Vasoactive | CCMDB.accdb | implemented | complete | hard check | Compare Vasoactive drug IV continuous-single (TISS Item)/T14 - Vasoactive drug IV continuous-multiple simultaneous (TISS Item) against Pharmacy entries for vasoactive drugs. | ||
| edit | Check organ donors must be dead | CCMDB.accdb | not feasible | soft check | organ donors must be deceased | |||
| edit | Function long LOS() | CCMDB.accdb | needs review | complete | soft check | LOS/Length of Stay should not be unlikely long based on historical LOS for a given ward (Service/Location field). | ||
| edit | Query check long transfer delay | CCMDB.accdb | needs review | always | soft check | Is the Transfer Delay (Critical Care) or Transfer Delay (Medicine) unreasonably long? | ||
| edit | Query check ICD10 dx implying death must have appropriate dispo | CCMDB.accdb | implemented | hard check | If dx is (Brain death;Medical Assistance In Dying;Sudden cardiac death (and died)) then Dispo field must be one of the Deceased patients options | |||
| edit | Query check CCI Date | CCMDB.accdb | implemented | complete | hard check | Px Date must be sensible when compared to first Service tmp entry and Dispo_DtTm | ||
| edit | Query check cooling vs arrest | CCMDB.accdb | implemented | hard check | Due to our definition of Targeted Temperature Management (TTM) that code can only be used if there is a Cardiac arrest dx | |||
| edit | Query check ICD10 awaiting has Transfer Ready DtTm | CCMDB.accdb | implemented | complete | hard check | Any patient who has code in Category:Awaiting/delayed transfer has to have a (Transfer Ready DtTm or Transfer Ready DtTm tmp entry) on a different day than their Dispo DtTm. | ||
| edit | Query check hernia type vs complication | CCMDB.accdb | implemented | hard check | any abdominal hernia complication dx must have an abdominal hernia type dx coded. | |||
| edit | Query check ICD10 mechanism vs trauma | CCMDB.accdb | implemented | hard check | Traumas need mechanisms, and mechanisms need traumas (see also Template:ICD10 Guideline Trauma w mechanism). | |||
| edit | Check APACHE physiological variable high low | CCMDB.accdb | implemented | hard check and soft check | an APACHE physiological variable is extremely high or low | |||
| edit | Query check ICD10 Inf Infection req Pathogen must have one | CCMDB.accdb | implemented | hard check | every dx in Category:Infection requiring pathogen must have a dx in Category:Pathogens or Category:Double duty pathogen as Combined ICD10 codes. | |||
| edit | Check Inf Infection with implied pathogen must not have a pathogen combined code | CCMDB.accdb | implemented | hard check | every dx in Category:Infection with implied pathogen must not have a dx in Category:Pathogens as Combined ICD10 codes. | |||
| edit | Query Check Inf Pathogens must have Infection requiring pathogen or Potential Infection | CCMDB.accdb | implemented | hard check | Dxs 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. | |||
| edit | Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogen | CCMDB.accdb | implemented | hard check | every dx in Category:Antibiotic resistance must have a dx in Category:Infection with implied pathogen or in Category:Pathogens as Combined ICD10 codes. | |||
| edit | Query check AIDS vs HIV | CCMDB.accdb | implemented | always | hard check | A record can not have both AIDS (disease due to HIV) and HIV infection, asymptomatic | ||
| edit | Query check ICD10 trach dxs consistent | CCMDB.accdb | implemented | hard check | Tracheostomy related CCI and ICD10 codes must be consistent with each other. | |||
| edit | Query check minimal data set incomplete | CCMDB.accdb | implemented | always | hard check | makes sure the Minimal Data Set is collected before records can be sent. | ||
| edit | Function Validate Pre admit Inpatient Institution | CCMDB.accdb | implemented | hard check | validates Pre-admit Inpatient Institution field:
| |||
| edit | Function Validate Previous Location | CCMDB.accdb | implemented | hard check | validates Previous Location field:
| |||
| edit | Query check prev pre-admit consistent | CCMDB.accdb | implemented | hard check | for inpatient transfers within the WRHA, Previous Location field and Pre-admit Inpatient Institution field should be same. | |||
| edit | Query check pt from ER | CCMDB.accdb | implemented | always | soft check | part of validating Boarding Loc | ||
| edit | Query check tmp generate allowed | CCMDB.accdb | implemented | always | hard check | check that tmp project/item combo exists for this location for a project | ||
| edit | Query s tmp project item consistent | CCMDB.accdb | implemented | hard check | Checks that tmp project entries only contain combinations of project and item that are allowed. | |||
| edit | Query s tmp apostrophe in comment | CCMDB.accdb | implemented | hard check | There must not be apostrophes in the comment field as they would mess with Julie's data analysis. | |||
| edit | Query s tmp QASeptic Dx no tmp ICD10 | CCMDB.accdb | implemented | hard check | CC patient has Septic Shock/Shock, septic dx and no QA Septic Shock tmp entry | |||
| edit | Query s tmp QASeptic tmp no dx | CCMDB.accdb | implemented | hard check | CC pt has QA Septic Shock tmp entry and no Septic Shock/Shock, septic dx | |||
| edit | Function Validate PHIN | CCMDB.accdb | implemented | hard check |
| |||
| edit | Function PHIN same as Chart | CCMDB.accdb | implemented | hard check | PHIN can't be the same as Chart | |||
| edit | Function Validate Chart | CCMDB.accdb | implemented | hard check | validates the Chart number:
| |||
| edit | Function Validate Province | CCMDB.accdb | implemented | hard check | Validates the Province field:
| |||
| edit | Function Validate Dispo | CCMDB.accdb | implemented | complete | hard check | doesn't allow empty | ||
| edit | Query check CCI component 1 and 2 compatible | CCMDB.accdb | implemented | complete | hard check | Component CCIs must have compatible component 1 and component 2 | ||
| edit | Query check CCI from OR no CCI | CCMDB.accdb | implemented | hard check (not allowed) or soft check (allowed, but give error; in CFE this means it has to go into the ... table, and cross checks have to consider that table) | If from OR or PACU, must have at least 1 CCI Procedure other than No procedure performed | |||
| edit | Query check dx primary not exactly one | CCMDB.accdb | implemented | always | hard check | There has to be exactly one dx per patient with Dx Primary checked, and it has to be an Admit Diagnosis | ||
| edit | Query check dx primary lowest priority | CCMDB.accdb | implemented | hard check | The dx with Dx Primary checked should be one of the group of Combined ICD10 codes with the lowest Dx Priority. | |||
| edit | Query check ICD10 date | CCMDB.accdb | implemented | complete | hard check | Acquired Diagnosis / Complication must have Dx Date or Dx Date unknown, other Dx Type must have neither, and must be Admit DtTm<Dx_Date<Dispo_DtTm | ||
| edit | Query check ICD10 unfilled | CCMDB.accdb | implemented | complete | hard check | ICD10 entry with missing Dx_Type, Dx_Priority or No Dx Entered | ||
| edit | Query check ICD10 Comorbids Dx present | CCMDB.accdb | implemented | complete | hard check | All complete patients must have at least one ICD10 entry for Dx Type Comorbid Diagnosis, which might be No Comorbidities (ICD10 code). | ||
| edit | Query check ICD10 Comorbids NoComo code but others | CCMDB.accdb | implemented | complete | hard check | If No Comorbidities (ICD10 code) is entered, there must really be no other comorbidities coded | ||
| edit | Query check CCI Picklist unfilled | CCMDB.accdb | implemented | complete | hard check | CCI Picklist entry with missing px, Px_Type or Px_Count | ||
| edit | Query check CCI Component unfilled | CCMDB.accdb | implemented | complete | hard check | CCI Component entry with missing px, Px_Type or Px_Count | ||
| edit | Query check CCI Component duplicates | CCMDB.accdb | implemented | complete | hard check | No duplication of CCI Component Px_Type, Px_Date | ||
| edit | Query check CCI Picklist duplicates | CCMDB.accdb | implemented | complete | hard check | No duplication of CCI Picklist Px_Type, Px_Date, Px_Count | ||
| edit | Query check CCI if no then none | CCMDB.accdb | implemented | complete | hard check | If No procedure performed in CCI Picklist there must be no other entries in CCI Picklist or CCI Component | ||
| edit | Query check CCI Picklist if no admin entries | CCMDB.accdb | implemented | complete | hard check | There must be no No procedure entered/Blank procedure entry in CCI Picklist. | ||
| edit | Query check CCI must have entry | CCMDB.accdb | implemented | complete | hard check | There must be at least 1 CCI entry in L_CCI_Picklist table (which might be No procedure performed) | ||
| edit | Query check ICD10 ESRD vs ARF | CCMDB.accdb | not feasible | complete | hard check | Can't have ESRD and acute renal failure, except if there was a transplant during this ward stay | ||
| edit | Query check ICD10 only 1 stage of renal failure | CCMDB.accdb | implemented | complete | hard check | can only have one stage of renal failure in Comorbid Diagnosis and in Admit Diagnosis | ||
| edit | Query check ICD10 ESRD vs kidney transplant | CCMDB.accdb | implemented | complete | hard check | If 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 complication | ||
| edit | Check Function Validate PostalCode | CCMDB.accdb | implemented | complete | hard check | Validates that Postal Code field only contains characters in format allowed for a postal code | ||
| edit | Check function Validate Last name | CCMDB.accdb | implemented | hard check |
| |||
| edit | Check function Validate First name | CCMDB.accdb | implemented | always | hard check |
| ||
| edit | Check function location NE dispo | CCMDB.accdb | implemented | complete | hard check | Service/Location field can't be same as Dispo field | ||
| edit | Check function preAdmit NE Location | CCMDB.accdb | implemented | complete | hard check | Pre-admit Inpatient Institution field can't be same as Service/Location field | ||
| edit | Check function previous NE Location | CCMDB.accdb | implemented | complete | hard check | Previous Location field can't be same as Service/Location field | ||
| edit | Check Sub PharmCheck | CCMDB.accdb | implemented | complete | hard check | Every CC record has to have at least one pharmacy record (possibly all zeros), and the number of drug days can't be GT LOS, | ||
| edit | Query check ICD10 CLI vs CCI CentralLine | CCMDB.accdb | implemented | complete | hard check | Checks for critical care patients who have a Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI) but no T17 - Central venous catheter (TISS Item). | ||
| edit | Check function Validate Pre Acute Living Situation | CCMDB.accdb | implemented | complete | hard check | can't be blank | ||
| edit | Query check CCI TISS Intubation vs Intubated | CCMDB.accdb | implemented | always | hard check | Any marked TISS Item in T28 - Planned extubation (TISS Item) or in T29 - Unplanned extubation (TISS Item) must have the T22 - ETT Present (TISS Item) on the same date. | ||
| edit | Query s tmp IICU consult dispo to IICU but no tmp | CCMDB.accdb | implemented | always | hard check | A patient is discharged to IICU and does not have an IICU consult entry. | ||
| edit | Sub Dx Checker | CCMDB.accdb | implemented | hard check | Runs most Category:Old_dx_check, Category:ICD10 Dx check, Category:CCI Px check, and a few other checks for dxs | |||
| edit | Query check ICD10 chronic vent acute resp failure | CCMDB.accdb | implemented | hard check | Chronic dependence on mechanical ventilator should not be coded with Respiratory failure (insufficiency) NOS, acute | |||
| edit | Query s tmp ABO TEE checks | CCMDB.accdb | implemented | complete | hard check | Each of the three ABO TEE project entries must have one entry on the ITEM for patients with RecordStatus complete | ||
| edit | Query check CCI TISS Vented without mechanism | CCMDB.accdb | implemented | complete | hard check | Any marked TISS Item T18 - Invasive Mechanical Ventilation (TISS Item) has to have (T22 - ETT Present (TISS Item) or T23 - Trach Tube Present (TISS Item)) for the same date. | ||
| edit | Query s tmp Borrow no borrow on own unit | CCMDB.accdb | not feasible | complete | hard check | Can't have Project Borrow arrive on own unit | ||
| edit | Query send check centralized is owner | CCMDB.accdb | implemented | hard check | Run automatically at the beginning of sending to ensure that no records that are already vetted or sent can be re-sent | |||
| edit | Query check ICD10 ESRD and AKI only if transplant | CCMDB.accdb | implemented | complete | soft check | A patient who has an ESRD dx and an AKI dx is an error unless they also have a kidney transplant CCI. | ||
| edit | Query s tmp Boarding Loc date item | CCMDB.accdb | implemented | complete | hard check | Validates entries for Boarding Loc | ||
| edit | Query check has transfer ready date or checkbox | CCMDB.accdb | implemented | complete | not entered | Each Transfer Ready DtTm tmp entry has to have either a dttm, or its checkbox checked. | ||
| edit | Query check tmp service or location duplicate | CCMDB.accdb | implemented | always | hard check | Service tmp entry and Boarding_Loc entries must not have duplicate dates and services resp. locations and comments | ||
| edit | Query check tmp service and program consistency | CCMDB.accdb | implemented | always | hard check | Service tmp entry values must be consistent with the Program | ||
| edit | Query check tmp Service and Boarding Loc during admission timeframe | CCMDB.accdb | implemented | complete | hard check | Service tmp entry and Boarding Loc date and time var need to be between Admit DtTm and Dispo DtTm. | ||
| edit | Query check CCI TISS if no then none | CCMDB.accdb | implemented | incomplete | hard check | If No TISS Item (TISS Item) in CCI Picklist there must be no other entry from TISS Item List in CCI Picklist, and vice versa | ||
| edit | Query check CCI TISS NrDays GT LOS | CCMDB.accdb | implemented | incomplete | hard check | There are more TISS Item Px_Dates than there are days between the first Service tmp entry and Dispo DtTm | ||
| edit | Query check CCI TISS NrDays LT LOS | CCMDB.accdb | implemented | complete | hard check | There are more TISS Item Px_Dates than there are days between the first Service tmp entry and Dispo DtTm | ||
| edit | Query check transfer DtTm during admission | CCMDB.accdb | implemented | always | not entered | Transfer Ready DtTm tmp entry should never be earlier than first Boarding Loc dttm or later than Dispo DtTm | ||
| edit | Query s tmp check combined Boarding Loc and TransferReadyDtTm | CCMDB.accdb | implemented | complete | hard check | Validates that there are no unmatched Transfer Ready DtTm tmp entry and Boarding Loc as per Template:Combined instructions for Transfer Ready DtTm and Boarding Loc. | ||
| edit | Query s tmp check Boarding Loc and TransferReadyDtTm pairs | CCMDB.accdb | implemented | complete | hard check | Validates that combinations of Transfer Ready DtTm tmp entry and Boarding Loc with the same integer always appear as pairs as per Template:Combined instructions for Transfer Ready DtTm and Boarding Loc. | ||
| edit | Query check tmp Boarding Loc Service first same | CCMDB.accdb | implemented | complete | hard check | Validates that the DtTm for the first Service tmp entry is the same as that for the first Boarding Loc entry | ||
| edit | Query check tmp 2 BL TR S same tm | CCMDB.accdb | implemented | always | hard check | There can't be two Transfer Ready DtTm or two Boarding Loc or two Service tmp entries with the same date and time | ||
| edit | Query check eliminated CCI Comp | CCMDB.accdb | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||
| edit | Query check eliminated CCI Pick | CCMDB.accdb | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||
| edit | Query check eliminated ICD10 | CCMDB.accdb | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||
| edit | Query check CCI TISS matching BoardingLoc time | CCMDB.accdb | implemented | incomplete | hard check | If the Px Date component of a CCI Picklist has a time, then there must be a corresponding Boarding Loc entry | ||
| edit | Query check CCI vs LOS count days component | CCMDB.accdb | implemented | complete | hard check | Confirm that CCI Collection Mode or CCI Component CCI collect count days items don't have a count > LOS. | ||
| edit | Query check CCI TISS discontinuous ETT | CCMDB.accdb | implemented | complete | soft check | T22 - ETT Present (TISS Item) should start with an T40 - Insertion of ETT (TISS Item) and end with an T28 - Planned extubation (TISS Item) or T29 - Unplanned extubation (TISS Item). | ||
| edit | Query check CCI vs LOS count days picklist | CCMDB.accdb | implemented | complete | hard check | Confirm that CCI Collection Mode for CCI Picklist CCI collect count days items don't have a count > LOS. | ||
| edit | Query check no consecutive same BL or Service | CCMDB.accdb | implemented | always | hard check | Check that there are no two identical Boarding Locs or Services without a different one with a time stamp in between those two. | ||
| edit | Query check Transfer DtTm after paired BL and before later BL | CCMDB.accdb | implemented | always | not entered | For each pair, the Transfer Ready DtTm tmp entry should never be earlier any Boarding Loc dttm, nor later than the next Boarding Loc | ||
| edit | Query Check BL TR combiner null | CCMDB.accdb | implemented | complete | hard check | Checks that all Boarding Loc / Transfer Ready DtTm tmp entry pairs have a non-null combiner integer. | ||
| edit | Query check ICD10 trach create but no TISS | CCMDB.accdb | implemented | always | hard check | If there is an acquired Tracheostomy creation there also has to be a Trach Tube Present (TISS Item) | ||
| edit | Query check ICD10 trach has trach but no TISS | CCMDB.accdb | implemented | always | soft check | If there is a Tracheostomy, has one (Z93.0) ICD10, there should likely be a T23 - Trach Tube Present (TISS Item) | ||
| edit | Query check CCI Component no admin entries | CCMDB.accdb | implemented | complete | hard check | There must be no No procedure entered/Blank procedure entry in CCI Component. | ||
| edit | Query s tmp EuroSCORE II checks | CCMDB.accdb | implemented | complete | hard check | Each of the two Euroscore II project entries must have one entry and the float_var must be between 0 and 23.99 if RecordStatus is complete | ||
| edit | Query check CCI ICD10 Dialysis no Dx | CCMDB.accdb | implemented | complete | hard check | If a profile has one of the #Dialysis CCI Items there should also be one of the #Dialysis qualifying Dxs. | ||
| edit | Query check tmp BedHeld | CCMDB.accdb | implemented | complete | hard check | Sanity check for BedHeldEnd DtTm | ||
| edit | Query check CCI each count vs LOS | CCMDB.accdb | needs review | complete | soft check | Confirm that a Category:Labs Imaging count is not unreasonably high | ||
| edit | Query s tmp Boarding Loc ER delay reasonable | CCMDB.accdb | implemented | complete | soft check | Flags Boarding Loc entries for ERs where a second Boarding Loc entry exists that is less than 30 min later or more than 67 hours later for CC or more than 144 hrs later for Med | There are many false positives due to ICU delays shorter than 30 mins. Do we want to change anything about that threshold? Discussed with Julie and Lisa today but can't remember the outcome. Ttenbergen 10:58, 2024 April 24 (CDT)
| Task |
All checks =
| edit | page | App | Status | Timing | Firmness | Summary | question | who |
|---|---|---|---|---|---|---|---|---|
| edit | page | App | Status | Timing | Firmness | Summary | question | who |
| edit | Date of Birth | CCMDB.accdb | implemented | complete | hard check | The minimum age allowed is 10, the maximum age allowed is 120. | ||
| edit | Check duplicate patient | CCMDB.accdb | implemented | hard check | there are no duplicate entries for the same patient ward admission on the laptop at send time | |||
| edit | Query Check Renal IncompatibleDxs | CCMDB.accdb | retired | hard check | can't have ARF and CRF in same record | |||
| edit | Query check ApARF CRF | CCMDB.accdb | retired | always | hard check | ARF (APACHE) and CRF - Chronic Renal Failure can not be coded together for the same patient. | ||
| edit | Query TISS Errors NrTISSDays NE LOS | CCMDB.accdb | declined | always | hard check | Length 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). | ||
| edit | Query check overstay not entered | CCMDB.accdb | retired | always | hard check | check that all has been entered for the Overstay project | ||
| edit | Query check CCI TISS Pharm Vasoactive | CCMDB.accdb | implemented | complete | hard check | Compare Vasoactive drug IV continuous-single (TISS Item)/T14 - Vasoactive drug IV continuous-multiple simultaneous (TISS Item) against Pharmacy entries for vasoactive drugs. | ||
| edit | Check BRR/XBR vs cardiac arrest dx | CCMDB.accdb | retired | always | hard check | If there is an Admit Diagnosis or Acquired Diagnosis of at least one of: then there has to be a BRR collection entry. | ||
| edit | Check organ donors must be dead | CCMDB.accdb | not feasible | soft check | organ donors must be deceased | |||
| edit | Check eliminated dx | CCMDB.accdb | retired | hard check | disallows any currently entered diagnosis that has been eliminated | |||
| edit | Function Dispo Chronological() | CCMDB.accdb | retired | always | hard check | Checks that the registry times are in a sensible chronological order. | ||
| edit | Function long LOS() | CCMDB.accdb | needs review | complete | soft check | LOS/Length of Stay should not be unlikely long based on historical LOS for a given ward (Service/Location field). | ||
| edit | Query check long transfer delay | CCMDB.accdb | needs review | always | soft check | Is the Transfer Delay (Critical Care) or Transfer Delay (Medicine) unreasonably long? | ||
| edit | Controlling Dx Type for ICD10 codes | CCMDB.accdb | declined | complete | hard check | Some dxs can't be Dx Types Primary Admit Diagnosis, Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis | ||
| edit | Query check ICD10 dx implying death must have appropriate dispo | CCMDB.accdb | implemented | hard check | If dx is (Brain death;Medical Assistance In Dying;Sudden cardiac death (and died)) then Dispo field must be one of the Deceased patients options | |||
| edit | Query check CCI Date | CCMDB.accdb | implemented | complete | hard check | Px Date must be sensible when compared to first Service tmp entry and Dispo_DtTm | ||
| edit | Query check cooling vs arrest | CCMDB.accdb | implemented | hard check | Due to our definition of Targeted Temperature Management (TTM) that code can only be used if there is a Cardiac arrest dx | |||
| edit | Query check ICD10 awaiting has Transfer Ready DtTm | CCMDB.accdb | implemented | complete | hard check | Any patient who has code in Category:Awaiting/delayed transfer has to have a (Transfer Ready DtTm or Transfer Ready DtTm tmp entry) on a different day than their Dispo DtTm. | ||
| edit | Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days | CCMDB.accdb | declined | complete | hard check | Any patient with a with Transfer Ready DtTm and Dispo DtTm on different days has to have one of the "awaiting" codes and vice versa. | ||
| edit | Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm | CCMDB.accdb | declined | always | hard check | If an ICD10 code in Category:Awaiting/delayed transfer is Primary Admit Diagnosis/Dx Primary then Transfer Ready DtTm must equal "Arrive DtTm" | ||
| edit | Query check hernia type vs complication | CCMDB.accdb | implemented | hard check | any abdominal hernia complication dx must have an abdominal hernia type dx coded. | |||
| edit | Query check ICD10 mechanism vs trauma | CCMDB.accdb | implemented | hard check | Traumas need mechanisms, and mechanisms need traumas (see also Template:ICD10 Guideline Trauma w mechanism). | |||
| edit | Check APACHE physiological variable high low | CCMDB.accdb | implemented | hard check and soft check | an APACHE physiological variable is extremely high or low | |||
| edit | Query check ICD10 Inf Infection req Pathogen must have one | CCMDB.accdb | implemented | hard check | every dx in Category:Infection requiring pathogen must have a dx in Category:Pathogens or Category:Double duty pathogen as Combined ICD10 codes. | |||
| edit | Check Inf Infection with implied pathogen must not have a pathogen combined code | CCMDB.accdb | implemented | hard check | every dx in Category:Infection with implied pathogen must not have a dx in Category:Pathogens as Combined ICD10 codes. | |||
| edit | Query Check Inf Pathogens must have Infection requiring pathogen or Potential Infection | CCMDB.accdb | implemented | hard check | Dxs 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. | |||
| edit | Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogen | CCMDB.accdb | implemented | hard check | every dx in Category:Antibiotic resistance must have a dx in Category:Infection with implied pathogen or in Category:Pathogens as Combined ICD10 codes. | |||
| edit | Query check AIDS vs HIV | CCMDB.accdb | implemented | always | hard check | A record can not have both AIDS (disease due to HIV) and HIV infection, asymptomatic | ||
| edit | Query check ICD10 trach dxs consistent | CCMDB.accdb | implemented | hard check | Tracheostomy related CCI and ICD10 codes must be consistent with each other. | |||
| edit | Query check minimal data set incomplete | CCMDB.accdb | implemented | always | hard check | makes sure the Minimal Data Set is collected before records can be sent. | ||
| edit | Query check overstay no colour | CCMDB.accdb | retired | always | hard check | Med pts must have Overstay colours | ||
| edit | Query check overstay pt from our med | CCMDB.accdb | retired | always | hard check | pts from a location where we collect should not have Overstay colour | ||
| edit | Function Validate Pre admit Inpatient Institution | CCMDB.accdb | implemented | hard check | validates Pre-admit Inpatient Institution field:
| |||
| edit | Function Validate Previous Location | CCMDB.accdb | implemented | hard check | validates Previous Location field:
| |||
| edit | Query check previous location vs service inconsistent | CCMDB.accdb | retired | hard check | patients 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". | |||
| edit | Query check prev pre-admit consistent | CCMDB.accdb | implemented | hard check | for inpatient transfers within the WRHA, Previous Location field and Pre-admit Inpatient Institution field should be same. | |||
| edit | Function Validate previous service | CCMDB.accdb | retired | always | hard check | Validates Previous Service field: can't be empty/blank | ||
| edit | Query check pt from ER | CCMDB.accdb | implemented | always | soft check | part of validating Boarding Loc | ||
| edit | Query check tmp generate allowed | CCMDB.accdb | implemented | always | hard check | check that tmp project/item combo exists for this location for a project | ||
| edit | Query check trach dx task | CCMDB.accdb | retired | always | hard check | make sure Trach Task is entered correctly | ||
| edit | Query s tmp ACP | CCMDB.accdb | retired | always | hard check | error if ACP Status collection in ICU is missing part of the entry. | ||
| edit | Query s tmp project item consistent | CCMDB.accdb | implemented | hard check | Checks that tmp project entries only contain combinations of project and item that are allowed. | |||
| edit | Query s tmp QAInf basic | CCMDB.accdb | retired | always | hard check | checks that none of int, float, bool fields are used in this data. | ||
| edit | Query s tmp apostrophe in comment | CCMDB.accdb | implemented | hard check | There must not be apostrophes in the comment field as they would mess with Julie's data analysis. | |||
| edit | Query s tmp QAInf dx no tmp | CCMDB.accdb | retired | always | hard check | If Complication Diagnosis is one of:
then there has to be a
| ||
| edit | Query s tmp QAInf tmp no dx | CCMDB.accdb | retired | always | hard check | If "QAInf" entry is present in L_TmpV2 then
| ||
| edit | Query s tmp QAInf LT 48 hrs after admit | CCMDB.accdb | retired | always | hard check | DtTm of QAInf entry has to be at least 48hrs after patient admission unless the inf_dttm is blank. | ||
| edit | Query s tmp QASeptic Dx no tmp ICD10 | CCMDB.accdb | implemented | hard check | CC patient has Septic Shock/Shock, septic dx and no QA Septic Shock tmp entry | |||
| edit | Query s tmp QASeptic tmp no dx | CCMDB.accdb | implemented | hard check | CC pt has QA Septic Shock tmp entry and no Septic Shock/Shock, septic dx | |||
| edit | Function Validate PHIN | CCMDB.accdb | implemented | hard check |
| |||
| edit | Function PHIN same as Chart | CCMDB.accdb | implemented | hard check | PHIN can't be the same as Chart | |||
| edit | Function Validate Chart | CCMDB.accdb | implemented | hard check | validates the Chart number:
| |||
| edit | Function Validate Province | CCMDB.accdb | implemented | hard check | Validates the Province field:
| |||
| edit | Function Validate Dispo | CCMDB.accdb | implemented | complete | hard check | doesn't allow empty | ||
| edit | Function Validate Transfer Ready DtTm | CCMDB.accdb | retired | complete | hard check | doesn't allow violation of function Transfer_Ready_DtTm_vs_status | ||
| edit | Function Transfer Ready DtTm vs status | CCMDB.accdb | retired | complete | hard check | If Transfer_Ready_DtTm is blank, TR_info_status must not be; if TR_info_status has content, Transfer_Ready_DtTm must be blank. | ||
| edit | Query check CCI component 1 and 2 compatible | CCMDB.accdb | implemented | complete | hard check | Component CCIs must have compatible component 1 and component 2 | ||
| edit | Query check CCI from OR no CCI | CCMDB.accdb | implemented | hard check (not allowed) or soft check (allowed, but give error; in CFE this means it has to go into the ... table, and cross checks have to consider that table) | If from OR or PACU, must have at least 1 CCI Procedure other than No procedure performed | |||
| edit | Query check dx primary not exactly one | CCMDB.accdb | implemented | always | hard check | There has to be exactly one dx per patient with Dx Primary checked, and it has to be an Admit Diagnosis | ||
| edit | Query check dx primary lowest priority | CCMDB.accdb | implemented | hard check | The dx with Dx Primary checked should be one of the group of Combined ICD10 codes with the lowest Dx Priority. | |||
| edit | Query check ICD10 date | CCMDB.accdb | implemented | complete | hard check | Acquired Diagnosis / Complication must have Dx Date or Dx Date unknown, other Dx Type must have neither, and must be Admit DtTm<Dx_Date<Dispo_DtTm | ||
| edit | Query check ICD10 unfilled | CCMDB.accdb | implemented | complete | hard check | ICD10 entry with missing Dx_Type, Dx_Priority or No Dx Entered | ||
| edit | Query check ICD10 duplicates | CCMDB.accdb | declined | complete | hard check | Admit and Comorbid ICD10 Diagnoses (except for Category:Pathogens or Category:Antibiotic resistance and Category:Mechanism and Colonized with organism (not infected)) can't be entered in duplicate. | ||
| edit | Query check ICD10 Comorbids Dx present | CCMDB.accdb | implemented | complete | hard check | All complete patients must have at least one ICD10 entry for Dx Type Comorbid Diagnosis, which might be No Comorbidities (ICD10 code). | ||
| edit | Query check ICD10 Comorbids NoComo code but others | CCMDB.accdb | implemented | complete | hard check | If No Comorbidities (ICD10 code) is entered, there must really be no other comorbidities coded | ||
| edit | Query check CCI Picklist unfilled | CCMDB.accdb | implemented | complete | hard check | CCI Picklist entry with missing px, Px_Type or Px_Count | ||
| edit | Query check CCI Component unfilled | CCMDB.accdb | implemented | complete | hard check | CCI Component entry with missing px, Px_Type or Px_Count | ||
| edit | Query check CCI Component duplicates | CCMDB.accdb | implemented | complete | hard check | No duplication of CCI Component Px_Type, Px_Date | ||
| edit | Query check CCI Picklist duplicates | CCMDB.accdb | implemented | complete | hard check | No duplication of CCI Picklist Px_Type, Px_Date, Px_Count | ||
| edit | Query check CCI if no then none | CCMDB.accdb | implemented | complete | hard check | If No procedure performed in CCI Picklist there must be no other entries in CCI Picklist or CCI Component | ||
| edit | Query check CCI Picklist if no admin entries | CCMDB.accdb | implemented | complete | hard check | There must be no No procedure entered/Blank procedure entry in CCI Picklist. | ||
| edit | Query check CCI must have entry | CCMDB.accdb | implemented | complete | hard check | There must be at least 1 CCI entry in L_CCI_Picklist table (which might be No procedure performed) | ||
| edit | Check pre acute consistent | CCMDB.accdb | declined | complete | soft check | consistency of Pre acute living situation; Dispo; Postal Code and Previous Location | ||
| edit | Query check ICD10 ESRD vs ARF | CCMDB.accdb | not feasible | complete | hard check | Can't have ESRD and acute renal failure, except if there was a transplant during this ward stay | ||
| edit | Query check ICD10 only 1 stage of renal failure | CCMDB.accdb | implemented | complete | hard check | can only have one stage of renal failure in Comorbid Diagnosis and in Admit Diagnosis | ||
| edit | Can't check ICD10 ARF vs APACHE ARF | CCMDB.accdb | declined | always | hard check | Can't have ESRD and acute renal failure | ||
| edit | Query check ICD10 ESRD vs kidney transplant | CCMDB.accdb | implemented | complete | hard check | If 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 complication | ||
| edit | Query check CCI CRRT vs Tmp | CCMDB.accdb | retired | complete | hard check | If CCI CRRT (incl volume removal via PRISMA device) exists there should be a tmp CRRT entry and vice versa | ||
| edit | Check Function Panelling admit transfer same | CCMDB.accdb | retired | complete | hard check | If patient has Panelling or Discharge Planning as Admit Diagnosis then Arrive DtTm field must be equal to Transfer Ready DtTm field. | ||
| edit | Query check dispo lower acuity than location | CCMDB.accdb | retired | complete | soft check | check for patients going to lower level of care (based on S dispo table.acuity_level) but without Transfer_Ready_DtTm; Check will launch an error but allow no date, ie it's just a reminder, see Level of care hierarchy. | ||
| edit | Check AcceptDtTm entered or missing checked | CCMDB.accdb | retired | complete | hard check | Either Accept DtTm field must have content or Accept DtTm missing field must be checked. | ||
| edit | Check Function Validate PostalCode | CCMDB.accdb | implemented | complete | hard check | Validates that Postal Code field only contains characters in format allowed for a postal code | ||
| edit | Check function Validate Last name | CCMDB.accdb | implemented | hard check |
| |||
| edit | Check function Validate First name | CCMDB.accdb | implemented | always | hard check |
| ||
| edit | Check function location NE dispo | CCMDB.accdb | implemented | complete | hard check | Service/Location field can't be same as Dispo field | ||
| edit | Check function preAdmit NE Location | CCMDB.accdb | implemented | complete | hard check | Pre-admit Inpatient Institution field can't be same as Service/Location field | ||
| edit | Check function previous NE Location | CCMDB.accdb | implemented | complete | hard check | Previous Location field can't be same as Service/Location field | ||
| edit | Check Accept Loc Park | CCMDB.accdb | retired | hard check | if Previous Location = <your hospital> ER (parked) and Pre-admit Inpatient Institution = "NA / not applicable" then there must be a Accept_Loc_park entry. | |||
| edit | Check Accept Loc Park | CCMDB.accdb | retired | hard check | 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" | |||
| edit | Check Sub PharmCheck | CCMDB.accdb | implemented | complete | hard check | Every CC record has to have at least one pharmacy record (possibly all zeros), and the number of drug days can't be GT LOS, | ||
| edit | Query check ICD10 Inf Potential Infection must have pathogen or alt | CCMDB.accdb | declined | always | hard check | every dx in Category:Potential infection must have a dx in Category:Pathogens or Not an Infection (ICD10 pathogen alternative) as Combined ICD10 codes. | ||
| edit | Query check ICD10 CLI vs CCI CentralLine | CCMDB.accdb | implemented | complete | hard check | Checks for critical care patients who have a Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI) but no T17 - Central venous catheter (TISS Item). | ||
| edit | Check function Validate Pre Acute Living Situation | CCMDB.accdb | implemented | complete | hard check | can't be blank | ||
| edit | Query check VAP admit must be from ICU | CCMDB.accdb | retired | complete | hard check | VAP should only be Admit Diagnosis when Previous Location is an ICU. | ||
| edit | Query check CCI TISS Intubation vs Intubated | CCMDB.accdb | implemented | always | hard check | Any marked TISS Item in T28 - Planned extubation (TISS Item) or in T29 - Unplanned extubation (TISS Item) must have the T22 - ETT Present (TISS Item) on the same date. | ||
| edit | Query s tmp IICU consult DtTm | CCMDB.accdb | retired | always | hard check | "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. | ||
| edit | Query s tmp IICU consult dispo to IICU but no tmp | CCMDB.accdb | implemented | always | hard check | A patient is discharged to IICU and does not have an IICU consult entry. | ||
| edit | Query check CCI TISS spont breath no tube | CCMDB.accdb | declined | always | hard check | A patient with T19 - Spontaneous breathing via ETT without PEEP/CPAP, with or without supplemental O2 (TISS Item) must also have (T22 - ETT Present (TISS Item) or T23 - Trach Tube Present (TISS Item)) | ||
| edit | Sub Dx Checker | CCMDB.accdb | implemented | hard check | Runs most Category:Old_dx_check, Category:ICD10 Dx check, Category:CCI Px check, and a few other checks for dxs | |||
| edit | Query check ICD10 chronic vent acute resp failure | CCMDB.accdb | implemented | hard check | Chronic dependence on mechanical ventilator should not be coded with Respiratory failure (insufficiency) NOS, acute | |||
| edit | Query check CCI TISS CAM positive vs Dx | CCMDB.accdb | declined | always | hard check | Checks that each T9 - CAM positive (TISS Item) goes with an ICD10 code from Category:Delirium | ||
| edit | Query s tmp comfort care gt one | CCMDB.accdb | retired | always | hard check | Only one entry allowed per patient. | ||
| edit | Query s tmp ABO TEE checks | CCMDB.accdb | implemented | complete | hard check | Each of the three ABO TEE project entries must have one entry on the ITEM for patients with RecordStatus complete | ||
| edit | Query check CCI TISS Vented without mechanism | CCMDB.accdb | implemented | complete | hard check | Any marked TISS Item T18 - Invasive Mechanical Ventilation (TISS Item) has to have (T22 - ETT Present (TISS Item) or T23 - Trach Tube Present (TISS Item)) for the same date. | ||
| edit | Query s tmp Borrow no borrow on own unit | CCMDB.accdb | not feasible | complete | hard check | Can't have Project Borrow arrive on own unit | ||
| edit | Query s tmp Borrow duplicates | CCMDB.accdb | retired | complete | hard check | Checks that data for Project Borrow arrive follows that project's | ||
| edit | Query s tmp Borrow sensible DtTm vs no borrow | CCMDB.accdb | retired | complete | hard check | Checks that data for Project Borrow arrive follows that project's | ||
| edit | Query NDC Dialysis TISS CCI | CCMDB.accdb | declined | complete | hard check | Critical care patients who have CCI entries for a type of dialysis must have a TISS28 entry for the same type of dialysis as well, and vice versa. | ||
| edit | Query send check centralized is owner | CCMDB.accdb | implemented | hard check | Run automatically at the beginning of sending to ensure that no records that are already vetted or sent can be re-sent | |||
| edit | Query check ICD10 ESRD and AKI only if transplant | CCMDB.accdb | implemented | complete | soft check | A patient who has an ESRD dx and an AKI dx is an error unless they also have a kidney transplant CCI. | ||
| edit | Query check ICD10 stroke | CCMDB.accdb | declined | hard check | Stroke, NOS can not be coded with other stroke codes. | |||
| edit | Query s tmp Boarding Loc date item | CCMDB.accdb | implemented | complete | hard check | Validates entries for Boarding Loc | ||
| edit | Query s tmp Boarding Loc no borrow but entry | CCMDB.accdb | retired | complete | hard check | Validates entries for Boarding Loc | ||
| edit | Query check has transfer ready date or checkbox | CCMDB.accdb | implemented | complete | not entered | Each Transfer Ready DtTm tmp entry has to have either a dttm, or its checkbox checked. | ||
| edit | Query check tmp service or location duplicate | CCMDB.accdb | implemented | always | hard check | Service tmp entry and Boarding_Loc entries must not have duplicate dates and services resp. locations and comments | ||
| edit | Query check tmp service and program consistency | CCMDB.accdb | implemented | always | hard check | Service tmp entry values must be consistent with the Program | ||
| edit | Query check tmp Service and Boarding Loc during admission timeframe | CCMDB.accdb | implemented | complete | hard check | Service tmp entry and Boarding Loc date and time var need to be between Admit DtTm and Dispo DtTm. | ||
| edit | Query check tmp ER Boarding Loc should exist if from ER | CCMDB.accdb | declined | always | soft check | For patients with Previous Location ER at same site there should be a Boarding Loc ER. | ||
| edit | Query check CCI TISS if no then none | CCMDB.accdb | implemented | incomplete | hard check | If No TISS Item (TISS Item) in CCI Picklist there must be no other entry from TISS Item List in CCI Picklist, and vice versa | ||
| edit | Query check CCI TISS NrDays GT LOS | CCMDB.accdb | implemented | incomplete | hard check | There are more TISS Item Px_Dates than there are days between the first Service tmp entry and Dispo DtTm | ||
| edit | Query check CCI TISS NrDays LT LOS | CCMDB.accdb | implemented | complete | hard check | There are more TISS Item Px_Dates than there are days between the first Service tmp entry and Dispo DtTm | ||
| edit | Query check transfer DtTm during admission | CCMDB.accdb | implemented | always | not entered | Transfer Ready DtTm tmp entry should never be earlier than first Boarding Loc dttm or later than Dispo DtTm | ||
| edit | Query check transfer ready tmp for each Boarding Loc | CCMDB.accdb | retired | complete | hard | There should be a Transfer Ready DtTm tmp entry for each Boarding Loc entry of a profile | ||
| edit | Query s tmp check combined Boarding Loc and TransferReadyDtTm | CCMDB.accdb | implemented | complete | hard check | Validates that there are no unmatched Transfer Ready DtTm tmp entry and Boarding Loc as per Template:Combined instructions for Transfer Ready DtTm and Boarding Loc. | ||
| edit | Query s tmp check Boarding Loc and TransferReadyDtTm pairs | CCMDB.accdb | implemented | complete | hard check | Validates that combinations of Transfer Ready DtTm tmp entry and Boarding Loc with the same integer always appear as pairs as per Template:Combined instructions for Transfer Ready DtTm and Boarding Loc. | ||
| edit | Query check tmp Boarding Loc Service first same | CCMDB.accdb | implemented | complete | hard check | Validates that the DtTm for the first Service tmp entry is the same as that for the first Boarding Loc entry | ||
| edit | Query check tmp Transfer Ready not before Boarding Loc | CCMDB.accdb | retired | complete | hard check | Validates that the DtTm for a Transfer_Ready_DtTm_tmp entry is not before its matching Boarding Loc entry | ||
| edit | Query check tmp 2 BL TR S same tm | CCMDB.accdb | implemented | always | hard check | There can't be two Transfer Ready DtTm or two Boarding Loc or two Service tmp entries with the same date and time | ||
| edit | Query check eliminated CCI Comp | CCMDB.accdb | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||
| edit | Query check eliminated CCI Pick | CCMDB.accdb | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||
| edit | Query check eliminated ICD10 | CCMDB.accdb | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||
| edit | Query check TISS each day | CCMDB.accdb | declined | complete | hard check | There needs to be at least one TISS entry in CCI Picklist for each day for each ICU profile. | ||
| edit | Query s tmp check combined BL and TRDtTm nonsequential | CCMDB.accdb | retired | complete | hard check | Validates that the combiner integers for Transfer Ready DtTm tmp entry and Boarding Loc are consecutive with the date/time_vals | ||
| edit | Query check CCI TISS matching BoardingLoc time | CCMDB.accdb | implemented | incomplete | hard check | If the Px Date component of a CCI Picklist has a time, then there must be a corresponding Boarding Loc entry | ||
| edit | Query check CCI TISS time means must be two | CCMDB.accdb | declined | complete | soft check | If certain Px Dates have a time component, then there should also be a matching CCI Picklist without the time | ||
| edit | Query check CCI vs LOS count days component | CCMDB.accdb | implemented | complete | hard check | Confirm that CCI Collection Mode or CCI Component CCI collect count days items don't have a count > LOS. | ||
| edit | Query check CCI TISS discontinuous ETT | CCMDB.accdb | implemented | complete | soft check | T22 - ETT Present (TISS Item) should start with an T40 - Insertion of ETT (TISS Item) and end with an T28 - Planned extubation (TISS Item) or T29 - Unplanned extubation (TISS Item). | ||
| edit | Query check CCI vs LOS count days picklist | CCMDB.accdb | implemented | complete | hard check | Confirm that CCI Collection Mode for CCI Picklist CCI collect count days items don't have a count > LOS. | ||
| edit | Query check no consecutive same BL or Service | CCMDB.accdb | implemented | always | hard check | Check that there are no two identical Boarding Locs or Services without a different one with a time stamp in between those two. | ||
| edit | Query check Transfer DtTm after paired BL and before later BL | CCMDB.accdb | implemented | always | not entered | For each pair, the Transfer Ready DtTm tmp entry should never be earlier any Boarding Loc dttm, nor later than the next Boarding Loc | ||
| edit | Query Check BL TR combiner null | CCMDB.accdb | implemented | complete | hard check | Checks that all Boarding Loc / Transfer Ready DtTm tmp entry pairs have a non-null combiner integer. | ||
| edit | Query check ICD10 trach create but no TISS | CCMDB.accdb | implemented | always | hard check | If there is an acquired Tracheostomy creation there also has to be a Trach Tube Present (TISS Item) | ||
| edit | Query check ICD10 trach has trach but no TISS | CCMDB.accdb | implemented | always | soft check | If there is a Tracheostomy, has one (Z93.0) ICD10, there should likely be a T23 - Trach Tube Present (TISS Item) | ||
| edit | Query check CCI Component no admin entries | CCMDB.accdb | implemented | complete | hard check | There must be no No procedure entered/Blank procedure entry in CCI Component. | ||
| edit | Query s tmp EuroSCORE II checks | CCMDB.accdb | implemented | complete | hard check | Each of the two Euroscore II project entries must have one entry and the float_var must be between 0 and 23.99 if RecordStatus is complete | ||
| edit | Query check CCI ICD10 Dialysis no Dx | CCMDB.accdb | implemented | complete | hard check | If a profile has one of the #Dialysis CCI Items there should also be one of the #Dialysis qualifying Dxs. | ||
| edit | Query check tmp BedHeld | CCMDB.accdb | implemented | complete | hard check | Sanity check for BedHeldEnd DtTm | ||
| edit | Query check CCI each count vs LOS | CCMDB.accdb | needs review | complete | soft check | Confirm that a Category:Labs Imaging count is not unreasonably high | ||
| edit | Query s tmp Boarding Loc ER delay reasonable | CCMDB.accdb | implemented | complete | soft check | Flags Boarding Loc entries for ERs where a second Boarding Loc entry exists that is less than 30 min later or more than 67 hours later for CC or more than 144 hrs later for Med | There are many false positives due to ICU delays shorter than 30 mins. Do we want to change anything about that threshold? Discussed with Julie and Lisa today but can't remember the outcome. Ttenbergen 10:58, 2024 April 24 (CDT)
| Task |