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