Work Item Types
The Work Item Types additional export populates 1 table in Snowflake:
Table Details
S4J_ISSUETYPES
This table contains information related to work item types in Jira. All work item type information available from Jira is stored in this table. One instance of this table is created per configured export location. All exports with the Work Item Types additional export option selected will merge work item type information into this table. For this reason, it is generally recommended that this option only be selected for one export per location. Otherwise export processes may perform duplicate work.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
ISSUETYPEID | INT | Work item type ID in Jira |
DESCRIPTION | VARCHAR | Work item type description in Jira |
ICONURL | VARCHAR | Work item type icon URL |
NAME | VARCHAR | Work item type name in Jira |
UNTRANSLATEDNAME | VARCHAR | Work item type untranslated name in Jira |
SUBTASK | BOOLEAN | Flag indicating whether type is a subtask |
AVATARID | INT | Work item type avatar ID |
HIERARCHYLEVEL | INT | Work item type hierarchy level in Jira |
SCOPETYPE | VARCHAR | Work item type scope type in Jira |
SCOPEPROJECTID | INT | Work item type scope project ID in Jira |