tblLAB_CD4 - Laboratory values
holds date and value of CD4 measurements.
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):
|
Unit of measurement |
| CD4_D_A | character: see coding of date precision | precision of measurement date |
QA Checks
| Table | Crosstable | Error Code | Description | Study specific | Is HICDEP |
|---|---|---|---|---|---|
| AllTables | CrossTable | ATC001 | any date in database after DEATH_D in tblLTFU | Yes | |
| AllTables | CrossTable | ATC002 | any date in database after DROP_D in tblLTFU | Yes | |
| AllTables | CrossTable | ATC003 | any date in database before BIRTH_D in tblBAS | Yes | |
| AllTables | CrossTable | ATC004 | any date in database in the future | Yes | |
| AllTables | CrossTable | ATC005 | patients submitted previously who have been missed out | Yes | |
| AllTables | CrossTable | ATC006 | Any fields not coded as coding lists on table definition | Yes | |
| tblLAB_CD4 | WithinTable | CW001 | CD4 value out of range | Yes | |
| tblLAB_CD4 | WithinTable | CW002 | Duplicate records for same date | Yes | |
| tblLAB_CD4 | WithinTable | CW003 | Missing CD4_D | Yes | |
| tblLAB_CD4 | WithinTable | CW004 | Missing CD4_V | Yes | |
| tblLAB_CD4 | WithinTable | CW005 | Missing CD4_U | Yes | |
| tblLAB_CD4 | WithinTable | CW006 | Miscoded CD4_U as coding list on table definition | Yes | |
| tblLAB_CD4 | WithinTable | CW007 | CD4_U=2 (percentage) and CD4_V>100 | Yes | |
| tblLAB_CD4 | WithinTable | CW008 | CD4_U=(1 or 3) and CD4_V>3000 | Yes | |
| tblLAB_CD4 | WithinTable | CW009 | CD4 counts spike up or down suddenly (large change in less than a year) | Yes | |
| tblLAB_CD4 | CrossTable | CC001 | Patient has no record in BAS | Yes |