Required attributes for the Microsoft Cloud for Sustainability data model
This article provides general notes about the Microsoft Cloud for Sustainability data model.
General rules
- The Name value must always be unique.
- The Origin Correlation ID value must be unique if it's specified. However, it isn't typically required.
Notation
The table that follows provides a partial list of the attributes in each entity. It includes only required attributes and attributes that influence the requirement of other attributes via logical dependency rules. The following notation is used in the "Required?" column:
| Notation | Meaning |
|---|---|
| Y | Required |
| N | Optional |
| <--<attribute> | Required only if <attribute> is specified |
| Y | <attribute>... | Required unless <attribute> is specified |
| Y <--<attribute> == <value> | Required if <attribute> contains <value> |
Entity/attribute rules
| Entity | Attribute | Required? |
|---|---|---|
| Accommodation type | Name | Y |
| Business Travel | Business travel type | Y |
| Consumption end date | Y | |
| Consumption start date | Y | |
| Cost | N | |
| Cost unit | <--Cost | |
| Data quality type | Y | |
| Distance | N | |
| Distance unit | <--Distance | |
| Fuel quantity | N | |
| Fuel quantity unit | <--Fuel quantity | |
| Fuel type | <--Fuel quantity | |
| Name | Y | |
| Night stay | N | |
| Night stay unit | <--Night stay | |
| Organizational unit | Y | |
| Quantity | N | |
| Quantity unit | <--Quantity | |
| Business travel type | Name | Y |
| Capital good | Cost | N |
| Cost unit | <--Cost | |
| Data quality type | Y | |
| Name | Y | |
| Organizational unit | Y | |
| Quantity | N | |
| Quantity unit | <--Quantity | |
| Spend type | Y | |
| Transaction date | Y | |
| Contractual instrument type | Energy source | Y |
| Name | Y | |
| Country/Region mapping | Country/Region | Y |
| Name | Y | |
| Disposal method | Name | Y |
| Emission | CH4 | N |
| CH4 unit | <--CH4 | |
| CO2 | N | |
| CO2 unit | <--CO2 | |
| CO2E | N | |
| CO2E (mt) | N | |
| CO2E unit | <--CO2E | |
| Consumption end date | Y | |
| Consumption start date | Y | |
| Emissions source | Y | |
| HFCs | N | |
| HFCs unit | <-- HFCs | |
| N2O | N | |
| N2O unit | <--N2O | |
| Name | Y | |
| NF3 | N | |
| NF3 unit | <--NF3 | |
| Organizational unit | Y | |
| Other GHGs | N | |
| Other GHGs unit | <--Other GHGs | |
| PFCs | N | |
| PFCs unit | <--PFCs | |
| SF6 | N | |
| SF6 unit | <--SF6 | |
| Emission factor | Biogenic CO2 factor | N |
| Biogenic CO2 factor unit | <--Biogenic CO2 factor | |
| CH4 | N | |
| CH4 unit | <--CH4 | |
| CO2 | N | |
| CO2 unit | <--CO2 | |
| CO2E | N | |
| CO2E unit | <--CO2E | |
| Factor library | Y | |
| Heat content | N | |
| Heat content unit | <--Heat content | |
| HFCs | N | |
| HFCs unit | <-- HFC | |
| N2O | N | |
| N2O unit | <--N2O | |
| Name | Y | |
| NF3 | N | |
| NF3 unit | <--NF3 | |
| Other GHGs | N | |
| Other GHGs unit | <--Other GHGs | |
| PFCs | N | |
| PFCs unit | <-- PFC | |
| SF6 | N | |
| SF6 unit | <--SF6 | |
| Unit | Y | |
| Emissions source | Name | Y |
| Scope | Y | |
| Estimation factor | Factor library | Y |
| Factor value | Y | |
| Factor value unit | <--Factor value | |
| Name | Y | |
| Unit | Y | |
| Facility | Address line 1 | Y |
| City | Y | |
| Country/Region | Y | |
| Name | Y | |
| ZIP/Postal Code | Y | |
| Facility type | Name | Y |
| Facility usage detail | Active period start | Y |
| Area | N | |
| Area unit | <--Area | |
| Active period end | Y | |
| Active period start | Y | |
| Facility | Y | |
| Leased or owned | Y | |
| Percent usage | Y | |
| Factor library | Library type | Y |
| Name | Y | |
| Type | Y | |
| Factor mapping | Factor | Y |
| Factor library | Y | |
| Name | Y | |
| Reference data | Y | |
| Fuel type | Name | Y |
| Fugitive emission | Cost | N |
| Cost unit | <--Cost | |
| Data quality type | Y | |
| Facility | Y | |
| Facility usage detail | <--Leased asset category | |
| Greenhouse gas | Y | |
| Name | Y | |
| Organizational unit | Y | |
| Quantity | Y | |
| Quantity unit | <--Quantity | |
| Transaction date | Y | |
| Greenhouse gas | Category | Y |
| GWP factor | Y | |
| Name | Y | |
| Industrial process | Consumption end date | Y |
| Consumption start date | Y | |
| Cost | N | |
| Cost unit | <--Cost | |
| Data quality type | Y | |
| Facility | Y | |
| Industrial process type | Y | |
| Name | Y | |
| Organizational unit | Y | |
| Quantity | Y | |
| Quantity unit | <--Quantity | |
| Industrial process type | Name | Y |
| Material | Name | Y |
| Mobile combustion | Consumption end date | Y |
| Consumption start date | Y | |
| Cost | N | |
| Cost unit | <--Cost | |
| Data quality type | Y | |
| Distance | Y | Fuel quantity | Quantity | |
| Distance unit | <--Distance | |
| Facility usage detail | <--Leased asset category | |
| Fuel quantity | Y | Distance | Quantity | |
| Fuel quantity unit | <--Fuel quantity | |
| Fuel type | <--Fuel quantity | |
| Name | Y | |
| Organizational unit | Y | |
| Quantity | Y | Fuel quantity | Distance | |
| Quantity unit | <--Quantity | |
| Vehicle type | Y | <--Distance | |
| Monthly revenue | Month | Y |
| Monthly revenue | Y | |
| Organizational unit | Y | |
| Revenue | Y | |
| Year | Y | |
| Organizational hierarchy | Effective start date | Y |
| Organizational unit | Y | |
| Parent | Y | |
| Organizational profile | Address line 1 | Y |
| City | Y | |
| Country/Region | Y | |
| Name | Y | |
| Postal code | Y | |
| Reporting start day | Y | |
| Reporting start month | Y | |
| State/Province | Y | |
| Organizational unit | Name | Y |
| Organizational unit type | Y | |
| Purchased energy | Consumption end date | Y |
| Consumption start date | Y | |
| Cost | N | |
| Cost unit | <--Cost | |
| Data quality type | Y | |
| Energy Provider Name | Y | |
| Energy Type | Y | |
| Facility | Y | |
| Facility usage detail | <--Leased asset category | |
| Is renewable | Y | |
| Name | Y | |
| Organizational unit | Y | |
| Quantity | Y | |
| Quantity unit | <--Quantity | |
| Purchased good and service | Cost | N |
| Cost unit | <--Cost | |
| Data quality type | Y | |
| Goods Quantity | N | |
| Goods unit | <--Goods Quantity | |
| Name | Y | |
| Organizational unit | Y | |
| Quantity | N | |
| Quantity unit | <--Quantity | |
| Spend type | Y | |
| Transaction date | Y | |
| Spend type | Emission source | Y |
| Name | Y | |
| Stationary combustion | Consumption end date | Y |
| Consumption start date | Y | |
| Cost | Y | Quantity | |
| Cost unit | <--Cost | |
| Data quality type | Y | |
| Facility | Y | |
| Facility usage detail | <--Leased asset category | |
| Fuel quantity | Y | |
| Fuel type | Y | |
| Name | Y | |
| Organizational unit | Y | |
| Quantity | Y | Cost | |
| Quantity unit | <--Quantity | |
| Transport mode | Is Shared Load (LTL) | Y |
| Name | Y | |
| Transportation and distribution | Cost | N |
| Cost unit | <--Cost | |
| Data quality type | Y | |
| Distance | N | |
| Distance unit | <--Distance | |
| Fuel quantity | N | |
| Fuel quantity unit | <--Fuel quantity | |
| Fuel type | <--Fuel quantity | |
| Goods quantity (mass) | N | |
| Goods quantity (mass) unit | <--Goods quantity (mass) | |
| Name | Y | |
| Organizational unit | Y | |
| Quantity | N | |
| Quantity unit | <--Quantity | |
| Transaction date | Y | |
| Transport mode | Y | |
| Transportation and distribution type | Y | |
| Unit | Conversion factor | Y <--Is base unit == true |
| Is base unit | Y | |
| Name | Y | |
| Unit group | Y | |
| Unit group | Name | Y |
| Value Chain Partner | Name | Y |
| Vehicle type | Is on-road | Y |
| Name | Y | |
| Waste generated in operations | Consumption end date | Y |
| Consumption start date | Y | |
| Cost | N | |
| Cost unit | <--Cost | |
| Data quality type | Y | |
| Disposal method | Y | |
| Distance | N | |
| Distance unit | <--Distance | |
| Fuel quantity | N | |
| Fuel quantity unit | <--Fuel quantity unit | |
| Material | Y | |
| Name | Y | |
| Organizational unit | Y | |
| Quantity | N | |
| Quantity unit | <--Quantity | |
| Waste quantity | Y | |
| Waste quantity unit | <--Waste quantity |
Additional constraints
Organizational unit type
The value must be one of the values from the following enumeration:
- Cost Center
- Department
- Division
- Group
- Team
- Unit
Factor library.type
The value must be one of the values from the following enumeration:
- Custom
- Demo
- Standard
Factor library.Library type
The value must be one of the values from the following enumeration:
- Estimation factor library
- Emission factor library
Data quality type
The value must be one of the values from the following enumeration:
- Actual
- Estimated
- Metered
Energy source
The value must be one of the values from the following enumeration:
- Nuclear
- Other
- Solar
- Water
- Wind
Energy type
The value must be one of the values from the following enumeration:
- Cooling
- Electricity
- Heating
- Steam
Greenhouse gas.category
The value must be one of the values from the following enumeration:
- Hydrofluorocarbons (HFC)
- Nitrogen Trifluoride (NF3)
- Non Fluorinated
- Perfluorocarbons (PFC)
- Sulfur hexafluoride (SF6)
Scope
The value must be one of the values from the following enumeration:
- Scope 1
- Scope 2
- Scope 3
Transportation and distribution.Transportation and distribution type
The value must be one of the values from the following enumeration:
- Downstream
- Upstream
See also
Microsoft Cloud for Sustainability data model Microsoft Cloud for Sustainability data model overview Record uniqueness in Microsoft Sustainability Manager