Data model and API reporting

Edit online

See both planned and recent updates to the IBM® Envizi ESG Suite data model.

Planned updates

No updates are currently planned.

Updates released in October 2025

Columns were added to tables in the Monthly Dataset to improve functionality.
Table 1. Released updates October 2025
Report name or data model table Description of changes Filters or API parameters Fields Planned release date Actual release date
Social Metric table in the Monthly Dataset, and associated files in the Monthly Dataset export New Approved Percent, Normalization Method, and Unit of Measure fields have been added to the Social Metric table. The fields are used with the new account data approval feature to indicate the percentage of approved monthly normalized data. If you have any queries that are built and linked to the data export service files, ensure that you are prepared for the new fields to be present. N/a
  • Approved Percent
  • Normalization Method
  • Unit of Measure
 30 September 2025 6 October 2025

Updates released in July 2025

Table 2. Released updates July 2025
Report name or data model table Description of changes Filters or API parameters Fields Planned release date Actual release date
Social metrics table in Monthly Dataset The Social Metrics tables in the Monthly Dataset have been updated to incorporate tag data. This allows PowerReports to filter and aggregate Social Metrics data by the tags that are applied to accounts. The update requires some changes to the table structure and affects data export files. If you have any queries that are built and linked to the data export service files, ensure that you are prepared for the new fields to be present. N/A Use_Id 14 July 2025 14 July 2025
Data export service file: AccountItems_SSAS_Meta The social metrics now include functionality to create fields automatically based on instantaneous calculation methods. To facilitate the functionality, new fields must be added to the data export service file: AccountItems_SSAS_Meta. N/A
Visibility
Formula
 14 July 2025 14 July 2025
Table [Calendar] in Monthly Dataset New columns have been added to some monthly dataset tables to enhance functionality and allow for custom variance calculations. N/A FY Month 14 July 2025 14 July 2025
Table [Fact] in Monthly Dataset New columns have beenadded to some monthly dataset tables to enhance functionality and allow for custom variance calculations. N/A Baseline_MonthEnd 14 July 2025 14 July 2025
Records & Cost Audit (extract)
_Envizi-RecordsAndCostAudit (API)
Account style data extract (extract)

_Envizi-AccountStyleDataExtract (API)

Account Items Audit (extract)

_Envizi-AccountItemsAudit (API)
Records Extract by Tag (extract)
 New columns for the Approval Status and Lock Status fields have been added to all listed extract and API reports. The columns are used with the new account data approval feature to indicate the approval and lock status of individual account records. N/A
Approval Status
Lock Status
 14 July 2025 14 July 2025
Monthly Data Summary (extract)
_Envizi-MonthlyDataSummary (API)
Monthly Data Summary - All Measures (extract)
_Envizi-MonthlyDataSummaryAllMeasures (API)
Monthly Data Summary - Social Metrics (extract)
 A new column Approved Percent has been added to all listed extract and API reports. The column is used with the new account data approval feature to indicate the percentage of approved monthly normalized data. N/A Approved Percent 14 July 2025 14 July 2025
Table [Fact] in Monthly Dataset
Fact file in Monthly Dataset export
A new field Approved Percent has been added to Table [Fact] and to the powerbiFactMonthly_ export file. The field is used with the new account data approval feature to indicate the percentage of approved monthly normalized data. N/A Approved Percent 14 July 2025 14 July 2025
All files that are included in Data Export AddOn - Monthly Dataset The format of the timestamp in the filenames has been changed from dd-MMM-yyyy to yyyy-mm-dd to make it easier to sort files that are exported by using the Data Export AddOn. N/A N/A 14 July 2025 14 July 2025

Updates released in April 2025

Table 3. Released updates April 2025
Report name or data model table Description of changes Filters or API parameters Fields Planned release date Actual release date
_Envizi-ExtractForAccounts (API) Extract for Accounts (extract) The following updates were made:
  1. A new column named Updated On was added to the API report _Envizi-ExtractForAccounts and its corresponding platform report Extract for Accounts. The Updated On column reflects the date and time when an account was last updated. The new column was added after the last column Account Style Cost Accrue Method in both reports.
  2. A new API input parameter named Utility_Type_Id was made available to the API report _Envizi-ExtractForAccounts, and its corresponding platform report Extract for Accounts as a new report selection criteria. The Utility_Type_Id parameter allows the selection of a specific data type when running the report. If the parameter is not specified, it defaults to all data types.
 Utility_Type_Id (new) Updated On (new) 31 March 2025 3 April 2025
Location table in the Monthly Dataset A new column Local Currency Unit was added to the Location table in the Monthly Dataset. The value of the column reflects a 3 digits ISO currency code of the default currency for a location based on its geographical region. N/A Local Currency Unit (new) 31 March 2025 7 April 2025
Social metrics table in Monthly Dataset The Social Metrics tables in the Monthly Dataset were updated to incorporate Group and Region data. This allows PowerReports to filter and aggregate Social Metrics data by these fields. This requires some changes to the table structure and affects data export files as a result. If you have any queries built and linked to the data export service files, ensure you are prepared for the new fields to be present. N/A Affected tables and files:Table [Social Metric]New Fields
  • Group_Id
  • Group_Location_Id
  • Lowest Group_Id
  • Middle_Group_Id
  • Region_Id
  • Top_Group_Id
Table [Social Metrics]New Fields
  • Group_Id
  • Group_Location_Id
  • Lowest Group_Id
  • Middle_Group_Id
  • Region_Id
  • Top_Group_Id
 31 March 2025 7 April 2025
Updates to several data type names
  • Propane Gas [gal] was updated to Propane [gal]. The name was updated to reflect that the US EPA factors against this data type are for liquid propane and not gaseous propane. A separate data type is to be created for gaseous propane.
  • Propane Gas [gal] - Scope 2 was updated to Propane [gal] - Scope 2. The name was updated to reflect that the US EPA factors against this data type are for liquid propane and not gaseous propane. A separate data type is to be created for gaseous propane.
  • Propane Gas [gal] - Scope 3 was updated to Propane [gal] - Scope 3. The name was updated to reflect that the US EPA factors against this data type are for liquid propane and not gaseous propane. A separate data type is to be created for gaseous propane.
 N/A Several data types. See description. 31 March 2025 17 April 2025
Files added to Data Export AddOn - Monthly Dataset The following files were added to the Data Export AddOn for the Monthly Dataset.
  • powerbiAccountStyleCategory_
  • powerbiFactAccountItems_
  • powerbiIntensityTargetsAssociate_
  • powerbiIntensityTargetsGroup_
  • powerbiIntensityTargetsLocation_
  • powerbiLocationGroupFilter_
  • powerbiMetaAccountItems_
  • powerbiRatios_
  • powerbiTag_
 N/A Each file is associated with a table in the monthly dataset. You can view the fields that are available in each table at the following links. The exported files include additional ID columns that are used to link tables when the dataset is rebuilt: 31 March 2025 7 April 2025