Job B20B5ACF-DF50-462D-A4A3-B50038D42191

Dispatched Back to batch
Batch
70D81621-0685-49A1-8807-56C48C1ACFD9
Template
InsufficientHours
Recipient
seema.balan@kwglobal.com (Seema Balan)
User id
90139A1E-5F0E-4A4D-B85B-7D8953D31A0C
Status
Dispatched
Attempts
3
Claimed by
thr-14344 at 2026-07-28 02:50:35.521256
Created
2026-07-28 02:50:23.787782
Completed
2026-07-28 02:50:35.612227

Attachments — what the end user receives in the email

#FilenameSizeStatusAction
1 90139A1E-5F0E-4A4D-B85B-7D8953D31A0C-Minimum Working Hours Report - 2026-07-27.csv
runs/70d81621-0685-49a1-8807-56c48c1acfd9-attachments/90139A1E-5F0E-4A4D-B85B-7D8953D31A0C-Minimum Working Hours Report - 2026-07-27.csv 		- missing file missing

Stage 4 — QA gate

Pass
15 checks run · 12 pass · 0 warn · 0 fail/error · 141 ms · evaluated 2026-07-28 02:50:35.516263
VerdictRuleExpected GotTime
Pass R1_RECIPIENT_EMAIL
Recipient's email address looks valid
severity: Block 		A real email address (with @, no commas/semicolons/angle-brackets, max 320 characters)
valid: seema.balan@kwglobal.com
 0 ms
Pass R2_RECIPIENT_ACTIVE
Recipient is an active employee in this company
severity: Block 		Recipient is a current, active employee of this company
OK
 0 ms
Pass R3_ACCESSIBLE_USERS
Recipient is a manager (has at least one team member)
severity: Block 		Recipient is a manager who has at least one team member to report on (skipped for UrgentAttention -- those recipients are HR-scoped, not line-manager-scoped)
181 active reportee(s) (8 inactive ignored)
Total In Tree
190
Active Others
181
Inactive Others
8
31 ms
Pass R4_SUBJECT_NONEMPTY
Email has a clean, non-empty subject line
severity: Block 		Email has a subject line that's filled in (no leftover {{name}} markers, max 500 characters)
len=51
 0 ms
Pass R5_PAYLOAD_PRESENT
Stage 2 saved data for this recipient
severity: Block 		Stage 2 saved data for this recipient
size=10012 bytes
 0 ms
Pass R6_PAYLOAD_NONEMPTY
The email actually has content (not empty)
severity: Block 		The data has at least some rows in it (not empty)
total rows=66
Section counts declared in the data
  • Users: 66
 0 ms
Pass R7_BODY_NO_PLACEHOLDERS
Email body has no unfilled placeholders like {{ManagerName}}
severity: Block 		Email body has no unfilled placeholders like {{ManagerName}} or ${date}
body OK (22841 bytes)
 0 ms
Pass R8_BODY_COMPLETE
Email body is complete (not cut off)
severity: Warn 		Email body is complete (at least 200 characters and ends with a closing tag, not cut off)
body looks complete (22841 bytes)
 0 ms
Pass R9_ATTACHMENTS_EXIST
All attachment files are saved correctly
severity: Block 		Every attachment file the email references actually exists on disk
1 attachment(s) present
Files attached
pathsize
runs\70d81621-0685-49a1-8807-56c48c1acfd9-attachments\90139A1E-5F0E-4A4D-B85B-7D8953D31A0C-Minimum Working Hours Report - 2026-07-27.csv2570
0 ms
Pass R10_ATTACHMENT_SIZE
Attachments are not too large to be emailed
severity: Warn 		Each attachment is 25 MB or less (so the email can actually be sent)
OK
 0 ms
Skipped R11_PAYLOAD_USERS_ACCESSIBLE
Email shows exactly this manager's team members
severity: Warn 		Every person shown in the email is accessible to this recipient (no leakage). For AssociateSummary / TeamSummary the accessible set is the recipient's line-manager reportee tree. For UrgentAttention the accessible set is the recipient's HR scope (the users returned by USP_*_GetUrgentNotificationUserDetails for their HrUserId), which is broader than the reportee tree. For InsufficientHours the reportee tree is used but the 'missing reportees' half is skipped (the report only lists users who triggered the threshold).
no UID-shaped fields recognised in payload
 0 ms
