Company: Link Technologies
Case No: L12844. Project: 14.50: LinkSOFT Version 14.50 - March 2023
Logged By: Sanjay (Link Technologies) on 23 Feb 2023 08:41AM
Priority: Low
Product: Payroll & HR
Group: Enhancement
Time Taken: 27.00
Assigned To: Development
Circulation: Development, Sanjay, Sitla Sharma, Vineet, Vineshwar Prasad
Resolve By: Friday, 24 February 2023 12:00 AM [419 days since logged date]
Status: Closed
Subject: Add "Start Date" to TNA Mapping and restrict TNA Import Data based on Employee Mapping and "START DATE"

In order to facilitate the staged rollout of TNA, we need a way to restrict only certain employees' data to flow from the TNA device into LinkSOFT.

To achieve this, we propose a design as follows:

  1. Add a "Start Date" to the TNA Employee Mapping
  2. Change the TNA Import to only import data where there is a TNA Mapping
  3. Allow TNA Mapping to be deleted in bulk
  4. Allow TNA Mapping to be edited
Audit Notes:
23 Feb 202307:37PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 10-03-2023 07:30 PM Time Taken: 26.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. Added "Start Date" to TNA Employee Mapping. When "Start Date" is not specified, there is no restriction to "TimeSheet Imports". When a "Start Date" is specified, data before the "Start Date" will be marked as "Deleted" and not be processed.
  2. Changed TNA Import for all Devices to implement restrictions in 2.1 above
  3. Changed TNA Data View to show more data in the TNA Data Source menu
  4. Added option to automatically "Delete TNA Archive Data" after "X" days. This is configured in the TNA process "ESS021" and has a default of "100 Days"
  5. Changed Documentation to reflect the above

3. Affected Areas:

  1. TNA Setup, Process Setup, TNA Processing Rules

4. The issue was caused by:

  1. Enhancements from User Feedback

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

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

Test Setup Instructions:
  1. Setup TNA TI001
  2. Set import file to use Employee E001 with no START Date, Employee E002 with Start Date 01/03/2023
  3. Setup TI001 to have data for both employees and some with the date 25th Jan 2023 and some with 25 FEB 2023
Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1TNA import should mark as DELETED Employee E002 where the Start date is 25/01/2023, and let the rest through



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: L12844 in the subject line of all emails regarding this issue.

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