# ScenarioMeasure

```{image} ../_static/table-icons/ScenarioMeasure.png
:alt: ScenarioMeasure
:align: right
:width: 200px
```

```{contents}
:local:
:depth: 2
```

## Attributes

| Attribute Code | Attribute Name | SQL DB Data Type | ReportNet3 Data Type | Properties | Code list | Related table(s) | In Reporting |
| -------------- | -------------- | ---------------- | -------------------- | ---------- | --------- | ---------------- | :----------: |
| SME_01 | CountryCode | varchar(2) | string | PK | [countries](https://dd.eionet.europa.eu/vocabulary/common/countries) |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/ScenarioMeasure.html#sme-01-countrycode) |
| SME_02 | ScenarioId | varchar(50) | string | PK |  | ComplianceAssessmentMethod<br>PlanScenario | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/ScenarioMeasure.html#sme-02-scenarioid) |
| SME_03 | ScenarioCategory | varchar(20) | string | PK | [scenariocategory](https://dd.eionet.europa.eu/vocabulary/aq/scenariocategory) |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/ScenarioMeasure.html#sme-03-scenariocategory) |
| SME_04 | MeasureGroupId | varchar(50) | string | PK |  | MeasurementStation | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/ScenarioMeasure.html#sme-04-measuregroupid) |
| SME_05 | MeasureGroupPollutionReduction | decimal(10,2) | numeric |  |  |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/ScenarioMeasure.html#sme-05-measuregrouppollutionreduction) |
| SME_06 | MeasureReductionAssessmentMethodId | varchar(50) | string |  |  | ModelObjectiveEstimation | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/ScenarioMeasure.html#sme-06-measurereductionassessmentmethodid) |
| SME_07 | Country | varchar(20) | string |  |  |  | N |
| SME_08 | Pollutant | varchar(50) | string |  |  |  | N |
| SME_09 | PollutantId | int | numeric |  |  |  | N |
| SME_10 | DataAggregationProcess | varchar(XXX) | string |  |  |  | N |
| SME_11 | DataAggregationProcessId | varchar(50) | string |  |  |  | N |
| SME_12 | Deletion | bit | boolean |  |  |  | N |

```{note}
`Country`, `Pollutant`, `PollutantId`, `DataAggregationProcess`, `DataAggregationProcessId` and `Deletion` are Reference attributes without a corresponding attribute in the reporting data model.
```

## Attribute details

### SME_01 - CountryCode

**Content**

Country or territory ISO2 code.

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/ScenarioMeasure.html#sme-01-countrycode)

### SME_02 - ScenarioId

**Content**

Identifier of the scenario, given by data provider.

**Remarks**

It will be cross-checked against PlanScenario table.

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/ScenarioMeasure.html#sme-02-scenarioid)

### SME_03 - ScenarioCategory

**Content**

Classification of the scenario (e.g., baseline, projection).

**Remarks**

ScenarioCategory: baseline or projection. It should be included in the composite PK in the next iteration of schema version.

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/ScenarioMeasure.html#sme-03-scenariocategory)

### SME_04 - MeasureGroupId

**Content**

Identifier of the pollution reduction for measure group, given by data provider.

**Remarks**

MeasureGroupId: distinct groups might contain one or more measures. For example, group 1 contains all the measures related to traffic, while group 2 contains all the measures related to industry. To the extreme, the group may correspond to one measure only; the same MeasureGroupId might be used for different scenarios, also - several MeasureGroupId might be declared for the same scenario.

It will be cross-checked against Measure table.

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/ScenarioMeasure.html#sme-04-measuregroupid)

### SME_05 - MeasureGroupPollutionReduction

**Content**

Reduction in air pollution concentration levels due to the applied group of measures.

**Remarks**

Sum of MeasureGroupAirPollutionReduction within ScenarioId should agree with the difference between value of AirPollutionLevel in the first AttainmentId and the value reported in PlanScenario as ScenarioAirPollutionLevel.

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/ScenarioMeasure.html#sme-05-measuregrouppollutionreduction)

### SME_06 - MeasureReductionAssessmentMethodId

**Content**

Identifier of the assessment method - model -  used in the scenario, given by data provider.

**Remarks**

AssessmentMethodId: the model/OBE used for producing the results for the measure group (also to be declared in the Model table). It may be cross-checked against Model table, also - indirectly - against ModellingResult table.

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/ScenarioMeasure.html#sme-06-measurereductionassessmentmethodid)

### SME_07 - Country

**Content**

Name of the country.

**In Reporting**

N - No corresponding reporting attribute.

### SME_08 - Pollutant

**Content**

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

**In Reporting**

N - No corresponding reporting attribute.

### SME_09 - PollutantId

**Content**

Code of the air pollutant for which the contribution is being assessed.

**In Reporting**

N - No corresponding reporting attribute.

### SME_10 - DataAggregationProcess

**Content**

Label of the process of data aggregation into statistical values.

**In Reporting**

N - No corresponding reporting attribute.

### SME_11 - DataAggregationProcessId

**Content**

Identifier for the process used to aggregate air quality data in the scenario.

**In Reporting**

N - No corresponding reporting attribute.

### SME_12 - Deletion

**Content**

Flag to indicate that this element must be deleted.

**In Reporting**

N - No corresponding reporting attribute.