Pass R12_ROW_COUNTS_CONSISTENT
The counts shown match the actual number of rows
severity: Warn 		The 'count' numbers shown at the top of the data match how many rows are actually there
all 1 row_counts consistent
 0 ms
Skipped R13_ATTACHMENT_SHEETS
Excel attachment has all the expected sheets
severity: Block 		The Excel attachment contains exactly the sheets it should - no missing, no extras
no expected-sheets defined for template 'InsufficientHours'
 0 ms
Pass R14_METRICS_RANGE
Time and percentage values look reasonable
severity: Warn 		Time values (productive/unproductive/neutral/no-impact/idle/total) are within realistic bounds and percentages are 0-100
all metrics in 66 row(s) within bounds (1 field(s) checked)
 0 ms
Skipped R15_ATTACHMENT_MATCHES_DASHBOARD
Attachment sheets match the proc data the email was built from
severity: Warn 		Every sheet in the .xlsx attachment has the same number of rows as the proc result the email was built from (no rows dropped or duplicated during rendering).
rule applies only to AssociateSummary (this is InsufficientHours); other templates' attachments aren't built from a per-recipient payload
 0 ms

Stage 2 — Data

Fetched 2026-07-28 02:50:35.328189 · 10012 bytes

Users 66
Users · 66 row(s) × 6 column(s)
ManagerNameUserNameEmployeeIdSpentTimeMinimumHoursRoleName
Seema Balan Aarti Patade 43075 07:17 07:30 User
Seema Balan Abhishekh Yadav 49187 06:40 07:00 User
Seema Balan Adesh Kumar 46712 06:47 08:00 User
Seema Balan Aghav Santosh 45340 06:30 07:00 User
Seema Balan Akanksha Pandey 48199 00:00 07:30 User
Seema Balan Akshata Parab 46435 00:00 07:00 User
Seema Balan Amol Kadam 47719 06:38 07:00 User
Seema Balan Aniket Pawar 48991 06:41 07:00 User
Seema Balan Anil Yadav 46737 07:42 08:00 User
Seema Balan Ansan Sundaram 49333 00:00 07:00 User
Seema Balan Anupam Dey 40510 06:14 07:00 User
Seema Balan Arun Barik 20088 07:11 07:30 User
Seema Balan Ashik Khan 40788 07:20 07:30 User
Seema Balan Ashish Sawant 48132 07:07 08:00 User
Seema Balan Ashraf Jawed 41132 06:25 07:00 User
Seema Balan Atharv Maniyar 49289 06:26 07:00 User
Seema Balan Atul Chaudhari 42003 06:25 07:00 User
Seema Balan Bhibham Shukla 49246 00:00 07:00 User
Seema Balan Dhananjay Hande 48962 06:57 07:00 User
Seema Balan Dheeraj Saklani 46412 07:24 08:00 User
Seema Balan Digvijay Sharma 46364 07:05 07:30 User
Seema Balan Dnyandeep Ruke 46298 06:11 07:00 User
Seema Balan Ekrama Tabrez 43137 06:41 07:00 User
Seema Balan Gunja Chaursiya 47658 06:18 07:00 User
Seema Balan Halli Sandeep 41836 06:32 07:00 User
Seema Balan Harsh Chaudhary 47748 00:00 07:00 User
Seema Balan Harshvardhan Kale 49338 00:00 07:00 User
Seema Balan Ishika Rawat 49311 07:14 07:30 User
Seema Balan Jayesh Bhosale 46901 00:08 07:00 User
Seema Balan Khajan Lohani 46418 07:40 08:00 User
Seema Balan Kiran Patil 47615 06:56 07:00 User
Seema Balan Komal Komal 46367 00:00 07:30 User
Seema Balan Kunal Parmar 46765 06:44 07:00 User
Seema Balan Marghoob Alam 46804 00:00 07:00 User
Seema Balan Minal Bodas 45084 06:35 07:00 User
Seema Balan Mukesh Kumar 40631 06:22 07:00 User
Seema Balan Nikhil Shelke 47780 06:54 07:00 User
Seema Balan Parth More 48457 06:40 07:00 User
Seema Balan Pratigya Yadav 48843 01:30 07:00 User
Seema Balan Rahul Baikar 44882 06:54 07:00 User
Seema Balan Rajur Sharma 44827 06:51 07:00 User
Seema Balan Rakesh Vishwakarma 41609 00:00 07:00 User
Seema Balan Ramesh Chitte 46681 06:58 07:00 User
Seema Balan Rishabha Jha 48556 00:00 07:00 User
Seema Balan Ritesh Kanojiya 49231 06:25 07:00 User
Seema Balan Rohan Palav 49331 04:19 07:00 User
Seema Balan Rohini Govale 46711 03:50 07:00 User
Seema Balan Rohit Bind 48721 07:13 07:30 User
Seema Balan Rutik Wayal 48167 07:04 07:30 User
Seema Balan Sachin Vishwakarma 48767 06:53 07:00 User
Seema Balan Sagar Bangar 45618 06:40 07:00 User
Seema Balan Salman Ahamed 46556 06:50 08:00 User
Seema Balan Seema Chavan 45759 06:53 07:00 User
Seema Balan Shakir Husain 46362 06:19 08:00 User
Seema Balan Shubham Karjavkar 47677 06:59 07:00 User
Seema Balan Siddhesh Gosavi 47469 00:00 07:00 User
Seema Balan Sonu Yadav 48825 00:00 07:00 User
Seema Balan Subhadeep Karak 46732 00:00 07:00 User
Seema Balan Subrato Gauda 49221 06:36 07:00 User
Seema Balan Vaishnavi Vedante 48717 07:11 07:30 User
Seema Balan Veena Khavale 46725 06:07 07:00 User
Seema Balan Vineet Ghogale 49273 03:42 07:00 User
Seema Balan Vinit Verma 49241 00:00 07:30 User
Seema Balan Vishal Yadav 46653 00:32 08:00 User
Seema Balan VishalB Yadav 49085 06:56 07:30 User
Seema Balan Vishnu Suthar 48657 06:47 07:30 User
Meta · non-tabular fields 
{
  "row_counts": {
    "users": 66
  }
}
Raw JSON 
{"users": [{"ManagerName": "Seema Balan", "UserName": "Aarti Patade", "EmployeeId": "43075", "SpentTime": "07:17", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Abhishekh Yadav", "EmployeeId": "49187", "SpentTime": "06:40", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Adesh Kumar", "EmployeeId": "46712", "SpentTime": "06:47", "MinimumHours": "08:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Aghav Santosh", "EmployeeId": "45340", "SpentTime": "06:30", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Akanksha Pandey", "EmployeeId": "48199", "SpentTime": "00:00", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Akshata Parab", "EmployeeId": "46435", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Amol Kadam", "EmployeeId": "47719", "SpentTime": "06:38", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Aniket Pawar", "EmployeeId": "48991", "SpentTime": "06:41", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Anil Yadav", "EmployeeId": "46737", "SpentTime": "07:42", "MinimumHours": "08:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Ansan  Sundaram", "EmployeeId": "49333", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Anupam Dey", "EmployeeId": "40510", "SpentTime": "06:14", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Arun Barik", "EmployeeId": "20088", "SpentTime": "07:11", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Ashik Khan", "EmployeeId": "40788", "SpentTime": "07:20", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Ashish Sawant", "EmployeeId": "48132", "SpentTime": "07:07", "MinimumHours": "08:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Ashraf Jawed", "EmployeeId": "41132", "SpentTime": "06:25", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Atharv Maniyar", "EmployeeId": "49289", "SpentTime": "06:26", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Atul Chaudhari", "EmployeeId": "42003", "SpentTime": "06:25", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Bhibham Shukla", "EmployeeId": "49246", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Dhananjay Hande", "EmployeeId": "48962", "SpentTime": "06:57", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Dheeraj Saklani", "EmployeeId": "46412", "SpentTime": "07:24", "MinimumHours": "08:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Digvijay Sharma", "EmployeeId": "46364", "SpentTime": "07:05", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Dnyandeep Ruke", "EmployeeId": "46298", "SpentTime": "06:11", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Ekrama Tabrez", "EmployeeId": "43137", "SpentTime": "06:41", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Gunja Chaursiya", "EmployeeId": "47658", "SpentTime": "06:18", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Halli Sandeep", "EmployeeId": "41836", "SpentTime": "06:32", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Harsh Chaudhary", "EmployeeId": "47748", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Harshvardhan  Kale", "EmployeeId": "49338", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Ishika   Rawat", "EmployeeId": "49311", "SpentTime": "07:14", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Jayesh Bhosale", "EmployeeId": "46901", "SpentTime": "00:08", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Khajan Lohani", "EmployeeId": "46418", "SpentTime": "07:40", "MinimumHours": "08:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Kiran Patil", "EmployeeId": "47615", "SpentTime": "06:56", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Komal Komal", "EmployeeId": "46367", "SpentTime": "00:00", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Kunal Parmar", "EmployeeId": "46765", "SpentTime": "06:44", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Marghoob Alam", "EmployeeId": "46804", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Minal Bodas", "EmployeeId": "45084", "SpentTime": "06:35", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Mukesh Kumar", "EmployeeId": "40631", "SpentTime": "06:22", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Nikhil Shelke", "EmployeeId": "47780", "SpentTime": "06:54", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Parth More", "EmployeeId": "48457", "SpentTime": "06:40", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Pratigya Yadav", "EmployeeId": "48843", "SpentTime": "01:30", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rahul Baikar", "EmployeeId": "44882", "SpentTime": "06:54", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rajur Sharma", "EmployeeId": "44827", "SpentTime": "06:51", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rakesh Vishwakarma", "EmployeeId": "41609", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Ramesh Chitte", "EmployeeId": "46681", "SpentTime": "06:58", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rishabha Jha", "EmployeeId": "48556", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Ritesh Kanojiya", "EmployeeId": "49231", "SpentTime": "06:25", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rohan   Palav", "EmployeeId": "49331", "SpentTime": "04:19", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rohini Govale", "EmployeeId": "46711", "SpentTime": "03:50", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rohit Bind", "EmployeeId": "48721", "SpentTime": "07:13", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rutik Wayal", "EmployeeId": "48167", "SpentTime": "07:04", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Sachin Vishwakarma", "EmployeeId": "48767", "SpentTime": "06:53", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Sagar Bangar", "EmployeeId": "45618", "SpentTime": "06:40", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Salman Ahamed", "EmployeeId": "46556", "SpentTime": "06:50", "MinimumHours": "08:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Seema Chavan", "EmployeeId": "45759", "SpentTime": "06:53", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Shakir Husain", "EmployeeId": "46362", "SpentTime": "06:19", "MinimumHours": "08:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Shubham Karjavkar", "EmployeeId": "47677", "SpentTime": "06:59", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Siddhesh Gosavi", "EmployeeId": "47469", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Sonu Yadav", "EmployeeId": "48825", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Subhadeep Karak", "EmployeeId": "46732", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Subrato Gauda", "EmployeeId": "49221", "SpentTime": "06:36", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Vaishnavi Vedante", "EmployeeId": "48717", "SpentTime": "07:11", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Veena Khavale", "EmployeeId": "46725", "SpentTime": "06:07", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Vineet Ghogale", "EmployeeId": "49273", "SpentTime": "03:42", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Vinit Verma", "EmployeeId": "49241", "SpentTime": "00:00", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Vishal Yadav", "EmployeeId": "46653", "SpentTime": "00:32", "MinimumHours": "08:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "VishalB Yadav", "EmployeeId": "49085", "SpentTime": "06:56", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Vishnu Suthar", "EmployeeId": "48657", "SpentTime": "06:47", "MinimumHours": "07:30", "RoleName": "User"}], "row_counts": {"users": 66}}

