Schema for Focus

Focus drives enterprise-wide outcomes by connecting strategic priorities to goals and the supporting work, teams, and funds. Read more about Focus.

If you add Focus data to an Atlassian Data Lake connection, you can query that data from the following tables:

Columns with an asterisk (*) are only available when you include all data for your app in a Data Lake connection. Read more about how to set the scope of data for Atlassian Data Lake connections.

Tables for focus area data

There are several tables for focus area data:

Focus area
Focus area status update
Focus area sub-focus area mapping
Focus area type

Focus area

The focus_area table contains the latest information for all focus areas.

The table uses the following columns:

Created at

The date and time (UTC time zone) when the focus area was created.

SQL name	`created_at`
Data type	Datetime

Focus area ID

The unique identifier of the focus area. Use this as the primary key for focus area data.

SQL name	`focus_area`
Data type	String

Focus area type ID

The unique identifier of the focus area type.

SQL name	`focus_area_type_id`
Data type	String
Foreign key	Links to a record in the `focus_area_type` table.

Health*

The health of the focus area.

SQL name	`health`
Data type	String
Example values	off track at risk on track

Lifecycle status*

Represents the lifecycle of a focus area, which can be in an active, archived, or draft state.

SQL name	`lifecycle_status`
Data type	String
Example values	active archived draft

Name*

The name of the focus area.

SQL name	`name`
Data type	String

Owned by

The unique identifier of the owner of the the focus area.

SQL name	`owned_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Parent focus area ID

The unique identifier of the parent focus area.

SQL name	`parent_focus_area_id`
Data type	String
Foreign key	Links to another record in the `focus_area` table.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Status*

The status of the focus area.

SQL name	`status`
Data type	String
Example values	pending in progress paused completed

Target date*

The target date of the focus area.

SQL name	`target_date`
Data type	Date

Target date type*

The type of target date for the focus area.

SQL name	`target_date_type`
Data type	String
Example values	DAY MONTH QUARTER

Updated at

The date and time (UTC time zone) when the focus area was last updated.

SQL name	`updated_at`
Data type	Datetime

URL*

The URL of the focus area.

SQL name	`url`
Data type	String
Example value	https://test.focus.com/focus/focus-area/01bf6913-eefd-4c24-8afd-5c02797a88b8

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Focus area status update

The focus_area_status_update table contains the latest information on status updates made to each focus area.

The table uses the following columns:

Created at

The date and time (UTC time zone) when the status update was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the status update.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Focus area ID

The unique identifier of the focus area.

SQL name	`focus_area_id`
Data type	String
Foreign key	Links to a record in the `focus_area` table.

Focus area status update ID

The unique identifier of the status update. Use this as the primary key for focus area status update data.

SQL name	`focus_area_status_update_id`
Data type	String

New health*

The new health value given to the focus area in the status update.

SQL name	`new_health`
Data type	String
Example value	on track

New status*

The new status value given to the focus area in the status update.

SQL name	`new_status`
Data type	String
Example value	in progress

New target date*

The new target date given to the focus area in the status update.

SQL name	`new_target_date`
Data type	Date

New target date type*

The new type of target date given to the focus area in the status update.

SQL name	`new_target_date_type`
Data type	String
Example values	DAY MONTH QUARTER

Previous health*

The previous health value of the focus area before the status update.

SQL name	`previous_health`
Data type	String
Example value	at risk

Previous status*

The previous status value of the focus area before the status update.

SQL name	`previous_status`
Data type	String
Example value	pending

Previous target date*

The previous target date of the focus area before the status update.

SQL name	`previous_target_date`
Data type	Date

Previous target date type*

SQL name	`previous_target_date_type`
Data type	String
Example value	DAY MONTH QUARTER

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Updated at

The date and time (UTC time zone) when the status update of the focus area was last updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who last updated the status update.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

URL*

The URL of the status update.

SQL name	`url`
Data type	String

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Focus area sub-focus area mapping

The focus_area_sub_focus_area_mapping table holds associations between focus areas and their sub-focus areas.

The table uses the following columns:

Focus area ID

The unique identifier of the focus area.

SQL name	`focus_area_id`
Data type	String
Foreign key	Links to a record in the `focus_area` table.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Sub-focus area ID

The unique identifier of the sub-focus area.

SQL name	`sub_focus_area_id`
Data type	String
Foreign key	Links to a record in the `focus_area` table.

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Focus area type

The focus_area_type table contains the latest information on your focus area types. Read more about focus area types.

The table uses the following columns:

Created at

The date and time (UTC time zone) when the focus area type was created.

SQL name	`created_at`
Data type	Datetime

Focus area type ID

The unique identifier of the focus area type. Use this as the primary key for focus area type data.

SQL name	`focus_area_type_id`
Data type	String

Level*

The hierarchy level of the focus area type. 0 is the highest hierarchy level.

SQL name	`level`
Data type	Number

Name*

The name of the focus area type.

SQL name	`name`
Data type	String

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Updated at

The date and time (UTC time zone) when the focus area type was last updated.

SQL name	`updated_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Table for custom field data

