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