Viewpoint Cloud Integration Overview

Classification

Data Types

  • People
  • Projects

Data Flow

  • Unidirectional; Viewpoint into LaborChart only

Sync Frequency

  • Twice daily

Connection Requirements and Process

🚧

This connection can only be made to Viewpoint Enterprise Cloud (VEC) instances

It is important that you confirm your organization is utilizing a Viewpoint Enterprise Cloud (VEC) instance. Vista in Viewpoint For Cloud (VFC) instances are not currently supported.

Process

The database connection will be established using Viewpoint's TLS VPN method. The LaborChart Integration Team will provide you with the necessary information to relay to Viewpoint Support and they will handle the appropriate whitelisting of our IP and distribution of your unique data URL.

Additional Requirements

We will also need to obtain:

  • A set of read-only SQL credentials



Commonly Used Viewpoint Fields and Tables

📘

Note

Your Viewpoint database may feature tables and fields with naming conventions altered slightly from what is listed below. This list is intended to be a baseline/template and the integration will be tailored to match your system exactly.

People

LaborChart Field

Viewpoint Field

Viewpoint Table

First Name

FirstName

PREH

Last Name

LastName

PREH

Status (Active, Pending, or Inactive)

ActiveYN

PREH

Employee ID

Employee

PREH

Address 1

Address

PREH

Address 2

Address2

PREH

City

City

PREH

State

State

PREH

Zipcode

Zip

PREH

Phone Number

Cellphone

PREH

Email

Email

PREH

Hourly Wage

NewRate

PRCP

Date of Birth

BirthDate

PREH

Emergency Contact Name

Contact

HREC

Emergency Contact Phone Number

HomePhone // WorkPhone

HREC

Emergency Contact Relation

Relationship

HREC

Hired Date

HireDate

PREH

Gender

sex

PREH

Job Title

Craft, Class

PREH

Projects

LaborChart Field

Viewpoint Field

Viewpoint Table

Project Name

Description

JCJM

Status (Active, Pending, or Inactive)

JobStatus

JCJM

Project ID

Job

JCJM

Address 1

ShipAddress

JCJM

Address 2

ShipAddress2

JCJM

City

ShipCity

JCJM

State

ShipState

JCJM

Zipcode

ShipZip

JCJM

Start Date

StartMonth

JCJM

Est. End Date

ProjCloseDate

JCJM

Customer

customer_name

ARCM

Project Manager

Name

JCMP

Have questions? Reach out to us at [email protected]