ESRS Standards

Climate Change Emissions and Financial Summary(ClimateChgEmssnFincSummary)

• GOV-3 Percentage of Remuneration Linked to Climate Considerations (Gov3PctRemunLnkClimateCsdn)

Calculation

For Non-Aggregated Cases

Get ClimateChgEmssnFincSummary.GOV-3 Percentage of Remuneration Linked to Climate Considerations for the reporting year

For Aggregated Cases

Get ClimateChgEmssnFincSummary.GOV-3 Percentage of Remuneration Linked to Climate Considerations for the reporting year from all the ClimateChgEmssnFincSummary records corresponding to the accounts in hierarchy with parent company in this format:

% Value - AccountName

Example:

15.50% - Affiliate Account 1

20.30% - Subsidiary Account 2

15.50% - Parent Company

20.30% - Subsidiary Account 1

Input Fields

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• Operating Expenses (OpEx) for Climate Transition Plan (E1OpExpenseClimateTrnstPlan)

Calculation

Get ClimateChgEmssnFincSummary.Operating Expenses (OpEx) for Climate Transition Plan for the reporting year

Sum (Get ClimateChgEmssnFincSummary.Operating Expenses (OpEx) for Climate Transition Plan for the reporting year) for selected parent and its child records

Input Fields

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Capital Expenditure (CapEx) for Climate Transition Plan (E1CptlExpClimateTrnstPlan)

Calculation

Get ClimateChgEmssnFincSummary.E1 Capital Expenditure (CapEx) for Climate Transition Plan for the reporting year

Sum (Get ClimateChgEmssnFincSummary.E1 Capital Expenditure (CapEx) for Climate Transition Plan for the reporting year) for selected parent and its child records

Input Fields

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Capital Expenditure (CapEx) for Coal-Related Activities (E1CptlExpCoalRelatedActivities)

Calculation

Get ClimateChgEmssnFincSummary.E1 Capital Expenditure (CapEx) for Coal-Related Activities for the reporting year

Sum (Get ClimateChgEmssnFincSummary.E1 Capital Expenditure (CapEx) for Coal-Related Activities for the reporting year) for selected parent and its child records

Input Fields

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Capital Expenditure (CapEx) for Oil-Related Activities (E1CptlExpOilRelatedActivities)

Calculation

Get ClimateChgEmssnFincSummary.E1 Capital Expenditure (CapEx) for Oil-Related Activities for the reporting year

Sum (Get ClimateChgEmssnFincSummary.E1 Capital Expenditure (CapEx) for Oil-Related Activities for the reporting year) for selected parent and its child records

Input Fields

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Capital Expenditure (CapEx) for Gas-Related Activities (E1CptlExpGasRelatedActivities)

Calculation

Get ClimateChgEmssnFincSummary.E1 Capital Expenditure (CapEx) for Gas-Related Activities for the reporting year

Sum (Get ClimateChgEmssnFincSummary.E1 Capital Expenditure (CapEx) for Gas-Related Activities for the reporting year) for selected parent and its child records

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Transition Plan Adoption Date (E1DateAdoptionTransitionPlan)

Calculation

Get ClimateChgEmssnFincSummary.E1 Transition Plan Adoption Date for the reporting year

Get ClimateChgEmssnFincSummary.E1 Transition Plan Adoption Date from the selected parent for the reporting year

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 SBM-3 Resilience Analysis Date (E1Sbm3DateResilienceAnlys)

Calculation

Get ClimateChgEmssnFincSummary.E1 SBM-3 Resilience Analysis Date for the reporting year

Get ClimateChgEmssnFincSummary.E1 SBM-3 Resilience Analysis Date from the selected parent for the reporting year

Annual Emissions Inventory (AnnualEmssnInventory)

• Total Emissions (tCO2e) (TotalEmissions)
• Final Emissions (tCO2e) (FinalEmssnInTco2e)

• Year (Year)

Calculation

Get AnnualEmssnInventory.TotalEmissions where Year = Reporting year (current year)

Get AnnualEmssnInventory.TotalEmissions where Year = Base year

Achieved GHG emission reductions = Base year.TotalEmissions - Reporting Year.TotalEmissions

Get AnnualEmssnInventory.FinalEmssnInTco2e where Year = Reporting year (current year)

Get AnnualEmssnInventory.FinalEmssnInTco2e where Year = Base year

Achieved GHG emission reductions = Base year.FinalEmssnInTco2e - Reporting Year.FinalEmssnInTco2e

Input Fields

Emissions Activity (EmissionsActivity)

• Name (Name)
• Id

Emissions Reduction Target (EmssnReductionTarget)

• Id
• Target Year (TargetYear)
• Emissions Activity (EmissionsActivityId)
• Target Type (TargetType)

Annual Emissions Reduction Target (AnnualEmssnRdctnTarget)

• Target Emissions (tC02e) (TargetEmissions)
• Parent Target (ParentTargetId)
• Target Year (TargetYear)
• Last Modified Date (LastModifiedDate)

Annual Emissions Inventory (AnnualEmssnInventory)

• Total Emissions (tCO2e) (TotalEmissions)
• Final Emissions (tCO2e) (FinalEmssnInTco2e)
• Year (Year)

Disclosure Reporting Period (DisclsReportingPeriod)

• Identifier (Identifier)

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue to Calculate GHG Intensity (E1NetRevenueCalcGhgIntensity)
• Subsidiary Account (SubsidiaryAccountId)

Calculation

Get EmissionsActivity.Id where Name = ‘All Emissions’

Get EmssnReductionTarget.Id and EmssnReductionTarget.TargetYear where EmssnReductionTarget.EmissionsActivityId = EmissionsActivity.Id and EmssnReductionTarget.TargetType = 'EMISSIONREDUCTIONTARGET'

Get AnnualEmssnRdctnTarget.TargetEmissions where AnnualEmssnRdctnTarget.ParentTargetId = EmssnReductionTarget.Id and AnnualEmssnRdctnTarget.TargetYear = EmssnReductionTarget.TargetYear OrderBy AnnualEmssnRdctnTarget.LastModifiedDate DESC LIMIT 1

Select AnnualEmssnInventory.TotalEmissions where AnnualEmssnInventory.Year = Reporting year

Formula:

Expected GHG emission reductions = AnnualEmssnInventory.TotalEmissions - AnnualEmssnRdctnTarget.TargetEmissions

Select AnnualEmssnInventory.FinalEmssnInTco2e where AnnualEmssnInventory.Year = Reporting year

Formula:

Expected GHG emission reductions = AnnualEmssnInventory.FinalEmssnInTco2e - AnnualEmssnRdctnTarget.TargetEmissions

Emissions Activity (EmissionsActivity)

• Name (Name)
• Id

Emissions Reduction Target (EmssnReductionTarget)

• Id,
• Target Year (TargetYear)
• Emissions Activity (EmissionsActivityId)
• Target Type (TargetType)

Annual Emissions Reduction Target (AnnualEmssnRdctnTarget)

• Target Emissions (tC02e) (TargetEmissions)
• Parent Target (ParentTargetId)
• Target Year (TargetYear)
• Last Modified Date (LastModifiedDate)

Annual Emissions Inventory (AnnualEmssnInventory)

• Total Emissions (tCO2e) (TotalEmissions)
• Final Emissions (tCO2e) (FinalEmssnInTco2e)
• Year (Year)

Disclosure Reporting Period (DisclsReportingPeriod)

• Identifier (Identifier)

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue to Calculate GHG Intensity (E1NetRevenueCalcGhgIntensity)
• Subsidiary Account (SubsidiaryAccountId)
• Disclosure Reporting Period (DisclsReportingPeriodId)

Calculation

Get EmissionsActivity.Id where Name = 'All Emissions'

Get EmssnReductionTarget.Id, EmssnReductionTarget.TargetYear where EmssnReductionTarget.EmissionsActivityId = EmissionsActivity.Id and EmssnReductionTarget.TargetType = 'EMISSIONREDUCTIONTARGET'

Get AnnualEmssnRdctnTarget.TargetEmissions where AnnualEmssnRdctnTarget.ParentTargetId = EmssnReductionTarget.Id and AnnualEmssnRdctnTarget.TargetYear = EmssnReductionTarget.TargetYear OrderBy AnnualEmssnRdctnTarget.LastModifiedDate DESC LIMIT 1

Get AnnualEmssnInventory.TotalEmissions where AnnualEmssnInventory.Year = Base Year

Get ClimateChgEmssnFincSummary.E1NetRevenueCalcGhgIntensity where ClimateChgEmssnFincSummary.DisclsReportingPeriodId = DisclsReportingPeriod.Identifier and ClimateChgEmssnFincSummary.SubsidiaryAccount = SubsidiaryAccountId

Note: SubsidiaryAccount = AccountId filter is only applicable subsidiary account

Formula

Total GHG Emission Reduction Absolute Value = AnnualEmssnInventory.TotalEmissions - AnnualEmssnRdctnTarget.TargetEmissions

Get EmissionsActivity.Id where Name = 'All Emissions'

Get EmssnReductionTarget.Id, EmssnReductionTarget.TargetYear where EmssnReductionTarget.EmissionsActivityId = EmissionsActivity.Id and EmssnReductionTarget.TargetType = 'EMISSIONREDUCTIONTARGET'

Get AnnualEmssnRdctnTarget.TargetEmissions where AnnualEmssnRdctnTarget.ParentTargetId = EmssnReductionTarget.Id and AnnualEmssnRdctnTarget.TargetYear = EmssnReductionTarget.TargetYear OrderBy AnnualEmssnRdctnTarget.LastModifiedDate DESC LIMIT 1

Get AnnualEmssnInventory.FinalEmssnInTco2e where AnnualEmssnInventory.Year = Base Year

Get ClimateChgEmssnFincSummary.E1NetRevenueCalcGhgIntensity where ClimateChgEmssnFincSummary.DisclsReportingPeriodId = DisclsReportingPeriod.Identifier and ClimateChgEmssnFincSummary.SubsidiaryAccount = SubsidiaryAccountId

Note: SubsidiaryAccount = AccountId filter is only applicable subsidiary account

Formula

Total GHG Emission Reduction Absolute Value = AnnualEmssnInventory.FinalEmssnInTco2e - AnnualEmssnRdctnTarget.TargetEmissions

Total GHG Emission Reduction Perecentage of Base Year = (Total GHG Emission Reduction Absolute Value / AnnualEmssnInventory.TotalEmissions)*100

Total GHG Emission Reduction Perecentage of Base Year = (Total GHG Emission Reduction Absolute Value / AnnualEmssnInventory.FinalEmssnInTco2e)*100

Scope 1 Greenhouse gas emissions reduction

Emissions Activity (EmissionsActivity)

• Name (Name)
• Id

Emissions Reduction Target (EmssnReductionTarget)

• Id
• Target Year (TargetYear)
• Emissions Activity (EmissionsActivityId)
• Target Type (TargetType)

Annual Emissions Reduction Target (AnnualEmssnRdctnTarget)

• Target Emissions (tC02e) (TargetEmissions)
• Parent Target (ParentTargetId)
• Target Year (TargetYear)
• Last Modified Date (LastModifiedDate)

Annual Emissions Inventory (AnnualEmssnInventory)

• Final Scope 1 Emissions (tCO2e) (FinalScope1EmssnInTco2e)
• Total Scope 1 Emissions (tCO2e) (TotalScope1Emissions)
• Year (Year)

Disclosure Reporting Period (DisclsReportingPeriod)

• Identifier (Identifier)

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue to Calculate GHG Intensity (E1NetRevenueCalcGhgIntensity)
• Subsidiary Account (SubsidiaryAccountId)
• Disclosure Reporting Period (DisclsReportingPeriodId)

Calculation

Get EmissionsActivity.Id where Name = 'Scope 1'

Get EmssnReductionTarget.Id, EmssnReductionTarget.TargetYear where EmssnReductionTarget.EmissionsActivityId = EmissionsActivity.Id AND EmssnReductionTarget.TargetType = 'EMISSIONREDUCTIONTARGET'

Get AnnualEmssnRdctnTarget.TargetEmissions where AnnualEmssnRdctnTarget.ParentTargetId = EmssnReductionTarget.Id AND AnnualEmssnRdctnTarget.TargetYear = EmssnReductionTarget.TargetYear OrderBy AnnualEmssnRdctnTarget.LastModifiedDate DESC LIMIT 1

Get AnnualEmssnInventory.TotalScope1Emissions where AnnualEmssnInventory.Year = Base Year

Get ClimateChgEmssnFincSummary.E1NetRevenueCalcGhgIntensity where ClimateChgEmssnFincSummary.DisclsReportingPeriodId = DisclsReportingPeriod.Identifier and ClimateChgEmssnFincSummary.SubsidiaryAccount = SubsidiaryAccountId

Scope 1 GHG Emission Reduction Absolute Value = AnnualEmssnInventory.TotalScope1Emissions - AnnualEmssnRdctnTarget.TargetEmissions

Get EmissionsActivity.Id where Name = 'Scope 1'

Get EmssnReductionTarget.Id, EmssnReductionTarget.TargetYear where EmssnReductionTarget.EmissionsActivityId = EmissionsActivity.Id AND EmssnReductionTarget.TargetType = 'EMISSIONREDUCTIONTARGET'

Get AnnualEmssnRdctnTarget.TargetEmissions where AnnualEmssnRdctnTarget.ParentTargetId = EmssnReductionTarget.Id AND AnnualEmssnRdctnTarget.TargetYear = EmssnReductionTarget.TargetYear OrderBy AnnualEmssnRdctnTarget.LastModifiedDate DESC LIMIT 1

Get AnnualEmssnInventory.FinalScope1EmssnInTco2e where AnnualEmssnInventory.Year = Base Year

Get ClimateChgEmssnFincSummary.E1NetRevenueCalcGhgIntensity where ClimateChgEmssnFincSummary.DisclsReportingPeriodId = DisclsReportingPeriod.Identifier and ClimateChgEmssnFincSummary.SubsidiaryAccount = SubsidiaryAccountId

Scope 1 GHG Emission Reduction Absolute Value = AnnualEmssnInventory.FinalScope1EmssnInTco2e - AnnualEmssnRdctnTarget.TargetEmissions

Scope 1 GHG Emission Reduction Percentage of Base Year = (Scope 1 GHG Emission Reduction Absolute Value / AnnualEmssnInventory.TotalScope1Emissions)*100

Scope 1 GHG Emission Reduction Percentage of Base Year = (Scope 1 GHG Emission Reduction Absolute Value / AnnualEmssnInventory.FinalScope1EmssnInTco2e)*100

Emissions Activity (EmissionsActivity)

• Name (Name)
• Id

Emissions Reduction Target (EmssnReductionTarget)

• Id
• Target Year (TargetYear)
• Emissions Activity (EmissionsActivityId)
• Target Type (TargetType)

Annual Emissions Reduction Target (AnnualEmssnRdctnTarget)

• Target Emissions (tC02e) (TargetEmissions)
• Parent Target (ParentTargetId)
• Target Year (TargetYear)
• Last Modified Date (LastModifiedDate)

Annual Emissions Inventory (AnnualEmssnInventory)

• Total Scope 2 Location Based Emissions (TotScope2LocBasedEmssn)
• Allocated Scope 2 Location Based Emissions (tCO2e) (AllocScope2LocBasedEmssn)
• Year (Year)

Disclosure Reporting Period (DisclsReportingPeriod)

• Identifier (Identifier)

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue to Calculate GHG Intensity (E1NetRevenueCalcGhgIntensity)
• Subsidiary Account (SubsidiaryAccountId)
• Disclosure Reporting Period (DisclsReportingPeriodId)

Calculation

