Costpoint Help

Talent Management to Costpoint Integration

The integration provides the ability to import new hires from Talent Management to Costpoint.

Costpoint will take the data provided by Talent Management and potentially populate fields in the following Costpoint tables:

  • Employee Regular Timesheet Defaults (DFLT_REG_TS)
  • Employee (EMPL)
  • Employee Salary/Labor Info (EMPL_LAB_INFO)
  • Employee Phone (EMPL_PHONE)
  • Employee Tax (EMPL_TAX)
  • Manage Employee Security Clearance (EMPL_SEC_CLR)
  • Employee Skills (H_EMPL_SKILLS)
  • Manage Job Templates (H_POS_RQ_RQST)
  • Manage Job Templates Employee Subtask (H_POS_RQ_RQST_EMPL)

Besides the values coming directly from Talent Management, there are other fields which will default from other sources which can include the optional CP Job Template.


EMPL

The Employee (EMPL) table stores basic information about the employees.

DFLT_REG_TS

The Timesheet Line Defaults (DFLT_REG_TS) table stores timesheet default values for the employee for Talent Management staging.

EMPL_PHONE

The Employee Phone (EMPL_PHONE) table stores the phone number information of employees.

EMPL_LAB_INFO

The Salary Information and History (EMPL_LAB_INFO) table stores the employee's labor information as well as salary amounts.

EMPL_TAX

The Employee Tax (EMPL_TAX) table stores employee federal and state W-4 information.

EMPL_SEC_CLR

The Manage Employee Security Clearances (EMPL_SEC_CLR) table stores information on the security statuses assigned to employees.

H_EMPL_SKILLS

The Employee Skills (H_EMPL_SKILLS) table stores information on skills assigned to employees.

H_POS_RQ_RQST

The Manage Job Templates (H_POS_RQ_RQST) table stores numbers assigned to job requests templates as well as optional requisition information, such as the approval information, target date, and whether the job is a new position or fills a vacancy.

H_POS_RQ_RQST_EMPL

The Manage Job Templates Employee Subtask (H_POS_RQ_RQST_EMPL) table stores employees assigned to the job requisition.


Parent Topic:

Costpoint - Talent Management Integration