wiki:Hicdep_1.100/TableCENTER

tblCENTER - Center information

Holds information about the Center in general, such as geographical location, start date of data collection, type of care provider etc.

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.

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

Last modified 19 months ago Last modified on 12/02/15 09:39:32