Get EmissionsActivity.Id where Name = 'Scope 2'

Get EmssnReductionTarget.Id, EmssnReductionTarget.TargetYear where EmssnReductionTarget.EmissionsActivityId = EmissionsActivity.Id AND EmssnReductionTarget.TargetType = 'EMISSIONREDUCTIONTARGET'

Get AnnualEmssnRdctnTarget.TargetEmissions where AnnualEmssnRdctnTarget.ParentTargetId = EmssnReductionTarget.Id AND AnnualEmssnRdctnTarget.TargetYear = EmssnReductionTarget.TargetYear OrderBy LastModifiedDate DESC LIMIT 1

Get AnnualEmssnInventory.TotScope2LocBasedEmssn, AnnualEmssnInventory.AllocScope2LocBasedEmssn where AnnualEmssnInventory.Year = Base Year

Get ClimateChgEmssnFincSummary.E1NetRevenueCalcGhgIntensity Where ClimateChgEmssnFincSummary.DisclsReportingPeriodId = DisclsReportingPeriod.Identifier and ClimateChgEmssnFincSummary.SubsidiaryAccount = SubsidiaryAccountId

Scope 2 Location-Based GHG Emission Reduction Absolute Value = AnnualEmssnInventory.TotScope2LocBasedEmssn - AnnualEmssnRdctnTarget.TargetEmissions

Scope 2 Location-Based GHG Emission Reduction Perecentage of Base Year = (Scope 2 Location-Based GHG Emission Reduction Absolute Value / (AnnualEmssnInventory.TotScope2LocBasedEmssn + AnnualEmssnInventory.AllocScope2LocBasedEmssn))*100

Get EmissionsActivity.Id where Name = 'Final Scope 2 Emissions'

Get EmssnReductionTarget.Id, EmssnReductionTarget.TargetYear where EmssnReductionTarget.EmissionsActivityId = EmissionsActivity.Id AND EmssnReductionTarget.TargetType = 'EMISSIONREDUCTIONTARGET'

Get AnnualEmssnRdctnTarget.TargetEmissions where AnnualEmssnRdctnTarget.ParentTargetId = EmssnReductionTarget.Id AND AnnualEmssnRdctnTarget.TargetYear = EmssnReductionTarget.TargetYear OrderBy LastModifiedDate DESC LIMIT 1

Get AnnualEmssnInventory.TotScope2LocBasedEmssn, AnnualEmssnInventory.AllocScope2LocBasedEmssn where AnnualEmssnInventory.Year = Base Year

Get ClimateChgEmssnFincSummary.E1NetRevenueCalcGhgIntensity Where ClimateChgEmssnFincSummary.DisclsReportingPeriodId = DisclsReportingPeriod.Identifier and ClimateChgEmssnFincSummary.SubsidiaryAccount = SubsidiaryAccountId

Scope 2 Location-Based GHG Emission Reduction Absolute Value = AnnualEmssnInventory.TotScope2LocBasedEmssn + AnnualEmssnInventory.AllocScope2LocBasedEmssn - AnnualEmssnRdctnTarget.TargetEmissions

Scope 2 Location-Based GHG Emission Reduction Perecentage of Base Year = (Scope 2 Location-Based GHG Emission Reduction Absolute Value / AnnualEmssnInventory.TotScope2LocBasedEmssn )*100

Scope 2 Location-Based GHG Emission Reduction Perecentage of Base Year = (Scope 2 Location-Based GHG Emission Reduction Absolute Value / (AnnualEmssnInventory.TotScope2LocBasedEmssn + AnnualEmssnInventory.AllocScope2LocBasedEmssn))*100

Emissions Activity (EmissionsActivity)

• Name (Name)
• Id

Emissions Reduction Target (EmssnReductionTarget)

• Id
• Target Year (TargetYear)
• Emissions Activity (EmissionsActivityId)
• Target Type (TargetType)

Annual Emissions Reduction Target (AnnualEmssnRdctnTarget)

• Target Emissions (tC02e) (TargetEmissions)
• Parent Target (ParentTargetId)
• Target Year (TargetYear)
• Last Modified Date (LastModifiedDate)

Annual Emissions Inventory (AnnualEmssnInventory)

• Total Scope 2 Market Based Emissions (TotScope2MarketBsdEmssn)
• Allocated Scope 2 Market Based Emissions (tCO2e) (AllocScope2MktBasedEmssn)
• Year (Year)

Disclosure Reporting Period (DisclsReportingPeriod)

• Identifier (Identifier)

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue to Calculate GHG Intensity (E1NetRevenueCalcGhgIntensity)
• Subsidiary Account (SubsidiaryAccountId)
• Disclosure Reporting Period (DisclsReportingPeriodId)

Calculation

For Aggregated Cases

Get EmissionsActivity.Id where Name = 'Final Scope 2 Market-based Emissions'

For Non-Aggregated Cases

Get EmissionsActivity.Id where Name = 'Scope 2 Market-based'

Get EmssnReductionTarget.Id, EmssnReductionTarget.TargetYear where EmssnReductionTarget.EmissionsActivityId = EmissionsActivity.Id AND EmssnReductionTarget.TargetType = 'EMISSIONREDUCTIONTARGET'

Get AnnualEmssnRdctnTarget.TargetEmissions where AnnualEmssnRdctnTarget.ParentTargetId = EmssnReductionTarget.Id AND AnnualEmssnRdctnTarget.TargetYear = EmssnReductionTarget.TargetYear OrderBy LastModifiedDate DESC LIMIT 1

Get AnnualEmssnInventory.TotScope2MarketBsdEmssn, AnnualEmssnInventory.AllocScope2MktBasedEmssn where AnnualEmssnInventory.Year = Base Year

Get ClimateChgEmssnFincSummary.E1NetRevenueCalcGhgIntensity Where ClimateChgEmssnFincSummary.DisclsReportingPeriodId = DisclsReportingPeriod.Identifier and ClimateChgEmssnFincSummary.SubsidiaryAccount = SubsidiaryAccountId

For Non-Aggregated Cases

Scope 2 Market-Based GHG Emission Reduction Absolute Value = AnnualEmssnInventory.TotScope2MarketBsdEmssn - AnnualEmssnRdctnTarget.TargetEmissions

For Aggregated Cases

Scope 2 Market-Based GHG Emission Reduction Absolute Value = AnnualEmssnInventory.TotScope2MarketBsdEmssn + AnnualEmssnInventory.AllocScope2MktBasedEmssn - AnnualEmssnRdctnTarget.TargetEmissions

For non-aggregate scenarios:-

Scope 2 Market-Based GHG Emission Reduction Percentage of Base Year = (Scope 2 Market-Based GHG Emission Reduction Absolute Value / (AnnualEmssnInventory.TotScope2MarketBsdEmssn)))*100

For aggregate scenarios:-

Scope 2 Market-Based GHG Emission Reduction Percentage of Base Year = (Scope 2 Market-Based GHG Emission Reduction Absolute Value / (AnnualEmssnInventory.TotScope2MarketBsdEmssn + AnnualEmssnInventory.AllocScope2MktBasedEmssn)))*100

For non-aggregate scenarios:-

Scope 2 Market-Based GHG Emission Reduction Intensity Value = Scope 2 Market-Based GHG Emission Reduction Absolute Value/ClimateChgEmssnFincSummary.E1NetRevenueCalcGhgIntensity

For aggregate scenarios:-

Scope 2 Market-Based GHG Emission Reduction Intensity Value = Scope 2 Market-Based GHG Emission Reduction Absolute Value/ClimateChgEmssnFincSummary.E1NetRevenueCalcGhgIntensity where ClimateChgEmssnFincSummary.E1NetRevenueCalcGhgIntensity will be summation of E1NetRevenueCalcGhgIntensity field value from all the ClimateChgEmssnFincSummary records corresponding to the accounts in hierarchy with parent company.

Emissions Activity (EmissionsActivity)

• Name (Name)
• Id

Emissions Reduction Target (EmssnReductionTarget)

Id,

• Target Year (TargetYear)
• Emissions Activity (EmissionsActivityId)
• Target Type (TargetType)

Annual Emissions Reduction Target (AnnualEmssnRdctnTarget)

• Target Emissions (tC02e) (TargetEmissions)
• Parent Target (ParentTargetId)
• Target Year (TargetYear)
• Last Modified Date (LastModifiedDate)

Annual Emissions Inventory (AnnualEmssnInventory)

• Final Scope 3 Emissions (tCO2e) (FinalScope3EmssnInTco2e)
• Total Scope 3 Emissions (tCO2e) (TotalScope3Emissions)
• Year (Year)

Disclosure Reporting Period (DisclsReportingPeriod)

• Identifier (Identifier)

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue to Calculate GHG IntensityE1NetRevenueCalcGhgIntensity
• Subsidiary Account (SubsidiaryAccountId)
• Disclosure Reporting Period (DisclsReportingPeriodId)

Calculation

For Non-Aggregated Cases

Get EmissionsActivity.Id where Name = 'Scope 3'

Get EmssnReductionTarget.Id, EmssnReductionTarget.TargetYear where EmssnReductionTarget.EmissionsActivityId = EmissionsActivity.Id and EmssnReductionTarget.TargetType = 'EMISSIONREDUCTIONTARGET'

Get AnnualEmssnRdctnTarget.TargetEmissions where AnnualEmssnRdctnTarget.ParentTargetId = EmssnReductionTarget.Id and AnnualEmssnRdctnTarget.TargetYear = EmssnReductionTarget.TargetYear OrderBy AnnualEmssnRdctnTarget.LastModifiedDate DESC LIMIT 1

Get AnnualEmssnInventory.TotalScope3Emissions where AnnualEmssnInventory.Year = Base Year

Get ClimateChgEmssnFincSummary.E1NetRevenueCalcGhgIntensity where ClimateChgEmssnFincSummary.DisclsReportingPeriodId = DisclsReportingPeriod.Identifier and ClimateChgEmssnFincSummary.SubsidiaryAccount = SubsidiaryAccountId

Scope 3 GHG Emission Reduction Absolute Value = AnnualEmssnInventory.TotalScope3Emissions - AnnualEmssnRdctnTarget.TargetEmissions

For Aggregated Cases

Get EmissionsActivity.Id where Name = 'Final Scope 3 Emissions'

Get EmssnReductionTarget.Id, EmssnReductionTarget.TargetYear where EmssnReductionTarget.EmissionsActivityId = EmissionsActivity.Id and EmssnReductionTarget.TargetType = 'EMISSIONREDUCTIONTARGET'

Get AnnualEmssnRdctnTarget.TargetEmissions where AnnualEmssnRdctnTarget.ParentTargetId = EmssnReductionTarget.Id and AnnualEmssnRdctnTarget.TargetYear = EmssnReductionTarget.TargetYear OrderBy AnnualEmssnRdctnTarget.LastModifiedDate DESC LIMIT 1

Get AnnualEmssnInventory.FinalScope3EmssnInTco2e where AnnualEmssnInventory.Year = Base Year

Get ClimateChgEmssnFincSummary.E1NetRevenueCalcGhgIntensity where ClimateChgEmssnFincSummary.DisclsReportingPeriodId = DisclsReportingPeriod.Identifier and ClimateChgEmssnFincSummary.SubsidiaryAccount = SubsidiaryAccountId

Scope 3 GHG Emission Reduction Absolute Value = AnnualEmssnInventory.FinalScope3EmssnInTco2e - AnnualEmssnRdctnTarget.TargetEmissions

For Non-Aggregated Cases

Scope 3 GHG Emission Reduction Perecentage of Base Year = (Scope 3 GHG Emission Reduction Absolute Value / AnnualEmssnInventory.TotalScope3Emissions)*100

For Aggregated Cases

Scope 3 GHG Emission Reduction Perecentage of Base Year = (Scope 3 GHG Emission Reduction Absolute Value / AnnualEmssnInventory.FinalScope3EmssnInTco2e)*100

Stationary Asset Carbon Footprint Item (StnryAssetCrbnFtprntItm)

• Fuel Type (FuelType)
• Total Energy Consumption (kWh) (TotalEnergyConsumptionInKwh)

Vehicle Asset Energy Use (VehicleAssetEnrgyUse)

• Total Fuel Consumption (US Gallons) (TotalFuelConsumptionInGal)
• Fuel Type (FuelType)

Calculation

For Non-Aggregated Cases

Get SUM of StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) for the selected account where the FuelType = Diesel || FuelType = Kerosene || FuelType = FuelOil || FuelType = Propane || FuelType = AutogasLPG || FuelType = HeavyOil || FuelType = LightOil || FuelType = Gasoline || FuelType = JetFuel for the previous year's carbon footprint's associated StnryAssetCrbnFtprntItm

Get SUM of VehicleAssetEnrgyUse.Total Fuel Consumption (US Gallons) for the selected account where the FuelType = Diesel || FuelType = AutogasLPG || FuelType = Gasoline || FuelType = JetFuel for the previous year's carbon footprint's associated StnryAssetCrbnFtprntItm

For Aggregated Cases

Get SUM of StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) for the parent and child accounts where the FuelType = Diesel || FuelType = Kerosene || FuelType = FuelOil || FuelType = Propane || FuelType = AutogasLPG || FuelType = HeavyOil || FuelType = LightOil || FuelType = Gasoline || FuelType = JetFuel for the previous year's carbon footprint's associated StnryAssetCrbnFtprntItm

Get SUM of VehicleAssetEnrgyUse.Total Fuel Consumption (US Gallons) for the parent and child accounts where the FuelType = Diesel || FuelType = AutogasLPG || FuelType = Gasoline || FuelType = JetFuel for the previous year's carbon footprint's associated StnryAssetCrbnFtprntItm

Convert StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) to Mwh

Example

Stationary Assets - 1430231.27 MWh

Vehicle Assets - 3344255.69 US Gallons

Stationary Asset Carbon Footprint Item (StnryAssetCrbnFtprntItm)

• Fuel Type (FuelType)
• Total Energy Consumption (kWh) (TotalEnergyConsumptionInKwh)

Vehicle Asset Energy Use (VehicleAssetEnrgyUse)

• Total Fuel Consumption (US Gallons) (TotalFuelConsumptionInGal)
• Fuel Type (FuelType)

Calculation

For Non-Aggregated Cases

Get SUM of StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) for the selected account where the FuelType = Diesel || FuelType = Kerosene || FuelType = FuelOil || FuelType = Propane || FuelType = AutogasLPG || FuelType = HeavyOil || FuelType = LightOil || FuelType = Gasoline || FuelType = JetFuel for the current year's carbon footprint's associated StnryAssetCrbnFtprntItm

Get SUM of VehicleAssetEnrgyUse.Total Fuel Consumption (US Gallons) for the selected account where the FuelType = Diesel || FuelType = AutogasLPG || FuelType = Gasoline || FuelType = JetFuel for the current year's carbon footprint's associated StnryAssetCrbnFtprntItm

For Aggregated Cases

Get SUM of StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) for the parent and child accounts where the FuelType = Diesel || FuelType = Kerosene || FuelType = FuelOil || FuelType = Propane || FuelType = AutogasLPG || FuelType = HeavyOil || FuelType = LightOil || FuelType = Gasoline || FuelType = JetFuel for the current year's carbon footprint's associated StnryAssetCrbnFtprntItm

Get SUM of VehicleAssetEnrgyUse.Total Fuel Consumption (US Gallons) for the parent and child accounts where the FuelType = Diesel || FuelType = AutogasLPG || FuelType = Gasoline || FuelType = JetFuel for the current year's carbon footprint's associated StnryAssetCrbnFtprntItm

Convert StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) to Mwh

Example

Stationary Assets - 661224.57 MWh

Vehicle Assets - 9.0 US Gallons

