tblBAS - Basic clinical, background and demographic information

holds basic information such as demographics, basic clinical information and date of AIDS diagnosis

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)
BIRTH_D yyyy-mm-dd Birth date
BIRTH_D_A character: see coding of date precision optional precision annotation for birth date
FRSVIS_D yyyy-mm-dd First seen at clinic
ENROL_D yyyy-mm-dd Date of enrolment into the cohort
ENROL_D_A character: see coding of date precision optional precision annotation for date of enrolment into the cohort
SEX

numeric:

  • 1 = Male
  • 2 = Female
  • 9 = Unknown
Patient's gender/sex at birth
HEIGH numeric (metric): 999 = Unknown Height of patient at visit/most current
MODE numeric. see coding table for valid codings. Mode of infection
ORIGIN character (1-3 letter/numeric codes). see coding table for valid codings. Country or region of birth
ETHNIC numeric. see coding table for valid codings. Ethnicity of patient. Please take the ###ADDITIONALNOTES### into consideration when using this field.
EDU_LVL numeric. see coding table for valid codings. Last completed education Level. ISCED97 refers to the ​1997 International Standard Classification of Education
HIV_POS_D yyyy-mm-dd Date of first positive HIV test
SEROCO_D yyyy-mm-dd Date of seroconversion
RECART_Y

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
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.
RECART_D 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.
RECART_D_A character: see coding of date precision optional date precision annotation for date RECART_D.
LTART_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.
AIDS_Y

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Has the patient ever been given an AIDS diagnosis? (i.e. WHO stage 3 or 4 or CDC category C diagnosis)
AIDS_D yyyy-mm-dd If yes, date of AIDS diagnosis
AIDS_D_A character: see coding of date precision optional precision annotation for date AIDS_D

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
MODE_OTH character Mode of infection OTHER
ORI_OTH character Origin of patient OTHER
CENS_D yyyy-mm-dd The last date the database has been updated for this patient
SEROHOW

numeric:

  • 1 = Midpoint between last neg/first pos test
  • 2 = Lab evidence of seroconversion
  • 3 = Seroconversion illness
  • 4 = Other
  • 9 = Unknown
For Seroconverters only: How was the seroconversion date determined?
NAIVE_Y

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Is the patient ART-naïve upon enrollment?

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
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