Focus area custom field definition

The focus_area_custom_field_definition table holds the definitions of custom fields for focus areas.

Created at

The date and time (UTC time zone) when the custom field definition was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the custom field definition.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Custom field definition ID

The unique identifier of a custom field definition. Use this as the primary key for custom field definitions.

SQL name	`custom_field_definition_id`
Data type	String

Description

More details about the custom field definition.

SQL name	`description`
Data type	String

Name

The name of the custom field definition.

SQL name	`name`
Data type	String
Example values	`Team Name` `T-Shirt Size`

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Search key

A system-generated key used for performing searches against the custom field definition.

SQL name	`search_key`
Data type	String
Example values	`custom_field_h6D7y`

Type

Represents the type of a custom field definition.

SQL name	`type`
Data type	String
Example values	TEXT NUMBER DATE SINGLE_SELECT MULTI_SELECT

Updated at

The date and time (UTC time zone) when the custom field definition was last updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who last updated the custom field definition.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Focus area custom field saved value

The focus_area_custom_field_saved_value table holds the values of the custom fields for focus areas.

Created at

The date and time (UTC time zone) when the custom field definition was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the value of the custom field for the focus area.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Custom field definition ID

The unique identifier of the custom field definition associated with the saved value.

SQL name	`custom_field_definition_id`
Data type	String
Foreign key	Links to a record in the `focus_area_custom_field_definition` table.

Custom field saved value ID

The unique identifier for a custom field. Use this as the primary key for saved values of custom fields.

SQL name	`custom_field_saved_valueid`
Data type	String

Focus area ID

The unique identifier of the focus area in which the value of the custom field is set.

SQL name	`focus_area_id`
Data type	String
Foreign key	Links to a record in the `focus_area` table.

Number value

The value of the custom field if its type is NUMBER.

SQL name	`number_value`
Data type	Number

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Text value

The value of the custom field if its type is TEXT.

SQL name	`text_value`
Data type	String

Updated at

The date and time (UTC time zone) when the custom field saved value was last updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who last updated the custom field saved value.

SQL name	`updated_at`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Table for Align project data

Align project

The align_project table contains the latest information on all your Align projects.

The table uses the following columns:

Created at

The date and time (UTC time zone) when the Align project was created.

SQL name	`created_at`
Data type	Datetime

Name*

The name of the Align project.

SQL name	`name`
Data type	String

Project ID

The unique identifier of the Align project. Use this as the primary key for Align project data.

SQL name	`project_id`
Data type	String

Project type*

The type of Align project.

SQL name	`project_type`
Data type	String
Example values	Epic Theme Capability

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Status*

The status of the Align project.

SQL name	`status`
Data type	String

Target date*

The target date of the Align project.

SQL name	`target_date`
Data type	Datetime

Updated at

The date and time (UTC time zone) when the Align project was last updated.

