wiki:Hicdep_1.110/TableVis

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?

FAM_Y

numeric.

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

Family history of CVD: Have any first degree relatives experienced myocardial infarction or stroke before the age of 50 years?

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_ID

numeric:

  • 1 = Male
  • 2 = Female
  • 3 = Transgender male
  • 4 = Transgender female
  • 5 = Other
  • 9 = Unknown

Current gender identification

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. see coding table for valid codings.

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 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
tblVISWithinTableVW001Duplicate records, same VIS_DYES
tblVISWithinTableVW002Height decreasing over time YES
tblVISWithinTableVW003Height out of acceptable rangeYES
tblVISWithinTableVW004Weight out of acceptable rangeYES
tblVISCrossTableVC001patient has no record in BAS tableYES
tblVISCrossTableVC002No weights within 3 mths of starting FPV/DRVEPPICC YES
Last modified 12 months ago Last modified on 08/07/17 11:16:57