Jira Align EI Enhancements and Features Version 10.78

Jira Align's Enterprise Insights (EI) was updated and deployed to test instances running version 10.78 on September 9th, 2020, and will be deployed to production instances on September 12th, 2020. The following enhancements were made:

Release highlights
New tables
Updated tables

Release highlights

Cancel Flag added to stories, features, capabilities, and epics.
Attachment information added for capabilities, defects, dependencies, epics, features, goals, ideas, impediments, risks, snapshots, stories, test cases, and themes.
Custom Hierarchy Tree added, including mappings to capabilities, epics, features, portfolios, programs, and teams.
Skill added, including mapping to users. Referenced to existing Epic Skill table.
Sprint Discipline Time: Defect and Discipline times entered in a team meeting.
User Notes field added.
Feature Summary field added to features.

New tables

View Name	Description
Capability Attachment	Attachment information: [Attachment ID] INT NOT NULL PRIMARY KEY [Attachment Name] NVARCHAR(500) NULL [Attachment Size] BIGINT NULL [Attachment Type] NVARCHAR(MAX) NULL [Date Added] DATETIME NULL [FK Capability ID] INT NOT NULL [FK User Uploaded by ID] INT NOT NULL
Defect Attachment	Attachment information: [Attachment ID] INT NOT NULL PRIMARY KEY [Attachment Name] NVARCHAR(500) NULL [Attachment Size] BIGINT NULL [Attachment Type] NVARCHAR(MAX) NULL [Date Added] DATETIME NULL [FK Defect ID] INT NOT NULL [FK User Uploaded by ID] INT NOT NULL
Dependency Attachment	Attachment information: [Attachment ID] INT NOT NULL PRIMARY KEY [Attachment Name] NVARCHAR(500) NULL [Attachment Size] BIGINT NULL [Attachment Type] NVARCHAR(MAX) NULL [Date Added] DATETIME NULL [FK Dependency ID] INT NOT NULL [FK User Uploaded by ID] INT NOT NULL
Epic Attachment	Attachment information: [Attachment ID] INT NOT NULL PRIMARY KEY [Attachment Name] NVARCHAR(500) NULL [Attachment Size] BIGINT NULL [Attachment Type] NVARCHAR(MAX) NULL [Date Added] DATETIME NULL [FK Epic ID] INT NOT NULL [FK User Uploaded by ID] INT NOT NULL
Feature Attachment	Attachment information: [Attachment ID] INT NOT NULL PRIMARY KEY [Attachment Name] NVARCHAR(500) NULL [Attachment Size] BIGINT NULL [Attachment Type] NVARCHAR(MAX) NULL [Date Added] DATETIME NULL [FK Feature ID] INT NOT NULL [FK User Uploaded by ID] INT NOT NULL
Goal Attachment	Attachment information: [Attachment ID] INT NOT NULL PRIMARY KEY [Attachment Name] NVARCHAR(500) NULL [Attachment Size] BIGINT NULL [Attachment Type] NVARCHAR(MAX) NULL [Date Added] DATETIME NULL [FK Goal ID] INT NOT NULL [FK User Uploaded by ID] INT NOT NULL
Idea Attachment	Attachment information: [Attachment ID] INT NOT NULL PRIMARY KEY [Attachment Name] NVARCHAR(500) NULL [Attachment Size] BIGINT NULL [Attachment Type] NVARCHAR(MAX) NULL [Date Added] DATETIME NULL [FK Idea ID] INT NOT NULL [FK User Uploaded by ID] INT NOT NULL
Impediment Attachment	Attachment information: [Attachment ID] INT NOT NULL PRIMARY KEY [Attachment Name] NVARCHAR(500) NULL [Attachment Size] BIGINT NULL [Attachment Type] NVARCHAR(MAX) NULL [Date Added] DATETIME NULL [FK Impediment ID] INT NOT NULL [FK User Uploaded by ID] INT NOT NULL
Risk Attachment	Attachment information: [Attachment ID] INT NOT NULL PRIMARY KEY [Attachment Name] NVARCHAR(500) NULL [Attachment Size] BIGINT NULL [Attachment Type] NVARCHAR(MAX) NULL [Date Added] DATETIME NULL [FK Risk ID] INT NOT NULL [FK User Uploaded by ID] INT NOT NULL
Strategic Snapshot Attachment	Attachment information: [Attachment ID] INT NOT NULL PRIMARY KEY [Attachment Name] NVARCHAR(500) NULL [Attachment Size] BIGINT NULL [Attachment Type] NVARCHAR(MAX) NULL [Date Added] DATETIME NULL [FK Strategic Snapshot ID] INT NOT NULL [FK User Uploaded by ID] INT NOT NULL
Story Attachment	Attachment information: [Attachment ID] INT NOT NULL PRIMARY KEY [Attachment Name] NVARCHAR(500) NULL [Attachment Size] BIGINT NULL [Attachment Type] NVARCHAR(MAX) NULL [Date Added] DATETIME NULL [FK Story ID] INT NOT NULL [FK User Uploaded by ID] INT NOT NULL
Test Case Attachment	Attachment information: [Attachment ID] INT NOT NULL PRIMARY KEY [Attachment Name] NVARCHAR(500) NULL [Attachment Size] BIGINT NULL [Attachment Type] NVARCHAR(MAX) NULL [Date Added] DATETIME NULL [FK Test Case ID] INT NOT NULL [FK User Uploaded by ID] INT NOT NULL
Theme Attachment	Attachment information: [Attachment ID] INT NOT NULL PRIMARY KEY [Attachment Name] NVARCHAR(500) NULL [Attachment Size] BIGINT NULL [Attachment Type] NVARCHAR(MAX) NULL [Date Added] DATETIME NULL [FK Theme ID] INT NOT NULL [FK User Uploaded by ID] INT NOT NULL
Capability Rank Program	Program Rank for capabilities: [FK Capability ID] INT NOT NULL [FK Program ID] INT NOT NULL [Rank] INT NULL [Rank ID] INT NOT NULL PRIMARY KEY
Epic Rank Program	Program Rank for epics: [FK Epic ID] INT NOT NULL [FK Program ID] INT NOT NULL [Rank] INT NULL [Rank ID] INT NOT NULL PRIMARY KEY
Feature Rank Program	Program Rank for features: [FK Feature ID] INT NOT NULL [FK Program ID] INT NOT NULL [Rank] INT NULL [Rank ID] INT NOT NULL PRIMARY KEY
Hierarchy	Custom Hierarchy Table -- tree table containing custom hierarchy: [Custom Hierarchy ID] INT NOT NULL [Custom Hierarchy Name] NVARCHAR(MAX) NULL [FK Hierarchy Parent ID] INT NULL [FK User Owner ID] INT NOT NULL [Hierarchy Description] NVARCHAR(MAX) NOT NULL [Hierarchy ID] INT NOT NULL PRIMARY KEY [Hierarchy Level] INT NULL [Hierarchy Level Name] NVARCHAR(MAX) NULL [Hierarchy Name] NVARCHAR(MAX) NULL [Hierarchy Structure Path] HIERARCHYID NULL
MAP Hierarchy to Capability	Mapping table for a hierarchy to epic: [FK Epic ID] INT NOT NULL [FK Hierarchy ID] INT NOT NULL [MAP Hierarchy Epic ID] INT NOT NULL PRIMARY KEY
MAP Hierarchy to Feature	Mapping table for a hierarchy to feature: [FK Feature ID] INT NOT NULL [FK Hierarchy ID] INT NOT NULL [MAP Hierarchy Feature ID] INT NOT NULL PRIMARY KEY
MAP Hierarchy to Portfolio	Mapping table for a hierarchy to portfolio: [FK Portfolio ID] INT NOT NULL [FK Hierarchy ID] INT NOT NULL [MAP Hierarchy Portfolio ID] INT NOT NULL PRIMARY KEY
MAP Hierarchy to Program	Mapping table for a hierarchy to program: [FK Program ID] INT NOT NULL [FK Hierarchy ID] INT NOT NULL [MAP Hierarchy Program ID] INT NOT NULL PRIMARY KEY
MAP Hierarchy to Team	Mapping table for a hierarchy to team: [FK Team ID] INT NOT NULL [FK Hierarchy ID] INT NOT NULL [MAP Hierarchy Team ID] INT NOT NULL PRIMARY KEY
Skill	Master table for skill: [Skill Group Name] NVARCHAR(500) NULL [Skill ID] INT NOT NULL PRIMARY KEY [Skill Name] NVARCHAR(500) NULL
MAP User to Skill	Mapping table for user skills: [FK Skill ID] INT NOT NULL [FK User ID] INT NOT NULL [MAP User Skill ID] INT NOT NULL PRIMARY KEY [Skill Level] INT NULL
Sprint Discipline Time Fact	Time table for defect and discipline times entered in the sprint team meeting: [Program ID] INT NOT NULL [Team ID] INT NOT NULL [Date Created] DATETIME NULL [Date Time Recorded] DATETIME NULL [Discipline Name] NVARCHAR(200) NULL [Discipline Time Spent] FLOAT NULL [Done] INT NULL [FK Sprint ID] INT NOT NULL [FK User ID] INT NOT NULL [Sprint Discipline Time ID] INT NOT NULL PRIMARY KEY

