tblLAB_VIRO - Laboratory values - viro-/serology
holds test results for viro-/serological tests (hepatitis etc.)
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) |
| VS_ID | character. see coding table | Viral test |
| VS_D | yyyy-mm-dd | Measurement date |
| VS_D_A | character: see coding of date precision | optional precision annotation for date of measurement |
| VS_R | numeric:
|
Measurement result |
| VS_V | numeric | Measurement value (HCV-RNA & HBV-DNA only) (copies/ml) |
| VS_U | character. see coding table for valid codings. | Measurement unit |
Additional Fields
| Field name | Format | Description |
|---|---|---|
| VS_LL | numeric | IF AVAILABLE, Lower limit of assay |
| VS_UL | numeric | IF AVAILABLE, Upper limit of assay |
| VS_T | character. see coding table for valid codings. | IF AVAILABLE, type of ASSAY used for this measurement |
| VS_ST | character | Specimen type |
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_VIRO | CrossTable | LVC001 | Patient doesn't have a record in BAS | Yes | |
| tblLAB_VIRO | WithinTable | LVW002 | Missing patient | Yes | |
| tblLAB_VIRO | WithinTable | LVW003 | Missing VS_ID | Yes | |
| tblLAB_VIRO | WithinTable | LVW004 | Missing VS_D | Yes | |
| tblLAB_VIRO | WithinTable | LVW005 | Missing VS_R | Yes | |
| tblLAB_VIRO | WithinTable | LVW006 | Missing VS_V | Yes | |
| tblLAB_VIRO | WithinTable | LVW007 | Missing VS_U | Yes | |
| tblLAB_VIRO | WithinTable | LVW008 | More or less than exactly 1 positive HIV test per patient | Yes | |
| tblLAB_VIRO | WithinTable | LVW009 | More than 1 negative HIV test for a patient | Yes | |
| tblLAB_VIRO | WithinTable | LVW010 | Date of negative test after date of positive test | Yes | |
| tblLAB_VIRO | WithinTable | LVW011 | Duplicate records | Yes |