LaborChart

The LaborChart Developer Hub

Welcome to the LaborChart developer hub. You'll find comprehensive guides and documentation to help you start working with LaborChart as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    

Viewpoint On-Premise Integration Overview

Classification

Data Types

  • People
  • Projects

Data Flow

  • Unidirectional; Viewpoint into LaborChart only

Sync Frequency

  • Twice daily

Connection Requirements

  • Accessible IP address or URL
  • Set of read-only SQL credentials
  • Database name

Provided

  • Four LaborChart outbound IP addresses will be provided during implementation and will need to be whitelisted

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]