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
character (or numeric if possible)
Code to identify patient (Cohort Patient ID)
yyyy-mm-dd
Birth date
character: see coding of date precision
optional precision annotation for birth date
yyyy-mm-dd
First seen at clinic
yyyy-mm-dd
Date of enrolment into the cohort
character: see coding of date precision
optional precision annotation for date of enrolment into the cohort

numeric:

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

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.
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.
character: see coding of date precision
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.

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)
yyyy-mm-dd
If yes, date of AIDS diagnosis
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
character
Mode of infection OTHER
character
Origin of patient OTHER
yyyy-mm-dd
The last date the database has been updated for this patient

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?

numeric:

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

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Prior to enrollment, has the Patient been exposed to antiretroviral therapy for prophylaxis such as PMTCT, PREP, or PEP?

QA Checks


TableCrosstableError CodeDescriptionStudy specificHICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFU Yes
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFU Yes
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBAS Yes
AllTablesCrossTableATC004any date in database in the future Yes
AllTablesCrossTableATC005patients submitted previously who have been missed out Yes
AllTablesCrossTableATC006Any fields not coded as coding lists on table definition Yes
tblBASWithinTableBW001AIDS date < SEROCO_D Yes
tblBASWithinTableBW002Duplicate patients Yes
tblBASWithinTableBW003First 3 chars of PATIENT don't form valid cohort codeCascadeOnlyYes
tblBASWithinTableBW004Missing PATIENT Yes
tblBASWithinTableBW005Missing CENTER Yes
tblBASWithinTableBW006Missing BIRTH_D Yes
tblBASWithinTableBW007Missing FRSVIS_D Yes
tblBASWithinTableBW008Missing ENROL_D Yes
tblBASWithinTableBW009Missing GENDER Yes
tblBASWithinTableBW010Missing HEIGH Yes
tblBASWithinTableBW011Missing MODE Yes
tblBASWithinTableBW012Missing MODE_OTH if MODE=90 Yes
tblBASWithinTableBW013Missing ORIGIN Yes
tblBASWithinTableBW014Missing ETHNIC Yes
tblBASWithinTableBW015Missing SEROCO_D Yes
tblBASWithinTableBW016Missing RECART_Y Yes
tblBASWithinTableBW017Missing AIDS_Y Yes
tblBASWithinTableBW018Missing AIDS_D if AIDS_Y=1 Yes
tblBASWithinTableBW019BIRTH_D out of range (15-85 yrs)CascadeOnlyYes
tblBASWithinTableBW020BIRTH_D out of range (<18)PENTAYes
tblBASCrossTableBC001RECART_Y=1 but no records in tblART Yes
tblBASCrossTableBC002AIDS_Y=0, but AIDS-defining records in tblDIS Yes
tblBASCrossTableBC003AIDS_Y=1 but no AIDS-defining records in tblDIS table Yes