Stage 3 — Rendered

Rendered 2026-07-28 02:50:35.363186 · 22841 bytes

Subject: Minimum Required Working Hours Not Met Jul 27, 2026

Attachments
[{"name": "Minimum Working Hours Report - 2026-07-27.csv", "path": "runs/70d81621-0685-49a1-8807-56c48c1acfd9-attachments/90139A1E-5F0E-4A4D-B85B-7D8953D31A0C-Minimum Working Hours Report - 2026-07-27.csv", "sizeBytes": 2570, "contentType": "text/csv", "kind": "csv"}]
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 name="viewport" content="width=device-width" />
  <link rel="stylesheet" type="text/css" href="bootstrap.min.css">
  <script type="text/javascript" src="css3-mediaqueries.js"></script>
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>First Team Added Milestone</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;
    }

    .text-overflow {
      width: 200px;
      text-overflow: ellipsis;
      overflow: hidden;
      display: inline-block;
      white-space: nowrap;
    }

    @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;
      }
    }

    @media (max-width: 600px) {
      .small_font {
        font-size: 10px;
      }
    }

    @media (max-width: 400px) {
      .small_font {
        font-size: 7px;
      }
    }

    @media (max-width: 425px) {
      .small_font {
        font-size: 10px;
      }
    }

    @media screen and (max-width: 375px) {
      .small_font {
        font-size: 7px;
      }
    }

    @media (min-width: 321px) and (max-width: 374px) {
      .small_font {
        font-size: 9px;
      }
    }

    @media (min-width: 301px) and (max-width: 374px) {
      .ccc {
        padding-top: 4px;
      }
    }

    @media (min-width: 321px) and (max-width: 374px) {
      .youtube {
        height: 10px !important;
        width: 10px !important;
      }
    }

    @media screen and (max-width: 375px) {
      .youtube {
        height: 8px !important;
        width: 8px !important;
      }
    }

    @media screen and (max-width: 300px) {
      .small_font {
        font-size: 7px;
        margin-top: 2px !important;
      }
    }

    @media screen and (max-width: 300px) {
      .youtube {
        width: 5px !important;
        height: 5px !important;
      }
    }

    @media screen and (max-width: 450px) {
      .bbb {
        align-items: center;
        flex-direction: column-reverse;
      }
    }

    @media screen and (max-width: 320px) {
      .youtube {
        width: 8px !important;
        height: 8px !important;
      }
    }

    @media (max-width: 320px) {
      .image {
        font-size: 7px;
      }
    }

    @media only screen and (max-width: 320px) {
      table.youtube {
        width: 7px !important;
        height: 7px !important;
      }
    }
  </style>
