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

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

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:

  • Parameter validation: The batch job checks that the entered parameter value for Retro Run Number is a non-zero positive number.

  • Selection of Records: The job selects all records from the temporary retro deduction tables associated with the retro run number entered as a job parameter.  

  • Processing steps:

  • The job then copies the selected records which are the newly created retro deduction adjustments to the Pending Deduction table.

  • All the selected records are then purged from the temporary retro deduction tables

Retro Deduction Processing

Retro Deduction Calculation

The Retro Deduction Calculation step performs three key functions:

  1. Sorts the files of extracted data needed to calculate Retro Deductions

  2. Determines the Retro Deductions and creates offsetting Retro Pend Deduction entries

  3. Generates a Detail Processing Report

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.

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:

  • Parameter validation: The batch job checks that the entered parameter value for Retro Run Number is a non-zero positive number.

  • Selection of Records: The job selects all records from the Retro Trigger tables associated with the retro run number entered as a job parameter.  

  • Processing steps:

  • All the selected records are purged from the Retro Triggers tables

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