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 - Role | Employee - Name - 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 - 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.
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 - 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 months ago