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
  • Vantagepoint 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 TypesMosaic 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

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

🚧

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.

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 NameTable DescriptionUsage in Mosaic
billLabDetailInvoice Detail Table - Labor Detail for Prior BillingsBill Rate integration (Coming soon)
BTBilling Terms TableProject integration
BTLaborCatsDescriptionsBilling Configuration Table - Labor Category Descriptions, by LanguageEmployee Role integration (Coming soon)
BTRCTBilling Rate Table - Labor Category TablesBill Rate integration (Coming soon)
BTRCTCatsBilling Rate Table - Labor CategoriesBill Rate integration (Coming soon)
BTRCTEmplsBilling Rate Table - Labor Category Table Employee OverridesBill Rate integration (Coming soon)
BTROTBilling Rate Table - Labor Override TablesBill Rate integration (Coming soon)
BTROTCatsBilling Rate Table - Labor Category Override TablesBill Rate integration (Coming soon)
BTROTEmplsBilling Rate Table - Labor OverridesBill Rate integration (Coming soon)
CAChart of Accounts TableBudgets integration (Coming soon)
CABCorporate Budgets TableBudgets integration (Coming soon)
CABDetailCorporate Budgets Table - DetailBudgets integration (Coming soon)
CFGEMSkillDescriptionsConfiguration Table - Employee Skill/Discipline Code Descriptions, by LanguageSkills and Disciplines integration (Coming soon)
CFGFormatConfiguration Table - Delimiters and Other FormatsTime Entry integration
CFGLCCodesDataConfiguration Table - Codes for Labor Code LevelsTime Entry integration
CFGLCCodesDescriptionsConfiguration Table - Descriptions for Labor Code Level Codes, by LanguageTime Entry integration
CLendorClient TableClient Integration
EBExpense Budget TableBudgets integration (Coming soon)
ekDetailExpense Table - Data Entry DetailExpenses integration (Coming soon)
EMAccrualEmployee Payroll Table - AccrualsEmployee integration
EMCompanyEmployee Company TableEmployee integration
EMMainEmployee TableEmployee integration
EMSkillsEmployees Table - SkillsSkills and Disciplines integration (Coming soon)
erDetailEmployee Repayments Table - Data Entry DetailExpenses integration (Coming soon)
GRGeneric ResourceTime Entry integration
Bill Rate integration (Coming soon)
inDetailInvoice Table - Data Entry DetailInvoices integration (Coming soon)
LBLabor Budget TableBudgets integration
LDLabor Detail TableTime Entry integration
OrganizationConfiguration Table - OrganizationsOrganization filtering integration
PRProject TableProject integration
PRDescriptionsProject Table - Project DescriptionsProject integration
prDetailPrints/Reproduction Expense Table - Data Entry DetailProject integration
PRFProject Financial TableProject integration
PRFEPhasesThis table contains fee estimate phase data for projectsProject integration
RPAssignmentResource Planning - Assignment TableWork Plan integration
RPPlanResource Planning - Plan TableWork Plan integration
RPPlannedLaborResource Planning - Planned Labor TableWork Plan integration
RPTaskResource Planning - TasksWork Plan integration
tkDetailTime Table - Data Entry DetailTime Entry integration
tkMasterTime Table - Data Entry MasterTime Entry integration
tsDetailTimesheets Table - Data Entry DetailTime Entry integration
tsMasterTimesheets Table - Data Entry MasterTime 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.