Integrated Data

Integrated Data Types

By integrating your BST10 data with Mosaic, you will be able to import the following:

Employees
Clients
Projects
Phases
Time Entries
Bill Rates
Roles

As Mosaic works on adding more data points to our integration with BST10, this list may change. When a new feature is added to Mosaic, you can expect your Customer Success Manager to reach out requesting access to your server to update your replication.

Integrated Data Fields

Data Sources

BST10 Data Types	Mosaic Data Types
Employee Name Email Role	Employee Name Email Role
Client Name	Clients Title
Project → Info Name Code Client Total Budget Effort Start Date Finish Date BillableProject → Tasks Name Code Budget Effort Start Date Finish Date Billable	Projects Title Project Number Client Fee Start Date End Date BillablePhases Title Phase Number Fee Start Date End Date Billable
Timesheet -- Only Posted Timesheet data is integrated Document Date Hours Project Task Employee	Time Entry Date Hours Project Phase Employee
Project → Pricing → Bill Rate Schedule Item (Employee) Regular Rate	Projects → Member Rates Employee Bill Rate

BST10 Data Types

Mosaic Data Types

Employee

Name
Email
Role

Employee

Name
Email
Role

Client

Name

Clients

Title

Project → Info

Name
Code
Client
Total Budget Effort
Start Date
Finish Date
BillableProject → Tasks
Name
Code
Budget Effort
Start Date
Finish Date
Billable

Projects

Title
Project Number
Client
Fee
Start Date
End Date
BillablePhases
Title
Phase Number
Fee
Start Date
End Date
Billable

Timesheet -- Only Posted Timesheet data is integrated

Document Date
Hours
Project
Task
Employee

Time Entry

Date
Hours
Project
Phase
Employee

Project → Pricing → Bill Rate Schedule

Item (Employee)
Regular Rate

Projects → Member Rates

Employee
Bill Rate

Mosaic is constantly working on adding more features to our integrations; you can expect additional data points to be added to your integration in the near future!

❗️
Unsupported Data Sources

Changing field names in Mosaic to match custom labels in your ERP.

Integrating data types that aren’t listed in the integration documentation.

👍
Customizations:
If you need a data source or endpoint that isn’t listed in the documentation, it will be considered a customization and charged at an hourly rate.
For more information, please see Integration Requests.

Extended Data Fields

Replicated Data

Mosaic replicates a subset of the data tables that are available in BST10. The following tables will be included in your replication:

Table Name	Fields	Use in Mosaic
Client	Id Name Code	Client integration
Employee	Id GivenName FamilyName MiddleName Email FullName BillClass	Employee integration
LaborBillClass	Id Name	Standard Role integration
LaborBillRateSchedule	Id Name	Bill Rate integration
LaborBillRateSchedule_RateType	Id Timestamp ParentId Employee EffectiveDate RateId	Standard Rate integration
LaborBillRateSchedule_RateType_Rate	Id ParentId RegularRateDC OvertimeRateDC EffectiveDate	Standard Rate integration
PostingDescription	Id Description	Time Entry integration
Project	Id Name Client StartDate FinishDate FeeAmount HasChargeable Status Code	Project integration
ProjectDetail	Id TransactionDate Quantity EffortCC Billable Employee Project Task ProjectDescription LaborExpense	Time Entry integration
Project_LaborTerm	ParentId Name LaborBillRateSchedule	Bill Rate integration
Project_LaborTerm_LaborBillRateScheduleOverride	Id ParentId Employee	Bill Rate integration
Project_LaborTerm_LaborBillRateScheduleOverride_Rate	Id RegularRateDC OvertimeRateDC EffectiveDate ParentId	Bill Rate integration
ProjectTaskSummary	Task LaborExpense BudgetEffortCC	Phase integration
Project_Task	Id Name ParentId ParentNodeId StartDate FinishDate BillFeePc HasChargeable EffectiveStatus Code HierarchyCode	Phase integration

Updated 4 days ago