Resource Planning Detailed Data Mapping

Overview

Customers have four options when it comes to how they manage data in Resource Planning and other Procore tools. Customers choose where they want to manage data. That data is then synced between Resource Planning and other tools in Procore. The data that is synced is listed below based on where you choose to manage your data.

Data flows between various systems are supported by:

  • Quick Connect - This integration tool syncs data from a system of record to Resource Planning.
    Note: This option is available to customers with an approved Resource Planning integration.

  • Internal Data Sync - This syncs information between the Resource Planning Tool and other tools in Procore.

  • ERP Integrations - This syncs information between a Customer's ERP system and Procore's Portfolio tool.
    Note: To purchase an ERP integration that syncs projects, Customers must also purchase Procore Financials.

  • Data Upload - This is a one-time data upload where a Customer's People and Project data is uploaded into Resource Planning.

Detailed Data Mapping

Customers have the following options available when it comes to how they manage data in Resource Planning and other Procore tools:

  1. Manage People and Projects from your System of Record.

  2. Manage People from your System of Record, Manage Projects from ERP.

  3. Manage People from Resource Planning, Manage Projects from the Portfolio tool.

Manage People and Projects from your System of Record

Customers manage people and project information in a system of record, and use QuickConnect to sync both people and projects in Resource Planning. People and project information then sync to the Company Directory and Portfolio tools.

Resource Planning People and Projects from SOR

People

Show/Hide Data Mapping

COMPANY DIRECTORY

DATA SYNC

RESOURCE PLANNING

QUICK CONNECT

SYSTEM OF RECORD

First Name

erp-green-arrows.png

First Name

erp-green-arrows.png

First Name

Last Name

erp-green-arrows.png

Last Name

erp-green-arrows.png

Last Name

Status (Active, Inactive)

erp-green-arrows.png

Status (Active, Inactive)

erp-green-arrows.png

Record Status or Date Terminated

Employee ID

erp-green-arrows.png

Employee ID

erp-green-arrows.png

Employee ID

Mobile Phone

erp-green-arrows.png

Mobile Phone

erp-green-arrows.png

Phone /Cell Phone

Email Address

erp-green-arrows.png

Email Address

erp-green-arrows.png

Email Address

Job Title

erp-green-arrows.png

Job Title

erp-green-arrows.png

Trade Number / Trade ID

N/A

N/A

Tags

erp-green-arrows.png

Tags

N/A

N/A

Hourly Wage

erp-green-arrows.png

Pay Rate

N/A

N/A

Date of Birth

erp-green-arrows.png

Date of Birth

N/A

N/A

Hired Date

erp-green-arrows.png

Hired Date

N/A

N/A

Gender

erp-green-arrows.png

Sex

N/A

N/A

Union

erp-green-arrows.png

Union Number / Union ID

Projects

Show/Hide Data Mapping

PORTFOLIO TOOL

DATA SYNC

RESOURCE PLANNING

QUICK CONNECT

SYSTEM OF RECORD

Project Name

erp-green-arrows.png

Project Name

erp-green-arrows.png

Project Name / Description

Status (Active, Inactive)

erp-green-arrows.png

Status (Active, Inactive)

erp-green-arrows.png

Job Status

Project Number

erp-green-arrows.png

Project Number

erp-green-arrows.png

Job Number

Address

erp-green-arrows.png

Address 1

erp-green-arrows.png

Address 1

N/A

N/A

Address 2

erp-green-arrows.png

Address 2

City

erp-green-arrows.png

City

erp-green-arrows.png

City

State

N/A

State

erp-green-arrows.png

State

ZIP

erp-green-arrows.png

Postal Code

erp-green-arrows.png

Zip Code

Timezone

erp-green-arrows.png

Timezone

N/A

N/A

Start Date

erp-green-arrows.png

Start Date

erp-green-arrows.png

Job Start Date

Completion Date

erp-green-arrows.png

Est. End Date

erp-green-arrows.png

Completion Date

N/A

N/A

Tags

erp-green-arrows.png

Tags

N/A

N/A

Customer

erp-green-arrows.png

Customer Number

N/A

N/A

Project Manager

erp-green-arrows.png

Project Manager

N/A

N/A

Project Type

erp-green-arrows.png

Project Class ID

Manage People from your System of Record, Manage Projects from ERP

Customers manage people in a system of record and use QuickConnect to integrate people to Resource Planning. People information then syncs to the Company Directory. At the same time, Customers use an ERP integration to manage project information which syncs to the Portfolio tool. Project information then syncs to Resource Planning.

SOR_2Band_2BERP.png

People

Show/Hide Data Mapping

COMPANY DIRECTORY

DATA SYNC

RESOURCE PLANNING

QUICK CONNECT

SYSTEM OF RECORD

First Name

erp-green-arrows.png

First Name

erp-green-arrows.png

First Name

Last Name

erp-green-arrows.png

Last Name

erp-green-arrows.png

Last Name

Status (Active, Inactive)

