ModelObjectiveEstimation

ModelObjectiveEstimation

Attributes

Attribute Code

Attribute Name

SQL DB Data Type

ReportNet3 Data Type

Properties

Code list

Related table(s)

In Reporting

MOE_01

CountryCode

varchar(2)

string

PK

countries

Y

MOE_02

AssessmentMethodId

varchar(50)

string

PK

ComplianceAssessmentMethod
SpatialRepresentativeness
PollutionLevelAdjustment
PlanScenario
MOEResultInline
MOEResultExternal

Y

MOE_03

DataAggregationProcessId

varchar(50)

string

PK

aggregationprocess

MOEResultInline
MOEResultExternal

Y

MOE_04

AssessmentMethodName

varchar(150)

string

Y

MOE_05

PollutantId

int

numeric

pollutant

Y

MOE_06

ResultEncoding

varchar(10)

string

resultencoding

Y

MOE_07

MethodApplication

varchar(20)

string

modelapplication

Y

MOE_08

GenericMQI

decimal(5,2)

numeric

Y

MOE_09

DataQualityDocumentId

varchar(150)

string

Documentation

Y

MOE_10

MethodDocumentId

varchar(150)

string

Documentation

Y

MOE_11

Country

varchar(20)

string

N

MOE_12

Pollutant

varchar(50)

string

N

MOE_13

DataAggregationProcess

varchar(XXX)

string

N

MOE_14

Deletion

bit

boolean

N

Note

Country, Pollutant, DataAggregationProcess and Deletion are Reference attributes without a corresponding attribute in the reporting data model.

Attribute details

MOE_01 - CountryCode

Content

Country or territory ISO2 code.

In Reporting

Y – View reporting attribute

MOE_02 - AssessmentMethodId

Content

Identifier of the assessment method (model), given by data provider.

Remarks

AssessmentMethodId which is model or OBE identifier is understood as an application of modelling or estimation methodology. It may be re-used for different years if the methodology and data sources remain the same (for example when the same source of meteorological data is used with data from different years).


In Reporting

Y – View reporting attribute

MOE_03 - DataAggregationProcessId

Content

Identifier for the process of data aggregation into statistical values.

Remarks

Several different statistics may be generated by the same AssessmentMethodId (for example where time series are modelled and subsequently aggregated).


In Reporting

Y – View reporting attribute

MOE_04 - AssessmentMethodName

Content

Name of model or OBE which can be re-used with different AssessmentMethodId, e.g. ‘CHIMERE’, ‘WRF-Chem’, etc.

Remarks

Examples include model names such as ‘CHIMERE’, ‘WRF-Chem’, etc.


In Reporting

Y – View reporting attribute

MOE_05 - PollutantId

Content

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

Remarks

Only one pollutant can be handled by a single AssessmentMethodId (model/OBE).


In Reporting

Y – View reporting attribute

MOE_06 - ResultEncoding

Content

Encoding method used for model results (‘zone’, ‘internal’ or ‘external’).

Remarks

Allowed values include:

  • zone

  • inline

  • external


In Reporting

Y – View reporting attribute

MOE_07 - MethodApplication

Content

Purpose of the model application (e.g., assessment, adjustment, scenario, spatial representativeness)

Remarks

The same Model/OBE identifier can only have one MethodApplication.


In Reporting

Y – View reporting attribute

MOE_08 - GenericMQI

Content

Modelling Quality Indicator

Remarks

MQI is reported here because it may originate from model or OBE validation exercises not directly related to the area for which modelling results are submitted within AQ e-Reporting. It is considered general information describing the quality of the modelling application used in the reporting.


In Reporting

Y – View reporting attribute

MOE_09 - DataQualityDocumentId

Content

Identifier of the report describing the model given by data provider.

In Reporting

Y – View reporting attribute

MOE_10 - MethodDocumentId

Content

Identifier of the report detailing the quality of the modelled data given by data provider.

In Reporting

Y – View reporting attribute

MOE_11 - Country

Content

Name of the country.

In Reporting

N - No corresponding reporting attribute.

MOE_12 - Pollutant

Content

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

In Reporting

N - No corresponding reporting attribute.

MOE_13 - DataAggregationProcess

Content

Label of the process of data aggregation into statistical values.

In Reporting

N - No corresponding reporting attribute.

MOE_14 - Deletion

Content

Flag to indicate that this element must be deleted.

In Reporting

N - No corresponding reporting attribute.