View Name
|
Description
|
Capability Health
|
Added object to reflect the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for capabilities.
- [Budget] NVARCHAR(50) NULL
- [Budget Reason] NVARCHAR(MAX) NULL
- [Capability Health ID] INT NOT NULL PRIMARY KEY
- [FK Capability ID] INT NOT NULL
- [People] NVARCHAR(50) NULL
- [People Reason] NVARCHAR(MAX) NULL
- [Quality] NVARCHAR(50) NULL
- [Quality Reason] NVARCHAR(MAX) NULL
- [Risk Issues] NVARCHAR(50) NULL
- [Risk Issues Reason] NVARCHAR(MAX) NULL
- [Schedule] NVARCHAR(50) NULL
- [Schedule Reason] NVARCHAR(MAX) NULL
|
Capability Health History
|
Added object to reflect the history of the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for capabilities.
- [Budget] NVARCHAR(50) NULL
- [Budget Reason] NVARCHAR(MAX) NULL
- [Capability Health Fact ID] INT NOT NULL PRIMARY KEY
- [Date Entered] DATETIME NOT NULL
- [FK Capability ID] INT NOT NULL
- [FK User Updated By ID] INT NOT NULL
- [People] NVARCHAR(50) NULL
- [People Reason] NVARCHAR(MAX) NULL
- [Quality] NVARCHAR(50) NULL
- [Quality Reason] NVARCHAR(MAX) NULL
- [Risk Issues] NVARCHAR(50) NULL
- [Risk Issues Reason] NVARCHAR(MAX) NULL
- [Schedule] NVARCHAR(50) NULL
- [Schedule Reason] NVARCHAR(MAX) NULL
|
Epic Health History
|
Added object to reflect the history of the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for epics.
- [Budget] NVARCHAR(50) NULL
- [Budget Reason] NVARCHAR(MAX) NULL
- [Date Entered] DATETIME NOT NULL
- [Epic Health Fact ID] INT NOT NULL PRIMARY KEY
- [FK Epic ID] INT NOT NULL
- [FK User Updated By ID] INT NOT NULL
- [People] NVARCHAR(50) NULL
- [People Reason] NVARCHAR(MAX) NULL
- [Quality] NVARCHAR(50) NULL
- [Quality Reason] NVARCHAR(MAX) NULL
- [Risk Issues] NVARCHAR(50) NULL
- [Risk Issues Reason] NVARCHAR(MAX) NULL
- [Schedule] NVARCHAR(50) NULL
- [Schedule Reason] NVARCHAR(MAX) NULL
|
Feature Health
|
Added object to reflect the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for features.
- [Budget] NVARCHAR(50) NULL
- [Budget Reason] NVARCHAR(MAX) NULL
- [Feature Health ID] INT NOT NULL PRIMARY KEY
- [FK Feature ID] INT NOT NULL
- [People] NVARCHAR(50) NULL
- [People Reason] NVARCHAR(MAX) NULL
- [Quality] NVARCHAR(50) NULL
- [Quality Reason] NVARCHAR(MAX) NULL
- [Risk Issues] NVARCHAR(50) NULL
- [Risk Issues Reason] NVARCHAR(MAX) NULL
- [Schedule] NVARCHAR(50) NULL
- [Schedule Reason] NVARCHAR(MAX) NULL
|
Feature Health History
|
Added object to reflect the history of the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for features.
- [Budget] NVARCHAR(50) NULL
- [Budget Reason] NVARCHAR(MAX) NULL
- [Date Entered] DATETIME NOT NULL
- [Feature Health Fact ID] INT NOT NULL PRIMARY KEY
- [FK Feature ID] INT NOT NULL
- [FK User Updated By ID] INT NOT NULL
- [People] NVARCHAR(50) NULL
- [People Reason] NVARCHAR(MAX) NULL
- [Quality] NVARCHAR(50) NULL
- [Quality Reason] NVARCHAR(MAX) NULL
- [Risk Issues] NVARCHAR(50) NULL
- [Risk Issues Reason] NVARCHAR(MAX) NULL
- [Schedule] NVARCHAR(50) NULL
- [Schedule Reason] NVARCHAR(MAX) NULL
|
Feature Roadmap Health
|
Roadmap Health Status History. This table contains the health status label from the roadmap. It is implemented as a history table and includes all previous values for the feature with an updated timestamp to indicate the time of the change. The current value can be identified by a Yes value in the [Current Value Flag] column.
- [Current Value Flag] NVARCHAR(3) NOT NULL
- [Date Updated] DATETIME NULL
- [Feature Roadmap Health ID] INT NOT NULL PRIMARY KEY
- [FK Feature ID] INT NOT NULL
- [FK User Updated By ID] INT NOT NULL
- [Health Label] NVARCHAR(50) NULL
|
Goal Health
|
Added object to reflect the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for goals.
- [Budget] NVARCHAR(50) NULL
- [Budget Reason] NVARCHAR(MAX) NULL
- [FK Goal ID] INT NOT NULL
- [Goal Health ID] INT NOT NULL PRIMARY KEY
- [People] NVARCHAR(50) NULL
- [People Reason] NVARCHAR(MAX) NULL
- [Quality] NVARCHAR(50) NULL
- [Quality Reason] NVARCHAR(MAX) NULL
- [Risk Issues] NVARCHAR(50) NULL
- [Risk Issues Reason] NVARCHAR(MAX) NULL
- [Schedule] NVARCHAR(50) NULL
- [Schedule Reason] NVARCHAR(MAX) NULL
|
Goal Health History
|
Added object to reflect the history of the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for goals.
- [Budget] NVARCHAR(50) NULL
- [Budget Reason] NVARCHAR(MAX) NULL
- [Date Entered] DATETIME NOT NULL
- [FK Goal ID] INT NOT NULL
- [FK User Updated By ID] INT NOT NULL
- [Goal Health Fact ID] INT NOT NULL PRIMARY KEY
- [People] NVARCHAR(50) NULL
- [People Reason] NVARCHAR(MAX) NULL
- [Quality] NVARCHAR(50) NULL
- [Quality Reason] NVARCHAR(MAX) NULL
- [Risk Issues] NVARCHAR(50) NULL
- [Risk Issues Reason] NVARCHAR(MAX) NULL
- [Schedule] NVARCHAR(50) NULL
- [Schedule Reason] NVARCHAR(MAX) NULL
|
Role Log
|
Audit Log for Jira Align role changes.
- [Action Type] NVARCHAR(50) NULL
- [Audit Log ID] INT NOT NULL
- [Change Source] NVARCHAR(100) NULL
- [Date Audit Event] DATETIME NULL
- [Detail Text] NVARCHAR(MAX) NULL
- [FK Role ID] INT NOT NULL
- [FK User Modified By ID] INT NOT NULL
- [FK User Modified By Impersonation ID] INT NOT NULL
|
Theme Health
|
Added object to reflect the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for themes.
- [Budget] NVARCHAR(50) NULL
- [Budget Reason] NVARCHAR(MAX) NULL
- [FK Theme ID] INT NOT NULL
- [People] NVARCHAR(50) NULL
- [People Reason] NVARCHAR(MAX) NULL
- [Quality] NVARCHAR(50) NULL
- [Quality Reason] NVARCHAR(MAX) NULL
- [Risk Issues] NVARCHAR(50) NULL
- [Risk Issues Reason] NVARCHAR(MAX) NULL
- [Schedule] NVARCHAR(50) NULL
- [Schedule Reason] NVARCHAR(MAX) NULL
- [Theme Health ID] INT NOT NULL PRIMARY KEY
|
Theme Health History
|
Added object to reflect the history of the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for themes.
- [Budget] NVARCHAR(50) NULL
- [Budget Reason] NVARCHAR(MAX) NULL
- [Date Entered] DATETIME NOT NULL
- [FK Theme ID] INT NOT NULL
- [FK User Updated By ID] INT NOT NULL
- [People] NVARCHAR(50) NULL
- [People Reason] NVARCHAR(MAX) NULL
- [Quality] NVARCHAR(50) NULL
- [Quality Reason] NVARCHAR(MAX) NULL
- [Risk Issues] NVARCHAR(50) NULL
- [Risk Issues Reason] NVARCHAR(MAX) NULL
- [Schedule] NVARCHAR(50) NULL
- [Schedule Reason] NVARCHAR(MAX) NULL
- [Theme Health Fact ID] INT NOT NULL PRIMARY KEY
|
Theme Group Health
|
Added object to reflect the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for theme groups.
- [Budget] NVARCHAR(50) NULL
- [Budget Reason] NVARCHAR(MAX) NULL
- [FK Theme Group ID] INT NOT NULL
- [People] NVARCHAR(50) NULL
- [People Reason] NVARCHAR(MAX) NULL
- [Quality] NVARCHAR(50) NULL
- [Quality Reason] NVARCHAR(MAX) NULL
- [Risk Issues] NVARCHAR(50) NULL
- [Risk Issues Reason] NVARCHAR(MAX) NULL
- [Schedule] NVARCHAR(50) NULL
- [Schedule Reason] NVARCHAR(MAX) NULL
- [Theme Group Health ID] INT NOT NULL PRIMARY KEY
|
Theme Group Health History
|
Added object to reflect the history of the health color code (green, orange, or red) and reason text for Budget, People, Quality, Risk/Issues, and Schedule for theme groups.
- [Budget] NVARCHAR(50) NULL
- [Budget Reason] NVARCHAR(MAX) NULL
- [Date Entered] DATETIME NOT NULL
- [FK Theme Group ID] INT NOT NULL
- [FK User Updated By ID] INT NOT NULL
- [People] NVARCHAR(50) NULL
- [People Reason] NVARCHAR(MAX) NULL
- [Quality] NVARCHAR(50) NULL
- [Quality Reason] NVARCHAR(MAX) NULL
- [Risk Issues] NVARCHAR(50) NULL
- [Risk Issues Reason] NVARCHAR(MAX) NULL
- [Schedule] NVARCHAR(50) NULL
- [Schedule Reason] NVARCHAR(MAX) NULL
- [Theme Group Health Fact ID] INT NOT NULL PRIMARY KEY
|
Theme Roadmap Health
|
Roadmap Health Status History. This table contains the health status label from the roadmap. It is implemented as a history table and includes all previous values for the Theme with an updated timestamp to indicate the time of the change. The current value can be identified by a Yes value in the [Current Value Flag] column.
- [Current Value Flag] NVARCHAR(3) NOT NULL
- [Date Updated] DATETIME NULL
- [FK Theme ID] INT NOT NULL
- [FK User Updated By ID] INT NOT NULL
- [Health Label] NVARCHAR(50) NULL
- [Theme Roadmap Health ID] INT NOT NULL PRIMARY KEY
|
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.