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
character
Code for Clinic/Center/Hospital where patient is seen. Needs to be unique within each Region.
character
Program or region with which the center is associated. Links to tblPROGRAM.
character
Proper name to identify center
character
3-letter ISO code
character
(Optional) Proper name to identify province
character
(Optional) Proper name to identify disctrict
character
(Optional) Proper name to identify city
numeric
Latitude (e.g. 47.376739 for University Hospital Zurich)
numeric
Longitude (e.g. 8.549156 for University Hospital Zurich)

numeric:

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

numeric:

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

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.

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.
yyyy-mm-dd
Date when Center data in this table was last reviewed and/or updated.
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