Stationary Asset Carbon Footprint Item (StnryAssetCrbnFtprntItm)

• Fuel Type (FuelType)
• Total Energy Consumption (kWh) (TotalEnergyConsumptionInKwh)

Vehicle Asset Energy Use (VehicleAssetEnrgyUse)

• Total Fuel Consumption (US Gallons) (TotalFuelConsumptionInGal)
• Fuel Type (FuelType)

Calculation

For Non-Aggregated Cases

Get SUM of StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) for the selected account where the FuelType = NaturalGas || FuelType = CityGas for the previous year's carbon footprint's associated StnryAssetCrbnFtprntItm

Get SUM of VehicleAssetEnrgyUse.Total Fuel Consumption (US Gallons) for the selected account where the FuelType = CompressedNaturalGasCNG for the previous year's carbon footprint's associated StnryAssetCrbnFtprntItm

For Aggregated Cases

Get SUM of StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) for the parent and child accounts where the FuelType = NaturalGas || FuelType = CityGas for the previous year's carbon footprint's associated StnryAssetCrbnFtprntItm

Get SUM of VehicleAssetEnrgyUse.Total Fuel Consumption (US Gallons) for the parent and child accounts where the FuelType = CompressedNaturalGasCNG for the previous year's carbon footprint's associated StnryAssetCrbnFtprntItm

Convert StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) to Mwh

Example

Stationary Assets - 1430231.27 MWh

Vehicle Assets - 3344255.69 US Gallons

Stationary Asset Carbon Footprint Item (StnryAssetCrbnFtprntItm)

• Fuel Type (FuelType)
• Total Energy Consumption (kWh) (TotalEnergyConsumptionInKwh)

Vehicle Asset Energy Use (VehicleAssetEnrgyUse)

• Total Fuel Consumption (US Gallons) (TotalFuelConsumptionInGal)
• Fuel Type (FuelType)

Calculation

For Non-Aggregated Cases

Get SUM of StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) for the selected account where the FuelType = NaturalGas || FuelType = CityGas for the current year's carbon footprint's associated StnryAssetCrbnFtprntItm

Get SUM of VehicleAssetEnrgyUse.Total Fuel Consumption (US Gallons) for the selected account where the FuelType = CompressedNaturalGasCNG for the current year's carbon footprint's associated StnryAssetCrbnFtprntItm

For Aggregated Cases

Get SUM of StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) for the parent and child accounts where the FuelType = NaturalGas || FuelType = CityGas for the current year's carbon footprint's associated StnryAssetCrbnFtprntItm

Get SUM of VehicleAssetEnrgyUse.Total Fuel Consumption (US Gallons) for the parent and child accounts where the FuelType = CompressedNaturalGasCNG for the current year's carbon footprint's associated StnryAssetCrbnFtprntItm

Convert StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) to Mwh

Example

Stationary Assets - 1430231.27 MWh

Vehicle Assets - 3344255.69 US Gallons

Stationary Asset Carbon Footprint Item (StnryAssetCrbnFtprntItm)

• Fuel Type (FuelType)
• Total Energy Consumption (kWh) (TotalEnergyConsumptionInKwh)

Vehicle Asset Energy Use (VehicleAssetEnrgyUse)

• Total Fuel Consumption (US Gallons) (TotalFuelConsumptionInGal)
• Fuel Type (FuelType)

Calculation

For Non-Aggregated Cases

Get SUM of StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) for the selected account where the FuelType = Propane for the previous year's carbon footprint's associated StnryAssetCrbnFtprntItm

For Aggregated Cases

Get SUM of StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) for the parent and child accounts where the FuelType = Propane for the previous year's carbon footprint's associated StnryAssetCrbnFtprntItm

Convert the value to Mwh

Stationary Asset Carbon Footprint Item (StnryAssetCrbnFtprntItm)

• Fuel Type (FuelType)
• Total Energy Consumption (kWh) (TotalEnergyConsumptionInKwh)

Vehicle Asset Energy Use (VehicleAssetEnrgyUse)

• Total Fuel Consumption (US Gallons) (TotalFuelConsumptionInGal)
• Fuel Type (FuelType)

Calculation

For Non-Aggregated Cases

Get SUM of StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) for the selected account where the FuelType = Propane for the current year's carbon footprint's associated StnryAssetCrbnFtprntItm

For Aggregated Cases

Get SUM of StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) for the parent and child accounts where the FuelType = Propane for the current year's carbon footprint's associated StnryAssetCrbnFtprntItm

Convert the value to Mwh

Stationary Asset Carbon Footprint Item (StnryAssetCrbnFtprntItm)

• Fuel Type (FuelType)
• Total Energy Consumption (kWh) (TotalEnergyConsumptionInKwh)

Stationary Asset Carbon Footprint (StnryAssetCrbnFtprnt)

• Total Renewable Energy (kWh) (TotalRenewableEnergyInKwh)

Vehicle Asset Energy Use (VehicleAssetEnrgyUse)

• Fuel Consumption (FuelConsumption)
• Fuel Type (FuelType)

Calculation

For Non-Aggregated Cases

Get SUM of StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) for the selected account where the FuelType = Steam || FuelType = Cooling || FuelType = Electricity || FuelType = Heat for the previous year's carbon footprint's associated StnryAssetCrbnFtprntItm - (SUM of StnryAssetCrbnFtprnt.Total Renewable Energy (kWh) of previous year)

Get SUM of VehicleAssetEnrgyUse.Fuel Consumption for the selected account where the FuelType = Electricity for the previous year

For Aggregated Cases

Get SUM of StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) for the parent and child accounts where the FuelType = Steam || FuelType = Cooling || FuelType = Electricity || FuelType = Heat for the previous year's carbon footprint's associated StnryAssetCrbnFtprntItm - (SUM of StnryAssetCrbnFtprnt.Total Renewable Energy (kWh) of previous year)

Get SUM of VehicleAssetEnrgyUse.Fuel Consumption for the parent and child accounts where the FuelType = Electricity for the previous year

Convert the values to Mwh

Example

Stationary Assets - 1430231.27 MWh

Vehicle Assets(Electricity) - 12.1 MWh

Stationary Asset Carbon Footprint Item (StnryAssetCrbnFtprntItm)

• Fuel Type (FuelType)
• Total Energy Consumption (kWh) (TotalEnergyConsumptionInKwh)

Stationary Asset Carbon Footprint (StnryAssetCrbnFtprnt)

• Total Renewable Energy (kWh) (TotalRenewableEnergyInKwh)

Vehicle Asset Energy Use (VehicleAssetEnrgyUse)

• Total Fuel Consumption (US Gallons) (TotalFuelConsumptionInGal)
• Fuel Type (FuelType)

Calculation

For Non-Aggregated Cases

Get SUM of StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) for the selected account where the FuelType = Steam || FuelType = Cooling || FuelType = Electricity || FuelType = Heat for the current year's carbon footprint's associated StnryAssetCrbnFtprntItm - (SUM of StnryAssetCrbnFtprnt.Total Renewable Energy (kWh) of previous year)

Get SUM of VehicleAssetEnrgyUse.Fuel Consumption for the selected account where the FuelType = Electricity for the current year

For Aggregated Cases

Get SUM of StnryAssetCrbnFtprntItm.Total Energy Consumption (kWh) for the parent and child accounts where the FuelType = Steam || FuelType = Cooling || FuelType = Electricity || FuelType = Heat for the current year's carbon footprint's associated StnryAssetCrbnFtprntItm - (SUM of StnryAssetCrbnFtprnt.Total Renewable Energy (kWh) of previous year)

Get SUM of VehicleAssetEnrgyUse.Fuel Consumption for the parent and child accounts where the FuelType = Electricityfor the current year

Convert the values to Mwh

Example

Stationary Assets - 1430231.27 MWh

Vehicle Assets(Electricity) - 12.1 MWh

Example

Stationary Assets - 1430231.27 MWh

Vehicle Assets - 3344255.69 US Gallons

Vehicle Assets(Electricity) - 1.23 MWh

Example

Stationary Assets - 1430231.27 MWh

Vehicle Assets - 3344255.69 US Gallons

Vehicle Assets(Electricity) - 1.23 MWh

Stationary Asset Carbon Footprint (StnryAssetCrbnFtprnt)

• Total Energy Consumption (MWh) (TotEnergyConsumptionInMwh)

Calculation

Get StnryAssetCrbnFtprnt.Total Energy Consumption (MWh) for the previous year

