Cargo query
Showing below up to 100 results in range #1 to #100.
edit | page | Status | Timing | Firmness | Summary | question | who |
---|---|---|---|---|---|---|---|
edit | page | Status | Timing | Firmness | Summary | question | who |
Date of Birth | implemented | complete | hard check | The minimum age allowed is 10, the maximum age allowed is 120. | |||
Check duplicate patient | implemented | hard check | there are no duplicate entries for the same patient ward admission on the laptop at send time | ||||
Query Check Renal IncompatibleDxs | retired | hard check | can't have ARF and CRF in same record | ||||
Query check ApARF CRF | retired | always | hard check | ARF (APACHE) and CRF - Chronic Renal Failure can not be coded together for the same patient. | |||
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). | |||
Query check overstay not entered | retired | always | hard check | check that all has been entered for the Overstay project | |||
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. | |||
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. | |||
Check organ donors must be dead | not feasible | soft check | organ donors must be deceased | ||||
Check eliminated dx | retired | hard check | disallows any currently entered diagnosis that has been eliminated | ||||
Function Dispo Chronological() | retired | always | hard check | Checks that the registry times are in a sensible chronological order. | |||
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). | |||
Query check long transfer delay | needs review | always | soft check | Is the Transfer Delay (Critical Care) or Transfer Delay (Medicine) unreasonably long? | |||
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 | |||
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 | ||||
Query check CCI Date | implemented | complete | hard check | Px Date must be sensible when compared to first Service tmp entry and Dispo_DtTm | |||
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 | ||||
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. | |||
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. | |||
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" | |||
Query check hernia type vs complication | implemented | hard check | any abdominal hernia complication dx must have an abdominal hernia type dx coded. | ||||
Query check ICD10 mechanism vs trauma | implemented | hard check | Traumas need mechanisms, and mechanisms need traumas (see also Template:ICD10 Guideline Trauma w mechanism). | ||||
Check APACHE physiological variable high low | implemented | hard check and soft check | an APACHE physiological variable is extremely high or low | ||||
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. | ||||
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. | ||||
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. | ||||
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. | ||||
Query check AIDS vs HIV | implemented | always | hard check | A record can not have both AIDS (disease due to HIV) and HIV infection, asymptomatic | |||
Query check ICD10 trach dxs consistent | implemented | hard check | Tracheostomy related CCI and ICD10 codes must be consistent with each other. | ||||
Query check minimal data set incomplete | implemented | always | hard check | makes sure the Minimal Data Set is collected before records can be sent. | |||
Query check overstay no colour | retired | always | hard check | Med pts must have Overstay colours | |||
Query check overstay pt from our med | retired | always | hard check | pts from a location where we collect should not have Overstay colour | |||
Function Validate Pre admit Inpatient Institution | implemented | hard check | validates Pre-admit Inpatient Institution field:
| ||||
Function Validate Previous Location | implemented | hard check | validates Previous Location field:
| ||||
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". | ||||
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. | ||||
Function Validate previous service | retired | always | hard check | Validates Previous Service field: can't be empty/blank | |||
Query check pt from ER | implemented | always | soft check | part of validating Boarding Loc | |||
Query check tmp generate allowed | implemented | always | hard check | check that tmp project/item combo exists for this location for a project | |||
Query check trach dx task | retired | always | hard check | make sure Trach Task is entered correctly | |||
Query s tmp ACP | retired | always | hard check | error if ACP Status collection in ICU is missing part of the entry. | |||
Query s tmp project item consistent | implemented | hard check | Checks that tmp project entries only contain combinations of project and item that are allowed. | ||||
Query s tmp QAInf basic | retired | always | hard check | checks that none of int, float, bool fields are used in this data. | |||
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. | ||||
Query s tmp QAInf dx no tmp | retired | always | hard check | If Complication Diagnosis is one of:
then there has to be a
| |||
Query s tmp QAInf tmp no dx | retired | always | hard check | If "QAInf" entry is present in L_TmpV2 then
| |||
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. | |||
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 | ||||
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 | ||||
Function Validate PHIN | implemented | hard check |
| ||||
Function PHIN same as Chart | implemented | hard check | |||||
Function Validate Chart | implemented | hard check | validates the Chart number:
| ||||
Function Validate Province | implemented | hard check | Validates the Province field:
| ||||
Function Validate Dispo | implemented | complete | hard check | doesn't allow empty | |||
Function Validate Transfer Ready DtTm | retired | complete | hard check | doesn't allow violation of function Transfer_Ready_DtTm_vs_status | |||
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. | |||
Query check CCI component 1 and 2 compatible | implemented | complete | hard check | Component CCIs must have compatible component 1 and component 2 | |||
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 checks have to consider that table) | If from OR or PACU, must have at least 1 CCI Procedure other than No procedure performed | ||||
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 | |||
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. | ||||
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 | |||
Query check ICD10 unfilled | implemented | complete | hard check | ICD10 entry with missing Dx_Type, Dx_Priority or No Dx Entered | |||
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. | |||
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). | |||
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 | |||
Query check CCI Picklist unfilled | implemented | complete | hard check | CCI Picklist entry with missing px, Px_Type or Px_Count | |||
Query check CCI Component unfilled | implemented | complete | hard check | CCI Component entry with missing px, Px_Type or Px_Count | |||
Query check CCI Component duplicates | implemented | complete | hard check | No duplication of CCI Component Px_Type, Px_Date | |||
Query check CCI Picklist duplicates | implemented | complete | hard check | No duplication of CCI Picklist Px_Type, Px_Date, Px_Count | |||
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 | |||
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. | |||
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) | |||
Check pre acute consistent | declined | complete | soft check | consistency of Pre acute living situation; Dispo; Postal Code and Previous Location | |||
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 | |||
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 | |||
Can't check ICD10 ARF vs APACHE ARF | declined | always | hard check | Can't have ESRD and acute renal failure | |||
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 | |||
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 | |||
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. | |||
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. | |||
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. | |||
Check Function Validate PostalCode | implemented | complete | hard check | Validates that Postal Code field only contains characters in format allowed for a postal code | |||
Check function Validate Last name | implemented | hard check |
| ||||
Check function Validate First name | implemented | always | hard check |
| |||
Check function location NE dispo | implemented | complete | hard check | Service/Location field can't be same as Dispo field | |||
Check function preAdmit NE Location | implemented | complete | hard check | Pre-admit Inpatient Institution field can't be same as Service/Location field | |||
Check function previous NE Location | implemented | complete | hard check | Previous Location field can't be same as Service/Location field | |||
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. | ||||
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" | ||||
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, | |||
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. | |||
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). | |||
Check function Validate Pre Acute Living Situation | implemented | complete | hard check | can't be blank | |||
Query check VAP admit must be from ICU | retired | complete | hard check | VAP should only be Admit Diagnosis when Previous Location is an ICU. | |||
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. | |||
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. | |||
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. | |||
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)) | |||
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 | ||||
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 |
{{#cargo_query: tables=DataIntegrityChecks,Discussions,_pageData |fields=CONCAT("\[\{\{fullurl:",DataIntegrityChecks._pageName, "|action=edit\}\} edit]")=edit, DataIntegrityChecks._pageName=page, Status, Timing, Firmness, Summary, question, who |where=App="CCMDB.accdb" |join on=DataIntegrityChecks._pageName=_pageData._pageName,DataIntegrityChecks._pageName=Discussions._pageName |order by=question |format=dynamic table |offset=0 |limit=100 |more results text=see all checks |default=Nothing found |rows per page=1000 }}