wiki:Hicdep_1.100/TableBas

tblBAS - Basic clinical, background and demographic information

holds basic information such as demographics, basic clinical information, date of AIDS diagnosis, death and drop-out information

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

GENDER

numeric:

  • 1 = Male
  • 2 = Female
  • 9 = Unknown

Gender/sex

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 additional notes 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?

PROPH_Y

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

Table Crosstable Error Code Description Study specific HICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFUYES
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFUYES
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBASYES
AllTablesCrossTableATC004any date in database in the futureYES
AllTablesCrossTableATC005patients submitted previously who have been missed outYES
AllTablesCrossTableATC006Any fields not coded as coding lists on table definitionYES
tblBASWithinTableBW001AIDS date < SEROCO_DYES
tblBASWithinTableBW002Duplicate patientsYES
tblBASWithinTableBW003First 3 chars of PATIENT don't form valid cohort codeCascadeOnlyYES
tblBASWithinTableBW004Missing PATIENTYES
tblBASWithinTableBW005Missing CENTERYES
tblBASWithinTableBW006Missing BIRTH_DYES
tblBASWithinTableBW007Missing FRSVIS_DYES
tblBASWithinTableBW008Missing ENROL_DYES
tblBASWithinTableBW009Missing GENDERYES
tblBASWithinTableBW010Missing HEIGHYES
tblBASWithinTableBW011Missing MODEYES
tblBASWithinTableBW012Missing MODE_OTH if MODE=90YES
tblBASWithinTableBW013Missing ORIGINYES
tblBASWithinTableBW014Missing ETHNICYES
tblBASWithinTableBW015Missing SEROCO_DYES
tblBASWithinTableBW016Missing RECART_YYES
tblBASWithinTableBW017Missing AIDS_YYES
tblBASWithinTableBW018Missing AIDS_D if AIDS_Y=1YES
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 tblDISYES
tblBASCrossTableBC003AIDS_Y=1 but no AIDS-defining records in tblDIS tableYES
Last modified 9 months ago Last modified on 07/31/17 11:02:22