ResourceOutflowsAggregate table
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 ResourceOutflowsAggregate aggregate table stores the aggregated weight of each resource outflow by facility and reporting period.
The CreateAggregateForResourceOutflowMetrics_INTB notebook contains the computation logic to aggregate data from environmental, social, and governance (ESG) data model tables and generate the ResourceOutflowsAggregate table.
Inputs
For this aggregate table, you store your data in these ESG data model tables in the ProcessedESGData_LH lakehouse.
Facility Item Production: Used for capturing the resource outflows, such as finished goods, produced. The raw materials and packaging material used for producing the resource outflow should be stored in:
- Item Bill of Material Line: For raw materials.
- Item Packaging Item: For packaging material.
For details on ingesting, transforming, and loading data into ESG data model tables, go to ESG data estate overview.
This table shows the ResourceOutflowsAggregate table column details and mapping of columns to ESG data model tables.
| Column name | Is nullable | Description | Mapping to ESG data model |
|---|---|---|---|
| FacilityId | Required | Unique identifier of the Facility | FacilityId |
| FacilityName | Optional | Name of the Facility | FacilityId > Facility.FacilityName |
| ReportingPeriod | Required | Specifies the period over which the ResourceOutflow weight and quantity are aggregated. Currently only calendar years are supported. | Year of Period end date if Period end date is available, else year of Period start date |
| ResourceOutflowId | Required | Unique identifier of the resource outflow produced in the facility | FacilityItemProduction.ItemSKU |
| ResourceOutflowName | Required | Name of the resource outflow produced in the facility | FacilityItemProduction.ItemSKU > Item.ItemName |
| ResourceOutflowWeight | Required | Weight of the item produced in the facility | FacilityItemProductionQuantity * Item.ItemWeight for each ItemSKU by Facility and Reporting period |
| UnitOfMeasureName | Required | Unit of measure for the Resource outflow weight | UnitOfMeasureId > UnitOfMeasure.UnitOfMeasureName |
| ResourceOutflowProductionQuantity | Required | Quantity of the resource outflow generated | FacilityItemProductionQuantity for each ItemSKU by facility and Reporting period |
Note
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.
By default, the computation logic aggregates the weight in kg unit of measure. Thus, all the data from ESG data model table is converted to kg and then stored in the aggregate table. If you want to generate metrics in different unit of measure or multiple units of measure, then generate the aggregate table in the required unit of measure. Update the UnitOfMeasureNames key for ResourceOutflowsAggregate in the aggregate_tables_config.json file in the ESG metrics folder in the ConfigAndDemoData lakehouse. Ensure that UnitOfMeasureName specified is a valid UnitOfMeasureName in the UnitOfMeasure reference table and the conversion factor from source unit to target unit is available in the UnitOfMeasureConversion table.
After the aggregate table generates in the required unit of measure, you can update the metric definition or define custom metric. For more details on customizing metrics, go to Create custom metrics.
