1. Jira Align
  2. What's new?
  3. Enterprise Insights release notes

Jira Align EI Enhancements and Features Version 10.76

Jira Align's Enterprise Insights (EI) was updated and deployed to production instances running version 10.76 on August 22nd, 2020. The following enhancements were made:

Release highlights

  • Added tables for Jira Sprint Connector, Forecast Capacity Planning, and Epic Schedule.
  • Rank validation.
  • Added Kanban flag for teams.
  • Feature Team Sprint table updates.
  • Corrected a predecessor mapping defect on object links.
  • Added mapping for programs and teams on release vehicles.
  • Time Tracking objects updated to include export features.
  • Time Tracking updates to billing codes.

New tables

View Name

Description

Epic Schedule

Schedule attributes for process steps from the Epic Time/Skills tab:

  • [Epic Schedule ID] INT NOT NULL PRIMARY KEY
  • [Complete Flag] NVARCHAR(500) NULL
  • [Date End] DATETIME NULL
  • [Date Estimate] DATETIME NULL
  • [Date Start] DATETIME NULL
  • [FK Epic ID] INT NOT NULL -- Foreign Key to [Epic].[Epic ID]
  • [FK Process Step ID] INT NOT NULL Foreign Key to [Process Step].[Process Step ID]

Forecast Capacity

Table added to represent Forecast - Plan Capacity estimates:

  • [Forecast Capacity ID] INT NOT NULL PRIMARY KEY
  • [FK Program Increment ID] INT NULL -- Foreign Key to [Program Increment].[Program Increment ID]
  • [FK Team ID] INT NULL -- Foreign Key to [Team].[Team ID]
  • [Planned FTE] INT NULL
  • [Specialist Flag] NVARCHAR(3) NULL
  • [Specialist Name] NVARCHAR(50) NULL
  • [Team Size Overriden Flag] NVARCHAR(3) NULL

Jira Sprint

Table added to represent the Jira connector configuration. This is a utility table designed to support the connector configuration. There may be data inconsistencies such as multiple records for a given Jira sprint ID, or incorrect mapping to the Jira board due to multiple connector records for a single board.

  • [Jira Sprint Mapping ID] INT NOT NULL PRIMARY KEY
  • [Active Flag] NVARCHAR(3) NOT NULL
  • [Date End] DATETIME NULL
    [Date Start] DATETIME NULL
  • [FK Connector ID] INT NOT NULL -- Unique identifier for connector, no target table available.
  • [FK Jira Board ID] INT NOT NULL -- Foreign Key to [Jira Board].[Board ID]
  • [FK Sprint ID] INT NOT NULL
  • [Jira Sprint ID] INT NULL -- Sprint Identifier in the Jira System
  • [Jira Sprint Name] NVARCHAR(500) NULL
  • [Jira Sprint Status] NVARCHAR(50) NULL

MAP Release Vehicle to Program

Mapping table for the multi-valued assignment of programs to a release vehicle:

  • [MAP Release Vehicle Program ID] INT NOT NULL PRIMARY KEY
  • [FK Program ID] INT NOT NULL -- Foreign Key to [Program].[Program ID]
  • [FK Release Vehicle ID] INT NOT NULL -- Foreign Key to [Release Vehicle].[Release Vehicle ID]

MAP Release Vehicle to Team

Mapping table for the multi-valued assignment of teams to a release vehicle:

  • [MAP Release Vehicle Team ID] INT NOT NULL PRIMARY KEY
  • [FK Release Vehicle ID] INT NOT NULL -- Foreign Key to [Release Vehicle].[Release Vehicle ID]
  • [FK Team ID] INT NOT NULL -- Foreign Key to [Team].[Team ID]

MAP Billing Code to Program (time)

Mapping table for multi-valued assignment of programs to billing codes in Time Tracking:

  • [MAP Billing Code Program ID] INT NOT NULL PRIMARY KEY
  • [Date DW Modified] DATETIME NOT NULL
  • [Deleted Flag] NVARCHAR(3) NOT NULL
  • [FK Billing Code ID] INT NOT NULL -- Foreign Key to [Billing Code].[Billing Code ID]
  • [FK Program ID] INT NOT NULL -- Foreign Key to [Program].[Program ID]

