tblVIS - Basic follow-up/visit related data

holds visit related information such as weight, wasting, smoking, occupational status etc.

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)
VIS_D yyyy-mm-dd Date of patient visit
VIS_D_A character: see coding of date precision Precision annotation variable for date of visit
CENTER character Center the patient visits. Links to tblCENTER.
WEIGH numeric (metric: kg): 999 = Unknown Weight of patient at visit
GAIN_Y

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Is the patient gaining fat in the abdomen, neck, breast or other defined locations?
LOSS_Y

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Is the patient experiencing loss of fat from extremities, buttocks or face?

Depending on the collaboration this data might be collected in intervals of a year, e.g. from July last to July this year. In that case all visit dates or a fixed number of visit dates for that period should be gathered, if the patient did not have a visit in the defined period, a record with the PATIENT id and empty fields for VIS_D etc. should be included.

Additional Fields

Field name Format Description
CDC_STAGE character. see coding table for valid codings. Clinical CDC stage at time of visit?
WHO_STAGE

numeric.

  • 1 = WHO Stage I
  • 2 = WHO Stage II
  • 3 = WHO Stage III
  • 4 = WHO Stage IV
  • 9 = Unknown
Clinical WHO stage at time of visit?

The following optional fields are meant to be used to document the transition process from adolescent to adult.

Field name Format Description
CLINIC_TYPE

numeric

  • 1 = paediatric
  • 2 = adolescent within paediatric care
  • 3 = adolescent within adult care
  • 4 = adolescent stand alone
  • 5 = adult
  • 9 = missing
Type of clinic/service the patient is currently attending
SPEC_TYPE

numeric

  • 1 = Physician providing paediatric care
  • 2 = Physician providing adolescent care
  • 3 = Physician providing adult care
  • 4 = Physician providing paediatric and adult care
  • 5 = other healthcare provider (e.g. nurse)
  • 9 = missing
Type of specialist providing care. Combinations if multiple specialists are involved (e.g. 23, 45).
TRANS_STAGE

numeric

  • 0 = transition not started
  • 1 = transition in progress
  • 2 = transition completed
  • 9 = not applicable/missing
Stage of transition from pediatric to adult care at current visit.
Transition has not yet started when the patient only sees paediatricians.
Transition is complete when the patient only sees adult physicians.

The following fields are meant to be used for adolescents and adults.

Field name Format Description
EMPLOY numeric. see coding table for valid codings. What is the patient's current situation regarding labour?
CONTRACT numeric. see coding table for valid codings. If the patient is an employee, what is the type of the patient's employment contract?
SMOKING_Y

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Is the patient currently a smoker?
PREG_Y

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Is the patient currently pregnant? If possible, provide additional details in tblPREG
GENDER_IDENT

numeric:

  • 1 = Male
  • 2 = Female
  • 3 = Transgender male
  • 4 = Transgender female
  • 5 = Other
  • 6 = Non-binary
  • 9 = Unknown
Current gender with which the patient identifies
SCHOOL

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Is the patient currently attending school or on break for customary school holidays?
SCHOOL_LVL numeric: see coding table Current level of education (ISCED97 refers to the 1997 International Standard Classification of Education)

The following fields are meant to be used for HIV-infected children and adolescents only.

Field name Format Description
STATUS_KNOWN

numeric:

  • 0 = No
  • 1 = Yes
  • 2 = Disclosure ongoing
  • 9 = Unknown
Does the patient know his/her HIV status?

The following fields are meant to be used for children and infants.

Field name Format Description
HEIGH numeric (metric in m). 999 = Unknown Height/length of patient at visit in meters (m)
LIVEWITH numeric:
  • 1 = Mother
  • 2 = Father
  • 12 = Mother and Father
  • 3 = Foster family
  • 4 = Institution
  • 9 = Other
Child lives with/in
HEALTHY_Y

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Is child healthy?
FEEDOTH_Y

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Is the Patient currently receiving Foods or liquids other than breast milk?
CAREGIVER

numeric:

  • 1 = Mother
  • 2 = Father
  • 3 = Sibling
  • 4 = Grandparent
  • 5 = Aunt or Uncle
  • 6 = Self
  • 7 = Other family member
  • 8 = Other non-family member
  • 9 = Unknown
  • 10 = Other non-coded
Who is the patient's primary caregiver?
BROUGHT_PATIENT

numeric:

  • 1 = Mother
  • 2 = Father
  • 3 = Sibling
  • 4 = Grandparent
  • 5 = Aunt or Uncle
  • 6 = Self
  • 7 = Other family member
  • 8 = Other non-family member
  • 9 = Unknown
  • 10 = Other non-coded
Who brought the Patient to this clinic visit?
HIV_STATUS

numeric:

  • 1 = HIV exposed, status indeterminate
  • 2 = HIV infected
  • 3 = HIV uninfected
Current HIV status

The following fields are meant to be used for infants:

Field name Format Description
HEIGH_P numeric Height/length of patient at visit in percentiles
WEIGH_P numeric Weight of patient at visit in percentiles
HEADC numeric Head circumference measured in millimeters (mm)
HEADC_P numeric Head circumference in percentiles
BREASTF_Y

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Currently Breastfeeding?

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
tblVIS WithinTable VW001 Duplicate records, same VIS_D Yes
tblVIS WithinTable VW002 Height decreasing over time Yes
tblVIS WithinTable VW003 Height out of acceptable range Yes
tblVIS WithinTable VW004 Weight out of acceptable range Yes
tblVIS CrossTable VC001 patient has no record in BAS table Yes
tblVIS CrossTable VC002 No weights within 3 mths of starting FPV/DRV EPPICC Yes