Company: Link Technologies
Case No: L08887. Project: 08.20: LinkSOFT Version 8.2
Logged By: Sanjeet (Link Business Solutions) on 27 Oct 2017 10:04AM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 3.50 (Weight: 3.50)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjeet
Resolve By: Wednesday, 25 October 2017 09:23 PM [2366 days since logged date]
Status: Closed
Subject: Timesheet Import Log Report does not show Absent Data
Summary:    
Bula Team                          
 
Kindly requesting assistance on the issue below.
 
Cheers
Prab
 
From: Priya Chand [mailto:priya.chand@lta.com.fj]
Sent: Wednesday, 25 October 2017 9:10 AM
To: 'Prab Padarath' <prabhakar.padarath@lta.com.fj>
Cc: sakeasi.tawaketini@lta.com.fj; matila.cama@lta.com.fj
Subject: Absent Report

Hi Prab
 
Kindly seeking your assistance, as I was trying to generate absent report, there is no records to be displayed.
 
Please advise with urgency as I need to submit absent report to General & Regional Managers.
 

 
Kind Regards
Priya Darshni chand
Human Resources Officer – Information System & Leave
Human Resources Department
Land Transport Authority
T: (679) 3392166  F: (679)3398925
Audit Notes:
27 Oct 201710:06AM Comment 1 by Sanjeet (Link Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 27-10-2017 10:06 AM Time Taken: 0.50
Bug on line 273 of function LT_ESS_RPT_TimesheetImportLog_fx
Replaced "AND e.EMP_STATUS LIKE @FLD03" with  this "AND ( @FLD03 = 'AL' AND e.EMP_STATUS IN ('A','L') OR e.EMP_STATUS LIKE @FLD03)"


Also I have added the following Index's
USE [LINKSOFT]
GO
CREATE NONCLUSTERED INDEX [IDX_TimeSheetImportLogReport_]
ON [dbo].[HR_POSITION] ([COMPANY_ID],[REPORTS_TO])

GO

USE [LINKSOFT]
GO
CREATE NONCLUSTERED INDEX [IDX_TimeSheetImportLogReport_1]
ON [dbo].[HR_POSITION] ([COMPANY_ID],[void])
INCLUDE ([POSITION_ID])
GO


USE [LINKSOFT]
GO
CREATE NONCLUSTERED INDEX [IDX_TimeSheetImportLogReport_2]
ON [dbo].[HR_EMPLOYEE] ([COMPANY_ID],[EMP_STATUS])
INCLUDE ([EMPLOYEE_ID],[POSITION_ID])
GO

27 Oct 201710:53AM Comment 2 by Alvis (Link Technologies) Case 8887 added to project 8.19
27 Oct 201710:58AM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-10-2017 10:58 AM Time Taken: 2.00

The following changes were done:

  1. Changed timesheet report to use function LT_HRM_GetEmployeeListForReports_fx to get a list of employees to filter in the report.
  2. Added index on HR_POSITION table for CompanyID and ReportsTo column.

The other indexes were not created as I will need sample client data to verify the index performance.



16 Nov 201703:23PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 16-11-2017 03:23 PM Time Taken: 1.00

Tested case in QA1 with LTA Database. Version 819 Beta 1

Table 1 - Summarised list of issues
NoIssue Description Resolved? 
1 Users should be able to generate data with "Absentees" filter  Pass
2 Users should be able to generate data with "Incomplete Time Entries" filter  Pass
3 Users should be able to generate data with "Late Arrivals" filter  Pass
4 Users should be able to generate data with "Time Entries" filter  Pass

Figure 1: Absentees Report



    09 Oct 201908:14AM Comment 5 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019
    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L08887 in the subject line of all emails regarding this issue.

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