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
Format
Description
PATIENT
character (or numeric if possible)
Code to identify patient (Cohort Patient ID)
CD4_D
yyyy-mm-dd
Date of measurement
CD4_V
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
Format
Description
CD4_U

numeric with codes (or full string):

  • 1 = cells/µl
  • 2 = %
Unit of measurement
CD4_D_A
character: see coding of date precision
precision of measurement date

QA Checks


TableCrosstableError CodeDescriptionStudy specificHICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFU Yes
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFU Yes
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBAS Yes
AllTablesCrossTableATC004any date in database in the future Yes
AllTablesCrossTableATC005patients submitted previously who have been missed out Yes
AllTablesCrossTableATC006Any fields not coded as coding lists on table definition Yes
tblLAB_CD4WithinTableCW001CD4 value out of range Yes
tblLAB_CD4WithinTableCW002Duplicate records for same date Yes
tblLAB_CD4WithinTableCW003Missing CD4_D Yes
tblLAB_CD4WithinTableCW004Missing CD4_V Yes
tblLAB_CD4WithinTableCW005Missing CD4_U Yes
tblLAB_CD4WithinTableCW006Miscoded CD4_U as coding list on table definition Yes
tblLAB_CD4WithinTableCW007CD4_U=2 (percentage) and CD4_V>100 Yes
tblLAB_CD4WithinTableCW008CD4_U=(1 or 3) and CD4_V>3000 Yes
tblLAB_CD4WithinTableCW009CD4 counts spike up or down suddenly (large change in less than a year) Yes
tblLAB_CD4CrossTableCC001Patient has no record in BAS Yes