WaterUtilizationAggregate table

Article
11/12/2024

Important

Some or all of this functionality is available as part of a preview release. The content and the functionality are subject to change.

The WaterUtilizationAggregate aggregate table stores the aggregated water utilization units at a comprehensive set of dimensions:

Water utilization type
Reporting period
Unit of measure
Water source type
Water type
CountryOrRegion
Party

CreateAggregateForWaterUtilizationMetrics_INTB stores the computation logic to aggregate water utilization from the ESG data model measurement tables.

Inputs

To generate the WaterUtilizationAggregate table, you need to map your source data to following ESG data model tables for the applicable scenario:

To understand the scenario when data is stored in respective tables, refer to ESG data estate overview.

Note

Ensure that data isn't duplicated across the ESG data model table.

If there are records in the measurement tables, but the attributes mapped to required fields in the aggregate table are missing, then aggregate table generation fails. You need to ensure that data for required fields is available for all the records in the ESG data model measurement tables.

This table shows the WaterUtilizationAggregate table’s column descriptions and mapping with ESG data model table fields.

Column name	Is nullable	Description	Mapping to ESG data model table
WaterUtilizationUnits	Required	This field stores the Water utilization value.	WaterUtilization
WaterUtilizationTypeName	Required	Specifies the Utilization type for the water utilization units. WaterUtilizationType is a reference table that has WaterUtilizationType values as Discharge, Recycled, and Withdrawal already available. These values are used in metric calculation.	WaterUtilizationTypeID > WaterUtilizationType.WaterUtilizationTypeName
UnitOfMeasureName	Required	Specifies the unit of measurement for the aggregated water utilization value. UnitOfMeasure is a reference table. The default unit of measure name is Cubic metres. All the Water utilization data from the ESG data model tables will be converted to Cubic metres and then stored in the aggregate table.	WaterUtilizationUOMID > UnitOfMeasure.UnitOfMeasureName
ReportingPeriod	Required	Specifies the period for which the Water utilization value is aggregated. Currently only calendar years are supported.	Year of PeriodEndDate
WaterRiskIndexName	Optional	Specifies the water risk associated with the Party (such as facility or site). WaterRiskIndex and WaterRiskType are reference tables in ESG data model. Note: In the current phase, only a single water risk value for a Party for a specific water risk type should be stored in the Water Risk table.	Maps the Party’s Water Risk using WaterRisk table. WaterRisk.WaterRiskIndexId > WaterRiskIndex.WaterRiskIndexName, where WaterRisk.WaterRiskTypeId > WaterRiskType.WaterRiskTypeName = Water Stress
CountryOrRegion	Optional	Specifies the country or region associated with the water utilization.	Maps the party’s associated location’s country/region according to the following logic: 1. If Party or Secondary Party is of PartyType = Facility then map corresponding Facility.location.Country.ISOCountryName. 2. If this condition isn't satisfied, check if Party or Secondary Party is of PartyType = 'Organization unit', then map corresponding PartyOrganization.Location.Country.ISOCountryName. 3. If this condition isn't satisfied, then map Party.PartyLocation.Country.ISOCountryName. 4. If this condition isn't satisfied, then map secondary party's Partylocation.Country.ISOCountryName. 5. Else country for the record remains null.
WaterTypeName	Optional	Describes the quality of the water being withdrawn from or discharged to the water source, such as Fresh water, Other water.	WaterTypeId > WaterType.WaterTypeName
WaterSourceTypeName	Optional	Field used to classify the water source, such as Surface water, Groundwater.	WaterSourceTypeId > WaterSourceType.WaterSourceTypeName
PartyName	Required	Name of the Party Note: Based on the scenarios explained in Configuration parameters, the PartyId here can be measurement table’s PartyId or RelatedParty.RelatedPartyId.	PartyId > Party.PartyName
PartyId	Required	Unique identifier of the Party Note: Based on the scenarios explained in Configuration parameters, the PartyId here can be measurement table’s PartyId or RelatedParty.RelatedPartyId.	PartyId
PartyTypeName	Required	This is the Party type at which data will be aggregated and stored in the aggregate tables. Note: Based on the scenarios explained in Configuration parameters, the PartyTypeNameId here can be measurement table’s PartyId > Party.PartyTypeId > PartyTypeName or RelatedParty.RelatedPartyId > Party.Party.PartyTypeId > PartyType.PartyTypeName.	PartyId > Party.PartyTypeId > PartyTypeName
SecondaryPartyName	Optional	Name of the Secondary Party. Only applicable when the measurement data in the ESG data model table is at a combination of two parties, such as Facility and organization unit combination. In such case Party and Secondary Party store the constituent parties of the combination (Facility and Organization unit).	PartyId > RelatedParty.RelatedPartyId > Party.PartyName
SecondaryPartyId	Optional	Unique identifier of the Secondary Party. Only applicable when the measurement data in the ESG data model table is at a combination of two parties, such as Facility and organization unit combination.	PartyId > RelatedParty.RelatedPartyId
SecondaryPartyType	Optional	This is the Party type at which data will be aggregated and stored in the aggregate tables. Only applicable when the measurement data in the ESG data model table is at a combination of two parties, such as Facility and organization unit combination.	PartyId > RelatedParty.RelatedPartyId > Party.PartyTypeId > PartyType.PartyTypeName
IsRolledUp	Calculated value	IsRolledUp flag indicates whether a row is a rolled-up record or not. The computation logic will always generate the aggregate table with this flag as false. Capability provides a utility function to roll up records in the aggregate table along the organization’s hierarchy (Party or secondary party dimension). The rolled-up records are also stored in the same aggregate table.	Calculated column. Value not mapped from ESG data model tables.