Documentation

Documentation

Description

The purpose of the Documentation table is to communicate the documents requested in different tables such as documentation on data quality process, documentation on the models, the air quality plans etc.

Documentation (record) table has to be reported whenever a new document or an updated document is available. Attributes which create unique identifier of each record: CountryCode, DataTable, DocumentType and DocumentId.

Updates of the Documentation table will be managed using reference/legacy data, where each addition and modification will be stamped with the ReportingTime. Data products for public and reporters will present the records with the latest ReportingTime for each unique identifier.

EEA extensions

Documentation table will be extended by EEA by:

  • Country (for convenience), based on ISO2 country codes;

  • ReportingTime, registering time of the latest reporting or modification for each record;

  • DocumentURL where the document is stored.

Data management rules

More details about rules of data management related to documentation reporting are given above under the relevant tables.

Records in Document table which do not have any correspondence (via DocumentId) to other tables will be flagged for deletion in the reference data flow.

Attributes

Attribute Code

Attribute Name

SQL DB Data Type

ReportNet3 Data Type

Properties

Code list

Related table(s)

DOC_01

CountryCode

varchar(2)

string

PK

countries

DOC_02

DataTable

varchar(50)

string

PK

datatable

DOC_03

DocumentType

varchar(50)

string

PK

documenttype

DOC_04

DocumentId

varchar(150)

string

PK

MeasurementStation
SamplingProcess
ModelObjectiveEstimation
AssessmentRegimeZone
CompliancePlanLink
SourceApportionment
PollutionLevelAdjustment

DOC_05

DocumentAttachment

varchar(100)

attachment (R3 data type)

Attribute details

DOC_01 – CountryCode

Content

Country or territory ISO2 code.

In Reference

View reference attribute

DOC_02 – DataTable

Content

Table name of origin.

In Reference

View reference attribute

DOC_03 – DocumentType

Content

Document content type.

In Reference

View reference attribute

DOC_04 – DocumentId

Content

Identifier of the document given by data provider.

In Reference

View reference attribute

DOC_05 – DocumentAttachment

Content

Attached document PDF.

Example

Attribute Code

Attribute Name

Example

SQL DB Data Type

ReportNet3 Data Type

PK

CL

DOC_01

CountryCode

DU

varchar(2)

string

✓

✓

DOC_02

DataTable

Station

varchar(50)

string

✓

✓

DOC_03

DocumentType

NetworkDocument

varchar(50)

string

✓

✓

DOC_04

DocumentId

DOC_NET_DU01

varchar(150)

string

✓

DOC_05

DocumentAttachment

DUS_NET_DU01.pdf

varchar(100)

attachment (R3 data type)

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.