year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.

smallint(2)

0

Month

Month

month in which sample taken, values in range 0-12. If the month value has not been supplied the value will be 0.

smallint(2)

0

Day

Day

day in which sample was taken, values in range 0-31. If the day value has not been supplied the value will be 0.

smallint(2)

0

Concentration

Concentration

concentration of determinand in sample. In TCM data, concentration values recorded as below the limit of detection or determination should contain the limit of detection or determination in the concentration field, with the LimitFlag field set to &lt;.

internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).

nvarchar(35)

-1

SampleID

Sample ID

unique sample identifier required if multiple samples taken on same day. SampleID default value is 0.

nvarchar(20)

0

Determinand

Determinand

determinand name.

nvarchar(100)

0

CASNumber

CAS Number

Chemical Abstract Service Number of the hazardous substance, as defined in the codelist.

]]>waterbase-tcm-hazsubs-biotawaterbase-tcm-hazsubs-biota Waterbase-TCM: HazSubs Biota The HSBiota table contains disaggregated data on hazardous substances in biota, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources only. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations data. 2012-06-25T10:35:07ZFalse1002009-11-12T23:43:35Zedse584498App.interfaces.IPersistentExtraOFS.interfaces.IObjectManagerwebdav.interfaces.IWriteLockProducts.ATContentTypes.interfaces.folder.IATBTreeFoldereea.faceted.inheritance.subtypes.interfaces.IPossibleFacetedHeritorProducts.CMFCore.interfaces._content.IContentishProducts.LinguaPlone.interfaces.ITranslatableplone.contentrules.engine.interfaces.IRuleAssignableeea.geotags.storage.interfaces.IGeoTaggableProducts.CMFCore.interfaces._content.IOpaqueItemManagereea.epub.subtypes.interfaces.IEPUBAwareeea.pdf.subtypes.interfaces.ICollectionPDFAwareeea.facetednavigation.subtypes.interfaces.IPossibleFacetedNavigableOFS.interfaces.IFoldereea.relations.content.interfaces.IBaseObjectAccessControl.interfaces.IOwnedProducts.ATContentTypes.interfaces.interfaces.IATContentTypeProducts.CMFDynamicViewFTI.interfaces.ISelectableBrowserDefaultProducts.CMFCore.interfaces._content.IWorkflowAwareOFS.interfaces.IItemOFS.interfaces.IOrderedContainerProducts.EEAContentTypes.interfaces.IEEAContentplone.app.iterate.interfaces.IIterateAwareeea.pdf.subtypes.interfaces.IPDFAwareAcquisition.interfaces.IAcquirerOFS.interfaces.IFindSupportplone.app.folder.folder.IATUnifiedFoldereea.themecentre.interfaces.IPossibleThemeCentrezope.annotation.interfaces.IAttributeAnnotatableeea.themecentre.interfaces.IThemeTaggableOFS.interfaces.ITraversableplone.app.folder.bbb.IPhotoAlbumAbleProducts.CMFCore.interfaces._content.IDynamicTypeeea.reports.interfaces.IPossibleReportContainereea.annotator.subtypes.interfaces.IAnnotatorAwarearchetypes.schemaextender.interfaces.IExtensiblewebdav.interfaces.IDAVResourceeea.alchemy.interfaces.IAlchemyDiscoverableProducts.CMFCore.interfaces._content.IMutableMinimalDublinCorepersistent.interfaces.IPersistenteea.cache.subtypes.interfaces.ICacheAwareAccessControl.interfaces.IPermissionMappingSupportApp.interfaces.INavigationplone.app.folder.bbb.IArchivableProducts.CMFCore.interfaces._content.IFolderisheea.promotion.interfaces.IPromotableOFS.interfaces.ICopyContainerProducts.Archetypes.interfaces.referenceable.IReferenceableOFS.interfaces.IPropertyManagerApp.interfaces.IUndoSupportplone.uuid.interfaces.IUUIDAwareplone.portlets.interfaces.ILocalPortletAssignableOFS.interfaces.ICopySourcewebdav.EtagSupport.EtagBaseInterfaceProducts.CMFPlone.interfaces.constrains.ISelectableConstrainTypesplone.locking.interfaces.ITTWLockableProducts.NavigationManager.sections.interfaces.INavigationSectionPositionableeea.progressbar.interfaces.IBaseObjecteea.dataservice.interfaces.IDatatableProducts.Archetypes.interfaces.base.IBaseObjectwebdav.interfaces.IDAVCollectioneea.versions.interfaces.IVersionEnhancedplone.app.imaging.interfaces.IBaseObjectAccessControl.interfaces.IRoleManagerplone.folder.interfaces.IOrderableFoldereea.uberlisting.browser.app.interfaces.IPossibleUberlistingViewProducts.CMFCore.interfaces._content.ICatalogAwareProducts.Archetypes.interfaces.metadata.IExtensibleMetadatacollective.quickupload.interfaces.IQuickUploadCapableProducts.EEAContentTypes.interfaces.IEEAPossibleContentProducts.Archetypes.interfaces.base.IBaseFolderThe HSBiota table contains disaggregated data on hazardous substances in biota, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources only. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations data.