((6) Total fossil energy consumption (MWh)/StnryAssetCrbnFtprnt.Total Energy Consumption (MWh)

Stationary Asset Carbon Footprint (StnryAssetCrbnFtprnt)

• Total Energy Consumption (MWh) (TotEnergyConsumptionInMwh)

Calculation

Get StnryAssetCrbnFtprnt.Total Energy Consumption (MWh) for the current year

((6) Total fossil energy consumption (MWh)/StnryAssetCrbnFtprnt.Total Energy Consumption (MWh)

Stationary Asset Carbon Footprint (StnryAssetCrbnFtprnt)

• Location-Based Electricity from Nuclear (kWh) (LocBasedElectrFromNuclearInKwh)

Calculation

Get SUM of StnryAssetCrbnFtprnt.Location-Based Electricity from Nuclear (kWh) for the previous year

Convert the value to Mwh

Stationary Asset Carbon Footprint (StnryAssetCrbnFtprnt)

• Location-Based Electricity from Nuclear (kWh) (LocBasedElectrFromNuclearInKwh)

Calculation

Get SUM of StnryAssetCrbnFtprnt.Location-Based Electricity from Nuclear (kWh) for the current year

Convert the value to Mwh

Stationary Asset Carbon Footprint (StnryAssetCrbnFtprnt)

• Location-Based Electricity from Nuclear (kWh) (LocBasedElectrFromNuclearInKwh)
• Total Energy Consumption (MWh) (TotEnergyConsumptionInMwh)

Calculation

Get SUM of StnryAssetCrbnFtprnt.Location-Based Electricity from Nuclear (kWh) for the previous year

Convert the value to MWh

Get StnryAssetCrbnFtprnt.Total Energy Consumption (MWh) for the previous year

(StnryAssetCrbnFtprnt.Location-Based Electricity from Nuclear (kWh) converted to MWh / StnryAssetCrbnFtprnt.Total Energy Consumption (MWh)) * 100

Stationary Asset Carbon Footprint (StnryAssetCrbnFtprnt)

• Location-Based Electricity from Nuclear (kWh) (LocBasedElectrFromNuclearInKwh)
• Total Energy Consumption (MWh) (TotEnergyConsumptionInMwh)

Calculation

Get SUM of StnryAssetCrbnFtprnt.Location-Based Electricity from Nuclear (kWh) for the current year

Convert the value to MWh

Get StnryAssetCrbnFtprnt.Total Energy Consumption (MWh) for the current year

(StnryAssetCrbnFtprnt.Location-Based Electricity from Nuclear (kWh) converted to MWh / StnryAssetCrbnFtprnt.Total Energy Consumption (MWh)) * 100

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Fuel Consumption for Renewable Sources (MWh)(E1FuelCnsmpRenewableSrcBiomass)

Calculation

For Non-Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Fuel Consumption for Renewable Sources (MWh) for the selected account

For Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Fuel Consumption for Renewable Sources (MWh) corresponding to the accounts in hierarchy with parent company

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Fuel Consumption for Renewable Sources (MWh)(E1FuelCnsmpRenewableSrcBiomass)

Calculation

For Non-Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Fuel Consumption for Renewable Sources (MWh) for the selected account

For Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Fuel Consumption for Renewable Sources (MWh) corresponding to the accounts in hierarchy with parent company

Stationary Asset Carbon Footprint (StnryAssetCrbnFtprnt)

• Total Renewable Energy (kWh) (TotalRenewableEnergyInKwh)

Calculation

For Non-Aggregated Cases

Get SUM of StnryAssetCrbnFtprnt.Total Renewable Energy (kWh) for the previous year for the selected account

For Aggregated Cases

Get SUM of StnryAssetCrbnFtprnt.Total Renewable Energy (kWh) for the previous year corresponding to the accounts in hierarchy with parent company

Convert the value to MWh

Stationary Asset Carbon Footprint (StnryAssetCrbnFtprnt)

• Total Renewable Energy (kWh) (TotalRenewableEnergyInKwh)

Calculation

For Non-Aggregated Cases

Get SUM of StnryAssetCrbnFtprnt.Total Renewable Energy (kWh) for the current year for the selected account

For Aggregated Cases

Get SUM of StnryAssetCrbnFtprnt.Total Renewable Energy (kWh) for the current year corresponding to the accounts in hierarchy with parent company

Convert the value to MWh

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Self-Generated Non-Fuel Renewable Energy Consumption (MWh) (E1CnsmpSelfGenNonFuelEnrgy)

Calculation

For Non-Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Self-Generated Non-Fuel Renewable Energy Consumption (MWh) for selected account

For Aggregated Cases

Get SUM(ClimateChgEmssnFincSummary.E1 Self-Generated Non-Fuel Renewable Energy Consumption (MWh) for parent and child accounts)

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Self-Generated Non-Fuel Renewable Energy Consumption (MWh) (E1CnsmpSelfGenNonFuelEnrgy)

Calculation

For Non-Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Self-Generated Non-Fuel Renewable Energy Consumption (MWh) for selected account

For Aggregated Cases

Get SUM(ClimateChgEmssnFincSummary.E1 Self-Generated Non-Fuel Renewable Energy Consumption (MWh) for parent and child accounts)

Calculation

Sum of ((8) Fuel consumption for renewable sources, including biomass (also comprising industrial and municipal waste of biologic origin, biogas, renewable hydrogen, etc.) (MWh) + (9) Consumption of purchased or acquired electricity, heat, steam, and cooling from renewable sources (MWh) + (10) The consumption of self-generated non-fuel renewable energy (MWh))

Convert the value to MWh

Calculation

Sum of ((8) Fuel consumption for renewable sources, including biomass (also comprising industrial and municipal waste of biologic origin, biogas, renewable hydrogen, etc.) (MWh) + (9) Consumption of purchased or acquired electricity, heat, steam, and cooling from renewable sources (MWh) + (10) The consumption of self-generated non-fuel renewable energy (MWh))

Convert the value to MWh

Share of renewable sources in total energy consumption (%)

Stationary Asset Carbon Footprint (StnryAssetCrbnFtprnt)

• Total Renewable Energy (kWh) (TotalRenewableEnergyInKwh)
• Total Energy Consumption (MWh) (TotEnergyConsumptionInMwh)

Calculation

Get StnryAssetCrbnFtprnt.Total Energy Consumption (MWh) for the previous year

((9) Consumption of purchased or acquired electricity, heat, steam, and cooling from renewable sources (MWh) + Vehicle Assets(Electricity) from (5) Consumption of purchased or acquired electricity, heat, steam, and cooling from fossil sources (MWh)) /StnryAssetCrbnFtprnt.Total Energy Consumption (MWh)

Stationary Asset Carbon Footprint (StnryAssetCrbnFtprnt)

• Total Renewable Energy (kWh) (TotalRenewableEnergyInKwh)
• Total Energy Consumption (MWh) (TotEnergyConsumptionInMwh)

Calculation

Get SUM of StnryAssetCrbnFtprnt.Total Renewable Energy (kWh) for the current year

Convert the value to MWh

((9) Consumption of purchased or acquired electricity, heat, steam, and cooling from renewable sources (MWh) + Vehicle Assets(Electricity) from (5) Consumption of purchased or acquired electricity, heat, steam, and cooling from fossil sources (MWh)) /StnryAssetCrbnFtprnt.Total Energy Consumption (MWh)

Stationary Asset Carbon Footprint Item (StnryAssetCrbnFtprntItm)

• Fuel Type (FuelType)
• Total Energy Consumption (kWh) (TotalEnergyConsumptionInKwh)
• Stationary Asset Carbon Footprint (StnryAssetCrbnFtprnt)
• Total Energy Consumption (MWh) (TotEnergyConsumptionInMwh)
• Location-Based Electricity from Nuclear (kWh) (LocBasedElectrFromNuclearInKwh)

Calculation

Sum of ((6) Total fossil energy consumption (MWh) + (7) Consumption from nuclear sources (MWh) + (11) Total renewable energy consumption (MWh)) for the previous year

Example:

Stationary Assets - 2101047.19 MWh

Vehicle Assets - 3344255.69 US Gallons

Vehicle Assets(Electricity) - 0.00 MWh

Stationary Asset Carbon Footprint Item (StnryAssetCrbnFtprntItm)

• Fuel Type (FuelType)
• Total Energy Consumption (kWh) (TotalEnergyConsumptionInKwh)
• Stationary Asset Carbon Footprint (StnryAssetCrbnFtprnt)
• Total Energy Consumption (MWh) (TotEnergyConsumptionInMwh)
• Location-Based Electricity from Nuclear (kWh) (LocBasedElectrFromNuclearInKwh)

Calculation

Sum of ((6) Total fossil energy consumption (MWh) + (7) Consumption from nuclear sources (MWh) + (11) Total renewable energy consumption (MWh)) for the current year

Example:

Stationary Assets - 2101047.19 MWh

Vehicle Assets - 3344255.69 US Gallons

Vehicle Assets(Electricity) - 0.00 MWh

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue from High Climate Impact Sectors (E1NetRevHighClimateImpcSctr)

Calculation

For Non-Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Net Revenue from High Climate Impact Sectors for selected account for the previous year

For Aggregated Cases

Get SUM of ClimateChgEmssnFincSummary.E1 Net Revenue from High Climate Impact Sectors of accounts in hierarchy with parent company for the previous year

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue from High Climate Impact Sectors (E1NetRevHighClimateImpcSctr)

Calculation

Get ClimateChgEmssnFincSummary.E1 Net Revenue from High Climate Impact Sectors for the reporting year

ClimateChgEmssnFincSummary.E1 Net Revenue from High Climate Impact Sectors for the reporting year/ClimateChgEmssnFincSummary.E1 Net Revenue from High Climate Impact Sectors for the previous year

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue Non-High Climate Impact Sectors (E1NetRevNonHighClimateimpcSctr)

Calculation

For Non-Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Net Revenue Non-High Climate Impact Sectors for the previous year

For Aggregated Cases

Get SUM of ClimateChgEmssnFincSummary.E1 Net Revenue Non-High Climate Impact Sectors of the accounts in hierarchy with parent company for the previous year

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue Non-High Climate Impact Sectors (E1NetRevNonHighClimateimpcSctr)

Calculation

Get ClimateChgEmssnFincSummary.E1 Net Revenue Non-High Climate Impact Sectors for the reporting year

ClimateChgEmssnFincSummary.E1 Net Revenue Non-High Climate Impact Sectors for the reporting year/ClimateChgEmssnFincSummary.E1 Net Revenue Non-High Climate Impact Sectors for the previous year

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue from High Climate Impact Sectors(E1NetRevHighClimateImpcSctr)
• E1 Total Energy Consumption from High Climate Impact Sectors (MWh) (E1TotEnrgyCnsmpHighImpcSctr)

Calculation (For previous year)

For Non-Aggregated Cases

If ClimateChgEmssnFincSummary.E1 Net Revenue from High Climate Impact Sectors > 0, then ClimateChgEmssnFincSummary.E1 Net Revenue from High Climate Impact Sectors / ClimateChgEmssnFincSummary.E1 Total Energy Consumption from High Climate Impact Sectors (MWh)

Else 0

For Aggregated Cases

If ClimateChgEmssnFincSummary.E1 Net Revenue from High Climate Impact Sectors > 0, then SUM of ClimateChgEmssnFincSummary.E1 Net Revenue from High Climate Impact Sectors of the accounts in hierarchy with parent company/ SUM of ClimateChgEmssnFincSummary.E1 Total Energy Consumption from High Climate Impact Sectors (MWh) of the accounts in hierarchy with parent company

Else 0

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue from High Climate Impact Sectors(E1NetRevHighClimateImpcSctr)
• E1 Total Energy Consumption from High Climate Impact Sectors (MWh) (E1TotEnrgyCnsmpHighImpcSctr)

Calculation (For reporting year)

If ClimateChgEmssnFincSummary.E1 Net Revenue from High Climate Impact Sectors > 0, then ClimateChgEmssnFincSummary.E1 Net Revenue from High Climate Impact Sectors / ClimateChgEmssnFincSummary.E1 Total Energy Consumption from High Climate Impact Sectors (MWh)

Else 0

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Percentage of Scope 1 GHG Emissions from Regulated Emissions Trading Schemes (E1PctScp1GhgEmssnRegltTrdSchm)

Calculation

Get ClimateChgEmssnFincSummary.E1 Percentage of Scope 1 GHG Emissions from Regulated Emissions Trading Schemes for previous year

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Percentage of Scope 1 GHG Emissions from Regulated Emissions Trading Schemes (E1PctScp1GhgEmssnRegltTrdSchm)

Calculation

Get ClimateChgEmssnFincSummary.E1 Percentage of Scope 1 GHG Emissions from Regulated Emissions Trading Schemes for reporting year

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Percentage of Scope 1 GHG Emissions from Regulated Emissions Trading Schemes (E1PctScp1GhgEmssnRegltTrdSchm)

Calculation

If(ClimateChgEmssnFincSummary .E1 Percentage of Scope 1 GHG Emissions from Regulated Emissions Trading Schemes from previous year > 0, (ClimateChgEmssnFincSummary.E1 Percentage of Scope 1 GHG Emissions from Regulated Emissions Trading Schemes from reporting year / ClimateChgEmssnFincSummary.E1 Percentage of Scope 1 GHG Emissions from Regulated Emissions Trading Schemes from previous year)*100

Else

0

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Biogenic CO2 Emissions from Combustion or Biodegradation of Biomass Excluded from Scope 1 GHG Emissions (E1BiogenicCo2EmssnScp1GhgEmssn)

Calculation

Get ClimateChgEmssnFincSummary.E1 Biogenic CO2 Emissions from Combustion or Biodegradation of Biomass Excluded from Scope 1 GHG Emissions

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Biogenic CO2 Emissions from Combustion or Biodegradation of Biomass Excluded from Scope 2 GHG Emissions (E1BgnCo2EmssnBiomassNotScp2Ghg)

Calculation

Get ClimateChgEmssnFincSummary.E1 Biogenic CO2 Emissions from Combustion or Biodegradation of Biomass Excluded from Scope 2 GHG Emissions

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Biogenic CO2 Emissions from Combustion or Biodegradation of Biomass that Occur in Value Chain Excluded from Scope 3 GHG Emissions (E1BgnEmssnCo2BiomassNotScp3Ghg)

Calculation

Get ClimateChgEmssnFincSummary.E1 Biogenic CO2 Emissions from Combustion or Biodegradation of Biomass that Occur in Value Chain Excluded from Scope 3 GHG Emissions

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Percentage of Contractual Instruments to Calculate Scope 2 GHG Emissions (E1PctCntrInstrScope2GhgEmssn)

Calculation

Get ClimateChgEmssnFincSummary.E1 Percentage of Contractual Instruments to Calculate Scope 2 GHG Emissions

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Percentage of Contractual Instruments to Calculate Scope 2 GHG Emissions (E1PctCntrInstrScope2GhgEmssn)

Calculation

Get ClimateChgEmssnFincSummary.E1 Percentage of Contractual Instruments to Calculate Scope 2 GHG Emissions

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Percentage of Contractual Instruments Used for Sale and Purchase of Energy Bundled with Attributes About Energy Generation in Relation to Scope 2 GHG Emissions (E1PctCntrEnrgyGnrnScp2Emssn)

Calculation

Get ClimateChgEmssnFincSummary.E1 Percentage of Contractual Instruments Used for Sale and Purchase of Energy Bundled with Attributes About Energy Generation in Relation to Scope 2 GHG Emissions

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Percentage of Contractual Instruments Used for Sale and Purchase of Unbundled Energy Attribute Claims in Relation to Scope 2 GHG Emissions (E1PctCntrPurchEnrgyScp2Emssn)

Calculation

Get ClimateChgEmssnFincSummary.E1 Percentage of Contractual Instruments Used for Sale and Purchase of Unbundled Energy Attribute Claims in Relation to Scope 2 GHG Emissions

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Percentage of Scope 3 GHG Emissions Calculated Using Primary Data (E1PctGhgScp3CalcPrimaryData)

Calculation

Get ClimateChgEmssnFincSummary.E1 Percentage of Scope 3 GHG Emissions Calculated Using Primary Data

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue (E1NetRevenue)

Annual Emissions Inventory (AnnualEmssnInventory)

• Total Scope 1 Emissions (tCO2e) (TotalScope1Emissions)
• Total Scope 2 Location Based Emissions (TotScope2LocBasedEmssn)
• Total Scope 3 Emissions (tCO2e) (TotalScope3Emissions)

Calculation

If (ClimateChgEmssnFincSummary.E1 Net Revenue > 0 ) then (SUM of AnnualEmssnInventory.Total Scope 1 Emissions (tCO2e) + AnnualEmssnInventory.Total Scope 2 Location Based Emissions + AnnualEmssnInventory.Total Scope 3 Emissions (tCO2e)) for previous year / ClimateChgEmssnFincSummary.E1 Net Revenue)

Else 0

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue (E1NetRevenue)

Annual Emissions Inventory (AnnualEmssnInventory)

• Total Scope 1 Emissions (tCO2e) (TotalScope1Emissions)
• Total Scope 2 Location Based Emissions (TotScope2LocBasedEmssn)
• Total Scope 3 Emissions (tCO2e) (TotalScope3Emissions)

Calculation

If (ClimateChgEmssnFincSummary.E1 Net Revenue > 0 ) then (SUM of AnnualEmssnInventory.Total Scope 1 Emissions (tCO2e) + AnnualEmssnInventory.Total Scope 2 Location Based Emissions + AnnualEmssnInventory.Total Scope 3 Emissions (tCO2e)) for reporting year / ClimateChgEmssnFincSummary.E1 Net Revenue)

Else 0

Else 0

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue (E1NetRevenue)

Annual Emissions Inventory (AnnualEmssnInventory)

• Total Scope 1 Emissions (tCO2e) (TotalScope1Emissions)
• Total Scope 2 Market Based Emissions (TotScope2MarketBsdEmssn)
• Total Scope 3 Emissions (tCO2e) (TotalScope3Emissions)

Calculation

If (ClimateChgEmssnFincSummary.E1 Net Revenue > 0 ) then (SUM of AnnualEmssnInventory.Total Scope 1 Emissions (tCO2e) + AnnualEmssnInventory.Total Scope 2 Market Based Emissions + AnnualEmssnInventory.Total Scope 3 Emissions (tCO2e)) for previous year / ClimateChgEmssnFincSummary.E1 Net Revenue)

Else 0

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue (E1NetRevenue)

Annual Emissions Inventory (AnnualEmssnInventory)

• Total Scope 1 Emissions (tCO2e) (TotalScope1Emissions)
• Total Scope 2 Market Based Emissions (TotScope2MarketBsdEmssn)
• Total Scope 3 Emissions (tCO2e) (TotalScope3Emissions)

Calculation

If (ClimateChgEmssnFincSummary.E1 Net Revenue > 0 ) then (SUM of AnnualEmssnInventory.Total Scope 1 Emissions (tCO2e) + AnnualEmssnInventory.Total Scope 2 Market Based Emissions + AnnualEmssnInventory.Total Scope 3 Emissions (tCO2e)) for reporting year / ClimateChgEmssnFincSummary.E1 Net Revenue)

Else 0

Else 0

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue to Calculate GHG Intensity (E1NetRevenueCalcGhgIntensity)

Calculation

Get ClimateChgEmssnFincSummary.E1 Net Revenue to Calculate GHG Intensity from reporting year

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue Other Than to Calculate GHG Intensity (E1NetRevOthrCalcGhgIntensity)

Calculation

Get ClimateChgEmssnFincSummary.E1 Net Revenue Other Than to Calculate GHG Intensity from reporting year

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue (E1NetRevenue)

Calculation

Get ClimateChgEmssnFincSummary.E1 Net Revenue from reporting year

Carbon Credit Allocation (CrbnCreditAlloc)

• Total Carbon Credits Allocated (tCO2e) (TotalCrbnCrAllocInTco2e)
• Annual Emissions Inventory(AnnualEmssnInventoryId)

Calculation

For Aggregated Cases

Get CrbnCreditAlloc.Total Carbon Credits Allocated (tCO2e) for OmniForm selected CrbnCreditAlloc.Annual Emissions Inventory

For Non-Aggregated Cases

Get CrbnCreditAlloc.Total Carbon Credits Allocated (tCO2e) for CrbnCreditAlloc records with the matching CrbnCreditAlloc.Annual Emissions Inventory

Input Fields

Carbon Credit Project (CrbnCreditProject)

• Mitigation Type (MitigationType)

Sustainability Credit (SustainabilityCredit)

• Carbon Credit Project (CrbnCreditProjectId)

Carbon Credit Allocation (CrbnCreditAlloc)

• Total Carbon Credits Allocated (tCO2e) (TotalCrbnCrAllocInTco2e)
• Annual Emissions Inventory(AnnualEmssnInventoryId)
• Total Carbon Credits Allocated (tCO2e) (TotalCrbnCrAllocInTco2e)

Carbon Credit Distribution (CrbnCreditDistribution)

• Carbon Credit Allocation (CrbnCreditAllocId)
• Sustainability Credit (SustainabilityCreditId)
• Total Carbon Credits Allocated (tCO2e) (TotalCrbnCrAllocInTco2e)

Logic:

Get CrbnCreditProject where MitigationType = ‘Removal’

{

Get SustainabilityCredit records where Carbon Credit Project = CrbnCreditProject.ID

}

Get CrbnCreditAlloc where CrbnCreditAlloc.Annual Emissions Inventory.ID=OmniForm selected Annual Emissions Inventory.ID for the same reporting year

Get CrbnCreditDistribution where CrbnCreditDistribution.SustainabilityCreditId = SustainabilityCredit.ID and CrbnCreditDistribution.CrbnCreditAllocId = CrbnCreditAlloc.ID

For Non-Aggregated Cases

(SUM(CrbnCreditDistribution.Total Carbon Credits Allocated (tCO2e))/CrbnCreditAlloc.Total Carbon Credits Allocated (tCO2e))*100

For Aggregated Cases

(SUM(CrbnCreditDistribution.Total Carbon Credits Allocated (tCO2e))/CrbnCreditAlloc.Total Carbon Credits Allocated (tCO2e))*100 corresponding to the accounts in hierarchy with parent company in this format:

% Value - AccountName

15.50% - Affiliate Account 1

20.30% - Subsidiary Account 2

15.50% - Parent Company

20.30% - Subsidiary Account 1

Input Fields

Carbon Credit Project (CrbnCreditProject)

• Mitigation Type (MitigationType)

Sustainability Credit (SustainabilityCredit)

• Carbon Credit Project (CrbnCreditProjectId)

Carbon Credit Allocation (CrbnCreditAlloc)

• Total Carbon Credits Allocated (tCO2e) (TotalCrbnCrAllocInTco2e)
• Annual Emissions Inventory(AnnualEmssnInventoryId)
• Total Carbon Credits Allocated (tCO2e) (TotalCrbnCrAllocInTco2e)

