Following the discussion of the February TC, I went ahead and made the changes such that tblLAB_RES and its level-specific subtables may also encode HCV resistance test results. It turned out to require a few changes we didn't anticipate in the first place, so I'd like to encourage you review the current draft.

As discussed, I added a variable VIRUSTYPE to tblLAB_RES which allows to distinguish HCV and HIV entries.

However, this change also implies that we need to be sure that SAMP_ID, the identifier for tblLAB_RES, is unique. This is not necessarily the case with samples, so Jesper proposed to rename the identifier to the more descriptive TEST_ID. An alternative would have been to carry the VIRUSTYPE value over to all the _LVL1/2/3 tables as part of the key, but we deemed this less elegant.

Another consequence is that the ART_ID field in tblLAB_RES_LVL3 which references the ART medication needed to be generalized to allow for HCV medication, too. We therefore renamed it to ATC_CODE to reflect this.

Comments regarding these changes are highly welcome.

A remaining issue is that the SEQTYPE and GENTYPE variables of tblLAB_RES_LVL1 and tblLAB_RES_LVL2 still only list the HIV-specific values. Can anyone provide a list of suitable values for the HCV case?

Kind regards,

Simon