Tempo Capacity Plans
The Tempo Capacity Plans additional export populates 4 tables in Snowflake:
Table Details
S4J_TEMPOPLANS
This table contains the main information related to Tempo capacity plans. All capacity plan information from the start of time, up to plans scheduled 90 days in the future, is included here. One instance of this table is created per configured export location. All exports with the Tempo Capacity Plans additional export option selected will merge plan 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. Custom/scheduled updates to exports will only merge in plans that have changed since the last update.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
PLANID | INT | Capacity Plan ID in Tempo |
PLANCREATORID | VARCHAR | Plan creator’s Jira user account ID |
STARTDATE | DATE | Plan start date |
ENDDATE | DATE | Plan end date |
DESCRIPTION | VARCHAR | Plan description |
CREATEDAT | DATETIME | Plan creation timestamp |
UPDATEDAT | DATETIME | Plan update timestamp |
PLANNEDSECONDSPERDAY | INT | Number of seconds planned for each day |
TOTALPLANNEDSECONDS | INT | Total number of seconds planned |
TOTALPLANNEDSECONDSINSCOPE | INT | Total number of seconds planned in scope |
EFFORTPERSISTENCETYPE | VARCHAR | Plan effort persistence type |
SYNCSOURCE | VARCHAR | Plan synchronization source |
INCLUDENONWORKINGDAYS | BOOLEAN | Flag indicating whether non-working days are included in the plan |
RULE | VARCHAR | Plan rule |
RECURRENCEENDDATE | DATE | Plan recurrence end date |
STARTTIME | TIME | Plan start time |
PLANASSIGNEEID | VARCHAR | Plan assignee’s Jira user account ID |
PLANASSIGNEETYPE | VARCHAR | Plan assignee type |
PLANITEMID | VARCHAR | Plan item ID |
PLANITEMTYPE | VARCHAR | Plan item type |
PLANAPPROVALSTATUS | VARCHAR | Plan approval status |
PLANAPPROVALREVIEWERID | VARCHAR | Plan approval reviewer’s Jira user account ID |
PLANAPPROVALACTORID | VARCHAR | Plan approval actor’s Jira user account ID |
PLANAPPROVALREQUESTERID | VARCHAR | Plan approval requester’s Jira user account ID |
S4J_TEMPOPLANS_DAYS
This table contains information related to the time planned for individual days in capacity plans.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
PLANID | INT | Capacity Plan ID in Tempo |
DATE | DATE | Date within a plan |
PLANNEDSECONDS | INT | Number of seconds planned for the date |
S4J_TEMPOPLANS_PERIODS
This table contains information related to the time planned for individual periods in capacity plans.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
PLANID | INT | Capacity Plan ID in Tempo |
FROMDATE | DATE | Start date of this period within a plan |
TODATE | DATE | End date of this period within a plan |
PLANNEDSECONDS | INT | Number of seconds planned for the period |
S4J_TEMPOGENERIC_RESOURCES
This table contains information related to the generic resources associated with capacity plans.
Column | Type | Description |
|---|---|---|
ID | INT | Autogenerated ID |
RESOURCEID | INT | Generic resource ID in Tempo |
NAME | VARCHAR | Generic resource name |
CREATEDAT | DATETIME | Generic resource creation timestamp |
CREATEDBY | VARCHAR | Generic resource creator’s Jira user account ID |
UPDATEDAT | DATETIME | Generic resource update timestamp |
UPDATEDBY | VARCHAR | Generic resource updater’s Jira user account ID |