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    

ExakTime Integration Overview

Classification

Data Types

  • People
  • Projects

Data Flow

  • Unidirectional; ExakTime into LaborChart only

Sync Frequency

  • Twice daily

Connection Requirements

ExakTime offers a data replication service that automatically sends your ExakTime data into a read-only SQL database. There is a fee associated with this service. In order for us to make the integration connection you will need to contact them to get this set up.

  • 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 ExakTime Fields and Tables

📘

Note

Your ExakTime 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

ExakTime Field

ExakTime Table

First Name

FirstName

tb_employee

Last Name

LastName

tb_employee

Status (Active, Pending, or Inactive)

Status

tb_employee

Employee ID

EmployeeNumber

tb_employee

Address 1

Address1

tb_address

Address 2

Address2

tb_address

City

City

tb_address

State

State

tb_address

Zipcode

Zip

tb_address

Phone Number

Data

tb_ContactInfo

Email

Login

tb_employee

Hourly Wage

Cost

tb_employee

Date of Birth

DOB

tb_employee

Hired Date

HireDate

tb_employee

Job Title

EmployeeCategoryDescription

vw_TimeRecords

Projects

LaborChart Field

ExakTime Field

ExakTime Table

Project Name

Name

tb_Site

Status (Active, Pending, or Inactive)

Description

tb_Status

Project ID

SiteNumber

tb_Site

Address 1

Address1

tb_Address

Address 2

Address2

tb_Address

City

City

tb_Address

State

State

tb_Address

Zipcode

Zip

tb_Address

Start Date

CreatedDate

tb_Site

Customer

ContactName

tb_Site

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