Integrated Data

What this page covers: A complete reference mapping every Vista field to its Mosaic equivalent. Use this guide when configuring your integration, verifying synced data, or troubleshooting discrepancies.


Integration type	On-Premise (Direct Database Access)
Setup complexity	Moderate
Prerequisite	Vista Integration Setup

How Data Flows

Vista (Direct Database Access) → Mosaic Sync Engine (field mapping + replication) → Mosaic (6 synced data types)

Mosaic replicates a subset of Vista database tables and maps them into Mosaic data types. Only posted time entries are synced — unposted time entries are not integrated.

Integrated Data Types

The integration syncs 6 data categories from Vista into Mosaic:

#	Data Type	Description
1	Employees	Staff records with names and emails from Payroll
2	Clients	Customer records from Accounts Receivable
3	Projects	Job records from Job Cost including fees and client links
4	Phases	Job phase breakdowns under projects
5	Time Entries	Posted cost detail entries with hours, jobs, and employees
6	Bill Rates	Job cost rate details and rate tables

This list may expand as new features are added. When a new feature is added, your Customer Success Manager will reach out requesting access to your server to update your replication.

Reading the Field Mapping Tables

Symbol legend for technical tables

The Technical Reference tabs below use a shorthand notation for Vista database table and field references. Read this legend before reviewing the mappings.

Symbol	Meaning	Example
`.`	Database table field reference	`PREH.FirstName` = the FirstName field from the PREH (PR Employee Header) table

Vista Table Reference:

Table	Full Name	Used For
JCJM	Job Cost Job Master	Project integration
JCCM	Job Cost Cost Master	Project integration
JCJP	Job Cost Job Phases	Phase integration
JCCP	Job Cost Cost Phase	Phase integration
JCCD	Job Cost Cost Detail	Time Entry integration
ARCM	AR Customer Master	Client integration
PREH	PR Employee Header	Employee integration
JCRD	Job Cost Rate Detail	Bill Rate integration*
JCRT	Job Cost Rate Table	Bill Rate integration*

Detailed Field Mappings

Employees

What Syncs to Mosaic	Where It Comes From in Vista
Employee Name	The employee's first and last name from Payroll
Email	The employee's email address

Clients

What Syncs to Mosaic	Where It Comes From in Vista
Client Name	The customer name from Accounts Receivable

Projects

What Syncs to Mosaic	Where It Comes From in Vista
Project Name	The job description from Job Cost
Client	The customer linked to the job
Project Number	The job number
Fee	The current contract amount for the job

Phases

What Syncs to Mosaic	Where It Comes From in Vista
Phase Name	The phase description from Job Cost
Phase Number	The phase identifier
Project Number	The contract/project the phase belongs to
Budget	The current total cost for the phase

Time Entries

Important: Mosaic only syncs posted time entries from Vista. Unposted time entries are not integrated.

What Syncs to Mosaic	Where It Comes From in Vista
Date	The actual date of the time entry
Hours	The number of hours logged
Project	The job the time was logged against
Phase	The phase the time was logged against
Description	The time entry description
Employee	The employee who logged the time

Bill Rates

Important: Primary Key Caveat

The tables used in Bill Rate integration (JCRD and JCRT) do not have a primary key in the Vista database. This means the data must be exported and provided to Mosaic for manual import into the database. This process will need to be repeated each time you want to refresh the data.

Alternatively, you can add a Primary Key to these tables or replicate them with a Primary Key following these instructions.

What Syncs to Mosaic	Where It Comes From in Vista
Rate Details	Job cost rate detail entries from the JCRD table
Rate Tables	Job cost rate table entries from the JCRT table

Troubleshooting & FAQ

Why are my time entries not showing up?

Only posted time entries are synced from Vista. Ensure your time entries are posted before expecting them to appear in Mosaic.

Can I rename field names in Mosaic to match custom labelling in Vista?

No. Custom field name changes in Mosaic to match Vista labeling is not supported as a standard integration feature.

I need a data source or field that isn't listed here.

Any integration not listed in this documentation is considered a customization and is charged at an hourly rate. For more information, see Integration Requests.

Vista Documentation Links

A consolidated reference of all Vista documentation referenced in this guide:

Topic	Link
Vista Product Help	Vista Online Help
Trimble (formerly Viewpoint) Help Center	Trimble Help