Integrated Data

Integrated Data Types

By integrating your Vantagepoint On-Premise data with Mosaic, you will be able to import the following:

  • Employees
  • Clients
  • Projects, Phases
  • Time Entries
  • Work Plans
  • Labor Codes

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!

Integrated Data Fields

Data Sources

Vantagepoint Data Types

Mosaic Data Types

Hubs → Employees → Name and Background → Full Name
Hubs -> Employees -> Contact Information → Home Email

Employees

  • Name
  • Email

Hubs → Clients

  • Name

Clients

  • Title

Hubs → Projects → Project → Overview → Long Name
Hubs → Projects → Project → Project Summary → Project Details → Contract
Hubs → Projects → Project → Primary Client
Hubs → Projects → Plan → Schedule

Project, Phases

  • Title
  • Fee
  • Client
  • Schedules

Transaction Center → Transaction Entry → Timesheets → Date
Transaction Center → Transaction Entry → Timesheets → Regular Hours + Overtime Hours
Transaction Center → Transaction Entry → Timesheets → Employee
Transaction Center → Transaction Entry → Timesheets → Project Name
Transaction Center → Transaction Entry → Timesheets → Phase Name
Transaction Center → Transaction Entry → Timesheets → Labor Category
Transaction Center → Transaction Entry → Timesheets → Comment
Settings → Rate Tables → Billing Labor Rates → Employees → Rate
Hubs → Projects → Project → Accounting → Charge Type

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

Time Entries

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

Hubs → Projects → Plan → Labor → Level/Resource → Assignment Start
Hubs → Projects → Plan → Labor → Level/Resource → Assignment End
Hubs → Projects → Plan → Labor → Level/Resource → Planned Hours
Settings → Rate Tables → Billing Labor Categories → Categories → Category
Settings → Rate Tables → Billing Labor Categories → Categories → Description

Work Plans

  • Start and End Dates
  • Scheduled Labor
  • Labor Codes
  • Title

Unsupported Data Sources

  • Changing field names in Mosaic to match custom labelling in Vantagepoint
  • Integrating Data Types that are not explicitly listed in the Vantagepoint 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 Vantagepoint on-premise. The following tables will be included in your replication:

Table Name

Table Description

Usage in Mosaic

BT

Billing Terms Table

Project integration

billFeeDetail

Invoice Detail Table - Fee Detail for Prior Billings

Employee integration

CA

Chart of Accounts Table

Budgets

CAB

Corporate Budgets Table

Budgets

CABDetail

Corporate Budgets Table - Detail

Budgets

CLendor

Client Table

Client Integration

EB

Expense Budget Table

Budgets

ekDetail

Expense Table - Data Entry Detail

Expenses Coming soon

EMAccrual

Employee Payroll Table - Accruals

Employee integration

EMCompany

Employee Company Table

Employee integration

EMMain

Employee Table

Employee integration

erDetail

Employee Repayments Table - Data Entry Detail

Expenses Coming soon

GR

Generic Resource

Time Entry integration

inDetail

Invoice Table - Data Entry Detail

Invoices Coming soon

LB

Labor Budget Table

Budgets

LD

Labor Detail Table

Time Entry integration

Organization

Configuration Table - Organizations

Organization filtering

PR

Project Table

Project integration

PRDescriptions

Project Table - Project Descriptions

Project integration

prDetail

Prints/Reproduction Expense Table - Data Entry Detail

Project integration

PRF

Project Financial Table

Project integration

PRFEPhases

This table contains fee estimate phase data for projects

Project integration

RPAssignment

Resource Planning - Assignment Table

Work Plan integration

RPPlan

Resource Planning - Plan Table

Work Plan integration

RPPlannedLabor

Resource Planning - Planned Labor Table

Work Plan integration

RPTask

Resource Planning - Tasks

Work Plan integration

tkDetail

Time Table - Data Entry Detail

Time Entry integration

tsDetail Coming soon

Timesheets Table - Data Entry Detail

Time Entry integration

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

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