CCMDB.accdb Data Integrity Checks: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) 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:
| |||
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:
then there has to be a
| ||
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
| ||
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 |
| ||||
edit | Function PHIN same as Chart | implemented | hard check | PHIN can't be the same as Chart | ||||
edit | Function Validate Chart | Function ''Validate_Chart'' | implemented | hard check | validates the Chart number:
| |||
edit | Function Validate Province | function ''Validate_Province'' | implemented | hard check | Validates the Province field:
| |||
edit | Function Validate Dispo | function ''Validate Dispo'' | implemented | complete | hard check | doesn't allow empty | ||
edit | Function Validate Transfer Ready DtTm | 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 | 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 | 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 | 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 | |||
edit | Query check dx primary not exactly one | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | query ''check_CCI_Component_duplicates'' | implemented | complete | hard check | No duplication of CCI Component Px_Type, Px_Date | ||
edit | Query check CCI Picklist duplicates | 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 | 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 | 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 | 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 | Check pre acute consistent | query '''check pre acute consistent''' | declined | complete | soft check | consistency of Pre acute living situation; Dispo; Postal Code and Previous Location | ||
edit | Query check ICD10 ESRD vs ARF | 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 | 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 ''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 | 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 | query ''check_dispo_lower_acuity_than_location'' and function ''Transfer_Ready_DtTm_vs_Location_vs_Dispo'' | 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 ''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 | function ''Validate_Last_name'' | implemented | hard check |
| |||
edit | Check function Validate First name | function ''Validate_First_name'' | implemented | always | hard check |
| ||
edit | Check function location NE dispo | location_NE_dispo() which calls query ''Check_Location_NE_Dispo'' | 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 ''s_tmp_Accept_Log_Park_prev_no_tmp'' | 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 ''s_tmp_Accept_Log_Park_tmp_no_prev'' | 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 ''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 | 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 ''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 | function Validate_Pre_Acute_Living_Situation | implemented | complete | hard check | can't be blank | ||
edit | Query check VAP admit must be from ICU | 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 | 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 | 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 | 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 | 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 | 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 | 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 ''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 | query ''s_tmp_comfort_care_gt_one'' | retired | always | hard check | Only one entry allowed per patient. | ||
edit | Query s tmp ABO TEE checks | 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 | 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 entered | not feasible | complete | hard check | Can't have Project Borrow arrive on own unit | ||
edit | Query s tmp Borrow duplicates | 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 | 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 | 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 | 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 | 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 ''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 | 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 | 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 | query ''check_tmp_ER_Boarding_Loc_should_exist_if_from_ER''; function from_ER(); query ''check_pt_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 | 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 | 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 | 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 | 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 | 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 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 ''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 | 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 ''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 | query ''check_eliminated_CCI_Comp'' | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||
edit | Query check eliminated CCI Pick | query ''check_eliminated_CCI_Pick'' | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||
edit | Query check eliminated ICD10 | query ''check_eliminated_ICD10'' | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||
edit | Query check TISS each day | 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 | 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 ''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 | 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 | 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 | 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 | 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 | 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 ''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 73 hrs later for Med | ||
edit | Query check Transfer DtTm after paired BL and before later BL | 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 | 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 ''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 | 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 | query ''check_tmp_BedHeld'' | 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 ''check_CCI_Component_if_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 | 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 |
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 ''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 check tmp Service and Boarding Loc during admission timeframe | 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 service and program consistency | 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 or location duplicate | 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 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 ''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 CCI TISS Vented without mechanism | 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 ABO TEE checks | 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 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 ''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 s tmp IICU consult dispo to IICU but no tmp | 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 if no then none | 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 | 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 ''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 Sub PharmCheck | 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 | 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 ''Check_Location_NE_Dispo'' | implemented | complete | hard check | Service/Location field can't be same as Dispo field | ||
edit | Check function Validate First name | function ''Validate_First_name'' | implemented | always | hard check |
| ||
edit | Check function Validate Last name | function ''Validate_Last_name'' | implemented | hard check |
| |||
edit | Check Function Validate PostalCode | Function ''Validate_PostalCode'' | 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 ''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 s tmp EuroSCORE II checks | 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 check CCI Component no admin entries | query ''check_CCI_Component_if_no_admin_entries'' | implemented | complete | hard check | There must be no No procedure entered/Blank procedure entry in CCI Component. | ||
edit | Query check tmp BedHeld | query ''check_tmp_BedHeld'' | 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 ''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 ICD10 trach create but no TISS | 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 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 ''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 s tmp Boarding Loc ER delay reasonable | 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 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 ''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 CCI TISS discontinuous ETT | 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 must have entry | 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 CCI TISS matching BoardingLoc time | 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 eliminated ICD10 | query ''check_eliminated_ICD10'' | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||
edit | Query check eliminated CCI Pick | query ''check_eliminated_CCI_Pick'' | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||
edit | Query check eliminated CCI Comp | query ''check_eliminated_CCI_Comp'' | implemented | hard check | disallows any currently entered diagnosis that has been eliminated | |||
edit | Query check tmp 2 BL TR S same tm | 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 tmp Boarding Loc Service first same | 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 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 ''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 CCI TISS NrDays LT LOS | 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 CCI TISS NrDays GT LOS | 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 | 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 pt from ER | function from_ER(); query ''check_pt_from_ER'' | implemented | always | soft check | part of validating Boarding Loc | ||
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 Location | Function Validate Previous Location | implemented | hard check | validates Previous Location field:
| |||
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 | 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 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 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 ''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 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 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 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 | 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 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 | 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 ''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 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 ''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 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 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 ''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 | 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 dx primary not exactly one | 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 CCI Picklist if no admin entries | 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 if no then none | 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 duplicates | query ''check_CCI_Picklist_duplicates'' | implemented | complete | hard check | No duplication of CCI Picklist Px_Type, Px_Date, Px_Count | ||
edit | Query check CCI Component duplicates | query ''check_CCI_Component_duplicates'' | implemented | complete | hard check | No duplication of CCI Component Px_Type, Px_Date | ||
edit | Query check CCI Component unfilled | query ''check_CCI_Component_unfilled'' | implemented | complete | hard check | CCI Component entry with missing px, Px_Type or Px_Count | ||
edit | Query check CCI Picklist unfilled | query ''check_CCI_Picklist_unfilled'' | 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 ''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 ICD10 Comorbids Dx present | 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 unfilled | query ''check_ICD10_unfilled'' | implemented | complete | hard check | ICD10 entry with missing Dx_Type, Dx_Priority or No Dx Entered | ||
edit | Query check ICD10 date | 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 dx primary lowest priority | 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 | Date of Birth | function ''Validate_DOB'' | 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 ''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 | |||
edit | Query check CCI component 1 and 2 compatible | query ''Check_CCI_component_1_and_2_compatible'' | implemented | complete | hard check | Component CCIs must have compatible component 1 and component 2 | ||
edit | Function Validate Dispo | function ''Validate Dispo'' | implemented | complete | hard check | doesn't allow empty | ||
edit | Function Validate Province | function ''Validate_Province'' | implemented | hard check | Validates the Province field:
| |||
edit | Function Validate Chart | Function ''Validate_Chart'' | implemented | hard check | validates the Chart number:
| |||
edit | Function PHIN same as Chart | implemented | hard check | PHIN can't be the same as Chart | ||||
edit | Function Validate PHIN | implemented | hard check |
| ||||
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 ''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 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 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 check CCI CXR vs LOS | query ''check_CCI_CXR_vs_LOS'' | needs review | complete | soft check | Confirm that a Category:Labs Imaging count is not unreasonably high |
| all |