SQL name	`updated_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Tables for relationships across apps

These tables help to connect data from this schema to data from other app schemas in the Atlassian Data Lake. You can query these tables if at least one of the apps is included in the Data Lake connection. However, if both apps aren’t included, the relevant tables won’t have data.

Focus area Align project mapping

The focus_area_align_project_mapping table holds associations between focus areas and Align projects.

The table uses the following columns:

Align project ID

The unique identifier of the Align project.

SQL name	`align_project_id`
Data type	String
Foreign key	Links to a record in the `align_project` table.

Focus area ID

The unique identifier of the focus area.

SQL name	`focus_area_id`
Data type	String
Foreign key	Links to a record in the `focus_area` table.

Focus workspace ID

The unique identifier of the workspace that the focus area belongs to.

SQL name	`focus_workspace_id`
Data type	String
Foreign key	Links to a record in the workspace table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Focus area Atlassian project mapping

The focus_area_atlassian_project_mapping table holds associations between focus areas from the Focus app and Atlassian projects.

The table uses the following columns:

Focus area ID

The unique identifier of a focus area.

SQL name	`focus_area_id`
Data type	String
Foreign key	Links to a record in the `focus_area` table in the schema for Focus.

Focus workspace ID

An Atlassian identifier that maps to the Focus instance that the focus area belongs to.

SQL name	`focus_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Project ID

The unique identifier of an Atlassian project.

SQL name	`project_id`
Data type	String
Foreign key	Links to a record in the `atlassian_project` table in the schema for Atlassian Projects.

Project workspace ID

An Atlassian identifier that maps to the Atlassian Projects instance that the project belongs to.

SQL name	`project_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Updated at

The date and time (UTC time zone) when the association between the focus area and the Atlassian project was last updated.

SQL name	`updated_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Focus area Goal mapping

The focus_area_goal_mapping table holds associations between focus areas from Focus and goals from the Goals app.

The table uses the following columns:

Focus area ID

The unique identifier of a focus area.

SQL name	`focus_area_id`
Data type	String
Foreign key	Links to a record in the `focus_area` table in the schema for Focus.

Focus workspace ID

An Atlassian identifier that maps to the Focus instance that the focus area belongs to.

SQL name	`focus_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Goal ID

The unique identifier of a goal.

SQL name	`goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table in the schema for Goals.

Goal workspace ID

An Atlassian identifier that maps to the Goals instance that the goal belongs to.

SQL name	`goal_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Updated at

The date and time (UTC time zone) when the association between the focus area and the goal was last updated.

SQL name	`updated_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Focus area Jira work item mapping

The focus_area_jira_issue_mapping table holds associations between focus areas and Jira work items.

The table uses the following columns:

Focus area ID

The unique identifier of the focus area.

SQL name	`focus_area_id`
Data type	String
Foreign key	Links to a record in the `focus_area` table in the schema for focus.

Focus workspace ID

An Atlassian identifier that maps to the Focus instance that the focus area belongs to.

SQL name	`focus_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Jira workspace ID

An Atlassian identifier that maps to the Jira instance that the work item belongs to.

SQL name	`jira_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Updated at

The date and time (UTC time zone) when the association between the focus area and the Jira work item was last updated.

SQL name	`updated_at`
Data type	Datetime

Work item ID

The unique identifier of the Jira work item.

SQL name	`issue_id`
Data type	String
Foreign key	Links to a record in the `jira_issue` table in the schema for Jira family of products.

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Focus area Talent position mapping

The focus_area_talent_position_mapping table holds associations between focus areas in Focus and positions in Talent.

The table uses the following columns:

Focus area ID

The unique identifier of the focus area.

SQL name	`focus_area_id`
Data type	String
Foreign key	Links to a record in the `focus_area` table in the schema for Focus.

Focus workspace ID

An Atlassian identifier that maps to the Focus instance that the focus area belongs to.

SQL name	`focus_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Position ID

The unique identifier of the position.

SQL name	`position_id`
Data type	String
Foreign key	Links to a record in the `talent_position` table in the schema for Talent.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Talent workspace ID

An Atlassian identifier that maps to the Talent instance that the position belongs to.

SQL name	`talent_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Tables for Asks data

Ask

The focus_ask table contains the latest information for all asks.

The table uses the following columns:

Ask ID

The unique identifier of the ask. Use this as the primary key for ask data.

SQL name	`ask_id`
Data type	String

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the Workspace table.

Name

The name of the ask.

SQL name	`name`
Data type	String

Description

The description of the ask.

SQL name	`description`
Data type	String

Justification

The justification for the ask.

SQL name	`justification`
Data type	String

