Document toolboxDocument toolbox

To learn more about Tempo products, please visit our Help Center. For support, see our Support Portal.

Tempo Data Center database tables

This article is for Tempo for Data Center.

Disclaimer: Tempo may change the format/layout of database tables at any time and does not support any direct access nor manipulation of the data, even though you can do so with a little SQL knowledge. Should you need any consultation on database querying, please contact Atlassian Support for more info.

Also, this is outside of Tempo Support scope. Should you have any questions, please join Tempo Slack Ecosystem to consult with other developers.

Always run a backup of database before making any changes on the Data Center.

On Data Center, there is no entity relationship diagrams or data models documentations. Tempo uses the same worklog table as Jira. In order to pull worklogs with Tempo data, you can use Tempo Servlet API or Tempo Data Center REST API.

Also, you could go to Jira Administration > System > Advanced > Plugin Data Storage section to look for any tables that has the keyword "Tempo", which will be all the Active Object tables that Tempo uses. If there are tables with the same name, please always use the one with the latest version. For example, Saved Report will be found in AO_013613_SAVED_REPORT_V2 (new), and not in AO_013613_SAVED_REPORT (old).

Tempo does not remove any old tables from the older versions. Therefore, you may see some tables with old data or no data, other than the ones you are actually using in the current version. In this article, we will only mention the active tables of the latest version and not any obsolete/deprecated tables.

Tempo Core

Plugin Key

Table Name

Tempo Data

Plugin Key

Table Name

Tempo Data

Tempo Core

AO_013613_HD_SCHEME_DAY

Holidays in the Holiday Scheme

 

AO_013613_HD_SCHEME

Holiday Scheme

 

AO_013613_HD_SCHEME_MEMBER

Holiday Scheme Members

 

AO_013613_WL_SCHEME_MEMBER

Workload Scheme Members

 

AO_013613_WL_SCHEME_DAY

Work days in the Workload Scheme

 

AO_013613_WL_SCHEME

Workload Scheme

 

AO_013613_WA_VALUE

Work Attribute values linked to worklogs

 

AO_013613_WA_SL_VALUE

Work Attribute Static Lists

 

AO_013613_WORK_ATTRIBUTE

Work Attributes created in Tempo Settings

 

AO_013613_EXP_CATEGORY

Expense Categories

 

AO_013613_EXPENSE

Expenses linked to Jira issues

 

AO_013613_SAVED_REPORT_V2

Saved Reports by Jira users

 

AO_013613_FAVORITES

Favorite issues inside Tempo panels

 

AO_013613_PROJECT_CONFIG

Tempo Project Color inside Project Settings

Internal Issue

Plugin Key

Table Name

Tempo Data

Plugin Key

Table Name

Tempo Data

Tempo Platform

AO_BEE373_INTERNAL_ISSUE

Internal Issues

Plugin Key

Table Name

Tempo Data

Plugin Key

Table Name

Tempo Data

Tempo Timesheets

AO_86ED1B_GRACE_PERIOD_V2

Granted Grace Periods

 

AO_86ED1B_PERIOD

Periods in Period Management

 

AO_86ED1B_PERIOD_CONFIG

Rules in Period Configuration

 

AO_86ED1B_TIMESHEET_APPROVAL

Timesheet Approval action log *

 

AO_86ED1B_WORKLOG_EXT_PROP

Servlet API External log

*For timesheet approval status on Tempo worklogs, it’s recommended to use Tempo Servlet API to retrieve data. However, for any reason, using Servlet API is not an option, you can query the approval periods from AO_86ED1B_TIMESHEET_APPROVAL (see details below) and join with worklog table.

Column

Data

Column

Data

Action

Submit/approve/reject

Actor_key

User's username (who submit/approve/reject the timesheet)

Date-Created

Date/Time when action (submit/approve/reject) is triggered

Date_from

Start date of the timesheet period

Date_to

End date of the timesheet period

ID

Approval log record id

Number_of_invalid_worklogs

Not applicable

Period

start date of monthly period (DDMMYYYY)

Period_type

Always billing

Period_view

