Query check AIDS vs HIV

Data Integrity Checks
Summary:	A record can not have both AIDS (disease due to HIV) and HIV infection, asymptomatic
Related:	AIDS (disease due to HIV), HIV infection, asymptomatic
Firmness:	hard check
Timing:
App:	CCMDB.accdb
Coding:	query check_AIDS_vs_HIV
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2018-11-06
Backlogged:	true

Log

10:30, 2019 March 7 (CST) - Changed this so HIV and AIDS are allowed together as long as they are different Dx_Types. Until now this was not allowed, but the scenario makes sense, where there might be HIV infection, asymptomatic as a Comorbid Diagnosis and then AIDS (disease due to HIV) as an Admit Diagnosis/Acquired Diagnosis