Integrated Data

Integrated Data Types

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

  • Employees
  • Clients
  • Project, Phases, Tasks
  • Time Entries
  • Work Plans
  • Labor Codes

As Mosaic works on adding more data points to our integration with Deltek Vision on-premise, 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

Vision Data Types

Mosaic Data Types

Info Center → Employees → General

  • Name → First
  • Name → Middle
  • Name → Last
  • Email
  • Title

Employee

  • Name
  • Email
  • Title

Info Center → Clients → General

  • Name

Clients

  • 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 Categories 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

Note: Time Entries synced into Mosaic by default are only those that have been posted in Vision. If you would like to use unposted time instead, please reach out to your Customer Success Manager for more details.

Time Entry

  • Date
  • Hours
  • Client
  • Project
  • Phase
  • Work Category
  • Description
  • Billable
  • Rate

Planning → Project Planning → Labor

  • Project Number
  • Phase Number
  • Task Number
  • Labor Code (Fourth level)
  • Employee
  • Hours (Right Grid)
  • Start
  • Finish

Work Plan

  • Project
  • Phase
  • Work Category
  • Employee
  • Hours
  • Start/End Dates

Configuration → Planning → Generic Resources (Only visible if Planning module installed) → Labor Code

  • Code
  • Name

Work Category

  • Number
  • Title

Configuration → Codes → Organization

  • Code
  • Label

Organization

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 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)

Extended Data Fields

Replicated Data

Mosaic replicates a subset of the data tables that are available in Vision on-premise. The following tables will be included in your replication:

Table Name

Use in Mosaic

BT

Project integration

billFeeDetail

Employee integration

BTROTEmpls

Employee integration (Coming soon)

CA

Budgets (Coming soon)

CAB

Budgets (Coming soon)

CABDetail

Budgets (Coming soon)

CFGEmployeeRoleDescriptions

Employee integration (Coming soon)

CL

Client integration

CostRTEmpls

Employee integration (Coming soon)

EB

Budgets (Coming soon)

ekDetail

Expenses (Coming soon)

EMAccrual

Employee integration (Coming soon)

EMCompany

Employee integration

EMMain

Employee integration

EMProjectAssoc

Project integration (Coming soon)

erDetail

Expenses (Coming soon)

GR

Time Entry integration

inDetail

Invoices (Coming soon)

LB

Budgets

LD

Time Entry integration

OppLabor

Project integration (Coming soon)

Opportunity

Project integration

OpportunityClientAssoc

Client integration (Coming soon)

Organization

Organization filtering

PR

Project integration

PRDescriptions

Project integration (Coming soon)

prDetail

Project integration (Coming soon)

PRF

Project integration (Coming soon)

PRFEPhases

Project integration (Coming soon)

RPAssignment

Work Plan integration

RPPlan

Work Plan integration

RPPlannedLabor

Work Plan integration

RPTask

Work Plan integration

tkDetail

Time Entry integration

tkMaster

Time Entry integration

tsDetail

Time Entry integration

tsMaster

Time Entry integration

For more information on what these tables contain, you can reference the Deltek Vision DataDictionary. It can be found in your Vision application: On the title bar the top of the Vision screen, click "Help" and then "Data Dictionary".