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.mdb
Coding:	query check_AIDS_vs_HIV
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2018-11-06
Backlogged:	true

• Cargo

• SMW

"CCMDB.mdb" is not in the list (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) of allowed values for the "DICApp" property. 

• Categories: 

• form:

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