Extracting Data for Terminated Employees
This section provides an overview of the data extraction process and discusses how to run the data retrieval process.
After processing and finalizing the off-cycle payroll group containing the terminated employees, run the Termination Data Application Engine process (GPFR_ASS_AE) to extract the data needed to produce the ASSEDIC certificate, the Work Certificate, and the Last Payment Receipt from Global Payroll and HR records. The Application Engine process loads the data into staging tables where it can be prepared and updated prior to generating the termination reports.
The data retrieved for the termination reports comes from tables and records in Global Payroll and HR.
Tables |
Purpose |
---|---|
GPFR_ASS_COMP |
Displays and records data concerning company and establishment information. |
GPFR_ASS_PAYEE |
Displays and records data concerning the employee. |
GPFR_ASS_RUNCTL |
Displays and records data concerning the process of mass edition. Enables the capture of the Frame 9 ASSEDIC certificate information and the selection of departing employees. |
GPFR_ASS_SELECT |
Displays and records the main data retrieval process information. |
GPFR_ASS_PRINT |
Displays and records employees requiring an ASSEDIC certificate. Note: Another record (GPFR_ASS_PRINT2) is built with the same definition. Its purpose is to make the connection between the payees to print and the queries defined for the report. |
GPFR_ASS_WAGE_1 |
Displays and records data concerning the wages and period of pay during the last 12 months. |
GPFR_ASS_WAGE_2 |
Displays and records data concerning bonus or compensation other than monthly salary. |
GPFR_ASS_WAGE_3 |
Displays and records data concerning the amounts paid after the last complete month. |
GPFR_ASS_WA |
Stores the results of accumulators after each payroll run. Application Engine reads this table to insert and update the record-dedicated writable array results concerning wages. The writable array for this functionality is GP WA AA ELMT. |
GPFR_ASS_SECU |
Stores the security number required for Pôle Emploi control services. |
GPFR_LPR_PAYEE |
Stores employee information for the last payment receipt. |
GPFR_WC_PAYEE |
Stores employment begin and end dates, plus a comment for the employee that is used in the work certificate. |
GPFR_WC_POS |
Stores employees' job descriptions that are required for the work certificate. |
Verify that you have selected payees for the final payroll process using the delivered GEN VR TEST DEPART variable or a variable you have defined yourself. The employee's data is retrieved only if this variable equals 1 (meaning the employee has left during the month). You must identify the variable you are using on the Element Mapping Codes FRA page.