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)

CENTER

character

Code for Clinic/Centre/Hospital where patient is seen. Links to tblCENTER.

BIRTH_D

yyyy-mm-dd

Birth date

FRSVIS_D

yyyy-mm-dd

First seen at clinic

ENROL_D

yyyy-mm-dd

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:

  • 1 = Yes
  • 0 = No
  • 9 = Unknown

Has the patient received antiretroviral treatment?

RECART_D

yyyy-mm-dd

Date ART started

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:

  • 1 = Yes
  • 0 = No
  • 9 = Unknown

Has patient been given an AIDS diagnosis?

AIDS_D

yyyy-mm-dd

IF YES, date of AIDS diagnosis

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 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 19 months ago Last modified on 12/02/15 09:39:32