12:34:52 - IsConnectionValid True 12:34:55 - IsConnectionValid True 12:34:56 - IsConnectionValid True 12:35:01 - IsConnectionValid True 12:35:02 - IsConnectionValid True 12:35:04 - IsConnectionValid True 12:35:08 - IsConnectionValid True 12:35:14 - IsConnectionValid True 12:35:14 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:35:17 - IsConnectionValid True 12:35:17 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1774 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:35:18 - IsConnectionValid True 12:35:18 - IsConnectionValid True 12:35:18 - IsConnectionValid True 12:35:18 - IsConnectionValid True 12:35:18 - IsConnectionValid True 12:35:18 - IsConnectionValid True 12:35:18 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 12:35:18 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 12:35:18 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - IsConnectionValid True 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - IsConnectionValid True 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=3) OR ExtensionsID=0) ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=6) OR ExtensionsID=0) ORDER BY ID Query 12:35:19 - IsConnectionValid True 12:35:19 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 815 WHERE LocationDef.TenantID =1 Query 12:35:19 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 815 WHERE CustodyItemsDef.TenantID =1 Query 12:35:19 - IsConnectionValid True 12:35:19 - IsConnectionValid True 12:35:19 - SELECT * FROM HRMS_vwEmp_Contracts WHERE TenantID =1 and EmployeeID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=16) OR ExtensionsID=0) ORDER BY ContractDate Desc Query 12:35:19 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =815 AND Emp.MasterID =0 Query 12:35:19 - IsConnectionValid True 12:35:19 - IsConnectionValid True 12:35:19 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:35:19 - IsConnectionValid True 12:35:19 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:35:19 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:35:19 - IsConnectionValid True 12:35:19 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:35:19 - IsConnectionValid True 12:35:19 - IsConnectionValid True 12:35:19 - IsConnectionValid True 12:35:19 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 12:35:20 - IsConnectionValid True 12:35:20 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 12:35:21 - IsConnectionValid True 12:35:21 - IsConnectionValid True 12:35:21 - IsConnectionValid True 12:35:21 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:35:21 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 12:35:21 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 and IsManager = @val3 and ID <> @val4 ORDER BY ID Query 12:35:33 - IsConnectionValid True 12:35:33 - 2025-06-01 dateleft :: 06/01/2025 12:35:33 - IsConnectionValid True 12:35:33 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:37:12 - IsConnectionValid True 12:37:12 - IsConnectionValid True 12:37:12 - IsConnectionValid True 12:37:12 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 12:37:12 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 and IsManager = @val3 and ID <> @val4 ORDER BY ID Query 12:37:12 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:16 - IsConnectionValid True 12:37:16 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:37:17 - IsConnectionValid True 12:37:19 - IsConnectionValid True 12:37:19 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:37:20 - IsConnectionValid True 12:37:20 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1777 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 12:37:22 - IsConnectionValid True 12:37:22 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 12:37:22 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 12:37:22 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 12:37:22 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:22 - IsConnectionValid True 12:37:22 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 12:37:22 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:22 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:22 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:22 - IsConnectionValid True 12:37:22 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:22 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 12:37:22 - IsConnectionValid True 12:37:22 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:22 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:22 - IsConnectionValid True 12:37:22 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:22 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:22 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:22 - IsConnectionValid True 12:37:22 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=3) OR ExtensionsID=0) ORDER BY ID Query 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:22 - IsConnectionValid True 12:37:22 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:22 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=6) OR ExtensionsID=0) ORDER BY ID Query 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 12:37:22 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 818 WHERE LocationDef.TenantID =1 Query 12:37:22 - IsConnectionValid True 12:37:22 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =818 AND Emp.MasterID =0 Query 12:37:22 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 818 WHERE CustodyItemsDef.TenantID =1 Query 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:37:22 - SELECT * FROM HRMS_vwEmp_Contracts WHERE TenantID =1 and EmployeeID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=16) OR ExtensionsID=0) ORDER BY ContractDate Desc Query 12:37:22 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:22 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:37:22 - IsConnectionValid True 12:37:22 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:37:23 - IsConnectionValid True 12:37:23 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 12:37:23 - IsConnectionValid True 12:37:23 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 12:37:24 - IsConnectionValid True 12:37:24 - IsConnectionValid True 12:37:24 - IsConnectionValid True 12:37:24 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 12:37:24 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:37:24 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 and IsManager = @val3 and ID <> @val4 ORDER BY ID Query 12:37:31 - IsConnectionValid True 12:37:31 - 2025-06-30 dateleft :: 06/30/2025 12:37:31 - IsConnectionValid True 12:37:31 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:42:52 - IsConnectionValid True 12:42:53 - IsConnectionValid True 12:42:53 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:42:55 - IsConnectionValid True 12:42:55 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1831 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:43:01 - IsConnectionValid True 12:43:01 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1831 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:43:01 - IsConnectionValid True 12:43:01 - IsConnectionValid True 12:43:01 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 12:43:01 - IsConnectionValid True 12:43:01 - IsConnectionValid True 12:43:01 - IsConnectionValid True 12:43:01 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 12:43:01 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 12:43:01 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 12:43:01 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 12:43:02 - IsConnectionValid True 12:43:02 - IsConnectionValid True 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - IsConnectionValid True 12:43:02 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - IsConnectionValid True 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 12:43:02 - IsConnectionValid True 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=3) OR ExtensionsID=0) ORDER BY ID Query 12:43:02 - IsConnectionValid True 12:43:02 - IsConnectionValid True 12:43:02 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 12:43:02 - IsConnectionValid True 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 12:43:02 - IsConnectionValid True 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:43:02 - IsConnectionValid True 12:43:02 - IsConnectionValid True 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 12:43:02 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=6) OR ExtensionsID=0) ORDER BY ID Query 12:43:02 - IsConnectionValid True 12:43:02 - IsConnectionValid True 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 12:43:02 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 918 WHERE LocationDef.TenantID =1 Query 12:43:02 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 918 WHERE CustodyItemsDef.TenantID =1 Query 12:43:02 - IsConnectionValid True 12:43:02 - IsConnectionValid True 12:43:02 - IsConnectionValid True 12:43:02 - SELECT * FROM HRMS_vwEmp_Contracts WHERE TenantID =1 and EmployeeID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=16) OR ExtensionsID=0) ORDER BY ContractDate Desc Query 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =918 AND Emp.MasterID =0 Query 12:43:02 - IsConnectionValid True 12:43:02 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:43:02 - IsConnectionValid True 12:43:02 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:43:02 - IsConnectionValid True 12:43:02 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:43:02 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:43:02 - IsConnectionValid True 12:43:02 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 12:43:03 - IsConnectionValid True 12:43:03 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 12:44:28 - IsConnectionValid True 12:44:28 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1831 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:44:31 - IsConnectionValid True 12:44:31 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1834 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:44:33 - IsConnectionValid True 12:44:33 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1834 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:44:33 - IsConnectionValid True 12:44:33 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1834 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:44:34 - IsConnectionValid True 12:44:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1834 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:44:37 - IsConnectionValid True 12:44:37 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1834 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:44:37 - IsConnectionValid True 12:44:37 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1834 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:44:38 - IsConnectionValid True 12:44:38 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1834 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:44:39 - IsConnectionValid True 12:44:39 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1834 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:44:40 - IsConnectionValid True 12:44:40 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1834 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:44:40 - IsConnectionValid True 12:44:40 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1834 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:45:17 - IsConnectionValid True 12:45:19 - IsConnectionValid True 12:45:19 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:45:21 - IsConnectionValid True 12:45:21 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1834 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 12:45:23 - IsConnectionValid True 12:45:23 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 12:45:23 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 12:45:23 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 12:45:23 - IsConnectionValid True 12:45:23 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - IsConnectionValid True 12:45:23 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - IsConnectionValid True 12:45:23 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - IsConnectionValid True 12:45:23 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - IsConnectionValid True 12:45:23 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - IsConnectionValid True 12:45:23 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - IsConnectionValid True 12:45:23 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=3) OR ExtensionsID=0) ORDER BY ID Query 12:45:23 - IsConnectionValid True 12:45:23 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 12:45:23 - IsConnectionValid True 12:45:23 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 12:45:23 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:23 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 12:45:23 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=6) OR ExtensionsID=0) ORDER BY ID Query 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 921 WHERE CustodyItemsDef.TenantID =1 Query 12:45:23 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 921 WHERE LocationDef.TenantID =1 Query 12:45:23 - IsConnectionValid True 12:45:23 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =921 AND Emp.MasterID =0 Query 12:45:23 - SELECT * FROM HRMS_vwEmp_Contracts WHERE TenantID =1 and EmployeeID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=16) OR ExtensionsID=0) ORDER BY ContractDate Desc Query 12:45:23 - IsConnectionValid True 12:45:23 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:45:23 - IsConnectionValid True 12:45:23 - IsConnectionValid True 12:45:23 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:45:23 - IsConnectionValid True 12:45:23 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:45:23 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:45:24 - IsConnectionValid True 12:45:24 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 12:45:24 - IsConnectionValid True 12:45:24 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 12:45:25 - IsConnectionValid True 12:45:25 - IsConnectionValid True 12:45:25 - IsConnectionValid True 12:45:25 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 and IsManager = @val3 and ID <> @val4 ORDER BY ID Query 12:45:25 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:45:25 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 12:45:33 - IsConnectionValid True 12:45:33 - 2025-06-03 dateleft :: 06/03/2025 12:45:33 - IsConnectionValid True 12:45:33 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:47:26 - IsConnectionValid True 12:47:27 - IsConnectionValid True 12:47:27 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:47:29 - IsConnectionValid True 12:47:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1600 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:47:30 - IsConnectionValid True 12:47:30 - IsConnectionValid True 12:47:30 - IsConnectionValid True 12:47:30 - IsConnectionValid True 12:47:30 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 12:47:30 - IsConnectionValid True 12:47:30 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 12:47:30 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 12:47:30 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 12:47:30 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 12:47:31 - IsConnectionValid True 12:47:31 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - IsConnectionValid True 12:47:31 - IsConnectionValid True 12:47:31 - IsConnectionValid True 12:47:31 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 12:47:31 - IsConnectionValid True 12:47:31 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - IsConnectionValid True 12:47:31 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - IsConnectionValid True 12:47:31 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 12:47:31 - IsConnectionValid True 12:47:31 - IsConnectionValid True 12:47:31 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - IsConnectionValid True 12:47:31 - IsConnectionValid True 12:47:31 - IsConnectionValid True 12:47:31 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 12:47:31 - IsConnectionValid True 12:47:31 - IsConnectionValid True 12:47:31 - IsConnectionValid True 12:47:31 - IsConnectionValid True 12:47:31 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - IsConnectionValid True 12:47:31 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=3) OR ExtensionsID=0) ORDER BY ID Query 12:47:31 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - IsConnectionValid True 12:47:31 - IsConnectionValid True 12:47:31 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 12:47:31 - IsConnectionValid True 12:47:31 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 12:47:31 - IsConnectionValid True 12:47:31 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - IsConnectionValid True 12:47:31 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - IsConnectionValid True 12:47:31 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:31 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 12:47:31 - IsConnectionValid True 12:47:31 - IsConnectionValid True 12:47:31 - IsConnectionValid True 12:47:31 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=6) OR ExtensionsID=0) ORDER BY ID Query 12:47:31 - IsConnectionValid True 12:47:31 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 12:47:31 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 597 WHERE LocationDef.TenantID =1 Query 12:47:31 - IsConnectionValid True 12:47:31 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 597 WHERE CustodyItemsDef.TenantID =1 Query 12:47:31 - IsConnectionValid True 12:47:31 - IsConnectionValid True 12:47:31 - IsConnectionValid True 12:47:31 - SELECT * FROM HRMS_vwEmp_Contracts WHERE TenantID =1 and EmployeeID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=16) OR ExtensionsID=0) ORDER BY ContractDate Desc Query 12:47:31 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =597 AND Emp.MasterID =0 Query 12:47:31 - IsConnectionValid True 12:47:31 - IsConnectionValid True 12:47:31 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:47:31 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:47:31 - IsConnectionValid True 12:47:31 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:47:31 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 12:47:31 - IsConnectionValid True 12:47:31 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 12:47:32 - IsConnectionValid True 12:47:32 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 12:47:32 - IsConnectionValid True 12:47:32 - IsConnectionValid True 12:47:32 - IsConnectionValid True 12:47:32 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 12:47:32 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 12:47:32 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 and IsManager = @val3 and ID <> @val4 ORDER BY ID Query 12:47:38 - IsConnectionValid True 12:47:38 - 2025-06-02 dateleft :: 06/02/2025 12:47:38 - IsConnectionValid True 12:47:38 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:49:09 - IsConnectionValid True 12:49:10 - IsConnectionValid True 12:49:10 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:49:13 - IsConnectionValid True 12:49:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1638 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:55:03 - IsConnectionValid True 12:55:05 - IsConnectionValid True 12:55:07 - IsConnectionValid True 12:55:07 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 12:55:09 - IsConnectionValid True 12:55:09 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 12:55:09 - IsConnectionValid True 12:55:09 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:55:11 - IsConnectionValid True 12:55:11 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:55:13 - IsConnectionValid True 12:55:13 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 12:55:15 - IsConnectionValid True 12:55:15 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 12:55:15 - IsConnectionValid True 12:55:15 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:55:16 - IsConnectionValid True 12:55:16 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 12:55:17 - IsConnectionValid True 12:55:17 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type, ShouldUploadAttachment AS ShouldUploadAttachment, IsOptionalAttachment AS IsOptionalAttachment, TransactionTypeID AS TransactionTypeID, IsFullPeriodCalculation AS IsFullPeriodCalculation, IsWorkInjury AS IsWorkInjury, dbo.web_get_vacationBalance('01/01/1900','01/01/1900',ID,1,1) AS CreditForLastYear, dbo.web_get_vacationCredit(ID,1,1) AS VacationsCredit, IsEffectBalance AS IsEffectBalance, Max_Exceed_Balance AS Max_Exceed_Balance FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:55:17 - (1-gen-1004) : Invalid column name 'IsEffectBalance'. Invalid column name 'Max_Exceed_Balance'. 12:55:31 - IsConnectionValid True 12:55:31 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type, ShouldUploadAttachment AS ShouldUploadAttachment, IsOptionalAttachment AS IsOptionalAttachment, TransactionTypeID AS TransactionTypeID, IsFullPeriodCalculation AS IsFullPeriodCalculation, IsWorkInjury AS IsWorkInjury, dbo.web_get_vacationBalance('01/01/1900','01/01/1900',ID,1,1) AS CreditForLastYear, dbo.web_get_vacationCredit(ID,1,1) AS VacationsCredit, IsEffectBalance AS IsEffectBalance, Max_Exceed_Balance AS Max_Exceed_Balance FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:55:31 - (1-gen-1004) : Invalid column name 'IsEffectBalance'. Invalid column name 'Max_Exceed_Balance'. 12:56:38 - IsConnectionValid True 12:56:38 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type, ShouldUploadAttachment AS ShouldUploadAttachment, IsOptionalAttachment AS IsOptionalAttachment, TransactionTypeID AS TransactionTypeID, IsFullPeriodCalculation AS IsFullPeriodCalculation, IsWorkInjury AS IsWorkInjury, dbo.web_get_vacationBalance('01/01/1900','01/01/1900',ID,1,1) AS CreditForLastYear, dbo.web_get_vacationCredit(ID,1,1) AS VacationsCredit, IsEffectBalance AS IsEffectBalance, Max_Exceed_Balance AS Max_Exceed_Balance FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:56:38 - (1-gen-1004) : Invalid column name 'IsEffectBalance'. Invalid column name 'Max_Exceed_Balance'. 12:57:07 - IsConnectionValid True 12:57:07 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type, ShouldUploadAttachment AS ShouldUploadAttachment, IsOptionalAttachment AS IsOptionalAttachment, TransactionTypeID AS TransactionTypeID, IsFullPeriodCalculation AS IsFullPeriodCalculation, IsWorkInjury AS IsWorkInjury, dbo.web_get_vacationBalance('01/01/1900','01/01/1900',ID,1,1) AS CreditForLastYear, dbo.web_get_vacationCredit(ID,1,1) AS VacationsCredit, IsEffectBalance AS IsEffectBalance, Max_Exceed_Balance AS Max_Exceed_Balance FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:59:44 - IsConnectionValid True 12:59:44 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type, ShouldUploadAttachment AS ShouldUploadAttachment, IsOptionalAttachment AS IsOptionalAttachment, TransactionTypeID AS TransactionTypeID, IsFullPeriodCalculation AS IsFullPeriodCalculation, IsWorkInjury AS IsWorkInjury, dbo.web_get_vacationBalance('01/01/1900','01/01/1900',ID,1,1) AS CreditForLastYear, dbo.web_get_vacationCredit(ID,1,1) AS VacationsCredit, IsEffectBalance AS IsEffectBalance, Max_Exceed_Balance AS Max_Exceed_Balance FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 12:59:45 - IsConnectionValid True 12:59:45 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 13:00:42 - IsConnectionValid True 13:00:42 - IsConnectionValid True 13:00:42 - SELECT DISTINCT ID AS ID FROM TransactionsDef WHERE TenantID = 1 AND MotherVacDeduct = @val0 AND IsReturnEffect = @val1 Query 13:00:42 - IsConnectionValid True 13:00:42 - IsConnectionValid True 13:00:49 - IsConnectionValid True 13:00:49 - IsConnectionValid True 13:00:49 - IsConnectionValid True 13:00:49 - SELECT DISTINCT ID AS ID FROM TransactionsDef WHERE TenantID = 1 AND MotherVacDeduct = @val0 AND IsReturnEffect = @val1 Query 13:00:49 - IsConnectionValid True 13:01:00 - IsConnectionValid True 13:01:00 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 13:01:01 - IsConnectionValid True 13:01:11 - IsConnectionValid True 13:01:11 - SELECT DISTINCT * FROM VwEmpTransactionsWithSecurity WHERE TenantID = @val0 AND UserID = @val1 AND EmployeeCode >= @val2 AND EmployeeCode <= @val3 AND TransactionUserID = @val4 AND IsNotManualEntry = @val5 AND IsReserve = @val6 AND Loans = @val7 AND IsInsurance = @val8 AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND month(TransactionDate) = @val13 AND year(TransactionDate) = @val14 ORDER BY Code Query 13:01:13 - IsConnectionValid True 13:01:13 - SELECT DISTINCT * FROM CloseMonth WHERE TenantID = 1 AND TenantID = @val0 and month(CloseDate) = @val1 and year(CloseDate) = @val2 Query 13:01:14 - IsConnectionValid True 13:01:18 - IsConnectionValid True 13:01:18 - IsConnectionValid True 13:01:18 - IsConnectionValid True 13:01:18 - SELECT DISTINCT ID AS ID FROM TransactionsDef WHERE TenantID = 1 AND MotherVacDeduct = @val0 AND IsReturnEffect = @val1 Query 13:01:18 - IsConnectionValid True 13:01:18 - IsConnectionValid True 13:01:18 - SELECT DISTINCT CloseDate AS CloseDate FROM CloseMonth WHERE TenantID = 1 AND Month(CloseDate) = @val0 and Year(CloseDate) = @val1 and TenantID = @val2 Query 13:01:18 - (1-gen-1002) : Conversion failed when converting the nvarchar value 'Month(06/01/2025)' to data type int. 13:01:18 - IsConnectionValid True 13:01:18 - IsConnectionValid True 13:01:18 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 13:01:24 - IsConnectionValid True 13:01:24 - SELECT DISTINCT * FROM VwEmpTransactionsWithSecurity WHERE TenantID = @val0 AND UserID = @val1 AND EmployeeCode >= @val2 AND EmployeeCode <= @val3 AND TransactionUserID = @val4 AND IsNotManualEntry = @val5 AND IsReserve = @val6 AND Loans = @val7 AND IsInsurance = @val8 AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND month(TransactionDate) = @val13 AND year(TransactionDate) = @val14 ORDER BY Code Query 13:01:30 - IsConnectionValid True 13:01:30 - SELECT DISTINCT * FROM CloseMonth WHERE TenantID = 1 AND TenantID = @val0 and month(CloseDate) = @val1 and year(CloseDate) = @val2 Query 13:01:31 - IsConnectionValid True 13:04:19 - IsConnectionValid True 13:04:19 - SELECT DISTINCT * FROM VwEmpTransactionsWithSecurity WHERE TenantID = @val0 AND UserID = @val1 AND EmployeeCode >= @val2 AND EmployeeCode <= @val3 AND TransactionUserID = @val4 AND IsNotManualEntry = @val5 AND IsReserve = @val6 AND Loans = @val7 AND IsInsurance = @val8 AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND month(TransactionDate) = @val13 AND year(TransactionDate) = @val14 ORDER BY Code Query 13:04:21 - IsConnectionValid True 13:04:21 - SELECT DISTINCT * FROM CloseMonth WHERE TenantID = 1 AND TenantID = @val0 and month(CloseDate) = @val1 and year(CloseDate) = @val2 Query 13:04:22 - IsConnectionValid True 13:04:25 - IsConnectionValid True 13:04:25 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE '%1%') ORDER BY ID ASC Query 13:04:25 - IsConnectionValid True 13:04:25 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:04:27 - IsConnectionValid True 13:04:27 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, IsShift AS IsShift, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, SocialSecPeriod AS SocialSecPeriod, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, SatuEmp AS SatuEmp, Sund AS Sun, Mond AS Mon, Tues AS Tus, Wend AS Wed, Thur AS Thr, Frid AS Fri, Satu AS Sat, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, CurrPVac AS CurrPVac, CurrGeneralVac AS CurrGeneralVac, SocialSalary AS SocialSalary, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0 END AS Resigned FROM HRMS_vwEmployees WHERE TenantID = 1 AND UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then 1 else 0 END END LIKE @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:04:28 - IsConnectionValid True 13:04:28 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 13:04:29 - IsConnectionValid True 13:04:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type, ShouldUploadAttachment AS ShouldUploadAttachment, IsOptionalAttachment AS IsOptionalAttachment, TransactionTypeID AS TransactionTypeID, IsFullPeriodCalculation AS IsFullPeriodCalculation, IsWorkInjury AS IsWorkInjury, dbo.web_get_vacationBalance('01/01/1900','01/01/1900',ID,688,1) AS CreditForLastYear, dbo.web_get_vacationCredit(ID,688,1) AS VacationsCredit, IsEffectBalance AS IsEffectBalance, Max_Exceed_Balance AS Max_Exceed_Balance FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:04:31 - IsConnectionValid True 13:04:31 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 13:04:41 - IsConnectionValid True 13:04:41 - IsConnectionValid True 13:04:41 - SELECT DISTINCT ID AS ID FROM TransactionsDef WHERE TenantID = 1 AND MotherVacDeduct = @val0 AND IsReturnEffect = @val1 Query 13:04:41 - IsConnectionValid True 13:04:41 - IsConnectionValid True 13:04:41 - SELECT DISTINCT CloseDate AS CloseDate FROM CloseMonth WHERE TenantID = 1 AND Month(CloseDate) = @val0 and Year(CloseDate) = @val1 and TenantID = @val2 Query 13:04:41 - (1-gen-1002) : Conversion failed when converting the nvarchar value 'Month(06/01/2025)' to data type int. 13:04:41 - IsConnectionValid True 13:04:41 - IsConnectionValid True 13:04:41 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 13:06:11 - IsConnectionValid True 13:06:11 - SELECT DISTINCT * FROM VwEmpTransactionsWithSecurity WHERE TenantID = @val0 AND UserID = @val1 AND EmployeeCode >= @val2 AND EmployeeCode <= @val3 AND TransactionUserID = @val4 AND IsNotManualEntry = @val5 AND IsReserve = @val6 AND Loans = @val7 AND IsInsurance = @val8 AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND month(TransactionDate) = @val13 AND year(TransactionDate) = @val14 ORDER BY Code Query 13:06:34 - IsConnectionValid True 13:06:34 - SELECT DISTINCT * FROM VwEmpTransactionsWithSecurity WHERE TenantID = @val0 AND UserID = @val1 AND EmployeeCode >= @val2 AND EmployeeCode <= @val3 AND TransactionUserID = @val4 AND IsNotManualEntry = @val5 AND IsReserve = @val6 AND Loans = @val7 AND IsInsurance = @val8 AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND month(TransactionDate) = @val13 AND year(TransactionDate) = @val14 ORDER BY Code Query 13:06:36 - IsConnectionValid True 13:06:36 - SELECT DISTINCT * FROM CloseMonth WHERE TenantID = 1 AND TenantID = @val0 and month(CloseDate) = @val1 and year(CloseDate) = @val2 Query 13:06:37 - IsConnectionValid True 13:10:08 - IsConnectionValid True 13:10:09 - IsConnectionValid True 13:10:09 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:10:12 - IsConnectionValid True 13:10:12 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1831 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:10:15 - IsConnectionValid True 13:10:15 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1831 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 13:10:17 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 13:10:17 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 13:10:17 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 13:10:17 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:17 - IsConnectionValid True 13:10:17 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:17 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:17 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:17 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:17 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 13:10:17 - IsConnectionValid True 13:10:17 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:17 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:17 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 13:10:17 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:17 - IsConnectionValid True 13:10:17 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:17 - IsConnectionValid True 13:10:17 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=3) OR ExtensionsID=0) ORDER BY ID Query 13:10:17 - IsConnectionValid True 13:10:17 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:17 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 13:10:17 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:17 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:17 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 13:10:17 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=6) OR ExtensionsID=0) ORDER BY ID Query 13:10:17 - IsConnectionValid True 13:10:17 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 918 WHERE CustodyItemsDef.TenantID =1 Query 13:10:17 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 918 WHERE LocationDef.TenantID =1 Query 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - SELECT * FROM HRMS_vwEmp_Contracts WHERE TenantID =1 and EmployeeID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=16) OR ExtensionsID=0) ORDER BY ContractDate Desc Query 13:10:17 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =918 AND Emp.MasterID =0 Query 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - IsConnectionValid True 13:10:17 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 13:10:17 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 13:10:17 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 13:10:17 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 13:10:17 - IsConnectionValid True 13:10:17 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 13:10:18 - IsConnectionValid True 13:10:18 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 13:10:19 - IsConnectionValid True 13:10:19 - IsConnectionValid True 13:10:19 - IsConnectionValid True 13:10:19 - SELECT DISTINCT * FROM vwEmployeesResignation WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 13:10:19 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 13:10:19 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:19 - (1-gen-1002) : The given key was not present in the dictionary. 13:10:23 - IsConnectionValid True 13:10:23 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:10:53 - IsConnectionValid True 13:10:53 - IsConnectionValid True 13:10:53 - IsConnectionValid True 13:10:53 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 13:10:53 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 and IsManager = @val3 and ID <> @val4 ORDER BY ID Query 13:10:53 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:10:55 - IsConnectionValid True 13:10:55 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:10:56 - IsConnectionValid True 13:10:57 - IsConnectionValid True 13:10:57 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:11:03 - IsConnectionValid True 13:11:03 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1831 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 13:11:04 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 13:11:04 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 13:11:04 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 13:11:04 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 13:11:04 - IsConnectionValid True 13:11:04 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 13:11:04 - IsConnectionValid True 13:11:04 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - IsConnectionValid True 13:11:04 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=3) OR ExtensionsID=0) ORDER BY ID Query 13:11:04 - IsConnectionValid True 13:11:04 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - IsConnectionValid True 13:11:04 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 13:11:04 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - IsConnectionValid True 13:11:04 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:04 - IsConnectionValid True 13:11:04 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=6) OR ExtensionsID=0) ORDER BY ID Query 13:11:04 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 13:11:04 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 918 WHERE LocationDef.TenantID =1 Query 13:11:04 - IsConnectionValid True 13:11:04 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 918 WHERE CustodyItemsDef.TenantID =1 Query 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =918 AND Emp.MasterID =0 Query 13:11:04 - SELECT * FROM HRMS_vwEmp_Contracts WHERE TenantID =1 and EmployeeID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=16) OR ExtensionsID=0) ORDER BY ContractDate Desc Query 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 13:11:04 - IsConnectionValid True 13:11:04 - IsConnectionValid True 13:11:04 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 13:11:04 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 13:11:04 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 13:11:05 - IsConnectionValid True 13:11:05 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 13:11:05 - IsConnectionValid True 13:11:05 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 13:11:06 - IsConnectionValid True 13:11:06 - IsConnectionValid True 13:11:06 - SELECT DISTINCT * FROM vwEmployeesResignation WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 13:11:06 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:11:06 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 13:11:06 - (1-gen-1002) : The given key was not present in the dictionary. 13:11:14 - IsConnectionValid True 13:11:14 - 2025-05-31 dateleft :: 05/31/2025 13:11:14 - IsConnectionValid True 13:11:14 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:11:55 - IsConnectionValid True 13:11:56 - IsConnectionValid True 13:11:56 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:11:59 - IsConnectionValid True 13:11:59 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1831 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:12:01 - IsConnectionValid True 13:12:01 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1831 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:12:01 - IsConnectionValid True 13:12:01 - IsConnectionValid True 13:12:01 - IsConnectionValid True 13:12:01 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 13:12:01 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 13:12:01 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 13:12:01 - IsConnectionValid True 13:12:01 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 13:12:01 - IsConnectionValid True 13:12:01 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 13:12:01 - IsConnectionValid True 13:12:01 - IsConnectionValid True 13:12:01 - IsConnectionValid True 13:12:01 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 13:12:01 - IsConnectionValid True 13:12:01 - IsConnectionValid True 13:12:01 - IsConnectionValid True 13:12:01 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:12:01 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:12:01 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:12:01 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:12:01 - IsConnectionValid True 13:12:01 - IsConnectionValid True 13:12:01 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 13:12:01 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:12:01 - IsConnectionValid True 13:12:01 - IsConnectionValid True 13:12:01 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:12:01 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:12:01 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:12:01 - IsConnectionValid True 13:12:01 - IsConnectionValid True 13:12:01 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:12:01 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 13:12:01 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:12:02 - IsConnectionValid True 13:12:02 - IsConnectionValid True 13:12:02 - IsConnectionValid True 13:12:02 - IsConnectionValid True 13:12:02 - IsConnectionValid True 13:12:02 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:12:02 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:12:02 - IsConnectionValid True 13:12:02 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=3) OR ExtensionsID=0) ORDER BY ID Query 13:12:02 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 13:12:02 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 13:12:02 - IsConnectionValid True 13:12:02 - IsConnectionValid True 13:12:02 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:12:02 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:12:02 - IsConnectionValid True 13:12:02 - IsConnectionValid True 13:12:02 - IsConnectionValid True 13:12:02 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:12:02 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 13:12:02 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 13:12:02 - IsConnectionValid True 13:12:02 - IsConnectionValid True 13:12:02 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=6) OR ExtensionsID=0) ORDER BY ID Query 13:12:02 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 918 WHERE LocationDef.TenantID =1 Query 13:12:02 - IsConnectionValid True 13:12:02 - IsConnectionValid True 13:12:02 - IsConnectionValid True 13:12:02 - IsConnectionValid True 13:12:02 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =918 AND Emp.MasterID =0 Query 13:12:02 - SELECT * FROM HRMS_vwEmp_Contracts WHERE TenantID =1 and EmployeeID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=16) OR ExtensionsID=0) ORDER BY ContractDate Desc Query 13:12:02 - IsConnectionValid True 13:12:02 - IsConnectionValid True 13:12:02 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 13:12:02 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 13:12:02 - IsConnectionValid True 13:12:02 - IsConnectionValid True 13:12:02 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 13:12:02 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 13:12:02 - IsConnectionValid True 13:12:02 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 13:12:02 - IsConnectionValid True 13:12:02 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 13:12:03 - IsConnectionValid True 13:12:03 - IsConnectionValid True 13:12:03 - IsConnectionValid True 13:12:03 - IsConnectionValid True 13:12:03 - SELECT DISTINCT * FROM vwEmployeesResignation WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 13:12:03 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 13:12:03 - (1-gen-1002) : The given key was not present in the dictionary. 13:12:03 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:12:09 - IsConnectionValid True 13:12:09 - 2025-06-01 dateleft :: 06/01/2025 13:12:09 - IsConnectionValid True 13:12:09 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:15:31 - IsConnectionValid True 13:15:32 - IsConnectionValid True 13:15:32 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:15:40 - IsConnectionValid True 13:15:40 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1831 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:15:46 - IsConnectionValid True 13:15:46 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and Code =1831 and DateLeft <> '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 13:15:47 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 13:15:47 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 13:15:47 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 13:15:47 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 13:15:47 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:47 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:47 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:47 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:47 - IsConnectionValid True 13:15:47 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 13:15:47 - IsConnectionValid True 13:15:47 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:47 - IsConnectionValid True 13:15:47 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:47 - IsConnectionValid True 13:15:47 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:47 - IsConnectionValid True 13:15:47 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:47 - IsConnectionValid True 13:15:47 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:47 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 13:15:47 - IsConnectionValid True 13:15:47 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=3) OR ExtensionsID=0) ORDER BY ID Query 13:15:47 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 13:15:47 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:47 - IsConnectionValid True 13:15:47 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:47 - IsConnectionValid True 13:15:47 - SELECT DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 13:15:47 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 918 WHERE LocationDef.TenantID =1 Query 13:15:47 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=6) OR ExtensionsID=0) ORDER BY ID Query 13:15:47 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 918 WHERE CustodyItemsDef.TenantID =1 Query 13:15:47 - IsConnectionValid True 13:15:47 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =918 AND Emp.MasterID =0 Query 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 13:15:47 - IsConnectionValid True 13:15:47 - IsConnectionValid True 13:15:47 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 13:15:47 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 13:15:47 - SELECT * FROM HRMS_vwEmp_Contracts WHERE TenantID =1 and EmployeeID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=16) OR ExtensionsID=0) ORDER BY ContractDate Desc Query 13:15:47 - IsConnectionValid True 13:15:47 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 13:15:47 - IsConnectionValid True 13:15:47 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 13:15:48 - IsConnectionValid True 13:15:48 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 13:15:56 - IsConnectionValid True 13:15:56 - IsConnectionValid True 13:15:56 - SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:15:56 - SELECT DISTINCT * FROM vwEmployeesResignation WHERE TenantID = 1 AND TenantID = @val0 and EmployeeID = @val1 ORDER BY ID Query 13:15:56 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = @val0 and (Dateleft = '01/01/1900') and UserID = @val2 ORDER BY ID Query 13:15:56 - (1-gen-1002) : The given key was not present in the dictionary. 13:16:03 - IsConnectionValid True 13:16:03 - 2025-05-31 dateleft :: 05/31/2025 13:16:03 - IsConnectionValid True 13:16:03 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) <> @val1 and UserID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 14:12:56 - IsConnectionValid True 14:13:07 - IsConnectionValid True 14:13:14 - IsConnectionValid True