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

🚧

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 Vision on-premise. The following tables will be included in your replication:

Table NameTable DescriptionUsage in MosaicTable Fields
BTBilling Terms TableBill Rate integration (Coming soon)Entire Table
BTLaborCatsDescriptionsBilling Configuration Table - Labor Category Descriptions, by LanguageEmployee Role integration (Coming soon)Entire Table
BTRCTBilling Rate Table - Labor Category TablesBill Rate integration (Coming soon)Entire Table
BTRCTCatsBilling Rate Table - Labor CategoriesBill Rate integration (Coming soon)Entire Table
BTRCTEmplsBilling Rate Table - Labor Category Table Employee OverridesBill Rate integration (Coming soon)Entire Table
BTROTBilling Rate Table - Labor Override TablesBill Rate integration (Coming soon)Entire Table
BTROTCatsBilling Rate Table - Labor Category Override TablesBill Rate integration (Coming soon)Entire Table
BTROTEmplsBilling Rate Table - Labor OverridesBill Rate integration (Coming soon)Entire Table
CAChart of Accounts TableBudgets integration (Coming soon)Entire Table
CABCorporate Budgets TableBudgets integration (Coming soon)Entire Table
CABDetailCorporate Budgets Table - DetailBudgets integration (Coming soon)Entire Table
CFGEMSkillDescriptionsConfiguration Table - Employee Skill/Discipline Code Descriptions, by LanguageSkills and Disciplines integration (Coming soon)Entire Table
CFGFormatConfiguration Table - Delimiters and Other FormatsTime Entry IntegrationEntire Table
CFGLCCodesDataConfiguration Table - Codes for Labor Code LevelsTime Entry IntegrationEntire Table
CFGLCCodesDescriptionsConfiguration Table - Descriptions for Labor Code Level Codes, by LanguageTime Entry IntegrationEntire Table
CLClient TableClient integrationEntire Table
CostRTEmplsCost/Pay Labor Rate Table - DetailEmployee integration (Coming soon)Entire Table
EBExpense Budget TableBudgets integration (Coming soon)Entire Table
ekDetailExpense Table - Data Entry DetailBudgets integration (Coming soon)Entire Table
EMAccrualEmployee Payroll Table - AccrualsEmployee integration (Coming soon)Entire Table
EMCompanyEmployee Company TableEmployee integrationEntire Table
EMMainEmployee TableEmployee integrationEmployee
FirstName
MiddleName
LastName
EMail
CreateDate
ModUser
ModDate
EMProjectAssocEmployee Table - Project AssociationsProject integration (Coming soon)Entire Table
EMSkillsEmployees Table - SkillsSkills and Disciplines integration (Coming soon)Entire Table
erDetailEmployee Repayments Table - Data Entry DetailExpenses integration (Coming soon)Entire Table
GRGeneric ResourceBill Rate integration (Coming soon)Entire Table
LBLabor Budget TableProject integrationEntire Table
LDLabor Detail TableTime Entry integrationEntire Table
OppLaborOpportunity Table - Labor Grid of Service Estimate Tab (CRM only)Project integration (Coming soon)Entire Table
OpportunityOpportunity Table (CRM only)Project integration (Coming soon)Entire Table
OpportunityClientAssocOpportunity Table - Client Associations (CRM only)Client integration (Coming soon)Entire Table
OrganizationConfiguration Table - OrganizationsOrganization filtering integrationEntire Table
PRProject TableProject integrationEntire Table
PRDescriptionsProject Table - Project DescriptionsProject integration (Coming soon)Entire Table
prDetailPrints/Reproduction Expense Table - Data Entry DetailProject integration (Coming soon)Entire Table
PRFProject Financial TableProject integration (Coming soon)Entire Table
PRFEPhasesThis table contains fee estimate phase data for projects.Project integration (Coming soon)Entire Table
RPAssignmentResource Planning - Assignment TableWork Plan integrationEntire Table
RPPlanResource Planning - Plan TableWork Plan integration (Coming soon)Entire Table
RPPlannedLaborResource Planning - Planned Labor TableWork Plan integrationEntire Table
RPTaskResource Planning - TasksWork Plan integrationEntire Table
tkDetailTime Table - Data Entry DetailWork Plan integrationEntire Table
tkMasterTime Table - Data Entry MasterWork Plan integrationEntire Table
tsDetailTimesheets Table - Data Entry DetailWork Plan integrationEntire Table
tsMasterTimesheets Table - Data Entry MasterWork Plan integrationEntire Table

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".