MAP Billing Code to Team (time)

Mapping table for multi-valued assignment of teams to billing xodes in Time Tracking:

  • [Date DW Modified] DATETIME NOT NULL
  • [Deleted Flag] NVARCHAR(3) NOT NULL
  • [FK Billing Code ID] INT NOT NULL -- Foreign Key to [Billing Code].[Billing Code ID]
  • [FK Team ID] INT NOT NULL -- Foreign Key to [Team].[Team ID]
  • [MAP Billing Code Team ID] INT NOT NULL PRIMARY KEY

Updated tables

View Name

Description

Feature Team Sprint

Added columns to identify Program Increment to which the sprint commitment belongs. Because feature team sprint reflects the history of commitments, a flag was added to identify the most recent/current record.

  • [Current Record Flag] NVARCHAR(3) NOT NULL - current sprint assignment for feature/team/program increment.
  • [FK Program Increment ID] INT NOT NULL - Foreign Key to [Program Increment].[Program Increment ID]

Team

Added flag to identify Kanban teams

  • [Kanban Team Flag] NVARCHAR(3) NOT NULL

Administration Code (time)

Added Date DW Modified for export support

  • [Date DW Modified] DATETIME NOT NULL

Billing Code (time)

Updated to include additional columns

  • [Billing Code Type] NVARCHAR(15) NULL
  • [Date Closed] DATETIME NULL
  • [Date DW Modified] DATETIME NOT NULL
  • [Date Expected Completion] DATETIME NULL
  • [Date Launched] DATETIME NULL
  • [Date Start] DATETIME NULL
  • [FK Epic ID] INT NOT NULL
  • [FK Product ID] INT NOT NULL
  • [State] NVARCHAR(20) NULL

Blended Rate (time)

Added Date DW Modified and Deleted Flag for export support

  • [Date DW Modified] DATETIME NOT NULL
  • [Deleted Flag] VARCHAR(3) NOT NULL

Cost Center (time)

Added Date DW Modified and Deleted Flag for export support

  • [Date DW Modified] DATETIME NOT NULL
  • [Deleted Flag] VARCHAR(3) NOT NULL

Employee Classification (time)

Added Date DW Modified and Deleted Flag for export support

  • [Date DW Modified] DATETIME NOT NULL
  • [Deleted Flag] VARCHAR(3) NOT NULL

Holiday (time)

Added Date DW Modified and Deleted Flag for export support

  • [Date DW Modified] DATETIME NOT NULL
  • [Deleted Flag] VARCHAR(3) NOT NULL

MAP Administration Code to Cost Center (time)

Added Primary Key, Date DW Modified and Deleted Flag for export support

  • [MAP Administration Code Work Code ID] INT NOT NULL PRIMARY KEY
  • [Date DW Modified] DATETIME NOT NULL
  • [Deleted Flag] VARCHAR(3) NOT NULL

MAP Administration Code to Employee Classification (time)

Added Date DW Modified and Deleted Flag for export support

  • [Date DW Modified] DATETIME NOT NULL
  • [Deleted Flag] VARCHAR(3) NOT NULL

MAP Administration Code to Work Code (time)

Added Primary Key, Date DW Modified and Deleted Flag for export support

  • [MAP Administration Code Work Code ID] INT NOT NULL PRIMARY KEY
  • [Date DW Modified] DATETIME NOT NULL
  • [Deleted Flag] VARCHAR(3) NOT NULL

MAP Billing Code to Cost Center (time)

Added Primary Key for export support

  • [MAP Billing Code Cost Center ID] INT NOT NULL PRIMARY KEY

Standard Task (time)

Added Date DW Modified and Deleted Flag for export support

  • [Date DW Modified] DATETIME NOT NULL
  • [Deleted Flag] VARCHAR(3) NOT NULL

Time Entry (Time)

Added Date DW Modified for export support

  • [Date DW Modified] DATETIME NOT NULL

Time Sheet (Time)

Added Date DW Modified for export support

  • [Date DW Modified] DATETIME NOT NULL

Time Tracking Period (time)

Added Date DW Modified and Deleted Flag for export support

  • [Date DW Modified] DATETIME NOT NULL
  • [Deleted Flag] VARCHAR(3) NOT 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.