Impacted work Atlassian project ID

The unique identifier of the impacted Atlassian project.

SQL name	`impacted_work_atlassian_project_id`
Data type	String
Foreign key	Links to a record in the Project table.

Impacted work Align project ID

The unique identifier of the impacted Align project.

SQL name	`impacted_work_align_project_id`
Data type	String
Foreign key	Links to a record in the Align project table.

Impacted work Jira work item ID

The unique identifier of the impacted Jira work item.

SQL name	`impacted_work_jira_issue_id`
Data type	String
Foreign key	Links to a record in the Work item table.

Target date

The target date of the ask.

SQL name	`target_date`
Data type	Date

Target date type

The type of target date for the ask.

SQL name	`target_date_type`
Data type	String

Status

The status of the ask.

SQL name	`status`
Data type	String

Submitter ID

The unique identifier of the person who submitted the ask.

SQL name	`submitted_by`
Data type	String
Foreign key	Links to a record in the Account table.

Owner ID

The unique identifier of the person who owns the ask.

SQL name	`owned_by`
Data type	String
Foreign key	Links to a record in the Account table.

Submitting team ID

The unique identifier of the team that submitted the ask.

SQL name	`submitting_team_id`
Data type	String
Foreign key	Links to a record in the Team table.

Receiving team ID

The unique identifier of the team that received the ask.

SQL name	`receiving_team_id`
Data type	String
Foreign key	Links to a record in the Team table.

Priority

The priority of the ask.

SQL name	`priority`
Data type	String

URL

The URL of the ask.

SQL name	`url`
Data type	String

Proposed date

The proposed date for the ask.

SQL name	`proposed_date`
Data type	Date

Proposed date type

The type of proposed date for the ask.

SQL name	`proposed_date_type`
Data type	String

Proposed by ID

The unique identifier of the person who proposed the date for the ask.

SQL name	`proposed_by`
Data type	String
Foreign key	Links to a record in the Account table.

Created at

The date and time (UTC time zone) when the ask was created.

SQL name	`created_at`
Data type	Datetime

Created by ID

The unique identifier of the person who created the ask.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the Account table.

Updated at

The date and time (UTC time zone) when the ask was last updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who last updated the ask.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the Account table.

Ask comment

The focus_ask_comment table contains the latest information for all ask comments.

The table uses the following columns:

Ask comment ID

The unique identifier of the ask comment. Use this as the primary key for ask comment data.

SQL name	`ask_comment_id`
Data type	String

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Ask ID

The unique identifier of the ask.

SQL name	`ask_id`
Data type	String
Foreign key	Links to a record in the Ask table.

Parent comment ID

The unique identifier of the parent comment.

SQL name	`parent_comment_id`
Data type	String

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the Workspace table.

Comment

The comment text.

SQL name	`comment`
Data type	String

URL

The URL of the ask comment.

SQL name	`url`
Data type	String

Created by ID

The unique identifier of the person who created the ask comment.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the Account table.

Created at

The date and time (UTC time zone) when the ask comment was created.

SQL name	`created_at`
Data type	Datetime

Updated at

The date and time (UTC time zone) when the ask comment was last updated.

SQL name	`updated_at`
Data type	Datetime

Tables for Funds data

Use these tables to query Funds financial data from Focus in Atlassian Analytics. The tables are available in Atlassian Data Lake connections that include Funds data.

To query Funds data, create or edit an Atlassian Data Lake connection that includes Focus, then select Include Funds data. If the option isn’t selected, Funds tables aren’t included in the connection.

Benefit item

The focus_benefit_item table contains the latest information for your Focus benefit items.

Benefit item ID

The unique identifier of the benefit item. Use this as the primary key for benefit item data.

SQL name	`benefit_item_id`
Data type	String

Benefit type ID

The unique identifier of the benefit type.

SQL name	`benefit_type_id`
Data type	String
Foreign key	Links to a record in the `focus_benefit_type` table.

Created at

The date and time in UTC when the benefit item was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the benefit item.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

External ref

The external identifier of the benefit item.

SQL name	`external_ref`
Data type	String

Focus area ID

The unique identifier of the focus area.

SQL name	`focus_area_id`
Data type	String
Foreign key	Links to a record in the `focus_area` table.

