SamplingProcess

SamplingProcess

Description

The purpose of the SamplingProcess table is to collect data on measurement techniques and methodologies. It describes the specific configurations of equipment, mostly through code listed values, and includes information on quality of the measurements as well as further details about the methods through attached documentation. The table includes corresponding times of operation.

SamplingProcess table has to be reported whenever new information or an update of existing information is available. Attributes which create unique identifier of each record: CountryCode, ProcessId, AssessmentMethodId and ProcessActivityBegin.

Updates of the SamplingProcess table will not be time stamped, i.e. each update generates the only version of the table in reference/legacy data:

  • either as addition of new record, understood as addition of new combination of values for the attributes creating unique identifier,

  • or modification of existing record, understood as modification of a value for any other attribute, e.g. entering end date.

Validity of the new record will be tested using QC rules to be established, e.g. cross-checking relation between the code listed values.

Valid modifications of existing record in this table are:

  • inserting ProcessActivityEnd,

  • attaching new/different documentation,

  • minor corrections, e.g. of wrong code list values.

Validity of the modifications of existing record will be tested using QC rules to be established. Allowed modifications are not supposed to affect outcomes of compliance analysis and/or assessments.

Data products will present all records related to SamplingPoints reported recently for the UTD purpose.

EEA extensions

SamplingProcess table will be extended by EEA by several attributes:

  • Country, for convenience, based on ISO2 country codes,

  • Pollutant, for convenience, based on code list,

  • SamplingPointReferenceId, based on SamplingPoint table.

Data management rules

In case where the ProcessActivityBegin was reported wrongly and/or the corresponding record needs to be deleted, the same value should be reported for ProcessActivityEnd. Records where ProcessActivityBegin = ProcessActivityEnd will be flagged for deletion in the reference data flow.

It is recommended not to change DataQualityDocumentId, EquivalenceDemonstrationDocumentId or ProcessDocumentId in case of documentation update related to the same process. Instead, a new attachment should be uploaded in Document table re-using the same DocumentId. Previous versions of documentation will be kept in reference data. In case where the same, e.g. DataQualityDocumentId, was used for all records and there is a need to modify documentation only for one specific process, it is recommended to create a new DataQualityDocumentId for that record in the SamplingProcess table, and then report old non-process-specific and new process-specific documents as attachments for that new DataQualityDocumentId as DocumentId in the Document table in a subsequent manner.

Attributes

Attribute Code

Attribute Name

SQL DB Data Type

ReportNet3 Data Type

Properties

Code list

Related table(s)

SPP_01

CountryCode

varchar(2)

string

PK

countries

SPP_02

ProcessId

varchar(150)

string

PK

SPP_03

AssessmentMethodId

varchar(100)

string

PK

ComplianceAssessmentMethod
SamplingPoint
SamplingPointLocation
ObservationMeasurementResult

SPP_04

ProcessActivityBegin

datetime

datetime

PK

SPP_05

ProcessActivityEnd

datetime

datetime

SPP_06

PollutantId

int

numeric

pollutant

SPP_07

MeasurementType

varchar(50)

string

measurementtype

SPP_08

Method

varchar(50)

string

samplingprocessmethod

SPP_09

Equipment

varchar(50)

string

samplingprocessequipment

SPP_10

AnalyticalTechnique

varchar(50)

string

analyticaltechnique

SPP_11

EquivalenceDemonstrated

varchar(20)

string

equivalencedemonstrated

SPP_12

DataQualityDocumentId

varchar(150)

string

Documentation

SPP_13

EquivalenceDemonstrationDocumentId

varchar(150)

string

Documentation

SPP_14

ProcessDocumentId

varchar(150)

string

Documentation

Note

Attributes with ReportNet3 data type date or datetime shall use the ISO 8601 format. Date-time values may include a local UTC offset.

Attribute details

SPP_01 – CountryCode

Content

Country or territory ISO2 code.

In Reference

View reference attribute

SPP_02 – ProcessId

Content

Identifier of the sampling process, given by data provider.

Remarks

The same ProcessId can be re-used for the same equipment configurations under different sampling points (AssessmentMethodId).

In Reference

View reference attribute

SPP_03 – AssessmentMethodId

Content

Identifier of the assessment method (sampling point) given by data provider.

Remarks

A sampling point (AssessmentMethodId) can be closed (set as inactive) by ending the ProcessId (specifying ProcessActivityEnd). The same sampling point can be re-opened, also with the same ProcessId, by adding new record with new ProcessActivityBegin.

In Reference

View reference attribute

SPP_04 – ProcessActivityBegin

Content

Start time of the measurement process.

Remarks

If there is more than one ProcessId within the same AssessmentMethodId, then ProcessActivityBegin - ProcessActivityEnd should not overlap within the same AssessmentMethodId.

In Reference

View reference attribute

SPP_05 – ProcessActivityEnd

Content

End time of the measurement process.

In Reference

View reference attribute

SPP_06 – PollutantId

Content

Code of the air pollutant being measured, as per Data Dictionary standards.

In Reference

View reference attribute

SPP_07 – MeasurementType

Content

Classification of measurement methods into generic types.

In Reference

View reference attribute

SPP_08 – Method

Content

Specific method used for measuring air pollutants.

In Reference

View reference attribute

SPP_09 – Equipment

Content

Equipment used for air pollutant measurement.

In Reference

View reference attribute

SPP_10 – AnalyticalTechnique

Content

Analytical technique used for measuring pollutants.

In Reference

View reference attribute

SPP_11 – EquivalenceDemonstrated

Content

Status of equivalence demonstration according to regulatory requirements.

In Reference

View reference attribute

SPP_12 – DataQualityDocumentId

Content

Identifier of the Quality Assurance report given by data provider.

In Reference

View reference attribute

SPP_13 – EquivalenceDemonstrationDocumentId

Content

Identifier of the Equivalence demonstration report given by data provider.

In Reference

View reference attribute

SPP_14 – ProcessDocumentId

Content

Identifier of the documentation on process and data quality given by data provider.

In Reference

View reference attribute

Example

Attribute Code

Attribute Name

Example

SQL DB Data Type

ReportNet3 Data Type

PK

CL

SPP_01

CountryCode

DU

varchar(2)

string

✓

✓

SPP_02

ProcessId

SPP_DU0001_0005_1

varchar(150)

string

✓

SPP_03

AssessmentMethodId

SPO_DU0001_0005_100

varchar(100)

string

✓

SPP_04

ProcessActivityBegin

2013-06-25T00:00

datetime

datetime

✓

SPP_05

ProcessActivityEnd

null

datetime

datetime

SPP_06

PollutantId

5

int

numeric

✓

SPP_07

MeasurementType

automatic

varchar(50)

string

✓

SPP_08

Method

BETA

varchar(50)

string

✓

SPP_09

Equipment

BETA1020

varchar(50)

string

✓

SPP_10

AnalyticalTechnique

null

varchar(50)

string

✓

SPP_11

EquivalenceDemonstrated

yes

varchar(20)

string

✓

SPP_12

DataQualityDocumentId

DOC_DQ_SPP_DU0005_1

varchar(150)

string

SPP_13

EquivalenceDemonstrationDocumentId

DOC_EQ_SPP_DU0005_1

varchar(150)

string

SPP_14

ProcessDocumentId

DOC_PR_SPP_DU0005_1

varchar(150)

string

Legend: PK = Primary Key; CL = Code List.

Note: The example file is temporarily unavailable while it is being updated. The updated version will be made available once the revision is complete.