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(100) |
string |
PK |
N |
||
MOI_03 |
DataAggregationProcessId |
varchar(50) |
string |
PK |
N |
||
MOI_04 |
Year |
int |
PK |
N |
|||
MOI_05 |
PollutantId |
int |
numeric |
N |
|||
MOI_06 |
Unit |
varchar(20) |
string |
N |
|||
MOI_07 |
Validity |
int |
numeric |
N |
|||
MOI_08 |
SpatialResolution |
int |
numeric |
N |
|||
MOI_09 |
Country |
varchar(50) |
string |
N |
|||
MOI_10 |
Pollutant |
varchar(100) |
string |
N |
|||
MOI_11 |
DataAggregationProcess |
varchar(100) |
string |
N |
|||
MOI_12 |
ValueCount |
bigint |
numeric |
N |
|||
MOI_13 |
StartInYear |
datetime |
datetime |
N |
|||
MOI_14 |
EndInYear |
datetime |
datetime |
N |
|||
MOI_15 |
MinResultTimeInYear |
datetime |
??? |
N |
|||
MOI_16 |
MaxResultTimeInYear |
datetime |
??? |
N |
|||
MOI_17 |
SourceDataFlow |
varchar(10) |
??? |
N |
|||
MOI_18 |
RawDataURL |
varchar(250) |
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.
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
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.