Query check ICD10 duplicates

Data Integrity Checks
Summary:	ICD10 Diagnoses (except for Category:Pathogens or Category:Antibiotic resistance and Category:Mechanism) can't be entered in duplicate.
Related:	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), 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), Antibiotic Resistant Organism, Antibiotic Resistant Organism (old), ICU Acquired Antibiotic Resistant Organism (ARO) rate, Resistance to antimicrobials, antibiotic, resistance to other beta lactams, Resistance to antimicrobials, antifungal drug, Resistance to antimicrobials, antiparasitic drug, Resistance to antimicrobials, antiviral agent, Resistance to antimicrobials, classic anti-mycobacterial agent, 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, Resistance to carbapenem antibiotics, VRE, Combined ICD10 codes, Infections in ICD10
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check_ICD10_duplicates
Uses L Problem table:	not relevant for this app
Status:	ready to implement
Implementation Date:
Backlogged:	true

• Cargo

• SMW

• Categories:  

• form:

_Dev_CCMDB the count is wrong, there wasn't a quick fix, so disabling the query for now. Ttenbergen 15:56, 2019 March 27 (CDT)

added: no added date action: no action date

• Cargo

• Categories

Putting here so it lists in query listings, there really is nothing do discuss, I just need to fix this. REmoved original implementation date since query has been disabled for over a year. Ttenbergen 17:29, 2021 October 7 (CDT)

the count is wrong, there wasn't a quick fix, so disabling the query for now. Ttenbergen 15:56, 2019 March 27 (CDT)

• SMW

• Cargo

• Categories

Log

• 2022-02-10 - the list to count had included lines for each category so there was much duplication. Broke out query to generate unique values first, now count works
• 2019-03-25 - excluded dxs in Category:Pathogens, Category:Antibiotic resistance and Category:Mechanism