</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;">
  <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: 632px; 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:632px;">
          <tbody>
            <tr>
              <td align="center" style=" max-width:632px;">
                <div style="text-align:center;  max-width:632px;">
                  <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>
  <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:#f9f8fa">
          <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"
            style="max-width: 632px;margin: 0 auto;">
            <tbody>
              <tr>
                <table class="o_block" width="100%" cellspacing="0" cellpadding="0" border="0" role="presentation"
                  style="max-width: 632px;">
                  <tbody>
                    <tr style="margin-bottom: 0px;display: flex;background-color:white" class="bbb">
                      <td width="340" class="es-m-p20b esd-container-frame" align="left">
                        <table cellpadding="0" cellspacing="0" width="100%">
                          <tbody>
                            <tr>
                              <td align="left" class="esd-block-text es-p10t"
                                style="background-color:white;padding-left: 10px;"> <br>
                                <p
                                  style="color: #363636;line-height:23px;  margin-left: 29px; font-family: Arial, Helvetica, sans-serif; font-weight:SemiBold; font-size:15px;margin-top: 20px;">
                                  <b> Dear Seema Balan,</b> </p>
                                <p
                                  style="color: #363636; margin-left: 29px; font-size: 15px;line-height:23px;margin-bottom: 0px;">
                                  For the day <b> Jul 27, 2026 </b>, Review the attached Excel sheet to identify
                                  employees who did not meet the minimum Expected hours for the day. </p>
                              </td>
                            </tr>
                          </tbody>
                        </table>
                      </td>
                      <td width="250" align="left" class="esd-container-frame">
                        <table cellpadding="0" cellspacing="0" width="100%">
                          <tbody>
                            <tr>
                              <td align="center" class="esd-block-image es-p30t es-m-p0t" style="font-size: 0px;"><img
                                  class="sideimage" style="margin-top:10%;padding-left: 10px;"
                                  src="https://img.freepik.com/free-vector/lateness-concept-illustration_114360-5950.jpg?w=740&t=st=1690988515~exp=1690989115~hmac=d20dec6ad868daff38a88dc676bfa7e5dffb495ff2048675453e493cd4c34a82"
                                  alt width="175" height="150"></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: 632px;margin-top:0px">
                  <tbody>
                    <tr style="margin-bottom: 0px;background-color:white">
                      <td align="left"
                        style="background-color:white;align-items: center;                                           flex-direction: row;padding-left: 10px;">
                        <br>
                        <p
                          style="color: #363636; margin-left: 29px;margin-right: 95px; font-size: 15px;line-height: 25px;margin-top: -8px;">
                          This may have been due to unforeseen circumstances or any other reasons beyond their control.
                        </p><br>
                        <p
                          style="color: #363636; margin-left: 29px; margin-right: 92px; font-size: 14px;line-height: 25px;margin-top: -3px;">
                          As the manager overseeing the team, we kindly request you to have a discussion with each
                          employee to understand their respective situations better and offer any necessary support or
                          guidance </p>
                        </p><br>
                        <p
                          style="color: #363636; margin-left: 29px; margin-right: 90px; font-size: 14px;line-height: 25px;margin-top: -3px;">
                          Please ensure that appropriate steps are taken to address this issue and help each employee
                          maintain their productivity and adherence to working hours moving forward. </p> <br>
                        <p
                          style="color: #363636; margin-left: 29px; margin-right: 93px; font-size: 14px;line-height: 25px;margin-top: -3px;">
                          If you have any questions or require further information, please do not hesitate to reach out
                          to <a href="https://support.timechamp.io/" target="_blank"
                            style="color: #1E9999;font-size:15px;text-decoration: none;">support@timechamp.io.</a> </p>
                        <br>
                        <p
                          style="color: #363636; margin-left: 29px;  font-size: 14px;line-height: 25px;margin-top: -3px;">
                          Thank you for your attention to this matter. <br><br> <b>Best Regards,</b><br><img
                            src="https://i.stack.imgur.com/SRhpR.png" alt="signature"
                            style="margin-left: -1px;width:100px"> </p> <br>
                      </td>
                    </tr>
                  </tbody>
                </table>
              </tr>
            </tbody>
          </table>
        </td>
      </tr>
    </tbody>
  </table>
  </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="width:632px; max-width:632px;">
          <tbody>
            <tr>
              <td align="center" style="max-width:632px;">
                <div style="text-align:center; max-width:632px;">
                  <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
