Longevity Bonus Batch Job

The Longevity Bonus batch job is added to automatically initiate longevity bonuses, via finalized ESMT transactions, for employees who meet the criteria to receive longevity bonuses. This batch job is run prior to regular GTN every pay period.

The batch job first selects employees based on the Payroll Number job parameter and the current Pay Period on PERD. Out of the employees selected, the job looks for employees that are in Employment Statuses where the EMPS Count in Workforce box is checked. If an employee is in an Employment Status that has the EMPS Count in Workforce box unchecked, that employee will not be selected for the Longevity Bonus batch job. From these selected employees, the job looks for employees that are in Titles/Sub-Titles that have the Eligible for Longevity Bonus check box set to true on STTL. If an employee has a Title/Sub-Title that is eligible for longevity bonus, the batch job looks to the LONB table for any entries with matching Title/Sub-Title that is effective on the Pay Period End Date of the Pay Period being processed. For every matching Title/Sub-Title LONB entry found that is effective on the Pay Period End Date, the batch job checks if the Check Evaluation check box is set to true. If Check Evaluation is set to true, the job checks whether the employee had met the employee performance evaluation criteria. The job searches the PERF_SUMMARY table for the employee’s evaluation record that is equal to or less than the current date for the employee’s assignment, with the Eval Typ Cd equal to the value entered in Evaluation Type field on LONB. The job then obtain the value on the Career Rtng Cd field of the PERF_SUMMARY record and query the CAREER_RATNG table using this Career Rtng Cd value. If the Rating Category field on the associated entry on CAREER_RATING is Process Increase, the employee is selected along with the employees in the Title/Sub-Title with the Check Evaluation flag set to false on LONB.

For every LONB entry that contain the employee’s Title/Sub-Title, the batch job computes the accumulated total time across all assignment time slices that the employee had ever worked under all the Titles/Sub-Titles entered on the Title and Sub-Title tab of the LONB entry, until the Pay Period End Date. The batch job then compares this accumulated total to the Number of Months in Title entered on the main tab. If the total is equal to or greater than the Number of Months in Title, then the employee is eligible for this longevity bonus and the ESMT transaction creation process is initiated for the employee. Out of all the LONB entries with the same groups of Title/Sub-Title combination, the batch job selects the LONB entry with the highest Number of Months in Title that the employee qualifies for and populate the ESMT transactions based on that entry. If the employee qualifies for more than one longevity bonus, new Pay Parameter lines are created for all bonus events in the ESMT transactions.

The ESMT transactions creation process created populates the ESMT with all employee assignment values as of the From date of the generated ESMT for the employee, including all Pay Parameter information, except the following:

From - The first day of the pay period, within the current pay period defined on PERD, when the employee meets the criteria for the bonus.
To -The ESMT processor automatically derives this date when the transaction is submitted.
Personnel Action Code - ESMT Personnel Action Code on LONB.
Personnel Action Reason - ESMT Personnel Action Reason on LONB.
Pay Parameter - In addition to the employee’s current Pay Parameter information, a new line is added.

Pay Type - Bonus Pay Event on LONB
Amount/Percent Indicator - Amount if Bonus Amount is entered on LONB, Percent if Bonus % is entered on LONB.
Amount - Bonus Amount on LONB if it is entered on LONB, blank otherwise.
Percent - Bonus % on LONB if it is entered on LONB, blank otherwise.
From - Equal to From date on the ESMT header for all Pay Parameter lines.