ES Sites

This data dictionary is mostly machine-generated and still needs to be validated by a human. If you notice issues or want to contribute to improve don’t hesitate to send an email to webifa@novel-t.ch.

Export to XLSX

Variable	Variable name in the data entry	Description	Data type	Variable options		Variable name in the exports
				Allowed Values	Required	Envdata.Rec	Environ.Rec	Envresult.Rec	Export Es Sites To Csv	Site.Rec
AREA_CCODE	AREA - Area (COUNTRY)	N/A	text	N/A	N/A	N/A	N/A	N/A	site.CCODE	country
AREA_COUNTRY	AREA - Area (COUNTRY)	N/A	text	N/A	N/A	country	country	country	site.ADMIN0	N/A
AREA_PCODE	AREA - Area (PROVINCE)	N/A	text	N/A	N/A	N/A	N/A	N/A	site.PCODE	N/A
AREA_PROVINCE	AREA - Area (PROVINCE)	N/A	text	N/A	N/A	province	province	province	site.ADMIN1	siteprov
AREA_DCODE	AREA - Area (DISTRICT)	N/A	text	N/A	N/A	N/A	N/A	N/A	site.DCODE	N/A
AREA_DISTRICT	AREA - Area (DISTRICT)	N/A	text	N/A	N/A	district	district	DISTRICT	site.ADMIN2	sitedist
SPECSITE	SPECSITE - Site number	N/A	text	N/A	Yes	specsite	specsite	N/A	site.FIELD_SPECSITE	specsite
SITECODE	SITECODE - Site code Country	N/A	text	N/A	Yes	N/A	N/A	N/A	site.SITECODE	N/A
RSITECODE	RSITECODE - Site code Region	N/A	text	N/A	N/A	N/A	N/A	N/A	site.FIELD_BID_ALT	N/A
SITENAME	SITENAME	N/A	text	N/A	Yes	sitename	sitename	SITE	site.FIELD_SITE_NAME	sitename
TMPSITE	TMPSITE - Temporary site	N/A	boolean	0 = No	N/A	N/A	N/A	N/A	site.FIELD_TEMP_SITE	N/A
				1 = Yes
STATUS	STATUS - Status of the site's function	N/A	text	1 = Active	Yes	N/A	N/A	N/A	site.FIELD_SITE_STATUS	N/A
				2 = Postponed
				3 = Closed
				4 = Unknown
DEND	DEND - Date ended	N/A	datetime	N/A	N/A	N/A	N/A	N/A	site.FIELD_DEND	dend
DSTART	DSTART - Date started	N/A	datetime	N/A	Yes	N/A	N/A	N/A	site.FIELD_DSTART	dstart
SITETYPE	SITETYPE - Type of Site	N/A	number	1 = WASTE WATER	N/A	N/A	N/A	N/A	site.FIELD_SITE_TYPE	N/A
				2 = WASTE WATER TREATMENT PLANT
				3 = SEWAGE WATER / SEWAGE
				4 = SEPTIC TANK
CANALTYPE	CANALTYPE - Type of Canal	N/A	number	1 = Open Canal	N/A	N/A	N/A	N/A	site.FIELD_SITE_TYPE_OF_CANAL	N/A
				2 = Closed canal
SITECAT	SITECAT - Category for the systematic collection schedule	N/A	text	0 = Seasonal	N/A	N/A	N/A	N/A	site.FIELD_SITE_SITECAT	N/A
				1 = Ad-hoc
				2 = Permanent
				3 = Tributary
FREQ	FREQ - Frequency of collection	N/A	text	1 = Weekly	N/A	N/A	N/A	N/A	site.FIELD_SITE_FREQUENCY	N/A
				3 = Monthly
				2 = Twice a Month
				4 = Undefined
ISOLLAB	ISOLLAB - Name of isolation Lab used for samples	N/A	text	N/A	N/A	N/A	N/A	N/A	site.FIELD_SITE_ISOLLAB	N/A
COMPOSITE	COMPOSITE - Composite of multiple collections making one site ?	N/A	number	2 = Yes	Yes	N/A	N/A	N/A	site.FIELD_TYPE_OF_SAMPLE	N/A
				1 = No
				3 = Unknown
