10:13:19 - IsConnectionValid True 10:13:20 - IsConnectionValid True 10:13:21 - IsConnectionValid True 10:13:27 - IsConnectionValid True 10:13:27 - IsConnectionValid True 10:13:32 - IsConnectionValid True 10:13:35 - IsConnectionValid True 10:13:35 - SELECT DISTINCT ID AS ID, Code AS Code, MonthName AS Name FROM ThirdAndFourCalculationPeriod WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:17:59 - IsConnectionValid True 10:18:00 - IsConnectionValid True 10:18:00 - SELECT DISTINCT ID AS ID, Code AS Code, MonthName AS Name FROM ThirdAndFourCalculationPeriod WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:18:41 - IsConnectionValid True 10:18:42 - IsConnectionValid True 10:18:42 - SELECT DISTINCT * FROM ThirdAndFourCalculationPeriod WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:19:02 - IsConnectionValid True 10:19:03 - IsConnectionValid True 10:19:03 - SELECT DISTINCT * FROM ThirdAndFourCalculationPeriod WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:20:18 - IsConnectionValid True 10:20:18 - IsConnectionValid True 10:20:18 - SELECT DISTINCT * FROM ThirdAndFourCalculationPeriod WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:20:35 - IsConnectionValid True 10:20:36 - IsConnectionValid True 10:20:36 - SELECT DISTINCT * FROM ThirdAndFourCalculationPeriod WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:21:11 - IsConnectionValid True 10:21:11 - IsConnectionValid True 10:21:11 - SELECT DISTINCT * FROM ThirdAndFourCalculationPeriod WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:21:47 - IsConnectionValid True 10:21:48 - IsConnectionValid True 10:21:48 - SELECT DISTINCT * FROM ThirdAndFourCalculationPeriod WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:23:16 - IsConnectionValid True 10:23:16 - IsConnectionValid True 10:23:16 - SELECT DISTINCT * FROM ThirdAndFourCalculationPeriod WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:24:19 - IsConnectionValid True 10:24:20 - IsConnectionValid True 10:24:20 - SELECT DISTINCT * FROM ThirdAndFourCalculationPeriod WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:25:56 - IsConnectionValid True 10:25:57 - IsConnectionValid True 10:25:57 - SELECT DISTINCT * FROM ThirdAndFourCalculationPeriod WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:33:14 - IsConnectionValid True 10:33:15 - IsConnectionValid True 10:33:15 - SELECT DISTINCT * FROM ThirdAndFourCalculationPeriod WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:51:38 - IsConnectionValid True 10:51:40 - IsConnectionValid True 10:51:41 - IsConnectionValid True 10:51: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 10:51:42 - IsConnectionValid True 10:51:42 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >06/25/2024)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:51:48 - IsConnectionValid True 10:51:48 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 10:51:50 - IsConnectionValid True 10:51:52 - IsConnectionValid True 10:51:54 - IsConnectionValid True 10:51:54 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 10:51:55 - IsConnectionValid True 10:51:55 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft = '1900-01-01' or (DateleftTemp<>DateLeft and DateLeft > GETDATE())) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:52:00 - IsConnectionValid True 10:52: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 10:52:07 - IsConnectionValid True 10:52:09 - IsConnectionValid True 10:52:09 - SELECT * FROM HRMS_VwVacationEntry_Cancel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 ORDER BY FromDate ASC Query 10:52:10 - IsConnectionValid True 10:52:10 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >06/25/2024)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:52:14 - IsConnectionValid True 10:52:18 - IsConnectionValid True 10:52:21 - IsConnectionValid True 10:52:21 - 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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >06/25/2024)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:52:23 - IsConnectionValid True 10:52:23 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 10:52:29 - IsConnectionValid True 10:52: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, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, ProjectID AS ProjectID, SectionID AS SectionID, DepartmentID AS DepartmentID, SocialSalary AS SocialSalary, Satu AS Satu, Sund AS Sund, mond AS mond, Tues AS Tues, Wend AS Wend, Thur AS Thur, Frid AS Frid, DateBegin AS DateBegin, DateLeftTemp AS DateLeftTemp, DateLeft AS DateLeft, SatuEmp AS SatuEmp, SundEmp AS SundEmp, MondEmp AS MondEmp, TuesEmp AS TuesEmp, WendEmp AS WendEmp, ThurEmp AS ThurEmp, FridEmp AS FridEmp, TotalSal AS TotalSal, JobEName AS JobEName, WorkHours AS WorkHours, HourStartWork AS HourStartWork, PilgrimageVacation AS PilgrimageVacation, SocialSecPeriod AS SocialSecPeriod, Relegion AS Relegion, Gender AS Gender, OldYearlyVac AS OldYearlyVac, ActualYearlyVac AS ActualYearlyVac, OldPVac AS OldPVac, CurrPVac AS CurrPVac, OldOccVac AS OldOccVac, ActualOccVac AS ActualOccVac, OldGeneralVac AS OldGeneralVac, CurrGeneralVac AS CurrGeneralVac, OldWeekVac AS OldWeekVac, CurrWeekVac AS CurrWeekVac, OldOthVac AS OldOthVac, CurrOthVac AS CurrOthVac FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >06/25/2024)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:52:30 - IsConnectionValid True 10:52:30 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 10:52:30 - IsConnectionValid True 10:52:30 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC Query 10:52:31 - IsConnectionValid True 10:52: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 FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 10:52:44 - IsConnectionValid True 10:52:45 - IsConnectionValid True 10:52:45 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query