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
- Vantagepoint Profit Centers
Work Categories (Vantagepoint Labor Codes, Vantagepoint Tasks)
Time Entries
Work Plans
Bill Rates
Roles

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 Hubs -> Employees -> Accounting → Labor Category (Optional) Hubs -> Employees -> Accounting → Job Cost Rate (Optional)	Employees Name Email Default Role (Optional) Default Cost Rate (Optional)
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 → Start Date and Estimated Completion Date	Project, Phases Title Fee Client Schedules
Hubs → Projects → Plan → Labor → Level/Resource → Work Plan Start 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 Time Entries Synchronization in Mosaic: 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 Vantagepoint, please contact your Customer Success Manager for assistance.	Time Entries Date Hours Account Project Phase Work Category Description Billable Rate
Hubs → Projects → Plan → Labor → Level/Resource → Project/Phase/Task Hubs → Projects → Plan → Labor → Level/Resource → Month/Year Hubs → Projects → Plan → Labor → Level/Resource → Planned Hours Hubs → Projects → Plan → Labor → Level/Resource → Employee Hubs → Projects → Plan → Labor → Level/Resource → Labor Code (Optional)	Work Plans Project/Phase/Subphase Start Date and End Date Hours Employee Work Category (Optional)

Vantagepoint Data Types

Mosaic Data Types

Hubs → Employees → Name and Background → Full Name Hubs -> Employees -> Contact Information → Home Email Hubs -> Employees -> Accounting → Labor Category (Optional) Hubs -> Employees -> Accounting → Job Cost Rate (Optional)

Employees

Name
Email
Default Role (Optional)
Default Cost Rate (Optional)

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 → Start Date and Estimated Completion Date

Project, Phases

Title
Fee
Client
Schedules

Hubs → Projects → Plan → Labor → Level/Resource → Work Plan Start
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

Time Entries Synchronization in Mosaic:

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 Vantagepoint, please contact your Customer Success Manager for assistance.

Time Entries

Date
Hours
Account
Project
Phase
Work Category
Description
Billable
Rate

Hubs → Projects → Plan → Labor → Level/Resource → Project/Phase/Task
Hubs → Projects → Plan → Labor → Level/Resource → Month/Year
Hubs → Projects → Plan → Labor → Level/Resource → Planned Hours
Hubs → Projects → Plan → Labor → Level/Resource → Employee
Hubs → Projects → Plan → Labor → Level/Resource → Labor Code (Optional)

Work Plans

Project/Phase/Subphase
Start Date and End Date
Hours
Employee
Work Category (Optional)

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

👍
Customizations:
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.

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 Fields	Table Description	Usage in Mosaic
BT	Entire Table	Billing Terms Table	Bill Rate integration
BTLaborCatsDescriptions	Entire Table	Billing Configuration Table - Labor Category Descriptions, by Language	Employee Role integration
BTRCT	Entire Table	Billing Rate Table - Labor Category Tables	Bill Rate integration
BTRCTCats	Entire Table	Billing Rate Table - Labor Categories	Bill Rate integration
BTRCTEmpls	Entire Table	Billing Rate Table - Labor Category Table Employee Overrides	Bill Rate integration
BTRLT	Entire Table	Billing Rate Table - Labor Code Tables	Bill Rate integration
BTRLTCodes	Entire Table	Billing Rate Table - Labor Code Masks and Overrides	Bill Rate integration
BTROT	Entire Table	Billing Rate Table - Labor Override Tables	Bill Rate integration
BTROTCats	Entire Table	Billing Rate Table - Labor Category Override Tables	Bill Rate integration
BTROTEmpls	Entire Table	Billing Rate Table - Labor Overrides	Bill Rate integration
BTRRT	Entire Table	Billing Rate Table - Labor Rate Tables	Bill Rate integration
BTRRTEmpls	Entire Table	Billing Rate Table - Labor Rate Tables	Bill Rate integration
CA	Entire Table	Chart of Accounts Table	Budgets integration (Coming soon)
CFGEmployeeTitleDescriptions	Entire Table	Configuration Table - Employee Job Title Code Descriptions, by Language	Employee integration
CFGEMSkillDescriptions	Entire Table	Configuration Table - Employee Skill/Discipline Code Descriptions, by Language	Skills and Disciplines integration (Coming soon)
CFGFormat	Entire Table	Configuration Table - Delimiters and Other Formats	Time Entry integration
CFGLCCodesData	Entire Table	Configuration Table - Codes for Labor Code Levels	Time Entry integration
CFGLCCodesDescriptions	Entire Table	Configuration Table - Descriptions for Labor Code Level Codes, by Language	Time Entry integration
CFGOHMain	Entire Table	Overhead Allocation by Company	Overhead Multiplier Integration
CLendor	Entire Table	Client Table	Client Integration
EB	Entire Table	Expense Budget Table	Budgets integration (Coming soon)
ekDetail	Entire Table	Expense Table - Data Entry Detail	Expenses integration (Coming soon)
EMAccrual	Entire Table	Employee Payroll Table - Accruals	Employee integration
EMCompany	Entire Table	Employee Company Table	Employee integration
EMMain	Employee FirstName MiddleName LastName EMail Title CreateDate ModUser ModDate	Employee Table	Employee integration
EMSkills	Entire Table	Employees Table - Skills	Skills and Disciplines integration (Coming soon)
erDetail	Entire Table	Employee Repayments Table - Data Entry Detail	Expenses integration (Coming soon)
GR	Entire Table	Generic Resource	Time Entry integration Bill Rate integration (Coming soon)
inDetail	Entire Table	Invoice Table - Data Entry Detail	Invoices integration (Coming soon)
LB	Entire Table	Labor Budget Table	Budgets integration
LD	Entire Table	Labor Detail Table	Time Entry integration
Organization	Entire Table	Configuration Table - Organizations	Organization filtering integration
PR	Entire Table	Project Table	Project integration
PRDescriptions	Entire Table	Project Table - Project Descriptions	Project integration
prDetail	Entire Table	Prints/Reproduction Expense Table - Data Entry Detail	Project integration
PRF	Entire Table	Project Financial Table	Project integration
PRFEPhases	Entire Table	This table contains fee estimate phase data for projects	Project integration
RPAssignment	Entire Table	Resource Planning - Assignment Table	Work Plan integration
RPPlan	Entire Table	Resource Planning - Plan Table	Work Plan integration
RPPlannedLabor	Entire Table	Resource Planning - Planned Labor Table	Work Plan integration
RPTask	Entire Table	Resource Planning - Tasks	Work Plan integration
tkDetail	Entire Table	Time Table - Data Entry Detail	Time Entry integration
tkMaster	Entire Table	Time Table - Data Entry Master	Time Entry integration
tsDetail	Entire Table	Timesheets Table - Data Entry Detail	Time Entry integration
tsMaster	Entire Table	Timesheets Table - Data Entry Master	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.