Query check ICD10 Inf Potential Infection must have pathogen or alt

From CCMDB Wiki
Data Integrity Checks
Summary: every dx in Category:Potential infection must have a dx in Category:Pathogens or Not an Infection (ICD10 pathogen alternative) as Combined ICD10 codes.
Related: Abdominal hernia, with gangrene, Abortion NOS, with complication, Bartholin's gland, disorder, infectious or not, Bladder, cystitis NOS, Bladder, cystitis, chronic, Breast, disorder NOS, Breast, inflammatory or infectious disorder of breast, Bronchitis, acute or chronic not specified, infectious or noninfectious, Cervix, inflammatory or infectious disorder, Cholecystitis, acute, Chronic sinusitis, Common cold (acute nasopharyngitis), Conjunctivitis, any type or cause, Deep venous thrombosis/thrombophlebitis, leg (DVT), 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 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, Epididymitis or orchitis, NOS (unclear which), Epiglotittis, acute, Erythema multiforme, Erythema nodosum, Esophagitis, NOS, 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, Lung abscess, Lymphangitis, Male genital organs, disorder NOS, Mastoiditis (acute or chronic, infectious or noninfectious), Medical abortion, with complication, Meningitis, bacterial, NOS, Mouth, cellulitis or abscess, Myocarditis, chronic, Observation for suspected infection NOS, Pancreas disorder, NOS, Pancreatitis, acute NOS, Penis, disorders NOS, Pharyngitis, acute, Pleural effusion, NOS, Pleurisy (infectious or noninfectious), 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, Superficial venous thrombosis/thrombophlebitis, anywhere, Testis, orchitis, Thyroiditis, acute, Tonsillitis, acute, Tonsillitis, chronic, Urethra, infectious or noninfectious urethritis, Urinary system, disorder NOS, Uterus, inflammatory or infectious disorder, Vagina or vulva, inflammatory or infectious disorder NOS, Vagina, vaginitis, acute, Vagina, vaginitis, chronic, Acinetobacter species, Actinomyces (actinomycosis), Adenovirus, Aspergillus, Bacillus fragilis (B. frag), Bacteria, NOS, Blastomyces, Botulism (due to Clostridium botulinum toxin), Bug, Bugs, COVID-19 (SARS-COV-2), 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, Treponema pallidum (Syphilis), 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, Not an Infection (ICD10 pathogen alternative)
Firmness: hard check
Timing: always
App: CCMDB.accdb
Coding: query check_ICD10_Inf_Potential_Infection_must_have_pathogen_or_alt
Uses L Problem table: not relevant for this app
Status: declined
Implementation Date: 2021-03-31
Backlogged: No
  • Cargo

  • SMW

  • Categories: 
  • form:
Potential infection codes:


  • 2021-04-29 - requiring these leads to too much overhead, so it was decided at Task to not do this check; well, that's not quite what was decided, but it boils down to the same thing, since what was decided essentially means we won't be able to test for this b
  • 2021-04-01 - renamed query because original name was so long it didn't work in MS Access
  • 2021-03-31 - implemented in CCMDB.accdb_Change_Log_2021#2021-03-29

Related articles

Related articles: