Newsletters
Abstract
This article outlines both planned and recent updates to the Envizi ESG Suite data model.
Content
Planned updates
The following updates are planned for March 2026:
| Report name, data model table, data type | Description of changes | Filters / API parameters | Fields | Planned release date |
|---|---|---|---|---|
| Issue Details (extract) Setup Issues (extract) _Envizi-IssueDetails (API) _Envizi-SetupIssues (API) | Status labels for DATA issues (Data Capture Issues) will be updated as indicated in the following list:
| N/A | Status | 30 March 2026 |
Released updates
The following updates were released in October 2025:
| Report name, data model table, data type | Description of changes | Filters / 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 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 |
| 30 September 2025 | 6 October 2025 |
The following updates were released in July 2025:
| Report name, data model table, data type | Description of changes | Filters / 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 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 been added 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 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 |
The following updates were released in April 2025:
| Report name, data model table, data type | Description of changes | Filters / API parameters | Fields | Planned release date | Actual release date |
|---|---|---|---|---|---|
_Envizi-ExtractForAccounts (API) Extract for Accounts (extract) |
| Utility_Type_Id (new) | Updated On (new) | 31 March 2025 | 03 April 2025 |
| Location table in the Monthly Dataset | A new 'Local Currency Unit' column 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 | 07 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 will affect 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
Table [Social Metrics] New Fields
| 31 March 2025 | 07 April 2025 |
| Updates to several data type names |
| 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.
| N/A | Each file is associated with a table in the monthly dataset. You can view the fields that are available in each table in the following links. The exported files include additional ID columns that are used to link tables when the dataset is rebuilt:
| 31 March 2025 | 07 April 2025 |
[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFJN8P","label":"IBM Envizi ESG Suite"},"ARM Category":[{"code":"a8m3p000000bmQRAAY","label":"Reports"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
12 February 2026
UID
ibm17181202