Name

The name of the benefit item.

SQL name	`name`
Data type	String
Example value	AI Savings

Updated at

The date and time in UTC when the benefit item was updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who updated the benefit item.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Benefit period value

The focus_benefit_period_value table contains the latest information for your Focus benefit period values.

Amount

The amount for the benefit period value.

SQL name	`amount`
Data type	Number

Benefit item ID

The unique identifier of the benefit item.

SQL name	`benefit_item_id`
Data type	String
Foreign key	Links to a record in the `focus_benefit_item` table.

Benefit period value ID

The unique identifier of the benefit period value. Use this as the primary key for benefit period value data.

SQL name	`benefit_period_value_id`
Data type	String

Created at

The date and time in UTC when the benefit period value was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the benefit period value.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Financial version ID

The unique identifier of the financial version.

SQL name	`financial_version_id`
Data type	String
Foreign key	Links to a record in the `focus_financial_version` table.

Period month

The month associated with the benefit period value.

SQL name	`period_month`
Data type	Date
Example values	2026-03 2026-04

Updated at

The date and time in UTC when the benefit period value was updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who updated the benefit period value.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Benefit type

The focus_benefit_type table contains the latest information for your Focus benefit types.

Benefit type ID

The unique identifier of the benefit type. Use this as the primary key for benefit type data.

SQL name	`benefit_type_id`
Data type	String

Created at

The date and time in UTC when the benefit type was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the benefit type.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Name

The name of the benefit type.

SQL name	`name`
Data type	String
Example value	Productivity gains

Key

The unique key of the benefit type.

SQL name	`key`
Data type	String
Example value	productivity gains

Updated at

The date and time in UTC when the benefit type was updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who updated the benefit type.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Cost item

The focus_cost_item table contains the latest information for your Focus cost items.

Cost item ID

The unique identifier of the cost item. Use this as the primary key for cost item data.

SQL name	`cost_item_id`
Data type	String

Cost subtype ID

The unique identifier of the cost subtype.

SQL name	`cost_subtype_id`
Data type	String
Foreign key	Links to a record in the `focus_cost_subtype` table.

Cost type

The cost type of the cost item.

SQL name	`cost_type`
Data type	String
Example values	labor non_labor

Created at

The date and time in UTC when the cost item was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the cost item.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Expenditure type

The expenditure type of the cost item.

SQL name	`expenditure_type`
Data type	String
Example values	capex opex

External ref

The external identifier of the cost item.

SQL name	`external_ref`
Data type	String

Focus area ID

The unique identifier of the focus area.

SQL name	`focus_area_id`
Data type	String
Foreign key	Links to a record in the `focus_area` table.

Investment category ID

The unique identifier of the investment category.

SQL name	`investment_category_id`
Data type	String
Foreign key	Links to a record in the `focus_investment_category` table.

Name

The name of the cost item.

SQL name	`name`
Data type	String
Example value	Infrastructure

Updated at

The date and time in UTC when the cost item was updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who updated the cost item.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Cost period value

The focus_cost_period_value table contains the latest information for your Focus cost period values.

Amount

The amount for the cost period value.

SQL name	`amount`
Data type	Number

Cost item ID

The unique identifier of the cost item.

SQL name	`cost_item_id`
Data type	String
Foreign key	Links to a record in the `focus_cost_item` table.

Cost period value ID

The unique identifier of the cost period value. Use this as the primary key for cost period value data.

SQL name	`cost_period_value_id`
Data type	String

Created at

The date and time in UTC when the cost period value was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the cost period value.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Financial version ID

The unique identifier of the financial version.

SQL name	`financial_version_id`
Data type	String
Foreign key	Links to a record in the `focus_financial_version` table.

Period month

The month associated with the cost period value.

SQL name	`period_month`
Data type	Date
Example values	2026-03 2026-04

Updated at

The date and time in UTC when the cost period value was updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who updated the cost period value.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Cost subtype

The focus_cost_subtype table contains the latest information for your Focus cost subtypes.

Cost subtype ID

The unique identifier of the cost subtype. Use this as the primary key for cost subtype data.

SQL name	`cost_subtype_id`
Data type	String

