Understanding the PeopleSoft Enterprise HRMS to JD Edwards EnterpriseOne Address Book Integration

This chapter discusses:

• Release levels

• Business process

• Integration architecture

Release Levels

This document supports the integration between JD Edwards EnterpriseOne 8.12 Address Book and PeopleSoft Enterprise 8.9 HRMS.

Business Process

You use the PeopleSoft Enterprise HRMS to JD Edwards EnterpriseOne Address Book integration to synchronize personnel data from PeopleSoft Enterprise HRMS with JD Edwards EnterpriseOne Address Book.

This integration is useful if you are using one or more PeopleSoft Enterprise systems but you conduct other business functions involving employees in the JD Edwards EnterpriseOne system. For example, you might use the PeopleSoft Enterprise payroll system and the JD Edwards EnterpriseOne Expense Management system.

The major tasks involved in the integration of PeopleSoft Enterprise HRMS with JD Edwards EnterpriseOne Address Book are:

• Setting up integration options and code cross-referencing in the JD Edwards EnterpriseOne WSG soft-coding/cross-reference database.

• Setting up the integration in the PeopleSoft Enterprise database.

• Loading a batch of PeopleSoft Enterprise personnel data into the JD Edwards EnterpriseOne system.

• Synchronizing incremental changes in PeopleSoft Enterprise personnel data with the JD Edwards EnterpriseOne system.

Integration Architecture

You can run this integration as a batch process to perform an initial load of the data. You can also enable this integration to synchronize person information in real time when a new employee is added or information for an existing employee changes.

This diagram illustrates the basic integration tasks:

PeopleSoft Enterprise HRMS to JD Edwards EnterpriseOne Address Book process flow

The PeopleSoft Enterprise HRMS to JD Edwards EnterpriseOne Address Book integration consists of these major steps:

1. The PeopleSoft Enterprise EIP generates either of these messages:

   1. PERSON_BASIC_FULLSYNC - This transaction is used for the initial load of the employee information and contains records for multiple employees.

   2. PERSON_BASIC_SYNC - This transaction is used each time an employee record is added, changed, or deleted in PeopleSoft Enterprise and contains a record for only one employee.

2. The Integration Server delivers the file to the E_Employee_To_E1_Employee flow, which invokes the processAddressBook interface flow.

   Note. This integration uses two different flows named E_Employee_To_E1_Employee: PSFT_JD Edwards EnterpriseOne_HRMS.Employee.InitialBatchLoads.E_Employee_To_E1_AddressBook and PSFT_JD Edwards EnterpriseOne_HRMS.Employee.RealTimeDataSyncs.E_Employee_To_E1_AddressBook. The flow in the InitialBatchLoads folder processes the PERSON_BASIC_FULLSYNC message and the flow in the RealTimeDataSyncs folder processes the PERSON_BASIC_SYNC message. Both flows invoke the processAddressBook interface flow.

3. The processAddressBook interface flow calls JD Edwards EnterpriseOne business functions to add, change, or delete the employee information in the Address Book Master table (F0101), the Address Book - Contact Phone Numbers table (F0115), and the Electronic Address table (F01151).