tblLAB_VIRO - Laboratory values - viro-/serology
holds test results for viro-/serological tests (hepatitis etc.)
|
Core FieldsNote: Fields marked bold form the unique identifier for a record of the table.
|
Field name Format Description character (or numeric if possible) Code to identify patient (Cohort Patient ID)
|
|
yyyy-mm-dd Measurement date
|
optional precision annotation for date of measurement
|
|
numeric Measurement value (HCV-RNA & HBV-DNA only) (copies/ml)
|
|
|
Additional FieldsField name Format Description numeric IF AVAILABLE, Lower limit of assay
|
numeric IF AVAILABLE, Upper limit of assay
|
IF AVAILABLE, type of ASSAY used for this measurement
|
|
QA Checks
Table | Crosstable | Error Code | Description | Study specific | 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 |