# Jira: User Enhanced

## Description

* Table of users enriched with their projects, and the volume and velocity of their issues.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/jira/resources/jira.svg" alt="" data-size="line"> Jira

## Columns

| Type     | Name                                  | Description                                                              |
| -------- | ------------------------------------- | ------------------------------------------------------------------------ |
| INTEGER  | email                                 | Email associated with the user acccount.                                 |
| STRING   | user\_id                              | Unique ID of the user.                                                   |
| STRING   | locale                                | The Java locale of the user.                                             |
| STRING   | user\_display\_name                   | Name of the user as it appears in the UI.                                |
| STRING   | time\_zone                            | The user's timezone, as defined in their settings.                       |
| INTEGER  | username                              | Account username.                                                        |
| DATETIME | \_fivetran\_synced                    |                                                                          |
| STRING   | projects                              | Comma-separated list of projects on which the user has been assigned to. |
| INTEGER  | count\_closed\_issues                 | The number of issues that the user has closed (while being assigned to). |
| INTEGER  | count\_open\_issues                   | The number of currently open issues that the user is assigned to.        |
| DECIMAL  | avg\_close\_time\_days                | The average time taken to close issues since assignment, in days.        |
| DECIMAL  | avg\_age\_currently\_open\_days       | The average age of a user's currently open issues.                       |
| DECIMAL  | median\_close\_time\_days             | The median time taken to close issues since assignment, in days.         |
| DECIMAL  | median\_age\_currently\_open\_days    | The median age of a user's currently open issues.                        |
| DECIMAL  | avg\_close\_time\_seconds             | The average time taken to close issues since assignment, in seconds.     |
| DECIMAL  | avg\_age\_currently\_open\_seconds    | Tjhe average age of a user's currently open issues.                      |
| DECIMAL  | median\_close\_time\_seconds          | The median time taken to close issues since assignment, in seconds.      |
| DECIMAL  | median\_age\_currently\_open\_seconds | The median age of a user's currently open issues.                        |


---

# 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-user-enhanced.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.