erp-green-arrows.png

Status (Active, Inactive)

erp-green-arrows.png

Record Status / Date Terminated

Employee ID

erp-green-arrows.png

Employee ID

erp-green-arrows.png

Employee Number

Mobile Phone

erp-green-arrows.png

Mobile Phone

erp-green-arrows.png

Phone / Cell Phone

Email Address

erp-green-arrows.png

Email Address

erp-green-arrows.png

Email Address

Job Title

erp-green-arrows.png

Job Title

erp-green-arrows.png

Trade Number / Trade ID

N/A

N/A

Tags

erp-green-arrows.png

Tags

N/A

N/A

Hourly Wage

erp-green-arrows.png

Pay Rate

N/A

N/A

Date of Birth

erp-green-arrows.png

Date of Birth

N/A

N/A

Hired Date

erp-green-arrows.png

Date Hired

N/A

N/A

Gender

erp-green-arrows.png

Sex

N/A

N/A

Union

erp-green-arrows.png

Union Number / Union ID

Projects

Show/Hide Data Mapping

ERP SYSTEM

ERP INTEGRATION

PROCORE

DATA SYNC

RESOURCE PLANNING

Project Name

erp-orange-arrows.png

Project Name

erp-orange-arrows.png

Project Name

N/A

N/A

Status (Active, Inactive)

erp-orange-arrows.png

Status (Active, Inactive)

Project Number

erp-orange-arrows.png

Project Number

erp-orange-arrows.png

Project Number

Address

erp-orange-arrows.png

Address

erp-orange-arrows.png

Address 1

City

erp-orange-arrows.png

City

erp-orange-arrows.png

City

State

erp-orange-arrows.png

State

N/A

State

ZIP

erp-orange-arrows.png

ZIP

erp-orange-arrows.png

Postal Code

N/A

N/A

Start Date

erp-orange-arrows.png

Start Date

N/A

N/A

Completion Date

erp-orange-arrows.png

Est. End Date

Manage People from Resource Planning, Manage Projects from the Portfolio Tool

Customers can use a one-time data upload to upload their people data into Resource Planning. Going forward, Customers manage people information in Resource Planning which syncs to the Company Directory. Customers manage Project information in the Portfolio tool which syncs to Resource Planning.

Data_2BUpload.png

People

Show/Hide Data Mapping

COMPANY DIRECTORY

DATA SYNC

RESOURCE PLANNING

DATA UPLOAD

CUSTOMER DATA

First Name

erp-green-arrows.png

First Name

erp-green-arrows.png

First Name

Last Name

erp-green-arrows.png

Last Name

erp-green-arrows.png

Last Name

Status (Active, Inactive)

erp-green-arrows.png

Status (Active, Inactive)

erp-green-arrows.png

Status

Employee ID

erp-green-arrows.png

Employee ID

erp-green-arrows.png

Employee ID

Mobile Phone

erp-green-arrows.png

Mobile Phone

erp-green-arrows.png

Mobile Phone

Email Address

erp-green-arrows.png

Email Address

erp-green-arrows.png

Email

Job Title

erp-green-arrows.png

Job Title

erp-green-arrows.png

Job Title (ID)

N/A

N/A

Assignable

erp-green-arrows.png

Assignable

N/A

N/A

Can receive email

erp-green-arrows.png

Can receive email

N/A

N/A

Can receive SMS

erp-green-arrows.png

Can receive SMS

N/A

N/A

Date of Birth

erp-green-arrows.png

Date of Birth

N/A

N/A

Date of Hire

erp-green-arrows.png

Date of Hire

N/A

N/A

Emergency Contact Email

erp-green-arrows.png

Emergency Contact Email

N/A

N/A

Emergency Contact Name

erp-green-arrows.png

Emergency Contact Name

N/A

N/A

Emergency Contact Mobile Number

erp-green-arrows.png

Emergency Contact Mobile Number

N/A

N/A

Emergency Contact Relationship

erp-green-arrows.png

Emergency Contact Relationship

N/A

N/A

Gender

erp-green-arrows.png

Gender

N/A

N/A

Group

erp-green-arrows.png

Group (ID)

N/A

N/A

Hourly Wage

erp-green-arrows.png

Hourly Wage

N/A

N/A

User

erp-green-arrows.png

User

Projects

Show/Hide Data Mapping

PROCORE

DATA SYNC

RESOURCE PLANNING

Project Name

erp-orange-arrows.png

Project Name

Status (Active, Inactive)

erp-orange-arrows.png

Status (Active, Inactive)

Stage

erp-orange-arrows.png

Job Stage

Project Number

erp-orange-arrows.png

Project Number

Address

erp-orange-arrows.png

Address 1

City

erp-orange-arrows.png

City

ZIP

erp-orange-arrows.png

Postal Code

Timezone

erp-orange-arrows.png

Timezone

Start Date

erp-orange-arrows.png

Start Date

Completion Date

erp-orange-arrows.png

Est. End Date

See Also

Loading related articles...