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 | |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/jira-issue-enhanced.md?ask=