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

Table Crosstable Error Code Description Study specific Is HICDEP
AllTables CrossTable ATC001 any date in database after DEATH_D in tblLTFU Yes
AllTables CrossTable ATC002 any date in database after DROP_D in tblLTFU Yes
AllTables CrossTable ATC003 any date in database before BIRTH_D in tblBAS Yes
AllTables CrossTable ATC004 any date in database in the future Yes
AllTables CrossTable ATC005 patients submitted previously who have been missed out Yes
AllTables CrossTable ATC006 Any fields not coded as coding lists on table definition Yes