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 and not any obsolete/deprecated tables.
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 |
Plugin Key | Table Name | Tempo Data |
|---|---|---|
Tempo Platform | AO_BEE373_INTERNAL_ISSUE | Internal Issues |
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 |
|---|---|
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 |
|---|---|---|
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 |
|---|---|---|
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 |
|---|---|---|
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 |