Jira: Issue Enhanced

Description

• The core issue table, enhanced with current-status attributes from foreign-key-related tables, and metrics regarding resolutions and assignments.

Supported Data Sources

• Jira

Columns

Type	Name	Description
INTEGER	issue_id	Unique ID of the issue.
INTEGER	parent_issue_id	Self-referencing ID of the parent issue.
INTEGER	original_estimate_seconds	The original estimate of how long working on this issue would take, in seconds.
INTEGER	remaining_estimate_seconds	The estimate of how much longer working on this issue will take, in seconds.
INTEGER	time_spent_seconds	The time that was spent working on this issue, in seconds.
STRING	assignee_user_id	Foreign key referencing the ID of the user currently assigned to this task.
DATETIME	created_at	Timestamp of when the issue was created (in UTC).
DATETIME	resolved_at	Timestamp of when the issue was resolved (ie completed, marked as duplicate). If an issue is un-resolved, this will be null.
STRING	creator_user_id	Foreign key referencing the user who first created the issue. Cannot be changed.
STRING	issue_description	The issue description, if given.
INTEGER	due_date	Calendar day on which the issue is due, if a due date is provided.
INTEGER	environment	Text field describing the environment in which the issue occurred (ie "IE9 on Windows 7").
INTEGER	issue_type_id	Foreign key referencing the ID of the issue_type.
STRING	issue_key	UI-facing id of the issue.
INTEGER	priority_id	Foreign key referencing the ID of the issue's current priority.
INTEGER	project_id	Foreign key referencing the project that the issue belongs to.
STRING	reporter_user_id	Foreign key referencing the ID of the user who reported the issue. This differs from the issue.creator column in that the reporter can be changed in-app, though it is initialized as the creator.
INTEGER	resolution_id	Foreign key referencing the ID of the issue's type of resolution.
INTEGER	status_id	Foreign key referencing the ID of the issue's status (the step that the issue is currently at in the project's workflow).
DATETIME	status_changed_at	Timestamp of when the status was last changed.
STRING	issue_name	Title of the issue.
DATETIME	updated_at	Timestamp of when the issue was last updated in some way.
DECIMAL	work_ratio	The percentage of work that has been logged against the issue (time_spent) vs the original estimate of worktime. Equals -1.0 when the fields required for calculation are not provided.
DATETIME	_fivetran_synced
STRING	issue_type	Name of the issue type (ie Epic, Task, Subtask, any custom types).
STRING	parent_issue_type	Name of the type of issue that the parent is.
STRING	parent_issue_name	Title of the parent issue/epic.
STRING	parent_issue_key	Issue key of the sub-issue's parent/epic.
BOOLEAN	is_parent_epic	Boolean that is true if the parent is an epic.
STRING	assignee_name	User display name of the person currently assigned this issue.
STRING	assignee_timezone	Timezone of the user currently assigned this issue.
INTEGER	assignee_email	Email associated with the user currently assigned this issue.
INTEGER	reporter_email	Email associated with the user who reported this issue.
STRING	reporter_name	User display name of the person who reported the issue.
STRING	reporter_timezone	Timezone of the user currently who reported this issue.
STRING	project_name	Title of the issue's project.
STRING	current_status	Title of the category of status.
STRING	current_status_category	Title of the umbrella status category that the issue is currently in.
STRING	resolution_type	Display name of the type of resolution that closed the issue.
STRING	current_priority	Name of the issue's current priority as it appears in the UI.
STRING	current_sprint_id	Foreign key referencing the current sprint associate with the issue.
STRING	current_sprint_name	Title of the current sprint associated with the issue.
INTEGER	count_sprint_changes	The total number of sprints that the issue has belonged to.
DATETIME	sprint_started_at	Timestamp of when the sprint began.
DATETIME	sprint_ended_at	Timestamp of when the sprint is planned to end.
DATETIME	sprint_completed_at	Timestamp of when the sprint was completed.
BOOLEAN	is_active_sprint	Yes, if the sprint started after the current time and if the sprint ends in the future.
DATETIME	first_assigned_at	Timestamp of when the issue was first assigned to a user.
DATETIME	last_assigned_at	Timestamp of when the issue was last assigned to a user.
DATETIME	first_resolved_at	Timestamp of when the issue was first resolved.
STRING	fixes_versions	Comma-separated list of the names of project versions that this issue fixes.
STRING	affects_versions	Comma-separated list of the names of project versions that this issue affects.
STRING	conversation	Line-separated list of comments made on this issue, including the timestamp and author name of each comment.
INTEGER	count_comments	The number of comments made on this issues.
INTEGER	open_duration_seconds	The number of seconds that the issue has spent open (until resolution, or the current timestamp).
INTEGER	any_assignment_duration_seconds	The number of seconds that the issue has spent assigned (until resolution, or the current timestamp).
INTEGER	last_assignment_duration_seconds	The number of seconds that the issue has spent assigned to the current/most recent user (until resolution, or the current timestamp).
STRING	status	ID of the associated status.
STRING	sprint	List of associated sprint IDs.
STRING	summary
STRING	story_points
STRING	components