Cost type

The cost type of the cost subtype.

SQL name	`cost_type`
Data type	String
Example values	labor non_labor

Created at

The date and time in UTC when the cost subtype was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the cost subtype.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Name

The name of the cost subtype.

SQL name	`name`
Data type	String
Example value	Contractors

Key

The unique key of the cost subtype.

SQL name	`key`
Data type	String
Example value	contractors

Updated at

The date and time in UTC when the cost subtype was updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who updated the cost subtype.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Financial version

The focus_financial_version table contains the latest information for your Focus financial versions.

Created at

The date and time in UTC when the financial version was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the financial version.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Financial version ID

The unique identifier of the financial version. Use this as the primary key for financial version data.

SQL name	`financial_version_id`
Data type	String

Name

The name of the financial version.

SQL name	`name`
Data type	String
Example value	Forecast

Type

The type of the financial version.

SQL name	`type`
Data type	String
Example values	forecast actual baseline baseline_revision

Updated at

The date and time in UTC when the financial version was updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who updated the financial version.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Fiscal calendar configuration

The focus_fiscal_calendar_configuration table contains the latest information for your Focus fiscal calendar configurations.

Created at

The date and time in UTC when the fiscal calendar configuration was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the fiscal calendar configuration.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Effective until

The effective end date and time (UTC time zone) of the fiscal calendar configuration.

SQL name	`effective_until`
Data type	Datetime

Effective start at

The effective start date and time (UTC time zone) of the fiscal calendar configuration.

SQL name	`effective_start_at`
Data type	Datetime

Fiscal calendar configuration ID

The unique identifier of the fiscal calendar configuration. Use this as the primary key for fiscal calendar configuration data.

SQL name	`fiscal_calendar_configuration_id`
Data type	String

Is active

Whether the fiscal calendar configuration is active.

SQL name	`is_active`
Data type	Boolean

Start month number

The start month number of the fiscal year represented by 1-12.

SQL name	`start_month_number`
Data type	Number

Updated at

The date and time in UTC when the fiscal calendar configuration was updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who updated the fiscal calendar configuration.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Focus area budget

The focus_area_budget table contains the latest information for your Focus focus area budgets.

Amount

The amount value of the focus area budget.

SQL name	`amount`
Data type	Number

Created at

The date and time in UTC when the focus area budget was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the focus area budget.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Fiscal year

The fiscal year for the focus area budget.

SQL name	`fiscal_year`
Data type	Number
Example values	2026 2025

Focus area ID

The unique identifier of the focus area.

SQL name	`focus_area_id`
Data type	String
Foreign key	Links to a record in the `focus_area` table.

Focus area budget ID

The unique identifier of the focus area budget. Use this as the primary key for focus area budget data.

SQL name	`focus_area_budget_id`
Data type	String

Updated at

The date and time in UTC when the focus area budget was updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who updated the focus area budget.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Investment category

The focus_investment_category table contains the latest information for your Focus investment categories.

Key

The unique key of the investment category.

SQL name	`key`
Data type	String
Example value	research

Created at

The date and time in UTC when the investment category was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the investment category.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Investment category ID

The unique identifier of the investment category. Use this as the primary key for investment category data.

SQL name	`investment_category_id`
Data type	String

Name

The name of the investment category.

SQL name	`name`
Data type	String
Example value	Research

Updated at

The date and time in UTC when the investment category was updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who updated the investment category.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Relationship tables for Funds data

These mapping tables connect Funds benefit and cost items to related Align projects, Atlassian projects, and Jira work items.

Benefit item Align project mapping

The benefit_item_align_project_mapping table contains associations between benefit items and Align projects.

Align project ID

The unique identifier of the Align project.

SQL name	`align_project_id`
Data type	String
Foreign key	Links to a record in the `align_project` table.

Benefit item ID

The unique identifier of the benefit item.

SQL name	`benefit_item_id`
Data type	String
Foreign key	Links to a record in the `focus_benefit_item` table.

Focus workspace ID

The unique identifier of the workspace that the benefit item belongs to.

