tblCENTER - Center information


holds information about the Center (e.g. geographical localisation, type of clinic) where the patient is receiving HIV care

Core Fields

Note: Fields marked bold form the unique identifier for a record of the table.
Field name
Format
Description
CENTER
character
Code for Clinic/Center/Hospital where patient is seen. Needs to be unique within each Region.
PROGRAM
character
Program or region with which the center is associated. Links to tblPROGRAM.
NAME
character
Proper name to identify center
COUNTRY
character
3-letter ISO code
PROVINCE
character
(Optional) Proper name to identify province
DISTRICT
character
(Optional) Proper name to identify disctrict
CITY
character
(Optional) Proper name to identify city
GEOCODE_LAT
numeric
Latitude (e.g. 47.376739 for University Hospital Zurich)
GEOCODE_LON
numeric
Longitude (e.g. 8.549156 for University Hospital Zurich)
RURAL

numeric:

  • 1 = Urban
  • 2 = Mostly urban
  • 3 = Mostly rural
  • 4 = Rural
  • 9 = Unknown
Code for the site situation (facility location)
LEVEL

numeric:

  • 1 = Health centre
  • 2 = District hospital
  • 3 = Regional, provincial or university hospital
  • 9 = Unknown
Code for level of care
ADULTPED
character: "PED","ADULT", or "BOTH"
Population the center serves
OPEN_D
yyyy-mm-dd
(Optional) Date of opening of dataset: earliest date for which data were included from this site
CLOSE_D
yyyy-mm-dd
(Optional) Date of closing of dataset
ADD_CENTER
yyyy-mm-dd
Inclusion date: date that the site was added to the cohort
DROP_CENTER
yyyy-mm-dd
(Optional) Exclusion date: date that the site was dropped from the cohort
SURVEY_INTERNET

numeric:

  • 1 = sufficient Access to complete online surveys
  • 2 = degraded Access making online Survey completion difficult
  • 3 = no internet access
  • 9 = Unknown
Quality of internet access for completing online Surveys.
SURVEY_PAPER

numeric:

  • 1 = site has resources to print and transfer Surveys
  • 2 = site has resources to print, but not Transfer surveys
  • 3 = site does not have resources to print, but can transfer surveys
  • 4 = site Needs assistance in both printing and transferring surveys
  • 8 = not applicable
  • 9 = Unknown
Resources for printing and transferring paper surveys to a central location for data entry.
LAST_REVIEWED_D
yyyy-mm-dd
Date when Center data in this table was last reviewed and/or updated.
LAST_REVIEWED_D_A
character: see coding of date precision
optional precision annotation for last review date LAST_REVIEW_D

QA Checks


TableCrosstableError CodeDescriptionStudy specificHICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFU Yes
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFU Yes
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBAS Yes
AllTablesCrossTableATC004any date in database in the future Yes
AllTablesCrossTableATC005patients submitted previously who have been missed out Yes
AllTablesCrossTableATC006Any fields not coded as coding lists on table definition Yes