tblBAS - Basic clinical, background and demographic information
holds basic information such as demographics, basic clinical information and date of AIDS diagnosis
|
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)
|
|
optional precision annotation for birth date
|
yyyy-mm-dd First seen at clinic
|
yyyy-mm-dd Date of enrolment into the cohort
|
optional precision annotation for date of enrolment into the cohort
|
Participant's sex at birth
|
|
numeric (metric): 999 = Unknown Height of patient at visit/most current
|
|
Country or region of birth
|
Ethnicity of patient. Please take the additional notes into consideration when using this field.
|
|
yyyy-mm-dd Date of first positive HIV test
|
yyyy-mm-dd Date of seroconversion
|
Has the patient ever received antiretroviral treatment? This includes all antiretroviral therapy given as Treatment even if given by another Center or program but excludes antiretroviral drugs given only for PMTCT or other prophylaxis.
|
yyyy-mm-dd Date of first antiretroviral Treatment Initiation. Leave blank if ART not yet initiated. This should be the first date at which antiretroviral therapy, regardless of Regimen, was given as Treatment irrespective of whether it was given at this center/program or not. It excludes antiretroviral regimens given only for PMTCT or other prophylaxis.
|
optional date precision annotation for date RECART_D.
|
yyyy-mm-dd Date last assessed for ART. If started ART, last date known to be on ART, or if not on ART, last date ART free.
|
Has the patient ever been given an AIDS diagnosis? (i.e. WHO stage 3 or 4 or CDC category C diagnosis)
|
yyyy-mm-dd If yes, date of AIDS diagnosis
|
optional precision annotation for date AIDS_D
|
Family history of CVD: Have any first degree relatives experienced myocardial infarction or stroke before the age of 50 years?
|
Additional Fields For mode of infection and origin a set of other fields are often used to capture what cannot be coded. These fields are represented here as optional fields as it is the intention that the suggested codes applied to the MODE and ORIGIN should be able to cover all possible values.
|
Field name Format Description character Mode of infection OTHER
|
character Origin of patient OTHER
|
yyyy-mm-dd The last date the database has been updated for this patient
|
For Seroconverters only: How was the seroconversion date determined?
|
Is the patient ART-naïve upon enrollment?
|
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 |
tblBAS | WithinTable | BW001 | AIDS date < SEROCO_D | | Yes |
tblBAS | WithinTable | BW002 | Duplicate patients | | Yes |
tblBAS | WithinTable | BW003 | First 3 chars of PATIENT don't form valid cohort code | CascadeOnly | Yes |
tblBAS | WithinTable | BW004 | Missing PATIENT | | Yes |
tblBAS | WithinTable | BW005 | Missing CENTER | | Yes |
tblBAS | WithinTable | BW006 | Missing BIRTH_D | | Yes |
tblBAS | WithinTable | BW007 | Missing FRSVIS_D | | Yes |
tblBAS | WithinTable | BW008 | Missing ENROL_D | | Yes |
tblBAS | WithinTable | BW009 | Missing GENDER | | Yes |
tblBAS | WithinTable | BW010 | Missing HEIGH | | Yes |
tblBAS | WithinTable | BW011 | Missing MODE | | Yes |
tblBAS | WithinTable | BW012 | Missing MODE_OTH if MODE=90 | | Yes |
tblBAS | WithinTable | BW013 | Missing ORIGIN | | Yes |
tblBAS | WithinTable | BW014 | Missing ETHNIC | | Yes |
tblBAS | WithinTable | BW015 | Missing SEROCO_D | | Yes |
tblBAS | WithinTable | BW016 | Missing RECART_Y | | Yes |
tblBAS | WithinTable | BW017 | Missing AIDS_Y | | Yes |
tblBAS | WithinTable | BW018 | Missing AIDS_D if AIDS_Y=1 | | Yes |
tblBAS | WithinTable | BW019 | BIRTH_D out of range (15-85 yrs) | CascadeOnly | Yes |
tblBAS | WithinTable | BW020 | BIRTH_D out of range (<18) | PENTA | Yes |
tblBAS | CrossTable | BC001 | RECART_Y=1 but no records in tblART | | Yes |
tblBAS | CrossTable | BC002 | AIDS_Y=0, but AIDS-defining records in tblDIS | | Yes |
tblBAS | CrossTable | BC003 | AIDS_Y=1 but no AIDS-defining records in tblDIS table | | Yes |