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:

CCMDB.mdb Data Integrity Checks - run in CCMDB.mdb and notify Data Collector during the collection process
CFE Data Integrity Checks - run in Centralized data front end.accdb as part of the Data Processor's job
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: 155

	Summary	Status	App	DICRelatedConcepts	Category
Minimum combined codes	Some ICD10s must always be coded as Combined ICD10 codes with at least a certain number of other codes.	declined	CCMDB.mdb	Combined ICD10 codes Has MinimumCombinedCodes	Data Integrity Checks CCMDB.mdb Legacy Content
Query NDC VAP no TISS	If a patient has a Acquired Diagnosis Pneumonia, ventilator-associated (VAP) and no TISS28 items Invasive Mechanical Ventilation (TISS Item) (T18) then this is an error.	declined	Centralized data front end.accdb	Pneumonia, ventilator-associated (VAP) Invasive Mechanical Ventilation (TISS Item) Spontaneous breathing via ETT or Trach (TISS Item)	Data Integrity Checks Centralized data front end.accdb Questions TISS28 checks Data Processing VAP - Ventilator Associated Pneumonia
Check APACHE physiological variable high low	an APACHE physiological variable is extremely high or low	implemented	CCMDB.mdb	AaDO2 AP Dias BP Field AP Sys BP Field Creatinine (APACHE) FiO2 HCT HR K Na PCO2 PH PO2 RR Serum CO2 Temperature WBC	Data Integrity Checks CCMDB.mdb APACHE II Physiological Variables APACHE check
Function long LOS()	LOS/Length of Stay should not be unlikely long based on historical LOS for a given ward (Service/Location field).	implemented	CCMDB.mdb	LOS Arrive DtTm field Dispo DtTm field	2016 Time and Place changes Length of stay Data Integrity Checks CCMDB.mdb Site/Location check Registry checks
Query check minimal data set incomplete	makes sure the Minimal Data Set is collected before records can be sent.	implemented	CCMDB.mdb	Minimal Data Set Serial number Service/Location field FirstName field LastName field PHIN field Chart number Arrive DtTm field Overstay Predictor Project Collection Instructions Overstay Predictor Project	Data Integrity Checks CCMDB.mdb Registry checks
Query check overstay no colour	Med pts must have Overstay colours	implemented	CCMDB.mdb	Overstay Predictor Project Collection Instructions Overstay Predictor Project	Data Integrity Checks CCMDB.mdb OverstayProject Tmp check
Query check overstay pt from our med	pts from a location where we collect should not have Overstay colour	implemented	CCMDB.mdb	Overstay Predictor Project Collection Instructions Overstay Predictor Project	Data Integrity Checks CCMDB.mdb OverstayProject Tmp check
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.mdb	Previous Location field	Data Integrity Checks CCMDB.mdb Registry checks
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".	implemented	CCMDB.mdb	Previous Location field Previous Service field	Data Integrity Checks CCMDB.mdb Registry checks
Query check prev pre-admit consistent	for inpatient transfers within the region, Previous Location field and Pre-admit Inpatient Institution field should be same.	implemented	CCMDB.mdb	Previous Location field Pre-admit Inpatient Institution field	Data Integrity Checks CCMDB.mdb Registry checks
Function Validate previous service	Validates Previous Service field: can't be empty/blank	implemented	CCMDB.mdb	Previous Service field	Data Integrity Checks CCMDB.mdb Registry checks
Query check tmp generate allowed	check that tmp project/item combo exists for this location in Overstay	implemented	CCMDB.mdb	Overstay Predictor Project Collection Instructions Overstay Predictor Project	Data Integrity Checks CCMDB.mdb OverstayProject Tmp check
Query s tmp project item consistent	Checks that tmp project entries only contain combinations of project and item that are allowed.	implemented	CCMDB.mdb	Tmp Project Collection	Data Integrity Checks CCMDB.mdb TmpV2 Tmp check
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.mdb	ACCU borrow ACP Status collection in ICU Accept Loc Park AcceptDateSource Alias ID collection Allied Health Consults Arrest Witnessing CCU Service Tracking CRRT Cardiac Arrest Cooling Protocol Catheter09 Comfort Care Creating a new project article Decubitus Ulcer Study DeviceUse Study Early ID study EuroScore H1N1 IABP project ICUotherService Influenza tracking Influenza treated Medical Incompetency tracking Moves for Medicine Overstay Predictor Project Peer Audit Project ABO TEE Project Borrow arrive Projects QA Infection CLI QA Infection VAP QA Septic Shock Septic Shock Order Set SmartPump Audit Transfusion Audit Query check CCI CRRT vs Tmp Query check tmp generate allowed Query s tmp QASeptic tmp no dx Query s tmp apostrophe in comment Check overstay not entered Query check overstay no colour Query check overstay pt from our med Query s tmp project item consistent IICU consult Query NDC zCRRT TISS no tmp Query NDC zCRRT tmp no TISS Query s tmp IICU consult DtTm Query s tmp IICU consult not paired Query s tmp QASeptic Dx no tmp ICD10 Bed Census Data Processing Instructions Bed census.mdb File:BedCensusAnnouncement Letter May 2012.pdf Catheter09 Wednesday, November 25, 2009 Catheter09 Wednesday, October 28.09 Contacting Quality Officer and Manager for VAPs and CLIs Critical Care Vital Signs Monitoring Family Satisfaction in the Intensive Care Unit File:Form Individual Site Bed example .pdf File:Form Site Bed Data Summary.pdf L TmpV2 table Legacy Processing Instructions Bed census.mdb List of Factor affecting data quality Peer Audit Partners Programmer-Peer Audit output problem table QA Infection Query s tmp ABO TEE checks Re-import of TmpV2 data from Julie's Export 2014-09-08 Re-import of TmpV2 data from Julie's Export 2014-09-18 Re-import of TmpV2 data from Julie's Export 2014-09-22 Re-import of TmpV2 data from Julie's Export 2014-09-25 Staphylococcus aureus TMP dates imported backwards Temporary study guidelines Transfer Delay VAP - Ventilator Associated Pneumonia WRHA Outcomes Improvement Team Query s tmp Borrow duplicates Query s tmp Borrow no borrow on own unit Query s tmp Borrow sensible DtTm vs no borrow Query s tmp IICU consult dispo to IICU but no tmp Function TmpChecker Query NDC CLI AcqDX but NoCLI DateinTMPV2 Query NDC CLI No AcqDX but CLI DateinTMPV2	Data Integrity Checks CCMDB.mdb Tmp check
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.mdb	PHIN field	Data Integrity Checks CCMDB.mdb Registry checks
Function PHIN same as Chart	PHIN can't be the same as Chart	implemented	CCMDB.mdb	PHIN field Chart number	Data Integrity Checks CCMDB.mdb Registry checks
Function Validate Province	Validates the Province field: can't be left blank must not fail function Validate_PHIN	implemented	CCMDB.mdb	Province field PHIN field	Data Integrity Checks CCMDB.mdb Registry checks
Date of Birth	The minimum age allowed is 10, the maximum age allowed is 120.	implemented	CCMDB.mdb	Date of Birth	Data structure Data Collection Guide Registry Data Demographics L Log table L PHI table Data Integrity Checks CCMDB.mdb CCMDB.mdb cross checks triggering for correct values Registry checks
Function Validate Dispo	doesn't allow empty	implemented	CCMDB.mdb	Dispo field	Data Integrity Checks CCMDB.mdb Registry checks
Function Validate Transfer Ready DtTm	doesn't allow violation of function Transfer_Ready_DtTm_vs_status	implemented	CCMDB.mdb	Transfer Ready DtTm field Function Transfer Ready DtTm vs status	Data Integrity Checks CCMDB.mdb Registry 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.	implemented	CCMDB.mdb	Transfer Ready DtTm field TR info status field	Data Integrity Checks CCMDB.mdb Registry checks
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).	implemented	TISS28.mdb	LOS TISS Arrive DtTm field Dispo DtTm field	Data Integrity Checks Data Processing Length of stay TISS28 checks Registry checks TISS28.mdb TISS28 Scanning Process Questions
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.mdb	Dx Primary Admit Diagnosis Primary Admit Diagnosis	Data Integrity Checks CCMDB.mdb ICD10 Dx check
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.mdb	Dx Primary Dx Priority	Data Integrity Checks CCMDB.mdb ICD10 Dx check
Query check ICD10 date	Acquired Diagnosis / Complication must have Dx Date or Dx Date unknown, other Dx Type must have neither, and must be Arrive_DtTm<Dx_Date<Dispo_DtTm	implemented	CCMDB.mdb	ICD10 Diagnosis Acquired Diagnosis / Complication Admit Diagnosis Comorbid Diagnosis Dx Type Dx Date Dx Date unknown Arrive DtTm field Dispo DtTm field	Data Integrity Checks CCMDB.mdb ICD10 ICD10 Dx check
Query check ICD10 unfilled	ICD10 entry with missing Dx_Type, Dx_Priority or No Dx Entered	implemented	CCMDB.mdb	Dx Type Dx Priority No Dx Entered	Data Integrity Checks CCMDB.mdb ICD10 ICD10 Dx check
Query check CCI no admin entries	There must be no No procedure entered/Blank procedure entry in CCI Picklist or CCI Component.	implemented	CCMDB.mdb	CCI Picklist CCI Component No procedure entered Blank procedure entry	Data Integrity Checks CCMDB.mdb CCI CCI Px check
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.mdb	CCI Picklist CCI Component No procedure performed	Data Integrity Checks CCMDB.mdb CCI CCI Px check
Query check CCI Date	Px Date must be sensible when compared to Arrive_DtTm and Dispo_DtTm	implemented	CCMDB.mdb	Px Date Arrive DtTm field Dispo DtTm field Px Type	Data Integrity Checks CCMDB.mdb CCI Px check
Query check CCI Component unfilled	CCI Component entry with missing px, Px_Type or Px_Count	implemented	CCMDB.mdb	CCI Component Px Count Px Type	CCI CCI Px check Data Integrity Checks CCMDB.mdb
Query check CCI Picklist unfilled	CCI Picklist entry with missing px, Px_Type or Px_Count	implemented	CCMDB.mdb	CCI Picklist Px Type Px Count	Data Integrity Checks CCMDB.mdb CCI CCI Px check
Query check CCI component 1 and 2 compatible	Component CCIs must have compatible component 1 and component 2	implemented	CCMDB.mdb	CCI Procedure	Data Integrity Checks CCMDB.mdb CCI Px check
Query check dispo lower acuity than location	check for patients going to lower level of care but without Transfer_Ready_DtTm; Check will launch an error but allow no date, ie it's just a reminder, see #hierarchy of levels of care.	implemented	CCMDB.mdb	Transfer Ready DtTm field Dispo field	Data Integrity Checks CCMDB.mdb Questions ICD10 Dx check CCI Px check Site/Location check
Check AcceptDtTm entered or missing checked	Either Accept DtTm field must have content or Accept DtTm missing field must be checked.	implemented	CCMDB.mdb	Accept DtTm field Accept DtTm missing field	Data Integrity Checks APACHE check Registry checks CCMDB.mdb
Check Function Validate PostalCode	Validates that Postal Code field only contains characters in format allowed for a postal code	implemented	CCMDB.mdb	Postal Code field	Data Integrity Checks Registry checks Postal Codes CCMDB.mdb
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.mdb	LastName field	Data Integrity Checks Registry checks CCMDB.mdb
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.mdb	FirstName field	Data Integrity Checks CCMDB.mdb Registry checks
Check function location NE dispo	Service/Location field can't be same as Dispo field	implemented	CCMDB.mdb	Service/Location field Dispo field	Data Integrity Checks CCMDB.mdb Registry checks
Check function previous NE Location	Previous Location field can't be same as Service/Location field	implemented	CCMDB.mdb	Service/Location field Previous Location field	Data Integrity Checks CCMDB.mdb Registry checks
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"	implemented	CCMDB.mdb	Previous Location field Pre-admit Inpatient Institution field Accept Loc Park	Data Integrity Checks CCMDB.mdb Registry checks
Check Sub PharmCheck	checks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have drug days than LOS, disallows complete check if Arrive DtTm or Dispo DtTm are missing because that would break max count check,	implemented	CCMDB.mdb	Pharmacy collection	Data Integrity Checks CCMDB.mdb
Check duplicate patient	there are no dupliate entries for the same patient ward admission on the laptop at send time	implemented	CCMDB.mdb	PHIN field Date of Birth Chart number FirstName field LastName field	Data Integrity Checks CCMDB.mdb Registry checks
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	PHIN field LastName field FirstName field Date of Birth	Data Integrity Checks Centralized data front end.accdb Registry checks PL queries Data Processing
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	Data Integrity Checks Centralized data front end.accdb Registry checks PL queries Data Processing
PL SamePHIN Site Diff chart	Another record exists for this Service/Location with the same PHIN and a different Chart number.	implemented	Centralized data front end.accdb	PHIN field Service/Location field Chart number	Data Integrity Checks Centralized data front end.accdb Registry checks PL queries Data Processing Questions
PL SamePhin Diff LN FN DOB Sex	Another record exists with the same PHIN but a different LastName field, FirstName field, Date of Birth, Sex	implemented	Centralized data front end.accdb	PHIN field LastName field FirstName field Date of Birth Sex field	Data Integrity Checks Centralized data front end.accdb Registry checks PL queries Data Processing
PL 1orphans	Record meets following conditions RecordStatus field is incomplete the record doesn't have the same SentDtTm field as the newest SentDtTm for that location.	implemented	Centralized data front end.accdb	RecordStatus field SentDtTm field Service/Location field	Data Integrity Checks Centralized data front end.accdb PL queries Data Processing
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	Registry checks Data Integrity Checks Centralized data front end.accdb PL queries Data Processing
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 Arrive DtTm.	implemented	Centralized data front end.accdb	PHIN field Arrive DtTm field Dispo DtTm field	Data Processing Multiple Encounter linking Data Integrity Checks Multiple encounter longitudinal consistency check Centralized data front end.accdb Registry checks
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	PHIN field Dispo DtTm field	Data Processing Multiple Encounter linking Data Integrity Checks Multiple encounter longitudinal consistency check Centralized data front end.accdb Registry checks
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	PHIN field Previous Location field	Data Processing Multiple Encounter linking Data Integrity Checks Multiple encounter longitudinal consistency check Centralized data front end.accdb Registry checks
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	PHIN field Dispo field	Data Processing Multiple Encounter linking Data Integrity Checks Multiple encounter longitudinal consistency check Centralized data front end.accdb Registry checks Questions
Check function Validate Pre Acute Living Situation	can't be blank	implemented	CCMDB.mdb	Pre acute living situation field	Data Integrity Checks CCMDB.mdb Registry checks
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	Visit Admit DtTm field	Data Integrity Checks Centralized data front end.accdb Registry checks
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	implemented	CCMDB.mdb	CRRT (incl volume removal via PRISMA device)	Data Integrity Checks CCMDB.mdb CCI Px check Tmp check
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.mdb	Cardiac arrest Targeted Temperature Management (TTM)	Data Integrity Checks CCMDB.mdb CCI ICD10
Query check hernia type vs complication	any abdominal hernia complication dx must have an abdominal hernia type dx coded.	implemented	CCMDB.mdb	Hiatus (diaphragmatic) hernia Inguinal hernia Abdominal hernia, NOS Abdominal hernia, with obstruction, incarceration or strangulation Abdominal hernia, with gangrene	Data Integrity Checks CCMDB.mdb Hernia ICD10 Dx check
Query check AIDS vs HIV	A record can not have both AIDS (disease due to HIV) and HIV infection, asymptomatic	implemented	CCMDB.mdb	AIDS (disease due to HIV) HIV infection, asymptomatic	Data Integrity Checks CCMDB.mdb ICD10 Dx check
Query s tmp QASeptic tmp no dx	CC pt has QA Septic Shock tmp entry and no Septic Shock/Shock, septic dx	implemented	CCMDB.mdb	QA Septic Shock Septic Shock Shock, septic	Data Integrity Checks CCMDB.mdb Tmp check ICD10 Dx check Old dx check
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	Data Integrity Checks Centralized data front end.accdb Registry checks Questions PL queries Data Processing
Query NDC zCRRT TISS no tmp	Record has CRRT (TISS Item) but no CRRT tmp entry	implemented	Centralized data front end.accdb	CRRT (TISS Item) CRRT	Data Integrity Checks Centralized data front end.accdb Tmp check TISS28 checks
Query NDC zCRRT tmp no TISS	Record has CRRT tmp but no CRRT (TISS Item) entry	implemented	Centralized data front end.accdb	CRRT (TISS Item) CRRT	Data Integrity Checks Centralized data front end.accdb Tmp check TISS28 checks
Query NDC zCRRT CCI Px but no TISS	If there is a CRRT (TISS Item) then there should be a CRRT (incl volume removal via PRISMA device) CCI Px	implemented	Centralized data front end.accdb	CRRT (TISS Item) CRRT (incl volume removal via PRISMA device)	Data Integrity Checks Centralized data front end.accdb CCI Px check TISS28 checks Questions
Query NDC zCRRT TISS but no CCI Px	If there is a CRRT (TISS Item) then there should be a CRRT (incl volume removal via PRISMA device) CCI Px	implemented	Centralized data front end.accdb	CRRT (TISS Item) CRRT (incl volume removal via PRISMA device)	Data Integrity Checks Centralized data front end.accdb CCI Px check TISS28 checks Questions
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.	implemented	CCMDB.mdb	IICU consult	Data Integrity Checks CCMDB.mdb Tmp check
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.mdb	Comorbid Diagnosis No Comorbidities (ICD10 code)	Data Integrity Checks CCMDB.mdb ICD10 ICD10 Dx check
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.mdb		Data Integrity Checks CCMDB.mdb ICD10 ICD10 Dx 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	implemented	CCMDB.mdb	Arrive DtTm field Transfer Ready DtTm field Primary Admit Diagnosis Dx Primary Awaiting/delayed transfer to home Awaiting/delayed transfer to long-term care/PCH Awaiting/delayed transfer to other acute care facility Awaiting/delayed transfer to transitional care facility Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm Admit Diagnosis Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days Awaiting/delayed transfer to other care facility NOS	Data Integrity Checks CCMDB.mdb Transfer Ready ICD10 Dx check Awaiting/delayed transfer
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.mdb	Abscess of intestine Anus or rectum, abscess Appendicitis, with or without rupture or peritonitis Arthritis, infectious (septic arthritis) Bacteremia Bacterial infection, NOS Bladder, cystitis, acute infectious Bladder, cystitis, chronic Bone infection (osteomyelitis), NOS Bone infection (osteomyelitis), acute Bone infection (osteomyelitis), chronic Bursitis, infective (any site) Cellulitis Cholangitis Chronic myringitis Colonized with organism (not infected) Dermatophytosis (tineas, cutaneous fungal infection) Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, bacterial Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, infectious NOS Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, viral Endocarditis, infective, acute or subacute Endophthalmitis, infectious Epididymis, infection (epididymitis) Food poisoning (due to foodborne bacterial toxin), NOS Fournier's gangrene in a male Fungemia, NOS Gas gangrene (usually due to Clostridium perfringens) Gastrointestinal infection (gastroenteritis, colitis), bug NOS 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, following a procedure or surgery, NOS Iatrogenic, infection, heart valve prosthesis (incl prosthetic valve endocarditis) Iatrogenic, infection, internal orthopedic prosthetic device or implant or graft or bone device Iatrogenic, infection, internal prosthetic device or implant or graft NOS Iatrogenic, infection, related to vascular access other than central line Iatrogenic, infection, urinary catheter Impetigo Infection of skin or subcutaneous (soft) tissue, NOS Infectious disease NOS Infectious mononucleosis (usually due to Epstein-Barr virus) Intervertebral disc, infection (infective discitis) Kidney infection, acute (pyelonephritis) Kidney infection, chronic (pyelonephritis) Liver abscess Lower respiratory tract infection, acute infectious Mediastinitis, infectious Meningitis, fungal Meningitis, infectious NOS Meningitis, viral - incl West Nile Muscle, infection (pyomyositis, infective myositis) Myocarditis/carditis, acute infective Necrotizing fasciitis Otitis externa, infectious Otitis media, infectious Parasitic infection, NOS Pericarditis, acute, infective Peritonitis, infectious Peritonsillar abscess Pneumonia, bacterial Pneumonia, fungal/yeast Pneumonia, ventilator-associated (VAP) Pneumonia, viral Puerperal (post-delivery) infections or sepsis Pulmonary embolism (thromboembolism), septic Pulmonary embolism, septic obstetrical thromboembolism Sepsis (SIRS due to infection, without acute organ failure) Severe sepsis Sexually transmitted (venereal) infections, NOS Skin abscess Synovitis, tenosynovitis, infective (any site) Toxic shock syndrome Upper respiratory infection, acute NOS Urinary tract infection, NOS Vertebrae, osteomyelitis (bone infection) Viral carditis Viral hemorrhagic fever, NOS Viral hepatitis, acute, NOS Viral hepatitis, chronic, NOS Abdominal hernia, with gangrene Abortion NOS, with complication Bartholin's gland, disorder, infectious or not Bladder, cystitis NOS Breast, disorder NOS Breast, inflammatory or infectious disorder of breast Cervix, inflammatory or infectious disorder Cholecystitis, acute Chronic sinusitis Common cold (acute nasopharyngitis) Disorder of anus or rectum, NOS Disorder of eye(s), NOS Disorder of iris or ciliary body of eye Disorder of lacrimal system Disorder of liver, NOS Disorder of nose and/or sinuses, infectious or noninfectious NOS Disorder of peritoneum, NOS Disorder of pulmonary vessels, NOS Disorder of respiratory system, any part, NOS Disorder of skin or subcutaneous tissues, NOS Disorder of spleen, NOS Disorder of the cardiovascular/circulatory system, NOS Disorder of upper respiratory tract, infectious or noninfectious NOS Diverticulitis, small or large intestine (diverticular disease with perforation or abscess) Diverticulosis, small or large intestine (diverticular disease without perforation or abscess) Duodenitis Endocarditis, infective, chronic Epiglotittis, acute Erythema multiforme Erythema nodosum Gallbladder or bile duct disorder, NOS Hepatomegaly Internal female reproductive organs and adnexa NOS, inflammatory or infectious disorder Interstitial lung disease, NOS Intracranial abscess Intraspinal abscess Kidney or ureter, disorder NOS Laryngitis or tracheitis, acute Laryngitis or tracheitis, chronic Lymphangitis Male genital organs, disorder NOS Mastoiditis (acute or chronic, infectious or noninfectious) Medical abortion, with complication Meningitis, bacterial, NOS Observation for suspected infection NOS Pancreas disorder, NOS Pancreatitis, acute NOS Penis, disorders NOS Pharyngitis, acute Pleural effusion, NOS Pleurisy (infectious or noninfectious) Pneumonia, NOS Prostate, disorder NOS Respiratory disorder, postprocedure/postop NOS Retropharyngeal or parapharyngeal abscess Salpingitis, oophoritis or salpingo-oophoritis Sinusitis, acute Skin, rash NOS Spontaneous abortion/miscarriage, with complication Thyroiditis, acute Tonsillitis, acute Tonsillitis, chronic Urethra, infectious or noninfectious urethritis Urinary system, disorder NOS Uterus, inflammatory or infectious disorder Acinetobacter species Actinomyces (actinomycosis) Adenovirus Aspergillus Bacillus fragilis (B. frag) Bacteria, NOS Blastomyces Botulism (due to Clostridium botulinum toxin) Candida species Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia) Cholera (due to Vibrio cholerae) Citrobacter species Clostridium perfringens Coccidioides Coronavirus Cryptococcus Cytomegalovirus (CMV) Dengue fever (due to Dengue virus) Entamoeba histolytica (amoebic infection of non-intestinal sites) Enterobacter species Enterococcus species Enterovirus - incl coxsackievirus, echovirus Escherichia coli (E. coli) Fungus or yeast, NOS HIV infection, asymptomatic Haemophilus influenzae (H. flu) Hantavirus infection Helicobacter pylori (H. pylori) Herpes simplex virus (HSV) Histoplasma Infectious contact/exposure, HIV, without disease (yet) Infectious contact/exposure, rabies, without disease (yet) Infectious organism, unknown Influenza virus NOS -- should almost never be used Influenza without pneumonia but with other respiratory manifestations Klebsiella species Legionella Listeria Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii Measles virus Molluscum contagiosum Mosquito-borne viruses (causes of encephalitis) Mucormycetes Mumps Mumps virus Mycobacterium avium-intracellulare (MAC) Mycobacterium tuberculosis (M. TB) Mycoplasma pneumoniae Neisseria gonorrhea (gonococcus) Neisseria meningitidis (meningococcus) Nocardia (nocardiosis) Nontuberculous mycobacteria Not an Infection (ICD10 pathogen alternative) Other type of infectious organism, NOS Papillomavirus Paracoccidioides Parainfluenza virus Parvovirus Pathogens Pneumocystis Jirovecii or Pneumocystis Carinii Progressive Multifocal Leukoencephalopathy (PML) (caused by JC virus) Proteus mirabilus (morganii) Protozoa, NOS Pseudomonas Rabies OR for buglist rabies virus Reovirus Resistance to antimicrobials, antiviral agent Retrovirus Rubella virus (German measles virus) Salmonella species Serratia species Shigellosis (dysentery due to Shigella species) Smallpox (due to Variola viruses) Spirochetes, NOS - incl yaws, louse-borne, tick-borne Sporothrix Staphylococcus aureus Staphylococcus, NOS Stenotrophomonas species Streptococcus group A (strep pyogenes) Streptococcus group B (strep agalactiae) Streptococcus group D Streptococcus group G Streptococcus pneumoniae Streptococcus, NOS Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus) Tick-borne viruses (causes of encephalitis) Toxoplasmosis OR for buglist Toxoplama gondii Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica) Varicella zoster virus (VZV) Virus, NOS West Nile virus Yellow fever (caused by yellow fever virus) Combined ICD10 codes Infections in ICD10 Shock, septic Clostridium difficile infection (C. diff) Empyema (pyothorax) Epididymitis or orchitis, NOS (unclear which) Esophagitis, NOS Vagina, vaginitis, acute Vagina, vaginitis, chronic Respiratory syncytial virus (RSV) Deep venous thrombosis/thrombophlebitis, leg (DVT) Superficial venous thrombosis/thrombophlebitis, anywhere Kidney, renal abscess or perinephric abscess Nosocomial infection, NOS Mouth, cellulitis or abscess Lung abscess Gastrointestinal infection (gastroenteritis, colitis), protozoal, NOS Gastrointestinal infection (gastroenteritis, colitis), viral Conjunctivitis, any type or cause Testis, orchitis Gastrointestinal infection (gastroenteritis, colitis), bacterial, NOS	Data Integrity Checks CCMDB.mdb ICD10 Dx check
Check Inf Infection requiring pathogen must have pathogen combined code	every dx in Category:Infection requiring pathogen must have a dx in Category:Pathogens as Combined ICD10 codes.	implemented	CCMDB.mdb	Abscess of intestine Anus or rectum, abscess Appendicitis, with or without rupture or peritonitis Arthritis, infectious (septic arthritis) Bacteremia Bacterial infection, NOS Bladder, cystitis, acute infectious Bladder, cystitis, chronic Bone infection (osteomyelitis), NOS Bone infection (osteomyelitis), acute Bone infection (osteomyelitis), chronic Bursitis, infective (any site) Cellulitis Cholangitis Chronic myringitis Colonized with organism (not infected) Dermatophytosis (tineas, cutaneous fungal infection) Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, bacterial Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, infectious NOS Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, viral Endocarditis, infective, acute or subacute Endophthalmitis, infectious Epididymis, infection (epididymitis) Food poisoning (due to foodborne bacterial toxin), NOS Fournier's gangrene in a male Fungemia, NOS Gas gangrene (usually due to Clostridium perfringens) Gastrointestinal infection (gastroenteritis, colitis), bug NOS 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, following a procedure or surgery, NOS Iatrogenic, infection, heart valve prosthesis (incl prosthetic valve endocarditis) Iatrogenic, infection, internal orthopedic prosthetic device or implant or graft or bone device Iatrogenic, infection, internal prosthetic device or implant or graft NOS Iatrogenic, infection, related to vascular access other than central line Iatrogenic, infection, urinary catheter Impetigo Infection of skin or subcutaneous (soft) tissue, NOS Infectious disease NOS Infectious mononucleosis (usually due to Epstein-Barr virus) Intervertebral disc, infection (infective discitis) Kidney infection, acute (pyelonephritis) Kidney infection, chronic (pyelonephritis) Liver abscess Lower respiratory tract infection, acute infectious Mediastinitis, infectious Meningitis, fungal Meningitis, infectious NOS Meningitis, viral - incl West Nile Muscle, infection (pyomyositis, infective myositis) Myocarditis/carditis, acute infective Necrotizing fasciitis Otitis externa, infectious Otitis media, infectious Parasitic infection, NOS Pericarditis, acute, infective Peritonitis, infectious Peritonsillar abscess Pneumonia, bacterial Pneumonia, fungal/yeast Pneumonia, ventilator-associated (VAP) Pneumonia, viral Puerperal (post-delivery) infections or sepsis Pulmonary embolism (thromboembolism), septic Pulmonary embolism, septic obstetrical thromboembolism Sepsis (SIRS due to infection, without acute organ failure) Severe sepsis Sexually transmitted (venereal) infections, NOS Skin abscess Synovitis, tenosynovitis, infective (any site) Toxic shock syndrome Upper respiratory infection, acute NOS Urinary tract infection, NOS Vertebrae, osteomyelitis (bone infection) Viral carditis Viral hemorrhagic fever, NOS Viral hepatitis, acute, NOS Viral hepatitis, chronic, NOS Acinetobacter species Actinomyces (actinomycosis) Adenovirus Aspergillus Bacillus fragilis (B. frag) Bacteria, NOS Blastomyces Botulism (due to Clostridium botulinum toxin) Candida species Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia) Cholera (due to Vibrio cholerae) Citrobacter species Clostridium perfringens Coccidioides Coronavirus Cryptococcus Cytomegalovirus (CMV) Dengue fever (due to Dengue virus) Entamoeba histolytica (amoebic infection of non-intestinal sites) Enterobacter species Enterococcus species Enterovirus - incl coxsackievirus, echovirus Escherichia coli (E. coli) Fungus or yeast, NOS HIV infection, asymptomatic Haemophilus influenzae (H. flu) Hantavirus infection Helicobacter pylori (H. pylori) Herpes simplex virus (HSV) Histoplasma Infectious contact/exposure, HIV, without disease (yet) Infectious contact/exposure, rabies, without disease (yet) Infectious organism, unknown Influenza virus NOS -- should almost never be used Influenza without pneumonia but with other respiratory manifestations Klebsiella species Legionella Listeria Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii Measles virus Molluscum contagiosum Mosquito-borne viruses (causes of encephalitis) Mucormycetes Mumps Mumps virus Mycobacterium avium-intracellulare (MAC) Mycobacterium tuberculosis (M. TB) Mycoplasma pneumoniae Neisseria gonorrhea (gonococcus) Neisseria meningitidis (meningococcus) Nocardia (nocardiosis) Nontuberculous mycobacteria Not an Infection (ICD10 pathogen alternative) Other type of infectious organism, NOS Papillomavirus Paracoccidioides Parainfluenza virus Parvovirus Pathogens Pneumocystis Jirovecii or Pneumocystis Carinii Progressive Multifocal Leukoencephalopathy (PML) (caused by JC virus) Proteus mirabilus (morganii) Protozoa, NOS Pseudomonas Rabies OR for buglist rabies virus Reovirus Resistance to antimicrobials, antiviral agent Retrovirus Rubella virus (German measles virus) Salmonella species Serratia species Shigellosis (dysentery due to Shigella species) Smallpox (due to Variola viruses) Spirochetes, NOS - incl yaws, louse-borne, tick-borne Sporothrix Staphylococcus aureus Staphylococcus, NOS Stenotrophomonas species Streptococcus group A (strep pyogenes) Streptococcus group B (strep agalactiae) Streptococcus group D Streptococcus group G Streptococcus pneumoniae Streptococcus, NOS Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus) Tick-borne viruses (causes of encephalitis) Toxoplasmosis OR for buglist Toxoplama gondii Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica) Varicella zoster virus (VZV) Virus, NOS West Nile virus Yellow fever (caused by yellow fever virus) Combined ICD10 codes Infections in ICD10 Shock, septic Clostridium difficile infection (C. diff) Empyema (pyothorax) Respiratory syncytial virus (RSV) Kidney, renal abscess or perinephric abscess Nosocomial infection, NOS Gastrointestinal infection (gastroenteritis, colitis), protozoal, NOS Gastrointestinal infection (gastroenteritis, colitis), viral Gastrointestinal infection (gastroenteritis, colitis), bacterial, NOS	Data Integrity Checks CCMDB.mdb ICD10 Dx check
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.mdb	AIDS (disease due to HIV) Actinomyces (actinomycosis) African trypanosomiasis Amoebiasis (amoebic dysentery due to Entamoeba histolytica) Arthritis, due to Lyme Arthritis, due to tuberculosis Bone, tuberculosis (tuberculous osteomyelitis) Botulism (due to Clostridium botulinum toxin) Chagas' disease (due to American trypanosomiasis) Chlamydia psittici infection Cholera (due to Vibrio cholerae) Clostridium difficile infection (C. diff) Creutzfeldt-Jakob disease Dengue fever (due to Dengue virus) Diptheria (due to Corynebacterium diphtheriae toxin) German measles, limited to skin HIV infection, asymptomatic Hantavirus infection Helminthic (parasitic worm) infection, any organ(s) Hepatitis A, acute Hepatitis B, acute Hepatitis B, chronic Hepatitis C, acute Hepatitis C, chronic Infection with implied pathogen Infectious contact/exposure, HIV, without disease (yet) Infectious contact/exposure, rabies, without disease (yet) Infectious contact/exposure, tuberculosis, without disease (yet) Infestation, NOS Influenza pneumonia Influenza with nonrespiratory manifestations Influenza without pneumonia but with other respiratory manifestations Leprosy (due to Mycobacterium leprae) (Hansen's disease) Lyme meningitis (due to Borrelia burgdorferi or Borrelia mayonii) Malaria (due to Plasmodia, any type) Measles, limited to skin Molluscum contagiosum Mumps Nocardia (nocardiosis) Observation for SUSPECTED tuberculosis Poliomyelitis, acute Progressive Multifocal Leukoencephalopathy (PML) (caused by JC virus) Rabies OR for buglist rabies virus Rickettsia infection SARS (severe acute respiratory syndrome) Salmonella enteritis Scarlet fever Shigellosis (dysentery due to Shigella species) Smallpox (due to Variola viruses) Staphylococcal scalded skin syndrome Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus) Syphilis (due to Treponema pallidum) Tetanus infection (due to toxoid of Clostridium tetani) Thrush (Candida infection of mouth) Toxoplasmosis OR for buglist Toxoplama gondii Tuberculosis of the nervous system Tuberculosis of the respiratory system, confirmed Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica) Whooping cough (Pertussis) (due to Bordetella pertussis) Yellow fever (caused by yellow fever virus) Zoonotic bacterial disease (directly transmitted from animal) Acinetobacter species Adenovirus Aspergillus Bacillus fragilis (B. frag) Bacteria, NOS Blastomyces Candida species Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia) Citrobacter species Clostridium perfringens Coccidioides Coronavirus Cryptococcus Cytomegalovirus (CMV) Dermatophytosis (tineas, cutaneous fungal infection) Entamoeba histolytica (amoebic infection of non-intestinal sites) Enterobacter species Enterococcus species Enterovirus - incl coxsackievirus, echovirus Escherichia coli (E. coli) Fungemia, NOS Fungus or yeast, NOS Haemophilus influenzae (H. flu) Helicobacter pylori (H. pylori) Herpes simplex virus (HSV) Histoplasma Infectious mononucleosis (usually due to Epstein-Barr virus) Infectious organism, unknown Influenza virus NOS -- should almost never be used Klebsiella species Legionella Listeria Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii Measles virus Mosquito-borne viruses (causes of encephalitis) Mucormycetes Mumps virus Mycobacterium avium-intracellulare (MAC) Mycobacterium tuberculosis (M. TB) Mycoplasma pneumoniae Neisseria gonorrhea (gonococcus) Neisseria meningitidis (meningococcus) Nontuberculous mycobacteria Not an Infection (ICD10 pathogen alternative) Other type of infectious organism, NOS Papillomavirus Paracoccidioides Parainfluenza virus Parvovirus Pathogens Pneumocystis Jirovecii or Pneumocystis Carinii Pneumonia, viral Proteus mirabilus (morganii) Protozoa, NOS Pseudomonas Reovirus Resistance to antimicrobials, antiviral agent Retrovirus Rubella virus (German measles virus) Salmonella species Serratia species Spirochetes, NOS - incl yaws, louse-borne, tick-borne Sporothrix Staphylococcus aureus Staphylococcus, NOS Stenotrophomonas species Streptococcus group A (strep pyogenes) Streptococcus group B (strep agalactiae) Streptococcus group D Streptococcus group G Streptococcus pneumoniae Streptococcus, NOS Tick-borne viruses (causes of encephalitis) Varicella zoster virus (VZV) Viral carditis Viral hemorrhagic fever, NOS Viral hepatitis, acute, NOS Viral hepatitis, chronic, NOS Virus, NOS West Nile virus Combined ICD10 codes Infections in ICD10 Respiratory syncytial virus (RSV)	Data Integrity Checks CCMDB.mdb ICD10 Dx check
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.mdb	AIDS (disease due to HIV) Actinomyces (actinomycosis) African trypanosomiasis Amoebiasis (amoebic dysentery due to Entamoeba histolytica) Arthritis, due to Lyme Arthritis, due to tuberculosis Bone, tuberculosis (tuberculous osteomyelitis) Botulism (due to Clostridium botulinum toxin) Chagas' disease (due to American trypanosomiasis) Chlamydia psittici infection Cholera (due to Vibrio cholerae) Clostridium difficile infection (C. diff) Creutzfeldt-Jakob disease Dengue fever (due to Dengue virus) Diptheria (due to Corynebacterium diphtheriae toxin) German measles, limited to skin HIV infection, asymptomatic Hantavirus infection Helminthic (parasitic worm) infection, any organ(s) Hepatitis A, acute Hepatitis B, acute Hepatitis B, chronic Hepatitis C, acute Hepatitis C, chronic Infection with implied pathogen Infectious contact/exposure, HIV, without disease (yet) Infectious contact/exposure, rabies, without disease (yet) Infectious contact/exposure, tuberculosis, without disease (yet) Infestation, NOS Influenza pneumonia Influenza with nonrespiratory manifestations Influenza without pneumonia but with other respiratory manifestations Leprosy (due to Mycobacterium leprae) (Hansen's disease) Lyme meningitis (due to Borrelia burgdorferi or Borrelia mayonii) Malaria (due to Plasmodia, any type) Measles, limited to skin Molluscum contagiosum Mumps Nocardia (nocardiosis) Observation for SUSPECTED tuberculosis Poliomyelitis, acute Progressive Multifocal Leukoencephalopathy (PML) (caused by JC virus) Rabies OR for buglist rabies virus Rickettsia infection SARS (severe acute respiratory syndrome) Salmonella enteritis Scarlet fever Shigellosis (dysentery due to Shigella species) Smallpox (due to Variola viruses) Staphylococcal scalded skin syndrome Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus) Syphilis (due to Treponema pallidum) Tetanus infection (due to toxoid of Clostridium tetani) Thrush (Candida infection of mouth) Toxoplasmosis OR for buglist Toxoplama gondii Tuberculosis of the nervous system Tuberculosis of the respiratory system, confirmed Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica) Whooping cough (Pertussis) (due to Bordetella pertussis) Yellow fever (caused by yellow fever virus) Zoonotic bacterial disease (directly transmitted from animal) Acinetobacter species Adenovirus Aspergillus Bacillus fragilis (B. frag) Bacteria, NOS Blastomyces Candida species Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia) Citrobacter species Clostridium perfringens Coccidioides Coronavirus Cryptococcus Cytomegalovirus (CMV) Dermatophytosis (tineas, cutaneous fungal infection) Entamoeba histolytica (amoebic infection of non-intestinal sites) Enterobacter species Enterococcus species Enterovirus - incl coxsackievirus, echovirus Escherichia coli (E. coli) Fungemia, NOS Fungus or yeast, NOS Haemophilus influenzae (H. flu) Helicobacter pylori (H. pylori) Herpes simplex virus (HSV) Histoplasma Infectious mononucleosis (usually due to Epstein-Barr virus) Infectious organism, unknown Influenza virus NOS -- should almost never be used Klebsiella species Legionella Listeria Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii Measles virus Mosquito-borne viruses (causes of encephalitis) Mucormycetes Mumps virus Mycobacterium avium-intracellulare (MAC) Mycobacterium tuberculosis (M. TB) Mycoplasma pneumoniae Neisseria gonorrhea (gonococcus) Neisseria meningitidis (meningococcus) Nontuberculous mycobacteria Not an Infection (ICD10 pathogen alternative) Other type of infectious organism, NOS Papillomavirus Paracoccidioides Parainfluenza virus Parvovirus Pathogens Pneumocystis Jirovecii or Pneumocystis Carinii Pneumonia, viral Proteus mirabilus (morganii) Protozoa, NOS Pseudomonas Reovirus Resistance to antimicrobials, antiviral agent Retrovirus Rubella virus (German measles virus) Salmonella species Serratia species Spirochetes, NOS - incl yaws, louse-borne, tick-borne Sporothrix Staphylococcus aureus Staphylococcus, NOS Stenotrophomonas species Streptococcus group A (strep pyogenes) Streptococcus group B (strep agalactiae) Streptococcus group D Streptococcus group G Streptococcus pneumoniae Streptococcus, NOS Tick-borne viruses (causes of encephalitis) Varicella zoster virus (VZV) Viral carditis Viral hemorrhagic fever, NOS Viral hepatitis, acute, NOS Viral hepatitis, chronic, NOS Virus, NOS West Nile virus Combined ICD10 codes Infections in ICD10 Respiratory syncytial virus (RSV)	Data Integrity Checks CCMDB.mdb ICD10 Dx check
Check CCI vs previous location	If from OR or PACU, must have at least 1 CCI Procedure other than No procedure performed	implemented	CCMDB.mdb	CCI Procedure Previous Location field	Data Integrity Checks CCMDB.mdb CCI Px check Registry checks
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.mdb	PHIN field Chart number	Data Integrity Checks CCMDB.mdb Registry checks
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.mdb	ICD10 collection	Data Integrity Checks CCMDB.mdb Old dx check ICD10 Dx check CCI Px check
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 kidney disease, ESRD), Stage 5 if there is also Kidney transplant, failure or rejection or unspecified complication	implemented	CCMDB.mdb	Past history, transplanted kidney Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5 Kidney transplant, failure or rejection or unspecified complication Renal Coding Considerations for ICD10	Data Integrity Checks CCMDB.mdb ICD10 ICD10 Dx check
Query check ICD10 chonic vent acute resp failure	Chronic dependence on mechanical ventilator should not be coded with Respiratory failure (insufficiency) NOS, acute	implemented	CCMDB.mdb	Chronic dependence on mechanical ventilator Respiratory failure (insufficiency) NOS, acute	Data Integrity Checks CCMDB.mdb ICD10 Dx check
Function Validate Pre admit Inpatient Institution	validates Pre-admit Inpatient Institution field: Can not be blank Check function preAdmit NE Location	implemented	CCMDB.mdb	Pre-admit Inpatient Institution field	Data Integrity Checks CCMDB.mdb
Query check ER Delay not too big	Unusually long ER Delay	implemented	CCMDB.mdb	ER Delay Accept DtTm field Arrive DtTm field Service/Location field	Data Integrity Checks CCMDB.mdb
Query check CCI Picklist duplicates	No duplication of CCI Picklist Px_Type, Px_Date, Px_Count	implemented	CCMDB.mdb	CCI Picklist Px Type Dx Priority No Dx Entered	Data Integrity Checks CCMDB.mdb CCI CCI Px check
Query check CCI Component duplicates	No duplication of CCI Component Px_Type, Px_Date	implemented	CCMDB.mdb	CCI Component Px Type Dx Priority No Dx Entered	Data Integrity Checks CCMDB.mdb CCI CCI Px check
Check eliminated dx	disallows any currently entered diagnosis that has been eliminated	implemented	CCMDB.mdb	Eliminating a diagnosis from collection	Data Integrity Checks CCMDB.mdb Old dx check ICD10 Dx check
Query check ICD10 ESRD vs AP ARF	ARF (APACHE) and CRF - Chronic Renal Failure can not be coded together for the same patient.	needs review	CCMDB.mdb	ARF (APACHE) Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5 Renal Coding Considerations for ICD10	Data Integrity Checks CCMDB.mdb Data Collection Guide ICD10 Dx check Questions
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.mdb	QA Septic Shock Septic Shock Shock, septic	Data Integrity Checks CCMDB.mdb Tmp check ICD10 Dx check Old dx check
Query s tmp comfort care gt one	Only one entry allowed per patient.	implemented	CCMDB.mdb	Comfort Care	Data Integrity Checks CCMDB.mdb
Query s tmp ABO TEE checks	Each of the three projects must have one entry on the ITEM for patients with RecordStatus complete	implemented	CCMDB.mdb	Project ABO TEE Service/Location field	Data Integrity Checks CCMDB.mdb Site/Location check Tmp check
TISS Errors vent vs vent2300	Any marked TISS Item Invasive mechanical ventilation at 2300 hrs (TISS Item) has to have a corresponding marked TISS Item Invasive Mechanical Ventilation (TISS Item) for the same date.	implemented	Centralized data front end.accdb	Invasive Mechanical Ventilation (TISS Item) Invasive mechanical ventilation at 2300 hrs (TISS Item)	Data Integrity Checks Centralized data front end.accdb Registry checks TISS28 checks
TISS Errors Vent vs mechanism	Any marked TISS Item Invasive Mechanical Ventilation (TISS Item) has to have (ETT Present (TISS Item) or Trach Tube Present (TISS Item)) for the same date.	implemented	Centralized data front end.accdb	Invasive Mechanical Ventilation (TISS Item) ETT Present (TISS Item) Trach Tube Present (TISS Item)	Data Integrity Checks Centralized data front end.accdb Tracheostomy TISS28 checks
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	Data Integrity Checks Centralized data front end.accdb Registry checks
Query NDC Trach Dx TISS	Tracheostomy ICD10s and CCIs must be consistent with Trach TISS.	implemented	Centralized data front end.accdb	Trach Tube Present (TISS Item) Tracheostomy, has one Tracheostomy creation	Data Integrity Checks Centralized data front end.accdb Tracheostomy ICD10 Dx check CCI Px check TISS28 checks
PL missing L Tables content	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	Quality Assurance queries in CFE L Dxs table L Como table L Labs Flowsheet table L Pharm Flowsheet table Sending Patients	Data Integrity Checks Centralized data front end.accdb Questions
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.	implemented	Centralized data front end.accdb	Pacemaker insertion, permanent Pacemaker insertion, temporary Permanent Pacemaker Insertion Pacemaker insertion (TISS Item)	Data Integrity Checks Centralized data front end.accdb
Query NDC TISS CCI endoscopic	If pt has TISS28 item Endoscopy (any type of scope) in the ICU (T43) then there must be an endoscopic CCI for that day.	implemented	Centralized data front end.accdb	Endoscopy (TISS Item) ERCP (endoscopic retrograde cholangiopancreatography) Inspection, Exploration (endoscopic) Biopsy (endoscopic)	Data Integrity Checks Centralized data front end.accdb TISS28 checks CCI Px check
Check function preAdmit NE Location	Pre-admit Inpatient Institution field can't be same as Service/Location field	implemented	CCMDB.mdb	Service/Location field Pre-admit Inpatient Institution field	Data Integrity Checks CCMDB.mdb Registry checks
Query check ICD10 mechanism vs trauma	Mechanism of injury needs to be co-coded with certain other codes, and should always have a combined code that expresses the injury itself.	implemented	CCMDB.mdb	Observation after accident/injury Iatrogenic, mechanical complication/dysfunction, cardiac electronic device Iatrogenic, mechanical complication/dysfunction, cardiac or vascular prosthetic device or implant or graft, NOS Iatrogenic, mechanical complication/dysfunction, dialysis catheter Iatrogenic, mechanical complication/dysfunction, heart valve prosthesis Iatrogenic, mechanical complication/dysfunction, internal orthopedic prosthetic device or implant or graft or bone device Iatrogenic, mechanical complication/dysfunction, internal prosthetic device or implant or graft NOS Iatrogenic, mechanical complication/dysfunction, urinary catheter Iatrogenic, puncture or laceration, related to a procedure or surgery NOS Mechanism of injury: animal rider or occupant of animal-drawn vehicle Mechanism of injury: bus occupant Mechanism of injury: crushed or jammed or pinched in or between objects 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: explosion Mechanism of injury: fall or jump (not necessarily from a height) Mechanism of injury: firearm (GSW) Mechanism of injury: hanging or strangulation (accidental or intentional) Mechanism of injury: hypodermic needle Mechanism of injury: knife or other sharp object, stabbing Mechanism of injury: machinery Mechanism of injury: motorcyclist Mechanism of injury: occupant or driver of car or truck Mechanism of injury: other NOS Mechanism of injury: pedal cyclist vs powered vehicle Mechanism of injury: pedal cyclist, not with powered vehicle Mechanism of injury: pedestrian vs powered vehicle Mechanism of injury: pilot or occupant of aircraft Mechanism of injury: struck by an inanimate moving object/blunt trauma Mechanism of injury: train occupant Mechanism of injury: transport or vehicle accident NOS Rotator cuff, tear or rupture Query check ICD10 mechanism vs trauma	Data Integrity Checks CCMDB.mdb ICD10 Dx check Mechanism
Check overstay not entered	check that all has been entered for the Overstay project	implemented	CCMDB.mdb	Overstay Predictor Project Collection Instructions Overstay Predictor Project	OverstayProject Data Integrity Checks CCMDB.mdb Tmp check
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 on a different day than their Dispo DtTm.	implemented	CCMDB.mdb	Transfer Ready DtTm field Awaiting/delayed transfer to home Awaiting/delayed transfer to long-term care/PCH Awaiting/delayed transfer to other acute care facility Awaiting/delayed transfer to transitional care facility 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 Awaiting/delayed transfer to other care facility NOS	Data Integrity Checks CCMDB.mdb Transfer Ready ICD10 Dx check Registry checks
Query s tmp IICU consult dispo to IICU but no tmp	A patient is discharged to IICU and does not have an "IICU consult".	implemented	CCMDB.mdb	IICU consult	Data Integrity Checks CCMDB.mdb Tmp check
Query check ICD10 trach dxs consistent	Tracheostomy related CCI and ICD10 codes must be consistent with each other.	implemented	CCMDB.mdb	Tracheostomy, has one Tracheostomy care Tracheostomy complication, hemorrhage from site Tracheostomy complication, malfunction Tracheostomy complication, NOS Tracheostomy complication, tracheo-esophageal fistula Tracheostomy creation	Data Integrity Checks CCMDB.mdb Tracheostomy ICD10 Dx check CCI Px check
Query s tmp Borrow sensible DtTm vs no borrow	Checks that data for Project Borrow arrive follows that project's	implemented	CCMDB.mdb	Project Borrow arrive	Data Integrity Checks CCMDB.mdb Tmp check
Query s tmp Borrow duplicates	Checks that data for Project Borrow arrive follows that project's	implemented	CCMDB.mdb	Project Borrow arrive	Data Integrity Checks CCMDB.mdb Tmp check
Query NDC cardioversion dx vs TISS	If pt has Acquired Procedure Cardioversion (EXCLUDE defibrillation-we are not tracking), then the TISS28 item Cardioversion (TISS Item) (T41) must be marked.	implemented	Centralized data front end.accdb	Cardioversion (TISS Item) Acquired Procedure Cardioversion (EXCLUDE defibrillation-we are not tracking)	Data Integrity Checks Centralized data front end.accdb TISS28 checks CCI Px check
Query NDC CLI vs DX but no TISS17 CentralLine	Checks for patients who have a Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI) but no Central venous catheter (TISS Item).	implemented	Centralized data front end.accdb	Central venous catheter (TISS Item) Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)	Data Integrity Checks Centralized data front end.accdb TISS28 checks ICD10 Dx check Old dx check Questions
Query NDC Bad Postal Code	Cross check of postal codes against known postal codes	implemented	Centralized data front end.accdb	Postal Code field	Data Integrity Checks Centralized data front end.accdb Data Processing Postal Codes Registry checks
Query NDC CLI AcqDX but NoCLI DateinTMPV2	Checks for Patients who have a CLI but not the corresponding tmp entry.	implemented	Centralized data front end.accdb	Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI) QA Infection CLI	Data Integrity Checks Centralized data front end.accdb Tmp check Old dx check ICD10 Dx check Questions
Query NDC CLI No AcqDX but CLI DateinTMPV2	Checks for Patients who have a CLI tmp entry but not the corresponding dx.	implemented	Centralized data front end.accdb	Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI) QA Infection CLI	Data Integrity Checks Centralized data front end.accdb Tmp check Old dx check ICD10 Dx check Questions
Query NDC TISS Spontaneous vs ETT Trach	A patient with Spontaneous breathing via ETT or Trach (TISS Item)(T19) must also have (ETT Present (TISS Item)(T22) or Trach Tube Present (TISS Item)(T23))	implemented	Centralized data front end.accdb	Spontaneous breathing via ETT or Trach (TISS Item) ETT Present (TISS Item) Trach Tube Present (TISS Item)	Data Integrity Checks Centralized data front end.accdb TISS28 checks Data Processing
Query NDC Dialysis TISS CCI	Critical care patients who have CCI entries for dialysis must have TISS28 entries as well, and vice versa.	implemented	Centralized data front end.accdb	CRRT (incl volume removal via PRISMA device) PD (Peritoneal dialysis) HD (Hemodialysis) Peritoneal dialysis (TISS Item) CRRT (TISS Item) Intermittent hemodialysis (TISS Item) Renal Coding Considerations for ICD10	Data Integrity Checks Centralized data front end.accdb TISS28 checks CCI Px check
Query TISS Errors D ID not in CFE	The D_ID on a TISS28 form does not exist in CFE	implemented	TISS28.mdb	Centralized data front end.accdb D ID field	Data Integrity Checks TISS28.mdb TISS28 checks Data Processing TISS28 Scanning Process
Query TISS Errors duplicate Items	A TISS28 item exists twice	implemented	TISS28.mdb	TISS Items SMW	Data Integrity Checks TISS28.mdb TISS28 checks Data Processing TISS28 Scanning Process
Query TISS Errors missing days	There are no TISS28 entries for a day that should have at least one based on Arrive DtTm and Dispo DtTm	implemented	TISS28.mdb	TISS Items SMW Arrive DtTm field Dispo DtTm field	Data Integrity Checks TISS28.mdb TISS28 checks Data Processing Questions TISS28 Scanning Process
Query TISS Errors TISS date out of admission	TISS date is not during admission	implemented	TISS28.mdb	TISS Items SMW Arrive DtTm field Dispo DtTm field	Data Integrity Checks TISS28 checks Registry checks Data Processing Length of stay TISS28.mdb TISS28 Scanning Process Questions
Query check long transfer delay	Is the Transfer Delay unreasonably long?	needs review	CCMDB.mdb	Transfer Delay Transfer Ready DtTm field Dispo DtTm field	Questions Admit/Discharge Transfer Ready Data Integrity Checks CCMDB.mdb
Controlling Dx Type for ICD10 codes	Controlling Dx Type for ICD10 codes	needs review	CCMDB.mdb	ICD10 Diagnosis	Questions ICD10 ICD10 Dx check Data Integrity Checks CCMDB.mdb
Check pre acute consistent	consistency of Pre acute living situation; Dispo; Postal Code and Previous Location	needs review	CCMDB.mdb	Pre acute living situation field Dispo field Postal Code field Previous Location field	Questions Data Integrity Checks CCMDB.mdb Admit/Discharge Registry Data Pre-acute living situation Postal Codes
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.	needs review	Centralized data front end.accdb	CRF - Chronic Renal Failure ARF (Diagnosis) Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5 Kidney, acute renal failure NOS Kidney, acute renal failure, postprocedural Kidney, acute tubular necrosis (ATN) Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic Renal Coding Considerations for ICD10	Questions Multiple encounter longitudinal consistency check Data Integrity Checks Centralized data front end.accdb ICD10 Dx check CCI Px check
Check Inf Potential Infection must have pathogen or alt combined code	every dx in Category:Potential infection must have a dx in Category:Pathogens or Not an Infection (ICD10 pathogen alternative) as Combined ICD10 codes.	needs review	CCMDB.mdb	Abdominal hernia, with gangrene Abortion NOS, with complication Bartholin's gland, disorder, infectious or not Bladder, cystitis NOS Breast, disorder NOS Breast, inflammatory or infectious disorder of breast Cervix, inflammatory or infectious disorder Cholecystitis, acute Chronic sinusitis Common cold (acute nasopharyngitis) Disorder of anus or rectum, NOS Disorder of eye(s), NOS Disorder of iris or ciliary body of eye Disorder of lacrimal system Disorder of liver, NOS Disorder of nose and/or sinuses, infectious or noninfectious NOS Disorder of peritoneum, NOS Disorder of pulmonary vessels, NOS Disorder of respiratory system, any part, NOS Disorder of skin or subcutaneous tissues, NOS Disorder of spleen, NOS Disorder of the cardiovascular/circulatory system, NOS Disorder of upper respiratory tract, infectious or noninfectious NOS Diverticulitis, small or large intestine (diverticular disease with perforation or abscess) Diverticulosis, small or large intestine (diverticular disease without perforation or abscess) Duodenitis Endocarditis, infective, chronic Epiglotittis, acute Erythema multiforme Erythema nodosum Gallbladder or bile duct disorder, NOS Hepatomegaly Internal female reproductive organs and adnexa NOS, inflammatory or infectious disorder Interstitial lung disease, NOS Intracranial abscess Intraspinal abscess Kidney or ureter, disorder NOS Laryngitis or tracheitis, acute Laryngitis or tracheitis, chronic Lymphangitis Male genital organs, disorder NOS Mastoiditis (acute or chronic, infectious or noninfectious) Medical abortion, with complication Meningitis, bacterial, NOS Observation for suspected infection NOS Pancreas disorder, NOS Pancreatitis, acute NOS Penis, disorders NOS Pharyngitis, acute Pleural effusion, NOS Pleurisy (infectious or noninfectious) Pneumonia, NOS Prostate, disorder NOS Respiratory disorder, postprocedure/postop NOS Retropharyngeal or parapharyngeal abscess Salpingitis, oophoritis or salpingo-oophoritis Sinusitis, acute Skin abscess Skin, rash NOS Spontaneous abortion/miscarriage, with complication Thyroiditis, acute Tonsillitis, acute Tonsillitis, chronic Urethra, infectious or noninfectious urethritis Urinary system, disorder NOS Uterus, inflammatory or infectious disorder Acinetobacter species Actinomyces (actinomycosis) Adenovirus Aspergillus Bacillus fragilis (B. frag) Bacteria, NOS Blastomyces Botulism (due to Clostridium botulinum toxin) Candida species Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia) Cholera (due to Vibrio cholerae) Citrobacter species Clostridium perfringens Coccidioides Coronavirus Cryptococcus Cytomegalovirus (CMV) Dengue fever (due to Dengue virus) Dermatophytosis (tineas, cutaneous fungal infection) Entamoeba histolytica (amoebic infection of non-intestinal sites) Enterobacter species Enterococcus species Enterovirus - incl coxsackievirus, echovirus Escherichia coli (E. coli) Fungemia, NOS Fungus or yeast, NOS HIV infection, asymptomatic Haemophilus influenzae (H. flu) Hantavirus infection Helicobacter pylori (H. pylori) Herpes simplex virus (HSV) Histoplasma Infectious contact/exposure, HIV, without disease (yet) Infectious contact/exposure, rabies, without disease (yet) Infectious mononucleosis (usually due to Epstein-Barr virus) Infectious organism, unknown Influenza virus NOS -- should almost never be used Influenza without pneumonia but with other respiratory manifestations Klebsiella species Legionella Listeria Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii Measles virus Molluscum contagiosum Mosquito-borne viruses (causes of encephalitis) Mucormycetes Mumps Mumps virus Mycobacterium avium-intracellulare (MAC) Mycobacterium tuberculosis (M. TB) Mycoplasma pneumoniae Neisseria gonorrhea (gonococcus) Neisseria meningitidis (meningococcus) Nocardia (nocardiosis) Nontuberculous mycobacteria Not an Infection (ICD10 pathogen alternative) Other type of infectious organism, NOS Papillomavirus Paracoccidioides Parainfluenza virus Parvovirus Pathogens Pneumocystis Jirovecii or Pneumocystis Carinii Pneumonia, viral Progressive Multifocal Leukoencephalopathy (PML) (caused by JC virus) Proteus mirabilus (morganii) Protozoa, NOS Pseudomonas Rabies OR for buglist rabies virus Reovirus Resistance to antimicrobials, antiviral agent Retrovirus Rubella virus (German measles virus) Salmonella species Serratia species Shigellosis (dysentery due to Shigella species) Smallpox (due to Variola viruses) Spirochetes, NOS - incl yaws, louse-borne, tick-borne Sporothrix Staphylococcus aureus Staphylococcus, NOS Stenotrophomonas species Streptococcus group A (strep pyogenes) Streptococcus group B (strep agalactiae) Streptococcus group D Streptococcus group G Streptococcus pneumoniae Streptococcus, NOS Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus) Tick-borne viruses (causes of encephalitis) Toxoplasmosis OR for buglist Toxoplama gondii Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica) Varicella zoster virus (VZV) Viral carditis Viral hemorrhagic fever, NOS Viral hepatitis, acute, NOS Viral hepatitis, chronic, NOS Virus, NOS West Nile virus Yellow fever (caused by yellow fever virus) Combined ICD10 codes Infections in ICD10 Clostridium difficile infection (C. diff) Epididymitis or orchitis, NOS (unclear which) Esophagitis, NOS Vagina, vaginitis, acute Vagina, vaginitis, chronic Respiratory syncytial virus (RSV) Deep venous thrombosis/thrombophlebitis, leg (DVT) Superficial venous thrombosis/thrombophlebitis, anywhere Mouth, cellulitis or abscess Lung abscess Conjunctivitis, any type or cause Testis, orchitis	Data Integrity Checks CCMDB.mdb Questions ICD10 Dx check
Query s tmp IICU consult not paired	If any "IICU consult" entries are present in L_TmpV2 then there have to be two.	needs review	CCMDB.mdb	IICU consult	Data Integrity Checks CCMDB.mdb Questions Tmp check
Check dx implying death across encounters	Category:Diagnosis implying death across encounters	needs review	Centralized data front end.accdb	Brain death Medical Assistance In Dying Sudden cardiac death (and died) Organ donor (organ/tissue donation by the donor) Deceased patients	Data Integrity Checks Centralized data front end.accdb Multiple encounter longitudinal consistency check Registry checks ICD10 Dx check End-of-life related data Questions
Check dx implying death must be dispo deceased	If dx is (Brain death;Medical Assistance In Dying;Sudden cardiac death (and died)) then Dispo field must be deceased or transplant location	needs review	CCMDB.mdb	Brain death Medical Assistance In Dying Sudden cardiac death (and died) Dispo field Deceased patients	Data Integrity Checks CCMDB.mdb ICD10 Dx check End-of-life related data Questions
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.	needs review	CCMDB.mdb	Transfer Ready DtTm field Dispo DtTm field Awaiting/delayed transfer to home Awaiting/delayed transfer to long-term care/PCH Awaiting/delayed transfer to other acute care facility Awaiting/delayed transfer to transitional care facility 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 Awaiting/delayed transfer to other care facility NOS	Data Integrity Checks CCMDB.mdb ICD10 Dx check Transfer Ready Questions Awaiting/delayed transfer
Query NDC Dxs vs TISS Dialysis	If there is a TISS28 entry for Hemodialysis there should be a corresponding Dx.	needs review	Centralized data front end.accdb	Intermittent hemodialysis (TISS Item) Peritoneal dialysis (TISS Item) CRRT (TISS Item) Kidney, acute renal failure NOS Kidney, acute renal failure, postprocedural Kidney, acute tubular necrosis (ATN) Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic	Data Integrity Checks Centralized data front end.accdb Questions TISS28 checks ICD10 Dx check
Function Dispo Chronological()	Checks that the registry times are in a sensible chronological order.	needs review	CCMDB.mdb	Arrive DtTm field Accept DtTm field Transfer Ready DtTm field Dispo DtTm field	2016 Time and Place changes Data Integrity Checks CCMDB.mdb Registry checks
Check ICD10 some cant be primary	Dxs in Category:Pathogens or Category:Antibiotic resistance must not be Primary Admit Diagnosis.	needs review	CCMDB.mdb	Acinetobacter species Actinomyces (actinomycosis) Adenovirus Aspergillus Bacillus fragilis (B. frag) Bacteria, NOS Blastomyces Botulism (due to Clostridium botulinum toxin) Candida species Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia) Cholera (due to Vibrio cholerae) Citrobacter species Clostridium difficile infection (C. diff) Clostridium perfringens Coccidioides Coronavirus Cryptococcus Cytomegalovirus (CMV) Dengue fever (due to Dengue virus) Dermatophytosis (tineas, cutaneous fungal infection) Entamoeba histolytica (amoebic infection of non-intestinal sites) Enterobacter species Enterococcus species Enterovirus - incl coxsackievirus, echovirus Escherichia coli (E. coli) Fungemia, NOS Fungus or yeast, NOS HIV infection, asymptomatic Haemophilus influenzae (H. flu) Hantavirus infection Helicobacter pylori (H. pylori) Herpes simplex virus (HSV) Histoplasma Infectious contact/exposure, HIV, without disease (yet) Infectious contact/exposure, rabies, without disease (yet) Infectious mononucleosis (usually due to Epstein-Barr virus) Infectious organism, unknown Influenza virus NOS -- should almost never be used Influenza without pneumonia but with other respiratory manifestations Klebsiella species Legionella Listeria Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii Measles virus Molluscum contagiosum Mosquito-borne viruses (causes of encephalitis) Mucormycetes Mumps Mumps virus Mycobacterium avium-intracellulare (MAC) Mycobacterium tuberculosis (M. TB) Mycoplasma pneumoniae Neisseria gonorrhea (gonococcus) Neisseria meningitidis (meningococcus) Nocardia (nocardiosis) Nontuberculous mycobacteria Not an Infection (ICD10 pathogen alternative) Other type of infectious organism, NOS Papillomavirus Paracoccidioides Parainfluenza virus Parvovirus Pathogens Pneumocystis Jirovecii or Pneumocystis Carinii Pneumonia, viral Progressive Multifocal Leukoencephalopathy (PML) (caused by JC virus) Proteus mirabilus (morganii) Protozoa, NOS Pseudomonas Rabies OR for buglist rabies virus Reovirus Resistance to antimicrobials, antiviral agent Respiratory syncytial virus (RSV) Retrovirus Rubella virus (German measles virus) Salmonella species Serratia species Shigellosis (dysentery due to Shigella species) Smallpox (due to Variola viruses) Spirochetes, NOS - incl yaws, louse-borne, tick-borne Sporothrix Staphylococcus aureus Staphylococcus, NOS Stenotrophomonas species Streptococcus group A (strep pyogenes) Streptococcus group B (strep agalactiae) Streptococcus group D Streptococcus group G Streptococcus pneumoniae Streptococcus, NOS Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus) Tick-borne viruses (causes of encephalitis) Toxoplasmosis OR for buglist Toxoplama gondii Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica) Varicella zoster virus (VZV) Viral carditis Viral hemorrhagic fever, NOS Viral hepatitis, acute, NOS Viral hepatitis, chronic, NOS Virus, NOS West Nile virus Antibiotic Resistant Organism (old) Resistance to antimicrobials, anti-mycobacterial agent Resistance to antimicrobials, antibiotic, resistance to other beta lactams Resistance to antimicrobials, antifungal drug Resistance to antimicrobials, antiparasitic drug Resistance to antimicrobials, drug NOS Resistance to antimicrobials, extended spectrum beta lactamase (ESBL) Resistance to antimicrobials, methicillin (anti-staph penicillins) Resistance to antimicrobials, miscellaneous antibacterial antibiotics Resistance to antimicrobials, vancomycin VRE Combined ICD10 codes Infections in ICD10 Yellow fever (caused by yellow fever virus) Antibiotic Resistant Organism	Data Integrity Checks CCMDB.mdb ICD10 Dx check Questions
Query check ICD10 ESRD vs ARF	Can't have ESRD and acute renal failure, except if there was a transplant during this ward stay	needs review	CCMDB.mdb	Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5 Kidney, acute renal failure NOS Kidney, acute renal failure, postprocedural Kidney, acute tubular necrosis (ATN) Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic Renal Coding Considerations for ICD10	Data Integrity Checks CCMDB.mdb ICD10 ICD10 Dx check Questions
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)	needs review	CCMDB.mdb	CCI Collection No procedure performed L CCI Picklist table	Data Integrity Checks CCMDB.mdb CCI CCI Px check Questions
Can't check ICD10 ARF vs APACHE ARF	Can't have ESRD and acute renal failure	not feasible	CCMDB.mdb	ARF (APACHE) Kidney, acute renal failure NOS Kidney, acute renal failure, postprocedural Kidney, acute tubular necrosis (ATN) Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic Renal Coding Considerations for ICD10	Data Integrity Checks ICD10 ICD10 Dx check APACHE check CCMDB.mdb Questions
Check organ donors must be dead	organ donors must be deceased	not feasible	CCMDB.mdb		Questions Data Integrity Checks CCMDB.mdb Legacy Content
Query s tmp Borrow no borrow on own unit	Can't have Project Borrow arrive on own unit	not feasible	CCMDB.mdb	Project Borrow arrive	Data Integrity Checks CCMDB.mdb Tmp check
Check VAP acquired only first encounter	VAP should only be Acquired Diagnosis on the first encounter.	ready to implement	Centralized data front end.accdb	Pneumonia, ventilator-associated (VAP) Acquired Diagnosis / Complication Multiple Encounter	Data Integrity Checks Multiple encounter longitudinal consistency check VAP - Ventilator Associated Pneumonia ICD10 Dx check Old dx check Registry checks Centralized data front end.accdb
Check TISS Intubation consistent	Any marked TISS Item Insertion of ETT (TISS Item) or in ETT Present (TISS Item) must have at least one marked TISS item either in Planned extubation (TISS Item) or in Unplanned extubation (TISS Item)	ready to implement	Centralized data front end.accdb	Insertion of ETT (TISS Item) Planned extubation (TISS Item) Unplanned extubation (TISS Item)	Questions Data Integrity Checks Centralized data front end.accdb
CXR count cross check	Confirm that a Category:Labs Imaging count is not unreasonably high	ready to implement	CCMDB.mdb	LOS Arrive DtTm field Dispo DtTm field CXR (plain film)	Data Integrity Checks CCMDB.mdb CCMDB.mdb cross checks triggering for correct values Labs Length of stay Questions
Query check ICD10 only 1 stage of renal failure	can only have one stage of renal failure in Comorbid Diagnosis and in Admit Diagnosis	ready to implement	CCMDB.mdb	Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5 Chronic kidney disease, NOS (stage unspecified) Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic Chronic kidney disease (chronic renal insufficiency, uremia) Stage 1 Chronic kidney disease (chronic renal insufficiency, uremia) Stage 2 Chronic kidney disease (chronic renal insufficiency, uremia) Stage 3 Chronic kidney disease (chronic renal insufficiency, uremia) Stage 4 Renal Coding Considerations for ICD10	Data Integrity Checks CCMDB.mdb Questions ICD10 ICD10 Dx check
Query check ICD10 duplicates	ICD10 Diagnoses (except for Category:Pathogens or Category:Antibiotic resistance and Category:Mechanism) can't be entered in duplicate.	ready to implement	CCMDB.mdb	Acinetobacter species Actinomyces (actinomycosis) Adenovirus Aspergillus Bacillus fragilis (B. frag) Bacteria, NOS Blastomyces Botulism (due to Clostridium botulinum toxin) Candida species Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia) Cholera (due to Vibrio cholerae) Citrobacter species Clostridium difficile infection (C. diff) Clostridium perfringens Coccidioides Coronavirus Cryptococcus Cytomegalovirus (CMV) Dengue fever (due to Dengue virus) Dermatophytosis (tineas, cutaneous fungal infection) Entamoeba histolytica (amoebic infection of non-intestinal sites) Enterobacter species Enterococcus species Enterovirus - incl coxsackievirus, echovirus Escherichia coli (E. coli) Fungemia, NOS Fungus or yeast, NOS HIV infection, asymptomatic Haemophilus influenzae (H. flu) Hantavirus infection Helicobacter pylori (H. pylori) Herpes simplex virus (HSV) Histoplasma Infectious contact/exposure, HIV, without disease (yet) Infectious contact/exposure, rabies, without disease (yet) Infectious mononucleosis (usually due to Epstein-Barr virus) Infectious organism, unknown Influenza virus NOS -- should almost never be used Influenza without pneumonia but with other respiratory manifestations Klebsiella species Legionella Listeria Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii Measles virus Molluscum contagiosum Mosquito-borne viruses (causes of encephalitis) Mucormycetes Mumps Mumps virus Mycobacterium avium-intracellulare (MAC) Mycobacterium tuberculosis (M. TB) Mycoplasma pneumoniae Neisseria gonorrhea (gonococcus) Neisseria meningitidis (meningococcus) Nocardia (nocardiosis) Nontuberculous mycobacteria Not an Infection (ICD10 pathogen alternative) Other type of infectious organism, NOS Papillomavirus Paracoccidioides Parainfluenza virus Parvovirus Pathogens Pneumocystis Jirovecii or Pneumocystis Carinii Pneumonia, viral Progressive Multifocal Leukoencephalopathy (PML) (caused by JC virus) Proteus mirabilus (morganii) Protozoa, NOS Pseudomonas Rabies OR for buglist rabies virus Reovirus Resistance to antimicrobials, antiviral agent Respiratory syncytial virus (RSV) Retrovirus Rubella virus (German measles virus) Salmonella species Serratia species Shigellosis (dysentery due to Shigella species) Smallpox (due to Variola viruses) Spirochetes, NOS - incl yaws, louse-borne, tick-borne Sporothrix Staphylococcus aureus Staphylococcus, NOS Stenotrophomonas species Streptococcus group A (strep pyogenes) Streptococcus group B (strep agalactiae) Streptococcus group D Streptococcus group G Streptococcus pneumoniae Streptococcus, NOS Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus) Tick-borne viruses (causes of encephalitis) Toxoplasmosis OR for buglist Toxoplama gondii Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica) Varicella zoster virus (VZV) Viral carditis Viral hemorrhagic fever, NOS Viral hepatitis, acute, NOS Viral hepatitis, chronic, NOS Virus, NOS West Nile virus Yellow fever (caused by yellow fever virus) Antibiotic Resistant Organism Antibiotic Resistant Organism (old) Resistance to antimicrobials, anti-mycobacterial agent Resistance to antimicrobials, antibiotic, resistance to other beta lactams Resistance to antimicrobials, antifungal drug Resistance to antimicrobials, antiparasitic drug Resistance to antimicrobials, drug NOS Resistance to antimicrobials, extended spectrum beta lactamase (ESBL) Resistance to antimicrobials, methicillin (anti-staph penicillins) Resistance to antimicrobials, miscellaneous antibacterial antibiotics Resistance to antimicrobials, vancomycin VRE Combined ICD10 codes Infections in ICD10	Data Integrity Checks CCMDB.mdb ICD10 ICD10 Dx check Questions
Check drugs vs TISS	Compare Vasoactive drug IV continuous-single (TISS Item)/Vasoactive drug IV continuous-multiple simultaneous (TISS Item) against Pharmacy entries for vasoactive drugs.	ready to implement	Centralized data front end.accdb	Vasoactive drug IV continuous-single (TISS Item) Vasoactive drug IV continuous-multiple simultaneous (TISS Item) Pharmacy collection	Data Integrity Checks TISS28 checks Questions Centralized data front end.accdb
Query TISS Errors CAM positive vs Dx	Checks that each CAM positive (TISS Item) goes with an ICD10 code from Category:Delirium	ready to implement	Centralized data front end.accdb	CAM positive (TISS Item) Delirium, not due to drugs or alcohol Delusional disorder Psychosis/psychotic disorder, NOS, acute or chronic	Data Integrity Checks Centralized data front end.accdb TISS28 checks Data Processing Length of stay Registry checks
Query NDC TISS Extubation only on TISS Intubated days	Any marked TISS Item in Planned extubation (TISS Item) or in Unplanned extubation (TISS Item) must have the ETT Present (TISS Item) on the same date.	ready to implement	Centralized data front end.accdb	Insertion of ETT (TISS Item) Planned extubation (TISS Item) Unplanned extubation (TISS Item)	Data Integrity Checks Centralized data front end.accdb TISS28 checks
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.mdb	Witnessed Cardiac Arrest Unwitnessed Cardiac Arrest BRR	Data Integrity Checks CCMDB.mdb Legacy Content
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.mdb	Panelling or Discharge Planning Arrive DtTm field Transfer Ready DtTm field	Data Integrity Checks CCMDB.mdb Old dx check Legacy Content
Query check ApARF CRF	ARF (APACHE) and CRF - Chronic Renal Failure can not be coded together for the same patient.	retired	CCMDB.mdb	ARF (APACHE) Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5	Data Integrity Checks CCMDB.mdb Data Collection Guide ICD10 Dx check Legacy Content
Query Check Renal IncompatibleDxs	can't have ARF and CRF in same record	retired	CCMDB.mdb	Renal Transplant CRF - Chronic Renal Failure ARI ARF (Diagnosis) Acute Tubular Necrosis (ATN)	Data Integrity Checks CCMDB.mdb Old dx check Legacy Content
Query check trach dx task	make sure Trach Task is entered correctly	retired	CCMDB.mdb	Trach Task	Data Integrity Checks CCMDB.mdb Legacy Content
Query s tmp QAInf basic	checks that none of int, float, bool fields are used in this data.	retired	CCMDB.mdb	QA Infection QA Infection CLI QA Infection VAP	Data Integrity Checks CCMDB.mdb Legacy Content
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.mdb	QA Infection QA Infection CLI QA Infection VAP	Data Integrity Checks CCMDB.mdb Legacy Content
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.mdb	QA Infection QA Infection CLI Pneumonia, ventilator-associated (VAP) QA Infection VAP Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)	Data Integrity Checks CCMDB.mdb Legacy Content
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.mdb	QA Infection QA Infection CLI QA Infection VAP	Data Integrity Checks CCMDB.mdb Legacy Content
Query s tmp ACP	error if ACP Status collection in ICU is missing part of the entry.	retired	CCMDB.mdb	ACP Status collection in ICU	Data Integrity Checks CCMDB.mdb Legacy Content
Query check VAP admit must be from ICU	VAP should only be Admit Diagnosis when Previous Location is an ICU.	retired	CCMDB.mdb	Pneumonia, ventilator-associated (VAP) Previous Location field Admit Diagnosis	Data Integrity Checks CCMDB.mdb Multiple encounter longitudinal consistency check VAP - Ventilator Associated Pneumonia ICD10 Dx check Old dx check Registry checks
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	Pneumonia, ventilator-associated (VAP) QA Infection VAP Arrive DtTm field Dispo DtTm field	Data Integrity Checks Centralized data front end.accdb Questions Old dx check Registry 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	Pneumonia, ventilator-associated (VAP) Acquired Diagnosis / Complication QA Infection VAP	Data Integrity Checks Centralized data front end.accdb Questions Old dx check Registry 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	Pneumonia, ventilator-associated (VAP) Acquired Diagnosis / Complication QA Infection VAP	Data Integrity Checks Centralized data front end.accdb Questions Registry checks Old dx check
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	Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI) Arrive DtTm field Dispo DtTm field QA Infection CLI	Data Integrity Checks Centralized data front end.accdb Old dx check Registry checks Questions

Checks under review

See Data Integrity Check under review

Data Integrity Checks

Documenting a new cross check

List of Data Integrity Checks (SMW)

Checks under review

Navigation menu

Views

Personal tools

Navigation

Search

Tools