# SourceApportionment

```{image} ../_static/table-icons/SourceApportionment.png
:alt: SourceApportionment
: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 |
| -------------- | -------------- | ---------------- | -------------------- | ---------- | --------- | ---------------- | :----------: |
| SAP_01 | CountryCode | varchar(2) | string | PK | [countries](https://dd.eionet.europa.eu/vocabulary/common/countries) |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/SourceApportionment.html#sap-01-countrycode) |
| SAP_02 | SourceApportionmentId | varchar(50) | string | PK |  | ComplianceAssessmentMethod | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/SourceApportionment.html#sap-02-sourceapportionmentid) |
| SAP_03 | ContributionType | varchar(20) | string | PK | [contributiontype](https://dd.eionet.europa.eu/vocabulary/aq/contributiontype/view) |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/SourceApportionment.html#sap-03-contributiontype) |
| SAP_04 | SpatialScale | varchar(50) | string | PK | [spatialscale](https://dd.eionet.europa.eu/vocabulary/aq/spatialscale) |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/SourceApportionment.html#sap-04-spatialscale) |
| SAP_05 | SourceSector | varchar(50) | string | PK | [aq/sourcesectors](https://dd.eionet.europa.eu/vocabulary/aq/sourcesectors) |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/SourceApportionment.html#sap-05-sourcesector) |
| SAP_06 | PollutantId | int | numeric |  | [pollutant](https://dd.eionet.europa.eu/vocabulary/aq/pollutant/view) |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/SourceApportionment.html#sap-06-pollutantid) |
| SAP_07 | Contribution | decimal(8,2) | numeric |  |  |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/SourceApportionment.html#sap-07-contribution) |
| SAP_08 | SourceApportionmentDocumentId | varchar(150) | string |  |  | Documentation | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/SourceApportionment.html#sap-08-sourceapportionmentdocumentid) |
| SAP_09 | Country | varchar(20) | string |  |  |  | N |
| SAP_10 | Pollutant | varchar(50) | string |  |  |  | N |
| SAP_11 | Deletion | bit | boolean |  |  |  | N |

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

## Attribute details

### SAP_01 - CountryCode

**Content**

Country or territory ISO2 code.

**In Reporting**

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

### SAP_02 - SourceApportionmentId

**Content**

Identifier of the source apportionment, given by data provider.

**In Reporting**

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

### SAP_03 - ContributionType

**Content**

Type of contribution (e.g.,  background, increment). 

**In Reporting**

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

### SAP_04 - SpatialScale

**Content**

Geographical scope of the contribution (e.g., urban, local, regional, national).

**In Reporting**

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

### SAP_05 - SourceSector

**Content**

The sector responsible for emissions (e.g., traffic, industry, residential heating).

**In Reporting**

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

### SAP_06 - PollutantId

**Content**

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

**Remarks**

AirPollutantCode: must correspond to the AirPollutantCode of the AttainmentId.

**In Reporting**

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

### SAP_07 - Contribution

**Content**

Estimated contribution of the specified source sector to air pollution levels [%].

**Remarks**

The value is understood as applicable to AirPollutionLevel adjusted for natural sources. Therefore contributions should not include the natural sources, should be given as % and sum up to 100% within SourceAppId.

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/SourceApportionment.html#sap-07-contribution)

### SAP_08 - SourceApportionmentDocumentId

**Content**

Identifier of the documentation on source apportionment.

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/SourceApportionment.html#sap-08-sourceapportionmentdocumentid)

### SAP_09 - Country

**Content**

Name of the country.

**In Reporting**

N - No corresponding reporting attribute.

### SAP_10 - Pollutant

**Content**

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

**In Reporting**

N - No corresponding reporting attribute.

### SAP_11 - Deletion

**Content**

Flag to indicate that this element must be deleted.

**In Reporting**

N - No corresponding reporting attribute.