Foundation On-Premise Integration Overview

Classification

Data Types

  • People
  • Projects

Data Flow

  • Unidirectional; Foundation into Workforce Planning only

Sync Frequency

  • Twice daily

Connection Requirements

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

Provided

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

Commonly Used Foundation Fields and Tables

📘

Note

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

Workforce Planning FieldFoundation FieldFoundation Table
First Namefirst_nameEmployees
Last Namelast_nameEmployees
Status (Active, Pending, or Inactive)record_status // date_terminatedEmployees
Employee IDemployee_noEmployees
Address 1address_1Employees
Address 2address_2Employees
CitycityEmployees
StatestateEmployees
Zipcodezip_codeEmployees
Phone Numberphone // cellphoneEmployees
Emailemail_addressEmployees
Hourly Wagepay_rateEmployees
Date of Birthdate_of_birthEmployees
Hired Datedate_hiredEmployees
GendersexEmployees
Job Titletrade_no // trade_idEmployees
Unionunion_no // union_idEmployees

Projects

Workforce Planning FieldFoundation FieldFoundation Table
Project Namedescriptionsjobs
Status (Active, Pending, or Inactive)job_statusjobs
Project IDjob_nojobs
Address 1address_1jobs
Address 2address_2jobs
Citycityjobs
Statestatejobs
Zipcodezip_codejobs
Start Datejob_start_datejobs
Est. End Datecompletion_datejobs
Customercustomer_nojobs
Project Managerproject_managerjobs
Project Typeproject_class_idjobs

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