Jira Align EI Enhancements and Features Version 10.87

Jira Align's Enterprise Insights (EI) was updated and deployed to test instances running version 10.87 on January 25, 2021, and will be deployed to production instances on January 30, 2021. The following enhancements were made:

Release highlights

  • Assessments object(s) added.
  • Detail Panel Settings added from Jira Align administration settings.

New tables

View Name

Description

Assessment

Master object for Jira Align Assessments.

  • [Assessment Description] NVARCHAR(MAX) NULL
  • [Assessment ID] INT NOT NULL PRIMARY KEY
  • [Assessment Name] NVARCHAR(100) NULL
  • [Assessment Type] NVARCHAR(20) NULL
  • [Date Created] DATETIME NULL
  • [Date Last Updated] DATETIME NULL
  • [FK User Owner ID] INT NOT NULL

Assessment Answer Set

Answer Set definitions for assessments.

  • [Active Flag] NVARCHAR(3) NULL
  • [Answer Set ID] INT NOT NULL PRIMARY KEY
  • [Answer Set Name] NVARCHAR(150) NULL
  • [FK Assessment ID] INT NOT NULL
  • [FK User Owner ID] INT NOT NULL

Assessment Answer Set Value

Individual Answer Set configured values (also referred to as responses).

  • [Answer Set Value Color] NVARCHAR(6) NULL
  • [Answer Set Value Description] NVARCHAR(350) NULL
  • [Answer Set Value ID] INT NOT NULL PRIMARY KEY
  • [Answer Set Value Name] NVARCHAR(50) NULL
  • [Answer Set Value Weight] INT NULL
  • [FK Assessment Answer Set ID] INT NOT NULL
  • [FK Assessment ID] INT NOT NULL
  • [FK User Owner ID] INT NOT NULL

Assessment Question

Question definition for Assessments. Note that [FK Assessment Category ID] does not have a corresponding reference table, as the name attribute was pulled onto this table.

  • [FK Assessment Answer Set ID] INT NOT NULL
  • [FK Assessment Category ID] INT NOT NULL
  • [FK Assessment ID] INT NOT NULL
  • [FK User Owner ID] INT NOT NULL
  • [Question Category] NVARCHAR(150) NULL
  • [Question Category Sort Order] INT NULL
  • [Question Description] NVARCHAR(2500) NULL
  • [Question ID] INT NOT NULL PRIMARY KEY
  • [Question Name] NVARCHAR(150) NULL
  • [Sort Order] INT NULL

Assessment Result

Actual Assessment responses from the user.

  • [Assessment Result Comment] NVARCHAR(MAX) NULL
  • [Assessment Result ID] INT NOT NULL PRIMARY KEY
  • [Date Entered] DATETIME NULL
  • [FK Assessment Answer Set Value ID] INT NOT NULL
  • [FK Assessment ID] INT NOT NULL
  • [FK Assessment Question ID] INT NOT NULL
  • [FK Assessment Schedule ID] INT NOT NULL
  • [FK User ID] INT NOT NULL

Assessment Schedule

Schedule for Assessments.

  • [Assessment Schedule ID] INT NOT NULL PRIMARY KEY
  • [Assessment Schedule Name] NVARCHAR(150) NULL
  • [Date Schedule End] DATETIME NULL
  • [Date Schedule Start] DATETIME NULL
  • [FK Assessment ID] INT NOT NULL

MAP Assessment to Participant

Participant mapping for an Assessment.

  • [FK Assessment ID] INT NOT NULL
  • [FK User Participant ID] INT NOT NULL
  • [MAP Assessment Participant ID] INT NOT NULL PRIMARY KEY

Details Panels Settings

Detail Panel Settings from the Administration section of Jira Align.

  • [Active Flag] NVARCHAR(3) NULL
  • [Agile Object Name] NVARCHAR(20) NULL
  • [Field Name] NVARCHAR(350) NULL
  • [FK Portfolio ID] INT NOT NULL
  • [Page Tab Name] NVARCHAR(20) NULL
  • [Required Flag] NVARCHAR(3) NULL
  • [Setting ID] INT NOT NULL PRIMARY KEY

 

Updated tables

No tables were updated in this release. 

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.