Plan
Attributes
Attribute Code |
Attribute Name |
SQL DB Data Type |
ReportNet3 Data Type |
Properties |
Code list |
Related table(s) |
In Reporting |
|---|---|---|---|---|---|---|---|
PLA_01 |
CountryCode |
varchar(2) |
string |
PK |
N |
||
PLA_03 |
PlanId |
varchar(100) |
string |
PK |
N |
||
PLA_06 |
PlanCategory |
varchar(20) |
string |
N |
|||
PLA_07 |
PlanTitle |
varchar(1000) |
string |
N |
|||
PLA_08 |
PlanAdoptionDate |
date |
date |
N |
|||
PLA_09 |
PlanBeginDate |
date |
date |
N |
|||
PLA_10 |
PlanEndDate |
date |
date |
N |
|||
PLA_11 |
PlanDocumentId |
varchar(150) |
string |
N |
|||
PLA_12 |
Deletion |
bit |
boolean |
N |
|||
PLA_13 |
Country |
varchar(50) |
string |
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
PLA_01 - CountryCode
Content
Country or territory ISO2 code.
In Reporting
N - No corresponding reporting table.
PLA_03 - PlanId
Content
Identifier of the air quality plan, given by data provider.
In Reporting
N - No corresponding reporting table.
PLA_06 - PlanCategory
Content
Category of the air quality plan (e.g., roadmap, short-term plan, plan).
In Reporting
N - No corresponding reporting table.
PLA_07 - PlanTitle
Content
Title of the plan
In Reporting
N - No corresponding reporting table.
PLA_08 - PlanAdoptionDate
Content
Date of official adoption of the plan by the responsible authorities
In Reporting
N - No corresponding reporting table.
PLA_09 - PlanBeginDate
Content
Start date (enforcement date) for the plan
In Reporting
N - No corresponding reporting table.
PLA_10 - PlanEndDate
Content
End date for the plan
In Reporting
N - No corresponding reporting table.
PLA_11 - PlanDocumentId
Content
Identifier of the air quality plan document given by data provider.
In Reporting
N - No corresponding reporting table.
PLA_12 - Deletion
Content
Flag to indicate that this element must be deleted.
In Reporting
N - No corresponding reporting table.
PLA_13 - Country
Content
Name of the country.
In Reporting
N - No corresponding reporting table.