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    

Spectrum Cloud Integration Overview

Classification

Data Types

  • People
  • Projects

Data Flow

  • Unidirectional; Spectrum 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

When integrating with Spectrum Cloud, you will need to contact your Spectrum support representative to have them handle the IP whitelisting and the creation of the SQL credentials.

Commonly Used Spectrum Fields and Tables

📘

Note

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

Spectrum Field

Spectrum Table

First Name

first_name

PR_EMPLOYEE_MASTER_MC

Last Name

last_name

PR_EMPLOYEE_MASTER_MC

Status (Active, Pending, or Inactive)

employment_status

PR_EMPLOYEE_MASTER_MC

Employee ID

employee_code

PR_EMPLOYEE_MASTER_MC

Address 1

street_address

PR_EMPLOYEE_MASTER_MC

Address 2

street_address2

PR_EMPLOYEE_MASTER_MC

State

state

PR_EMPLOYEE_MASTER_MC

City

address

PR_EMPLOYEE_MASTER_MC

Zipcode

zip_code

PR_EMPLOYEE_MASTER_MC

Phone Number

phone

PR_EMPLOYEE_MASTER_MC

Email

employee_email

PR_EMPLOYEE_MASTER_MC

Hourly Wage

hourly_rate_list_1

PR_WAGE_CLASS_MASTER_MC

Date of Birth

employee_date_list4

PR_EMPLOYEE_MASTER_MC

Emergency Contact Name

emergency_contact

PR_EMPLOYEE_MASTER_MC

Emergency Contact Phone Number

emergency_phone

PR_EMPLOYEE_MASTER_MC

Emergency Contact Relation

emergency_relationship

PR_EMPLOYEE_MASTER_MC

Hired Date

employee_date_list1

PR_EMPLOYEE_MASTER_MC

Gender

sex

PR_EMPLOYEE_MASTER_MC

Job Title

title

PR_EMPLOYEE_MASTER_MC

Projects

LaborChart Field

Spectrum Field

Spectrum Table

Project Name

job_description

JC_JOB_MASTER_MC

Status (Active, Pending, or Inactive)

status_code

JC_JOB_MASTER_MC

Project ID

job_number

JC_JOB_MASTER_MC

Address 1

address_1

JC_JOB_MASTER_MC

Address 2

address_2

JC_JOB_MASTER_MC

City

city

JC_JOB_MASTER_MC

State

state

JC_JOB_MASTER_MC

Zipcode

zip

JC_JOB_MASTER_MC

Start Date

start_date

JC_JOB_MASTER_MC

Est. End Date

complete_date

JC_JOB_MASTER_MC

Percent Complete

percent_complete

JC_JOB_MASTER_TOTAL_MC

Customer

name

CR_CUSTOMER_MASTER_MC

Project Manager

project_manager

JC_JOB_MASTER_MC

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