CCMDB.accdb Data Integrity Checks: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 11: | Line 11: | ||
|fields= | |fields= | ||
CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit, | CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit, | ||
DataIntegrityChecks._pageName=page | DataIntegrityChecks._pageName=page, Status, Timing, Firmness, Summary, question, who | ||
|where=App="CCMDB.accdb" and (Status<>"retired" and Status<>"declined") | |where=App="CCMDB.accdb" and (Status<>"retired" and Status<>"declined") | ||
|order by=question | |order by=question | ||
| Line 27: | Line 27: | ||
|fields= | |fields= | ||
CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit, | CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "{{!}}action=edit\}\} edit]")=edit, | ||
DataIntegrityChecks._pageName=page | DataIntegrityChecks._pageName=page, Status, Timing, Firmness, Summary, question, who | ||
|where=App="CCMDB.accdb" | |where=App="CCMDB.accdb" | ||
|order by=question | |order by=question | ||
| Line 39: | Line 39: | ||
== Related articles == | == Related articles == | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Data Integrity Checks| *]] | [[Category: Data Integrity Checks| *]] | ||
Revision as of 12:55, 15 September 2021
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 | Status | Timing | Firmness | Summary | question | who | ||
|---|---|---|---|---|---|---|---|---|---|
| edit | page | Status | Timing | Firmness | Summary | question | who | ||
| edit | Date of Birth | implemented | complete | hard check | The minimum age allowed is 10, the maximum age allowed is 120. | ||||
| edit | Check duplicate patient | implemented | hard check | there are no duplicate entries for the same patient ward admission on the laptop at send time | |||||
| edit | Query check CCI ICD10 Dialysis no Dx | 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 CCI TISS Pharm Vasoactive | 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 | not feasible | soft check | organ donors must be deceased | |||||
| edit | Function long LOS() | 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 CCI each count vs LOS | needs review | complete | soft check | Confirm that a Category:Labs Imaging count is not unreasonably high | ||||
| edit | Query check long transfer delay | 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 | 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 | 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 | 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 | 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 | implemented | hard check | any abdominal hernia complication dx must have an abdominal hernia type dx coded. | |||||
| edit | Query check ICD10 mechanism vs trauma | 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 | 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 | 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 | 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 | 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 | 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 | 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 | implemented | hard check | Tracheostomy related CCI and ICD10 codes must be consistent with each other. | |||||
| edit | Query check minimal data set incomplete | implemented | always | hard check | makes sure the Minimal Data Set is collected before records can be sent. | ||||
| edit | Function Validate Pre admit Inpatient Institution | implemented | hard check | validates Pre-admit Inpatient Institution field:
| |||||
| edit | Function Validate Previous Location | implemented | hard check | validates Previous Location field:
| |||||
| edit | Query check prev pre-admit consistent | 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 | implemented | always | soft check | part of validating Boarding Loc | ||||
| edit | Query check tmp generate allowed | implemented | always | hard check | check that tmp project/item combo exists for this location for a project | ||||
| edit | Query s tmp project item consistent | 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 | 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 | 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 | implemented | hard check | CC pt has QA Septic Shock tmp entry and no Septic Shock/Shock, septic dx | |||||
| edit | Function Validate PHIN | implemented | hard check |
| |||||
| edit | Function PHIN same as Chart | implemented | hard check | PHIN can't be the same as Chart | |||||
| edit | Function Validate Chart | implemented | hard check | validates the Chart number:
| |||||
| edit | Function Validate Province | implemented | hard check | Validates the Province field:
| |||||
| edit | Function Validate Dispo | implemented | complete | hard check | doesn't allow empty | ||||
| edit | Query check CCI component 1 and 2 compatible | implemented | complete | hard check | Component CCIs must have compatible component 1 and component 2 | ||||
| edit | Query check CCI from OR no CCI | 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 check]]s 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 | 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 | 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 | 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 | implemented | complete | hard check | ICD10 entry with missing Dx_Type, Dx_Priority or No Dx Entered | ||||
| edit | Query check ICD10 Comorbids Dx present | 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 | 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 | implemented | complete | hard check | CCI Picklist entry with missing px, Px_Type or Px_Count | ||||
| edit | Query check CCI Component unfilled | implemented | complete | hard check | CCI Component entry with missing px, Px_Type or Px_Count | ||||
| edit | Query check CCI Component duplicates | implemented | complete | hard check | No duplication of CCI Component Px_Type, Px_Date | ||||
| edit | Query check CCI Picklist duplicates | implemented | complete | hard check | No duplication of CCI Picklist Px_Type, Px_Date, Px_Count | ||||
| edit | Query check CCI if no then none | 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 | implemented | complete | hard check | There must be no No procedure entered/Blank procedure entry in CCI Picklist. | ||||
| edit | Query check CCI must have entry | 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 | 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 | 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 | 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 | 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 | implemented | hard check |
| |||||
| edit | Check function Validate First name | implemented | always | hard check |
| ||||
| edit | Check function location NE dispo | implemented | complete | hard check | Service/Location field can't be same as Dispo field | ||||
| edit | Check function preAdmit NE Location | implemented | complete | hard check | Pre-admit Inpatient Institution field can't be same as Service/Location field | ||||
| edit | Check function previous NE Location | implemented | complete | hard check | Previous Location field can't be same as Service/Location field | ||||
| edit | Check Sub PharmCheck | 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 | 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 | implemented | complete | hard check | can't be blank | ||||
| edit | Query check CCI TISS Intubation vs Intubated | 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 | implemented | always | hard check | A patient is discharged to IICU and does not have an IICU consult entry. | ||||
| edit | Sub Dx Checker | 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 | 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 | 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 | 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 | not feasible | complete | hard check | Can't have Project Borrow arrive on own unit | ||||
| edit | Query send check centralized is owner | 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 | 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 | implemented | complete | hard check | Validates entries for Boarding Loc | ||||
| edit | Query check tmp service or location duplicate | 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 | 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 | 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 | 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 | 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 | 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 | 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 Boarding Loc and TransferReadyDtTm pairs | 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 | 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 | 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 | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||||
| edit | Query check eliminated CCI Pick | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||||
| edit | Query check eliminated ICD10 | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||||
| edit | Query check CCI TISS matching BoardingLoc time | 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 | 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 | 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 | 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 | 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 s tmp Boarding Loc ER delay reasonable | 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 | ||||
| edit | Query check Transfer DtTm after paired BL and before later BL | 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 | 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 | 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 | 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 tmp BedHeld | implemented | complete | hard check | Sanity check for BedHeldEnd DtTm | ||||
| edit | Query check CCI Component no admin entries | implemented | complete | hard check | There must be no No procedure entered/Blank procedure entry in CCI Component. | ||||
| edit | Query s tmp EuroSCORE II checks | 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 s tmp AHC consistent | implemented | complete | hard check | Checks for Project AHC (LAU) | ||||
| edit | Query check LAU collection readmission data | implemented | complete | hard check | dates must make sense | ||||
| edit | Query check ACP Status Collection | implemented | complete | hard check | every LAU Collection Project must have an entry, and the date must make sense | ||||
| edit | Query check Project Consults data | implemented | complete | hard check | every LAU Collection Project must have an entry, and the date must make sense | ||||
| edit | Query check Project OT PT Consults | implemented | complete | hard check | every LAU OT/PT consults must have an entry, and the date must make sense | ||||
| edit | Query s tmp MR | needs review | complete | hard check | Checks for Project MR | ||||
| edit | Function Validate DOB | implemented | always | hard check | doesn't allow empty, or younger than 10 or older than 120 | ||||
| edit | Query Check from ED and prev location same site | ready to implement | always | soft check | A patient would not usually be sent from their own site to their own ED. It can happen, so this is a soft check. | ||||
| edit | Query check tmp AHC | needs review | complete | hard check | For patients with Previous Location ER at same site there should be a Boarding Loc ER. |
| Lisa | ||
| edit | Query check has transfer ready date or checkbox | implemented | complete | not entered | Each Transfer Ready DtTm tmp entry has to have either a dttm, or its checkbox checked. |
| Tina | ||
| edit | Query s tmp check combined Boarding Loc and TransferReadyDtTm | 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. |
| Tina | ||
| edit | Query check tmp AHC | needs review | complete | hard check | For patients with Previous Location ER at same site there should be a Boarding Loc ER. |
| Lisa | ||
| edit | Query Check VADT too close to first boarding loc | needs review | always | soft check | no idea hope JM or LK remember |
| Lisa | ||
| edit | Query check tmp Overstay2 | needs review | complete | hard check | Not yet filled in | others? | Julie | ||
| edit | Query Check VADT too close to first boarding loc | needs review | always | soft check | no idea hope JM or LK remember | We discussed this in our after-Task meeting 2023-07-23 and I just stumbled across it. I do not remember what this was about, nor what a reasonable delay would be. Could one of you fill in the details for the query if we still want it? No hurry. In fact I'd prefer if you not hurried ;-). Ttenbergen 21:38, 13 August 2025 (CDT)
| Julie |
All checks =
| edit | page | Status | Timing | Firmness | Summary | question | who | ||
|---|---|---|---|---|---|---|---|---|---|
| edit | page | Status | Timing | Firmness | Summary | question | who | ||
| edit | Date of Birth | implemented | complete | hard check | The minimum age allowed is 10, the maximum age allowed is 120. | ||||
| edit | Check duplicate patient | 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 | retired | hard check | can't have ARF and CRF in same record | |||||
| edit | Query check ApARF CRF | retired | always | hard check | ARF (APACHE) and CRF - Chronic Renal Failure can not be coded together for the same patient. | ||||
| edit | Query check CCI ICD10 Dialysis no Dx | 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 TISS Errors NrTISSDays NE LOS | 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 | retired | always | hard check | check that all has been entered for the Overstay project | ||||
| edit | Query check CCI TISS Pharm Vasoactive | 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 | 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 | not feasible | soft check | organ donors must be deceased | |||||
| edit | Check eliminated dx | retired | hard check | disallows any currently entered diagnosis that has been eliminated | |||||
| edit | Function Dispo Chronological() | retired | always | hard check | Checks that the registry times are in a sensible chronological order. | ||||
| edit | Function long LOS() | 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 CCI each count vs LOS | needs review | complete | soft check | Confirm that a Category:Labs Imaging count is not unreasonably high | ||||
| edit | Query check long transfer delay | needs review | always | soft check | Is the Transfer Delay (Critical Care) or Transfer Delay (Medicine) unreasonably long? | ||||
| edit | Controlling Dx Type for ICD10 codes | 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 | 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 | 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 | 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 | 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 | 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 | 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 | implemented | hard check | any abdominal hernia complication dx must have an abdominal hernia type dx coded. | |||||
| edit | Query check ICD10 mechanism vs trauma | 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 | 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 | 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 | 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 | 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 | 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 | 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 | implemented | hard check | Tracheostomy related CCI and ICD10 codes must be consistent with each other. | |||||
| edit | Query check minimal data set incomplete | implemented | always | hard check | makes sure the Minimal Data Set is collected before records can be sent. | ||||
| edit | Query check overstay no colour | retired | always | hard check | Med pts must have Overstay colours | ||||
| edit | Query check overstay pt from our med | retired | always | hard check | pts from a location where we collect should not have Overstay colour | ||||
| edit | Function Validate Pre admit Inpatient Institution | implemented | hard check | validates Pre-admit Inpatient Institution field:
| |||||
| edit | Function Validate Previous Location | implemented | hard check | validates Previous Location field:
| |||||
| edit | Query check previous location vs service inconsistent | 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 | 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 | retired | always | hard check | Validates Previous Service field: can't be empty/blank | ||||
| edit | Query check pt from ER | implemented | always | soft check | part of validating Boarding Loc | ||||
| edit | Query check tmp generate allowed | implemented | always | hard check | check that tmp project/item combo exists for this location for a project | ||||
| edit | Query check trach dx task | retired | always | hard check | make sure Trach Task is entered correctly | ||||
| edit | Query s tmp ACP | always | hard check | error if ACP Status Collection is missing part of the entry. | |||||
| edit | Query s tmp project item consistent | implemented | hard check | Checks that tmp project entries only contain combinations of project and item that are allowed. | |||||
| edit | Query s tmp QAInf basic | retired | always | hard check | checks that none of int, float, bool fields are used in this data. | ||||
| edit | Query s tmp apostrophe in comment | 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 | retired | always | hard check | If Complication Diagnosis is one of:
then there has to be a
| ||||
| edit | Query s tmp QAInf tmp no dx | retired | always | hard check | If "QAInf" entry is present in L_TmpV2 then
| ||||
| edit | Query s tmp QAInf LT 48 hrs after admit | 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 | 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 | implemented | hard check | CC pt has QA Septic Shock tmp entry and no Septic Shock/Shock, septic dx | |||||
| edit | Function Validate PHIN | implemented | hard check |
| |||||
| edit | Function PHIN same as Chart | implemented | hard check | PHIN can't be the same as Chart | |||||
| edit | Function Validate Chart | implemented | hard check | validates the Chart number:
| |||||
| edit | Function Validate Province | implemented | hard check | Validates the Province field:
| |||||
| edit | Function Validate Dispo | implemented | complete | hard check | doesn't allow empty | ||||
| edit | Function Validate Transfer Ready DtTm | retired | complete | hard check | doesn't allow violation of function Transfer_Ready_DtTm_vs_status | ||||
| edit | Function Transfer Ready DtTm vs status | 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 | implemented | complete | hard check | Component CCIs must have compatible component 1 and component 2 | ||||
| edit | Query check CCI from OR no CCI | 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 check]]s 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 | 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 | 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 | 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 | implemented | complete | hard check | ICD10 entry with missing Dx_Type, Dx_Priority or No Dx Entered | ||||
| edit | Query check ICD10 duplicates | 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 | 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 | 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 | implemented | complete | hard check | CCI Picklist entry with missing px, Px_Type or Px_Count | ||||
| edit | Query check CCI Component unfilled | implemented | complete | hard check | CCI Component entry with missing px, Px_Type or Px_Count | ||||
| edit | Query check CCI Component duplicates | implemented | complete | hard check | No duplication of CCI Component Px_Type, Px_Date | ||||
| edit | Query check CCI Picklist duplicates | implemented | complete | hard check | No duplication of CCI Picklist Px_Type, Px_Date, Px_Count | ||||
| edit | Query check CCI if no then none | 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 | implemented | complete | hard check | There must be no No procedure entered/Blank procedure entry in CCI Picklist. | ||||
| edit | Query check CCI must have entry | 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 | 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 | 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 | declined | always | hard check | Can't have ESRD and acute renal failure | ||||
| edit | Query check ICD10 ESRD vs kidney transplant | 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 | 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 | 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 | 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 | retired | complete | hard check | Either Accept DtTm field must have content or Accept DtTm missing field must be checked. | ||||
| edit | Check Function Validate PostalCode | 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 | implemented | hard check |
| |||||
| edit | Check function Validate First name | implemented | always | hard check |
| ||||
| edit | Check function location NE dispo | implemented | complete | hard check | Service/Location field can't be same as Dispo field | ||||
| edit | Check function preAdmit NE Location | implemented | complete | hard check | Pre-admit Inpatient Institution field can't be same as Service/Location field | ||||
| edit | Check function previous NE Location | implemented | complete | hard check | Previous Location field can't be same as Service/Location field | ||||
| edit | Check Accept Loc Park | 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 | 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 | 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 | 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 | 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 | implemented | complete | hard check | can't be blank | ||||
| edit | Query check VAP admit must be from ICU | retired | complete | hard check | VAP should only be Admit Diagnosis when Previous Location is an ICU. | ||||
| edit | Query check CCI TISS Intubation vs Intubated | 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 | 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 | 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 | 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 | 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 | 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 | 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 | retired | always | hard check | Only one entry allowed per patient. | ||||
| edit | Query s tmp ABO TEE checks | 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 | 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 | not feasible | complete | hard check | Can't have Project Borrow arrive on own unit | ||||
| edit | Query s tmp Borrow duplicates | 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 | retired | complete | hard check | Checks that data for Project Borrow arrive follows that project's | ||||
| edit | Query NDC Dialysis TISS CCI | 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 | 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 | 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 | declined | hard check | Stroke, NOS can not be coded with other stroke codes. | |||||
| edit | Query s tmp Boarding Loc date item | implemented | complete | hard check | Validates entries for Boarding Loc | ||||
| edit | Query s tmp Boarding Loc no borrow but entry | retired | complete | hard check | Validates entries for Boarding Loc | ||||
| edit | Query check tmp service or location duplicate | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 Boarding Loc and TransferReadyDtTm pairs | 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 | 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 | 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 | 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 | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||||
| edit | Query check eliminated CCI Pick | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||||
| edit | Query check eliminated ICD10 | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||||
| edit | Query check TISS each day | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 s tmp Boarding Loc ER delay reasonable | 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 | ||||
| edit | Query check Transfer DtTm after paired BL and before later BL | 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 | 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 | 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 | 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 tmp BedHeld | implemented | complete | hard check | Sanity check for BedHeldEnd DtTm | ||||
| edit | Query check CCI Component no admin entries | implemented | complete | hard check | There must be no No procedure entered/Blank procedure entry in CCI Component. | ||||
| edit | Query s tmp EuroSCORE II checks | 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 s tmp AHC consistent | implemented | complete | hard check | Checks for Project AHC (LAU) | ||||
| edit | Query check LAU collection readmission data | implemented | complete | hard check | dates must make sense | ||||
| edit | Query check ACP Status Collection | implemented | complete | hard check | every LAU Collection Project must have an entry, and the date must make sense | ||||
| edit | Query check Project Consults data | implemented | complete | hard check | every LAU Collection Project must have an entry, and the date must make sense | ||||
| edit | Query check Project OT PT Consults | implemented | complete | hard check | every LAU OT/PT consults must have an entry, and the date must make sense | ||||
| edit | Query s tmp MR | needs review | complete | hard check | Checks for Project MR | ||||
| edit | Function Validate DOB | implemented | always | hard check | doesn't allow empty, or younger than 10 or older than 120 | ||||
| edit | Query Check from ED and prev location same site | ready to implement | always | soft check | A patient would not usually be sent from their own site to their own ED. It can happen, so this is a soft check. | ||||
| edit | Query check tmp AHC | needs review | complete | hard check | For patients with Previous Location ER at same site there should be a Boarding Loc ER. |
| Lisa | ||
| edit | Query check has transfer ready date or checkbox | implemented | complete | not entered | Each Transfer Ready DtTm tmp entry has to have either a dttm, or its checkbox checked. |
| Tina | ||
| edit | Query s tmp check combined Boarding Loc and TransferReadyDtTm | 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. |
| Tina | ||
| edit | Query check tmp AHC | needs review | complete | hard check | For patients with Previous Location ER at same site there should be a Boarding Loc ER. |
| Lisa | ||
| edit | Query Check VADT too close to first boarding loc | needs review | always | soft check | no idea hope JM or LK remember |
| Lisa | ||
| edit | Check pre acute consistent | declined | complete | soft check | consistency of Pre acute living situation; Dispo; Postal Code and Previous Location | JALT
| all | ||
| edit | Query check tmp Overstay2 | needs review | complete | hard check | Not yet filled in | others? | Julie | ||
| edit | Query Check VADT too close to first boarding loc | needs review | always | soft check | no idea hope JM or LK remember | We discussed this in our after-Task meeting 2023-07-23 and I just stumbled across it. I do not remember what this was about, nor what a reasonable delay would be. Could one of you fill in the details for the query if we still want it? No hurry. In fact I'd prefer if you not hurried ;-). Ttenbergen 21:38, 13 August 2025 (CDT)
| Julie |