CCMDB.accdb Data Integrity Checks: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 5: Line 5:
See [[Template:Data Integrity Check]] for how to get things on this list.  
See [[Template:Data Integrity Check]] for how to get things on this list.  


== Checks currently requiring action
== Checks currently requiring action ===
{{#cargo_query:
{{#cargo_query:
tables=DataIntegrityChecks,Discussions,_pageData
tables=DataIntegrityChecks,Discussions,_pageData

Revision as of 16:09, 2021 October 7

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.

Checks currently requiring action =

edit page Coding Status Timing Firmness Summary question who
edit page Coding Status Timing Firmness Summary question who
edit Date of Birth function ''Validate_DOB'' implemented complete hard check The minimum age allowed is 10, the maximum age allowed is 120.
edit Check duplicate patient functions ''has_multiples()'' and ''overlap()'' and query ''Check_pt_multiples'' 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 query ''Check Renal IncompatibleDxs'' retired hard check can't have ARF and CRF in same record
edit Query check ApARF CRF 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 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 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 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 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 query ''s_tmp_BRR_DX_inconsistent'' 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 check_eliminated_dx retired hard check disallows any currently entered diagnosis that has been eliminated
edit Function Dispo Chronological() Function Dispo_Chronological() retired always hard check Checks that the registry times are in a sensible chronological order.
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 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 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 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 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 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 query check_ICD10_PrDx_Awaiting_but_not_transferReady 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 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 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 functions ''validate_x'', function ''Min_Max_Checker'' 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 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 query ''check_ICD10_Inf_Infection_w_implied_must_not_have_pathogen'' 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 query ''check_ICD10_Inf_Pathogens_must_have_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 query ''check_ICD10_Inf_Antibiotic_resistance_must_have_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 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 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 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 query ''check_overstay_no_colour'' retired always hard check Med pts must have Overstay colours
edit Query check overstay pt from our med 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 Function ''Validate_Pre_admit_Inpatient_Institution'', [[Check function preAdmit NE Location]] implemented hard check validates Pre-admit Inpatient Institution field:
edit Function Validate Previous Location Function Validate Previous Location implemented hard check validates Previous Location field:
  • Can not be blank
  • function previous_NE_Location() - Previous Location field can't be same as Service/Location field
  • edit Query check previous location vs service inconsistent function ''previous_location_vs_service_inconsistent'', 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 function ''prev_pre_admit_consistent'', 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 function ''Validate_previous_service '' retired always hard check Validates Previous Service field: can't be empty/blank
    edit Query check pt from ER function from_ER(); query ''check_pt_from_ER'' implemented always soft check part of validating Boarding Loc
    edit Query check tmp generate allowed query ''check tmp generate allowed'', Sub ''GenerUpdate_tmp_entry'' implemented always hard check check that tmp project/item combo exists for this location for a project
    edit Query check trach dx task query ''check trach dx task'' retired always hard check make sure Trach Task is entered correctly
    edit Query s tmp ACP query ''s_tmp_ACP '' retired always hard check error if ACP Status collection in ICU is missing part of the entry.
    edit Query s tmp project item consistent [[Function TmpChecker]], 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 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 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 Query s_tmp_QAInf_dx_no_tmp retired always hard check If Complication Diagnosis is one of:
  • Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)
  • Pneumonia, ventilator-associated (VAP)
  • then there has to be a

    • L_TmpV2 entry with project "ICU Infection Audit"
    edit Query s tmp QAInf tmp no dx Query s tmp QAInf dx no tmp retired always hard check If "QAInf" entry is present in L_TmpV2 then
  • program must be "CC"
  • the corresponding diagnosis must exist
  • edit Query s tmp QAInf LT 48 hrs after admit 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 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 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
  • for patients with Province = MB, the PHIN has to be (> 100 000 000 and <= 130 000 000) or 999 999 999 (to accommodate PHIN_field#Location_Manitoba_and_no_PHIN
  • for out-of-province patients, the PHIN must be entered as blank
  • checks Function PHIN same as Chart
  • edit Function PHIN same as Chart implemented hard check PHIN can't be the same as Chart
    edit Function Validate Chart Function &#039;&#039;Validate_Chart&#039;&#039; implemented hard check validates the Chart number:
  • Chart must be numerical
  • chart must be
  • checks Function PHIN same as Chart
  • no further checks at this time because chart numbers are different at different hospitals
  • edit Function Validate Province function &#039;&#039;Validate_Province&#039;&#039; implemented hard check Validates the Province field:
  • can't be left blank
  • must not fail function Validate_PHIN
  • edit Function Validate Dispo function &#039;&#039;Validate Dispo&#039;&#039; implemented complete hard check doesn't allow empty
    edit Function Validate Transfer Ready DtTm function &#039;&#039;Validate_Transfer_Ready_DtTm&#039;&#039; retired complete hard check doesn't allow violation of function Transfer_Ready_DtTm_vs_status
    edit Function Transfer Ready DtTm vs status function &#039;&#039;Transfer_Ready_DtTm_vs_status&#039;&#039; 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 query &#039;&#039;Check_CCI_component_1_and_2_compatible&#039;&#039; implemented complete hard check Component CCIs must have compatible component 1 and component 2
    edit Query check CCI from OR no CCI query &#039;&#039;check_CCI_from_OR_no_CCI&#039;&#039; 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 query &#039;&#039;check_dx_primary_not_exactly_one&#039;&#039; 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 query &#039;&#039;check_dx_primary_lowest_priority&#039;&#039; 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 query &#039;&#039;check_ICD10_date&#039;&#039; 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 query &#039;&#039;check_ICD10_unfilled&#039;&#039; implemented complete hard check ICD10 entry with missing Dx_Type, Dx_Priority or No Dx Entered
    edit Query check ICD10 duplicates query &#039;&#039;check_ICD10_duplicates&#039;&#039; 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 query &#039;&#039;check_ICD10_Comorbids_Dx_present&#039;&#039; 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 query &#039;&#039;check_ICD10_Comorbids_NoComo_code_but_others&#039;&#039; 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 query &#039;&#039;check_CCI_Picklist_unfilled&#039;&#039; implemented complete hard check CCI Picklist entry with missing px, Px_Type or Px_Count
    edit Query check CCI Component unfilled query &#039;&#039;check_CCI_Component_unfilled&#039;&#039; implemented complete hard check CCI Component entry with missing px, Px_Type or Px_Count
    edit Query check CCI Component duplicates query &#039;&#039;check_CCI_Component_duplicates&#039;&#039; implemented complete hard check No duplication of CCI Component Px_Type, Px_Date
    edit Query check CCI Picklist duplicates query &#039;&#039;check_CCI_Picklist_duplicates&#039;&#039; implemented complete hard check No duplication of CCI Picklist Px_Type, Px_Date, Px_Count
    edit Query check CCI if no then none query &#039;&#039;check_CCI_if_no_then_none&#039;&#039; 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 query &#039;&#039;check_CCI_Picklist_if_no_admin_entries&#039;&#039; implemented complete hard check There must be no No procedure entered/Blank procedure entry in CCI Picklist.
    edit Query check CCI must have entry query &#039;&#039;check_CCI_must_have_entry&#039;&#039; 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 query &#039;&#039;&#039;check pre acute consistent&#039;&#039;&#039; declined complete soft check consistency of Pre acute living situation; Dispo; Postal Code and Previous Location
    edit Query check ICD10 ESRD vs ARF query &#039;&#039;check_ICD10_ESRD_vs_ARF&#039;&#039; 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 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 not feasible to implement declined always hard check Can't have ESRD and acute renal failure
    edit Query check ICD10 ESRD vs kidney transplant 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 query &#039;&#039;check_CCI_CRRT_vs_Tmp&#039;&#039; 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 function &#039;&#039;Panelling_admit_transfer_same&#039;&#039; 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 query &#039;&#039;check_dispo_lower_acuity_than_location&#039;&#039; and function &#039;&#039;Transfer_Ready_DtTm_vs_Location_vs_Dispo&#039;&#039; 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 function Validate_Accept_DtTm() retired complete hard check Either Accept DtTm field must have content or Accept DtTm missing field must be checked.
    edit Check Function Validate PostalCode Function &#039;&#039;Validate_PostalCode&#039;&#039; 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 function &#039;&#039;Validate_Last_name&#039;&#039; implemented hard check
  • can't be blank
  • can't start with a space
  • can't start with a hyphen
  • only allows letters, spaces and hyphens
  • edit Check function Validate First name function &#039;&#039;Validate_First_name&#039;&#039; implemented always hard check
  • can't be blank
  • can't start with a space
  • can't start with a hyphen
  • only allows letters, spaces and hyphens
  • edit Check function location NE dispo location_NE_dispo() which calls query &#039;&#039;Check_Location_NE_Dispo&#039;&#039; implemented complete hard check Service/Location field can't be same as Dispo field
    edit Check function preAdmit NE Location 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 function previous_NE_Location() implemented complete hard check Previous Location field can't be same as Service/Location field
    edit Check Accept Loc Park query &#039;&#039;s_tmp_Accept_Log_Park_prev_no_tmp&#039;&#039; 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 query &#039;&#039;s_tmp_Accept_Log_Park_tmp_no_prev&#039;&#039; 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 Sub &#039;&#039;PharmCheck&#039;&#039; 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 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 query &#039;&#039;check_ICD10_CLI_vs_CCI_CentralLine&#039;&#039; 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 function Validate_Pre_Acute_Living_Situation implemented complete hard check can't be blank
    edit Query check VAP admit must be from ICU query &#039;&#039;check_VAP_admit_must_be_from_ICU&#039;&#039; retired complete hard check VAP should only be Admit Diagnosis when Previous Location is an ICU.
    edit Query check CCI TISS Intubation vs Intubated query &#039;&#039;check_CCI_TISS_Intubation_vs_Intubated&#039;&#039; 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 query &#039;&#039;s_tmp_IICU_consult_DtTm&#039;&#039; 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 query &#039;&#039;s_tmp_IICU_consult_dispo_to_IICU_but_no_tmp&#039;&#039; 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 query &#039;&#039;check_CCI_TISS_spont_breath_no_tube&#039;&#039; 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 Sub &#039;&#039;Dx_Checker&#039;&#039; 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 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 query &#039;&#039;check_CCI_TISS_CAM_positive_vs_Dx&#039;&#039; 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 query &#039;&#039;s_tmp_comfort_care_gt_one&#039;&#039; retired always hard check Only one entry allowed per patient.
    edit Query s tmp ABO TEE checks query &#039;&#039;s_tmp_ABO_TEE_checks&#039;&#039; 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 query &#039;&#039;check_CCI_TISS_Vented_without_mechanism&#039;&#039; 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 entered not feasible complete hard check Can't have Project Borrow arrive on own unit
    edit Query s tmp Borrow duplicates query &#039;&#039;s_tmp_Borrow_duplicates&#039;&#039; 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 query &#039;&#039;s_tmp_Borrow_sensible_DtTm_vs_no_borrow&#039;&#039; retired complete hard check Checks that data for Project Borrow arrive follows that project's
    edit Query NDC Dialysis TISS CCI Query &#039;&#039;NDC_Dialysis_TISS_CCI&#039;&#039; 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 Query &#039;&#039;send_check_centralized_is_owner&#039;&#039; 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 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 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 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 query s_tmp_Boarding_Loc_no_borrow_but_entry retired complete hard check Validates entries for Boarding Loc
    edit Query check has transfer ready date or checkbox 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.
    edit Query check tmp service or location duplicate query &#039;&#039;check_tmp_service_or_location_duplicate&#039;&#039; 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 query &#039;&#039;check_tmp_service_and_program_consistency&#039;&#039; 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 query &#039;&#039;check_tmp_Service_and_Boarding_Loc_during_admission_timeframe&#039;&#039; 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 query &#039;&#039;check_tmp_ER_Boarding_Loc_should_exist_if_from_ER&#039;&#039;; function from_ER(); query &#039;&#039;check_pt_from_ER&#039;&#039; 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 query &#039;&#039;check_CCI_TISS_if_no_then_none&#039;&#039; 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 query &#039;&#039;check_CCI_TISS_NrDays_GT_LOS&#039;&#039; 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 query &#039;&#039;check_CCI_TISS_NrDays_LT_LOS&#039;&#039; 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 query &#039;&#039;check_transfer_DtTm_during_admission&#039;&#039; 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 query &#039;&#039;check_transfer_ready_tmp_for_each_Boarding_Loc&#039;&#039; 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 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.
    edit Query s tmp check Boarding Loc and TransferReadyDtTm pairs 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 query &#039;&#039;check_tmp_Boarding_Loc_Service_first_same&#039;&#039; 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 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 Query &#039;&#039;check_tmp_2_BL_TR_S_same_tm&#039;&#039; 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 query &#039;&#039;check_eliminated_CCI_Comp&#039;&#039; implemented hard check disallows any currently entered diagnosis that has been eliminated
    edit Query check eliminated CCI Pick query &#039;&#039;check_eliminated_CCI_Pick&#039;&#039; implemented hard check disallows any currently entered diagnosis that has been eliminated
    edit Query check eliminated ICD10 query &#039;&#039;check_eliminated_ICD10&#039;&#039; implemented hard check disallows any currently entered diagnosis that has been eliminated
    edit Query check TISS each day Query &#039;&#039;check_TISS_each_day&#039;&#039; 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 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 query &#039;&#039;check_CCI_TISS_matching_BoardingLoc_time&#039;&#039; 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 query &#039;&#039;check_CCI_TISS_time_means_must_be_two&#039;&#039; 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 query &#039;&#039;check_CCI_vs_LOS_count_days_component&#039;&#039; 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 query &#039;&#039;check_CCI_TISS_discontinuous_ETT&#039;&#039; 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 query &#039;&#039;check_CCI_vs_LOS_count_days_picklist&#039;&#039; 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 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 query &#039;&#039;s_tmp_Boarding_Loc_ER_delay_reasonable&#039;&#039; 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 73 hrs later for Med
    edit Query check Transfer DtTm after paired BL and before later BL query &#039;&#039;check_Transfer_DtTm_after_paired_BL_and_before_later_BL&#039;&#039; 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 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 Query &#039;&#039;check_ICD10_trach_create_but_no_TISS&#039;&#039; 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 Query &#039;&#039;check_ICD10_trach_has_trach_but_no_TISS&#039;&#039; 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 query &#039;&#039;check_tmp_BedHeld&#039;&#039; 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 CCI Component no admin entries query &#039;&#039;check_CCI_Component_if_no_admin_entries&#039;&#039; implemented complete hard check There must be no No procedure entered/Blank procedure entry in CCI Component.
    edit Query s tmp EuroSCORE II checks query &#039;&#039;s_tmp_EuroSCORE_II_checks&#039;&#039; 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


    Currently active checks

    edit page Coding Status Timing Firmness Summary question who
    edit page Coding Status Timing Firmness Summary question who
    edit Query check CCI TISS Intubation vs Intubated query &#039;&#039;check_CCI_TISS_Intubation_vs_Intubated&#039;&#039; 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 check tmp Service and Boarding Loc during admission timeframe query &#039;&#039;check_tmp_Service_and_Boarding_Loc_during_admission_timeframe&#039;&#039; 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 service and program consistency query &#039;&#039;check_tmp_service_and_program_consistency&#039;&#039; implemented always hard check Service tmp entry values must be consistent with the Program
    edit Query check tmp service or location duplicate query &#039;&#039;check_tmp_service_or_location_duplicate&#039;&#039; 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 has transfer ready date or checkbox 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.
    edit Query s tmp Boarding Loc date item query s_tmp_Boarding_Loc_date_item implemented complete hard check Validates entries for Boarding Loc
    edit Query check ICD10 ESRD and AKI only if transplant 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 send check centralized is owner Query &#039;&#039;send_check_centralized_is_owner&#039;&#039; 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 CCI TISS Vented without mechanism query &#039;&#039;check_CCI_TISS_Vented_without_mechanism&#039;&#039; 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 ABO TEE checks query &#039;&#039;s_tmp_ABO_TEE_checks&#039;&#039; 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 ICD10 chronic vent acute resp failure 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 Sub Dx Checker Sub &#039;&#039;Dx_Checker&#039;&#039; 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 s tmp IICU consult dispo to IICU but no tmp query &#039;&#039;s_tmp_IICU_consult_dispo_to_IICU_but_no_tmp&#039;&#039; implemented always hard check A patient is discharged to IICU and does not have an IICU consult entry.
    edit Query check CCI TISS if no then none query &#039;&#039;check_CCI_TISS_if_no_then_none&#039;&#039; 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 Check function Validate Pre Acute Living Situation function Validate_Pre_Acute_Living_Situation implemented complete hard check can't be blank
    edit Query check ICD10 CLI vs CCI CentralLine query &#039;&#039;check_ICD10_CLI_vs_CCI_CentralLine&#039;&#039; 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 Sub PharmCheck Sub &#039;&#039;PharmCheck&#039;&#039; 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 Check function previous NE Location function previous_NE_Location() implemented complete hard check Previous Location field can't be same as Service/Location field
    edit Check function preAdmit NE Location function preAdmit_NE_Location() implemented complete hard check Pre-admit Inpatient Institution field can't be same as Service/Location field
    edit Check function location NE dispo location_NE_dispo() which calls query &#039;&#039;Check_Location_NE_Dispo&#039;&#039; implemented complete hard check Service/Location field can't be same as Dispo field
    edit Check function Validate First name function &#039;&#039;Validate_First_name&#039;&#039; implemented always hard check
    • can't be blank
    • can't start with a space
    • can't start with a hyphen
    • only allows letters, spaces and hyphens
    edit Check function Validate Last name function &#039;&#039;Validate_Last_name&#039;&#039; implemented hard check
  • can't be blank
  • can't start with a space
  • can't start with a hyphen
  • only allows letters, spaces and hyphens
  • edit Check Function Validate PostalCode Function &#039;&#039;Validate_PostalCode&#039;&#039; implemented complete hard check Validates that Postal Code field only contains characters in format allowed for a postal code
    edit Query check ICD10 ESRD vs kidney transplant 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 ICD10 only 1 stage of renal failure 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 CCI vs LOS count days component query &#039;&#039;check_CCI_vs_LOS_count_days_component&#039;&#039; 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 s tmp EuroSCORE II checks query &#039;&#039;s_tmp_EuroSCORE_II_checks&#039;&#039; 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 Component no admin entries query &#039;&#039;check_CCI_Component_if_no_admin_entries&#039;&#039; implemented complete hard check There must be no No procedure entered/Blank procedure entry in CCI Component.
    edit Query check tmp BedHeld query &#039;&#039;check_tmp_BedHeld&#039;&#039; 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 ICD10 trach has trach but no TISS Query &#039;&#039;check_ICD10_trach_has_trach_but_no_TISS&#039;&#039; 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 ICD10 trach create but no TISS Query &#039;&#039;check_ICD10_trach_create_but_no_TISS&#039;&#039; 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 BL TR combiner null 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 Transfer DtTm after paired BL and before later BL query &#039;&#039;check_Transfer_DtTm_after_paired_BL_and_before_later_BL&#039;&#039; 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 s tmp Boarding Loc ER delay reasonable query &#039;&#039;s_tmp_Boarding_Loc_ER_delay_reasonable&#039;&#039; 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 73 hrs later for Med
    edit Query check no consecutive same BL or Service 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 check CCI vs LOS count days picklist query &#039;&#039;check_CCI_vs_LOS_count_days_picklist&#039;&#039; 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 CCI TISS discontinuous ETT query &#039;&#039;check_CCI_TISS_discontinuous_ETT&#039;&#039; 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 must have entry query &#039;&#039;check_CCI_must_have_entry&#039;&#039; 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 CCI TISS matching BoardingLoc time query &#039;&#039;check_CCI_TISS_matching_BoardingLoc_time&#039;&#039; 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 eliminated ICD10 query &#039;&#039;check_eliminated_ICD10&#039;&#039; implemented hard check disallows any currently entered diagnosis that has been eliminated
    edit Query check eliminated CCI Pick query &#039;&#039;check_eliminated_CCI_Pick&#039;&#039; implemented hard check disallows any currently entered diagnosis that has been eliminated
    edit Query check eliminated CCI Comp query &#039;&#039;check_eliminated_CCI_Comp&#039;&#039; implemented hard check disallows any currently entered diagnosis that has been eliminated
    edit Query check tmp 2 BL TR S same tm Query &#039;&#039;check_tmp_2_BL_TR_S_same_tm&#039;&#039; 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 tmp Boarding Loc Service first same query &#039;&#039;check_tmp_Boarding_Loc_Service_first_same&#039;&#039; 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 s tmp check Boarding Loc and TransferReadyDtTm pairs 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 s tmp check combined Boarding Loc and TransferReadyDtTm 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.
    edit Query check transfer DtTm during admission query &#039;&#039;check_transfer_DtTm_during_admission&#039;&#039; 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 CCI TISS NrDays LT LOS query &#039;&#039;check_CCI_TISS_NrDays_LT_LOS&#039;&#039; 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 CCI TISS NrDays GT LOS query &#039;&#039;check_CCI_TISS_NrDays_GT_LOS&#039;&#039; 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 Check APACHE physiological variable high low functions &#039;&#039;validate_x&#039;&#039;, function &#039;&#039;Min_Max_Checker&#039;&#039; implemented hard check and soft check an APACHE physiological variable is extremely high or low
    edit Query check pt from ER function from_ER(); query &#039;&#039;check_pt_from_ER&#039;&#039; implemented always soft check part of validating Boarding Loc
    edit Query check prev pre-admit consistent function &#039;&#039;prev_pre_admit_consistent&#039;&#039;, query &#039;&#039;check_prev_pre-admit_consistent&#039;&#039; 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 Location Function Validate Previous Location implemented hard check validates Previous Location field:
  • Can not be blank
  • function previous_NE_Location() - Previous Location field can't be same as Service/Location field
  • edit Function Validate Pre admit Inpatient Institution Function &#039;&#039;Validate_Pre_admit_Inpatient_Institution&#039;&#039;, [[Check function preAdmit NE Location]] implemented hard check validates Pre-admit Inpatient Institution field:
  • Can not be blank
  • Check function preAdmit NE Location
  • edit Query check minimal data set incomplete query &#039;&#039;check_minimal_data_set_incomplete&#039;&#039; implemented always hard check makes sure the Minimal Data Set is collected before records can be sent.
    edit Query check ICD10 trach dxs consistent Query &#039;&#039;check_ICD10_trach_dxs_consistent&#039;&#039; implemented hard check Tracheostomy related CCI and ICD10 codes must be consistent with each other.
    edit Query check AIDS vs HIV 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 Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogen query &#039;&#039;check_ICD10_Inf_Antibiotic_resistance_must_have_pathogen&#039;&#039; 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 Inf Pathogens must have Infection requiring pathogen or Potential Infection query &#039;&#039;check_ICD10_Inf_Pathogens_must_have_Infection&#039;&#039; 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 Infection with implied pathogen must not have a pathogen combined code query &#039;&#039;check_ICD10_Inf_Infection_w_implied_must_not_have_pathogen&#039;&#039; 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 ICD10 Inf Infection req Pathogen must have one query &#039;&#039;check_ICD10_Inf_Infection_req_Pathogen_must_have_one&#039;&#039; 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 Query check tmp generate allowed query &#039;&#039;check tmp generate allowed&#039;&#039;, Sub &#039;&#039;GenerUpdate_tmp_entry&#039;&#039; implemented always hard check check that tmp project/item combo exists for this location for a project
    edit Query check ICD10 mechanism vs trauma query &#039;&#039;check_ICD10_mechanism_vs_trauma&#039;&#039; implemented hard check Traumas need mechanisms, and mechanisms need traumas (see also Template:ICD10 Guideline Trauma w mechanism).
    edit Query check hernia type vs complication 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 awaiting has Transfer Ready DtTm Query &#039;&#039;check_ICD10_awaiting_has_Transfer_Ready_DtTm&#039;&#039; 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 cooling vs arrest 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 CCI Date query &#039;&#039;check_CCI_Date&#039;&#039; implemented complete hard check Px Date must be sensible when compared to first Service tmp entry and Dispo_DtTm
    edit Query check ICD10 dx implying death must have appropriate dispo query &#039;&#039;check_ICD10_dx_implying_death_must_have_appropriate_dispo&#039;&#039; 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 long transfer delay Query check_long_transfer_delay needs review always soft check Is the Transfer Delay (Critical Care) or Transfer Delay (Medicine) unreasonably long?
    edit Function long LOS() 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 TISS Pharm Vasoactive 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 Query check CCI ICD10 Dialysis no Dx query &#039;&#039;check_CCI_ICD10_Dialysis_no_Dx&#039;&#039; 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 Check duplicate patient functions &#039;&#039;has_multiples()&#039;&#039; and &#039;&#039;overlap()&#039;&#039; and query &#039;&#039;Check_pt_multiples&#039;&#039; implemented hard check there are no duplicate entries for the same patient ward admission on the laptop at send time
    edit Query check dx primary not exactly one query &#039;&#039;check_dx_primary_not_exactly_one&#039;&#039; 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 CCI Picklist if no admin entries query &#039;&#039;check_CCI_Picklist_if_no_admin_entries&#039;&#039; implemented complete hard check There must be no No procedure entered/Blank procedure entry in CCI Picklist.
    edit Query check CCI if no then none query &#039;&#039;check_CCI_if_no_then_none&#039;&#039; 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 duplicates query &#039;&#039;check_CCI_Picklist_duplicates&#039;&#039; implemented complete hard check No duplication of CCI Picklist Px_Type, Px_Date, Px_Count
    edit Query check CCI Component duplicates query &#039;&#039;check_CCI_Component_duplicates&#039;&#039; implemented complete hard check No duplication of CCI Component Px_Type, Px_Date
    edit Query check CCI Component unfilled query &#039;&#039;check_CCI_Component_unfilled&#039;&#039; implemented complete hard check CCI Component entry with missing px, Px_Type or Px_Count
    edit Query check CCI Picklist unfilled query &#039;&#039;check_CCI_Picklist_unfilled&#039;&#039; implemented complete hard check CCI Picklist entry with missing px, Px_Type or Px_Count
    edit Query check ICD10 Comorbids NoComo code but others query &#039;&#039;check_ICD10_Comorbids_NoComo_code_but_others&#039;&#039; implemented complete hard check If No Comorbidities (ICD10 code) is entered, there must really be no other comorbidities coded
    edit Query check ICD10 Comorbids Dx present query &#039;&#039;check_ICD10_Comorbids_Dx_present&#039;&#039; 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 unfilled query &#039;&#039;check_ICD10_unfilled&#039;&#039; implemented complete hard check ICD10 entry with missing Dx_Type, Dx_Priority or No Dx Entered
    edit Query check ICD10 date query &#039;&#039;check_ICD10_date&#039;&#039; 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 dx primary lowest priority query &#039;&#039;check_dx_primary_lowest_priority&#039;&#039; 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 Date of Birth function &#039;&#039;Validate_DOB&#039;&#039; implemented complete hard check The minimum age allowed is 10, the maximum age allowed is 120.
    edit Query check CCI from OR no CCI query &#039;&#039;check_CCI_from_OR_no_CCI&#039;&#039; 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 CCI component 1 and 2 compatible query &#039;&#039;Check_CCI_component_1_and_2_compatible&#039;&#039; implemented complete hard check Component CCIs must have compatible component 1 and component 2
    edit Function Validate Dispo function &#039;&#039;Validate Dispo&#039;&#039; implemented complete hard check doesn't allow empty
    edit Function Validate Province function &#039;&#039;Validate_Province&#039;&#039; implemented hard check Validates the Province field:
  • can't be left blank
  • must not fail function Validate_PHIN
  • edit Function Validate Chart Function &#039;&#039;Validate_Chart&#039;&#039; implemented hard check validates the Chart number:
  • Chart must be numerical
  • chart must be
  • checks Function PHIN same as Chart
  • no further checks at this time because chart numbers are different at different hospitals
  • edit Function PHIN same as Chart implemented hard check PHIN can't be the same as Chart
    edit Function Validate PHIN implemented hard check
  • for patients with Province = MB, the PHIN has to be (> 100 000 000 and <= 130 000 000) or 999 999 999 (to accommodate PHIN_field#Location_Manitoba_and_no_PHIN
  • for out-of-province patients, the PHIN must be entered as blank
  • checks Function PHIN same as Chart
  • edit Query s tmp QASeptic tmp no dx 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 Query s tmp QASeptic Dx no tmp ICD10 query &#039;&#039;s_tmp_QASeptic_Dx_no_tmp_ICD10&#039;&#039; implemented hard check CC patient has Septic Shock/Shock, septic dx and no QA Septic Shock tmp entry
    edit Query s tmp apostrophe in comment query &#039;&#039;s_tmp_apostrophe_in_comment&#039;&#039; 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 project item consistent [[Function TmpChecker]], query &#039;&#039;s_tmp_project_item_consistent&#039;&#039; implemented hard check Checks that tmp project entries only contain combinations of project and item that are allowed.
    edit Query check CCI CXR vs LOS query &#039;&#039;check_CCI_CXR_vs_LOS&#039;&#039; needs review complete soft check Confirm that a Category:Labs Imaging count is not unreasonably high
  • Just came across this... the started query includes additional dxs now, as per #CCI collect count each. Does the proposed accepted count make sense for all the dxs? Your validation table was for CXR. Ttenbergen 11:50, 2023 May 3 (CDT)
    • Did some checking on all 13 LAB Imaging from CCI picklist and found counts more than the LOS only in ECHO, AXR and CXR. Emailed Lisa and Pagasa March 14, 2024 to check if correct or not. Waiting for their feedbacks. In the email, I also propose another query (e.g. the counts per calendar day per patient must not be more than one) as alternative to the threshold limits LOS +- 3 STD shown below. --JMojica 10:55, 2024 March 18 (CDT)
      • That query is tighter and would therefore have more false positives. What does Lisa think about that? Ttenbergen 09:51, 2024 March 20 (CDT)
      • I made some limits per LOS group for CXR, AXR, ECHO and Blood gases and emailed the results to Tina and Lisa 3/25/2024 for discussion. ---JMojica 13:28, 2024 March 25 (CDT)
  • all

    All checks

    see all checks

    Related articles

    Related articles: