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
- Budget & Revenue → Direct Consult
- Budget & Revenue → Direct Labor
- 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)		Project, Phase, Work Category
- Title
- Fee
- Client (Projects only)
- Schedules (Work Category 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 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.		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

Unsupported Data Sources

  • Changing field names in Mosaic to match custom labelling in Vision
  • Integrating Data Types that are not explicitly listed in the Vision 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)

🚧

Please Note:

If there is a data endpoint not listed in this documentation and it is required for your integration, it will be a customization, charged at an hourly rate. For more information, please see Integration Requests.

Updated 14 days ago