Integrated Data
Integrated Data Types
By integrating your Deltek Costpoint Cloud data with Mosaic, you will be able to import the following:
- Employees
- Clients
- Projects, Phases
- Profit Center (Costpoint Organizations)
- Departments (Costpoint Organizations)
- Time Entries
- Bill Rates
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!
If new features require additional permissions, your Customer Success Manager will reach out to request that they be added to the role you have assigned to the Mosaic user.
Integrated Data Fields
Data Sources
Costpoint Data Types | Mosaic Data Types |
---|---|
People → Employee → Basic Employee Information - First Name - Last Name - Work Email - Detail Job Title | Employee - Name - Title |
Projects → Project Setup → Project Master - Project Name (Level 1) | Client - Title |
Projects → Project Setup → Project Master - Project Name (Project: Level 2, Phase: Level 3, Subphase: Level 4) - Funding Modification Value - Project Name (Client) - Start Date - End Date - Task Value - Organization | Project, Phase - Title - Fee - Client (Projects only) - Start Date (Phases only) - End Date (Phases only) - Phase Budgeted Hours - Profit Center |
Time & Expense → Time → Timesheets - Project - Phase - Date - Employee - Hours - Billable - Bill RateTime Entries Synchronization in Mosaic:By default, time entries synchronized to Mosaic include only time entries with Approved status.Should you prefer to synchronize all time entries from Costpoint, please contact your Customer Success Manager for assistance. | Time Entry - Project - Phase - Date - Employee - Hours - Billable - Rate |
Accounting → General Ledger → Organizations - Code - Name | Department - Name |
Projects → Project Setup → Project Labor → Link Project Labor Category Rates to Projects - PLC Description - Rate - Starting Date - Ending Date | Rate Group - Role - Rate - Start Date - End Date |
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.
Updated 2 months ago