Hello all

I am currently spending my time making sure that the Quality Assurance Checks in the HIV DDM tool reflect the HICDEP 1.60 error-codes.

In this more detailed process of going through the tables I noticed some odd things.

for tblLAB_VIRO

Error Code LVW001 for tblLAB_VIRO is in fact NOT a "Within-Table" check as it is defined as "Patient has no record in BAS" - I would suggest renaming this check "LVC001" and moving it to the "Cross-Table" section of the qa checks.


I am not sure if Error Code LVW008 and LVW009 are suitable for as a standard HICDEP check. I see no reason that only one positive and one negative HIV-test result should be allowed. In my understanding this table should contain all the VIRO/SERO results. It seems arbitrary to insist on only two HIV test -- one positive and one negative.
I suggest that these are marked as study specific - or reformulated to search for AT LEAST 1 with negative result and AT LEAST one with positive result. This would allow you to know that indeed the patient has HIV - and by the negative results you should be able to tell from the latest date approximately when seroconversion occured.

for tblLAB

Error codes LW006 and LW007 reference fields that are not required fields in the tblLAB (LAB_LLN and LAB_ULN) - at the very least I am not sure that the optional fields should have the column HICDEP=YES, if they should even be included in the list.

tblOVERLAP

the Error Checks OW001 (invalid other cohort) and OC002 (patient not found in BAS for other cohort) are not feasible to code in the HIVDDM tool, as you would not neccesarily have access to the patientlists submitted by other cohorts in the study upon making your own data submissions.