Stage 3 — Rendered · lalit.kumar@kwglobal.com

Dispatched View full job

Recipient: lalit.kumar@kwglobal.com (Lalit Kumar) · Template: AssociateSummary · Job: E4A899C4-395C-4293-9CFA-5F7DF4911F5B

Stage 2 — Data

Fetched 2026-07-29 02:35:35.901524 · 16151 bytes

Associates 1 App Usage 24 Web Usage 14 Category Usage 10 Timesheet 2
Associates · 1 row(s) × 22 column(s)
UserIdCompanyIdUserNameUserEmailTotalTimeTotalDeskTimeDeskTimeProductiveTimeUnProductiveTimeNeutralTimeNoImpactTimeTotalIdleTimeMostUsedAppsCommitsWorkItemsActivityLoggedWorkItemsIsAttendanceBasedOnTrackingIsUserHavingShiftStartTimeFinishTimeMessageEnumIsNoImpactEnabled
99C1EAE4-7E81-42C1-9473-70EAEB575ECF 6E919CFE-74DD-4EBC-8665-3C0D44866649 Sunil Kumar1 sunil.kumar1@kwglobal.com 0h 0m 0 True True 0 False
App Usage · 24 row(s) × 6 column(s)
ApplicationNameTotalDurationPercentageProductivityRankingUserNameEmployeeNumber
OUTLOOK 02:48:25 43.97 Productive Lalit Kumar 46041
explorer 01:09:55 18.25 Productive Lalit Kumar 46041
notepad++ 00:41:54 10.94 Productive Lalit Kumar 46041
Notepad 00:28:16 7.38 Productive Lalit Kumar 46041
EXCEL 00:20:36 5.38 Productive Lalit Kumar 46041
ms-teams 00:18:06 4.73 Productive Lalit Kumar 46041
Acrobat 00:13:06 3.42 Productive Lalit Kumar 46041
WINWORD 00:07:54 2.06 Productive Lalit Kumar 46041
filezilla 00:04:37 1.21 Productive Lalit Kumar 46041
TimeChamp 00:02:43 0.71 Productive Lalit Kumar 46041
chrome 00:02:36 0.68 Productive Lalit Kumar 46041
DigitalEditions 00:01:12 0.31 Neutral Lalit Kumar 46041
msedge 00:01:11 0.31 Productive Lalit Kumar 46041
SnippingTool 00:00:48 0.21 Productive Lalit Kumar 46041
Thorium 00:00:33 0.14 Productive Lalit Kumar 46041
Ace by DAISY 00:00:24 0.10 Neutral Lalit Kumar 46041
SearchHost 00:00:23 0.10 Productive Lalit Kumar 46041
javaw 00:00:10 0.04 Productive Lalit Kumar 46041
ShellExperienceHost 00:00:05 0.02 Productive Lalit Kumar 46041
7zG 00:00:03 0.01 Productive Lalit Kumar 46041
Photos 00:00:02 0.01 UnProductive Lalit Kumar 46041
Photoshop 00:00:02 0.01 Productive Lalit Kumar 46041
Photoshop 00:00:02 0.01 UnProductive Lalit Kumar 46041
Kindle 00:00:01 0.00 Productive Lalit Kumar 46041
Web Usage · 14 row(s) × 6 column(s)
ApplicationNameTotalDurationPercentageProductivityRankingUserNameEmployeeNumber
accessanesthesiology.mhmedical.com 00:57:27 48.36 Neutral Lalit Kumar 46041
docs.google.com 00:28:14 23.77 Productive Lalit Kumar 46041
zipline.mhmedical.com 00:25:37 21.56 Neutral Lalit Kumar 46041
mft.hachette.co.uk 00:02:11 1.84 Productive Lalit Kumar 46041
accessmedicine.mhmedical.com 00:01:45 1.47 Neutral Lalit Kumar 46041
translate.google.com 00:00:57 0.80 Productive Lalit Kumar 46041
google.com 00:00:28 0.39 Productive Lalit Kumar 46041
accounts.mheducation.com 00:00:27 0.38 Neutral Lalit Kumar 46041
d 00:00:27 0.38 Productive Lalit Kumar 46041
mheducation.sharepoint.com 00:00:24 0.34 Productive Lalit Kumar 46041
mft.hachette.co.uk 00:00:21 0.29 Neutral Lalit Kumar 46041
accesssurgery.mhmedical.com 00:00:15 0.21 Neutral Lalit Kumar 46041
sso.mhmedical.com 00:00:08 0.11 Neutral Lalit Kumar 46041
kwglobal.v5.timechamp.io 00:00:07 0.10 Productive Lalit Kumar 46041
Category Usage · 10 row(s) × 5 column(s)
ApplicationCategoryNameTotalDurationPercentageUserNameEmployeeNumber
Office Apps 03:55 47.284 Lalit Kumar 46041
PRINT ACCOUNT_IDC 02:12 26.559 Lalit Kumar 46041
Others 01:27 17.505 Lalit Kumar 46041
Work Apps/URLs 00:28 5.634 Lalit Kumar 46041
Development 00:15 3.018 Lalit Kumar 46041
eLearning 00:00 0.000 Lalit Kumar 46041
KGLIndia 00:00 0.000 Lalit Kumar 46041
Personal URLs 00:00 0.000 Lalit Kumar 46041
HE and STM Apps 00:00 0.000 Lalit Kumar 46041
BackGround 00:00 0.000 Lalit Kumar 46041
Timesheet · 2 row(s) × 56 column(s)
TimeSheetIdUserIdUserNameTeamNameIsNoImpactEnabledRoleNameReportToEmployeeNameReportToEmployeeMailShiftDepartmentNameMobileNoDateActiveTimeInSecProductiveTimeInSecUnProductiveTimeInSecNeutralTimeInSecNoImpactTimeInSecTotalIdleTimeUserBreaksCountEmployeeNameUserProfileImageTimeZoneIdLunchBreakEndTimeLunchBreakStartTimeInTimeInTimeAbbreviationOutTimeAbbreviationLunchStartAbbreviationLunchEndAbbreviationInTimeTimeZoneOutTimeTimeZoneLunchStartTimeZoneLunchEndTimeZoneOutTimePunchCardBasedLatestInsertedTrackerDateLunchBreakDiffUsersBreakTimeIsNextDaySpentTimeDiffTotalOfflineTimeLunchTimeInSecUsersBreakTimeInSecEmployeeNumberLoggedTimeAttendanceStatusBranchNameDesktopNameTotalSpentTimeFullDayMinimumHoursHalfDayMinimumHoursAbsentDayMinimumHoursAttendanceAbsentTimeAttendanceHalfOrFullDayTimeIsAttendacneBasedOnPercentageTotalTimeInSec
46416736-FED0-4992-A43B-DF432DE0354C 6183DCB1-3C52-4187-8BFE-E06F7E1DA5DC lalit.kumar@kwglobal.com N-ePublishing False Manager Raju Sharma raju.sharma@kwglobal.com 09:00 IST - 18:00 IST ePublishing - XML 2026-07-28T00:00:00 29509 24245 5 5258 0 4281 0 Lalit Kumar 2026-07-28T07:43:39.524245+05:30 2026-07-28T17:06:50.464364+05:30 False 0 33791 1 0 46041 KGL-NOD XINNDNDELL098 90.93 8.0 4.0 4.0 491 491 False 33791
7DDD8F31-E761-4114-ABB0-697CB0740E0A 99C1EAE4-7E81-42C1-9473-70EAEB575ECF sunil.kumar1@kwglobal.com N-ePublishing False User Lalit Kumar lalit.kumar@kwglobal.com 09:00 IST - 18:00 IST ePublishing - XML 2026-07-28T00:00:00 0 0 0 Sunil Kumar1 False 0 0 48974 KGL-NOD 0.0 8.0 4.0 4.0 0 0 False
Meta · non-tabular fields
{
  "row_counts": {
    "app_usage": 24,
    "associates": 1,
    "category_usage": 10,
    "timesheet": 2,
    "web_usage": 14
  },
  "soft_labels": {
    "ActionLabel": "Action",
    "ActionsLabel": "Actions",
    "ActualShiftLabel": "Actual Shift",
    "ActualWorkingHoursLabel": "Actual Working Hours",
    "AuditActivityLabel": "Audit activity",
    "AuditAnalyticsLabel": "Audit analytics",
    "AuditLabel": "Audit",
    "AuditQuestionLabel": "Question",
    "AuditQuestionsLabel": "Question",
    "AuditReportLabel": "Audit report",
    "AuditReportsLabel": "Audit reports",
    "AuditsLabel": "Audits",
    "AvgOnlineHoursLabel": "Avg Online Hours",
    "AvgProductiveHoursLabel": "Avg Productive Hours",
    "AvgTotalHoursLabel": "Avg Total Hours",
    "AvgWorkingHoursLabel": "Avg Working Hours",
    "AwayHoursLabel": "Away Hours",
    "ClaimedTimeLabel": "Claimed Time",
    "CompanyId": "6E919CFE-74DD-4EBC-8665-3C0D44866649",
    "CompletedWorkItemsLabel": "Completed Work Items",
    "ConductLabel": "Conduct",
    "ConductsLabel": "Conducts",
    "CreatedDateTime": "2026-03-28 14:50:11.710000",
    "DeadlineLabel": "Deadline",
    "DeadlinesLabel": "Deadlines",
    "DescriptionLabel": "Description",
    "EmployeeCodeLabel": "Employee Code",
    "EmployeeLabel": "Employee",
    "EmployeesLabel": "Employees",
    "EndTimeLabel": "End Time",
    "EndingBalanceLabel": "Ending Balance",
    "EstimateLabel": "Estimate",
    "EstimatedTimeLabel": "Estimated time",
    "EstimatesLabel": "Estimates",
    "EstimationLabel": "Estimation",
    "EstimationsLabel": "Estimations",
    "ExpectedWorkingHoursLabel": "Expected Working Hours",
    "ExtensionLabel": "Extension",
    "ExtensionsLabel": "Extensions",
    "GoalLabel": "Module",
    "GoalsLabel": "Modules",
    "IdleHoursLabel": "Idle Hours",
    "IdleHoursPercentLabel": "Idle Hours %",
    "IdleLabel": "Idle",
    "LocationLabel": "Location",
    "NeutralHoursLabel": "Neutral Hours",
    "NeutralHoursPercentLabel": "Neutral Hours %",
    "NeutralLabel": "Neutral",
    "NeutralTAFSLabel": "Neutral(TAFS)",
    "NeutralTOSLabel": "Neutral(TOS)",
    "NewWorkItemsLabel": "New Work Items",
    "NoImpactHoursLabel": "No Impact Hours",
    "NoImpactHoursPercentLabel": "No Impact Hours %",
    "NoImpactLabel": "No Impact",
    "NoImpactTAFSLabel": "NoImpact(TAFS)",
    "NoImpactTOSLabel": "NoImpact(TOS)",
    "NonProductiveHoursLabel": "Non-Productive Hours",
    "NonProductiveHoursPercentLabel": "Non-Productive Hours %",
    "NonProductiveLabel": "Non-productive",
    "NonProductiveTAFSLabel": "NonProductive(TAFS)",
    "NonProductiveTOSLabel": "NonProductive(TOS)",
    "OfflineHoursLabel": "Offline Hours",
    "OfflineLabel": "Offline",
    "OfflineTAFSLabel": "Offline(TAFS)",
    "OnHoldLabel": "On Hold",
    "OnlineHoursLabel": "Online Hours",
    "OpeningBalanceLabel": "Opening Balance",
    "ProductiveHoursLabel": "Productive Hours",
    "ProductiveHoursPercentLabel": "Productive Hours %",
    "ProductiveLabel": "Productive",
    "ProductiveTAFSLabel": "Productive(TAFS)",
    "ProductiveTOSLabel": "Productive(TOS)",
    "ProjectLabel": "Project",
    "ProjectsLabel": "Projects",
    "ReportLabel": "Report",
    "ReportsLabel": "Reports",
    "RunLabel": "Test run",
    "RunsLabel": "Test runs",
    "ScenarioLabel": "Test suite",
    "ScenariosLabel": "Test suites",
    "ScheduledVsActualsLabel": "Scheduled vs Actuals",
    "SchedulesLabel": "Schedules",
    "SoftLabelConfigurationId": "85ACDD48-80CB-4FE0-90FD-29B06E7EE87A",
    "StartTimeLabel": "Start Time",
    "TakenBackByClientLabel": "Taken Back by Client",
    "TeamLabel": "Team",
    "TeamNameLabel": "Team Name",
    "TeamsLabel": "Teams",
    "TestReportLabel": "Test report",
    "TestReportsLabel": "Test reports",
    "TimeAwayFromSystemTAFSLabel": "TimeAwayFromSystem(TAFS)",
    "TimeOnSystemTOSLabel": "TimeOnSystem(TOS)",
    "TimeStamp": "b\u0027\\x00\\x00\\x00\\x00\\x009K\\xf9\u0027",
    "TimelineLabel": "Timeline",
    "TotalHoursLabel": "Total Hours",
    "TotalHoursPercentLabel": "Total Hours %",
    "UserNameLabel": "Username",
    "UserStoriesLabel": "Tasks",
    "UserStoryLabel": "Task",
    "VersionLabel": "Version",
    "VersionsLabel": "Versions",
    "WorkItemTypeLabel": "Task Type",
    "WorkItemTypesLabel": "Task Types",
    "WorkingHoursLabel": "Working Hours",
    "WorkingHoursPercentLabel": "Working Hours %"
  }
}
Raw JSON
{"associates": [{"UserId": "99C1EAE4-7E81-42C1-9473-70EAEB575ECF", "CompanyId": "6E919CFE-74DD-4EBC-8665-3C0D44866649", "UserName": "Sunil Kumar1", "UserEmail": "sunil.kumar1@kwglobal.com", "TotalTime": null, "TotalDeskTime": "0h 0m", "DeskTime": 0, "ProductiveTime": null, "UnProductiveTime": null, "NeutralTime": null, "NoImpactTime": null, "TotalIdleTime": null, "MostUsedApps": null, "Commits": null, "WorkItemsActivity": null, "LoggedWorkItems": null, "IsAttendanceBasedOnTracking": true, "IsUserHavingShift": true, "StartTime": null, "FinishTime": null, "MessageEnum": 0, "IsNoImpactEnabled": false}], "app_usage": [{"ApplicationName": "OUTLOOK", "TotalDuration": "02:48:25", "Percentage": "43.97", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "explorer", "TotalDuration": "01:09:55", "Percentage": "18.25", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "notepad++", "TotalDuration": "00:41:54", "Percentage": "10.94", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "Notepad", "TotalDuration": "00:28:16", "Percentage": "7.38", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "EXCEL", "TotalDuration": "00:20:36", "Percentage": "5.38", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "ms-teams", "TotalDuration": "00:18:06", "Percentage": "4.73", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "Acrobat", "TotalDuration": "00:13:06", "Percentage": "3.42", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "WINWORD", "TotalDuration": "00:07:54", "Percentage": "2.06", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "filezilla", "TotalDuration": "00:04:37", "Percentage": "1.21", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "TimeChamp", "TotalDuration": "00:02:43", "Percentage": "0.71", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "chrome", "TotalDuration": "00:02:36", "Percentage": "0.68", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "DigitalEditions", "TotalDuration": "00:01:12", "Percentage": "0.31", "ProductivityRanking": "Neutral", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "msedge", "TotalDuration": "00:01:11", "Percentage": "0.31", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "SnippingTool", "TotalDuration": "00:00:48", "Percentage": "0.21", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "Thorium", "TotalDuration": "00:00:33", "Percentage": "0.14", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "Ace by DAISY", "TotalDuration": "00:00:24", "Percentage": "0.10", "ProductivityRanking": "Neutral", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "SearchHost", "TotalDuration": "00:00:23", "Percentage": "0.10", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "javaw", "TotalDuration": "00:00:10", "Percentage": "0.04", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "ShellExperienceHost", "TotalDuration": "00:00:05", "Percentage": "0.02", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "7zG", "TotalDuration": "00:00:03", "Percentage": "0.01", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "Photos", "TotalDuration": "00:00:02", "Percentage": "0.01", "ProductivityRanking": "UnProductive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "Photoshop", "TotalDuration": "00:00:02", "Percentage": "0.01", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "Photoshop", "TotalDuration": "00:00:02", "Percentage": "0.01", "ProductivityRanking": "UnProductive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "Kindle", "TotalDuration": "00:00:01", "Percentage": "0.00", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}], "web_usage": [{"ApplicationName": "accessanesthesiology.mhmedical.com", "TotalDuration": "00:57:27", "Percentage": "48.36", "ProductivityRanking": "Neutral", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "docs.google.com", "TotalDuration": "00:28:14", "Percentage": "23.77", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "zipline.mhmedical.com", "TotalDuration": "00:25:37", "Percentage": "21.56", "ProductivityRanking": "Neutral", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "mft.hachette.co.uk", "TotalDuration": "00:02:11", "Percentage": "1.84", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "accessmedicine.mhmedical.com", "TotalDuration": "00:01:45", "Percentage": "1.47", "ProductivityRanking": "Neutral", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "translate.google.com", "TotalDuration": "00:00:57", "Percentage": "0.80", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "google.com", "TotalDuration": "00:00:28", "Percentage": "0.39", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "accounts.mheducation.com", "TotalDuration": "00:00:27", "Percentage": "0.38", "ProductivityRanking": "Neutral", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "d", "TotalDuration": "00:00:27", "Percentage": "0.38", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "mheducation.sharepoint.com", "TotalDuration": "00:00:24", "Percentage": "0.34", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "mft.hachette.co.uk", "TotalDuration": "00:00:21", "Percentage": "0.29", "ProductivityRanking": "Neutral", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "accesssurgery.mhmedical.com", "TotalDuration": "00:00:15", "Percentage": "0.21", "ProductivityRanking": "Neutral", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "sso.mhmedical.com", "TotalDuration": "00:00:08", "Percentage": "0.11", "ProductivityRanking": "Neutral", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationName": "kwglobal.v5.timechamp.io", "TotalDuration": "00:00:07", "Percentage": "0.10", "ProductivityRanking": "Productive", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}], "category_usage": [{"ApplicationCategoryName": "Office Apps", "TotalDuration": "03:55", "Percentage": "47.284", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationCategoryName": "PRINT ACCOUNT_IDC", "TotalDuration": "02:12", "Percentage": "26.559", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationCategoryName": "Others", "TotalDuration": "01:27", "Percentage": "17.505", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationCategoryName": "Work Apps/URLs", "TotalDuration": "00:28", "Percentage": "5.634", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationCategoryName": "Development", "TotalDuration": "00:15", "Percentage": "3.018", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationCategoryName": "eLearning", "TotalDuration": "00:00", "Percentage": "0.000", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationCategoryName": "KGLIndia", "TotalDuration": "00:00", "Percentage": "0.000", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationCategoryName": "Personal URLs", "TotalDuration": "00:00", "Percentage": "0.000", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationCategoryName": "HE and STM Apps", "TotalDuration": "00:00", "Percentage": "0.000", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}, {"ApplicationCategoryName": "BackGround", "TotalDuration": "00:00", "Percentage": "0.000", "UserName": "Lalit Kumar", "EmployeeNumber": "46041"}], "timesheet": [{"TimeSheetId": "46416736-FED0-4992-A43B-DF432DE0354C", "UserId": "6183DCB1-3C52-4187-8BFE-E06F7E1DA5DC", "UserName": "lalit.kumar@kwglobal.com", "TeamName": "N-ePublishing", "IsNoImpactEnabled": false, "RoleName": " Manager", "ReportToEmployeeName": "Raju Sharma", "ReportToEmployeeMail": "raju.sharma@kwglobal.com", "Shift": "09:00 IST - 18:00 IST", "DepartmentName": "ePublishing - XML", "MobileNo": null, "Date": "2026-07-28T00:00:00", "ActiveTimeInSec": 29509, "ProductiveTimeInSec": 24245, "UnProductiveTimeInSec": 5, "NeutralTimeInSec": 5258, "NoImpactTimeInSec": 0, "TotalIdleTime": 4281, "UserBreaksCount": 0, "EmployeeName": "Lalit Kumar", "UserProfileImage": null, "TimeZoneId": null, "LunchBreakEndTime": null, "LunchBreakStartTime": null, "InTime": "2026-07-28T07:43:39.524245+05:30", "InTimeAbbreviation": null, "OutTimeAbbreviation": null, "LunchStartAbbreviation": null, "LunchEndAbbreviation": null, "InTimeTimeZone": null, "OutTimeTimeZone": null, "LunchStartTimeZone": null, "LunchEndTimeZone": null, "OutTime": "2026-07-28T17:06:50.464364+05:30", "PunchCardBased": false, "LatestInsertedTrackerDate": null, "LunchBreakDiff": null, "UsersBreakTime": null, "IsNextDay": 0, "SpentTimeDiff": 33791, "TotalOfflineTime": 1, "LunchTimeInSec": null, "UsersBreakTimeInSec": 0, "EmployeeNumber": "46041", "LoggedTime": null, "AttendanceStatus": "", "BranchName": "KGL-NOD", "DesktopName": "XINNDNDELL098", "TotalSpentTime": 90.93, "FullDayMinimumHours": 8.0, "HalfDayMinimumHours": 4.0, "AbsentDayMinimumHours": 4.0, "AttendanceAbsentTime": 491, "AttendanceHalfOrFullDayTime": 491, "IsAttendacneBasedOnPercentage": false, "TotalTimeInSec": 33791}, {"TimeSheetId": "7DDD8F31-E761-4114-ABB0-697CB0740E0A", "UserId": "99C1EAE4-7E81-42C1-9473-70EAEB575ECF", "UserName": "sunil.kumar1@kwglobal.com", "TeamName": "N-ePublishing", "IsNoImpactEnabled": false, "RoleName": " User", "ReportToEmployeeName": "Lalit Kumar", "ReportToEmployeeMail": "lalit.kumar@kwglobal.com", "Shift": "09:00 IST - 18:00 IST", "DepartmentName": "ePublishing - XML", "MobileNo": null, "Date": "2026-07-28T00:00:00", "ActiveTimeInSec": 0, "ProductiveTimeInSec": null, "UnProductiveTimeInSec": null, "NeutralTimeInSec": null, "NoImpactTimeInSec": null, "TotalIdleTime": 0, "UserBreaksCount": 0, "EmployeeName": "Sunil Kumar1", "UserProfileImage": null, "TimeZoneId": null, "LunchBreakEndTime": null, "LunchBreakStartTime": null, "InTime": null, "InTimeAbbreviation": null, "OutTimeAbbreviation": null, "LunchStartAbbreviation": null, "LunchEndAbbreviation": null, "InTimeTimeZone": null, "OutTimeTimeZone": null, "LunchStartTimeZone": null, "LunchEndTimeZone": null, "OutTime": null, "PunchCardBased": false, "LatestInsertedTrackerDate": null, "LunchBreakDiff": null, "UsersBreakTime": null, "IsNextDay": 0, "SpentTimeDiff": null, "TotalOfflineTime": null, "LunchTimeInSec": null, "UsersBreakTimeInSec": 0, "EmployeeNumber": "48974", "LoggedTime": null, "AttendanceStatus": "", "BranchName": "KGL-NOD", "DesktopName": null, "TotalSpentTime": 0.0, "FullDayMinimumHours": 8.0, "HalfDayMinimumHours": 4.0, "AbsentDayMinimumHours": 4.0, "AttendanceAbsentTime": 0, "AttendanceHalfOrFullDayTime": 0, "IsAttendacneBasedOnPercentage": false, "TotalTimeInSec": null}], "soft_labels": {"SoftLabelConfigurationId": "85ACDD48-80CB-4FE0-90FD-29B06E7EE87A", "ProjectLabel": "Project", "GoalLabel": "Module", "EmployeeLabel": "Employee", "EmployeeCodeLabel": "Employee Code", "UserStoryLabel": "Task", "DeadlineLabel": "Deadline", "ProjectsLabel": "Projects", "GoalsLabel": "Modules", "EmployeesLabel": "Employees", "UserStoriesLabel": "Tasks", "DeadlinesLabel": "Deadlines", "ScenarioLabel": "Test suite", "ScenariosLabel": "Test suites", "RunLabel": "Test run", "RunsLabel": "Test runs", "VersionLabel": "Version", "VersionsLabel": "Versions", "TestReportLabel": "Test report", "TestReportsLabel": "Test reports", "EstimatedTimeLabel": "Estimated time", "EstimationLabel": "Estimation", "EstimationsLabel": "Estimations", "EstimateLabel": "Estimate", "EstimatesLabel": "Estimates", "AuditLabel": "Audit", "AuditsLabel": "Audits", "ConductLabel": "Conduct", "ConductsLabel": "Conducts", "ActionLabel": "Action", "ActionsLabel": "Actions", "TimelineLabel": "Timeline", "AuditActivityLabel": "Audit activity", "AuditReportLabel": "Audit report", "AuditReportsLabel": "Audit reports", "ReportLabel": "Report", "ReportsLabel": "Reports", "AuditAnalyticsLabel": "Audit analytics", "AuditQuestionLabel": "Question", "AuditQuestionsLabel": "Question", "ExtensionLabel": "Extension", "ExtensionsLabel": "Extensions", "StartTimeLabel": "Start Time", "EndTimeLabel": "End Time", "ProductiveHoursLabel": "Productive Hours", "ProductiveHoursPercentLabel": "Productive Hours %", "AvgProductiveHoursLabel": "Avg Productive Hours", "NonProductiveHoursLabel": "Non-Productive Hours", "NonProductiveHoursPercentLabel": "Non-Productive Hours %", "NeutralHoursLabel": "Neutral Hours", "NeutralHoursPercentLabel": "Neutral Hours %", "IdleHoursLabel": "Idle Hours", "IdleHoursPercentLabel": "Idle Hours %", "OfflineHoursLabel": "Offline Hours", "AwayHoursLabel": "Away Hours", "WorkingHoursLabel": "Working Hours", "WorkingHoursPercentLabel": "Working Hours %", "AvgWorkingHoursLabel": "Avg Working Hours", "ExpectedWorkingHoursLabel": "Expected Working Hours", "ActualWorkingHoursLabel": "Actual Working Hours", "TotalHoursLabel": "Total Hours", "TotalHoursPercentLabel": "Total Hours %", "AvgTotalHoursLabel": "Avg Total Hours", "OnlineHoursLabel": "Online Hours", "AvgOnlineHoursLabel": "Avg Online Hours", "LocationLabel": "Location", "ProductiveTOSLabel": "Productive(TOS)", "NonProductiveTOSLabel": "NonProductive(TOS)", "NeutralTOSLabel": "Neutral(TOS)", "TimeOnSystemTOSLabel": "TimeOnSystem(TOS)", "ProductiveTAFSLabel": "Productive(TAFS)", "NonProductiveTAFSLabel": "NonProductive(TAFS)", "NeutralTAFSLabel": "Neutral(TAFS)", "OfflineTAFSLabel": "Offline(TAFS)", "TimeAwayFromSystemTAFSLabel": "TimeAwayFromSystem(TAFS)", "SchedulesLabel": "Schedules", "ActualShiftLabel": "Actual Shift", "ScheduledVsActualsLabel": "Scheduled vs Actuals", "UserNameLabel": "Username", "TeamLabel": "Team", "TeamsLabel": "Teams", "TeamNameLabel": "Team Name", "WorkItemTypeLabel": "Task Type", "WorkItemTypesLabel": "Task Types", "ClaimedTimeLabel": "Claimed Time", "OpeningBalanceLabel": "Opening Balance", "NewWorkItemsLabel": "New Work Items", "CompletedWorkItemsLabel": "Completed Work Items", "OnHoldLabel": "On Hold", "TakenBackByClientLabel": "Taken Back by Client", "EndingBalanceLabel": "Ending Balance", "DescriptionLabel": "Description", "ProductiveLabel": "Productive", "NonProductiveLabel": "Non-productive", "NeutralLabel": "Neutral", "IdleLabel": "Idle", "OfflineLabel": "Offline", "NoImpactHoursLabel": "No Impact Hours", "NoImpactHoursPercentLabel": "No Impact Hours %", "NoImpactLabel": "No Impact", "NoImpactTAFSLabel": "NoImpact(TAFS)", "NoImpactTOSLabel": "NoImpact(TOS)", "CompanyId": "6E919CFE-74DD-4EBC-8665-3C0D44866649", "CreatedDateTime": "2026-03-28 14:50:11.710000", "TimeStamp": "b'\\x00\\x00\\x00\\x00\\x009K\\xf9'"}, "row_counts": {"associates": 1, "app_usage": 24, "web_usage": 14, "category_usage": 10, "timesheet": 2}}

Stage 3 — Rendered

Rendered 2026-07-29 02:35:36.130527 · 28342 bytes

Subject: Daily associates summary report - Jul 28, 2026

Attachments
[{"name": "ManagerDailyAssociateSummaryReport_2026-07-28.xlsx", "path": "runs/875ba8c4-304a-48db-801d-1001f400dfdc-attachments/6183DCB1-3C52-4187-8BFE-E06F7E1DA5DC-ManagerDailyAssociateSummaryReport_2026-07-28.xlsx", "sizeBytes": 9336, "contentType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "kind": "xlsx"}]
Body HTML (source)
<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="utf-8" />
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />
  <meta name="x-apple-disable-message-reformatting" />
  <meta http-equiv="X-UA-Compatible" content="IE=edge" />
  <title>Account Password Reset</title>
  <style type="text/css">
    a {
      text-decoration: none;
      outline: none;
    }

    p {
      font-size: 14px;
      font-family: Roboto;
    }

    b {
      font-size: 14px;
      font-family: Roboto;
    }

    @media (max-width: 649px) {
      .o_col-full {
        max-width: 100% !important;
      }

      .o_col-half {
        max-width: 50% !important;
      }

      .o_hide-lg {
        display: inline-block !important;
        font-size: inherit !important;
        max-height: none !important;
        line-height: inherit !important;
        overflow: visible !important;
        width: auto !important;
        visibility: visible !important;
      }

      .o_hide-xs,
      .o_hide-xs.o_col_i {
        display: none !important;
        font-size: 0 !important;
        max-height: 0 !important;
        width: 0 !important;
        line-height: 0 !important;
        overflow: hidden !important;
        visibility: hidden !important;
        height: 0 !important;
      }

      .o_xs-center {
        text-align: center !important;
      }

      .o_xs-left {
        text-align: left !important;
      }

      .o_xs-right {
        text-align: left !important;
      }

      table.o_xs-left {
        margin-left: 0 !important;
        margin-right: auto !important;
        float: none !important;
      }

      table.o_xs-right {
        margin-left: auto !important;
        margin-right: 0 !important;
        float: none !important;
      }

      table.o_xs-center {
        margin-left: auto !important;
        margin-right: auto !important;
        float: none !important;
      }

      h1.o_heading {
        font-size: 32px !important;
        line-height: 41px !important;
      }

      h2.o_heading {
        font-size: 26px !important;
        line-height: 37px !important;
      }

      h3.o_heading {
        font-size: 20px !important;
        line-height: 30px !important;
      }

      .o_xs-py-md {
        padding-top: 24px !important;
        padding-bottom: 24px !important;
      }

      .o_xs-pt-xs {
        padding-top: 8px !important;
      }

      .o_xs-pb-xs {
        padding-bottom: 8px !important;
      }
    }

    @media screen {
      @font-face {
        font-family: Roboto;
        font-style: normal;
        font-weight: 400;
        src: local("Roboto"), local("Roboto-Regular"), url(https://fonts.gstatic.com/s/roboto/v18/KFOmCnqEu92Fr1Mu7GxKOzY.woff2) format("woff2");
        unicode-range: U+0100-024F, U+0259, U+1E00-1EFF, U+2020, U+20A0-20AB, U+20AD-20CF, U+2113, U+2C60-2C7F, U+A720-A7FF;
      }

      @font-face {
        font-family: Roboto;
        font-style: normal;
        font-weight: 400;
        src: local("Roboto"), local("Roboto-Regular"), url(https://fonts.gstatic.com/s/roboto/v18/KFOmCnqEu92Fr1Mu4mxK.woff2) format("woff2");
        unicode-range: U+0000-00FF, U+0131, U+0152-0153, U+02BB-02BC, U+02C6, U+02DA, U+02DC, U+2000-206F, U+2074, U+20AC, U+2122, U+2191, U+2193, U+2212, U+2215, U+FEFF, U+FFFD;
      }

      @font-face {
        font-family: Roboto;
        font-style: normal;
        font-weight: 700;
        src: local("Roboto Bold"), local("Roboto-Bold"), url(https://fonts.gstatic.com/s/roboto/v18/KFOlCnqEu92Fr1MmWUlfChc4EsA.woff2) format("woff2");
        unicode-range: U+0100-024F, U+0259, U+1E00-1EFF, U+2020, U+20A0-20AB, U+20AD-20CF, U+2113, U+2C60-2C7F, U+A720-A7FF;
      }

      @font-face {
        font-family: Roboto;
        font-style: normal;
        font-weight: 700;
        src: local("Roboto Bold"), local("Roboto-Bold"), url(https://fonts.gstatic.com/s/roboto/v18/KFOlCnqEu92Fr1MmWUlfBBc4.woff2) format("woff2");
        unicode-range: U+0000-00FF, U+0131, U+0152-0153, U+02BB-02BC, U+02C6, U+02DA, U+02DC, U+2000-206F, U+2074, U+20AC, U+2122, U+2191, U+2193, U+2212, U+2215, U+FEFF, U+FFFD;
      }

      .o_sans,
      .o_heading {
        font-family: "Roboto", sans-serif !important;
      }

      .o_heading,
      strong,
      b {
        font-weight: 700 !important;
      }

      a[x-apple-data-detectors] {
        color: inherit !important;
        text-decoration: none !important;
      }
    }
  </style>
  <!--[if mso]>              <style>                  table {                      border-collapse: collapse;                  }                  .o_col {                      float: left;                  }              </style>              <xml>                  <o:OfficeDocumentSettings> <o:PixelsPerInch>96</o:PixelsPerInch> </o:OfficeDocumentSettings>              </xml>          <![endif]-->
</head>

<body class="o_body o_bg-light"
  style="width: 100%; margin: 0px; padding: 0px; -webkit-text-size-adjust: 100%; -ms-text-size-adjust: 100%; background-color: #f9f8fa;">
  <!-- preview-text -->
  <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">
    <tbody>
      <tr>
        <td class="o_hide" align="center"
          style="display: none; font-size: 0; max-height: 0; width: 0; line-height: 0; overflow: hidden; mso-hide: all; visibility: hidden;">
          Email Summary (Hidden)</td>
      </tr>
    </tbody>
  </table> <!-- header-white-link -->
  <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">
  <tbody>
    <tr>
      <td class="o_bg-light o_px-xs" align="center"
        style="background-color: #f9f8fa; padding-left: 8px; padding-right: 8px;">
        <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"
          style="max-width: 700px; margin: 0 auto;">
          <tbody>
            <tr>
              <td style="padding: 10px 0; text-align: left;">
               
              </td>
            </tr>
          </tbody>
        </table>
      </td>
    </tr>
  </tbody>
</table>

<table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" 
       style="background-color:#f9f8fa; margin:0; padding:0;">
  <tbody>
    <tr>
      <td align="center">
        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" style=" max-width:700px;">
          <tbody>
            <tr>
              <td align="center" style="max-width:700px;">
                <div style=" text-align:center;  max-width:700px;">
                  <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">
    <tbody>
      <tr>
        <td class="o_bg-light o_px-xs o_pt-lg o_xs-pt-xs" align="center"
          style="background-color: #f9f8fa;">
          <!--[if mso]><table width="632" cellspacing="0" cellpadding="0" border="0" role="presentation"><tbody><tr><td><![endif]-->
          <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"
            style="margin: 0 auto;">
            <tbody>
              <tr>
                <td class="o_re o_bg-white o_px o_pb-md o_br-t" align="center"
                  style="font-size: 0;vertical-align: top;background-color: #ecf9fb;border-radius: 4px 4px 0px 0px;padding-left: 16px;padding-right: 16px;padding-top: 7px;padding-bottom: 7px;">
                  <!--[if mso]><table cellspacing="0" cellpadding="0" border="0" role="presentation"><tbody><tr><td width="200" align="left" valign="top" style="padding:0px 8px;"><![endif]-->
                  <div class="o_col o_col-2"
                    style="display: inline-block;vertical-align: top;width: 100%;max-width: 200px;">
                    <div class="o_px-xs o_sans o_text o_left o_xs-center"
                      style="font-family: Helvetica, Arial, sans-serif;margin-top: 0px;margin-bottom: 0px;font-size: 16px;line-height: 24px;text-align: center;padding-left: 8px;padding-right: 8px;">
                      <p style="margin-top: 0px;margin-bottom: 0px;"><a class="o_text-primary"
                          style="text-decoration: none;outline: none;color: #126de5;"><img
                            src="https://timechampimages.blob.core.windows.net/icons/timechamp_logo.png" width="150" height="36"
                            style="max-width: 150px;-ms-interpolation-mode: bicubic;vertical-align: middle;border: 0;line-height: 100%;height: auto;outline: none;text-decoration: none;"></a>
                      </p>
                    </div>
                  </div>
                </td>
              </tr>
            </tbody>
          </table>
        </td>
      </tr>
    </tbody>
  </table>
                </div>
              </td>
            </tr>
          </tbody>
        </table>
      </td>
    </tr>
  </tbody>
</table>
  <!-- hero-icon-lines -->
  <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">
    <tbody>
      <tr>
        <td class="o_bg-light o_px-xs" align="center"
          style="background-color: #f9f8fa; padding-left: 8px; padding-right: 8px;">
          <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"
            style="max-width: 700px; margin: 0 auto;">
            <tbody>
              <tr>
                <td class="o_bg-ultra_light o_px-md o_py-xl o_xs-py-md o_sans o_text-md o_text-light" align="center"
                  style="                                              font-family: Helvetica, Arial, sans-serif;                                              margin-top: 0px;                                              margin-bottom: 0px;                                              font-size: 19px;                                              line-height: 28px;                                              background-color: white;                                              color: #82899a;                                              padding-left: 24px;                                              padding-right: 24px;                                              padding-top: 10px;                                              padding-bottom: 10px;                                          ">
                  <p
                    style="font-size: 13pt; margin-top: 0px; margin-bottom: 10px; color: #363636; font-family: roboto; text-align: left;">
                    <span style="font-weight: 600;">Hi Lalit Kumar,</span><br /> Here is the summary report of your
                    associates for <span style="font-weight: 600;"> Jul 28, 2026</span>. </p>
                </td>
              </tr>
              <tr>
                <td style="text-align: center;"> <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"><tbody>  <tr>    <td class="o_bg-light o_px-xs" align="center" style="background-color: #f9f8fa; max-width: 700px;">      <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" style="max-width: 700px; margin: 0 auto; background-color: white;">        <tbody>          <tr>            <td style="padding: 0px 25px; font-weight: 600; font-family: Helvetica, Arial, sans-serif;">              <p style="margin-top: 10px; margin-bottom: 0px; color: #363636; font-weight:600;font-size: 13pt; letter-spacing: .5px;">Sunil Kumar1</p>            </td>          </tr>        </tbody>      </table><table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" style="max-width: 700px; margin: 0 auto; background-color: #ffffff;">  <tbody>    <tr>      <td class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="center" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 12pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-top: 16px; padding-bottom: 10px; width: 25%; vertical-align: top;">        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">          <tbody>            <tr>              <td  style="border-right: 1px solid #dbe5ea;">                <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;text-align:center;border-right: 1px solid #dbe5ea;">                  <span style="color: #363636;">Start Time<br></span>                  <span style="color: #51A6DF;font-size: 14pt;">-</span>                </p>              </td>            </tr>          </tbody>        </table>      </td>      <td  class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="center" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 12pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-top: 16px; padding-bottom: 10px; width: 25%; vertical-align: top;" >        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">          <tbody>            <tr>              <td  style="border-right: 1px solid #dbe5ea;">                <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;text-align:center;border-right: 1px solid #dbe5ea;">                  <span style="color: #363636;">Finish Time<br></span>                  <span style="color: #F27575;font-size: 14pt; ">-</span>                </p>              </td>            </tr>          </tbody>        </table>      </td>      <td class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="center" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 12pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-top: 16px; padding-bottom: 10px; width: 25%; vertical-align: top;">        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">          <tbody>            <tr>              <td  style="border-right: 1px solid #dbe5ea;">                <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;text-align:center;border-right: 1px solid #dbe5ea;">                  <span style="color: #363636;">Desk Time<br></span>                  <span style="color: #5861AA;font-size: 14pt;">0h 0m</span>                </p>              </td>            </tr>          </tbody>        </table>      </td>              <td  class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="center" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 12pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-top: 16px; padding-bottom: 10px; width: 25%; vertical-align: top;">                <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">                  <tbody>                    <tr>                      <td>                        <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;text-align:center;">                          <span style="color: #363636;">Productive Hours<br></span>                          <span style="color: #4CC96D;font-size: 14pt; ">0h 0m</span>                        </p>                      </td>                    </tr>                  </tbody>                </table>              </td>          </tr>        </tbody>      </table><table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" style="max-width: 700px; margin: 0 auto;">  <tbody>    <tr>      <td class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="center" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 12pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-top: 16px; padding-bottom: 10px; width: 25%; vertical-align: top; ">        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">          <tbody>            <tr>              <td   style="border-right: 1px solid #dbe5ea;">                <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;text-align:center;border-right: 1px solid #dbe5ea;">                  <span style="color: #363636;">Non-Productive Hours<br></span>                  <span style="color: #F27575;font-size: 14pt; ">0h 0m</span>                </p>              </td>            </tr>          </tbody>        </table>      </td>      <td  class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="center" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 12pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-top: 16px; padding-bottom: 10px; width: 25%; vertical-align: top;">        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">          <tbody>            <tr>              <td  style="border-right: 1px solid #dbe5ea;">                <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;text-align:center;border-right: 1px solid #dbe5ea;">                  <span style="color: #363636;">Neutral Time<br></span>                  <span style="color: #A4A9D0;font-size: 14pt; ">0h 0m</span>                </p>              </td>            </tr>          </tbody>        </table>      </td>      <td class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="center" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 12pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-top: 16px; padding-bottom: 10px; width: 25%; vertical-align: top;">        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">          <tbody>            <tr>              <td style="border-right: 1px solid #dbe5ea;">                <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;text-align:center">                  <span style="color: #363636;">Idle Time<br></span>                  <span style="color: #D2BB45;font-size: 14pt; ">0h 0m</span>                </p>              </td>            </tr>          </tbody>        </table>      </td>      <td class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="center" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 12pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-top: 16px; padding-bottom: 10px; width: 25%; vertical-align: top;">        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"  style="display:none;">          <tbody>            <tr>              <td >                <p style="margin-top: 0px; margin-bottom: 3px; margin-left: 0px;text-align:center">                  <span style="color: #363636;">No Impact Time<br></span>                  <span style="color: #D2BB45;font-size: 14pt; ">0h 0m</span>                </p>              </td>            </tr>          </tbody>        </table>      </td>    </tr>  </tbody></table><table width="100%" cellspacing="0"  style="max-width: 700px; margin: 0 auto;" cellpadding="0" border="0" role="presentation">  <tbody>    <tr style="border-bottom: 1px solid #dbe5ea;">      <td class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="left" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 13pt; line-height: 24px; background-color: #ffffff; color: #424651; padding-left: 24px; padding-right: 24px; padding-top: 16px; padding-bottom: 10px; vertical-align: top;">        <p style="margin-top: 10px; margin-bottom: 5px; color: #363636;font-weight:600;font-size:11pt">Most Used Applications & Websites : </p>        <div style="margin: 0px">                  </div>      </td>    </tr>  </tbody></table><table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" style="max-width: 632px; margin: 0 auto;">  <tbody>    <tr><td><table style="width: 100%; border-collapse: collapse; max-width: 632px; margin: 0 auto;">  <tbody><tr><td class="o_bg-white o_px-md o_py o_sans o_text o_text-secondary" align="left" style="font-family: Helvetica, Arial, sans-serif; margin-top: 0px; margin-bottom: 0px; font-size: 16px; line-height: 24px; background-color: #ffffff; color: #424651; border-top: 1px solid #d3dce0;"></td></tr>  </tbody></table></td>    </tr>  </tbody></table></td>            </tr>          </tbody>        </table> <!-- footer-white-2cols --> </td>
              </tr>
            </tbody>
          </table>
          <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"
            style="max-width: 700px; margin: 0 auto;">
            <tbody>
              <tr style="margin-bottom: 0px; background-color: white;">
                <td align="left"
                  style="background-color: white; align-items: center; flex-direction: row; padding-left: 24px; line-height: 30px; padding-right: 24px; padding-top: 10px; padding-bottom: 10px;">
                  <p> <b>Best Regards,</b><br /> <img src="https://i.stack.imgur.com/SRhpR.png" alt="signature"
                      style="margin-left: -1px; width: 100px;" /> </p>
                </td>
              </tr>
              <tr style="margin-bottom: 0px; background-color: white;">
                <td style="height: 10px;"></td>
              </tr>
            </tbody>
          </table>
        </td>
      </tr>
    </tbody>
  </table>
 <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" 
       style="background-color:#f9f8fa; margin:0; padding:0;">
  <tbody>
    <tr>
      <td align="center">
        <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation" style=" max-width:700px;">
          <tbody>
            <tr>
              <td align="center" style="max-width:700px;">
                <div style="text-align:center; max-width:700px;">
                  <table width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation">
    <tbody>
      <tr>
        <td class="o_bg-light o_px-xs o_pb-lg o_xs-pb-xs" align="center"
          style="background-color: #f9f8fa;padding-bottom:32px;white-space: nowrap;">
          <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"
            style="margin:0 auto;">
            <tbody>
              <tr style="background-color: #ecf9fb;">
                <td class="o_re o_px o_pb-lg" style="font-size:0;padding-left:10px;">
                  <div class="small_font ccc"
                    style="display:inline-block;vertical-align:top;width:100%;max-width:200px">
                    <div class="o_px-xs o_sans o_text-xs o_text-dark_light o_left o_xs-center"
                      style="font-family:Helvetica,Arial,sans-serif;margin-bottom:0;font-size:14px;text-align:left;padding-left:8px;padding-right:8px;white-space: nowrap;">
                      <p style="margin-top:0;margin-bottom:0" class="small_font">For support <a class="small_font"
                          class="o_text-dark_light o_underline"
                          href="https://timechamp.freshdesk.com/support/solutions/articles/101000451716" target="_blank"
                          style="outline:0;color:#1e9999;text-decoration: none;">Contact us</a> </p>
                    </div>
                  </div>
                </td>
                <td style="height: 35px;white-space: nowrap;">
                  <div class="small_font ccc"
                    style="display:inline-block;vertical-align:top;width:100%;max-width:135px">
                    <div class="o_px-xs o_sans o_text-xs o_text-dark_light o_left o_xs-center"
                      style="font-family:Helvetica,Arial,sans-serif;margin-bottom:0;font-size:14px;text-align:Center;padding-left:8px;padding-right:8px;white-space: nowrap;">
                      <span><a class="small_font" href="https://timechamp.io/documents/TimeChampTermsAndConditions.pdf"
                          target="_blank" style="color: #1e9999;text-decoration: none;padding-left: 8px;">Terms &
                          Conditions</a> </span> </div>
                  </div>
                <td>
                  <div class="small_font"
                    style="display:inline-block;vertical-align:top;width:100%;max-width:200px;white-space: nowrap;">
                    <div class="o_px-xs o_sans o_text-xs o_text-dark_light o_right"
                      style="font-family:Helvetica,Arial,sans-serif;margin-top:0;margin-bottom:0;font-size:15px;line-height:21px;text-align:right;padding-left:8px;padding-right:8px;white-space: nowrap;">
                      <p style="margin-top:0;margin-bottom:0"> <a class="o_text-dark_light"
                          href="https://www.youtube.com/@timechamp_io" target="_blank"
                          style="text-decoration:none;outline:0;"> <img class="youtube"
                            src="https://timechampimages.blob.core.windows.net/icons/youtube_logo.png" width="19" height="19" alt="fb"
                            style="max-width:36px;-ms-interpolation-mode:bicubic;vertical-align:middle;border:0;line-height:100%;height:auto;outline:0;text-decoration:none">
                        </a><span>&nbsp;</span> <a class="o_text-dark_light" href="https://www.facebook.com/TimeChamp1/"
                          target="_blank" style="text-decoration:none;outline:0;"> <img class="youtube"
                            src="https://timechampimages.blob.core.windows.net/icons/facebook_logo.png" width="14" height="14" alt="fb"
                            style="max-width:36px;-ms-interpolation-mode:bicubic;vertical-align:middle;border:0;line-height:100%;height:auto;outline:0;text-decoration:none">
                        </a> <span>&nbsp;</span> <a class="o_text-dark_light" href="https://twitter.com/timechamp_io"
                          target="_blank" style="text-decoration:none;outline:0;"> <img class="youtube"
                            src="https://timechampimages.blob.core.windows.net/icons/twitter_logo.png" width="14" height="14" alt="tw"
                            style="max-width:36px;-ms-interpolation-mode:bicubic;vertical-align:middle;border:0;line-height:100%;height:auto;outline:0;text-decoration:none">
                        </a> <span>&nbsp;</span> <a class="o_text-dark_light"
                          href="https://www.linkedin.com/showcase/timechamp/" target="_blank"
                          style="text-decoration:none;outline:0;"> <img class="youtube"
                            src="https://timechampimages.blob.core.windows.net/icons/linkdin_logo.png" width="14" height="14" alt="ig"
                            style="max-width:36px;-ms-interpolation-mode:bicubic;vertical-align:middle;border:0;line-height:100%;height:auto;outline:0;text-decoration:none">
                        </a> <span>&nbsp;</span> <a class="o_text-dark_light"
                          href="https://www.instagram.com/timechamp.io/" target="_blank"
                          style="text-decoration:none;outline:0;"> <img class="youtube"
                            src="https://timechampimages.blob.core.windows.net/icons/instagram_logo.png" width="14" height="14" alt="ig"
                            style="max-width:36px;-ms-interpolation-mode:bicubic;vertical-align:middle;border:0;line-height:100%;height:auto;outline:0;text-decoration:none">
                        </a><span>&nbsp;&nbsp;&nbsp;</span> </p>
                    </div>
                  </div>
                </td>
              </tr>
            </tbody>
          </table>
          <div class="o_hide-xs" style="font-size:64px;line-height:64px;height:64px">&nbsp;</div>
        </td>
      </tr>
    </tbody>
  </table>
                </div>
              </td>
            </tr>
          </tbody>
        </table>
      </td>
    </tr>
  </tbody>
</table>
  
</body>

</html>
Rendered preview (sandboxed)

Stage 5 — Dispatched

Outcome
Inserted
SentMailId
E282F02F-424B-4E13-A8FC-75EEAA1E7900
Skip reason
Error
At
2026-07-29 02:35:36.432132

Events

AtStageLevelMessagemsWorker
2026-07-29 02:34:57.376274 DataFetch Info --- Stage 2 begin --- template=AssociateSummary recipient=lalit.kumar@kwglobal.com userId=6183DCB1-3C52-4187-8BFE-E06F7E1DA5DC thr-24124
2026-07-29 02:34:57.404275 DataFetch Info >>> EXEC USP_EmailComp_UserDailyTrackerReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @LeadLevelUserId='6183DCB1-3C52-4187-8BFE-E06F7E1DA5DC', @Date='2026-07-28') thr-24124
2026-07-29 02:34:58.148289 DataFetch Info <<< USP_EmailComp_UserDailyTrackerReport returned 1 row(s) in 740ms; cols=[UserId,CompanyId,UserName,UserEmail,TotalTime,TotalDeskTime,DeskTime,ProductiveTime,UnProductiveTime,NeutralTime,NoImpactTime,TotalIdleTime,MostUsedApps,Commits,WorkItemsActivity,LoggedWorkItems,IsAttendanceBasedOnTracking,IsUserHavingShift,StartTime,FinishTime,MessageEnum,IsNoImpactEnabled]; first_row={UserId=99C1EAE4-7E81-42C1-9473-70E..., CompanyId=6E919CFE-74DD-4EBC-8665-3C0..., UserName=Sunil Kumar1, UserEmail=sunil.kumar1@kwglobal.com, TotalTime=NULL, TotalDeskTime=0h 0m, DeskTime=0, ProductiveTime=NULL} 740 thr-24124
2026-07-29 02:34:58.152288 DataFetch Info >>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-07-28', @IsApp=1, @IsForLineManager=1, @LineManagerId='6183DCB1-3C52-4187-8BFE-E06F7E1DA5DC') thr-24124
2026-07-29 02:34:58.163288 DataFetch Info <<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Apps] returned 24 row(s) in 6ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber]; first_row={ApplicationName=OUTLOOK, TotalDuration=02:48:25, Percentage=43.97, ProductivityRanking=Productive, UserName=Lalit Kumar, EmployeeNumber=46041} 6 thr-24124
2026-07-29 02:34:58.168288 DataFetch Info >>> EXEC USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web](@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-07-28', @IsApp=0, @IsForLineManager=1, @LineManagerId='6183DCB1-3C52-4187-8BFE-E06F7E1DA5DC') thr-24124
2026-07-29 02:34:58.181285 DataFetch Info <<< USP_EmailComp_GetExportableWebAppUsageSummaryReport[Web] returned 14 row(s) in 10ms; cols=[ApplicationName,TotalDuration,Percentage,ProductivityRanking,UserName,EmployeeNumber]; first_row={ApplicationName=accessanesthesiology.mhmedi..., TotalDuration=00:57:27, Percentage=48.36, ProductivityRanking=Neutral, UserName=Lalit Kumar, EmployeeNumber=46041} 10 thr-24124
2026-07-29 02:34:58.186293 DataFetch Info >>> EXEC USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport(@CompanyId='6e919cfe-74dd-4ebc-8665-3c0d44866649', @Date='2026-07-28', @IsForLineManager=1, @LineManagerId='6183DCB1-3C52-4187-8BFE-E06F7E1DA5DC') thr-24124
2026-07-29 02:34:58.335740 DataFetch Info <<< USP_EmailComp_GetExportableAppCategoryWiseUsageSummaryReport returned 10 row(s) in 145ms; cols=[ApplicationCategoryName,TotalDuration,Percentage,UserName,EmployeeNumber]; first_row={ApplicationCategoryName=Office Apps, TotalDuration=03:55, Percentage=47.284, UserName=Lalit Kumar, EmployeeNumber=46041} 145 thr-24124
2026-07-29 02:34:58.351741 DataFetch Info >>> EXEC USP_EmailComp_DownloadTimesheet(@UserId=NULL, @DateFrom='2026-07-28', @DateTo='2026-07-28', @OperationsPerformedBy='6183DCB1-3C52-4187-8BFE-E06F7E1DA5DC', @EmployeeSearchText=NULL, @IsActive=NULL, @ProjectId=NULL, @IsCompanyWide=0) thr-24124
2026-07-29 02:35:35.885524 DataFetch Info <<< USP_EmailComp_DownloadTimesheet returned 2 row(s) in 37508ms; cols=[TimeSheetId,UserId,UserName,TeamName,IsNoImpactEnabled,RoleName,ReportToEmployeeName,ReportToEmployeeMail,Shift,DepartmentName,MobileNo,Date,ActiveTimeInSec,ProductiveTimeInSec,UnProductiveTimeInSec,NeutralTimeInSec,NoImpactTimeInSec,TotalIdleTime,UserBreaksCount,EmployeeName,UserProfileImage,TimeZoneId,LunchBreakEndTime,LunchBreakStartTime,InTime,InTimeAbbreviation,OutTimeAbbreviation,LunchStartAbbreviation,LunchEndAbbreviation,InTimeTimeZone,OutTimeTimeZone,LunchStartTimeZone,LunchEndTimeZone,OutTime,PunchCardBased,LatestInsertedTrackerDate,LunchBreakDiff,UsersBreakTime,IsNextDay,SpentTimeDiff,TotalOfflineTime,LunchTimeInSec,UsersBreakTimeInSec,EmployeeNumber,LoggedTime,AttendanceStatus,BranchName,DesktopName,TotalSpentTime,FullDayMinimumHours,HalfDayMinimumHours,AbsentDayMinimumHours,AttendanceAbsentTime,AttendanceHalfOrFullDayTime,IsAttendacneBasedOnPercentage,TotalTimeInSec]; first_row={TimeSheetId=46416736-FED0-4992-A43B-DF4..., UserId=6183DCB1-3C52-4187-8BFE-E06..., UserName=lalit.kumar@kwglobal.com, TeamName=N-ePublishing, IsNoImpactEnabled=False, RoleName= Manager, ReportToEmployeeName=Raju Sharm...} 37508 thr-24124
2026-07-29 02:35:35.893524 DataFetch Info Soft labels: batch-cache hit (105 keys) thr-24124
2026-07-29 02:35:35.896524 DataFetch Info AssociateSummary fetched — associates=1, app_usage=24, web_usage=14, category_usage=10, timesheet=2 thr-24124
2026-07-29 02:35:35.904526 DataFetch Info Wrote EmailComp_Job_Data (16151 bytes); shape=dict, top-level=['associates', 'app_usage', 'web_usage', 'category_usage', 'timesheet', 'soft_labels', 'row_counts'] 38497 thr-24124
2026-07-29 02:35:35.912524 Render Info --- Stage 3 begin --- template=AssociateSummary recipient=lalit.kumar@kwglobal.com thr-24124
2026-07-29 02:35:35.935546 Render Info dbo.HtmlTemplates lookup 'ManagerDailyAssociateSummaryEmailTemplate': OK (10649 chars, batch-cache hit) thr-24124
2026-07-29 02:35:36.137528 Render Info Rendered (28342 bytes, subject='Daily associates summary report - Jul 28, 2026', attachments=1) 226 thr-24124
2026-07-29 02:35:36.353531 QA Info QA passed (15 check(s)) 202 thr-24124
2026-07-29 02:35:36.361130 Dispatch Info >>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='lalit.kumar@kwglobal.com', @Subject='Daily associates summary report - Jul 28, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='34c620ac-7137-4cf2-83d6-11b9802fc670') thr-24124
2026-07-29 02:35:36.377131 Dispatch Info <<< USP_EmailComp_InsertMail returned MailId=e282f02f-424b-4e13-a8fc-75eeaa1e7900 in 14ms (inserted) 14 thr-24124
2026-07-29 02:35:36.423133 Dispatch Info >>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=e282f02f-424b-4e13-a8fc-75eeaa1e7900, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/470150ead5d3422ba2cfadd95c5d64ef_6183DCB1-3C52-4187-8BFE-E06F7E1DA5DC-ManagerDailyAssociateSummaryReport_2026-07-28.xlsx') thr-24124
2026-07-29 02:35:36.426132 Dispatch Info <<< USP_EmailComp_InsertMailAttchment OK in 1ms 1 thr-24124
2026-07-29 02:35:36.429132 Dispatch Info Inserted into SentMail. MailId=e282f02f-424b-4e13-a8fc-75eeaa1e7900 thr-24124