SQL name	`focus_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Benefit item Atlassian project mapping

The benefit_item_atlassian_project_mapping table contains associations between benefit items and Atlassian projects.

Benefit item ID

The unique identifier of the benefit item.

SQL name	`benefit_item_id`
Data type	String
Foreign key	Links to a record in the `focus_benefit_item` table.

Focus workspace ID

An Atlassian identifier that maps to the Focus instance that the benefit item belongs to.

SQL name	`focus_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Project ID

The unique identifier of an Atlassian project.

SQL name	`project_id`
Data type	String
Foreign key	Links to a record in the `atlassian_project` table in the schema for Atlassian Projects.

Project workspace ID

An Atlassian identifier that maps to the Atlassian Projects instance that the project belongs to.

SQL name	`project_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Updated at

The date and time in UTC when the association between the benefit item and the Atlassian project was last updated.

SQL name	`updated_at`
Data type	Datetime

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Benefit item Jira work item mapping

The focus_benefit_item_jira_issue_mapping table contains associations between benefit items and Jira work items.

Benefit item ID

The unique identifier of the benefit item.

SQL name	`benefit_item_id`
Data type	String
Foreign key	Links to a record in the `focus_benefit_item` table.

Focus workspace ID

An Atlassian identifier that maps to the Focus instance that the benefit item belongs to.

SQL name	`focus_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Jira workspace ID

An Atlassian identifier that maps to the Jira instance that the work item belongs to.

SQL name	`jira_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Updated at

The date and time in UTC when the association between the benefit item and the Jira work item was last updated.

SQL name	`updated_at`
Data type	Datetime

Work item ID

The unique identifier of the Jira work item.

SQL name	`issue_id`
Data type	String
Foreign key	Links to a record in the `jira_issue` table in the schema for Jira family of products.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Cost item Align project mapping

The cost_item_align_project_mapping table contains associations between cost items and Align projects.

Align project ID

The unique identifier of the Align project.

SQL name	`align_project_id`
Data type	String
Foreign key	Links to a record in the `align_project` table.

Cost item ID

The unique identifier of the cost item.

SQL name	`cost_item_id`
Data type	String
Foreign key	Links to a record in the `focus_cost_item` table.

Focus workspace ID

The unique identifier of the workspace that the cost item belongs to.

SQL name	`focus_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Cost item Atlassian project mapping

The cost_item_atlassian_project_mapping table contains associations between cost items and Atlassian projects.

Cost item ID

The unique identifier of the cost item.

SQL name	`cost_item_id`
Data type	String
Foreign key	Links to a record in the `focus_cost_item` table.

Focus workspace ID

An Atlassian identifier that maps to the Focus instance that the cost item belongs to.

SQL name	`focus_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Project ID

The unique identifier of an Atlassian project.

SQL name	`project_id`
Data type	String
Foreign key	Links to a record in the `atlassian_project` table in the schema for Atlassian Projects.

Project workspace ID

An Atlassian identifier that maps to the Atlassian Projects instance that the project belongs to.

SQL name	`project_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Updated at

The date and time in UTC when the association between the cost item and the Atlassian project was last updated.

SQL name	`updated_at`
Data type	Datetime

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Cost item Jira work item mapping

The focus_cost_item_jira_issue_mapping table contains associations between cost items and Jira work items.

Cost item ID

The unique identifier of the cost item.

SQL name	`cost_item_id`
Data type	String
Foreign key	Links to a record in the `focus_cost_item` table.

Focus workspace ID

An Atlassian identifier that maps to the Focus instance that the cost item belongs to.

SQL name	`focus_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Jira workspace ID

An Atlassian identifier that maps to the Jira instance that the work item belongs to.

SQL name	`jira_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Updated at

The date and time in UTC when the association between the cost item and the Jira work item was last updated.

SQL name	`updated_at`
Data type	Datetime

Work item ID

The unique identifier of the Jira work item.

SQL name	`issue_id`
Data type	String
Foreign key	Links to a record in the `jira_issue` table in the schema for Jira family of products.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	`row_refreshed_at`
Data type	Datetime

Workspace ID

An Atlassian identifier that maps data to a site in the workspace table.

SQL name	`workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Was this helpful?

It wasn't accurateIt wasn't clearIt wasn't relevant

Still need help?

The Atlassian Community is here for you.

Ask the Community