CCMDB.accdb Data Integrity Checks

This page lists pages that have CCMDB Data Integrity Checks on them, the status of those checks if available, and the page's last modification date.

See Template:Data Integrity Check for how to get things on this list.

Checks currently requiring action

edit	page	Coding	Status	Timing	Firmness	Summary	question	who
edit	page	Coding	Status	Timing	Firmness	Summary	question	who
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 each count vs LOS	query ''check_CCI_each_count_vs_LOS''	needs review	complete	soft check	Confirm that a Category:Labs Imaging count is not unreasonably high
edit	Query check long transfer delay	Query check_long_transfer_delay	needs review	always	soft check	Is the Transfer Delay (Critical Care) or Transfer Delay (Medicine) unreasonably long?

Currently active checks

edit	page	Coding	Status	Timing	Firmness	Summary	question	who
edit	page	Coding	Status	Timing	Firmness	Summary	question	who
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 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 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 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 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 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	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 ''Validate_Last_name''	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 ''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 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 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	Sanity check for BedHeldEnd DtTm
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 144 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	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 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	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 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: 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 ''Validate_Pre_admit_Inpatient_Institution'', [[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 ''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	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 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 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	Query check CCI each count vs LOS	query ''check_CCI_each_count_vs_LOS''	needs review	complete	soft check	Confirm that a Category:Labs Imaging count is not unreasonably high
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	Date of Birth	function ''Validate_DOB''	implemented	complete	hard check	The minimum age allowed is 10, the maximum age allowed is 120.
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 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 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 &#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	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 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 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 s tmp AHC consistent	not entered	implemented	complete	hard check	Checks for Project AHC	If "item" is "yes" there needs to be a date waiting for details on unclear dates and times Ttenbergen 13:54, 2024 December 2 (CST)	all
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.	This check doesn't seem to catch when a time is entered without a date. It would be good to update that. Don't have time right now, so leaving a note. Email exchange 2024-11-14. Ttenbergen 12:12, 2024 November 15 (CST)	Tina

All checks

see all checks