Time in Status
The Time in Status additional export populates 1 table in Snowflake:
Table Details
S4J_TIME_IN_STATUS
This table contains information related to work item status transition times in Jira. All status time information associated with the current export’s work items is stored in this table. This information is generated by the app after examining all changelogs for the current export’s work items. One instance of this table is created per configured export location. All exports with the Time in Status additional export option selected will merge their work item’s status time information into this table. For this reason, multiple exports per location may include this option without causing export processes to perform duplicate work. If all status time information from Jira is required, then one or more exports containing all Jira work items must include this option.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
ISSUEKEY | VARCHAR | Work item key in Jira |
ISSUEID | INT | Work item ID in Jira |
FROMSTATUSNAME | VARCHAR | Original work item status name |
FROMSTATUSID | INT | Original work item status ID |
TOSTATUSNAME | VARCHAR | New work item status name |
TOSTATUSID | INT | New work item status ID |
CHANGEDATE | DATETIME | Work item status change timestamp |
CHANGEUSERACCOUNTID | VARCHAR | Change user Jira account ID |
TIMEINFROMSTATUS | INT | Work item time spent in original status (minutes) |