Carbon Credit Distribution (CrbnCreditDistribution)

• Carbon Credit Allocation (CrbnCreditAllocId)
• Sustainability Credit (SustainabilityCreditId)
• Total Carbon Credits Allocated (tCO2e) (TotalCrbnCrAllocInTco2e)

Logic:

Get CrbnCreditProject where MitigationType = ‘Reduction’

{

Get SustainabilityCredit records where Carbon Credit Project = CrbnCreditProject.ID

}

Get CrbnCreditAlloc where CrbnCreditAlloc.Annual Emissions Inventory.ID=OmniForm selected Annual Emissions Inventory.ID for the same reporting year

Get CrbnCreditDistribution where CrbnCreditDistribution.SustainabilityCreditId = SustainabilityCredit.ID and CrbnCreditDistribution.CrbnCreditAllocId = CrbnCreditAlloc.ID

For Non-Aggregated Cases

(SUM(CrbnCreditDistribution.Total Carbon Credits Allocated (tCO2e))/CrbnCreditAlloc.Total Carbon Credits Allocated (tCO2e))*100

For Aggregated Cases

Get CrbnCreditDistribution where CrbnCreditDistribution.SustainabilityCreditId = SustainabilityCredit.ID and CrbnCreditDistribution.CrbnCreditAllocId = CrbnCreditAlloc.ID corresponding to the accounts in hierarchy with parent company in this format:

% Value - AccountName

15.50% - Affiliate Account 1

20.30% - Subsidiary Account 2

15.50% - Parent Company

20.30% - Subsidiary Account 1

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Percentage of Carbon Credits Issued from Projects in European Union (E1PctCrbnCrProjEuropeanUnion)

Calculation

For Non-Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Percentage of Carbon Credits Issued from Projects in European Union from previous year

For Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Percentage of Carbon Credits Issued from Projects in European Union from previous year corresponding to the accounts in hierarchy with parent company in this format:

% Value - AccountName

15.50% - Affiliate Account 1

20.30% - Subsidiary Account 2

15.50% - Parent Company

20.30% - Subsidiary Account 1

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Percentage of Carbon Credits Issued from Projects in European Union (E1PctCrbnCrProjEuropeanUnion)

Calculation

Get ClimateChgEmssnFincSummary.E1 Percentage of Carbon Credits Issued from Projects in European Union from reporting year

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Percentage of Carbon Credits That Qualifies as Corresponding Adjustment (E1PctCrbnCrQualCoresAdjustment)

Calculation

For Non-Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Percentage of Carbon Credits That Qualifies as Corresponding Adjustment from previous year

For Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Percentage of Carbon Credits That Qualifies as Corresponding Adjustment from previous year corresponding to the accounts in hierarchy with parent company in this format:

% Value - AccountName

15.50% - Affiliate Account 1

20.30% - Subsidiary Account 2

15.50% - Parent Company

20.30% - Subsidiary Account 1

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Percentage of Carbon Credits That Qualifies as Corresponding Adjustment (E1PctCrbnCrQualCoresAdjustment)

Calculation

Get ClimateChgEmssnFincSummary.E1 Percentage of Carbon Credits That Qualifies as Corresponding Adjustment from reporting year

Carbon Credit Project (CrbnCreditProject)

• Total Carbon Credits Available (tCO2e) (TotalCrbnCrAvlInTco2e)

Calculation

Sum of CrbnCreditProject.Total Carbon Credits Available (tCO2e)

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Carbon Price Applied for Each Metric Tonne of GHG Emissions (E1CrbnPriceMetricTonneGhgEmssn)

Calculation

For Non-Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Carbon Price Applied for Each Metric Tonne of GHG Emissions from reporting year

For Aggregated Cases

Get SUM of ClimateChgEmssnFincSummary.E1 Carbon Price Applied for Each Metric Tonne of GHG Emissions from reporting year corresponding to the accounts in hierarchy with parent company

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Percentage of Gross Scope 1 GHG Emissions Covered by Internal Carbon Pricing Scheme (E1PctScp1GhgEmssnIntrCrbnPrc)

Calculation

For Non-Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Percentage of Gross Scope 1 GHG Emissions Covered by Internal Carbon Pricing Scheme from reporting year

For Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Percentage of Gross Scope 1 GHG Emissions Covered by Internal Carbon Pricing Scheme from reporting year corresponding to the accounts in hierarchy with parent company in this format:

% Value - AccountName

Example:

15.50% - Affiliate Account 1

20.30% - Subsidiary Account 2

15.50% - Parent Company

20.30% - Subsidiary Account 1

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Percentage of Gross Scope 2 GHG Emissions Covered by Internal Carbon Pricing Scheme (E1PctScp2GhgEmssnIntrCrbnPrc)

Calculation

For Non-Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Percentage of Gross Scope 2 GHG Emissions Covered by Internal Carbon Pricing Scheme from reporting year

For Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Percentage of Gross Scope 2 GHG Emissions Covered by Internal Carbon Pricing Scheme from reporting year corresponding to the accounts in hierarchy with parent company in this format:

% Value - AccountName

Example:

15.50% - Affiliate Account 1

20.30% - Subsidiary Account 2

15.50% - Parent Company

20.30% - Subsidiary Account 1

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Percentage of Gross Scope 3 GHG Emissions Covered by Internal Carbon Pricing Scheme (E1PctScp3GhgEmssnIntrCrbnPrc)

Calculation

For Non-Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Percentage of Gross Scope 3 GHG Emissions Covered by Internal Carbon Pricing Scheme from reporting year

For Aggregated Cases

Get ClimateChgEmssnFincSummary.E1 Percentage of Gross Scope 3 GHG Emissions Covered by Internal Carbon Pricing Scheme from reporting year corresponding to the accounts in hierarchy with parent company in this format:

% Value - AccountName

Example:

15.50% - Affiliate Account 1

20.30% - Subsidiary Account 2

15.50% - Parent Company

20.30% - Subsidiary Account 1

Climate Change Risk Opportunity Summary (ClimateChgRiskOppSummary)

• E1 Number of Assets at Material Physical Risk Before Climate Change Adaptation Actions (E1AstMtrlPhyRiskClimateChg)

Calculation

For Non-Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Number of Assets at Material Physical Risk Before Climate Change Adaptation Actions

For Aggregated Cases

Get SUM of ClimateChgRiskOppSummary.E1 Number of Assets at Material Physical Risk Before Climate Change Adaptation Actions corresponding to the accounts in hierarchy with parent company

Climate Change Risk Opportunity Summary (ClimateChgRiskOppSummary)

• E1 Number of Assets at Acute Material Physical Risk Before Climate Change Adaptation Actions (E1AstAcutMtrlPhyRiskClimateChg)

Calculation

For Non-Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Number of Assets at Acute Material Physical Risk Before Climate Change Adaptation Actions

For Aggregated Cases

Get SUM of ClimateChgRiskOppSummary.E1 Number of Assets at Acute Material Physical Risk Before Climate Change Adaptation Actions corresponding to the accounts in hierarchy with parent company

Climate Change Risk Opportunity Summary (ClimateChgRiskOppSummary)

• E1 Number of Assets at Chronic Material Physical Risk Before Climate Change Adaptation Actions (E1AstChrncMtrlPhyRiskClimate)

Calculation

For Non-Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Number of Assets at Chronic Material Physical Risk Before Climate Change Adaptation Actions

For Aggregated Cases

Get SUM of ClimateChgRiskOppSummary.E1 Number of Assets at Chronic Material Physical Risk Before Climate Change Adaptation Actions corresponding to the accounts in hierarchy with parent company

Climate Change Risk Opportunity Summary (ClimateChgRiskOppSummary)

• E1 Percentage of Assets at Material Physical Risk Before Climate Change Adaptation Actions (E1PctAstMtrlRiskBefClimateChg)

Calculation

For Non-Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Percentage of Assets at Material Physical Risk Before Climate Change Adaptation Actions

For Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Percentage of Assets at Material Physical Risk Before Climate Change Adaptation Actions corresponding to the accounts in hierarchy with parent company in this format:

% Value - AccountName

Example:

15.50% - Affiliate Account 1

20.30% - Subsidiary Account 2

15.50% - Parent Company

20.30% - Subsidiary Account 1

Climate Change Risk Opportunity Summary (ClimateChgRiskOppSummary)

• E1 Percentage of Assets at Material Physical Risk Addressed by Climate Change Adaptation Actions (E1PctAstMtrlPhyRiskClimateChg)

Calculation

For Non-Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Percentage of Assets at Material Physical Risk Addressed by Climate Change Adaptation Actions

For Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Percentage of Assets at Material Physical Risk Addressed by Climate Change Adaptation Actions corresponding to the accounts in hierarchy with parent company in this format:

% Value - AccountName

Example:

15.50% - Affiliate Account 1

20.30% - Subsidiary Account 2

15.50% - Parent Company

20.30% - Subsidiary Account 1

Climate Change Risk Opportunity Summary (ClimateChgRiskOppSummary)

• E1 Net Revenue from Business Activities at Material Physical Risk (E1NetRevBusActvMtrlPhyRisk)

Calculation

For Non-Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Net Revenue from Business Activities at Material Physical Risk

For Aggregated Cases

Get SUM of ClimateChgRiskOppSummary.E1 Net Revenue from Business Activities at Material Physical Risk corresponding to the accounts in hierarchy with parent company

Climate Change Risk Opportunity Summary (ClimateChgRiskOppSummary)

• E1 Percentage of Net Revenue from Business Activities at Material Physical Risk (E1PctNetRevBusActvMtrlPhyRisk)

Calculation

For Non-Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Percentage of Net Revenue from Business Activities at Material Physical Risk

For Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Percentage of Net Revenue from Business Activities at Material Physical Risk corresponding to the accounts in hierarchy with parent company in this format:

% Value - AccountName

Example:

15.50% - Affiliate Account 1

20.30% - Subsidiary Account 2

15.50% - Parent Company

20.30% - Subsidiary Account 1

Climate Change Risk Opportunity Summary (ClimateChgRiskOppSummary)

• E1 Number of Assets at Material Transition Risk Before Climate Mitigation Actions (E1AstMtrlTrnstRiskBefMitgAct)

Calculation

For Non-Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Number of Assets at Material Transition Risk Before Climate Mitigation Actions

For Aggregated Cases

Get SUM of ClimateChgRiskOppSummary.E1 Number of Assets at Material Transition Risk Before Climate Mitigation Actions corresponding to the accounts in hierarchy with parent company

Climate Change Risk Opportunity Summary (ClimateChgRiskOppSummary)

• E1 Percentage of Assets at Material Transition Risk Before Climate Mitigation Actions (E1PctAstMtrlTrnstRiskBefMitg)

Calculation

For Non-Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Percentage of Assets at Material Transition Risk Before Climate Mitigation Actions

For Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Percentage of Assets at Material Transition Risk Before Climate Mitigation Actions corresponding to the accounts in hierarchy with parent company in this format:

% Value - AccountName

Example:

15.50% - Affiliate Account 1

20.30% - Subsidiary Account 2

15.50% - Parent Company

20.30% - Subsidiary Account 1

Climate Change Risk Opportunity Summary (ClimateChgRiskOppSummary)

• E1 Percentage of Assets at Material Transition Risk Addressed by Climate Change Mitigation Actions (E1PctAstMtrlTrnstRiskAddrMitg)

Calculation

For Non-Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Percentage of Assets at Material Transition Risk Addressed by Climate Change Mitigation Actions

For Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Percentage of Assets at Material Transition Risk Addressed by Climate Change Mitigation Actions corresponding to the accounts in hierarchy with parent company in this format:

% Value - AccountName

Example:

15.50% - Affiliate Account 1

20.30% - Subsidiary Account 2

15.50% - Parent Company

20.30% - Subsidiary Account 1

Climate Change Risk Opportunity Summary (ClimateChgRiskOppSummary)

• E1 Total Amount of Real Estate Assets by Energy Efficiency Classes (E1CarrValRealEstAstEnrgyEfcy)

Calculation

For Non-Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Total Amount of Real Estate Assets by Energy Efficiency Classes

For Aggregated Cases

Get SUM of ClimateChgRiskOppSummary.E1 Total Amount of Real Estate Assets by Energy Efficiency Classes corresponding to the accounts in hierarchy with parent company

Climate Change Risk Opportunity Summary (ClimateChgRiskOppSummary)

• E1 Estimated Amount of Potentially Stranded Assets (E1EstmtAmtPotStrandedAssets)

Calculation

For Non-Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Estimated Amount of Potentially Stranded Assets

For Aggregated Cases

Get SUM of ClimateChgRiskOppSummary.E1 Estimated Amount of Potentially Stranded Assets corresponding to the accounts in hierarchy with parent company

Climate Change Risk Opportunity Summary (ClimateChgRiskOppSummary)

• E1 Percentage of Potentially Stranded Assets at Material Transition Risk (E1PctStrandedAstMtrlTranstRisk)

Calculation

For Non-Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Percentage of Potentially Stranded Assets at Material Transition Risk

For Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Percentage of Potentially Stranded Assets at Material Transition Risk corresponding to the accounts in hierarchy with parent company in this format:

% Value - AccountName

Example:

15.50% - Affiliate Account 1

20.30% - Subsidiary Account 2

15.50% - Parent Company

20.30% - Subsidiary Account 1

Climate Change Risk Opportunity Summary (ClimateChgRiskOppSummary)

• E1 Total Carrying Amount of Real Estate Assets with Internal Energy Consumption Estimates (E1TotalAmountRealEstateAssets)

Calculation

For Non-Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Total Carrying Amount of Real Estate Assets with Internal Energy Consumption Estimates

For Aggregated Cases

Get SUM of ClimateChgRiskOppSummary.E1 Total Carrying Amount of Real Estate Assets with Internal Energy Consumption Estimates corresponding to the accounts in hierarchy with parent company

Climate Change Risk Opportunity Summary (ClimateChgRiskOppSummary)

• E1 Material Transition Risk Liabilities Recognized in Financial Statements (E1LiabMtrlTrnstRisksFinclStmt)

Calculation

For Non-Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Material Transition Risk Liabilities Recognized in Financial Statements

For Aggregated Cases

Get SUM of ClimateChgRiskOppSummary.E1 Material Transition Risk Liabilities Recognized in Financial Statements corresponding to the accounts in hierarchy with parent company

Climate Change Risk Opportunity Summary (ClimateChgRiskOppSummary)

• E1 Number of Scope 1 GHG Emissions Allowances Within Regulated Emission Trading Schemes (E1NbrScp1GhgEmssnTrdSchemes)

Calculation

For Non-Aggregated Cases

Get ClimateChgRiskOppSummary.E1 Number of Scope 1 GHG Emissions Allowances Within Regulated Emission Trading Schemes

For Aggregated Cases

