tblLAB_CD4 - Laboratory values

holds date and value of CD4 measurements.

Note: If needed, a CD8 table (tblLAB_CD8) could be formed from the same structure.

Core fields

Note: Fields marked bold form the unique identifier for a record of the table.

Field name




character (or numeric if possible)

Code to identify patient (Cohort Patient ID)



Date of measurement


numeric (per microliter): -1 = undetectable or detection limit as negative value

Value of CD4 measurement

Additional fields

CD4_V is assumed to contain absolute CD4 cell counts per mL as standard. In case CD4 % (with respect to CD45+ lymphocytes as denominator) should be collected as well, please append the following field to the table:

Field name




numeric with codes (or full string):

  • 1 = cells/┬Ál
  • 2 = %

Unit of measurement


character: see coding of date precision

precision of measurement date

QA Checks

Table Crosstable Error Code Description Study specific HICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFUYES
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFUYES
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBASYES
AllTablesCrossTableATC004any date in database in the futureYES
AllTablesCrossTableATC005patients submitted previously who have been missed outYES
AllTablesCrossTableATC006Any fields not coded as coding lists on table definitionYES
tblLAB_CD4WithinTableCW001CD4 value out of rangeYES
tblLAB_CD4WithinTableCW002Duplicate records for same dateYES
tblLAB_CD4WithinTableCW003Missing CD4_DYES
tblLAB_CD4WithinTableCW004Missing CD4_VYES
tblLAB_CD4WithinTableCW005Missing CD4_UYES
tblLAB_CD4WithinTableCW006Miscoded CD4_U as coding list on table definitionYES
tblLAB_CD4WithinTableCW007CD4_U=2 (percentage) and CD4_V>100YES
tblLAB_CD4WithinTableCW008CD4_U=(1 or 3) and CD4_V>3000YES
tblLAB_CD4WithinTableCW009CD4 counts spike up or down suddenly (large change in less than a year)YES
tblLAB_CD4CrossTableCC001Patient has no record in BASYES
Last modified 3 years ago Last modified on 08/07/17 11:16:57