Updated tables

View Name	Description
Capability	Added Canceled Flag: [Canceled Flag] NVARCHAR(3) NULL
Capability History	Added Canceled Flag: [Canceled Flag] NVARCHAR(3) NULL
Epic	Added Canceled Flag: [Canceled Flag] NVARCHAR(3) NULL
Epic History	Added Canceled Flag: [Canceled Flag] NVARCHAR(3) NULL
Feature	Added Canceled Flag and Feature Summary columns: [Canceled Flag] NVARCHAR(3) NULL [Feature Summary NVARCHAR(2000) NULL
Feature History	Added Canceled Flag and Feature Summary columns: [Canceled Flag] NVARCHAR(3) NULL [Feature Summary NVARCHAR(2000) NULL
Story	Added Canceled Flag: [Canceled Flag] NVARCHAR(3) NULL
Story History	Added Canceled Flag: [Canceled Flag] NVARCHAR(3) NULL
Epic Skill	Added Foreign Key to Skill Table: [FK Skill ID] INT NOT NULL
Jira Board	Added "FK" prefix columns for [Program ID] and [Team ID] columns: [FK Program ID] INT NOT NULL [FK Team ID] INT NOT NULL
User	Added Notes columns to User record: [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.78

Join the Atlassian Community!

Useful links

Get started