wiki:Hicdep_1.80/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

WEIGH

numeric (metric: kg): 999 = Unknown

Weight of patient at visit

GAIN_Y

numeric:

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

Is the patient gaining fat in the abdomen, neck, breast or other defined locations?

LOSS_Y

numeric:

  • 1 = Yes
  • 0 = No
  • 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
  • 2
  • 3
  • 4
  • 9 = Unknown

Clinical WHO stage at time of visit?

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:

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

Is the patient currently a smoker?

PREG_Y

numeric:

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

Is the patient currently pregnant? If possible, provide additional details in tblPREG

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

Field name

Format

Description

HEIGH

numeric (metric). 999 = Unknown

Height/length of patient at visit

LIVEWITH

numeric. see coding table for valid codings.

Child lives with/in

HEALTHY_Y

numeric:

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

Is child healthy?

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:

  • 1 = Yes
  • 0 = No
  • 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 4 years ago Last modified on 11/08/13 10:35:27