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

  • 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
Was this article helpful?
0 out of 0 found this helpful
Print Friendly Version of this pagePrint Get a PDF version of this webpagePDF

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.