Get SUM of ClimateChgRiskOppSummary.E1 Number of Scope 1 GHG Emissions Allowances Within Regulated Emission Trading Schemes corresponding to the accounts in hierarchy with parent company

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Emissions To Air by Pollutant (tCO2e) (E2EmissionsAirPollutant)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Emissions To Air by Pollutant (tCO2e)

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Emissions To Water by Pollutant (tCO2e) (E2EmissionsWaterPollutant)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Emissions To Water by Pollutant (tCO2e)

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Emissions To Soil by Pollutant (tCO2e) (E2EmissionsSoilPollutant)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Emissions To Soil by Pollutant (tCO2e)

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Percentage of Total Emissions of Pollutants To Water in Areas at Water Risk (E2PctEmssnPolutWtrAreaWtrRisk)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Percentage of Total Emissions of Pollutants To Water in Areas at Water Risk

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Percentage of Total Emissions of Pollutants To Water in Areas of High-Water Stress (E2PctEmssnPolutWtrAreaWtrStrss)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Percentage of Total Emissions of Pollutants To Water in Areas of High-Water Stress

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Percentage of Total Emissions of Pollutants To Soil in Areas at Water Risk (E2PctEmssnPolutSoilWtrRisk)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Percentage of Total Emissions of Pollutants To Soil in Areas at Water Risk

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Percentage of Total Emissions of Pollutants To Soil in Areas of High-Water Stress (E2PctEmssnPolutSoilWtrStrss)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Percentage of Total Emissions of Pollutants To Soil in Areas of High-Water Stress

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Total Amount of Substances of Concern Generated, Used During Production, or Procured Broken Down by Main Hazard Classes of Substances of Concern (E2AmountSbstncCncrnHazardCls)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Total Amount of Substances of Concern Generated, Used During Production, or Procured Broken Down by Main Hazard Classes of Substances of Concern

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Total Amount of Substances of Concern Generated, Used During Production, or Procured (E2AmountSbstncCncrnProcured)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Total Amount of Substances of Concern Generated, Used During Production, or Procured

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Total Amount of Substances of Concern That Leave Facilities as Emissions, Products, or Part of Products or Services (E2AmtSbstncCncrnEmssnPrdct)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Total Amount of Substances of Concern That Leave Facilities as Emissions, Products, or Part of Products or Services

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Amount of Substances of Concern that Leave Facilities as Emissions by Main Hazard Classes of Substances of Concern (E2AmtSbstncCncrnEmssnHazardCls)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Amount of Substances of Concern that Leave Facilities as Emissions by Main Hazard Classes of Substances of Concern

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Amount of Substances of Concern That Leave Facilities as Products by Main Hazard Classes of Substances of Concern (E2AmtSbstncCncrnPrdctHazardCls)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Amount of Substances of Concern That Leave Facilities as Products by Main Hazard Classes of Substances of Concern

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Amount of Substances of Concern That Leave Facilities as Part of Products by Main Hazard Classes of Substances of Concern (E2AmtSbstncCncrnPartPrdctHzrd)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Amount of Substances of Concern That Leave Facilities as Part of Products by Main Hazard Classes of Substances of Concern

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Amount of Substances of Concern That Leave Facilities as Services by Main Hazard Classes of Substances of Concern (E2AmtSbstncCncrnSrvcsHazardCls)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Amount of Substances of Concern That Leave Facilities as Services by Main Hazard Classes of Substances of Concern

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Total Amount of Substances of Very High Concern That Are Generated or Used During Production or Procured by Main Hazard Classes of Substances of Concern (E2TotSbstncHighCncrnGenHzrdCls)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Total Amount of Substances of Very High Concern That Are Generated or Used During Production or Procured by Main Hazard Classes of Substances of Concern

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Total Amount of Substances of Very High Concern That Leave Facilities as Emissions, Products, or Part of Products or Services by Main Hazard Classes of Substances of Concern (E2TotSbstncHighCncrnPrdctHzrd)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Total Amount of Substances of Very High Concern That Leave Facilities as Emissions, Products, or Part of Products or Services by Main Hazard Classes of Substances of Concern

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Amount of Substances of Very High Concern That Leave Facilities as Emissions by Main Hazard Classes of Substances of Concern (E2AmtSbstncHighCncrnEmssnHzrd)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Amount of Substances of Very High Concern That Leave Facilities as Emissions by Main Hazard Classes of Substances of Concern

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Amount of Substances of Very High Concern That Leave Facilities as Products by Main Hazard Classes of Substances of Concern (E2AmtSbstncHighCncrnPrdctHzrd)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Amount of Substances of Very High Concern That Leave Facilities as Products by Main Hazard Classes of Substances of Concern

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Amount of Substances of Very High Concern That Leave Facilities as Part of Products by Main Hazard Classes of Substances of Concern (E2AmtSbstncHighCncrnPartHzrd)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Amount of Substances of Very High Concern That Leave Facilities as Part of Products by Main Hazard Classes of Substances of Concern

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Amount of Substances of Very High Concern That Leave Facilities as Services by Main Hazard Classes of Substances of Concern (E2AmtSbstncHighCncrnSrvcsHzrd)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Amount of Substances of Very High Concern That Leave Facilities as Services by Main Hazard Classes of Substances of Concern

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Anticipated Financial Effect of Material Risks and Opportunities Arising from Pollution-Related Impacts (E2AntcpFinclEffMaterialRisks)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Anticipated Financial Effect of Material Risks and Opportunities Arising from Pollution-Related Impacts

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Operating Expenditure (OpEx) Incurred in Conjunction with Major Incidents and Deposits (Pollution) (E2OpExpIncidentsDeposits)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Operating Expenditure (OpEx) Incurred in Conjunction with Major Incidents and Deposits (Pollution)

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Capital Expenditure (CapEx) Incurred in Conjunction with Major Incidents and Deposits (Pollution) (E2CptlExpIncidentsDeposits)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Capital Expenditure (CapEx) Incurred in Conjunction with Major Incidents and Deposits (Pollution)

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Provisions for Environmental Protection and Remediation Costs (Pollution) (E2PrvsnEnvrPrtcRemediationCost)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Provisions for Environmental Protection and Remediation Costs (Pollution)

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Percentage of Net Revenue from Products and Services Containing Substances of Concern (E2PctNetRevSrvcsSbstncCncrn)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Percentage of Net Revenue from Products and Services Containing Substances of Concern

Input Fields

Pollution Impact Risk Opportunity Summary (PltnImpactRiskOppSummary)

• E2 Percentage of Net Revenue from Products and Services Containing Substances of Very High Concern (E2PctNetRevSvcSbstncHighCncrn)

Calculation

SUM of PltnImpactRiskOppSummary.E2 Percentage of Net Revenue from Products and Services Containing Substances of Very High Concern

Input Fields

Stationary Asset Water Footprint (StnryAssetWaterFtprnt)

• Total Consumption (Ml) (TotalConsumptionInMl)

Calculation

