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:
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 |
|
---|---|
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 |
|
---|---|
Data type | String |
Focus area type ID
The unique identifier of the focus area type.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Health
The health of the focus area.
SQL name |
|
---|---|
Data type | String |
Example values |
|
Lifecycle status
Represents the lifecycle of a focus area, which can be in an active, archived, or draft state.
SQL name |
|
---|---|
Data type | String |
Example values |
|
Name
The name of the focus area.
SQL name |
|
---|---|
Data type | String |
Owned by
The unique identifier of the owner of the the focus area.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Parent focus area ID
The unique identifier of the parent focus area.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to another record in the |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Status
The status of the focus area.
SQL name |
|
---|---|
Data type | String |
Example values |
|
Target date
The target date of the focus area.
SQL name |
|
---|---|
Data type | Date |
Target date type
The type of target date for the focus area.
SQL name |
|
---|---|
Data type | String |
Updated at
The date and time (UTC time zone) when the focus area was last updated.
SQL name |
|
---|---|
Data type | Datetime |
URL
The URL of the focus area.
SQL name |
|
---|---|
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 |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
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 |
|
---|---|
Data type | Datetime |
Created by
The unique identifier of the person who created the status update.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Focus area ID
The unique identifier of the focus area.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
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 |
|
---|---|
Data type | String |
New health
The new health value given to the focus area in the status update.
SQL name |
|
---|---|
Data type | String |
Example value | on track |
New status
The new status value given to the focus area in the status update.
SQL name |
|
---|---|
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 |
|
---|---|
Data type | Date |
New target date type
The new type of target date given to the focus area in the status update.
SQL name |
|
---|---|
Data type | String |
Example values |
|
Previous health
The previous health value of the focus area before the status update.
SQL name |
|
---|---|
Data type | String |
Example value | at risk |
Previous status
The previous status value of the focus area before the status update.
SQL name |
|
---|---|
Data type | String |
Example value | pending |
Previous target date
The previous target date of the focus area before the status update.
SQL name |
|
---|---|
Data type | Date |
Previous target date type
SQL name |
|
---|---|
Data type | String |
Example value |
|
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
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 |
|
---|---|
Data type | Datetime |
Updated by
The unique identifier of the person who last updated the status update.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
URL
The URL of the status update.
SQL name |
|
---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
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 |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Sub-focus area ID
The unique identifier of the sub-focus area.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
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 |
|
---|---|
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 |
|
---|---|
Data type | String |
Level
The hierarchy level of the focus area type. 0 is the highest hierarchy level.
SQL name |
|
---|---|
Data type | Number |
Name
The name of the focus area type.
SQL name |
|
---|---|
Data type | String |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Updated at
The date and time (UTC time zone) when the focus area type was last updated.
SQL name |
|
---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
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 |
|
---|---|
Data type | Datetime |
Name
The name of the Align project.
SQL 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 |
|
---|---|
Data type | String |
Project type
The type of Align project.
SQL name |
|
---|---|
Data type | String |
Example values |
|
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Status
The status of the Align project.
SQL name |
|
---|---|
Data type | String |
Target date
The target date of the Align project.
SQL name |
|
---|---|
Data type | Datetime |
Updated at
The date and time (UTC time zone) when the Align project was last updated.
SQL name |
|
---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
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 |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Focus area ID
The unique identifier of the focus area.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Focus workspace ID
The unique identifier of the workspace that the focus area belongs to.
SQL name |
|
---|---|
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 |
|
---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
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 |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Focus workspace ID
An Atlassian identifier that maps to the Focus instance that the focus area belongs to.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Project ID
The unique identifier of an Atlassian project.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Project workspace ID
An Atlassian identifier that maps to the Atlassian Projects instance that the project belongs to.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
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 |
|
---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
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 |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Focus workspace ID
An Atlassian identifier that maps to the Focus instance that the focus area belongs to.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal ID
The unique identifier of a goal.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Goal workspace ID
An Atlassian identifier that maps to the Goals instance that the goal belongs to.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
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 |
|
---|---|
Data type | Datetime |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
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 |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Focus workspace ID
An Atlassian identifier that maps to the Focus instance that the focus area belongs to.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Jira workspace ID
An Atlassian identifier that maps to the Jira instance that the work item belongs to.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
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 |
|
---|---|
Data type | Datetime |
Work item ID
The unique identifier of the Jira work item.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
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 |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Focus workspace ID
An Atlassian identifier that maps to the Focus instance that the focus area belongs to.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Position ID
The unique identifier of the position.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Row refreshed at
The last refresh time (UTC time zone) for this record.
SQL name |
|
---|---|
Data type | Datetime |
Talent workspace ID
An Atlassian identifier that maps to the Talent instance that the position belongs to.
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace
table
SQL name |
|
---|---|
Data type | String |
Foreign key | Links to a record in the |
Was this helpful?