Company: Link Technologies
Case No: L12839. Project: 14.50: LinkSOFT Version 14.50 - March 2023
Logged By: Sanjay (Link Technologies) on 07 Feb 2023 09:34AM
Priority: Low
Product: Payroll & HR
Group: Enhancement
Time Taken: 18.00
Assigned To: Development
Circulation: Development, Sanjay
Resolve By: Friday, 17 February 2023 12:00 AM [435 days since logged date]
Status: Closed
Subject: Purge Data to include TNA data past a certain date

Purge Data to include TNA data past a certain date - Issue with Jacks keeping data which is 2 years old.

  1. Add Cleanup of Analysis data in Purge.
  2. In Process ESS021
    1. Add a configuration to "DELETE" Archive after X number of days. This will permanently delete archive records. Parameter Name: TimesheetImport.DeleteArchiveRecordDays  Value: 90
    2. Change the default value of "TimesheetImport.ArchiveRecordsDays" to 30
Audit Notes:Edited by sanjay on 17/02/23 11:31. Edited by sanjay on 14/02/23 18:26. Edited by sanjay on 07/02/23 09:34. 
15 Feb 202302:29PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 24-02-2023 02:26 PM Time Taken: 12.00
PART A - Development work for this case has been completed.

1. The change will be available in version: 14.50

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

  1. Changed Process ESS021 Rule: TimesheetImport.ArchiveRecordsDays to 30
  2. Added Rule: TimesheetImport.DeleteRecordsDays. Default 365
  3. Added function to Cleanup Archived records based on 2 above. 

3. Affected Areas:

  1. TNA Records stored in Archive

4. The issue was caused by:

  1. Excessive database size when keeping Timesheet Records indefinitely. We remove this from LinkSOFt as the TNA system hols all these records and we do not use them in LinkSOFT after a certain date.

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

01 Mar 202309:18AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 10-03-2023 09:16 AM Time Taken: 6.00
The following tests were performed:

Test Setup Instructions:
  1. Setup TNA for TI001 and TI002
  2. Import Data as of 1st Jan 2023 - Batch 1
  3. Import another batch as at 01/02/2023 - Batch 2
Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Set Automatic Archive to 10 days
Batch 1 should be sent to Archive. No Data should be deleted

2Set Delete days to 10 days
Batch 1 should be deleted. Batch 2 should remain in place




Environment Details

  1. OS version: Win11
  2. Application version: 14.50
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure

If you have any queries regarding this support incident, please email and include the Case No: L12839 in the subject line of all emails regarding this issue.

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