The SLA Cycles additional export populates 2 tables in Snowflake:
Table Details
S4J_ISSUE_SLA_CYCLES
This table contains information for all SLA cycles applicable to work items keys from Service Desk projects in Jira. One instance of this table is created per configured export location. All exports with the SLA Cycles additional export option selected will merge information into this table. For this reason, it is generally recommended that this option only be selected for one export per location, unless individual exports operate on distinct subsets of work item keys. Otherwise export processes may perform duplicate work.
|
Column |
Type |
Description |
|---|---|---|
|
ID |
INT |
Autogenerated ID |
|
ISSUEKEY |
VARCHAR |
Jira work item key |
|
ISSUEID |
INT |
Jira work item ID |
|
SLAID |
INT |
SLA ID - foreign key to S4J_SLA_DETAILS table |
|
STARTTIME |
DATETIME |
SLA cycle start time |
|
STOPTIME |
DATETIME |
SLA cycle stop time |
|
BREACHTIME |
DATETIME |
SLA cycle breach time |
|
BREACHED |
BOOLEAN |
Flag for whether this cycle breached the SLA goal |
|
ELAPSEDTIMEMILLIS |
NUMBER |
Cycle elapsed time, in milliseconds |
|
REMAININGTIMEMILLIS |
NUMBER |
Cycle remaining time, in milliseconds |
|
COMPLETED |
BOOLEAN |
Flag for whether this cycle is completed |
|
ONGOING |
BOOLEAN |
Flag for whether this cycle is ongoing |
|
PAUSED |
BOOLEAN |
Flag for whether this cycle is paused |
|
WITHINCALENDARHOURS |
BOOLEAN |
Flag for whether this cycle is within calendar hours |
|
UPDATED |
DATETIME |
Timestamp for cycle data update in Snowflake |
S4J_SLA_DETAILS
This table contains information for all SLA goals applicable to work items keys from Service Desk projects in Jira. One instance of this table is created per configured export location. All exports with the SLA Cycles additional export option selected will merge information into this table. For this reason, it is generally recommended that this option only be selected for one export per location, unless individual exports operate on distinct subsets of work item keys. Otherwise export processes may perform duplicate work.
|
Column |
Type |
Description |
|---|---|---|
|
ID |
INT |
Autogenerated ID |
|
SLAID |
INT |
SLA ID |
|
NAME |
VARCHAR |
SLA name |
|
GOALDURATIONMILLIS |
NUMBER |
SLA goal duration, in milliseconds |