tblCENTER - Center information
holds information about the Center (e.g. geographical localisation, type of clinic) where the patient is receiving HIV care
|
Core FieldsNote: 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)
|
Code for the site situation (facility location)
|
|
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
|
Quality of internet access for completing online Surveys.
|
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.
|
optional precision annotation for last review date LAST_REVIEW_D
|
QA Checks
Table | Crosstable | Error Code | Description | Study specific | 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 |