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 |
||
SPP_02 |
ProcessId |
varchar(150) |
string |
PK |
||
SPP_03 |
AssessmentMethodId |
varchar(100) |
string |
PK |
ComplianceAssessmentMethod |
|
SPP_04 |
ProcessActivityBegin |
datetime |
datetime |
PK |
||
SPP_05 |
ProcessActivityEnd |
datetime |
datetime |
|||
SPP_06 |
PollutantId |
int |
numeric |
|||
SPP_07 |
MeasurementType |
varchar(50) |
string |
|||
SPP_08 |
Method |
varchar(50) |
string |
|||
SPP_09 |
Equipment |
varchar(50) |
string |
|||
SPP_10 |
AnalyticalTechnique |
varchar(50) |
string |
|||
SPP_11 |
EquivalenceDemonstrated |
varchar(20) |
string |
|||
SPP_12 |
DataQualityDocumentId |
varchar(150) |
string |
|||
SPP_13 |
EquivalenceDemonstrationDocumentId |
varchar(150) |
string |
|||
SPP_14 |
ProcessDocumentId |
varchar(150) |
string |
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
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
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
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
SPP_05 – ProcessActivityEnd
Content
End time of the measurement process.
In Reference
SPP_06 – PollutantId
Content
Code of the air pollutant being measured, as per Data Dictionary standards.
In Reference
SPP_07 – MeasurementType
Content
Classification of measurement methods into generic types.
In Reference
SPP_08 – Method
Content
Specific method used for measuring air pollutants.
In Reference
SPP_09 – Equipment
Content
Equipment used for air pollutant measurement.
In Reference
SPP_10 – AnalyticalTechnique
Content
Analytical technique used for measuring pollutants.
In Reference
SPP_11 – EquivalenceDemonstrated
Content
Status of equivalence demonstration according to regulatory requirements.
In Reference
SPP_12 – DataQualityDocumentId
Content
Identifier of the Quality Assurance report given by data provider.
In Reference
SPP_13 – EquivalenceDemonstrationDocumentId
Content
Identifier of the Equivalence demonstration report given by data provider.
In Reference
SPP_14 – ProcessDocumentId
Content
Identifier of the documentation on process and data quality given by data provider.
In Reference
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.