Integration Guides

Integrated Data

Suggest Edits

Integrated Data Types

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

  • Employees
  • Clients
  • Projects, Phases (Vision Tasks)
    • Vision Profit Centers **
  • Time Entries **
  • Vision Labor Codes
  • Bill Rates
  • Roles

📘

Please Note:

** These data types are available through stored procedures. Please see Adding Stored Procedures to Vision for more details.

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

Vision Data TypesMosaic Data Types
Info Center → Employees

- Name → First + Middle + Last
- Email
- Billing Category
- Job Cost Rate (Optional)		Employee

- Name
- Email
- Default Role
- Default Cost Rate (Optional)
Info Center → Clients → General

- Name		Client

- Title
Info Center → Projects

- Budget & Revenue → Compensation → Direct Labor
- Budget & Revenue → Compensation → Direct Expense
- Budget & Revenue → Compensation → Direct Consultant
- General → Short Name
- General → Client Address
- General → Primary Client
- General → Project
- General → Status
- Dates & Cost → Initial Dates → Start
- Dates & Cost → Initial Dates → ActCompletionDate
- General → Phase (only visible on 2nd project level)
- General → Task (only visible on 3rd project level)
- Accounting → Project Currency (only visible on 1st project level)		Project, Phase, Work Category

- Fee
- Title
- Client (Projects only)
- Schedules (Work Category only)
- Currency (Projects only)
Time & Expense → Timesheet → Timesheet Detail Grid

- Project
- Phase
- Task
- Period Ending (in header record)
- Employee reference (in header record)
- Comment
- Reg (In Detail Block below grid)
- Ovt (in Detail Block below grid)
- Labor Code		Time Entry

- Date
- Hours
- Account
- Project
- Phase
- Work Category
- Description
- Billable
- Rate
Configuration → Planning → Generic Resources → Labor Codes (Only visible if Planning module installed)

- Code
- Name		Work Category

- Number
- Title
Configuration → Codes → Organization

- Code
- Label		Employee

- Organization

📘

Time Entries Synchronization in Mosaic:

To synchronize Time Entries from Vision Cloud to Mosaic, a Stored Procedure is necessary. For a step-by-step guide on how to implement this, refer to the Adding Stored Procedures to Vision documentation.

By default, time entries synchronized to Mosaic include both unposted and posted time entries.

Should you prefer to synchronize only the posted time entries from Vision, please contact your Customer Success Manager for assistance.

🚧

Alternative Fee Fields:

For more information about default and alternative Project and Phase Fee fields, please refer to this documentation.

❗️

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.
  • WBS Fee information from any location other than:
    • Projects Info Center
    • Billing Terms Section (users are required to maintain this data so that it can be integrated reliably)

👍

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 3 months ago