MOEResultInventory
Attributes
Attribute Code |
Attribute Name |
SQL DB Data Type |
ReportNet3 Data Type |
Properties |
Code list |
Related table(s) |
In Reporting |
|---|---|---|---|---|---|---|---|
MOI_01 |
CountryCode |
varchar(2) |
string |
PK |
N |
||
MOI_02 |
AssessmentMethodId |
varchar(50) |
string |
PK |
N |
||
MOI_03 |
DataAggregationProcessId |
varchar(50) |
string |
PK |
N |
||
MOI_04 |
Year |
PK |
N |
||||
MOI_05 |
PollutantId |
int |
numeric |
N |
|||
MOI_06 |
Unit |
varchar(10) |
string |
N |
|||
MOI_07 |
Validity |
int |
numeric |
N |
|||
MOI_08 |
SpatialResolution |
int |
numeric |
N |
|||
MOI_09 |
Country |
varchar(20) |
string |
N |
|||
MOI_10 |
Pollutant |
varchar(50) |
string |
N |
|||
MOI_11 |
DataAggregationProcess |
varchar(XXX) |
string |
N |
|||
MOI_12 |
ValueCount |
int |
numeric |
N |
|||
MOI_13 |
StartInYear |
datetime |
datetime |
N |
|||
MOI_14 |
EndInYear |
datetime |
datetime |
N |
|||
MOI_15 |
MinResultTimeInYear |
??? |
??? |
N |
|||
MOI_16 |
MaxResultTimeInYear |
??? |
??? |
N |
|||
MOI_17 |
SourceDataFlow |
??? |
??? |
N |
|||
MOI_18 |
RawDataURL |
varchar(50) |
string |
N |
|||
MOI_19 |
Deletion |
bit |
boolean |
N |
Note
There is no corresponding table in the reporting data model. Therefore, all attributes are marked N.
Attribute details
MOI_01 - CountryCode
Content
Country or territory ISO2 code.
In Reporting
N - No corresponding reporting table.
MOI_02 - AssessmentMethodId
Content
Identifier of the assessment method (model), given by provider.
In Reporting
N - No corresponding reporting table.
MOI_03 - DataAggregationProcessId
Content
Identifier for the process of aggregating model data into statistical values.
In Reporting
N - No corresponding reporting table.
MOI_04 - Year
Content
year covered by the modelled data.
In Reporting
N - No corresponding reporting table.
MOI_05 - PollutantId
Content
Code of the air pollutant being modeled, as per Data Dictionary standards.
In Reporting
N - No corresponding reporting table.
MOI_06 - Unit
Content
Unit of measurement for the air pollution level (e.g., µg/m³).
In Reporting
N - No corresponding reporting table.
MOI_07 - Validity
Content
Indicator of whether the model data is valid or flagged.
In Reporting
N - No corresponding reporting table.
MOI_08 - SpatialResolution
Content
Description of the spatial resolution of the model output, indicating the level of detail - new code list.
In Reporting
N - No corresponding reporting table.
MOI_09 - Country
Content
Name of the country.
In Reporting
N - No corresponding reporting table.
MOI_10 - Pollutant
Content
Name of the air pollutant being measured, as per Data Dictionary standards.
In Reporting
N - No corresponding reporting table.
MOI_11 - DataAggregationProcess
Content
Label of the process of data aggregation into statistical values.
In Reporting
N - No corresponding reporting table.
MOI_12 - ValueCount
Content
Number of values reported in the model.
In Reporting
N - No corresponding reporting table.
MOI_13 - StartInYear
Content
Datetime of the first data transmitted
In Reporting
N - No corresponding reporting table.
MOI_14 - EndInYear
Content
Datetime of the last data transmitted
In Reporting
N - No corresponding reporting table.
MOI_15 - MinResultTimeInYear
Content
???
In Reporting
N - No corresponding reporting table.
MOI_16 - MaxResultTimeInYear
Content
???
In Reporting
N - No corresponding reporting table.
MOI_17 - SourceDataFlow
Content
Indicate whether the data were transmitted in E1b (Reportnet2) or within the new system Reportnet3.
In Reporting
N - No corresponding reporting table.
MOI_18 - RawDataURL
Content
URL of parquet file
In Reporting
N - No corresponding reporting table.
MOI_19 - Deletion
Content
Flag to indicate that this element must be deleted.
In Reporting
N - No corresponding reporting table.