GEOLOC1_LAT	GEOLOC1 - Geolocation	Stores the latitude value	number	N/A	N/A	N/A	N/A	N/A	site.FIELD_GEOLOCATION_LAT	lat
GEOLOC1_LNG	GEOLOC1 - Geolocation	Stores the longitude value	number	N/A	N/A	N/A	N/A	N/A	site.FIELD_GEOLOCATION_LNG	lon
GEOLOC2_LAT	GEOLOC2 - Geolocation 2	Stores the latitude value	number	N/A	N/A	N/A	N/A	N/A	site.FIELD_GEOLOCATION2_LAT	N/A
GEOLOC2_LNG	GEOLOC2 - Geolocation 2	Stores the longitude value	number	N/A	N/A	N/A	N/A	N/A	site.FIELD_GEOLOCATION2_LNG	N/A
GEOLOC3_LAT	GEOLOC3 - Geolocation 3	Stores the latitude value	number	N/A	N/A	N/A	N/A	N/A	site.FIELD_GEOLOCATION3_LAT	N/A
GEOLOC3_LNG	GEOLOC3 - Geolocation 3	Stores the longitude value	number	N/A	N/A	N/A	N/A	N/A	site.FIELD_GEOLOCATION3_LNG	N/A
GEOLOCCOLL	GEOLOCCOLL - Geolocation/Coordinates collected while at site location	N/A	boolean	0 = No	N/A	N/A	N/A	N/A	site.FIELD_GEOLOCATION_STATUS	N/A
				1 = Yes
COLLECTORNAME	COLLECTORNAME - Name of main sample collector	N/A	text	N/A	N/A	N/A	N/A	N/A	site.FIELD_SITE_COLLECTOR_NAME	N/A
COLLECTORPHONE	COLLECTORPHONE - Phone Number of Main sample collector	N/A	text	N/A	N/A	N/A	N/A	N/A	site.FIELD_SITE_COLLECTOR_PHONE	N/A
CITY	CITY - City Name	N/A	text	N/A	N/A	N/A	N/A	N/A	site.FIELD_SITE_CITY_NAME	N/A
VILLAGE	VILLAGE - Village / Settlement	N/A	text	N/A	N/A	N/A	N/A	N/A	site.FIELD_SITE_VILLAGE	N/A
ESTPOP	ESTPOP - Estimated total population for the site's catchment area	N/A	number	N/A	N/A	N/A	N/A	N/A	site.FIELD_SITE_ESTPOP	N/A
IDPPRESENT	IDPPRESENT - Internally Displaced Persons in catchment area	N/A	number	1 = Yes	N/A	N/A	N/A	N/A	site.FIELD_SITE_IDPPRESENT	N/A
				2 = No
				9 = Unknown
REFUGEEPRESENT	REFUGEEPRESENT - Are refugee camps set up in the catchment area?	N/A	number	1 = Yes	N/A	N/A	N/A	N/A	site.FIELD_SITE_REFUGEEPRESENT	N/A
				2 = No
				9 = Unknown
SCHOOLPRESENT	SCHOOLPRESENT - Schools in catchment area	N/A	number	1 = Yes	N/A	N/A	N/A	N/A	site.FIELD_SITE_SCHOOLPRESENT	N/A
				2 = No
				9 = Unknown
HFPRESENT	HFPRESENT - Health Facility/Centre in catchment area	N/A	number	1 = Yes	N/A	N/A	N/A	N/A	site.FIELD_SITE_HFPRESENT	N/A
				2 = No
				9 = Unknown
TRANSITPRESENT	TRANSITPRESENT - Transit Hub in catchment area	N/A	number	1 = Yes	N/A	N/A	N/A	N/A	site.FIELD_SITE_TRANSITPRESENT	N/A
				2 = No
				9 = Unknown
COMMENTS	COMMENTS	N/A	text	N/A	N/A	N/A	N/A	N/A	site.FIELD_SITE_COMMENTS	N/A