Integrated Data

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


Integration type	On-Premise (Direct Database Access)
Setup complexity	Moderate
Prerequisite	BST10 Integration Setup

How Data Flows

BST10 (Direct Database Access) → Mosaic Sync Engine (field mapping + replication) → Mosaic (7 synced data types)

Mosaic replicates a subset of BST10 database tables and maps them into Mosaic data types. Only posted timesheet data is integrated — unposted time entries are not synced.

Integrated Data Types

The integration syncs 7 data categories from BST10 into Mosaic:

#	Data Type	Description
1	Employees	Staff records with names, emails, and roles
2	Clients	Client records
3	Projects	Project records including fees, dates, and billable status
4	Phases	Task/phase breakdowns under projects
5	Time Entries	Posted timesheet data with hours, projects, and employees
6	Bill Rates	Billing rate schedules linking employees to rates
7	Roles	Labor bill classes used for role assignments

This list may expand as new features are added. When a new feature is added, your Customer Success Manager will reach out requesting access to your server to update your replication.

Reading the Field Mapping Tables

Symbol legend for technical tables

The Technical Reference tabs below use a shorthand notation for BST10 database field references. Read this legend before reviewing the mappings.

Symbol	Meaning	Example
`.`	Database table field reference	`Employee.GivenName` = the GivenName field from the Employee table
`_`	Nested table relationship	`Project_Task.Name` = the Name field from the Project_Task child table

Detailed Field Mappings

Employees

What Syncs to Mosaic	Where It Comes From in BST10
Employee Name	The employee's first, middle, and last name
Email	The employee's email address
Role	The employee's labor bill class assignment

Clients

What Syncs to Mosaic	Where It Comes From in BST10
Client Name	The client display name
Client ID	The unique client identifier
Client Code	The client code

Projects

What Syncs to Mosaic	Where It Comes From in BST10
Project Name	The project name from the Project record
Project Number	The project code
Client	The client linked to the project
Fee	The project fee amount (total budget effort)
Start Date	The project start date
End Date	The project finish date
Billable Status	Whether the project has chargeable time enabled
Status	The project status value

Phases

What Syncs to Mosaic	Where It Comes From in BST10
Phase Name	The task/phase name
Phase Number	The task/phase code
Start Date	The phase start date
End Date	The phase finish date
Fee	The phase fee percentage (BillFeePc)
Billable Status	Whether the phase has chargeable time enabled
Status	The phase effective status
Budget	The budgeted effort for the phase
Hierarchy	The phase hierarchy code and parent node relationships

Time Entries

Important: Only posted timesheet data is integrated. Unposted time entries are not synced from BST10.

What Syncs to Mosaic	Where It Comes From in BST10
Date	The transaction date of the time entry
Hours	The quantity of hours logged
Project	The project the time was logged against
Phase	The task/phase the time was logged against
Employee	The employee who logged the time
Billable	Whether the time entry is billable
Description	The posting description for the time entry

Bill Rates

What Syncs to Mosaic	Where It Comes From in BST10
Employee	The employee the bill rate applies to
Bill Rate	The regular billing rate for the employee
Rate Schedule	The labor bill rate schedule the rate belongs to
Effective Date	When the rate becomes effective

Roles

What Syncs to Mosaic	Where It Comes From in BST10
Role ID	The labor bill class identifier
Role Name	The labor bill class name

Troubleshooting & FAQ

Why are my time entries not showing up?

Only posted timesheet data is integrated from BST10. Ensure your timesheets are posted before expecting them to appear in Mosaic.

Can I rename field names in Mosaic to match custom labelling in BST10?

No. Custom field name changes in Mosaic to match BST10 labeling is not supported as a standard integration feature.

I need a data source or field that isn't listed here.

Any integration not listed in this documentation is considered a customization and is charged at an hourly rate. For more information, see Integration Requests.

BST Global Documentation Links

A consolidated reference of all BST Global documentation referenced in this guide:

Topic	Link
BST Global Support	BST Global Support Portal
BST Global Website	BST Global