(SUM of StnryAssetWaterFtprnt.Total Consumption (Ml) * 1000.0

Input Fields

Stationary Asset Water Activity (StnryAssetWaterActvty)

• Quantity (m3) (QuantityInM3)

• Reporting Year (ReportingYear)

• Start Date (StartDate)

• End Date (EndDate)

Environmental Risk (EnvironmentalRisk)

• Baseline Stress (BaselineStress)

Stationary Asset Environmental Source (StnryAssetEnvrSrc)

Calculation

SUM of StnryAssetWaterActvty.Quantity (m3) Where EnvironmentalRisk.Baseline Stress = 'High' AND (...footprint filter)

For StnryAssetWaterActvty, the filtering of the records that match the reporting year: StnryAssetWaterActvty.Reporting Year = report year OR StnryAssetWaterActvty.Start Date within report year range, OR StnryAssetWaterActvty.End Date within report year range.

For StnryAssetWaterActvty, the filtering of the records that match the accounts included in the report: StnryAssetEnvrSrc.Account

Input Fields

Stationary Asset Water Activity (StnryAssetWaterActvty)

• Quantity (m3) (QuantityInM3)

• Activity Source Type (ActivitySourceType)

• Reporting Year (ReportingYear)

• Start Date (StartDate)

• End Date (EndDate)

Calculation

SUM of StnryAssetWaterActvty.Quantity (m3) WHERE StnryAssetWaterActvty.Activity Source Type IN ('Recycled Water', 'Reused Water') AND StnryAssetWaterActvty.Activity Type = 'Consumption' AND (...footprint filter)

For StnryAssetWaterActvty, the filtering of the records that match the reporting year: StnryAssetWaterActvty.Reporting Year = report year OR StnryAssetWaterActvty.Start Date within report year range, OR StnryAssetWaterActvty.End Date within report year range.

For StnryAssetWaterActvty, the filtering of the records that match the accounts included in the report: StnryAssetEnvrSrc.Account

Input Fields

Stationary Asset Water Footprint (StnryAssetWaterFtprnt)

• Total Storage (Ml) (TotalStorageInMl)

Calculation

SUM of StnryAssetWaterFtprnt.Total Storage (Ml) * 1000.0

Input Fields

Stationary Asset Water Footprint (StnryAssetWaterFtprnt)

• Total Storage (Ml) (TotalStorageInMl)

• Total Storage During Previous Year (m3) (TotalStorageDuringPreviousYear)

Calculation

(1000.0 * (SUM of StnryAssetWaterFtprnt.Total Storage (Ml)) - (SUM of StnryAssetWaterFtprnt.Total Storage During Previous Year (m3))

Input Fields

Stationary Asset Water Activity (StnryAssetWaterActvty)

• Quantity (m3) (QuantityInM3)

• Activity Type (ActivityType)

• Water Data Measurement (WaterDataMeasurement)

Calculation

Direct Quantity = (SUM of StnryAssetWaterActvty.Quantity (m3) WHERE StnryAssetWaterActvty.Activity Type = 'Consumption' AND StnryAssetWaterActvty.Water Data Measurement IN ('DirectMeasurement', 'BestEstimate', 'SamplingAndExtrapolation') AND (...footprint filter))

Total Quantity = (SUM of StnryAssetWaterActvty.Quantity (m3) WHERE StnryAssetWaterActvty.Activity Type = 'Consumption' AND (...footprint filter))

Result = Direct Quantity / Total Quantity (or 0 if either are missing)

For StnryAssetWaterActvty, the filtering of the records that match the reporting year: StnryAssetWaterActvty.Reporting Year = report year OR StnryAssetWaterActvty.Start Date within report year range, OR StnryAssetWaterActvty.End Date within report year range.

For StnryAssetWaterActvty, the filtering of the records that match the accounts included in the report: StnryAssetEnvrSrc.Account

Input Fields

Stationary Asset Water Footprint (StnryAssetWaterFtprnt)

• Total Consumption (Ml) (TotalConsumptionInMl)

Climate Change Emissions and Financial Summary (ClimateChgEmssnFincSummary)

• E1 Net Revenue to Calculate GHG Intensity (E1NetRevenueCalcGhgIntensity)

Calculation

(1000.0 * (SUM of StnryAssetWaterFtprnt.Total Consumption (Ml)) / (SUM of ClimateChgEmssnFincSummary.E1 Net Revenue to Calculate GHG Intensity)

Input Fields

Stationary Asset Water Footprint (StnryAssetWaterFtprnt)

• Total Discharge (Ml) (TotalDischargeInMl)

Calculation

1000.0 * (SUM of StnryAssetWaterFtprnt.Total Discharge (Ml))

Input Fields

Biodiversity Summary (BiodiversitySummary)

• E4 Direct and Indirect Costs of Biodiversity Offsets (E4DirIdirCostsBiodiversityOfst)

Calculation

BiodiversitySummary.E4 Direct and Indirect Costs of Biodiversity Offsets

Input Fields

Biodiversity Summary (BiodiversitySummary)

• E4 Number of Sites Owned, Leased, or Managed In or Near Protected Areas That the Company is Negatively Affecting (E4NbrSiteOwnLsdMngPrtcAreas)

Calculation

BiodiversitySummary.E4 Number of Sites Owned, Leased, or Managed In or Near Protected Areas That the Company is Negatively Affecting

Input Fields

Biodiversity Summary (BiodiversitySummary)

• E4 Area of Sites Owned, Leased, or Managed In or Near Protected Areas or Key Biodiversity Areas That the Company is Negatively Affecting (E4NbrSiteOwnLsdMngBiodiversity)

Calculation

BiodiversitySummary.E4 Area of Sites Owned, Leased, or Managed In or Near Protected Areas or Key Biodiversity Areas That the Company is Negatively Affecting

Input Fields

Biodiversity Summary (BiodiversitySummary)

• E4 Total Use of Land (E4TotalUseLand)

Calculation

BiodiversitySummary.E4 Total Use of Land

Input Fields

Biodiversity Summary (BiodiversitySummary)

• E4 Total Sealed Area (E4TotalSealedArea)

Calculation

BiodiversitySummary.E4 Total Sealed Area

Input Fields

Biodiversity Summary (BiodiversitySummary)

• E4 Nature-Oriented Area on Site (E4NatureOrientedAreaOnSite)

Calculation

BiodiversitySummary.E4 Nature-Oriented Area on Site

Input Fields

Biodiversity Summary (BiodiversitySummary)

• E4 Nature-Oriented Area Off Site (E4NatureOrientedAreaOffSite)

Calculation

BiodiversitySummary.E4 Nature-Oriented Area Off Site

Input Fields

Biodiversity Summary (BiodiversitySummary)

• E4 Number of Invasive Alien Species (E4NumberInvasiveAlienSpecies)

Calculation

BiodiversitySummary.E4 Number of Invasive Alien Species

Input Fields

Biodiversity Summary (BiodiversitySummary)

• E4 Area Covered by Invasive Alien Species (E4AreaCvInvasiveAlienSpecies)

Calculation

BiodiversitySummary.E4 Area Covered by Invasive Alien Species

Input Fields

Biodiversity Summary (BiodiversitySummary)

• E4 Anticipated Financial Effects Due to Material Risks and Opportunities Arising from Biodiversity and Ecosystem-Related Impacts and Dependencies (E4AntcpFinclEffMaterialRisks)

Calculation

BiodiversitySummary.E4 Anticipated Financial Effects Due to Material Risks and Opportunities Arising from Biodiversity and Ecosystem-Related Impacts and Dependencies

Input Fields

Sustainability Material Use Summary (SustnMaterialUseSummary)

• E5 Total Weight of Products and Technical and Biological Materials Used (in Kg) (E5WtPrdctTechBiolMaterials)

Calculation

SUM of SustnMaterialUseSummary.E5 Total Weight of Products and Technical and Biological Materials Used (in Kg)

Input Fields

Sustainability Material Use Summary (​​SustnMaterialUseSummary)

• E5 Percentage of Biological Materials and Biofuels Used for Non-Energy Purposes (E5PctBiologicalMaterials)

Calculation

SUM of SustnMaterialUseSummary.E5 Percentage of Biological Materials and Biofuels Used for Non-Energy Purposes

Input Fields

Sustainability Material Use Summary (​​SustnMaterialUseSummary)

• E5 Absolute Weight of Secondary Reused or Recycled Components, Secondary Intermediary Products, and Secondary Materials Used to Manufacture the Company's Products and Services Including Packaging (Kg) (E5WtScndReusedRecycComponents)

Calculation

SUM of ​​SustnMaterialUseSummary.E5 Absolute Weight of Secondary Reused or Recycled Components, Secondary Intermediary Products, and Secondary Materials Used to Manufacture the Company's Products and Services Including Packaging (Kg)

Input Fields

Sustainability Material Use Summary (SustnMaterialUseSummary)

• E5 Percentage of Secondary Reused or Recycled Components, Secondary Intermediary Products, and Secondary Materials (E5PctWtScndReusedRecycCmpnt)

Calculation

SUM of SustnMaterialUseSummary.E5 Percentage of Secondary Reused or Recycled Components, Secondary Intermediary Products, and Secondary Materials

Input Fields

Sustainability Material Use Summary (SustnMaterialUseSummary)

• E5 Rate of Recyclable Content in Products (E5RateRecyclableCntntProducts)

Calculation

SUM of SustnMaterialUseSummary.E5 Rate of Recyclable Content in Products

Input Fields

Sustainability Material Use Summary (SustnMaterialUseSummary)

• E5 Rate of Recyclable Content in Product Packaging (E5RtRecyclableCntntPrdctPkg)

Calculation

SUM of SustnMaterialUseSummary.E5 Rate of Recyclable Content in Product Packaging

Input Fields

Waste Footprint (WasteFootprint)

• Total Waste Quantity in Tonnes (TotalWasteQuantityinTonnes)

• Reporting Year (ReportingYear)

• Start Date (StartDate)

• End Date (EndDate)

Calculation

SUM of WasteFootprint.Total Waste Quantity in Tonnes

For WasteFootprint, the filtering of the records that match the reporting year: WasteFootprint.Reporting Year = report year OR WasteFootprint.Start Date within report year range, OR WasteFootprint.End Date within report year range.

For WasteFootprint, the filtering of the records that match the accounts included in the report: StnryAssetEnvrSrc.Account

Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

• Disposal Type (DisposalType)

Calculation

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = TRUE AND GeneratedWaste.Disposal Type IN (‘Recycled’, ‘Preparation for Reuse’, ‘Other Recovery Operations’)

​Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

• Disposal Type (DisposalType)

Calculation

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = FALSE AND GeneratedWaste.Disposal Type IN (‘Recycled’, ‘Preparation for Reuse’, ‘Other Recovery Operations’)

​{Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

• Disposal Type (DisposalType)

​Calculation:

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = TRUE AND GeneratedWaste.Disposal Type = ‘Recycled’

​{Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

• Disposal Type (DisposalType)

​Calculation:

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = FALSE AND GeneratedWaste.Disposal Type = ‘Recycled’

​Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

• Disposal Type (DisposalType)

​Calculation:

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = TRUE AND GeneratedWaste.Disposal Type = ‘Preparation for Reuse’

​{Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

• Disposal Type (DisposalType)

​Calculation:

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = FALSE AND GeneratedWaste.Disposal Type = ‘Preparation for Reuse’

​Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

• Disposal Type (DisposalType)

Calculation

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = TRUE AND GeneratedWaste.Disposal Type = ‘Other Recovery Operations’

​{Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

• Disposal Type (DisposalType)

​Calculation:

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = FALSE AND GeneratedWaste.Disposal Type = ‘Other Recovery Operations’

​{Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

• Disposal Type (DisposalType)

​Calculation:

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = TRUE AND GeneratedWaste.Disposal Type IN (‘Combustion’, ‘Landfilled’, ‘Other Disposal Operations’)

​Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

• Disposal Type (DisposalType)

Calculation

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = FALSE AND GeneratedWaste.Disposal Type IN (‘Combustion’, ‘Landfilled’, ‘Other Disposal Operations’)

​{Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

• Disposal Type (DisposalType)

​Calculation:

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = TRUE AND GeneratedWaste.Disposal Type = ‘‘Combustion’

​{Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

• Disposal Type (DisposalType)

​Calculation:

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = FALSE AND GeneratedWaste.Disposal Type = ‘‘Combustion’

​{Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

• Disposal Type (DisposalType)

​Calculation:

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = TRUE AND GeneratedWaste.Disposal Type = ‘Landfilled’

​{Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

• Disposal Type (DisposalType)

​Calculation:

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = FALSE AND GeneratedWaste.Disposal Type = ‘Landfilled’

​{Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

• Disposal Type (DisposalType)

​Calculation:

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = TRUE AND GeneratedWaste.Disposal Type = ‘Other Disposal Operations’

​{Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

• Disposal Type (DisposalType)

Calculation

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = FALSE AND GeneratedWaste.Disposal Type = ‘Other Disposal Operations’

Input Fields

Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Hazardous (IsHazardous)

Calculation

SUM of Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Hazardous = TRUE

Input Fields

Generated Waste (GeneratedWaste)

• Disposed Waste Quantity in Tonnes (DisposedWasteQuantityinTonnes)

• Radioactive (IsRadioactive)

Calculation

SUM of GeneratedWaste.Disposed Waste Quantity in Tonnes WHERE GeneratedWaste.Radioactive = TRUE

Input Fields

Sustainability Material Use Summary (SustnMaterialUseSummary)

• E5 Anticipated Financial Effects of Material Risks and Opportunities from Resource Use and Circular Economy-Related Impacts (E5AntcpFinclEffMaterialRisks)

Calculation

SUM of SustnMaterialUseSummary.E5 Anticipated Financial Effects of Material Risks and Opportunities from Resource Use and Circular Economy-Related Impacts

Employee Demographic Summary (EmployeeDemographicSum)

• Gender (Gender)
• Employee Count (EmployeeCount)
• Report Type (ReportType)
• Employment Type (EmploymentType)

Calculation

Get EmployeeDemographicSum.Gender and SUM(EmployeeDemographicSum.EmployeeCount) where EmployeeDemographicSum.ReportType='Headcount' and EmployeeDemographicSum.EmploymentType not in ('Non-Employee or Self-Employed', 'Provided By Undertakings') group by EmployeeDemographicSum.Gender

Employee Demographic Summary (EmployeeDemographicSum)

• Employee Count (EmployeeCount)
• Report Type (ReportType)
• Employment Type (EmploymentType)

Calculation

Get SUM(EmployeeDemographicSum.EmployeeCount) where EmployeeDemographicSum.ReportType='Headcount' and EmployeeDemographicSum.EmploymentType not in ('Non-Employee or Self-Employed', 'Provided By Undertakings')

Employee Demographic Summary (EmployeeDemographicSum)

• Gender (Gender)
• Employee Count (EmployeeCount)
• Report Type (ReportType)
• Employment Type (EmploymentType)

Calculation

Get EmployeeDemographicSum.Gender and SUM(EmployeeDemographicSum.EmployeeCount) where EmployeeDemographicSum.ReportType='Headcount' and EmployeeDemographicSum.EmploymentType not in ('Non-Employee or Self-Employed', 'Provided By Undertakings') group by EmployeeDemographicSum.Gender

Employee Demographic Summary (EmployeeDemographicSum)

• Gender (Gender)
• Employee Count (EmployeeCount)
• Report Type (ReportType)
• Employment Type (EmploymentType)

Calculation

Get EmployeeDemographicSum.Gender, EmployeeDemographicSum.EmploymentType, and SUM(EmployeeDemographicSum.EmployeeCount) where EmployeeDemographicSum.ReportType='Headcount' and EmployeeDemographicSum.EmploymentType not in ('Non-Employee or Self-Employed', 'Provided By Undertakings') group by EmployeeDemographicSum.Gender and EmployeeDemographicSum.EmploymentType

Employee Demographic Summary (EmployeeDemographicSum)

• Employee Count (EmployeeCount)
• Report Type (ReportType)
• Employment Type (EmploymentType)
• Region (Region)

Calculation

Get EmployeeDemographicSum.EmploymentType, EmployeeDemographicSum. Region, and SUM(EmployeeDemographicSum.EmployeeCount) where EmployeeDemographicSum.ReportType='Headcount' and EmployeeDemographicSum.EmploymentType not in ('Non-Employee or Self-Employed', 'Provided By Undertakings') group by EmployeeDemographicSum.EmploymentType and EmployeeDemographicSum.Region

Employee Demographic Summary (EmployeeDemographicSum)

• Employee Count (EmployeeCount)
• Report Type (ReportType)
• Employment Type (EmploymentType)
• Gender(Gender)
• Region (Region)

Calculation

Get EmployeeDemographicSum.EmploymentType, EmployeeDemographicSum.Region, EmployeeDemographicSum.Gender, and SUM(EmployeeDemographicSum.EmployeeCount) where EmployeeDemographicSum.ReportType='Headcount' and EmployeeDemographicSum.EmploymentType not in ('Non-Employee or Self-Employed', 'Provided By Undertakings') group by EmployeeDemographicSum.EmploymentType, EmployeeDemographicSum.Gender, and EmployeeDemographicSum.Region

Employee Demographic Summary (EmployeeDemographicSum)

• Employee Count (EmployeeCount)
• Report Type (ReportType)
• Employment Type (EmploymentType)

Calculation

Get EmployeeDemographicSum.EmploymentType and SUM(EmployeeDemographicSum.EmployeeCount) where EmployeeDemographicSum.ReportType='Headcount' and EmployeeDemographicSum.EmploymentType not in ('Non-Employee or Self-Employed', 'Provided By Undertakings') group by EmployeeDemographicSum.EmploymentType

Employee Demographic Summary (EmployeeDemographicSum)

• Employee Count (EmployeeCount)
• Report Type (ReportType)
• Employment Type (EmploymentType)

Calculation

Get SUM(EmployeeDemographicSum.EmployeeCount) where EmployeeDemographicSum.ReportType='Headcount' and EmployeeDemographicSum.EmploymentType not in ('Non-Employee or Self-Employed', 'Provided By Undertakings')

Iceland - 8

Italy - 11

India - 10

United Kingdom - 30

Diversity Equity Inclusion Summary (DivrsEquityInclSum)

• Diversity Type (DiversityType)
• Employee Count (EmployeeCount)

Calculation

Get Sum(DivrsEquityInclSum.EmployeeCount) where DivrsEquityInclSum.DiversityType=’Ability’

Diversity Equity Inclusion Summary (DivrsEquityInclSum)

• Diversity Type (DiversityType)
• Employee Percentage (EmployeePercentage)

Calculation

Get Sum(DivrsEquityInclSum.EmployeePercentage) where DivrsEquityInclSum.DiversityType=’Ability’

Employee Development Summary (EmployeeDevelopmentSum)

• Employee Count (EmployeeCount)
• Employee Percentage (EmployeePercentage)
• Employee Type (EmployeeType)
• Gender (Gender)
• Program Category (ProgramCategory)

Calculation

Get EmployeeDevelopmentSum.ProgramCategory, EmployeeDevelopmentSum.Gender, SUM(EmployeeDevelopmentSum.EmployeeCount), SUM(EmployeeDevelopmentSum.EmployeePercentage)

where EmployeeDevelopmentSum.ProgramCategory = 'Training'

And EmployeeDevelopmentSum.EmployeeType NOT IN ('Non-Employee or Self-Employed', 'Provided By Undertakings')

And EmployeeDevelopmentSum.Gender != null

GROUP BY EmployeeDevelopmentSum.ProgramCategory, EmployeeDevelopmentSum.Gender

Employee Development Summary (EmployeeDevelopmentSum)

• Employee Count (EmployeeCount)
• Employee Type (EmployeeType)
• Gender (Gender)
• Program Category (ProgramCategory)

Calculation

Get SUM(EmployeeDevelopmentSum.EmployeeCount) where EmployeeDevelopmentSum.ProgramCategory = 'Training'

And EmployeeDevelopmentSum.EmployeeType NOT IN ('Non-Employee or Self-Employed', 'Provided By Undertakings')

And EmployeeDevelopmentSum.Gender != null

Employee Development Summary (EmployeeDevelopmentSum)

• Employee Percentage (EmployeePercentage)
• Employee Type (EmployeeType)
• Gender (Gender)
• Program Category (ProgramCategory)

Calculation

Get SUM(EmployeeDevelopmentSum.EmployeePercentage) where EmployeeDevelopmentSum.ProgramCategory = 'Training'

And EmployeeDevelopmentSum.EmployeeType NOT IN ('Non-Employee or Self-Employed', 'Provided By Undertakings')

And EmployeeDevelopmentSum.Gender != null

Employee Development Summary (EmployeeDevelopmentSum)

• Employee Count (EmployeeCount)
• Employee Percentage (EmployeePercentage)
• Employee Type (EmployeeType)
• Gender (Gender)
• Program Category (ProgramCategory)

Calculation

Get EmployeeDevelopmentSum.ProgramCategory, EmployeeDevelopmentSum.Gender, SUM(EmployeeDevelopmentSum.EmployeeCount), SUM(EmployeeDevelopmentSum.EmployeePercentage)

where EmployeeDevelopmentSum.ProgramCategory = 'Skill Development-Related Activities'

And EmployeeDevelopmentSum.EmployeeType NOT IN ('Non-Employee or Self-Employed', 'Provided By Undertakings')

And EmployeeDevelopmentSum.Gender != null

GROUP BY EmployeeDevelopmentSum.ProgramCategory, EmployeeDevelopmentSum.Gender

Employee Development Summary (EmployeeDevelopmentSum)

• Employee Count (EmployeeCount)
• Employee Type (EmployeeType)
• Gender (Gender)
• Program Category (ProgramCategory)

Calculation

Get SUM(EmployeeDevelopmentSum.EmployeeCount) where EmployeeDevelopmentSum.ProgramCategory = 'Skill Development-Related Activities'

And EmployeeDevelopmentSum.EmployeeType NOT IN ('Non-Employee or Self-Employed', 'Provided By Undertakings')

And EmployeeDevelopmentSum.Gender != null

Employee Development Summary (EmployeeDevelopmentSum)

• Employee Percentage (EmployeePercentage)
• Employee Type (EmployeeType)
• Gender (Gender)
• Program Category (ProgramCategory)

Calculation

Get SUM(EmployeeDevelopmentSum.EmployeePercentage) where EmployeeDevelopmentSum.ProgramCategory = 'Skill Development-Related Activities'

And EmployeeDevelopmentSum.EmployeeType NOT IN ('Non-Employee or Self-Employed', 'Provided By Undertakings')

And EmployeeDevelopmentSum.Gender != null

Employee Development Summary (EmployeeDevelopmentSum)

• Average Training Time (AverageTrainingTime)
• Employee Count (EmployeeCount)
• Employee Type (EmployeeType)
• Gender (Gender)
• Program Category (ProgramCategory)

Calculation

Get EmployeeDevelopmentSum.Gender, EmployeeDevelopmentSum.EmployeeCount, and EmployeeDevelopmentSum.AverageTrainingTime where EmployeeDevelopmentSum.ProgramCategory in ('Skill Development-Related Activities', 'Training') and EmployeeDevelopmentSum.Gender != null and EmployeeDevelopmentSum.EmployeeType NOT IN ('Non-Employee or Self-Employed', 'Provided By Undertakings')

Employee Count in row is SUM(EmployeeCount) grouped by Gender.

Average Training Time in row is a weighted average training time based on the total employee count grouped by Gender.

Total Number Training Hours calculated from the rows queries for this table:

SUM(Total Employee Count * Average Training Time)

Average Training Time calculated from the rows queried for this table:

SUM(AverageTrainingTime * EmployeeCount) / SUM(EmployeeCount))

Employee Development Summary (EmployeeDevelopmentSum)

• Average Training Time (AverageTrainingTime)
• Employee Count (EmployeeCount)
• Management Level (ManagementLevel)
• Employee Type (EmployeeType)
• Program Category (ProgramCategory)

Calculation

Get EmployeeDevelopmentSum.ManagementLevel, EmployeeDevelopmentSum.EmployeeCount, and EmployeeDevelopmentSum.AverageTrainingTime where EmployeeDevelopmentSum.ProgramCategory in ('Skill Development-Related Activities', 'Training') and EmployeeDevelopmentSum.ManagementLevel != null and EmployeeDevelopmentSum.EmployeeType NOT IN ('Non-Employee or Self-Employed', 'Provided By Undertakings')

Employee Count in row is SUM(EmployeeCount) grouped by ManagementLevel.

Average Training Time in row is a weighted average training time based on the total employees grouped by ManagementLevel.

Total Number Training Hours calculated from the rows queries for this table:

SUM(Total Employee Count * Average Training Time)

Average Training Time calculated from the rows queried for this table:

SUM(AverageTrainingTime * EmployeeCount) / SUM(EmployeeCount))

Employee Development Summary (EmployeeDevelopmentSum)

• Average Training Time (AverageTrainingTime)
• Employee Count (EmployeeCount)
• Business Function (BusinessFunction)
• Employee Type (EmployeeType)
• Program Category (ProgramCategory)

Calculation

Get EmployeeDevelopmentSum.BusinessFunction, EmployeeDevelopmentSum.EmployeeCount, and EmployeeDevelopmentSum.AverageTrainingTime where EmployeeDevelopmentSum.ProgramCategory in ('Skill Development-Related Activities', 'Training') and EmployeeDevelopmentSum.BusinessFunction != null and EmployeeDevelopmentSum.EmployeeType NOT IN ('Non-Employee or Self-Employed', 'Provided By Undertakings')

Employee Count in row is SUM(EmployeeCount) grouped by BusinessFunction.

Average Training Time in row is a weighted average training time based on the total employees grouped by BusinessFunction

Total Number Training Hours calculated from the rows queries for this table:

SUM(Total Employee Count * Average Training Time)

Average Training Time calculated from the rows queried for this table:

SUM(AverageTrainingTime * EmployeeCount) / SUM(EmployeeCount))

Employee Development Summary (EmployeeDevelopmentSum)

• Average Training Time (AverageTrainingTime)
• Employee Count (EmployeeCount)
• Employee Type (EmployeeType)
• Program Category (ProgramCategory)

Calculation

Get EmployeeDevelopmentSum.EmployeeType, EmployeeDevelopmentSum.EmployeeCount, and EmployeeDevelopmentSum.AverageTrainingTime where EmployeeDevelopmentSum.ProgramCategory in ('Skill Development-Related Activities', 'Training') and EmployeeDevelopmentSum.EmployeeType != null and EmployeeDevelopmentSum.EmployeeType NOT IN ('Non-Employee or Self-Employed', 'Provided By Undertakings')

Employee Count in row is SUM(EmployeeCount) grouped by BusinessFunction.

Average Training Time in row is a weighted average training time based on the total employees grouped by BusinessFunction

Total Number Training Hours calculated from the rows queries for this table:

SUM(Total Employee Count * Average Training Time)

Average Training Time calculated from the rows queried for this table:

SUM(AverageTrainingTime * EmployeeCount) / SUM(EmployeeCount))

Organization Incident Summary (OrgIncidentSummary)

• Category (Category)
• Incident Count (IncidentCount)
• Incident Subtype (IncidentSubtype)
• Incident Type (IncidentType)

Calculation

Get SUM(OrgIncidentSummary.IncidentCount) where OrgIncidentSummary.Category = ‘Work-related Illness’ and OrgIncidentSummary.IncidentType = ‘Fatality’ and OrgIncidentSummary.IncidentSubtype = ‘Own Workforce’

SELECT SUM(IncidentCount) FROM OrgIncidentSummary WHERE Category = ‘Work-related Illness’ AND IncidentType = ‘Fatality’ AND IncidentSubtype = ‘Own Workforce’

Organization Incident Summary (OrgIncidentSummary)

• Category (Category)
• Incident Count (IncidentCount)
• Incident Subtype (IncidentSubtype)
• Incident Type (IncidentType)

Calculation

Get SUM(OrgIncidentSummary.IncidentCount) where OrgIncidentSummary.Category = ‘Work-related Illness’ and OrgIncidentSummary.IncidentType = ‘Fatality’ and OrgIncidentSummary.IncidentSubtype = ‘Other Workers’SELECT SUM(IncidentCount) FROM OrgIncidentSummary WHERE Category = ‘Work-related Illness’ AND IncidentType = ‘Fatality’ AND IncidentSubtype = ‘Other Workers’

Organization Incident Summary (OrgIncidentSummary)

• Category (Category)
• Incident Count (IncidentCount)
• Incident Subtype (IncidentSubtype)
• Incident Type (IncidentType)

Calculation

Get SUM(OrgIncidentSummary.IncidentCount) where OrgIncidentSummary.Category = ‘Work-related Injuries’ and OrgIncidentSummary.IncidentType = ‘Fatality’ and OrgIncidentSummary.IncidentSubtype = ‘Own Workforce’SELECT SUM(IncidentCount) FROM OrgIncidentSummary WHERE Category = ‘Work-related Injuries’ AND IncidentType = ‘Fatality’ AND IncidentSubtype = ‘Own Workforce’

Organization Incident Summary (OrgIncidentSummary)

• Category (Category)
• Incident Count (IncidentCount)
• Incident Subtype (IncidentSubtype)
• Incident Type (IncidentType)

Calculation

Get SUM(OrgIncidentSummary.IncidentCount) where OrgIncidentSummary.Category = ‘Work-related Injuries’ and OrgIncidentSummary.IncidentType = ‘Fatality’ and OrgIncidentSummary.IncidentSubtype = ‘Other Workers’SELECT SUM(IncidentCount) FROM OrgIncidentSummary WHERE Category = ‘Work-related Injuries’ AND IncidentType = ‘Fatality’ AND IncidentSubtype = ‘Other Workers’

Organization Incident Summary (OrgIncidentSummary)

• Category (Category)
• Incident Count (IncidentCount)
• Incident Subtype (IncidentSubtype)
• Incident Type (IncidentType)

Calculation

Get SUM(OrgIncidentSummary.IncidentCount) where OrgIncidentSummary.Category IN (‘Work-related Illness’, ‘Work-related Injuries’) and OrgIncidentSummary.IncidentType = ‘Fatality’ and OrgIncidentSummary.IncidentSubtype IN (‘Own Workforce’, ‘Other Workers’)

SELECT SUM(IncidentCount) FROM OrgIncidentSummary WHERE Category IN (‘Work-related Illness’, ‘Work-related Injuries’) AND IncidentType = ‘Fatality’ AND IncidentSubtype IN (‘Own Workforce’, ‘Other Workers’)

Employment Benefit Summary (EmpBenefitSummary)

• Benefit Type (EmployeeBenefitType)
• Employee Percentage (EmployeePercentage)

Calculation

Get EmpBenefitSummary.EmployeeBenefitType and EmpBenefitSummary.EmployeePercentage

Employment Benefit Summary (EmpBenefitSummary)

• Benefit Type (EmployeeBenefitType)
• Benefit Usage (BenefitUsage)
• Employee Count (EmployeeCount)
• Gender (Gender)

Calculation

Get EmpBenefitSummary.Gender, EmpBenefitSummary.BenefitUsage, SUM(EmpBenefitSummary.EmployeeCount) where EmpBenefitSummary.EmployeeBenefitType = 'Family Related Leave (Parental, Maternity, Paternity, Care)' and EmpBenefitSummary.EmploymentType NOT IN ('Non-Employee or Self-Employed', 'Provided By Undertakings') Group by EmpBenefitSummary.Gender, EmpBenefitSummary.BenefitUsage ORDER BY EmpBenefitSummary.Gender ASC, EmpBenefitSummary.BenefitUsage ASC

Employment Benefit Summary (EmpBenefitSummary)

• Benefit Type (EmployeeBenefitType)
• Benefit Usage (BenefitUsage)
• Employee Count (EmployeeCount)
• Gender (Gender)

Calculation

Get EmpBenefitSummary.Gender, EmpBenefitSummary.BenefitUsage, SUM(EmpBenefitSummary.EmployeeCount) where EmpBenefitSummary.EmployeeBenefitType = 'Family Related Leave (Parental, Maternity, Paternity, Care)' and EmpBenefitSummary.EmploymentType NOT IN ('Non-Employee or Self-Employed', 'Provided By Undertakings') Group by EmpBenefitSummary.Gender, EmpBenefitSummary.BenefitUsage ORDER BY EmpBenefitSummary.Gender ASC, EmpBenefitSummary.BenefitUsage ASC

Employment Benefit Summary (EmpBenefitSummary)

• Benefit Type (EmployeeBenefitType)
• Benefit Usage (BenefitUsage)
• Employee Count (EmployeeCount)
• Gender (Gender)

Employee Demographic Summary (EmployeeDemographicSum)

• Employee Count (EmployeeCount)
• Employment Type (EmploymentType)
• Report Type (ReportType)
• Gender (Gender)

Calculation

Get SUM(EmpBenefitSummary.EmployeeCount) where EmpBenefitSummary.EmployeeBenefitType = 'Family Related Leave (Parental, Maternity, Paternity, Care)' and EmpBenefitSummary.EmploymentType NOT IN ('Non-Employee or Self-Employed', 'Provided By Undertakings') / Get SUM(EmployeeDemographicSum.EmployeeCount) where EmployeeDemographicSum.EmploymentType NOT IN ('Non-Employee or Self-Employed', 'Provided By Undertakings') And EmployeeDemographicSum.Gender = :<gender of this row>

Employment Compensation Summary (EmploymentCompensationSummary)

• Region (Region)

Calculation

Get EmploymentCompensationSummary.Region

Employment Compensation Summary (EmploymentCompensationSummary)

• Region (Region)

Calculation

Get EmploymentCompensationSummary.Region

Organization Incident Summary (OrgIncidentSummary)

• Category (Category)
• Incident Subtype (IncidentSubtype)
• Incident Type (IncidentType)
• Incident Count (IncidentCount)
• Fine Amount (FineAmount)

Calculation

Get OrgIncidentSummary.Category, OrgIncidentSummary.IncidentType, OrgIncidentSummary.IncidentSubtype, OrgIncidentSummary.IncidentCount, OrgIncidentSummary.FineAmount where OrgIncidentSummary.Category = 'Violation of Human Rights'

Input Fields

Organization Incident Summary (OrgIncidentSummary)

• Category (Category)
• Fine Amount (FineAmount)

Calculation

Get SUM(OrgIncidentSummary.FineAmount) where OrgIncidentSummary.Category = 'Violation of Human Rights'

Organization Incident Summary (OrgIncidentSummary)

• Category (Category)
• Corrective Action Type (CorrectiveActionType)
• Incident Type (IncidentType)
• Incident Subtype (IncidentSubtype)
• Incident Type (IncidentType)
• Incident Count (IncidentCount)
• Fine Amount (FineAmount)

Calculation

Get OrgIncidentSummary.Category, OrgIncidentSummary.IncidentType, OrgIncidentSummary.IncidentSubtype, OrgIncidentSummary.CorrectiveActionType, OrgIncidentSummary.IncidentCount, and OrgIncidentSummary.FineAmount where OrgIncidentSummary.Category IN (<the list of categories the user checked in the omni script>) and OrgIncidentSummary.IncidentType IN (<the list of incident types the user checked>) and OrgIncidentSummary.IncidentSubtype IN (<the list of incident subtypes the user checked>) and OrgIncidentSummary.CorrectiveActionType IN (<the list of corrective action types the user checked>)

Organization Incident Summary (OrgIncidentSummary)

• Category (Category)
• Corrective Action Type (CorrectiveActionType)
• Incident Count (IncidentCount)
• Fine Amount (FineAmount)

Get OrgIncidentSummary.Category, OrgIncidentSummary.CorrectiveActionType, OrgIncidentSummary.IncidentCount, and OrgIncidentSummary.FineAmount where OrgIncidentSummary.Category Category = ‘Violation of Anti-Corruption and Anti-Bribery Laws’ AND OrgIncidentSummary.CorrectiveActionType = ‘Conviction’

Organization Incident Summary (OrgIncidentSummary)

• Category (Category)
• Corrective Action Type (CorrectiveActionType)
• Incident Count (IncidentCount)

Get SUM(OrgIncidentSummary.IncidentCount) where OrgIncidentSummary.Category = ‘Violation of Anti-Corruption and Anti-Bribery Laws’ and OrgIncidentSummary.CorrectiveActionType = ‘Conviction’

Organization Incident Summary (OrgIncidentSummary)

• Category (Category)
• Corrective Action Type (CorrectiveActionType)
• Fine Amount (FineAmount)

Get SUM(OrgIncidentSummary.FineAmount) where OrgIncidentSummary.Category = ‘Violation of Anti-Corruption and Anti-Bribery Laws’ and OrgIncidentSummary.CorrectiveActionType = ‘Conviction’

Organization Incident Summary (OrgIncidentSummary)

• Category (Category)
• Incident Type (IncidentType)
• Incident Count (IncidentCount)

Get OrgIncidentSummary.IncidentType, OrgIncidentSummary.Category, and SUM(OrgIncidentSummary.IncidentCount) where OrgIncidentSummary.IncidentType = ‘Corruption’ and OrgIncidentSummary.Category IN ("Corruption Confirmed", "Corruption - Employees Dismissed or Disciplined", "Corruption - Business Partners Contracts Terminated") GROUP BY OrgIncidentSummary.IncidentType, OrgIncidentSummary.Category

Organization Incident Summary (OrgIncidentSummary)

• Category (Category)
• Incident Type (IncidentType)
• incident Subtype (IncidentSubtype)
• Incident Count (IncidentCount)

Get SUM(OrgIncidentSummary.IncidentCount) where OrgIncidentSummary.IncidentType = ‘Corruption’ and OrgIncidentSummary.Category IN ("Corruption Confirmed", "Corruption - Employees Dismissed or Disciplined", "Corruption - Business Partners Contracts Terminated") AND OrgIncidentSummary.IncidentSubtype = “Own Workforce”

Organization Incident Summary (OrgIncidentSummary)

• Category (Category)
• Incident Type (IncidentType)
• incident Subtype (IncidentSubtype)
• Incident Count (IncidentCount)

Get SUM(OrgIncidentSummary.IncidentCount) where OrgIncidentSummary.IncidentType = ‘Corruption’ and OrgIncidentSummary.Category IN ("Corruption Confirmed", "Corruption - Employees Dismissed or Disciplined", "Corruption - Business Partners Contracts Terminated") and OrgIncidentSummary.IncidentSubtype = “Other Workers”

Social Contribution Summary (SocialContributionSum)

• Category (Category)
• Country (Country)
• Subtype (Subtype)
• Total Amount (TotalAmount)
• Type (Type)

Calculation

Get SocialContributionSum.Category, SocialContributionSum.Type, SocialContributionSum.Subtype, SocialContributionSum.Country, SUM(SocialContributionSum.TotalAmount) where SocialContributionSum.Country IN (<the list of countries checked by the user in the omniscript>) and SocialContributionSum.Category = ‘Monetary’ and SocialContributionSum.Type = ‘Political’ GROUP BY SocialContributionSum.Subtype, SocialContributionSum.Country

Social Contribution Summary (SocialContributionSum)

• Category (Category)
• Country (Country)
• Total Amount (TotalAmount)
• Type (Type)

Calculation

Get SocialContributionSum.Category, SocialContributionSum.Type, SocialContributionSum.Country, SUM(SocialContributionSum.TotalAmount) where SocialContributionSum.Country IN (<the list of countries checked by the user in the omniscript>) and SocialContributionSum.Category = ‘Monetary’ and SocialContributionSum.Type = ‘Political’ GROUP BY SocialContributionSum.Country

Social Contribution Summary (SocialContributionSum)

• Category (Category)
• Country (Country)
• Total Amount (TotalAmount)
• Type (Type)
• Recipient Name (RecipientName)
• Subtype (Subtype)

Calculation

Get SocialContributionSum.Category, SocialContributionSum.Type, SocialContributionSum.Subtype, SocialContributionSum.RecipientName, and SUM(SocialContributionSum.TotalAmount) where SocialContributionSum.Country IN (<the list of countries checked by the user in the omniscript>) and SocialContributionSum.Category = ‘Monetary’ and SocialContributionSum.Type = ‘Political’ GROUP BY SocialContributionSum.Subtype, SocialContributionSum.RecipientName

Social Contribution Summary (SocialContributionSum)

• Category (Category)
• Total Amount (TotalAmount)
• Type (Type)
• Recipient Name (RecipientName)

Get SocialContributionSum.Category, SocialContributionSum.Type, SocialContributionSum.RecipientName, and SUM(SocialContributionSum.TotalAmount) where SocialContributionSum.Country IN (<the list of countries checked by the user in the omniscript>) and SocialContributionSum.Category = ‘Monetary’ and SocialContributionSum.Type = ‘Political’ GROUP BY SocialContributionSum.RecipientName