Approval period setup in Period configuration

Reason

Description

Required_time

User's required time as per workload scheme

Reviewer_key

Reviewer's username (selected user in the submission, the actual reviewer approved/rejected the timesheet)

Status

Approval status

Submitted_time

User's logged/submitted time

User_key

Username of the timesheet

Plugin Key

Table Name

Tempo Data

Plugin Key

Table Name

Tempo Data

Tempo Budgets

AO_2D3BEA_PORTFOLIO

Portfolios

 

AO_2D3BEA_PORTFOLIO_ADMIN

Portfolio Admins

 

AO_2D3BEA_FOLIOTOPORTFOLIO

Folio linked to Portfolios

 

AO_2D3BEA_PORTFOLIOTOPORTFOLIO

Portfolio linked to Portfolios

 

AO_2D3BEA_COMMENT

Folio Notes

 

AO_2D3BEA_BASELINE

Folio Baselines/Expenditures

 

AO_2D3BEA_POSITION

Team members linked to Folio

 

AO_2D3BEA_ALLOCATION

Team members' Plans

 

AO_2D3BEA_RATE

Cost Rates by User/Role

 

AO_2D3BEA_CURRENCY

Currencies

 

AO_2D3BEA_EXCHANGERATE

Currencies Exchange Rates

 

AO_2D3BEA_STATUS

Folio Status

 

AO_2D3BEA_WEEKDAY

Folio Working Days and Hours

 

AO_2D3BEA_WAGE

Folio Accounting

 

AO_2D3BEA_OVERTIME

Overtime Rules

 

AO_2D3BEA_FOLIO_MATRIX

Folio Cost Matrix

 

AO_2D3BEA_EXTERNALTEAM

Folio linked to Tempo Teams

 

AO_2D3BEA_FOLIOCF

Folio Custom Fields

 

AO_2D3BEA_FOLIOCFVALUE

Custom Field linked to Folios

 

AO_2D3BEA_EXPENSE

Expenses linked to Folios

 

AO_2D3BEA_EXCHANGERATE

Configuration change logs

 

AO_2D3BEA_ATTACHMENT

Folio Attachments

Tempo Planner

AO_2D3BEA_PLAN_ALLOCATION

Tempo Plans

 

AO_2D3BEA_PLAN_APPROVAL_LOG

Plan Approval action log

Plugin Key

Table Name

Tempo Data

Plugin Key

Table Name

Tempo Data

Tempo Accounts

AO_C3C6E8_ACCOUNT_V1

Tempo Accounts

 

AO_C3C6E8_CATEGORY_V1

Account Category Types

 

AO_C3C6E8_CUSTOMER_V1

Customers

 

AO_C3C6E8_LINK_V1

Account Links to Projects

 

AO_C3C6E8_RATE

Price Tables for Roles

 

AO_C3C6E8_RATE_TABLE

Accounts linked to Price Tables

Plugin Key

Table Name

Tempo Data

Plugin Key

Table Name

Tempo Data

Tempo Teams

AO_AEFED0_GENERIC_RESOURCE

Generic Resource Names

 

AO_AEFED0_GR_TEAM_MEMBER

GR linked to Teams

 

AO_AEFED0_LOCATION

Location

 

AO_AEFED0_TEAM_V2

Tempo Teams

 

AO_AEFED0_TEAM_ROLE

Team Roles

 

AO_AEFED0_TEAM_LINK

Team linked to Projects

 

AO_AEFED0_MEMBERSHIP

Team Memberships

 

AO_AEFED0_TEAM_MEMBER_V2

Team Member Types (User/Group)

 

AO_AEFED0_TEAM_PERMISSION

Team Member Permissions

 

AO_AEFED0_PGP_GROUP_V2

Team Permission Groups

 

AO_AEFED0_PGP_PERMISSION_V2

Team Permission Group Permissions

 

AO_AEFED0_PGP_GROUP_TO_TEAM

Team Permission Group linked to Teams

 

AO_AEFED0_PROGRAM

Tempo Programs

 

AO_AEFED0_USER_INDEX

Tempo Users