874F5515-7C5C-4938-8356-634C5536891D
Skip reason
—
Error
—
At
2026-07-28 02:50:35.606189

Events

AtStageLevelMessagemsWorker
2026-07-28 02:50:32.763809 DataFetch Info --- Stage 2 begin --- template=InsufficientHours recipient=seema.balan@kwglobal.com userId=90139A1E-5F0E-4A4D-B85B-7D8953D31A0C thr-14344
2026-07-28 02:50:32.768809 DataFetch Info >>> EXEC USP_EmailComp_InsufficientHoursUsers(@LineManagerId='90139A1E-5F0E-4A4D-B85B-7D8953D31A0C', @Date='2026-07-27') thr-14344
2026-07-28 02:50:35.308187 DataFetch Info <<< USP_EmailComp_InsufficientHoursUsers returned 66 row(s) in 2531ms; cols=[ManagerName,UserName,EmployeeId,SpentTime,MinimumHours,RoleName]; first_row={ManagerName=Seema Balan, UserName=Aarti Patade, EmployeeId=43075, SpentTime=07:17, MinimumHours=07:30, RoleName=User} 2531 thr-14344
2026-07-28 02:50:35.331189 DataFetch Info Wrote EmailComp_Job_Data (10012 bytes); shape=dict, top-level=['users', 'row_counts'] 2558 thr-14344
2026-07-28 02:50:35.352189 Render Info --- Stage 3 begin --- template=InsufficientHours recipient=seema.balan@kwglobal.com thr-14344
2026-07-28 02:50:35.355186 Render Info dbo.HtmlTemplates lookup 'InsufficientHours': OK (14803 chars, batch-cache hit) thr-14344
2026-07-28 02:50:35.367186 Render Info Rendered (22841 bytes, subject='Minimum Required Working Hours Not Met Jul 27, 2026', attachments=1) 14 thr-14344
2026-07-28 02:50:35.518252 QA Info QA passed (15 check(s)) 141 thr-14344
2026-07-28 02:50:35.526279 Dispatch Info >>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='seema.balan@kwglobal.com', @Subject='Minimum Required Working Hours Not Met Jul 27, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='28a68492-0ae1-42c8-ba32-5ae49cd928ed') thr-14344
2026-07-28 02:50:35.540267 Dispatch Info <<< USP_EmailComp_InsertMail returned MailId=874f5515-7c5c-4938-8356-634c5536891d in 10ms (inserted) 10 thr-14344
2026-07-28 02:50:35.598203 Dispatch Info >>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=874f5515-7c5c-4938-8356-634c5536891d, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/5a9675649adb4bf8a4b76136af0651df_90139A1E-5F0E-4A4D-B85B-7D8953D31A0C-Minimum%20Working%20Hours%20Report%20-%202026-07-27.csv') thr-14344
2026-07-28 02:50:35.601190 Dispatch Info <<< USP_EmailComp_InsertMailAttchment OK in 1ms 1 thr-14344
2026-07-28 02:50:35.604197 Dispatch Info Inserted into SentMail. MailId=874f5515-7c5c-4938-8356-634c5536891d thr-14344