12:46:19 - IsConnectionValid True
12:46:20 - IsConnectionValid True
12:46:20 - IsConnectionValid True
12:46:25 - IsConnectionValid True
12:46:25 - IsConnectionValid True
12:46:27 - IsConnectionValid True
12:46:33 - IsConnectionValid True
12:46:33 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM InsuranceCompanies  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:49:08 - IsConnectionValid True
12:49:08 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM InsuranceCompanies  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:49:48 - IsConnectionValid True
12:49:53 - IsConnectionValid True
12:49:55 - IsConnectionValid True
12:49: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 DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:49:58 - IsConnectionValid True
12:49:58 - IsConnectionValid True
12:49:58 - IsConnectionValid True
12:49:58 - IsConnectionValid True
12:49:58 - IsConnectionValid True
12:49:58 - IsConnectionValid True
12:49:58 - SELECT * FROM EmpWifeInfo WHERE  TenantID =1 and EmpId = @val1 ORDER BY Code  Query
12:49:58 - SELECT  DISTINCT * FROM Section WHERE TenantID = 1 AND   TenantID = @val0 and ID = @val1  Query
12:49:58 - 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:49:58 - SELECT  DISTINCT * FROM Projects WHERE  TenantID =1 and ID = @val1  Query
12:49:58 - SELECT  DISTINCT * FROM Jobs WHERE  TenantID =1 ORDER BY ID  Query
12:49:59 - IsConnectionValid True
12:49:59 - IsConnectionValid True
12:49:59 - IsConnectionValid True
12:49:59 - SELECT  DISTINCT * FROM Nation WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:49:59 - IsConnectionValid True
12:49:59 - SELECT  DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:49:59 - SELECT  DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:49:59 - SELECT  DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:49:59 - IsConnectionValid True
12:49:59 - SELECT  DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:49:59 - SELECT  DISTINCT * FROM Religion WHERE TenantID = 1 AND   TenantID = @val0 AND IsActive = @val1 ORDER BY ID  Query
12:49:59 - IsConnectionValid True
12:49:59 - SELECT * FROM vwEmployeeLanguages WHERE  TenantID =1 and EmployeeID = @val1  Query
12:49:59 - IsConnectionValid True
12:49:59 - IsConnectionValid True
12:49:59 - SELECT  DISTINCT * FROM EducationCity WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:49:59 - IsConnectionValid True
12:49:59 - SELECT  DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:49:59 - 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:49:59 - IsConnectionValid True
12:49:59 - IsConnectionValid True
12:49:59 - SELECT  DISTINCT * FROM JobType WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:49:59 - SELECT  DISTINCT * FROM Subjects WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:49:59 - IsConnectionValid True
12:49:59 - SELECT  DISTINCT * FROM JobDegree WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:49:59 - SELECT  DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:49:59 - SELECT  DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:49:59 - IsConnectionValid True
12:49:59 - IsConnectionValid True
12:49:59 - 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:49:59 - IsConnectionValid True
12:49:59 - SELECT * FROM VwEmpExperience WHERE  TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID  Query
12:49:59 - IsConnectionValid True
12:49:59 - IsConnectionValid True
12:49:59 - SELECT * FROM VwEmpExperience WHERE  TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID  Query
12:49:59 - SELECT  DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:49:59 - SELECT  DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:49:59 - IsConnectionValid True
12:49:59 - SELECT  DISTINCT * FROM Career_Ladder_Years WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:49:59 - IsConnectionValid True
12:49:59 - IsConnectionValid True
12:49:59 - IsConnectionValid True
12:49:59 - SELECT  DISTINCT * FROM Banks WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:49:59 - SELECT  DISTINCT * FROM HRMS_vwVacTransType WHERE  TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID  Query
12:49:59 - SELECT  DISTINCT * FROM HRMS_vwVacTransType WHERE  TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID  Query
12:49:59 - IsConnectionValid True
12:49:59 - IsConnectionValid True
12:49:59 - IsConnectionValid True
12:49:59 - 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:49:59 - 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 = 876 WHERE  LocationDef.TenantID =1  Query
12:49:59 - IsConnectionValid True
12:49:59 - 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 = 876 WHERE  CustodyItemsDef.TenantID =1  Query
12:49:59 - 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:49:59 - 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 =876 AND Emp.MasterID =0  Query
12:49:59 - IsConnectionValid True
12:49:59 - IsConnectionValid True
12:49:59 - SELECT * FROM vwCoursesEntryDetails WHERE  TenantID =1 AND EmpID = @val1 AND UserID = @val2  Query
12:49:59 - IsConnectionValid True
12:49:59 - IsConnectionValid True
12:49:59 - SELECT * FROM vwThanksBooksEntry WHERE  TenantID =1 AND EmpID = @val1 AND UserID = @val2  Query
12:49:59 - SELECT * FROM vwWarningEntry WHERE  TenantID =1 AND EmpID = @val1 AND UserID = @val2  Query
12:49:59 - SELECT * FROM vwInjuryEntry WHERE  TenantID =1 AND EmpID = @val1 AND UserID = @val2  Query
12:49:59 - IsConnectionValid True
12:49:59 - IsConnectionValid True
12:49:59 - SELECT  DISTINCT * FROM Departments WHERE  TenantID =1 and ID = @val1  Query
12:49:59 - IsConnectionValid True
12:49:59 - SELECT  DISTINCT * FROM Section WHERE  TenantID =1 and ID = @val1  Query
12:50:03 - IsConnectionValid True
12:50:07 - IsConnectionValid True
12:50:12 - IsConnectionValid True
12:50: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 DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:50:25 - IsConnectionValid True
12:50:25 - 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 =622 and DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:50:28 - IsConnectionValid True
12:50: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 =621 and DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:50:30 - IsConnectionValid True
12:50:30 - 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 =620 and DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:50:34 - IsConnectionValid True
12:50: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 DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:50:38 - IsConnectionValid True
12:50: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 DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:50:44 - IsConnectionValid True
12:50:44 - 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 =33 and DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:50:47 - IsConnectionValid True
12:50:47 - 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 =0033 and DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:50:49 - IsConnectionValid True
12:50:49 - 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 =0033 and DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:50:49 - IsConnectionValid True
12:50:49 - 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:50:55 - IsConnectionValid True
12:50: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 DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:51:01 - IsConnectionValid True
12:51: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 =257 and DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:51:04 - IsConnectionValid True
12:51:04 - 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 =877 and DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:51:06 - IsConnectionValid True
12:51:06 - 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 =877 and DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:51:06 - IsConnectionValid True
12:51:06 - 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 =877 and DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:51:06 - IsConnectionValid True
12:51:06 - 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:51:09 - IsConnectionValid True
12:51: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 Code =788 and DateLeft = '1900-01-01'   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:52:15 - IsConnectionValid True
12:52:24 - IsConnectionValid True
12:52:24 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY TransID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT ID AS TransID, Code AS TransCode, Name AS TransName, Reccuring AS Reccuring, WorkingHours AS WorkingHours, Month_Divide AS Month_Divide, InsertType AS InsertType, TransEntryName AS TransEntryName, LinkWithAccNo AS LinkWithAccNo, Factor AS Multiply, Sign AS Sign, CASE WHEN IsSalaryDetails=1 THEN 1 ELSE 0 END  AS Post, VoucherType AS VoucherType, CalcPercent AS CalcPercent, IsWorkInjury AS IsWorkInjury, CalcBySocialSalary AS CalcBySocialSalary, AccountNo AS AccountNo, '' AS VoucherNo, IsTransIsNeededAccNo AS IsTransIsNeededAccNo FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 and TenantID = @val1 and IsNotManualEntry = @val2 and IsReserve = @val3 and Loans = @val4 and IsInsurance = @val5  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:52:25 - IsConnectionValid True
12:52:25 - SELECT * FROM HRMS_vwEmployees WHERE  TenantID = @val0 and UserID = @val1 and CAST(DateLeft AS Date) = @val2 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val6 and cast(replace(Code,'-','') as decimal(20,0)) <= @val7 ORDER BY cast(replace(Code,'-','') as decimal(20,0))  Query
12:52:31 - IsConnectionValid True
12:52:31 - SELECT * FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val5 and cast(replace(Code,'-','') as decimal(20,0)) <= @val6 AND (Code LIKE '%75%') ORDER BY ID ASC  Query
12:52:32 - IsConnectionValid True
12:52:32 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees  WHERE   UserID = @val0 and TenantID = @val1 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val5 and cast(replace(Code,'-','') as decimal(20,0)) <= @val6 AND Code LIKE @val7  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:52:41 - IsConnectionValid True
12:52:41 - SELECT * FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 and (ProjectID =0 or 0=0) and (DepartmentID =0 or 0=0) and (SectionID =0 or 0=0) and cast(replace(Code,'-','') as decimal(20,0)) >= @val5 and cast(replace(Code,'-','') as decimal(20,0)) <= @val6 AND (Code LIKE '%0075%') ORDER BY ID ASC  Query
12:53:34 - IsConnectionValid True
12:53:46 - IsConnectionValid True
12:53:46 - IsConnectionValid True
12:53:46 - IsConnectionValid True
12:53:46 - SELECT * FROM web_HRMS_Experience WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY StaffCatID ASC, ExperienceNo2 ASC  Query
12:53:46 - SELECT  DISTINCT * FROM StaffCategory WHERE  TenantID =1 ORDER BY ID  Query
12:53:50 - IsConnectionValid True
12:56:59 - IsConnectionValid True
12:56:59 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1
12:56:59 - Select COUNT(ID) AS TotalNum FROM Employees WHERE ( DATEDIFF(DAY,GETDATE(),EndContractDate)<=30 AND DATEDIFF(DAY,GETDATE(),EndContractDate)>0)  COUNT Query 0
12:56:59 - SELECT COUNT(ID) AS TotalNum 
									FROM VwEmpDocAlerts
									WHERE DocTypeID=1 AND  
									( DATEDIFF(DAY,GETDATE(),ToDate)<=21 AND 
									DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 0
12:56:59 - Select COUNT(E.ID) AS TotalNum from Employees E INNER JOIN EmploymentTypes ET ON E.EmploymentType=ET.ID WHERE ((( DATEDIFF(DAY,DateBegin ,GETDATE()))-6)/30 )>=6 and et.IsShowInAlert=1 and ISNULL(IsthirdOrFour,0)=0 COUNT Query 0
12:56:59 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(BirthDate)=MONTH(GETDATE())  COUNT Query 13
12:56:59 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND (DATEDIFF(day,DateBegin,GETDATE()) +1)<=90 AND (90 - (DATEDIFF(day,DateBegin,GETDATE()) +1))<=(SELECT RemainBeforeFinishTrainingPeriod FROM SysParam) COUNT Query 0
12:56:59 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(EndContractDate)=MONTH(GETDATE()) AND YEAR(EndContractDate)=YEAR(GETDATE())  COUNT Query 0
12:56:59 - SELECT COUNT(*)FROM (SELECT Gender,CODE,ID,Name,cASE when ISNULL(NewSocSecDate,'01/01/1900')<>'01/01/1900' AND ISNULL(NewSocSecDate,'')<>'' then DATEADD(DAY, (DATEDIFF(DAY, GETDATE(),NewSocSecDate)), BirthDate)ELSE BirthDate END COMPAREDATE FROM Employees where IsSocialSec = 1 AND DateLeft='01/01/1900') D WHERE Abs((DateDiff(DAY, (COMPAREDATE), GETDATE()) / 365)) > CASE WHEN Gender =1 THEN (SELECT FemaleSocStopY FROM SysParam) ELSE (SELECT MaleSocStopY FROM SysParam) END COUNT Query 1
12:57:01 - IsConnectionValid True
13:03:07 - IsConnectionValid True
13:03:08 - IsConnectionValid True
13:03:09 - IsConnectionValid True
13:03:10 - IsConnectionValid True
13:03:46 - IsConnectionValid True
13:03:47 - IsConnectionValid True
13:03:48 - IsConnectionValid True
13:04:27 - IsConnectionValid True
13:05:36 - IsConnectionValid True
13:05:36 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:05:37 - IsConnectionValid True
13:05:37 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
13:05:37 - IsConnectionValid True
13:05:37 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
13:05:38 - IsConnectionValid True
13:05: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 FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:05:49 - IsConnectionValid True
13:05:49 - IsConnectionValid True
13:05:49 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
13:05:51 - IsConnectionValid True
13:05:51 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:05:52 - IsConnectionValid True
13:05:52 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
13:05:52 - IsConnectionValid True
13:05:52 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
13:05:54 - IsConnectionValid True
13:05:54 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:05:55 - IsConnectionValid True
13:05:55 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:11:21 - IsConnectionValid True
15:11:24 - IsConnectionValid True
15:11:24 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:11:25 - IsConnectionValid True
15:11:25 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:11:25 - IsConnectionValid True
15:11:25 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:11:26 - IsConnectionValid True
15:11:26 - 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
15:14:19 - IsConnectionValid True
15:14:19 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:14:19 - IsConnectionValid True
15:14:19 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:14:30 - IsConnectionValid True
15:14:30 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:14:31 - IsConnectionValid True
15:14:31 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:14:35 - IsConnectionValid True
15:14:35 - 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
15:17:42 - IsConnectionValid True
15:17:45 - IsConnectionValid True
15:17:45 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:17:45 - IsConnectionValid True
15:17:45 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:17:45 - IsConnectionValid True
15:17:45 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:17:46 - IsConnectionValid True
15:17:46 - 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 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:20:04 - IsConnectionValid True
15:20:06 - IsConnectionValid True
15:20:06 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:20:06 - IsConnectionValid True
15:20:06 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:20:06 - IsConnectionValid True
15:20:06 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:20:07 - IsConnectionValid True
15:20: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, dbo.web_get_vacationCredit(ID,1,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:20:29 - IsConnectionValid True
15:20: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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:20:29 - IsConnectionValid True
15:20:29 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:20:56 - IsConnectionValid True
15:20:56 - 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, dbo.web_get_vacationCredit(ID,2,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:21:13 - IsConnectionValid True
15:21:13 - 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, dbo.web_get_vacationCredit(ID,2,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:21:19 - IsConnectionValid True
15:21:19 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:21:21 - IsConnectionValid True
15:21:21 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:21:23 - IsConnectionValid True
15:21:23 - 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, dbo.web_get_vacationCredit(ID,2,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:21:28 - IsConnectionValid True
15:21:32 - IsConnectionValid True
15:21:32 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:21:33 - IsConnectionValid True
15:21:33 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:21:33 - IsConnectionValid True
15:21:33 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:24:12 - IsConnectionValid True
15:24:14 - IsConnectionValid True
15:24:14 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:24:15 - IsConnectionValid True
15:24:15 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:24:15 - IsConnectionValid True
15:24:15 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:24:22 - IsConnectionValid True
15:24:22 - 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, dbo.web_get_vacationCredit(ID,2,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:24:53 - IsConnectionValid True
15:24:53 - IsConnectionValid True
15:24:53 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:24:55 - IsConnectionValid True
15:24:55 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:24:56 - IsConnectionValid True
15:24:56 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:24:56 - IsConnectionValid True
15:24:56 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:25:01 - IsConnectionValid True
15:25:01 - 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, dbo.web_get_vacationCredit(ID,2,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:25:10 - IsConnectionValid True
15:25:10 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:25:12 - IsConnectionValid True
15:25:12 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:25:13 - IsConnectionValid True
15:25:13 - 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, dbo.web_get_vacationCredit(ID,1,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:25:21 - IsConnectionValid True
15:25:21 - IsConnectionValid True
15:25:21 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:25:37 - IsConnectionValid True
15:25:37 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:25:38 - IsConnectionValid True
15:25:38 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:25:38 - IsConnectionValid True
15:25:38 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:25:46 - IsConnectionValid True
15:25:46 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:25:47 - IsConnectionValid True
15:25:47 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:25:52 - IsConnectionValid True
15:25:52 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:25:53 - IsConnectionValid True
15:25:53 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:25:54 - IsConnectionValid True
15:25:54 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:25:54 - IsConnectionValid True
15:25:54 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:25:56 - IsConnectionValid True
15:25:56 - 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, dbo.web_get_vacationCredit(ID,16,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:26:01 - IsConnectionValid True
15:26:01 - IsConnectionValid True
15:26:01 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:26:03 - IsConnectionValid True
15:26:03 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:26:04 - IsConnectionValid True
15:26:04 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:26:04 - IsConnectionValid True
15:26:04 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:26:57 - IsConnectionValid True
15:26:57 - 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, dbo.web_get_vacationCredit(ID,16,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:29:51 - IsConnectionValid True
15:29:51 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:29:53 - IsConnectionValid True
15:29:53 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:29:54 - IsConnectionValid True
15:29:54 - 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, dbo.web_get_vacationCredit(ID,19,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:30:15 - IsConnectionValid True
15:30:19 - IsConnectionValid True
15:30:35 - IsConnectionValid True
15:30:35 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:30:36 - IsConnectionValid True
15:30:36 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:30:40 - IsConnectionValid True
15:30:40 - 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, dbo.web_get_vacationCredit(ID,142,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:30:47 - IsConnectionValid True
15:31:23 - IsConnectionValid True
15:31:25 - IsConnectionValid True
15:31: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, 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:31:26 - IsConnectionValid True
15:31:26 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:31:26 - IsConnectionValid True
15:31:26 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:31:27 - IsConnectionValid True
15:31: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, Type AS Type, dbo.web_get_vacationCredit(ID,174,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:31:33 - IsConnectionValid True
15:32:20 - IsConnectionValid True
15:32:20 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:32:24 - IsConnectionValid True
15:32:24 - 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/18/2025)) and UserID = @val1 and TenantID = @val2 AND Code LIKE @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:32:25 - IsConnectionValid True
15:32:25 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:32:26 - IsConnectionValid True
15:32:26 - 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, dbo.web_get_vacationCredit(ID,869,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:32:26 - (1-gen-1004) : Divide by zero error encountered.
15:32:29 - IsConnectionValid True
15:32: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, dbo.web_get_vacationCredit(ID,869,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:32:29 - (1-gen-1004) : Divide by zero error encountered.
15:33:01 - IsConnectionValid True
15:33:01 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:33:04 - IsConnectionValid True
15:33:04 - 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/18/2025)) and UserID = @val1 and TenantID = @val2 AND Code LIKE @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:33:05 - IsConnectionValid True
15:33:05 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:33:06 - IsConnectionValid True
15:33:06 - 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, dbo.web_get_vacationCredit(ID,27,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:33:11 - IsConnectionValid True
15:33:18 - IsConnectionValid True
15:37:35 - IsConnectionValid True
15:37:35 - IsConnectionValid True
15:37:35 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:38:10 - IsConnectionValid True
15:38:10 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:38:12 - IsConnectionValid True
15:38:12 - 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/18/2025)) and UserID = @val1 and TenantID = @val2 AND Code LIKE @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:38:13 - IsConnectionValid True
15:38:13 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:38:13 - IsConnectionValid True
15:38:13 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:38:15 - IsConnectionValid True
15:38: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, Type AS Type, dbo.web_get_vacationCredit(ID,27,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:39:56 - IsConnectionValid True
15:39:56 - 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, dbo.web_get_vacationCredit(ID,27,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:40:01 - IsConnectionValid True
15:40:01 - IsConnectionValid True
15:40:01 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:40:28 - IsConnectionValid True
15:40:28 - 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/18/2025)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:40:30 - IsConnectionValid True
15:40:30 - 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/18/2025)) and UserID = @val1 and TenantID = @val2 AND Code LIKE @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:40:33 - IsConnectionValid True
15:40:33 - 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/18/2025)) and UserID = @val1 and TenantID = @val2 AND Code LIKE @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:40:39 - IsConnectionValid True
15:40:39 - 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/18/2025)) and UserID = @val1 and TenantID = @val2 AND Code LIKE @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:40:39 - IsConnectionValid True
15:40:39 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:40:40 - IsConnectionValid True
15:40:40 - SELECT * FROM VwVacationsExchangeModel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 ORDER BY Date ASC  Query
15:40:41 - IsConnectionValid True
15:40:41 - 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, dbo.web_get_vacationCredit(ID,27,1) AS VacationsCredit FROM HRMS_VwVacationTypes_WithSecurity  WHERE  TenantID = 1 AND   TenantID = @val0 and UserID = @val1 and Type = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow