Advanced Batch Processing
The Deduction Processing functional area consists of several batch and report jobs that are listed under several different areas in the Batch Catalog. The jobs are listed alphabetically Batch Catalog section wise in the below table and the last column indicates the location in the Batch Catalog. For detailed information on the jobs (such as input, output, and process parameters, and when to run the job), please refer to the CGI Advantage HRM Runsheet Guides.
|
Batch Job Name |
Description |
Batch Catalog section |
|---|---|---|
|
Deduction Adjustment |
This chain job creates deduction adjustments based on the employee Health Insurance Eligibility (HINS) status and creates and loads One-Time Deductions accordingly. |
On Request Processing |
|
Deduction Mass Change |
Deduction Mass Change job is used for Deduction Attribute Change, Deduction Mass Expiration and Deduction Move to or Create a New Type/Plan in a large scale. The job reads data from Deduction Parameter table to create new transaction. The data in the operational tables are updated when the transaction is submitted. The minimum effective date and maximum expiration date are retrieved from DED_MAS_CHG table. Deduction records, that are effective within these dates, are retrieved from DED_PARM table. For each Deduction record’s effective and expiration dates, deduction mass change records are retrieved. For each deduction mass change record, the selection criteria are matched with data in the current deduction Parameter record. If the selection criteria are matched, then a transaction is created for the Request Type in that deduction mass change record. If selection criteria are not matched, then the next deduction mass change record is matched against the current Deduction Parameter record and the process continues until all deduction mass change records are processed. A separate PDF report is generated for each deduction transaction at the end that contains Selection Criteria, Revised Criteria of MAS5 and deduction transaction information. Mass Change can create ENRL, MISC, NPD and PENS transactions. |
On Request Processing |
|
Deduction Rollup |
The Deduction Rollup batch job organizes deduction types and deduction plans in the Deduction Plan Rollup table by indicating the root deduction and any associated Employer Contribution, Cafeteria After-Tax Deduction and Secondary Deduction. The batch job records the level of each deduction to the corresponding root deduction. |
On Request Processing |
|
Evaluate Employee Deductions/Benefits |
The Evaluate Employee Deductions/Benefits batch job evaluates the eligibility of employee deductions/benefits and then expires the deductions/benefits accordingly. This job, when run independent of the Personnel Action Wizard, retrieves triggers from the ESMT Deduction Trigger Table, evaluates them on the basis of Rules established on PAWRDB Rules page, and expires the deductions/benefits. |
On Request Processing |
|
Personnel Action Wizard Batch Job for Deductions |
The Personnel Action Wizard Batch Job for Deductions evaluates the eligibility of Deductions/Benefits Triggers and then expires the deductions/benefits accordingly by creating the respective transactions. |
On Request Processing |
|
Recovery of Outstanding Balances at Termination |
The Recovery of Outstanding Balances at Termination job is run to generate One Time Deduction (OTDED) / One Time Pay (OTPAY) transactions to recover pending deductions or pending payments from terminated employees. This job is run prior to regular Gross-to-Net cycle. |
On Request Processing |
|
Unrecovered Deductions and Earnings Balances |
If an employee’s final paycheck is not enough to cover the outstanding balance, all funds are retained from the paycheck and the employee is listed on the report: Unrecovered Deductions and Earnings Balances. This report lists all pending deductions and payments not recovered in the employee’s final paycheck. The report job is scheduled after GTN completes processing. It compares those ‘Recovery at Termination’ triggers that have the Recover Balance on Termination check box selected with Pending Pays and Pending Deductions that are generated from GTN (of the final paycheck). If there is a match, this means that the employee’s paycheck does not have sufficient funds to recover all outstanding balances. This report lists all pending deductions and payments not recovered in the employee’s final paycheck and the employee is then listed on this report. |
On Request Processing |
|
Generate Bank Notification Extract File - Deduction (HA00600C) |
Generate Bank Notification Extract File - Deduction reads the paycycle tables and produces the following extract files: Deduction Register Processing, Savings Bond Processing, the extract required for the Savings Bond Tapes, and the extract required for EFT deductions. |
Paycycle Processing |
|
Payroll Accounting Transaction Generator |
Generates and passes on Employee name and other required data to the Advantage Financial application (eCAPS) as part of the Payroll Accounting Management (PAM) interface so that the data can be printed on the warrant and stub for garnishment, support, and tax levy warrants. |
Paycycle Processing |
|
Delete/Reset Retro Deduction Triggers |
Delete/Reset Retro Deduction Triggers deletes or resets retro triggers after running the Select Retro Deduction Trigger Process. Running Delete/Reset Retro Triggers resets the current retroactive deduction process, and you will have to start the process over again starting with the Select Retro Deduction Trigger job. This job is used if the retro triggers selected for processing should not have been selected. |
Retro Deduction Processing |
|
Extract Data for Retro Calculations |
The Extract Data for Retro Calculations process will extract and collect data from the Pending Pay table, Pay Detail table, Archived Pay Details, Deduction Detail table, Archived Deduction Details, and Pending Deduction table for each of the employees and pay periods referenced in the selected retro deduction triggers. Archived pay and deduction details must be available on a file. These records will be read into and processed by the batch process immediately, just like the non-archived pay and deduction details. The input to this process will be the retro deduction trigger file. The output from this batch program will be a file of relevant pay and deduction details. Statistics from this process (including how many records are read from which table) will be seen on the job log. |
Retro Deduction Processing |
|
Process Retro Pending Deductions |
The Process Retro Pending Deductions job along with Retro Run Cleanup job forms the final steps in the retro deduction batch processes. The Process Retro Pending Deductions job loads the newly created retro deduction adjustments to the Pending Deduction table, then purges all records on any temporary retro deduction tables associated with the retro run number entered as a job parameter. This job will run directly after the Retro Deduction Calculation job. The input for this job will be the retro deduction adjustment details and the new 'Retro Deduction Run Cleanup' batch parameter. The various steps in the Process Retro Pending Deductions process are as follows:
|
Retro Deduction Processing |
|
Retro Deduction Calculation |
The Retro Deduction Calculation step performs three key functions:
Retro Deduction Calculation (HAB3620) uses the output from Extract Data for Retro Deduction to call the Gross-to-net Deduction (HAB2150) program to recalculate the Deductions. The process will then compare the new deductions to the previously generated deductions for the same period. Any differences will be outputted to the Retro Pending Deduction table to be processed at a later time into Pending Deductions for input into Gross-to-Net run. The Retro Deduction Processing Detail Report (HAR3640) will read the file of Retro Pending Deduction records producing a detail processing report. When the Retro Deduction Calculation batch job is executed in Retro FLSA Mode*, the Employer Contribution and Taxable Cash amounts are recalculated and populated on the CAFÉ_FLSA database table. *Note - this functionality is only available for sites utilizing the Next Generation payroll service. |
Retro Deduction Processing |
|
Retro Deduction Processing |
The retro deduction process will consist of the following batch jobs: Select Retro Deduction Triggers, Delete/Reset Retro Deduction Triggers, Extract Data for Retro Calculations, Retro Deduction Calculation, Process Retro Pending Deductions, and Retro Run Cleanup. The process will be run on an as-needed basis to pick up all of the retro triggers with Type IDs of Deduction–Salary Change and Deduction–Ded Change. If retroactive pay processing is required, then the retroactive pay process must be run before the retroactive deduction process to ensure that all pay details are included in the case where both adjustment types are needed for an employee. |
Retro Deduction Processing |
|
Retro Run Cleanup |
The Retro Run Cleanup job along with Process Retro Pending Deductions job forms the final steps in the retro deduction batch processes. The Retro Run Cleanup job purges the retro trigger table; all RTRG deduction records with the selected Retro Run Number are deleted. This job runs after the next regular Gross-to-Net cycle is complete. The input for this job will be the RTRG table and the new 'Retro Deduction Run Cleanup' batch parameter. The various steps in the ”Retro Run Cleanup” process are as follows:
|
Retro Deduction Processing |
|
Select Retro Deduction Triggers |
Select Retro Deduction Trigger (HAB3600) scans through the Retro Trigger Selection (RSEL) table selecting entries based on the input parameters to Select Retro Trigger (RTRG) Table entries for processing. Selected triggers are written to a file. This job must be run for all employment statuses before running the Regular GTN cycle. |
Retro Deduction Processing |