Integration Guides

Integrated Data

Suggest Edits

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 TypesMosaic Data Types
People → Employee → Basic Employee Information

- First Name
- Last Name
- Work Email
- Detail Job Title		Employee

- Name
- Email
- 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 about 2 months ago