Jira Align EI Enhancements and Features Version 10.95

Jira Align's Enterprise Insights (EI) was updated and deployed to test instances running version 10.95 on June 5, 2021, and will be deployed to production instances on June 12, 2021. The following enhancements were made:

Release highlights
New tables
Updated tables

Release highlights

Work Item Health Status added to capabilities, features, goals, themes, and theme groups.
- Health Color Code (green, orange, or red) and Reason Text for Budget, People, Quality, Risk/Issues and Schedule added.
- Health Status History added to capabilities, epics, features, goals, themes, and theme groups.
Work Item Roadmap Health Status added to features and themes.
Audit Log Detail added to the Role object.
Status Report Notes column added to features.

New tables

View Name	Description
Capability Health	Added object to reflect the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for capabilities. [Budget] NVARCHAR(50) NULL [Budget Reason] NVARCHAR(MAX) NULL [Capability Health ID] INT NOT NULL PRIMARY KEY [FK Capability ID] INT NOT NULL [People] NVARCHAR(50) NULL [People Reason] NVARCHAR(MAX) NULL [Quality] NVARCHAR(50) NULL [Quality Reason] NVARCHAR(MAX) NULL [Risk Issues] NVARCHAR(50) NULL [Risk Issues Reason] NVARCHAR(MAX) NULL [Schedule] NVARCHAR(50) NULL [Schedule Reason] NVARCHAR(MAX) NULL
Capability Health History	Added object to reflect the history of the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for capabilities. [Budget] NVARCHAR(50) NULL [Budget Reason] NVARCHAR(MAX) NULL [Capability Health Fact ID] INT NOT NULL PRIMARY KEY [Date Entered] DATETIME NOT NULL [FK Capability ID] INT NOT NULL [FK User Updated By ID] INT NOT NULL [People] NVARCHAR(50) NULL [People Reason] NVARCHAR(MAX) NULL [Quality] NVARCHAR(50) NULL [Quality Reason] NVARCHAR(MAX) NULL [Risk Issues] NVARCHAR(50) NULL [Risk Issues Reason] NVARCHAR(MAX) NULL [Schedule] NVARCHAR(50) NULL [Schedule Reason] NVARCHAR(MAX) NULL
Epic Health History	Added object to reflect the history of the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for epics. [Budget] NVARCHAR(50) NULL [Budget Reason] NVARCHAR(MAX) NULL [Date Entered] DATETIME NOT NULL [Epic Health Fact ID] INT NOT NULL PRIMARY KEY [FK Epic ID] INT NOT NULL [FK User Updated By ID] INT NOT NULL [People] NVARCHAR(50) NULL [People Reason] NVARCHAR(MAX) NULL [Quality] NVARCHAR(50) NULL [Quality Reason] NVARCHAR(MAX) NULL [Risk Issues] NVARCHAR(50) NULL [Risk Issues Reason] NVARCHAR(MAX) NULL [Schedule] NVARCHAR(50) NULL [Schedule Reason] NVARCHAR(MAX) NULL
Feature Health	Added object to reflect the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for features. [Budget] NVARCHAR(50) NULL [Budget Reason] NVARCHAR(MAX) NULL [Feature Health ID] INT NOT NULL PRIMARY KEY [FK Feature ID] INT NOT NULL [People] NVARCHAR(50) NULL [People Reason] NVARCHAR(MAX) NULL [Quality] NVARCHAR(50) NULL [Quality Reason] NVARCHAR(MAX) NULL [Risk Issues] NVARCHAR(50) NULL [Risk Issues Reason] NVARCHAR(MAX) NULL [Schedule] NVARCHAR(50) NULL [Schedule Reason] NVARCHAR(MAX) NULL
Feature Health History	Added object to reflect the history of the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for features. [Budget] NVARCHAR(50) NULL [Budget Reason] NVARCHAR(MAX) NULL [Date Entered] DATETIME NOT NULL [Feature Health Fact ID] INT NOT NULL PRIMARY KEY [FK Feature ID] INT NOT NULL [FK User Updated By ID] INT NOT NULL [People] NVARCHAR(50) NULL [People Reason] NVARCHAR(MAX) NULL [Quality] NVARCHAR(50) NULL [Quality Reason] NVARCHAR(MAX) NULL [Risk Issues] NVARCHAR(50) NULL [Risk Issues Reason] NVARCHAR(MAX) NULL [Schedule] NVARCHAR(50) NULL [Schedule Reason] NVARCHAR(MAX) NULL
Feature Roadmap Health	Roadmap Health Status History. This table contains the health status label from the roadmap. It is implemented as a history table and includes all previous values for the feature with an updated timestamp to indicate the time of the change. The current value can be identified by a Yes value in the [Current Value Flag] column. [Current Value Flag] NVARCHAR(3) NOT NULL [Date Updated] DATETIME NULL [Feature Roadmap Health ID] INT NOT NULL PRIMARY KEY [FK Feature ID] INT NOT NULL [FK User Updated By ID] INT NOT NULL [Health Label] NVARCHAR(50) NULL
Goal Health	Added object to reflect the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for goals. [Budget] NVARCHAR(50) NULL [Budget Reason] NVARCHAR(MAX) NULL [FK Goal ID] INT NOT NULL [Goal Health ID] INT NOT NULL PRIMARY KEY [People] NVARCHAR(50) NULL [People Reason] NVARCHAR(MAX) NULL [Quality] NVARCHAR(50) NULL [Quality Reason] NVARCHAR(MAX) NULL [Risk Issues] NVARCHAR(50) NULL [Risk Issues Reason] NVARCHAR(MAX) NULL [Schedule] NVARCHAR(50) NULL [Schedule Reason] NVARCHAR(MAX) NULL
Goal Health History	Added object to reflect the history of the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for goals. [Budget] NVARCHAR(50) NULL [Budget Reason] NVARCHAR(MAX) NULL [Date Entered] DATETIME NOT NULL [FK Goal ID] INT NOT NULL [FK User Updated By ID] INT NOT NULL [Goal Health Fact ID] INT NOT NULL PRIMARY KEY [People] NVARCHAR(50) NULL [People Reason] NVARCHAR(MAX) NULL [Quality] NVARCHAR(50) NULL [Quality Reason] NVARCHAR(MAX) NULL [Risk Issues] NVARCHAR(50) NULL [Risk Issues Reason] NVARCHAR(MAX) NULL [Schedule] NVARCHAR(50) NULL [Schedule Reason] NVARCHAR(MAX) NULL
Role Log	Audit Log for Jira Align role changes. [Action Type] NVARCHAR(50) NULL [Audit Log ID] INT NOT NULL [Change Source] NVARCHAR(100) NULL [Date Audit Event] DATETIME NULL [Detail Text] NVARCHAR(MAX) NULL [FK Role ID] INT NOT NULL [FK User Modified By ID] INT NOT NULL [FK User Modified By Impersonation ID] INT NOT NULL
Theme Health	Added object to reflect the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for themes. [Budget] NVARCHAR(50) NULL [Budget Reason] NVARCHAR(MAX) NULL [FK Theme ID] INT NOT NULL [People] NVARCHAR(50) NULL [People Reason] NVARCHAR(MAX) NULL [Quality] NVARCHAR(50) NULL [Quality Reason] NVARCHAR(MAX) NULL [Risk Issues] NVARCHAR(50) NULL [Risk Issues Reason] NVARCHAR(MAX) NULL [Schedule] NVARCHAR(50) NULL [Schedule Reason] NVARCHAR(MAX) NULL [Theme Health ID] INT NOT NULL PRIMARY KEY
Theme Health History	Added object to reflect the history of the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for themes. [Budget] NVARCHAR(50) NULL [Budget Reason] NVARCHAR(MAX) NULL [Date Entered] DATETIME NOT NULL [FK Theme ID] INT NOT NULL [FK User Updated By ID] INT NOT NULL [People] NVARCHAR(50) NULL [People Reason] NVARCHAR(MAX) NULL [Quality] NVARCHAR(50) NULL [Quality Reason] NVARCHAR(MAX) NULL [Risk Issues] NVARCHAR(50) NULL [Risk Issues Reason] NVARCHAR(MAX) NULL [Schedule] NVARCHAR(50) NULL [Schedule Reason] NVARCHAR(MAX) NULL [Theme Health Fact ID] INT NOT NULL PRIMARY KEY
Theme Group Health	Added object to reflect the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for theme groups. [Budget] NVARCHAR(50) NULL [Budget Reason] NVARCHAR(MAX) NULL [FK Theme Group ID] INT NOT NULL [People] NVARCHAR(50) NULL [People Reason] NVARCHAR(MAX) NULL [Quality] NVARCHAR(50) NULL [Quality Reason] NVARCHAR(MAX) NULL [Risk Issues] NVARCHAR(50) NULL [Risk Issues Reason] NVARCHAR(MAX) NULL [Schedule] NVARCHAR(50) NULL [Schedule Reason] NVARCHAR(MAX) NULL [Theme Group Health ID] INT NOT NULL PRIMARY KEY
Theme Group Health History	Added object to reflect the history of the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for theme groups. [Budget] NVARCHAR(50) NULL [Budget Reason] NVARCHAR(MAX) NULL [Date Entered] DATETIME NOT NULL [FK Theme Group ID] INT NOT NULL [FK User Updated By ID] INT NOT NULL [People] NVARCHAR(50) NULL [People Reason] NVARCHAR(MAX) NULL [Quality] NVARCHAR(50) NULL [Quality Reason] NVARCHAR(MAX) NULL [Risk Issues] NVARCHAR(50) NULL [Risk Issues Reason] NVARCHAR(MAX) NULL [Schedule] NVARCHAR(50) NULL [Schedule Reason] NVARCHAR(MAX) NULL [Theme Group Health Fact ID] INT NOT NULL PRIMARY KEY
Theme Roadmap Health	Roadmap Health Status History. This table contains the health status label from the roadmap. It is implemented as a history table and includes all previous values for the Theme with an updated timestamp to indicate the time of the change. The current value can be identified by a Yes value in the [Current Value Flag] column. [Current Value Flag] NVARCHAR(3) NOT NULL [Date Updated] DATETIME NULL [FK Theme ID] INT NOT NULL [FK User Updated By ID] INT NOT NULL [Health Label] NVARCHAR(50) NULL [Theme Roadmap Health ID] INT NOT NULL PRIMARY KEY

Updated tables

View Name

Description

Feature

Added column for status report notes.

[Status Reports Notes] NVARCHAR(MAX) NULL

Join the Atlassian Community!

The Atlassian Community is a unique, highly collaborative space where customers and Atlassians come together. Ask questions and get answers, start discussions, and collaborate with thousands of other Jira Align customers. Visit the Jira Align Community Collection today.

Need to contact Jira Align Support? Please open a support request.

Jira Align EI Enhancements and Features Version 10.95

Release highlights

New tables

Updated tables

Join the Atlassian Community!

Useful links

Get started