Integrated Data

What this page covers: A complete reference mapping every BQE Core field to its Mosaic equivalent. Use this guide when configuring your integration, verifying synced data, or troubleshooting discrepancies.


Integration type	Cloud (BQE Core API)
Setup complexity	Low
Prerequisite	BQE Core Integration Setup

How Data Flows

BQE Core (BQE Core API) → Mosaic Sync Engine (field mapping) → Mosaic (8 synced data types)

Mosaic pulls data from BQE Core using the BQE Core API. Employees, clients, projects, phases, time entries, and rate information are mapped into Mosaic's data model.

Integrated Data Types

The integration syncs 9 data categories from BQE Core into Mosaic:

#	Data Type	Description
1	Employees	Staff records with names, emails, roles, and cost rates
2	Clients	Client records
3	Projects	Project records with titles, fees, clients, and schedules
4	Phases	Phase breakdowns under projects
5	Time Entries	Time records with hours, rates, and billability
6	Team Roles	Role assignments for team members
7	Member Bill Rate	Employee billing rate assignments
8	Member Cost Rate	Employee cost rate assignments
9	Role Rate Groups	Rate groups with role-based billing and cost rates

This list may expand as new features are added.

Reading the Field Mapping Tables

Symbol legend for technical tables

The Technical Reference tabs below use a shorthand notation for API sources. Read this legend before reviewing the mappings.

Symbol	Meaning	Example
`.`	API object field reference	`Employee.Name` = the Name field from the Employee object

Detailed Field Mappings

Employees

What Syncs to Mosaic	Where It Comes From in BQE Core
Employee Name	The employee's name
Employee Email	The employee's email address
Default Role	The employee's default role (optional)
Default Cost Rate	The employee's default cost rate (optional)

Clients

What Syncs to Mosaic	Where It Comes From in BQE Core
Client Name	The client's name

Projects

What Syncs to Mosaic	Where It Comes From in BQE Core
Project Title	The project title
Project Fee	The project fee amount
Client	The client linked to the project
Schedules	The project schedule (start/end dates)

Phases

What Syncs to Mosaic	Where It Comes From in BQE Core
Phase Title	The phase title
Phase Fee	The phase fee amount
Client	The client linked to the phase's project
Schedules	The phase schedule (start/end dates)

Time Entries

What Syncs to Mosaic	Where It Comes From in BQE Core
Date	The date of the time entry
Hours	The number of hours logged
Member	The employee who logged the time
Project	The project the time was logged against
Phase	The phase the time was logged against
Work Category	The activity/labor code used for the time entry
Description	The time entry description
Billable	Whether the time entry is billable
Rate	The billing rate for the time entry

Team Roles

What Syncs to Mosaic	Where It Comes From in BQE Core
Team Role	Role assignments linking employees to team roles

Member Bill Rate

What Syncs to Mosaic	Where It Comes From in BQE Core
Member Bill Rate	The employee's billing rate assignment

Member Cost Rate

What Syncs to Mosaic	Where It Comes From in BQE Core
Member Cost Rate	The employee's cost rate assignment

BQE Core Documentation Links

A consolidated reference of all BQE Core documentation referenced in this guide:

Topic	Link
API Explorer	BQE Core API Explorer
BQE Core Help	BQE Core Support