| 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:
| 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:
| 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
| 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:
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 |