Data Integrity Checks

The Critical Care and Medicine Database has many data integrity checks built into our data collection process. This page is an index to our documentation for those.

We try to run the checks as early in the collection process as possible:

1. CCMDB Data Integrity Checks - run in CCMDB.mdb and notify Data Collector during the collection process
2. CFE Data Integrity Checks - run in Centralized data front end.accdb as part of the Data Processor's job
3. SAS Data Integrity Checks - run in SAS as part of the Statistician's final clean up of the data before any reports or data requests are released

Documenting a new cross check

• search the wiki to see if this already exists
• if not, make a new page with a self-explanatory name that follows any conventions we might use
• add

  {{Data Integrity Check}}

  at the top of the page and save
• click the "edit with form" tab at the top of the page to edit the Data Integrity Checks with a helpful form

List of Data Integrity Checks (SMW)

Current number of Data Integrity Checks: 195

	Summary	Status	App	DICRelatedConcepts	Category
Query NDC VAP no TISS	If a patient has a Acquired Diagnosis Pneumonia, ventilator-associated (VAP) and no TISS28 items T18 - Invasive Mechanical Ventilation (TISS Item) (T18) then this is an error.	declined	Centralized data front end.accdb	Invasive Mechanical Ventilation (TISS Item) Pneumonia, ventilator-associated (VAP) Spontaneous breathing via ETT without PEEP/CPAP, with or without supplemental O2 (TISS Item)	Centralized data front end.accdb VAP - Ventilator Associated Pneumonia Legacy Content Data Processing Data Integrity Checks TISS28 check
Check CRF vs ARF across multiple encounters	If a patient had a comorbid of CRF in any previous admission then ARF can not be an admit or complication in subsequent admissions.	declined	Centralized data front end.accdb	ARF (Diagnosis) Kidney, acute tubular necrosis (ATN) Kidney, acute renal failure NOS Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic Kidney, acute renal failure, postprocedural CRF - Chronic Renal Failure Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15 ICD10 Guideline for Renal Coding	Multiple encounter longitudinal consistency check Centralized data front end.accdb ICD10 Dx check CCI Px check Data Integrity Checks
Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days	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.	declined	CCMDB.accdb	Dispo DtTm field Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days ICD10 Guideline AwaitingTransfer Awaiting/delayed transfer to long-term care/PCH inside or outside of Winnipeg Transfer Ready DtTm tmp entry Task Team Meeting - Rolling Agenda and Minutes 2021 Change from Awaiting/delayed dx codes to Transfer Ready DtTm	Transfer Ready Awaiting/delayed transfer ICD10 Dx check Data Integrity Checks CCMDB.accdb
Query check ICD10 stroke	Stroke, NOS can not be coded with other stroke codes.	declined	CCMDB.accdb	Cerebral infarction/stroke, NOS Cerebral infarction/stroke due to embolism Hemorrhage, intracerebral/intracranial, nontraumatic (ICH, hemorrhagic stroke) Stroke, NOS Subdural or epidural hematoma/hemorrhage, nontraumatic Hemorrhage, subarachnoid or ruptured cerebral aneurysm	ICD10 Dx check Data Integrity Checks CCMDB.accdb
Can't check ICD10 ARF vs APACHE ARF	Can't have ESRD and acute renal failure	declined	CCMDB.accdb	ARF (APACHE) Kidney, acute tubular necrosis (ATN) Kidney, acute renal failure NOS Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic Kidney, acute renal failure, postprocedural Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15 ICD10 Guideline for Renal Coding	ICD10 Dx check APACHE check Data Integrity Checks ICD10 CCMDB.accdb
Query NDC Dialysis TISS CCI	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.	declined	CCMDB.accdb	CRRT (TISS Item) Intermittent hemodialysis (TISS Item) Peritoneal dialysis (TISS Item) CRRT (incl volume removal via PRISMA device) HD (Hemodialysis) PD (Peritoneal dialysis) ICD10 Guideline for Renal Coding	CCI Px check Data Integrity Checks CCMDB.accdb TISS28 check
Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm	If an ICD10 code in Category:Awaiting/delayed transfer is Primary Admit Diagnosis/Dx Primary then Transfer Ready DtTm must equal "Arrive DtTm"	declined	CCMDB.accdb	Primary Admit Diagnosis Dx Primary Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days Admit Diagnosis ICD10 Guideline AwaitingTransfer Boarding Loc Awaiting/delayed transfer to long-term care/PCH inside or outside of Winnipeg Task Team Meeting - Rolling Agenda and Minutes 2021 Change from Awaiting/delayed dx codes to Transfer Ready DtTm	Transfer Ready Awaiting/delayed transfer ICD10 Dx check Data Integrity Checks CCMDB.accdb
Query check CCI TISS spont breath no tube	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))	declined	CCMDB.accdb	ETT Present (TISS Item) Trach Tube Present (TISS Item) Spontaneous breathing via ETT without PEEP/CPAP, with or without supplemental O2 (TISS Item)	Data Processing Data Integrity Checks CCMDB.accdb TISS28 check
Query check ICD10 Inf Potential Infection must have pathogen or alt	every dx in Category:Potential infection must have a dx in Category:Pathogens or Not an Infection (ICD10 pathogen alternative) as Combined ICD10 codes.	declined	CCMDB.accdb	Adenovirus Cytomegalovirus (CMV) Parainfluenza virus Staphylococcus aureus Combined ICD10 codes Clostridium perfringens Viral hepatitis, acute, NOS Viral hepatitis, chronic, NOS Mumps Mumps virus Infectious mononucleosis (usually due to Epstein-Barr virus) Viral carditis Hantavirus infection Coccidioides Histoplasma Blastomyces Paracoccidioides Sporothrix Aspergillus Cryptococcus Mucormycetes Fungus or yeast, NOS Fungemia, NOS Pneumocystis Jirovecii or Pneumocystis Carinii Protozoa, NOS Streptococcus group A (strep pyogenes) Streptococcus group D Streptococcus pneumoniae Streptococcus, NOS Streptococcus group G Mycoplasma pneumoniae Escherichia coli (E. coli) Haemophilus influenzae (H. flu) Proteus mirabilus (morganii) Pseudomonas Bacillus fragilis (B. frag) Bacteria, NOS Helicobacter pylori (H. pylori) Enterovirus - incl coxsackievirus, echovirus Coronavirus Retrovirus Reovirus Parvovirus Papillomavirus Virus, NOS Disorder of spleen, NOS Thyroiditis, acute Cholera (due to Vibrio cholerae) Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica) Salmonella species Shigellosis (dysentery due to Shigella species) Clostridium difficile infection (C. diff) Botulism (due to Clostridium botulinum toxin) Mycobacterium tuberculosis (M. TB) Mycobacterium avium-intracellulare (MAC) Nontuberculous mycobacteria Listeria Neisseria meningitidis (meningococcus) Actinomyces (actinomycosis) Nocardia (nocardiosis) Legionella Neisseria gonorrhea (gonococcus) Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia) Spirochetes, NOS - incl yaws, louse-borne, tick-borne Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus) Mosquito-borne viruses (causes of encephalitis) Tick-borne viruses (causes of encephalitis) West Nile virus Yellow fever (caused by yellow fever virus) Dengue fever (due to Dengue virus) Viral hemorrhagic fever, NOS Herpes simplex virus (HSV) Varicella zoster virus (VZV) Smallpox (due to Variola viruses) Measles virus Rubella virus (German measles virus) Molluscum contagiosum Meningitis, bacterial, NOS Intracranial abscess Intraspinal abscess Interstitial lung disease, NOS Lung abscess Pleural effusion, NOS Respiratory disorder, postprocedure/postop NOS Disorder of respiratory system, any part, NOS Disorder of salivary glands Mouth, cellulitis or abscess Esophagitis, NOS Duodenitis Abdominal hernia, with gangrene Diverticulitis, small or large intestine (diverticular disease with perforation or abscess) Diverticulosis, small or large intestine (diverticular disease without perforation or abscess) Disorder of anus or rectum, NOS Disorder of peritoneum, NOS Disorder of liver, NOS Cholecystitis, acute Gallbladder or bile duct disorder, NOS Pancreatitis, acute NOS Pancreas disorder, NOS Skin abscess Erythema multiforme Erythema nodosum Kidney or ureter, disorder NOS Bladder, cystitis, chronic Bladder, cystitis NOS Urethra, infectious or noninfectious urethritis Urinary system, disorder NOS Prostate, disorder NOS Testis, orchitis Epididymitis or orchitis, NOS (unclear which) Penis, disorders NOS Male genital organs, disorder NOS Breast, disorder NOS Salpingitis, oophoritis or salpingo-oophoritis Uterus, inflammatory or infectious disorder Cervix, inflammatory or infectious disorder Internal female reproductive organs and adnexa NOS, inflammatory or infectious disorder Vagina, vaginitis, acute Vagina, vaginitis, chronic Vagina or vulva, inflammatory or infectious disorder NOS Spontaneous abortion/miscarriage, with complication Medical abortion, with complication Abortion NOS, with complication Pleurisy (infectious or noninfectious) Hepatomegaly Skin, rash NOS Common cold (acute nasopharyngitis) Disorder of nose and/or sinuses, infectious or noninfectious NOS Disorder of iris or ciliary body of eye Disorder of the cardiovascular/circulatory system, NOS Chronic sinusitis Epiglotittis, acute Conjunctivitis, any type or cause Disorder of pulmonary vessels, NOS Deep venous thrombosis/thrombophlebitis, leg (DVT) Disorder of upper respiratory tract, infectious or noninfectious NOS Disorder of lacrimal system Laryngitis or tracheitis, acute Laryngitis or tracheitis, chronic Mastoiditis (acute or chronic, infectious or noninfectious) Myocarditis, chronic Pharyngitis, acute Disorder of eye(s), NOS Pneumonia, viral Retropharyngeal or parapharyngeal abscess Tonsillitis, acute Sinusitis, acute Tonsillitis, chronic Superficial venous thrombosis/thrombophlebitis, anywhere Lymphangitis Resistance to antimicrobials, antiviral agent Observation for suspected infection NOS Infectious contact/exposure, rabies, without disease (yet) Infectious contact/exposure, HIV, without disease (yet) HIV infection, asymptomatic Not an Infection (ICD10 pathogen alternative) Dermatophytosis (tineas, cutaneous fungal infection) Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii Rabies OR for buglist rabies virus Toxoplasmosis OR for buglist Toxoplama gondii Influenza without pneumonia but with other respiratory manifestations Influenza virus NOS -- should almost never be used Entamoeba histolytica (amoebic infection of non-intestinal sites) Infections in ICD10 Streptococcus group B (strep agalactiae) Staphylococcus, NOS Bartholin's gland, disorder, infectious or not Infectious organism, unknown Stenotrophomonas species Citrobacter species Enterobacter species Acinetobacter species Breast, inflammatory or infectious disorder of breast Klebsiella species Bronchitis, chronic, infectious or noninfectious Serratia species Enterococcus species Candida species Bronchitis, acute or chronic not specified, infectious or noninfectious Other type of infectious organism, NOS Bug Bugs Endocarditis, infective, chronic Respiratory syncytial virus (RSV) Pathogens Treponema pallidum (Syphilis) COVID-19 (SARS-COV-2) Progressive Multifocal Leukoencephalopathy (PML)	ICD10 Dx check Data Integrity Checks CCMDB.accdb
Query check TISS each day	There needs to be at least one TISS entry in CCI Picklist for each day for each ICU profile.	declined	CCMDB.accdb	Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days ICD10 Guideline AwaitingTransfer Awaiting/delayed transfer to long-term care/PCH inside or outside of Winnipeg Transfer Ready DtTm tmp entry TISS Item List Task Team Meeting - Rolling Agenda and Minutes 2021 Change from Awaiting/delayed dx codes to Transfer Ready DtTm	CCI Px check Registry checks Data Integrity Checks CCMDB.accdb TISS28 timing checks TISS28 check
Query TISS Errors NrTISSDays NE LOS	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).	declined	CCMDB.accdb	TISS General Info Dispo DtTm field LOS	Legacy Content Data Integrity Checks CCMDB.accdb Legacy TISS28 check
Check VAP acquired only first encounter	VAP should only be Acquired Diagnosis on the first encounter.	declined	Centralized data front end.accdb	Pneumonia, ventilator-associated (VAP) Acquired Diagnosis / Complication Multiple Encounter	Multiple encounter longitudinal consistency check Centralized data front end.accdb VAP - Ventilator Associated Pneumonia ICD10 Dx check Old dx check Registry checks Data Integrity Checks
Check pre acute consistent	consistency of Pre acute living situation; Dispo; Postal Code and Previous Location	declined	CCMDB.accdb	Dispo field Postal Code field Pre acute living situation field Previous Location field	Postal Codes Pre-acute living situation Admit/Discharge Data Integrity Checks Registry Data CCMDB.accdb
Query check ICD10 duplicates	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.	declined	CCMDB.accdb	Comorbid Diagnosis Admit Diagnosis	ICD10 Dx check Data Integrity Checks ICD10 CCMDB.accdb
Query check tmp ER Boarding Loc should exist if from ER	For patients with Previous Location ER at same site there should be a Boarding Loc ER.	declined	CCMDB.accdb	Previous Location field Boarding Loc	Tmp check Data Integrity Checks CCMDB.accdb
Controlling Dx Type for ICD10 codes	Some dxs can't be Dx Types Primary Admit Diagnosis, Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis	declined	CCMDB.accdb	Comorbid Diagnosis Primary Admit Diagnosis Dx Type ICD10 Diagnosis Admit Diagnosis Acquired Diagnosis / Complication	ICD10 Dx check Data Integrity Checks ICD10 CCMDB.accdb
Query check CCI TISS time means must be two	If certain Px Dates have a time component, then there should also be a matching CCI Picklist without the time	declined	CCMDB.accdb	Non-invasive CPAP or BIPAP (TISS Item) ETT Present (TISS Item) Trach Tube Present (TISS Item) CAM positive (TISS Item) Invasive Mechanical Ventilation (TISS Item) Intracranial pressure monitoring (TISS Item) Vasoactive drug IV continuous-single (TISS Item) Vasoactive drug IV continuous-multiple simultaneous (TISS Item) Pulmonary arterial line (TISS Item) Peripheral arterial line (TISS Item) Central venous catheter (TISS Item) Patient is on isolation (TISS Item) IV hyperalimentation (TISS Item) CCI Picklist Supp O2 through any device, delivered via nose, mouth, ETT or trach (TISS Item)	CCI Px check Data Integrity Checks CCMDB.accdb TISS28 timing checks TISS28 check
Query check CCI TISS CAM positive vs Dx	Checks that each T9 - CAM positive (TISS Item) goes with an ICD10 code from Category:Delirium	declined	CCMDB.accdb	CAM positive (TISS Item) Delusional disorder Psychosis/psychotic disorder, NOS, acute or chronic Delirium, not due to drugs or alcohol	ICD10 Dx check CCI Px check Data Integrity Checks CCMDB.accdb TISS28 check
Check APACHE physiological variable high low	an APACHE physiological variable is extremely high or low	implemented	CCMDB.accdb	HCT AaDO2 PO2 PCO2 Creatinine (APACHE) FiO2 WBC Na K RR HR Temperature PH Serum CO2 AP Sys BP Field AP Dias BP Field	APACHE check Data Integrity Checks APACHE II Physiological Variables CCMDB.accdb
Query check minimal data set incomplete	makes sure the Minimal Data Set is collected before records can be sent.	implemented	CCMDB.accdb	Minimal Data Set Serial number Chart number Service/Location field LastName field FirstName field PHIN field Boarding Loc Service tmp entry	Registry checks Data Integrity Checks CCMDB.accdb
Function Validate Previous Location	validates Previous Location field: Can not be blank function previous_NE_Location() - Previous Location field can't be same as Service/Location field	implemented	CCMDB.accdb	Previous Location field	Registry checks Data Integrity Checks CCMDB.accdb
Query check prev pre-admit consistent	for inpatient transfers within the WRHA, Previous Location field and Pre-admit Inpatient Institution field should be same.	implemented	CCMDB.accdb	Pre-admit Inpatient Institution field Previous Location field	Registry checks Data Integrity Checks CCMDB.accdb
Query s tmp project item consistent	Checks that tmp project entries only contain combinations of project and item that are allowed.	implemented	CCMDB.accdb	Tmp Project Collection	Tmp check Data Integrity Checks TmpV2 CCMDB.accdb
Query s tmp apostrophe in comment	There must not be apostrophes in the comment field as they would mess with Julie's data analysis.	implemented	CCMDB.accdb	Query check overstay no colour Query check overstay pt from our med Query check tmp generate allowed Query s tmp project item consistent Query s tmp apostrophe in comment Query s tmp QASeptic tmp no dx Query check CCI CRRT vs Tmp Check Accept Loc Park Query s tmp IICU consult DtTm Query s tmp QASeptic Dx no tmp ICD10 Query s tmp ABO TEE checks Query s tmp IICU consult dispo to IICU but no tmp Query s tmp Borrow no borrow on own unit Query s tmp Borrow duplicates Query s tmp Borrow sensible DtTm vs no borrow Query check overstay not entered Query s tmp Boarding Loc date item Query s tmp Boarding Loc no borrow but entry Query check tmp service or location duplicate Query check tmp service and program consistency Query check tmp Service and Boarding Loc during admission timeframe Query check tmp ER Boarding Loc should exist if from ER Query s tmp check combined Boarding Loc and TransferReadyDtTm Query s tmp check Boarding Loc and TransferReadyDtTm pairs Query check tmp Boarding Loc Service first same Query check tmp Transfer Ready not before Boarding Loc Query check tmp 2 BL TR S same tm Query s tmp check combined BL and TRDtTm nonsequential Query s tmp Boarding Loc ER delay reasonable Query check tmp BedHeld Query s tmp EuroSCORE II checks Query cardiac arrest throughout admission	Tmp check Data Integrity Checks CCMDB.accdb
Function Validate PHIN	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	implemented	CCMDB.accdb	PHIN field	Registry checks Data Integrity Checks CCMDB.accdb
Function PHIN same as Chart	PHIN can't be the same as Chart	implemented	CCMDB.accdb	Chart number PHIN field	Registry checks Data Integrity Checks CCMDB.accdb
Function Validate Province	Validates the Province field: can't be left blank must not fail function Validate_PHIN	implemented	CCMDB.accdb	Province field PHIN field	Registry checks Data Integrity Checks CCMDB.accdb
Date of Birth	The minimum age allowed is 10, the maximum age allowed is 120.	implemented	CCMDB.accdb	Date of Birth	L Log table L PHI table Registry checks Data structure Data Collection Guide Data Integrity Checks Registry Data Demographics CCMDB.accdb CCMDB.accdb cross checks triggering for correct values Cognos Report Integrator
Function Validate Dispo	doesn't allow empty	implemented	CCMDB.accdb	Dispo field	Registry checks Data Integrity Checks CCMDB.accdb
Query check dx primary not exactly one	There has to be exactly one dx per patient with Dx Primary checked, and it has to be an Admit Diagnosis	implemented	CCMDB.accdb	Primary Admit Diagnosis Dx Primary Admit Diagnosis	ICD10 Dx check Data Integrity Checks CCMDB.accdb
Query check dx primary lowest priority	The dx with Dx Primary checked should be one of the group of Combined ICD10 codes with the lowest Dx Priority.	implemented	CCMDB.accdb	Dx Priority Dx Primary	ICD10 Dx check Data Integrity Checks CCMDB.accdb
Query check ICD10 date	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	implemented	CCMDB.accdb	Comorbid Diagnosis Dispo DtTm field Dx Date Dx Type ICD10 Diagnosis Dx Date unknown Admit Diagnosis Acquired Diagnosis / Complication Service tmp entry	ICD10 Dx check Data Integrity Checks ICD10 CCMDB.accdb
Query check ICD10 unfilled	ICD10 entry with missing Dx_Type, Dx_Priority or No Dx Entered	implemented	CCMDB.accdb	Dx Type Dx Priority No Dx Entered	ICD10 Dx check Data Integrity Checks ICD10 CCMDB.accdb
Query check CCI Date	Px Date must be sensible when compared to first Service tmp entry and Dispo_DtTm	implemented	CCMDB.accdb	Dispo DtTm field Px Date Px Type Service tmp entry	CCI Px check Data Integrity Checks CCMDB.accdb
Query check CCI Component unfilled	CCI Component entry with missing px, Px_Type or Px_Count	implemented	CCMDB.accdb	Px Type Px Count CCI Component	CCI CCI Px check Data Integrity Checks CCMDB.accdb
Query check CCI Picklist unfilled	CCI Picklist entry with missing px, Px_Type or Px_Count	implemented	CCMDB.accdb	Px Type Px Count CCI Picklist	CCI CCI Px check Data Integrity Checks CCMDB.accdb
Query check CCI component 1 and 2 compatible	Component CCIs must have compatible component 1 and component 2	implemented	CCMDB.accdb	CCI Procedure	CCI Px check Data Integrity Checks CCMDB.accdb
Check Function Validate PostalCode	Validates that Postal Code field only contains characters in format allowed for a postal code	implemented	CCMDB.accdb	Postal Code field	Postal Codes Registry checks Data Integrity Checks CCMDB.accdb
Check function Validate Last name	can't be blank can't start with a space can't start with a hyphen only allows letters, spaces and hyphens	implemented	CCMDB.accdb	LastName field	Registry checks Data Integrity Checks CCMDB.accdb
Check function Validate First name	can't be blank can't start with a space can't start with a hyphen only allows letters, spaces and hyphens	implemented	CCMDB.accdb	FirstName field	Registry checks Data Integrity Checks CCMDB.accdb
Check function location NE dispo	Service/Location field can't be same as Dispo field	implemented	CCMDB.accdb	Dispo field Service/Location field	Registry checks Data Integrity Checks CCMDB.accdb
Check function previous NE Location	Previous Location field can't be same as Service/Location field	implemented	CCMDB.accdb	Previous Location field Service/Location field	Registry checks Data Integrity Checks CCMDB.accdb
Check Sub PharmCheck	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,	implemented	CCMDB.accdb	Pharmacy collection LOS	Data Integrity Checks Length of stay CCMDB.accdb
Check duplicate patient	there are no duplicate entries for the same patient ward admission on the laptop at send time	implemented	CCMDB.accdb	Chart number Dispo DtTm field LastName field FirstName field PHIN field Date of Birth Service tmp entry	Registry checks Data Integrity Checks CCMDB.accdb
PL Diff Phin SameLN FN DOB	Checks that there are no likely matches of this patient with a different PHIN (ie typos)	implemented	Centralized data front end.accdb	LastName field FirstName field PHIN field Date of Birth	Centralized data front end.accdb PL queries Registry checks Data Processing Data Integrity Checks
PL SameCHART Site Diff PHIN	A record with this Chart number already exists for this service/Location and it has a different PHIN.	implemented	Centralized data front end.accdb	Chart number Service/Location field PHIN field	Centralized data front end.accdb PL queries Registry checks Data Processing Data Integrity Checks
PL SamePHIN Site Diff chart	Another record exists for this site with the same PHIN and a different Chart number.	implemented	Centralized data front end.accdb	Chart number PHIN field	Centralized data front end.accdb PL queries Registry checks Data Processing Data Integrity Checks
Link suspect negative transit time query	Used in Correcting suspect links to find records where an earlier record for a patient with that PHIN has a Dispo DtTm that is later than the next record's Admit DtTm.	implemented	Centralized data front end.accdb	Dispo DtTm field PHIN field Admit DtTm	Multiple encounter longitudinal consistency check Centralized data front end.accdb Registry checks Data Processing Data Integrity Checks Multiple Encounter linking
Link suspect dead then alive query	Used in Correcting suspect links to find records where an earlier record with that PHIN was listed as dispo field deceased, but a later entry then shows up.	implemented	Centralized data front end.accdb	Dispo field Deceased patients PHIN field Guideline for coding organ donation after death	Multiple encounter longitudinal consistency check Centralized data front end.accdb Registry checks Data Processing Data Integrity Checks Multiple Encounter linking
Link suspect mismatch from ours incomplete query	Used in Correcting suspect links to find records where a later record with that PHIN has a Previous Location entry corresponding to one of our sites as per the s_dispo table.real_collection table, but an earlier corresponding entry doesn't exist for that location.	implemented	Centralized data front end.accdb	Previous Location field PHIN field	Multiple encounter longitudinal consistency check Centralized data front end.accdb Registry checks Data Processing Data Integrity Checks Multiple Encounter linking
Link suspect mismatch to ours incomplete query	Used in Correcting suspect links to find records where an earlier record with that PHIN has a dispo entry corresponding to one of our sites as per the s_dispo table.real_collection, but a later corresponding entry doesn't exist for that location.	implemented	Centralized data front end.accdb	Dispo field PHIN field Guideline for coding organ donation after death	Multiple encounter longitudinal consistency check Centralized data front end.accdb Registry checks Data Processing Data Integrity Checks Multiple Encounter linking
Check function Validate Pre Acute Living Situation	can't be blank	implemented	CCMDB.accdb	Pre acute living situation field	Registry checks Data Integrity Checks CCMDB.accdb
Link suspect not same visitAdmitDtTm query	Checks for records that are likely part of the same admission but have different Visit Admit DtTm field.	implemented	Centralized data front end.accdb	Dispo field Pre-admit Inpatient Institution field Previous Location field Service/Location field Visit Admit DtTm field	Centralized data front end.accdb Registry checks Data Integrity Checks
Query check cooling vs arrest	Due to our definition of Targeted Temperature Management (TTM) that code can only be used if there is a Cardiac arrest dx	implemented	CCMDB.accdb	Cardiac arrest Targeted Temperature Management (TTM)	CCI Data Integrity Checks ICD10 CCMDB.accdb
Query check hernia type vs complication	any abdominal hernia complication dx must have an abdominal hernia type dx coded.	implemented	CCMDB.accdb	Inguinal hernia Hiatus (diaphragmatic) hernia Abdominal hernia, with obstruction, incarceration or strangulation Abdominal hernia, with gangrene Abdominal hernia, NOS	Hernia ICD10 Dx check Data Integrity Checks CCMDB.accdb
Query check AIDS vs HIV	A record can not have both AIDS (disease due to HIV) and HIV infection, asymptomatic	implemented	CCMDB.accdb	AIDS (disease due to HIV) HIV infection, asymptomatic	ICD10 Dx check Data Integrity Checks CCMDB.accdb
Query s tmp QASeptic tmp no dx	CC pt has QA Septic Shock tmp entry and no Septic Shock/Shock, septic dx	implemented	CCMDB.accdb	QA Septic Shock Shock, septic Septic Shock	ICD10 Dx check Old dx check Tmp check Data Integrity Checks CCMDB.accdb
PL Chart 9 Digit	Finds any chart numbers that have >8 digits. This would usually mean someone confused a PHIN and a Chart number	implemented	Centralized data front end.accdb	Chart number	Centralized data front end.accdb PL queries Registry checks Data Processing Data Integrity Checks
Query check ICD10 Comorbids NoComo code but others	If No Comorbidities (ICD10 code) is entered, there must really be no other comorbidities coded	implemented	CCMDB.accdb	Comorbid Diagnosis No Comorbidities (ICD10 code)	ICD10 Dx check Data Integrity Checks ICD10 CCMDB.accdb
Query check ICD10 Comorbids Dx present	All complete patients must have at least one ICD10 entry for Dx Type Comorbid Diagnosis, which might be No Comorbidities (ICD10 code).	implemented	CCMDB.accdb		ICD10 Dx check Data Integrity Checks ICD10 CCMDB.accdb
Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogen	every dx in Category:Antibiotic resistance must have a dx in Category:Infection with implied pathogen or in Category:Pathogens as Combined ICD10 codes.	implemented	CCMDB.accdb	Adenovirus Cytomegalovirus (CMV) Parainfluenza virus Staphylococcus aureus Combined ICD10 codes Clostridium perfringens Hepatitis B, acute Hepatitis C, acute Viral hepatitis, acute, NOS Hepatitis B, chronic Hepatitis C, chronic Viral hepatitis, chronic, NOS AIDS (disease due to HIV) Mumps Mumps virus Infectious mononucleosis (usually due to Epstein-Barr virus) Viral carditis Hantavirus infection Thrush (Candida infection of mouth) Coccidioides Histoplasma Blastomyces Paracoccidioides Sporothrix Aspergillus Cryptococcus Mucormycetes Fungus or yeast, NOS Fungemia, NOS Malaria (due to Plasmodia, any type) African trypanosomiasis Pneumocystis Jirovecii or Pneumocystis Carinii Protozoa, NOS Helminthic (parasitic worm) infection, any organ(s) Streptococcus group A (strep pyogenes) Streptococcus group D Streptococcus pneumoniae Streptococcus, NOS Streptococcus group G Mycoplasma pneumoniae Escherichia coli (E. coli) Haemophilus influenzae (H. flu) Proteus mirabilus (morganii) Pseudomonas Bacillus fragilis (B. frag) Bacteria, NOS Helicobacter pylori (H. pylori) Enterovirus - incl coxsackievirus, echovirus Coronavirus Retrovirus Reovirus Parvovirus Papillomavirus Virus, NOS Cholera (due to Vibrio cholerae) Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica) Salmonella enteritis Salmonella species Shigellosis (dysentery due to Shigella species) Clostridium difficile infection (C. diff) Botulism (due to Clostridium botulinum toxin) Amoebiasis (amoebic dysentery due to Entamoeba histolytica) Tuberculosis of the respiratory system, confirmed Observation for SUSPECTED tuberculosis Tuberculosis of the nervous system Mycobacterium tuberculosis (M. TB) Zoonotic bacterial disease (directly transmitted from animal) Leprosy (due to Mycobacterium leprae) (Hansen's disease) Mycobacterium avium-intracellulare (MAC) Nontuberculous mycobacteria Listeria Tetanus infection (due to toxoid of Clostridium tetani) Diptheria (due to Corynebacterium diphtheriae toxin) Whooping cough (Pertussis) (due to Bordetella pertussis) Scarlet fever Neisseria meningitidis (meningococcus) Actinomyces (actinomycosis) Nocardia (nocardiosis) Legionella Neisseria gonorrhea (gonococcus) Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia) Lyme meningitis (due to Borrelia burgdorferi or Borrelia mayonii) Spirochetes, NOS - incl yaws, louse-borne, tick-borne Chlamydia psittici infection Rickettsia infection Poliomyelitis, acute Creutzfeldt-Jakob disease Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus) Mosquito-borne viruses (causes of encephalitis) Tick-borne viruses (causes of encephalitis) West Nile virus Yellow fever (caused by yellow fever virus) Dengue fever (due to Dengue virus) Viral hemorrhagic fever, NOS Herpes simplex virus (HSV) Varicella zoster virus (VZV) Smallpox (due to Variola viruses) Measles virus Measles, limited to skin Rubella virus (German measles virus) German measles, limited to skin Molluscum contagiosum Hepatitis A, acute Arthritis, due to tuberculosis Arthritis, due to Lyme Spine, tuberculosis (Pott's disease) Bone, tuberculosis (tuberculous osteomyelitis) Pneumonia, viral SARS (severe acute respiratory syndrome) Resistance to antimicrobials, antiviral agent Infectious contact/exposure, tuberculosis, without disease (yet) Infectious contact/exposure, rabies, without disease (yet) Infectious contact/exposure, HIV, without disease (yet) HIV infection, asymptomatic Not an Infection (ICD10 pathogen alternative) Dermatophytosis (tineas, cutaneous fungal infection) Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii Rabies OR for buglist rabies virus Toxoplasmosis OR for buglist Toxoplama gondii Influenza without pneumonia but with other respiratory manifestations Influenza pneumonia Influenza with nonrespiratory manifestations Influenza virus NOS -- should almost never be used Chagas' disease (due to American trypanosomiasis) Entamoeba histolytica (amoebic infection of non-intestinal sites) Infections in ICD10 Streptococcus group B (strep agalactiae) Staphylococcus, NOS Infectious organism, unknown Stenotrophomonas species Citrobacter species Enterobacter species Acinetobacter species Klebsiella species Serratia species Enterococcus species Candida species Other type of infectious organism, NOS Staphylococcal scalded skin syndrome Infection with implied pathogen Infestation, NOS Bug Bugs Respiratory syncytial virus (RSV) Pathogens Treponema pallidum (Syphilis) COVID-19 (SARS-COV-2) Progressive Multifocal Leukoencephalopathy (PML)	ICD10 Dx check Data Integrity Checks CCMDB.accdb
Check Inf Infection with implied pathogen must not have a pathogen combined code	every dx in Category:Infection with implied pathogen must not have a dx in Category:Pathogens as Combined ICD10 codes.	implemented	CCMDB.accdb	Adenovirus Cytomegalovirus (CMV) Parainfluenza virus Staphylococcus aureus Combined ICD10 codes Clostridium perfringens Hepatitis B, acute Hepatitis C, acute Viral hepatitis, acute, NOS Hepatitis B, chronic Hepatitis C, chronic Viral hepatitis, chronic, NOS AIDS (disease due to HIV) Mumps Mumps virus Infectious mononucleosis (usually due to Epstein-Barr virus) Viral carditis Hantavirus infection Thrush (Candida infection of mouth) Coccidioides Histoplasma Blastomyces Paracoccidioides Sporothrix Aspergillus Cryptococcus Mucormycetes Fungus or yeast, NOS Fungemia, NOS Malaria (due to Plasmodia, any type) African trypanosomiasis Pneumocystis Jirovecii or Pneumocystis Carinii Protozoa, NOS Helminthic (parasitic worm) infection, any organ(s) Streptococcus group A (strep pyogenes) Streptococcus group D Streptococcus pneumoniae Streptococcus, NOS Streptococcus group G Mycoplasma pneumoniae Escherichia coli (E. coli) Haemophilus influenzae (H. flu) Proteus mirabilus (morganii) Pseudomonas Bacillus fragilis (B. frag) Bacteria, NOS Helicobacter pylori (H. pylori) Enterovirus - incl coxsackievirus, echovirus Coronavirus Retrovirus Reovirus Parvovirus Papillomavirus Virus, NOS Cholera (due to Vibrio cholerae) Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica) Salmonella enteritis Salmonella species Shigellosis (dysentery due to Shigella species) Clostridium difficile infection (C. diff) Botulism (due to Clostridium botulinum toxin) Amoebiasis (amoebic dysentery due to Entamoeba histolytica) Tuberculosis of the respiratory system, confirmed Observation for SUSPECTED tuberculosis Tuberculosis of the nervous system Mycobacterium tuberculosis (M. TB) Zoonotic bacterial disease (directly transmitted from animal) Leprosy (due to Mycobacterium leprae) (Hansen's disease) Mycobacterium avium-intracellulare (MAC) Nontuberculous mycobacteria Listeria Tetanus infection (due to toxoid of Clostridium tetani) Diptheria (due to Corynebacterium diphtheriae toxin) Whooping cough (Pertussis) (due to Bordetella pertussis) Scarlet fever Neisseria meningitidis (meningococcus) Actinomyces (actinomycosis) Nocardia (nocardiosis) Legionella Neisseria gonorrhea (gonococcus) Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia) Lyme meningitis (due to Borrelia burgdorferi or Borrelia mayonii) Spirochetes, NOS - incl yaws, louse-borne, tick-borne Chlamydia psittici infection Rickettsia infection Poliomyelitis, acute Creutzfeldt-Jakob disease Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus) Mosquito-borne viruses (causes of encephalitis) Tick-borne viruses (causes of encephalitis) West Nile virus Yellow fever (caused by yellow fever virus) Dengue fever (due to Dengue virus) Viral hemorrhagic fever, NOS Herpes simplex virus (HSV) Varicella zoster virus (VZV) Smallpox (due to Variola viruses) Measles virus Measles, limited to skin Rubella virus (German measles virus) German measles, limited to skin Molluscum contagiosum Hepatitis A, acute Arthritis, due to tuberculosis Arthritis, due to Lyme Spine, tuberculosis (Pott's disease) Bone, tuberculosis (tuberculous osteomyelitis) Pneumonia, viral SARS (severe acute respiratory syndrome) Resistance to antimicrobials, antiviral agent Infectious contact/exposure, tuberculosis, without disease (yet) Infectious contact/exposure, rabies, without disease (yet) Infectious contact/exposure, HIV, without disease (yet) HIV infection, asymptomatic Not an Infection (ICD10 pathogen alternative) Dermatophytosis (tineas, cutaneous fungal infection) Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii Rabies OR for buglist rabies virus Toxoplasmosis OR for buglist Toxoplama gondii Influenza without pneumonia but with other respiratory manifestations Influenza pneumonia Influenza with nonrespiratory manifestations Influenza virus NOS -- should almost never be used Chagas' disease (due to American trypanosomiasis) Entamoeba histolytica (amoebic infection of non-intestinal sites) Infections in ICD10 Streptococcus group B (strep agalactiae) Staphylococcus, NOS Infectious organism, unknown Stenotrophomonas species Citrobacter species Enterobacter species Acinetobacter species Klebsiella species Serratia species Enterococcus species Candida species Other type of infectious organism, NOS Staphylococcal scalded skin syndrome Infection with implied pathogen Infestation, NOS Bug Bugs Respiratory syncytial virus (RSV) Pathogens Treponema pallidum (Syphilis) COVID-19 (SARS-COV-2) Progressive Multifocal Leukoencephalopathy (PML)	ICD10 Dx check Data Integrity Checks CCMDB.accdb
Function Validate Chart	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	implemented	CCMDB.accdb	Chart number PHIN field	Registry checks Data Integrity Checks CCMDB.accdb
Sub Dx Checker	Runs most Category:Old_dx_check, Category:ICD10 Dx check, Category:CCI Px check, and a few other checks for dxs	implemented	CCMDB.accdb	ICD10 collection	ICD10 Dx check Old dx check CCI Px check Data Integrity Checks CCMDB.accdb
Query check_ICD10_ESRD_vs_kidney_transplant	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	implemented	CCMDB.accdb	Kidney transplant, failure or rejection or unspecified complication Past history, transplanted kidney Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15 ICD10 Guideline for Renal Coding	ICD10 Dx check Data Integrity Checks ICD10 CCMDB.accdb
Function Validate Pre admit Inpatient Institution	validates Pre-admit Inpatient Institution field: Can not be blank Check function preAdmit NE Location	implemented	CCMDB.accdb	Pre-admit Inpatient Institution field	Data Integrity Checks CCMDB.accdb
Query check CCI Picklist duplicates	No duplication of CCI Picklist Px_Type, Px_Date, Px_Count	implemented	CCMDB.accdb	Px Type Dx Priority CCI Picklist No Dx Entered	CCI CCI Px check Data Integrity Checks CCMDB.accdb
Query check CCI Component duplicates	No duplication of CCI Component Px_Type, Px_Date	implemented	CCMDB.accdb	Px Type Dx Priority CCI Component No Dx Entered	CCI CCI Px check Data Integrity Checks CCMDB.accdb
Query s tmp QASeptic Dx no tmp ICD10	CC patient has Septic Shock/Shock, septic dx and no QA Septic Shock tmp entry	implemented	CCMDB.accdb	QA Septic Shock Shock, septic Septic Shock	ICD10 Dx check Old dx check Tmp check Data Integrity Checks CCMDB.accdb
Query s tmp ABO TEE checks	Each of the three ABO TEE project entries must have one entry on the ITEM for patients with RecordStatus complete	implemented	CCMDB.accdb	Project ABO TEE Service/Location field	Tmp check Data Integrity Checks CCMDB.accdb Service/Location check
Link suspect mismatch pre inpt ours incomplete query	Checks for patients where Pre-admit Inpatient Institution is one of ours but we don't have a corresponding record.	implemented	Centralized data front end.accdb	Pre-admit Inpatient Institution field Service/Location field	Centralized data front end.accdb Registry checks Data Integrity Checks
Check function preAdmit NE Location	Pre-admit Inpatient Institution field can't be same as Service/Location field	implemented	CCMDB.accdb	Pre-admit Inpatient Institution field Service/Location field	Registry checks Data Integrity Checks CCMDB.accdb
Query s tmp IICU consult dispo to IICU but no tmp	A patient is discharged to IICU and does not have an IICU consult entry.	implemented	CCMDB.accdb	IICU consult	Tmp check Data Integrity Checks CCMDB.accdb
Query NDC Bad Postal Code	Cross check of postal codes against known postal codes	implemented	Centralized data front end.accdb	Postal Code field	Postal Codes Centralized data front end.accdb Registry checks Questions Data Processing Data Integrity Checks To do
Query send check centralized is owner	Run automatically at the beginning of sending to ensure that no records that are already vetted or sent can be re-sent	implemented	CCMDB.accdb	Pat ID field D ID field Service/Location field	Registry checks Data Integrity Checks CCMDB.accdb
Query check ICD10 mechanism vs trauma	Traumas need mechanisms, and mechanisms need traumas (see also Template:ICD10 Guideline Trauma w mechanism).	implemented	CCMDB.accdb	Post-concussion syndrome Muscle, strain Muscle, disorder NOS Rotator cuff, tear or rupture Osteoporosis without new pathologic fracture Bone, stress fracture Bone, pathologic fracture NOS Rupture/laceration of artery, NOS Head, superficial injury/trauma (minor, contusion) Head, open wound, injury/trauma Skull, fracture, injury/trauma Tooth, fracture (broken tooth), injury/trauma Head, joints or ligaments, dislocation/sprain/strain, injury/trauma Cranial nerve, wound/injury/trauma Eye (globe), wound/injury/trauma Brain, concussion, injury/trauma Brain, cerebral edema, injury/trauma Brain injury, diffuse (TBI), injury/trauma Brain injury, focal (TBI), injury/trauma Epidural hemorrhage, injury/trauma Subdural hemorrhage/hematoma, injury/trauma Subarachnoid hemorrhage, injury/trauma Intracranial hemorrhage, injury/trauma Brain/intracranial injury NOS, injury/trauma Head NOS, wound/injury/trauma Neck, superficial injury/trauma (minor, contusion) Neck, open wound, injury/trauma Vertebra, cervical (C-spine), fracture, injury/trauma Neck, joints or ligaments, dislocation/sprain/strain, injury/trauma Spinal cord, cervical (C-spine), injury/trauma Nerve root, cervical spinal cord, injury/trauma Neck, nerves NOS, injury/trauma Carotid artery, injury/trauma Neck, blood vessels NOS, injury/trauma Neck structures NOS, wound/injury/trauma Thorax, superficial injury/trauma (minor, contusion) Thorax, open wound, injury/trauma Vertebra, thoracic (T-spine), fracture, injury/trauma Sternum, fracture, injury/trauma Rib, fracture, injury/trauma Flail chest, injury/trauma Thorax, bones NOS, fracture, injury/trauma Thorax, joints or ligaments, dislocation/sprain/strain, injury/trauma Spinal cord, thoracic (T-spine), injury/trauma Nerve root, thoracic spinal cord, injury/trauma Thorax, nerves NOS, injury/trauma Aorta, thoracic, injury/trauma Superior vena cava (SVC), injury/trauma Heart, wound/injury/trauma Pneumothorax, traumatic Hemothorax, traumatic Lung NOS, wound/injury/trauma Trachea or bronchus (airways) NOS, wound/injury/trauma Esophagus, wound/injury/trauma Intrathoracic organ/structure NOS, wound/injury/laceration Thorax NOS, wound/injury/trauma Abdomen or lower back or pelvis, superficial injury/trauma (minor, contusion) Abdomen or lower back or pelvis, soft tissues, open wound, injury/trauma Vertebra, lumbar (L-spine), fracture, injury/trauma Pelvis, fracture, injury/trauma Lumbar spine or pelvis, joints or ligaments, dislocation/sprain/strain, injury/trauma Spinal cord, lumbar (L-spine), injury/trauma Nerve root, lumbar spinal cord, injury/trauma Abdomen or lower back or pelvis, nerves NOS, injury/trauma Aorta, abdominal, injury/trauma Inferior vena cava (IVC), injury/trauma Abdomen or pelvic, blood vessels NOS, injury/trauma Spleen, wound/injury/trauma Gallbladder or bile ducts, traumatic laceration/rupture Liver, wound/injury/trauma Gallbladder or bile ducts, wound/injury/trauma Pancreas, wound/injury/trauma Stomach, traumatic laceration/rupture Stomach, wound/injury/trauma Small intestine, traumatic laceration/rupture Small intestine, wound/injury/trauma Colon (large intestine), traumatic laceration/rupture Rectum, traumatic laceration/rupture Rectum, wound/injury/trauma NOS Intra-abdominal organ NOS, traumatic laceration/rupture Intra-abdominal organ NOS, wound/injury/trauma NOS Kidney, wound/injury/trauma Ureter, wound/injury/trauma Bladder, traumatic laceration/rupture Bladder, wound/injury/trauma Urethra, wound/injury/trauma Ovary or fallopian tube, wound/injury/trauma Uterus, wound/injury/trauma Urinary, pelvic or genitourinary organs NOS, wound/injury/trauma Abdomen or lower back or pelvis NOS, wound/injury/trauma Shoulder or upper arm, superficial injury/trauma (minor, contusion) Shoulder or upper arm, open wound, injury/trauma Clavicle or scapula or humerus, fracture, injury/trauma Shoulder, joints or ligaments, dislocation/sprain/strain, injury/trauma Shoulder or upper arm, nerves, wound/injury/trauma Shoulder or upper, arm blood vessels, wound/injury/trauma Shoulder or upper arm, muscles/tendons, wound/injury/trauma Shoulder or upper arm, amputation, injury/trauma Shoulder or upper arm, wound/injury/trauma, NOS Elbow or forearm, superficial injury/trauma (minor, contusion) Elbow, open wound, injury/trauma Forearm, open wound, injury/trauma Ulna or radius (forearm), fracture, injury/trauma Elbow, joints or ligaments, dislocation/sprain/strain, injury/trauma Forearm, nerves, wound/injury/trauma Forearm, blood vessels, wound/injury/trauma Forearm, muscles/tendons, wound/injury/trauma Forearm, amputation, injury/trauma Elbow or forearm, wound/injury/trauma, NOS Wrist or hand or fingers, superficial injury/trauma (minor, contusion) Wrist or hand or fingers, open wound, injury/trauma Wrist or hand or finger bones, fracture, injury/trauma Wrist or hand or fingers, joints or ligaments, dislocation/sprain/strain, injury/trauma Wrist or hand or fingers, nerves, wound/injury/trauma Wrist or hand or fingers, blood vessels, wound/injury/trauma Wrist or hand or fingers, muscles/tendons, wound/injury/trauma Wrist or hand or fingers, amputation, injury/trauma Wrist or hand or fingers, wound/injury/trauma, NOS Hip or thigh, superficial injury/trauma (minor, contusion) Hip or thigh, open wound, injury/trauma Hip, joints or ligaments, dislocation/sprain/strain, injury/trauma Hip or thigh, nerves, wound/injury/trauma Hip or thigh, blood vessels, wound/injury/trauma Hip or thigh, muscles/tendons, wound/injury/trauma Hip or thigh, amputation, injury/trauma Hip or thigh, wound/injury/trauma, NOS Knee or lower leg, superficial injury/trauma (minor, contusion) Knee or lower leg, open wound, injury/trauma Knee, joint or ligaments or cartilage, dislocation/sprain/strain/tear, injury/trauma Knee, nerves, wound/injury/trauma Knee or lower leg, blood vessels, wound/injury/trauma Knee or lower leg, muscles/tendons, wound/injury/trauma Lower leg, amputation, injury/trauma Knee or lower leg, wound/injury/trauma, NOS Ankle or foot or toes, superficial injury/trauma (minor, contusion) Ankle or foot or toes, open wound, injury/trauma Ankle or foot or toes, joints or ligaments, dislocation/sprain/strain, injury/trauma Ankle or foot or toes, nerves, wound/injury/trauma Ankle or foot or toes, blood vessels, wound/injury/trauma Ankle or foot or toes, muscles/tendons, wound/injury/trauma Ankle or foot or toes, amputation, injury/trauma Ankle or foot or toes, wound/injury/trauma, NOS Multiple trauma Upper limb (arm) bones, level not specified/NOS, fracture, injury/trauma Upper limb (arm), level not specified/NOS, superficial injury/trauma (minor, contusion) Upper limb (arm), level not specified/NOS, open wound, injury trauma Upper limb (arm), level not specified/NOS, joints or ligaments, dislocation/sprain/strain, injury/trauma Upper limb (arm), level not specified/NOS, nerves, wound/injury/trauma Upper limb (arm), level not specified/NOS, blood vessels, wound/injury/trauma Upper limb (arm), level not specified/NOS, muscles/tendons, wound/injury/trauma Upper limb (arm), level not specified/NOS, amputation, injury/trauma Upper limb (arm), level not specified/NOS, wound/injury/trauma, NOS Lower limb (leg) bones, level not specified/NOS, fracture, injury/trauma Lower limb (leg), level not specified/NOS, superficial injury/trauma (minor, contusion) Lower limb (leg), level not specified/NOS, open wound, injury trauma Lower limb (leg), level not specified/NOS, joints or ligaments, dislocation/sprain/strain, injury/trauma Lower limb (leg), level not specified/NOS, nerves, wound/injury/trauma Lower limb (leg), level not specified/NOS, blood vessels, wound/injury/trauma Lower limb (leg), level not specified/NOS, muscles/tendons, wound/injury/trauma Lower limb (leg), level not specified/NOS, amputation, injury/trauma Lower limb (leg), level not specified/NOS, wound/injury/trauma, NOS Wound/injury/trauma, body region NOS Eye, foreign body in Ear, foreign body in Respiratory tract, foreign body in Gastrointestinal (GI) tract, foreign body in Genitorurinary tract, foreign body in Eye, burn or chemical burn Respiratory tract, burn Respiratory tract, chemical burn Mouth or pharynx, burn Esophagus, burn Gastrointestinal (GI) tract, burn Internal organ NOS, burn Mouth or pharynx, chemical burn Esophagus, chemical burn Gastrointestinal (GI) tract, chemical burn Internal organ NOS, chemical burn Skin, burn, degree unspecified Skin, burn, 1st degree Skin, burn, 2nd degree Skin, burn, 3rd degree Skin, chemical burn, degree unspecified Skin, chemical burn, 1st degree Skin, chemical burn, 2nd degree Skin, chemical burn, 3rd degree Trench foot (immersion foot) Lightning injury Electrical injury Air embolism, traumatic Fat embolism, traumatic Mechanism of injury: pedestrian vs powered vehicle Mechanism of injury: pedal cyclist, not with powered vehicle Mechanism of injury: pedal cyclist vs powered vehicle Mechanism of injury: motorcyclist Mechanism of injury: bus occupant Mechanism of injury: animal rider or occupant of animal-drawn vehicle Mechanism of injury: train occupant Mechanism of injury: driver or occupant of ATV or off-road vehicle or snowmobile Mechanism of injury: driver or occupant of watercraft Mechanism of injury: pilot or occupant of aircraft Mechanism of injury: transport or vehicle accident NOS Mechanism of injury: fall or jump (not necessarily from a height) Mechanism of injury: struck by an inanimate moving object/blunt trauma Mechanism of injury: crushed or jammed or pinched in or between objects Mechanism of injury: knife or other sharp object, stabbing Mechanism of injury: machinery Mechanism of injury: firearm (GSW) Mechanism of injury: explosion Mechanism of injury: hypodermic needle Mechanism of injury: other NOS Mechanism of injury: hanging or strangulation (accidental or intentional) Observation after accident/injury Colon (large intestine), wound/injury trauma Coding fractures in ICD10 Thorax, blood vessels NOS, injury/trauma Vertebra or spinal cord, level not specified/NOS, fracture, injury/trauma Head bones NOS, fracture, injury/trauma Femur, fracture, injury/trauma Lower leg, fracture, injury/trauma Ankle or foot or toes, fracture, injury/trauma Bone NOS, pathologic fracture due to neoplastic disease Femur or pelvis, pathologic fracture due to neoplastic disease Femur or pelvis, osteoporosis with new pathologic fracture Vertebra, pathologic fracture due to neoplastic disease Vertebra, nontraumatic fracture NOS Femur or pelvis, nontraumatic fracture NOS Bone NOS, nontraumatic fracture NOS Vertebra, osteoporosis with new pathologic fracture Bone NOS, osteoporosis with new pathologic fracture Bone, disorder of bone continuity NOS Mechanism of injury: occupant or driver of car or truck Burns, 90% or more body surface area involved Burns, 80-89% body surface area involved Burns, 70-79% body surface area involved Burns, 60-69% body surface area involved Burns, 50-59% body surface area involved Burns, 40-49% body surface area involved Burns, 30-39% body surface area involved Burns, 20-29% body surface area involved Burns, 10-19% body surface area involved Burns, up to 9% or unspecified body surface area involved ICU Interfacility Transfer Mechanism of injury: assault with bodily force Eardrum (tympanic membrane), rupture, injury/trauma	ICD10 Dx check Data Integrity Checks CCMDB.accdb
Query check ICD10 Inf Infection req Pathogen must have one	every dx in Category:Infection requiring pathogen must have a dx in Category:Pathogens or Category:Double duty pathogen as Combined ICD10 codes.	implemented	CCMDB.accdb	Bacteremia Adenovirus Cytomegalovirus (CMV) Parainfluenza virus Staphylococcus aureus Combined ICD10 codes Clostridium perfringens Viral hepatitis, acute, NOS Viral hepatitis, chronic, NOS Mumps Mumps virus Infectious mononucleosis (usually due to Epstein-Barr virus) Viral carditis Hantavirus infection Coccidioides Histoplasma Blastomyces Paracoccidioides Sporothrix Aspergillus Cryptococcus Mucormycetes Fungus or yeast, NOS Fungemia, NOS Pneumocystis Jirovecii or Pneumocystis Carinii Protozoa, NOS Streptococcus group A (strep pyogenes) Streptococcus group D Streptococcus pneumoniae Streptococcus, NOS Streptococcus group G Mycoplasma pneumoniae Escherichia coli (E. coli) Haemophilus influenzae (H. flu) Proteus mirabilus (morganii) Pseudomonas Bacillus fragilis (B. frag) Bacteria, NOS Helicobacter pylori (H. pylori) Enterovirus - incl coxsackievirus, echovirus Coronavirus Retrovirus Reovirus Parvovirus Papillomavirus Virus, NOS Cholera (due to Vibrio cholerae) Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica) Salmonella species Shigellosis (dysentery due to Shigella species) Clostridium difficile infection (C. diff) Botulism (due to Clostridium botulinum toxin) Food poisoning (due to foodborne bacterial toxin), NOS Gastrointestinal infection (gastroenteritis, colitis), bug NOS Mycobacterium tuberculosis (M. TB) Mycobacterium avium-intracellulare (MAC) Nontuberculous mycobacteria Listeria Neisseria meningitidis (meningococcus) Actinomyces (actinomycosis) Nocardia (nocardiosis) Gas gangrene (usually due to Clostridium perfringens) Legionella Toxic shock syndrome Bacterial infection, NOS Neisseria gonorrhea (gonococcus) Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia) Sexually transmitted (venereal) infections, NOS Spirochetes, NOS - incl yaws, louse-borne, tick-borne Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus) Mosquito-borne viruses (causes of encephalitis) Tick-borne viruses (causes of encephalitis) West Nile virus Yellow fever (caused by yellow fever virus) Dengue fever (due to Dengue virus) Viral hemorrhagic fever, NOS Herpes simplex virus (HSV) Varicella zoster virus (VZV) Smallpox (due to Variola viruses) Measles virus Rubella virus (German measles virus) Molluscum contagiosum Meningitis, viral - incl West Nile Meningitis, fungal Meningitis, infectious NOS Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, bacterial Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, viral Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, infectious NOS Empyema (pyothorax) Tracheostomy complication, infection of site Pneumonia, ventilator-associated (VAP) Mediastinitis, infectious Appendicitis, with or without rupture or peritonitis Anus or rectum, abscess Abscess of intestine Peritonitis, infectious Liver abscess Cholangitis Impetigo Skin abscess Cellulitis Infection of skin or subcutaneous (soft) tissue, NOS Arthritis, infectious (septic arthritis) Vertebrae, osteomyelitis (bone infection) Intervertebral disc, infection (infective discitis) Muscle, infection (pyomyositis, infective myositis) Synovitis, tenosynovitis, infective (any site) Bursitis, infective (any site) Necrotizing fasciitis Bone infection (osteomyelitis), acute Bone infection (osteomyelitis), chronic Bone infection (osteomyelitis), NOS Kidney infection, acute (pyelonephritis) Kidney infection, chronic (pyelonephritis) Kidney, renal abscess or perinephric abscess Bladder, cystitis, acute infectious Urinary tract infection, NOS Prostate, abscess Epididymis, infection (epididymitis) Puerperal (post-delivery) infections or sepsis Pulmonary embolism, septic obstetrical thromboembolism Shock, septic Chronic myringitis Endophthalmitis, infectious Endocarditis, infective, acute or subacute Lower respiratory tract infection, acute infectious Myocarditis/carditis, acute infective Peritonsillar abscess Pericarditis, acute, infective Pneumonia, viral Otitis media, infectious Otitis externa, infectious Pneumonia, fungal/yeast Pneumonia, NOS Pulmonary embolism (thromboembolism), septic Upper respiratory infection, acute NOS Pneumonia, bacterial Sepsis (SIRS due to infection, without acute organ failure) Iatrogenic, infection, related to vascular access other than central line Iatrogenic, infection, following a procedure or surgery, NOS Iatrogenic, infection, heart valve prosthesis (incl prosthetic valve endocarditis) Iatrogenic, infection, cardiac or vascular prosthetic device or implant or graft NOS Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI) Iatrogenic, infection, urinary catheter Iatrogenic, infection, internal orthopedic prosthetic device or implant or graft or bone device Iatrogenic, infection, internal prosthetic device or implant or graft NOS Resistance to antimicrobials, antiviral agent Infectious contact/exposure, rabies, without disease (yet) Infectious contact/exposure, HIV, without disease (yet) HIV infection, asymptomatic Colonized with organism (not infected) Not an Infection (ICD10 pathogen alternative) Dermatophytosis (tineas, cutaneous fungal infection) Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii Rabies OR for buglist rabies virus Toxoplasmosis OR for buglist Toxoplama gondii Severe sepsis Influenza without pneumonia but with other respiratory manifestations Influenza virus NOS -- should almost never be used Entamoeba histolytica (amoebic infection of non-intestinal sites) Infections in ICD10 Streptococcus group B (strep agalactiae) Staphylococcus, NOS Infectious organism, unknown Stenotrophomonas species Citrobacter species Enterobacter species Acinetobacter species Klebsiella species Serratia species Enterococcus species Candida species Other type of infectious organism, NOS Infectious disease NOS Parasitic infection, NOS Bug Bugs Respiratory syncytial virus (RSV) Nosocomial infection, NOS Gastrointestinal infection (gastroenteritis, colitis), viral Gastrointestinal infection (gastroenteritis, colitis), protozoal, NOS Gastrointestinal infection (gastroenteritis, colitis), bacterial, NOS Pathogens Treponema pallidum (Syphilis) Viral infection, NOS CCMDB.accdb Change Log 2019 Septic Thrombosis or Embolism, NOS Psoas abscess Retroperitoneal abscess COVID-19 (SARS-COV-2) Other specified infectious agents as the cause of diseases classified by other ICD10 code Carrier of infectious disease, unspecified Fournier's gangrene Progressive Multifocal Leukoencephalopathy (PML)	ICD10 Dx check Data Integrity Checks CCMDB.accdb
Query check ICD10 only 1 stage of renal failure	can only have one stage of renal failure in Comorbid Diagnosis and in Admit Diagnosis	implemented	CCMDB.accdb	Chronic kidney disease (chronic renal insufficiency, uremia) Stage 1, GFR GT 90 Chronic kidney disease (chronic renal insufficiency, uremia) Stage 2, GFR 60-89 Chronic kidney disease (chronic renal insufficiency, uremia) Stage 3, GFR 30-59 Chronic kidney disease (chronic renal insufficiency, uremia) Stage 4, GFR 15-29 Chronic kidney/renal disease, NOS (stage unspecified) Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15	ICD10 Dx check Data Integrity Checks ICD10 CCMDB.accdb
Query check ICD10 chronic vent acute resp failure	Chronic dependence on mechanical ventilator should not be coded with Respiratory failure (insufficiency) NOS, acute	implemented	CCMDB.accdb	Respiratory failure (insufficiency) NOS, acute Chronic dependence on mechanical ventilator	ICD10 Dx check Data Integrity Checks CCMDB.accdb
Query check CCI from OR no CCI	If from OR or PACU, must have at least 1 CCI Procedure other than No procedure performed	implemented	CCMDB.accdb	Previous Location field CCI Procedure No procedure performed No codable procedure done in OR	CCI Px check Registry checks Data Integrity Checks CCMDB.accdb
Query NDC Postal Code over time	Cross check of postal codes for consistency during a continuous hospital admission	implemented	Centralized data front end.accdb	Postal Code field	Postal Codes Centralized data front end.accdb Registry checks Data Processing Data Integrity Checks
Query check tmp generate allowed	check that tmp project/item combo exists for this location for a project	implemented	CCMDB.accdb	Overstay Predictor Project Overstay Predictor Project Collection Instructions	Tmp check Data Integrity Checks CCMDB.accdb
Query s tmp Boarding Loc date item	Validates entries for Boarding Loc	implemented	CCMDB.accdb	Dispo DtTm field Boarding Loc Service tmp entry	Tmp check Registry checks Data Integrity Checks CCMDB.accdb
PL SamePhin Diff DOB Sex	Another record exists with the same PHIN but a different Date of Birth, Sex	implemented	Centralized data front end.accdb	PHIN field Date of Birth Sex field	Centralized data front end.accdb PL queries Registry checks Data Processing Data Integrity Checks
Query check tmp service or location duplicate	Service tmp entry and Boarding_Loc entries must not have duplicate dates and services resp. locations and comments	implemented	CCMDB.accdb	Boarding Loc Service tmp entry	Tmp check Data Integrity Checks CCMDB.accdb
Query check tmp service and program consistency	Service tmp entry values must be consistent with the Program	implemented	CCMDB.accdb	Program Service tmp entry	Tmp check Data Integrity Checks CCMDB.accdb
Query check CCI if no then none	If No procedure performed in CCI Picklist there must be no other entries in CCI Picklist or CCI Component	implemented	CCMDB.accdb	CCI Picklist CCI Component No procedure performed	CCI CCI Px check Data Integrity Checks CCMDB.accdb
Query check CCI TISS NrDays GT LOS	There are more TISS Item Px_Dates than there are days between the first Service tmp entry and Dispo DtTm	implemented	CCMDB.accdb	Dispo DtTm field CCI Picklist Service tmp entry	CCI CCI Px check Registry checks Data Integrity Checks Length of stay CCMDB.accdb TISS28 timing checks TISS28 check
Query check CCI TISS NrDays LT LOS	There are more TISS Item Px_Dates than there are days between the first Service tmp entry and Dispo DtTm	implemented	CCMDB.accdb	Dispo DtTm field CCI Picklist Service tmp entry	CCI Px check Registry checks Data Integrity Checks Length of stay CCMDB.accdb TISS28 timing checks TISS28 check
Query check CCI TISS if no then none	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	implemented	CCMDB.accdb	No TISS Item (TISS Item) CCI Picklist	CCI CCI Px check Data Integrity Checks CCMDB.accdb TISS28 check
Query check ICD10 dx implying death must have appropriate dispo	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	implemented	CCMDB.accdb	Dispo field Brain death Sudden cardiac death (and died) Medical Assistance In Dying Deceased patients	ICD10 Dx check Data Integrity Checks End-of-life related data CCMDB.accdb
Query check CCI TISS Intubation vs Intubated	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.	implemented	CCMDB.accdb	ETT Present (TISS Item) Planned extubation (TISS Item) Unplanned extubation (TISS Item) Insertion of ETT (TISS Item)	Data Integrity Checks CCMDB.accdb TISS28 check
Query check CCI TISS Vented without mechanism	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.	implemented	CCMDB.accdb	ETT Present (TISS Item) Trach Tube Present (TISS Item) Invasive Mechanical Ventilation (TISS Item)	Tracheostomy Data Integrity Checks CCMDB.accdb TISS28 check
Query check transfer DtTm during admission	Transfer Ready DtTm tmp entry should never be earlier than first Boarding Loc dttm or later than Dispo DtTm	implemented	CCMDB.accdb	Dispo DtTm field Boarding Loc Transfer Ready DtTm tmp entry	Transfer Ready Data Integrity Checks CCMDB.accdb
Query check CCI TISS Pharm Vasoactive	Compare Vasoactive drug IV continuous-single (TISS Item)/T14 - Vasoactive drug IV continuous-multiple simultaneous (TISS Item) against Pharmacy entries for vasoactive drugs.	implemented	CCMDB.accdb	Pharmacy collection Vasoactive drug IV continuous-single (TISS Item) Vasoactive drug IV continuous-multiple simultaneous (TISS Item) Service tmp entry	Data Integrity Checks CCMDB.accdb TISS28 check
Query s tmp check combined Boarding Loc and TransferReadyDtTm	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.	implemented	CCMDB.accdb	Boarding Loc Transfer Ready DtTm tmp entry	Tmp check Data Integrity Checks CCMDB.accdb
Query s tmp check Boarding Loc and TransferReadyDtTm pairs	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.	implemented	CCMDB.accdb	Boarding Loc Transfer Ready DtTm tmp entry	Tmp check Data Integrity Checks CCMDB.accdb
Query check tmp Boarding Loc Service first same	Validates that the DtTm for the first Service tmp entry is the same as that for the first Boarding Loc entry	implemented	CCMDB.accdb	Boarding Loc Service tmp entry	Tmp check Registry checks Data Integrity Checks CCMDB.accdb
Query check has transfer ready date or checkbox	Each Transfer Ready DtTm tmp entry has to have either a dttm, or its checkbox checked.	implemented	CCMDB.accdb	Transfer Ready DtTm tmp entry	Data Integrity Checks PatientFollow Project CCMDB.accdb
Query Check Inf Pathogens must have Infection requiring pathogen or Potential Infection	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.	implemented	CCMDB.accdb	Bacteremia Adenovirus Cytomegalovirus (CMV) Parainfluenza virus Staphylococcus aureus Combined ICD10 codes Clostridium perfringens Viral hepatitis, acute, NOS Viral hepatitis, chronic, NOS Mumps Mumps virus Infectious mononucleosis (usually due to Epstein-Barr virus) Viral carditis Hantavirus infection Coccidioides Histoplasma Blastomyces Paracoccidioides Sporothrix Aspergillus Cryptococcus Mucormycetes Fungus or yeast, NOS Fungemia, NOS Pneumocystis Jirovecii or Pneumocystis Carinii Protozoa, NOS Streptococcus group A (strep pyogenes) Streptococcus group D Streptococcus pneumoniae Streptococcus, NOS Streptococcus group G Mycoplasma pneumoniae Escherichia coli (E. coli) Haemophilus influenzae (H. flu) Proteus mirabilus (morganii) Pseudomonas Bacillus fragilis (B. frag) Bacteria, NOS Helicobacter pylori (H. pylori) Enterovirus - incl coxsackievirus, echovirus Coronavirus Retrovirus Reovirus Parvovirus Papillomavirus Virus, NOS Disorder of spleen, NOS Thyroiditis, acute Cholera (due to Vibrio cholerae) Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica) Salmonella species Shigellosis (dysentery due to Shigella species) Clostridium difficile infection (C. diff) Botulism (due to Clostridium botulinum toxin) Food poisoning (due to foodborne bacterial toxin), NOS Gastrointestinal infection (gastroenteritis, colitis), bug NOS Mycobacterium tuberculosis (M. TB) Mycobacterium avium-intracellulare (MAC) Nontuberculous mycobacteria Listeria Neisseria meningitidis (meningococcus) Actinomyces (actinomycosis) Nocardia (nocardiosis) Gas gangrene (usually due to Clostridium perfringens) Legionella Toxic shock syndrome Bacterial infection, NOS Neisseria gonorrhea (gonococcus) Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia) Sexually transmitted (venereal) infections, NOS Spirochetes, NOS - incl yaws, louse-borne, tick-borne Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus) Mosquito-borne viruses (causes of encephalitis) Tick-borne viruses (causes of encephalitis) West Nile virus Yellow fever (caused by yellow fever virus) Dengue fever (due to Dengue virus) Viral hemorrhagic fever, NOS Herpes simplex virus (HSV) Varicella zoster virus (VZV) Smallpox (due to Variola viruses) Measles virus Rubella virus (German measles virus) Molluscum contagiosum Meningitis, bacterial, NOS Meningitis, viral - incl West Nile Meningitis, fungal Meningitis, infectious NOS Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, bacterial Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, viral Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, infectious NOS Intracranial abscess Intraspinal abscess Interstitial lung disease, NOS Lung abscess Empyema (pyothorax) Pleural effusion, NOS Tracheostomy complication, infection of site Pneumonia, ventilator-associated (VAP) Respiratory disorder, postprocedure/postop NOS Mediastinitis, infectious Disorder of respiratory system, any part, NOS Disorder of salivary glands Mouth, cellulitis or abscess Esophagitis, NOS Duodenitis Appendicitis, with or without rupture or peritonitis Abdominal hernia, with gangrene Diverticulitis, small or large intestine (diverticular disease with perforation or abscess) Diverticulosis, small or large intestine (diverticular disease without perforation or abscess) Anus or rectum, abscess Disorder of anus or rectum, NOS Abscess of intestine Peritonitis, infectious Disorder of peritoneum, NOS Liver abscess Disorder of liver, NOS Cholecystitis, acute Gallbladder or bile duct disorder, NOS Cholangitis Pancreatitis, acute NOS Pancreas disorder, NOS Impetigo Skin abscess Cellulitis Infection of skin or subcutaneous (soft) tissue, NOS Erythema multiforme Erythema nodosum Arthritis, infectious (septic arthritis) Vertebrae, osteomyelitis (bone infection) Intervertebral disc, infection (infective discitis) Muscle, infection (pyomyositis, infective myositis) Synovitis, tenosynovitis, infective (any site) Bursitis, infective (any site) Necrotizing fasciitis Bone infection (osteomyelitis), acute Bone infection (osteomyelitis), chronic Bone infection (osteomyelitis), NOS Kidney infection, acute (pyelonephritis) Kidney infection, chronic (pyelonephritis) Kidney, renal abscess or perinephric abscess Kidney or ureter, disorder NOS Bladder, cystitis, acute infectious Bladder, cystitis, chronic Bladder, cystitis NOS Urethra, infectious or noninfectious urethritis Urinary tract infection, NOS Urinary system, disorder NOS Prostate, abscess Prostate, disorder NOS Epididymis, infection (epididymitis) Testis, orchitis Epididymitis or orchitis, NOS (unclear which) Penis, disorders NOS Male genital organs, disorder NOS Breast, disorder NOS Salpingitis, oophoritis or salpingo-oophoritis Uterus, inflammatory or infectious disorder Cervix, inflammatory or infectious disorder Internal female reproductive organs and adnexa NOS, inflammatory or infectious disorder Vagina, vaginitis, acute Vagina, vaginitis, chronic Vagina or vulva, inflammatory or infectious disorder NOS Spontaneous abortion/miscarriage, with complication Medical abortion, with complication Abortion NOS, with complication Puerperal (post-delivery) infections or sepsis Pulmonary embolism, septic obstetrical thromboembolism Pleurisy (infectious or noninfectious) Hepatomegaly Skin, rash NOS Shock, septic Common cold (acute nasopharyngitis) Chronic myringitis Disorder of nose and/or sinuses, infectious or noninfectious NOS Disorder of iris or ciliary body of eye Disorder of the cardiovascular/circulatory system, NOS Chronic sinusitis Epiglotittis, acute Conjunctivitis, any type or cause Disorder of pulmonary vessels, NOS Deep venous thrombosis/thrombophlebitis, leg (DVT) Endophthalmitis, infectious Endocarditis, infective, acute or subacute Disorder of upper respiratory tract, infectious or noninfectious NOS Disorder of lacrimal system Laryngitis or tracheitis, acute Lower respiratory tract infection, acute infectious Laryngitis or tracheitis, chronic Mastoiditis (acute or chronic, infectious or noninfectious) Myocarditis, chronic Myocarditis/carditis, acute infective Pharyngitis, acute Peritonsillar abscess Pericarditis, acute, infective Disorder of eye(s), NOS Pneumonia, viral Otitis media, infectious Otitis externa, infectious Retropharyngeal or parapharyngeal abscess Tonsillitis, acute Sinusitis, acute Pneumonia, fungal/yeast Tonsillitis, chronic Superficial venous thrombosis/thrombophlebitis, anywhere Pneumonia, NOS Lymphangitis Pulmonary embolism (thromboembolism), septic Upper respiratory infection, acute NOS Pneumonia, bacterial Sepsis (SIRS due to infection, without acute organ failure) Iatrogenic, infection, related to vascular access other than central line Iatrogenic, infection, following a procedure or surgery, NOS Iatrogenic, infection, heart valve prosthesis (incl prosthetic valve endocarditis) Iatrogenic, infection, cardiac or vascular prosthetic device or implant or graft NOS Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI) Iatrogenic, infection, urinary catheter Iatrogenic, infection, internal orthopedic prosthetic device or implant or graft or bone device Iatrogenic, infection, internal prosthetic device or implant or graft NOS Resistance to antimicrobials, antiviral agent Observation for suspected infection NOS Infectious contact/exposure, rabies, without disease (yet) Infectious contact/exposure, HIV, without disease (yet) HIV infection, asymptomatic Colonized with organism (not infected) Not an Infection (ICD10 pathogen alternative) Dermatophytosis (tineas, cutaneous fungal infection) Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii Rabies OR for buglist rabies virus Toxoplasmosis OR for buglist Toxoplama gondii Severe sepsis Influenza without pneumonia but with other respiratory manifestations Influenza virus NOS -- should almost never be used Entamoeba histolytica (amoebic infection of non-intestinal sites) Infections in ICD10 Streptococcus group B (strep agalactiae) Staphylococcus, NOS Bartholin's gland, disorder, infectious or not Infectious organism, unknown Stenotrophomonas species Citrobacter species Enterobacter species Acinetobacter species Breast, inflammatory or infectious disorder of breast Klebsiella species Bronchitis, chronic, infectious or noninfectious Serratia species Enterococcus species Candida species Bronchitis, acute or chronic not specified, infectious or noninfectious Other type of infectious organism, NOS Infectious disease NOS Parasitic infection, NOS Bug Bugs Endocarditis, infective, chronic Respiratory syncytial virus (RSV) Nosocomial infection, NOS Gastrointestinal infection (gastroenteritis, colitis), viral Gastrointestinal infection (gastroenteritis, colitis), protozoal, NOS Gastrointestinal infection (gastroenteritis, colitis), bacterial, NOS Pathogens Treponema pallidum (Syphilis) Viral infection, NOS CCMDB.accdb Change Log 2019 Septic Thrombosis or Embolism, NOS Psoas abscess Retroperitoneal abscess COVID-19 (SARS-COV-2) Other specified infectious agents as the cause of diseases classified by other ICD10 code Carrier of infectious disease, unspecified Fournier's gangrene Progressive Multifocal Leukoencephalopathy (PML)	ICD10 Dx check Data Integrity Checks CCMDB.accdb
Query check ICD10 awaiting has Transfer Ready DtTm	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.	implemented	CCMDB.accdb	Awaiting/delayed transfer to long-term care/PCH inside or outside of Winnipeg Transfer Ready DtTm tmp entry	Transfer Ready ICD10 Dx check Registry checks Data Integrity Checks CCMDB.accdb
PL 2Phin Fake or Blank	Finds blank PHINs and those entered to meet function Validate_PHIN so Data Processor can apply PseudoPHIN via Generating PseudoPHINs.	implemented	Centralized data front end.accdb	PHIN field	Centralized data front end.accdb PL queries Registry checks Data Processing Data Integrity Checks
Query check eliminated ICD10	disallows any currently entered diagnosis that has been eliminated	implemented	CCMDB.accdb	Eliminating a diagnosis from collection	ICD10 Dx check CCI Px check Data Integrity Checks CCMDB.accdb
Query check eliminated CCI Pick	disallows any currently entered diagnosis that has been eliminated	implemented	CCMDB.accdb	Eliminating a diagnosis from collection	CCI Px check Data Integrity Checks CCMDB.accdb
Query check eliminated CCI Comp	disallows any currently entered diagnosis that has been eliminated	implemented	CCMDB.accdb	Eliminating a diagnosis from collection	CCI Px check Data Integrity Checks CCMDB.accdb
Query check tmp 2 BL TR S same tm	There can't be two Transfer Ready DtTm or two Boarding Loc or two Service tmp entries with the same date and time	implemented	CCMDB.accdb	Boarding Loc Service tmp entry Transfer Ready DtTm tmp entry	Tmp check Data Integrity Checks CCMDB.accdb
Query check tmp Service and Boarding Loc during admission timeframe	Service tmp entry and Boarding Loc date and time var need to be between Admit DtTm and Dispo DtTm.	implemented	CCMDB.accdb	Dispo DtTm field Boarding Loc Service tmp entry Admit DtTm	Tmp check Data Integrity Checks CCMDB.accdb
Query check pt from ER	part of validating Boarding Loc	implemented	CCMDB.accdb	Previous Location field	Data Integrity Checks CCMDB.accdb
Query check CCI ICD10 Dialysis no Dx	If a profile has one of the #Dialysis CCI Items there should also be one of the #Dialysis qualifying Dxs.	implemented	CCMDB.accdb	CRRT (TISS Item) Intermittent hemodialysis (TISS Item) Peritoneal dialysis (TISS Item) Acidosis, NOS Kidney, acute tubular necrosis (ATN) Kidney, acute renal failure NOS Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic Kidney, renal tubular acidosis (RTA, all types) Congestive heart failure with pulmonary edema Fluid overload Kidney, acute renal failure, postprocedural Insulin or other antidiabetes drug, overdose/toxicity Drug or biological substance/agent NOS, overdose/toxicity Antiseizure drug NOS, overdose/toxicity Psychiatric drug NOS, overdose/toxicity Aspirin or other salicylate or NSAID, overdose/toxicity Calcium channel blocker, overdose/toxicity Alcohol (ethanol), poisoning Toxic alcohols, poisoning Hyperkalemia, severe or symptomatic	ICD10 Dx check Data Integrity Checks CCMDB.accdb TISS28 check Dialysis
Query check CCI must have entry	There must be at least 1 CCI entry in L_CCI_Picklist table (which might be No procedure performed)	implemented	CCMDB.accdb	L_CCI_Picklist table CCI Collection No procedure performed	CCI CCI Px check Data Integrity Checks CCMDB.accdb
Query check CCI vs LOS count days component	Confirm that CCI Collection Mode or CCI Component CCI collect count days items don't have a count > LOS.	implemented	CCMDB.accdb	Dispo DtTm field LOS Service tmp entry	CCI Px check Data Integrity Checks Length of stay Labs CCMDB.accdb
Query check CCI vs LOS count days picklist	Confirm that CCI Collection Mode for CCI Picklist CCI collect count days items don't have a count > LOS.	implemented	CCMDB.accdb	Dispo DtTm field ECMO, VV ECMO, VA LOS Service tmp entry Prone positioning	CCI Px check Data Integrity Checks Length of stay Labs CCMDB.accdb
Query check CCI TISS discontinuous ETT	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).	implemented	CCMDB.accdb	Planned extubation (TISS Item) Unplanned extubation (TISS Item) Insertion of ETT (TISS Item)	Data Integrity Checks CCMDB.accdb TISS28 check
Query check CCI TISS matching BoardingLoc time	If the Px Date component of a CCI Picklist has a time, then there must be a corresponding Boarding Loc entry	implemented	CCMDB.accdb	CCI Picklist Boarding Loc	CCI CCI Px check Data Integrity Checks CCMDB.accdb TISS28 timing checks TISS28 check
Link suspect mismatch pre inpt should be ours incomplete query	What is description	implemented	Centralized data front end.accdb		Multiple encounter longitudinal consistency check Centralized data front end.accdb Registry checks Data Processing Data Integrity Checks Multiple Encounter linking
Reconnect check orphans query	Record meets following conditions RecordStatus field is incomplete the record doesn't have the same SentDtTm field as the newest SentDtTm for that Service/Location.	implemented	Centralized data front end.accdb	RecordStatus field Service/Location field SentDtTm field	Centralized data front end.accdb PL queries Data Processing Data Integrity Checks
Reconnect check missing L Tables content query	Complete patients must have entries in all of L_ICD10 table L_CCI_Picklist table L_Labs_Flowsheet table L_Pharm_Flowsheet table	implemented	Centralized data front end.accdb	L_Labs_Flowsheet table L_Pharm_Flowsheet table Quality Assurance queries in CFE Sending Patients L Como table L_Dxs table	Centralized data front end.accdb Data Integrity Checks
Reconnect check Completes query	Shows any records in that have RecordStatus "Complete", indicating failed send.	implemented	Centralized data front end.accdb	RecordStatus field Sending Patients	Centralized data front end.accdb CCI wiki infrastructure Data Integrity Checks
Query s tmp Boarding Loc ER delay reasonable	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	implemented	CCMDB.accdb	ER Delay Boarding Loc	Tmp check Registry checks Data Integrity Checks CCMDB.accdb
Query NDC dx implying death across encounters	Category:Diagnosis implying death across encounters	implemented	Centralized data front end.accdb	Brain death Sudden cardiac death (and died) Medical Assistance In Dying Deceased patients	Multiple encounter longitudinal consistency check Centralized data front end.accdb ICD10 Dx check Registry checks Data Integrity Checks End-of-life related data
Query Check BL TR combiner null	Checks that all Boarding Loc / Transfer Ready DtTm tmp entry pairs have a non-null combiner integer.	implemented	CCMDB.accdb	Boarding Loc Transfer Ready DtTm tmp entry	Transfer Ready Admit/Discharge Data Integrity Checks CCMDB.accdb
Query check no consecutive same BL or Service	Check that there are no two identical Boarding Locs or Services without a different one with a time stamp in between those two.	implemented	CCMDB.accdb	Boarding Loc Service tmp entry	Data Integrity Checks CCMDB.accdb
Query check Transfer DtTm after paired BL and before later BL	For each pair, the Transfer Ready DtTm tmp entry should never be earlier any Boarding Loc dttm, nor later than the next Boarding Loc	implemented	CCMDB.accdb	Boarding Loc Transfer Ready DtTm tmp entry	Transfer Ready Data Integrity Checks CCMDB.accdb
Query check CCI Component no admin entries	There must be no No procedure entered/Blank procedure entry in CCI Component.	implemented	CCMDB.accdb	CCI Component Blank procedure entry No procedure entered	CCI CCI Px check Data Integrity Checks CCMDB.accdb
Query check ICD10 trach has trach but no TISS	If there is a Tracheostomy, has one (Z93.0) ICD10, there should likely be a T23 - Trach Tube Present (TISS Item)	implemented	CCMDB.accdb	Trach Tube Present (TISS Item) Tracheostomy, has one	Tracheostomy ICD10 Dx check CCI Px check Data Integrity Checks CCMDB.accdb TISS28 check
Query check ICD10 trach create but no TISS	If there is an acquired Tracheostomy creation there also has to be a Trach Tube Present (TISS Item)	implemented	CCMDB.accdb	Trach Tube Present (TISS Item) Tracheostomy creation	Tracheostomy CCI Px check Data Integrity Checks CCMDB.accdb TISS28 check
Query check ICD10 CLI vs CCI CentralLine	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).	implemented	CCMDB.accdb	Central venous catheter (TISS Item) Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)	ICD10 Dx check Old dx check Data Integrity Checks CCMDB.accdb TISS28 check
Query check ICD10 trach dxs consistent	Tracheostomy related CCI and ICD10 codes must be consistent with each other.	implemented	CCMDB.accdb	Trach Tube Present (TISS Item) Tracheostomy complication, hemorrhage from site Tracheostomy complication, malfunction Tracheostomy complication, tracheo-esophageal fistula Tracheostomy complication, NOS Tracheostomy, has one	Tracheostomy ICD10 Dx check CCI Px check Data Integrity Checks CCMDB.accdb TISS28 check
Query check_ICD10_ESRD_and_AKI_only_if_transplant	A patient who has an ESRD dx and an AKI dx is an error unless they also have a kidney transplant CCI.	implemented	CCMDB.accdb	Kidney, acute tubular necrosis (ATN) Kidney, acute renal failure NOS Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic Transplant Kidney, acute renal failure, postprocedural (T) Kidney Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15 Kidney Transplant Coding Guidelines	ICD10 Dx check Data Integrity Checks ICD10 CCMDB.accdb
Query check tmp BedHeld	Sanity check for BedHeldEnd DtTm	implemented	CCMDB.accdb	Dispo DtTm field BedHeldEnd DtTm	Tmp check Registry checks Data Integrity Checks CCMDB.accdb
Query s tmp EuroSCORE II checks	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	implemented	CCMDB.accdb	Service/Location field EuroSCORE II	Tmp check Data Integrity Checks CCMDB.accdb Service/Location check
Query check CCI Picklist if no admin entries	There must be no No procedure entered/Blank procedure entry in CCI Picklist.	implemented	CCMDB.accdb	CCI Picklist Blank procedure entry No procedure entered	CCI CCI Px check Data Integrity Checks CCMDB.accdb
Query check long transfer delay	Is the Transfer Delay (Critical Care) or Transfer Delay (Medicine) unreasonably long?	needs review	CCMDB.accdb	Dispo DtTm field Transfer Ready DtTm tmp entry Transfer Delay (Critical Care) Transfer Delay (Medicine)	Transfer Ready Admit/Discharge Data Integrity Checks CCMDB.accdb To do
Query Import request matcher	Records in for which we have patients in L_Log but no lab records from DSM	needs review	DSM Labs Consistency check.accdb	Instructions for requesting a batch of data from DSM Instructions for importing a batch of DSM Data DSM Labs data.accdb	DSM Labs Extract Data Integrity Checks DSM Labs Consistency check.accdb DSM check
Function long LOS()	LOS/Length of Stay should not be unlikely long based on historical LOS for a given ward (Service/Location field).	needs review	CCMDB.accdb	Dispo DtTm field LOS Admit DtTm	Registry checks Data Integrity Checks Length of stay 2016 Time and Place changes CCMDB.accdb Service/Location check
Query cardiac arrest throughout admission	Any patient who is admitted to ICU from Med or another ICU with a #Cardiac Arrest dx should have one in their immediately preceeding Med or ICU record also.	needs review	Centralized data front end.accdb	Dispo field Previous Location field Cardiac arrest Admit Diagnosis Acquired Diagnosis / Complication	Centralized data front end.accdb Tmp check Questions Data Integrity Checks Service/Location check
Query check CCI each count vs LOS	Confirm that a Category:Labs Imaging count is not unreasonably high	needs review	CCMDB.accdb	CT of chest with PE protocol (CT angiogram of pulmonary vessels) Cardiac MRI Blood gas, arterial Blood gas, venous Angiogram, artery NOS (except specifically coded) AXR (abdominal plain X-ray) Angiogram, vein Angiogram, aortic (any part of aorta) Angiogram, cerebral (including vertebral arteries) Angiogram, coronary (diagnostic cardiac catheterization) Cardiac CT or Cardiac CT angiogram (with or without coronary arteries) CXR (plain film) ECHO (echocardiogram of heart) Angiogram, pulmonary artery (pulmonary arteriogram) Cardiac nuclear scan (e.g. MUGA) LOS	CCI Px check Data Integrity Checks Length of stay Labs CCMDB.accdb
Check organ donors must be dead	organ donors must be deceased	not feasible	CCMDB.accdb		Legacy Content Data Integrity Checks CCMDB.accdb
Query s tmp Borrow no borrow on own unit	Can't have Project Borrow arrive on own unit	not feasible	CCMDB.accdb	Project Borrow arrive	Tmp check Data Integrity Checks CCMDB.accdb
Query check ICD10 ESRD vs ARF	Can't have ESRD and acute renal failure, except if there was a transplant during this ward stay	not feasible	CCMDB.accdb	Kidney, acute tubular necrosis (ATN) Kidney, acute renal failure NOS Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic Kidney, acute renal failure, postprocedural Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15 ICD10 Guideline for Renal Coding	ICD10 Dx check Data Integrity Checks ICD10 CCMDB.accdb
Check BRR/XBR vs cardiac arrest dx	If there is an Admit Diagnosis or Acquired Diagnosis of at least one of: Witnessed Cardiac Arrest Unwitnessed Cardiac Arrest then there has to be a BRR collection entry.	retired	CCMDB.accdb	BRR Unwitnessed Cardiac Arrest Witnessed Cardiac Arrest	Legacy Content Data Integrity Checks CCMDB.accdb
Check Function Panelling admit transfer same	If patient has Panelling or Discharge Planning as Admit Diagnosis then Arrive DtTm field must be equal to Transfer Ready DtTm field.	retired	CCMDB.accdb	Transfer Ready DtTm field Panelling or Discharge Planning	Legacy Content Old dx check Data Integrity Checks CCMDB.accdb
Query check ApARF CRF	ARF (APACHE) and CRF - Chronic Renal Failure can not be coded together for the same patient.	retired	CCMDB.accdb	ARF (APACHE) Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15	Legacy Content ICD10 Dx check Data Collection Guide Data Integrity Checks CCMDB.accdb
Query Check Renal IncompatibleDxs	can't have ARF and CRF in same record	retired	CCMDB.accdb	ARF (Diagnosis) ARI Acute Tubular Necrosis (ATN) Renal Transplant CRF - Chronic Renal Failure	Legacy Content Old dx check Data Integrity Checks CCMDB.accdb
Query check trach dx task	make sure Trach Task is entered correctly	retired	CCMDB.accdb	Trach Task	Legacy Content Data Integrity Checks CCMDB.accdb
Query s tmp QAInf basic	checks that none of int, float, bool fields are used in this data.	retired	CCMDB.accdb	QA Infection QA Infection CLI QA Infection VAP	Legacy Content Data Integrity Checks CCMDB.accdb
Query s tmp QAInf dx no tmp	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"	retired	CCMDB.accdb	QA Infection QA Infection CLI QA Infection VAP	Legacy Content Data Integrity Checks CCMDB.accdb
Query s tmp QAInf tmp no dx	If "QAInf" entry is present in L_TmpV2 then program must be "CC" the corresponding diagnosis must exist	retired	CCMDB.accdb	QA Infection QA Infection CLI QA Infection VAP Pneumonia, ventilator-associated (VAP) Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)	Legacy Content Data Integrity Checks CCMDB.accdb
Query s tmp QAInf LT 48 hrs after admit	DtTm of QAInf entry has to be at least 48hrs after patient admission unless the inf_dttm is blank.	retired	CCMDB.accdb	QA Infection QA Infection CLI QA Infection VAP	Legacy Content Data Integrity Checks CCMDB.accdb
Query s tmp ACP	error if ACP Status collection in ICU is missing part of the entry.	retired	CCMDB.accdb	ACP Status collection in ICU	Legacy Content Data Integrity Checks CCMDB.accdb
Query check VAP admit must be from ICU	VAP should only be Admit Diagnosis when Previous Location is an ICU.	retired	CCMDB.accdb	Previous Location field Pneumonia, ventilator-associated (VAP) Admit Diagnosis	Multiple encounter longitudinal consistency check VAP - Ventilator Associated Pneumonia ICD10 Dx check Old dx check Registry checks Data Integrity Checks CCMDB.accdb
Query NDC VAP unacceptable date	Checks for Arrive DtTm before QA Infection VAP date and Dispo DtTm after QA Infection VAP date.	retired	Centralized data front end.accdb	Dispo DtTm field QA Infection VAP Pneumonia, ventilator-associated (VAP)	Centralized data front end.accdb Old dx check Registry checks Data Integrity Checks
Query NDC VAP AcqDX but NoVAP DateinTMPV2	Checks that any record with an Acquired Diagnosis VAP has a QA Infection VAP entry with a date.	retired	Centralized data front end.accdb	QA Infection VAP Pneumonia, ventilator-associated (VAP) Acquired Diagnosis / Complication	Centralized data front end.accdb Old dx check Registry checks Data Integrity Checks
Query NDC VAP No AcqDX but VAP DateinTMPV2	Checks that any record with QA Infection VAP entry with a date also has an Acquired Diagnosis VAP .	retired	Centralized data front end.accdb	QA Infection VAP Pneumonia, ventilator-associated (VAP) Acquired Diagnosis / Complication	Centralized data front end.accdb Old dx check Registry checks Data Integrity Checks
Check eliminated dx	disallows any currently entered diagnosis that has been eliminated	retired	CCMDB.accdb	Eliminating a diagnosis from collection	Old dx check Data Integrity Checks CCMDB.accdb
Query NDC zCRRT TISS no tmp	Record has T33 - CRRT (TISS Item) but no CRRT Project tmp entry	retired	Centralized data front end.accdb	CRRT (TISS Item) CRRT Project	Centralized data front end.accdb Legacy Content Data Integrity Checks Legacy Tmp check Legacy TISS28 check
Query NDC zCRRT tmp no TISS	Record has CRRT tmp but no T33 - CRRT (TISS Item) entry	retired	Centralized data front end.accdb	CRRT (TISS Item) CRRT	Centralized data front end.accdb Data Integrity Checks Legacy Tmp check Legacy TISS28 check
Query check CCI CRRT vs Tmp	If CCI CRRT (incl volume removal via PRISMA device) exists there should be a tmp CRRT entry and vice versa	retired	CCMDB.accdb	CRRT (incl volume removal via PRISMA device) CRRT Project	Tmp check CCI Px check Data Integrity Checks CCMDB.accdb
Query NDC CLI unacceptable date	Checks that the QA Infection CLI Dt is between the Arrive DtTm and Dispo DtTm	retired	Centralized data front end.accdb	Dispo DtTm field QA Infection CLI Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)	Centralized data front end.accdb Old dx check Registry checks Data Integrity Checks
Query s tmp Borrow sensible DtTm vs no borrow	Checks that data for Project Borrow arrive follows that project's	retired	CCMDB.accdb	Project Borrow arrive	Tmp check Data Integrity Checks CCMDB.accdb
Query s tmp Borrow duplicates	Checks that data for Project Borrow arrive follows that project's	retired	CCMDB.accdb	Project Borrow arrive	Tmp check Data Integrity Checks CCMDB.accdb
Query check overstay not entered	check that all has been entered for the Overstay project	retired	CCMDB.accdb	Overstay Predictor Project Overstay Predictor Project Collection Instructions	Tmp check Data Integrity Checks OverstayProject CCMDB.accdb
Query check overstay pt from our med	pts from a location where we collect should not have Overstay colour	retired	CCMDB.accdb	Overstay Predictor Project Overstay Predictor Project Collection Instructions	Tmp check Data Integrity Checks OverstayProject CCMDB.accdb
Query check overstay no colour	Med pts must have Overstay colours	retired	CCMDB.accdb	Overstay Predictor Project Overstay Predictor Project Collection Instructions	Tmp check Data Integrity Checks OverstayProject CCMDB.accdb
Query check dispo lower acuity than location	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.	retired	CCMDB.accdb	Dispo field Transfer Ready DtTm field	Transfer Ready Legacy Content Data Integrity Checks CCMDB.accdb
Query check ICD10 ESRD vs AP ARF	ARF (APACHE) and CRF - Chronic Renal Failure can not be coded together for the same patient.	retired	not entered	ARF (APACHE) Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15 ICD10 Guideline for Renal Coding	ICD10 Dx check Data Collection Guide Data Integrity Checks
Function Transfer Ready DtTm vs status	If Transfer_Ready_DtTm is blank, TR_info_status must not be; if TR_info_status has content, Transfer_Ready_DtTm must be blank.	retired	CCMDB.accdb	TR info status field Transfer Ready DtTm tmp entry	Registry checks Data Integrity Checks CCMDB.accdb
Function Validate Transfer Ready DtTm	doesn't allow violation of function Transfer_Ready_DtTm_vs_status	retired	CCMDB.accdb	Function Transfer Ready DtTm vs status Transfer Ready DtTm tmp entry	Registry checks Data Integrity Checks CCMDB.accdb
Query TISS Errors vent vs vent2300	Any marked TISS Item T - Invasive mechanical ventilation at 2300 hrs (TISS Item) has to have a corresponding marked TISS Item T18 - Invasive Mechanical Ventilation (TISS Item) for the same date.	retired	Centralized data front end.accdb	Invasive Mechanical Ventilation (TISS Item) Invasive mechanical ventilation at 2300 hrs (TISS Item)	Centralized data front end.accdb Legacy Content Data Integrity Checks Legacy Registry check Legacy TISS28 check
Query TISS Errors CVC vs CVC2300	Any marked TISS Item T - Central Venous Catheter at 2300 (TISS Item) has to have a corresponding marked TISS Item T17 - Central venous catheter (TISS Item) for the same date.	retired	TISS28.accdb	Central Venous Catheter at 2300 (TISS Item) Central venous catheter (TISS Item)	Data Integrity Checks TISS28.accdb Legacy TISS28 check
Query TISS Errors BIPAP vs BIPAP2300	Any marked TISS Item T - BIPAP at 2300 (TISS Item) has to have a corresponding marked TISS Item T21 - Non-invasive CPAP or BIPAP (TISS Item) for the same date.	retired	TISS28.accdb	Non-invasive CPAP or BIPAP (TISS Item) BIPAP at 2300 (TISS Item)	Data Integrity Checks TISS28.accdb Legacy TISS28 check
Query TISS Errors D ID not in CFE	The D_ID on a TISS28 form does not exist in CFE	retired	TISS28.accdb	Centralized data front end.accdb D ID field	TISS28 Scanning Process Data Integrity Checks TISS28.accdb Legacy TISS28 check
Query NDC TISS CCI endoscopic	If pt has T26 & 27 - Endoscopy (TISS Item) then there must be an endoscopic CCI for that day.	retired	Centralized data front end.accdb	Endoscopy (TISS Item) ERCP (endoscopic retrograde cholangiopancreatography) Inspection, Exploration (endoscopic) Biopsy (endoscopic)	Centralized data front end.accdb Legacy Content Data Integrity Checks Legacy CCI Px check Legacy TISS28 check
Query NDC zCRRT CCI Px but no TISS	If there is a T33 - CRRT (TISS Item) then there should be a CRRT (incl volume removal via PRISMA device) CCI Px	retired	Centralized data front end.accdb	CRRT (TISS Item) CRRT (incl volume removal via PRISMA device)	Centralized data front end.accdb Legacy Content Data Integrity Checks Legacy CCI Px check Legacy TISS28 check
Query NDC zCRRT TISS but no CCI Px	If there is a T33 - CRRT (TISS Item) then there should be a CRRT (incl volume removal via PRISMA device) CCI Px	retired	Centralized data front end.accdb	CRRT (TISS Item) CRRT (incl volume removal via PRISMA device)	Centralized data front end.accdb Legacy Content Data Integrity Checks Legacy CCI Px check Legacy TISS28 check
Query TISS Errors TISS date out of admission	TISS date is not during admission	retired	TISS28.accdb	Dispo DtTm field TISS Item List	Legacy Content TISS28 Scanning Process Data Integrity Checks TISS28.accdb Legacy Registry check Legacy TISS28 check
Query TISS Errors duplicate Items	A TISS28 item exists twice	retired	TISS28.accdb	TISS Item List	Legacy Content TISS28 Scanning Process Data Integrity Checks TISS28.accdb Legacy TISS28 check
Link suspect transfer ready greater than dispo	Checks for records that have Transfer Ready DtTm field is greater than Dispo DtTm field.	retired	Centralized data front end.accdb	Dispo DtTm field	Centralized data front end.accdb Legacy Content Registry checks Data Integrity Checks
Link suspect transfer ready before arrive date	Checks for records that have Transfer Ready DtTm field is before Arrive_DtTm field.	retired	Centralized data front end.accdb	Transfer Ready DtTm field	Centralized data front end.accdb Legacy Content Registry checks Data Integrity Checks
Query TISS Errors missing days	There are no TISS28 entries for a day that should have at least one based on Accept DtTm and Dispo DtTm	retired	TISS28.accdb	Dispo DtTm field TISS Item List	Legacy Content TISS28 Scanning Process Data Integrity Checks TISS28.accdb Legacy TISS28 check
Query check transfer ready tmp for each Boarding Loc	There should be a Transfer Ready DtTm tmp entry for each Boarding Loc entry of a profile	retired	CCMDB.accdb	Boarding Loc Transfer Ready DtTm tmp entry	Transfer Ready Data Integrity Checks CCMDB.accdb
Query NDC Trach Dx TISS	Tracheostomy ICD10s and CCIs must be consistent with Trach TISS.	retired	Centralized data front end.accdb	Trach Tube Present (TISS Item) Tracheostomy, has one Tracheostomy creation	Tracheostomy TISS28 Legacy Centralized data front end.accdb Legacy Content ICD10 Dx check Data Integrity Checks Legacy CCI Px check
Query s tmp Boarding Loc no borrow but entry	Validates entries for Boarding Loc	retired	CCMDB.accdb	Service/Location field Boarding Loc	Tmp check Registry checks Data Integrity Checks CCMDB.accdb
Query check tmp Transfer Ready not before Boarding Loc	Validates that the DtTm for a Transfer_Ready_DtTm_tmp entry is not before its matching Boarding Loc entry	retired	CCMDB.accdb	Boarding Loc Transfer Ready DtTm tmp entry	Tmp check Registry checks Data Integrity Checks CCMDB.accdb
Query NDC Pacemaker acquired vs TISS	Records with Acquired Procedure of Pacemaker insertion, temporary that don't have date-matching Pacemaker insertion or vice versa.	retired	Centralized data front end.accdb	Permanent Pacemaker Insertion Pacemaker insertion (TISS Item) Pacemaker insertion, temporary Pacemaker insertion, permanent	Centralized data front end.accdb Legacy Content Data Integrity Checks
Query NDC cardioversion dx vs TISS	If pt has Acquired Procedure Cardioversion (EXCLUDE defibrillation-we are not tracking), then the TISS28 item T26 & 27 - Cardioversion (TISS Item) (T41) must be marked.	retired	Centralized data front end.accdb	Cardioversion (TISS Item) Acquired Procedure Cardioversion (EXCLUDE defibrillation-we are not tracking)	Centralized data front end.accdb CCI Px check Data Integrity Checks TISS28 check
Query check CCI InExtubation consistent	Any marked TISS Item T40 - Insertion of ETT (TISS Item) or in T22 - ETT Present (TISS Item) must have at least one marked TISS item either in T28 - Planned extubation (TISS Item) or in T29 - Unplanned extubation (TISS Item)	retired	Centralized data front end.accdb	Planned extubation (TISS Item) Unplanned extubation (TISS Item) Insertion of ETT (TISS Item)	Centralized data front end.accdb Data Integrity Checks
Query s tmp IICU consult DtTm	"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.	retired	CCMDB.accdb	IICU consult	Tmp check Data Integrity Checks CCMDB.accdb
Check Accept Loc Park	if Previous Location = <your hospital> ER (parked) and Pre-admit Inpatient Institution = "NA / not applicable" then there must be a Accept_Loc_park entry. 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"	retired	CCMDB.accdb	Pre-admit Inpatient Institution field Previous Location field Accept Loc Park	Legacy Content Tmp check Registry checks Data Integrity Checks CCMDB.accdb
Check AcceptDtTm entered or missing checked	Either Accept DtTm field must have content or Accept DtTm missing field must be checked.	retired	CCMDB.accdb		APACHE check Registry checks Data Integrity Checks CCMDB.accdb
Function Dispo Chronological()	Checks that the registry times are in a sensible chronological order.	retired	CCMDB.accdb	Dispo DtTm field	Legacy Content Registry checks Data Integrity Checks 2016 Time and Place changes CCMDB.accdb
Query s tmp check combined BL and TRDtTm nonsequential	Validates that the combiner integers for Transfer Ready DtTm tmp entry and Boarding Loc are consecutive with the date/time_vals	retired	CCMDB.accdb	Boarding Loc Transfer Ready DtTm tmp entry	Tmp check Data Integrity Checks CCMDB.accdb
Function Validate previous service	Validates Previous Service field: can't be empty/blank	retired	CCMDB.accdb	Previous Service field	Legacy Content Data Integrity Checks CCMDB.accdb Legacy Registry check
Query check previous location vs service inconsistent	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".	retired	CCMDB.accdb	Previous Service field Previous Location field	Data Integrity Checks CCMDB.accdb Legacy Registry check
Query s tmp comfort care gt one	Only one entry allowed per patient.	retired	CCMDB.accdb	Comfort Care	Data Integrity Checks CCMDB.accdb

Checks under review

See Data Integrity Check under review