wiki:Hicdep_1.50/TableVis

tblVIS - Basic follow-up/visit related data

holds visit related information, weight, wasting.

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

The following fields 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:

  • 1 = Mother
  • 2 = Father
  • 12 = Mother and Father
  • 3 = Foster family
  • 4 = Institution
  • 9 = Other
TODO
how to code unknown?

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 7 years ago Last modified on 05/09/11 09:00:19