Company: Link Technologies
Case No: L13018. Project: 15.30: LinkSOFT Version 15.30
Logged By: Sanjay (Link Technologies) on 10 Apr 2024 10:20AM
Priority: High
Product: Payroll & HR
Group: Enhancement
Time Taken: 19.00 (Weight: 14.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay, Vineet, Vineshwar Prasad
Resolve By: Friday, 12 April 2024 02:13 PM [225 days since logged date]
Status: Closed
Subject: Closing pay takes a long time if there are a large number of employees
Summary:    Closing pay takes a long time if there are a large number of employees. This was observed at GFI where pay can contain up to 700 employees and employees' time is fed by TNA. In this instance, pay close took 3 hours and 30 minutes to complete.
Audit Notes:Edited by sanjay on 10/04/24 10:20. 
10 Apr 202410:19AM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 12-04-2024 02:13 PM Time Taken: 18.00 Notes: ETC extended from: 10/04/2024 to 12/04/2024
PART A - Development work for this case has been completed.

1. The change will be available in version: 15.30 and 15.20.240409 Patch

2. The following changes were made (Include Database object names, Program classes, and any other relevant information):

  1. When pay is closed, we finalize LEAVE entries for all Employee / Leave combinations instead of just the leave allocated to an employee. This took a lot of time especially when there were a lot of Leave codes in the system. 
  2. Added index on "Time Entry" to allow for employees that have a TNA Feed
  3. Added Index on "Pay History" for employees that have a TNA feed
  4. Added Event Logging to show time taken for Pay Close as well as Leave Processing

3. Affected Areas:

  1. Pay Processing form - Close Pay function

4. The issue was caused by:

  1. Missing Index when TNA feed is providing Payroll data
  2. Processing Employee/Leave combinations that was not required

5. Other Relevant Notes: 
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT


PART B - Development Reference (Place descriptor for objects changed):

  1. Reduced time taken to Close pay from 3 hours 30 min to under 5 minutes.

16 Apr 202403:45PM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 18-04-2024 07:44 PM Time Taken: 1.00
Closing case. Same as L13017

If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L13018 in the subject line of all emails regarding this issue.

Document size: 3.8 KB
For call complaints, please contact the Managing Director of the company using this form.