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    

Sage HRMS Integration Overview

Classification

Data Types

  • People

Data Flow

  • Unidirectional; Sage HRMS 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 Sage HRMS Fields and Tables

📘

Note

Your Sage HRMS 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

Sage Field

Sage Table

First Name

p_fname

hrpersnl

Last Name

p_lname

hrpersnl

Status (Active, Pending, or Inactive)

p_active

hrpersnl

Employee ID

p_empno

hrpersnl

Address 1

p_hstreet1

hrpersnl

Address 2

p_hstreet2

hrpersnl

City

p_hcity

hrpersnl

State

p_hstate

hrpersnl

Zipcode

p_hzip

hrpersnl

Phone Number

p_cellular

hrpersnl

Email

p_empemail

hrpersnl

Hourly Wage

p_lunitr

hrpersnl

Date of Birth

p_birth

hrpersnl

Emergency Contact Name

e_contact

hemerg

Emergency Contact Phone Number

e_cphone

hemerg

Emergency Contact Relation

e_relat

hemerg

Hired Date

p_orighire

hrpersnl

Gender

p_sex

hrpersnl

Job Title

p_jobtitle

hrpersnl

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