Jira Align EI Enhancements and Features Version 10.78


Vector.png

The old navigation will be removed from Jira Align in early 2024.
Learn more about the upcoming changes


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

  • 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
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.