Merging French Public Sector and Human Resources Files

This chapter provides an overview of the merge process and discusses how to:

Execute the merge.
View merged records.

Understanding the Merge Process

The merge process provides an interface between Manage French Public Sector and various PeopleSoft Enterprise Human Resources business processes. This process is mandatory.

As soon as the personnel manager completes the first step in the FPS hiring process, the pre-hired employee is available in all Human Resources components.

If an employee is transferred from one department to another, the effect on Human Resources security begins for the non-FPS components only after the merge is executed.

The merge process consists of feeding and updating the standard JOB, JOB_JR, and COMPENSATION tables (job data) with various Manage French Public Sector tables. The system considers only actual actions, not requests. The merge process is possible only after the hire is validated.

Each event in the employee record corresponds to a move in the merged record. When the same event, which has the same action and effective date, appears in various parts of the employee record, only one row is created in the merged record.

When two events have been registered in two different parts of the record on the same date, the process generates two rows in the merged record.

There are three SQR processes to merge data:

The Merge Application Engine process (FPA0501).

This process updates the JOB, JOB_JR, and COMPENSATION tables for a particular employee ID and employee record number. You start this process manually.
The Merge All Application Engine process (FPA0503).

This process updates the JOB, JOB_JR, and COMPENSATION tables for all employee IDs and record numbers that have been modified since the last update according to the following guidelines:
- If a row is deleted in the employee record, the record is stored by the hiring date.
- If there are only updates and creations, the record is reconstituted from the earliest effective date.
  
  It is recommended that you run this process each night. You must schedule this process.
The Merge All process (FPA504).

This processes the merge for all employee IDs and record numbers. This process is delivered by PeopleSoft and can be run using sqrw.exe. Run this process once before going live to create JOB data.

Executing the Merge

This section discusses how to merge data for a specified employee and record number.

Pages Used to Execute the Merge

Page Name	Object Name	Navigation	Usage
Merge Process - Empl Rcd (merge process - employee record)	RUNCTL_FPA50X	Workforce Administration, Job Information, Merge Employee Record FPS	Run the Merge process (FPA501) to merge data for a specified employee ID and record number.
Merge Process - All	PRCSRUNCNTL	Workforce Administration, Collective Processes, Merge All Employee Records FPS	Run the Merge All process (FPA503) to merge data for all employee IDs and record numbers.

Merging Data for a Specified Employee ID and Record Number

Access the Merge Process - Empl Rcd page.

Select the date and employee ID.

The date that you select enables the system to select and merge all actions with effective dates that are later than or equal to the selected date. To merge the entire career of an employee, enter a date that is earlier than or equal to the hire date.

Viewing Merged Records

This section discusses how to view merged records.

Pages Used to View Merged Records

Page Name	Object Name	Navigation	Usage
Job Data - Career	FPAJOB_SUM1	Workforce Administration, Job Information, Review Job Information, Job Data FPS, Job Data - Career	View an employee’s career information.
Job Data - Assignment	FPAJOB_SUM2	Workforce Administration, Job Information, Review Job Information, Job Data FPS, Job Data - Assignment	View an employee’s assignment information.
Job Data - Compensation	FPAEESCP_PNL	Workforce Administration, Job Information, Review Job Information, Job Data FPS, Job Data - Compensation	View an employee’s compensation information.
Job Data	FPAJOB_SUM4	Workforce Administration, Job Information, Review Job Information, Job Data FPS, Job Data	View an employee’s job data information.
Job Data History 1	FPAJOB_SUM_PNL	Workforce Administration, Job Information, Review Job Information, Job Data History FPS, Job Data History 1	View an employee’s career history derived from all the merged records.
Job Data History 2	FPAJOB_SUM2_PNL	Workforce Administration, Job Information, Review Job Information, Job Data History FPS, Job Data History 2	View an employee’s career history derived from all the merged records.
Merge Process Results	FPA_CI_RSLT_PNL	Workforce Administration, Collective Processes, Review Merge Results FPS	View the merge process results.