Job 9FA71D73-303D-410A-AC83-5C0FF20005D3

Dispatched Back to batch
Batch
7FB1101D-1D3A-4C29-B330-67C4F739FB5D
Template
InsufficientHours
Recipient
seema.balan@kwglobal.com (Seema Balan)
User id
90139A1E-5F0E-4A4D-B85B-7D8953D31A0C
Status
Dispatched
Attempts
3
Claimed by
thr-18580 at 2026-06-04 06:38:10.715778
Created
2026-06-04 06:31:33.517495
Completed
2026-06-04 06:38:10.826778

Attachments — what the end user receives in the email

#FilenameSizeStatusAction
1 90139A1E-5F0E-4A4D-B85B-7D8953D31A0C-Minimum Working Hours Report - 2026-06-03.csv
runs/7fb1101d-1d3a-4c29-b330-67c4f739fb5d-attachments/90139A1E-5F0E-4A4D-B85B-7D8953D31A0C-Minimum Working Hours Report - 2026-06-03.csv
- missing file missing

Stage 4 — QA gate

Pass
15 checks run · 12 pass · 0 warn · 0 fail/error · 483 ms · evaluated 2026-06-04 06:38:10.707788
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)
178 active reportee(s) (1 inactive ignored)
Total In Tree
180
Active Others
178
Inactive Others
1
391 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=9536 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=63
Section counts declared in the data
  • Users: 63
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\7fb1101d-1d3a-4c29-b330-67c4f739fb5d-attachments\90139A1E-5F0E-4A4D-B85B-7D8953D31A0C-Minimum Working Hours Report - 2026-06-03.csv2433
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 63 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-06-04 06:38:10.182770 · 9536 bytes

Users 63
Users · 63 row(s) × 6 column(s)
ManagerNameUserNameEmployeeIdSpentTimeMinimumHoursRoleName
Seema Balan Aarti Patade 43075 00:00 07:30 User
Seema Balan Abhishekh Yadav 49187 06:49 07:00 User
Seema Balan Aditya Hajare 49230 00:00 07:00 User
Seema Balan Afrita Pir 48558 06:46 07:00 User
Seema Balan Ajay Pal 47029 06:52 07:00 User
Seema Balan Akanksha Pandey 48199 06:52 07:30 User
Seema Balan Akash Bhosle 45127 06:50 07:00 User
Seema Balan Akshata Parab 46435 00:00 07:00 User
Seema Balan Amruta Patil1 48645 06:17 07:00 User
Seema Balan Anil Lauvot 46706 06:54 07:00 User
Seema Balan Anil Yadav 46737 07:45 08:00 User
Seema Balan Anuj Keskar 49117 06:58 07:00 User
Seema Balan Anuj Singh 43006 06:59 07:00 User
Seema Balan Aparna Shivde 20087 04:30 07:30 User
Seema Balan Ashik Khan 40788 00:00 07:30 User
Seema Balan Ashish Sawant 48132 06:58 08:00 User
Seema Balan Ashraf Jawed 41132 00:00 07:00 User
Seema Balan Dhananjay Hande 48962 06:47 07:00 User
Seema Balan Dipankar Mane 49228 00:00 07:00 User
Seema Balan Gunja Chaursiya 47658 06:24 07:00 User
Seema Balan Harsh Chaudhary 47748 06:27 07:00 User
Seema Balan Harsh Patil 47673 06:35 07:00 User
Seema Balan Imteyaz Ahmad 40706 07:10 07:30 User
Seema Balan Jaspreet Saini 48386 05:01 07:00 User
Seema Balan Jayesh Bhosale 46901 05:49 07:00 User
Seema Balan Kiran Patil 47615 00:00 07:00 User
Seema Balan Kunal Parmar 46765 06:51 07:00 User
Seema Balan Mayur Yadav 49004 00:00 07:00 User
Seema Balan Minal Bodas 45084 00:00 07:00 User
Seema Balan Navnath Kharat 48699 00:00 07:00 User
Seema Balan Parth More 48457 06:21 07:00 User
Seema Balan Pooja Shirwadkar 46868 00:00 07:00 User
Seema Balan Rahul Baikar 44882 06:49 07:00 User
Seema Balan Rajeev Kumar1 46415 00:00 08:00 User
Seema Balan Rajesh Kumar 45851 06:56 07:00 User
Seema Balan Rakesh Verma 40621 06:52 07:00 User
Seema Balan Ramashish Goud 48709 06:24 07:30 User
Seema Balan Reshmi Nair 40262 05:07 07:30 User
Seema Balan Rishabha Jha 48556 06:40 07:00 User
Seema Balan Ritesh Kanojiya 49231 00:00 07:00 User
Seema Balan Rohini Govale 46711 06:43 07:00 User
Seema Balan Rohit Bind 48721 00:00 07:30 User
Seema Balan Rohit Maurya 49111 06:28 07:00 User
Seema Balan Rohit Nayak 41302 00:00 07:00 User
Seema Balan Rutik Wayal 48167 00:00 07:30 User
Seema Balan Sakshi Chavan 48688 06:18 07:00 User
Seema Balan Saloni Yadav 47659 00:00 07:00 User
Seema Balan Sanchit Dalvi 49148 00:00 07:00 User
Seema Balan Sanuj Upadhyay 48803 06:10 07:00 User
Seema Balan Saturam Patil 44947 06:54 07:00 User
Seema Balan Shreyas Acharya 47698 06:55 07:00 User
Seema Balan Siddhesh Gosavi 47469 06:52 07:00 User
Seema Balan Snehal Pendurkar 45901 06:56 07:00 User
Seema Balan Somesh Kelshikar 48769 06:56 07:00 User
Seema Balan Subrato Gauda 49221 00:00 07:00 User
Seema Balan Suhas Pawar 46705 00:00 07:00 User
Seema Balan Tushar Patil 49086 07:23 07:30 User
Seema Balan Vaishnavi Vedante 48717 06:37 07:30 User
Seema Balan Veena Khavale 46725 00:00 07:00 User
Seema Balan Vikas Yadav 47845 06:40 07:00 User
Seema Balan Vinayak Bhelekar 44034 00:00 07:00 User
Seema Balan Vishnu Suthar 48657 05:59 07:30 User
Seema Balan Yaswant Kashyap 46651 05:59 07:30 User
Meta · non-tabular fields
{
  "row_counts": {
    "users": 63
  }
}
Raw JSON
{"users": [{"ManagerName": "Seema Balan", "UserName": "Aarti Patade", "EmployeeId": "43075", "SpentTime": "00:00", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Abhishekh Yadav", "EmployeeId": "49187", "SpentTime": "06:49", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Aditya Hajare", "EmployeeId": "49230", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Afrita Pir", "EmployeeId": "48558", "SpentTime": "06:46", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Ajay Pal", "EmployeeId": "47029", "SpentTime": "06:52", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Akanksha Pandey", "EmployeeId": "48199", "SpentTime": "06:52", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Akash Bhosle", "EmployeeId": "45127", "SpentTime": "06:50", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Akshata Parab", "EmployeeId": "46435", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Amruta Patil1", "EmployeeId": "48645", "SpentTime": "06:17", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Anil Lauvot", "EmployeeId": "46706", "SpentTime": "06:54", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Anil Yadav", "EmployeeId": "46737", "SpentTime": "07:45", "MinimumHours": "08:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Anuj Keskar", "EmployeeId": "49117", "SpentTime": "06:58", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Anuj Singh", "EmployeeId": "43006", "SpentTime": "06:59", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Aparna Shivde", "EmployeeId": "20087", "SpentTime": "04:30", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Ashik Khan", "EmployeeId": "40788", "SpentTime": "00:00", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Ashish Sawant", "EmployeeId": "48132", "SpentTime": "06:58", "MinimumHours": "08:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Ashraf Jawed", "EmployeeId": "41132", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Dhananjay Hande", "EmployeeId": "48962", "SpentTime": "06:47", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Dipankar Mane", "EmployeeId": "49228", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Gunja Chaursiya", "EmployeeId": "47658", "SpentTime": "06:24", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Harsh Chaudhary", "EmployeeId": "47748", "SpentTime": "06:27", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Harsh Patil", "EmployeeId": "47673", "SpentTime": "06:35", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Imteyaz Ahmad", "EmployeeId": "40706", "SpentTime": "07:10", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Jaspreet Saini", "EmployeeId": "48386", "SpentTime": "05:01", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Jayesh Bhosale", "EmployeeId": "46901", "SpentTime": "05:49", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Kiran Patil", "EmployeeId": "47615", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Kunal Parmar", "EmployeeId": "46765", "SpentTime": "06:51", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Mayur Yadav", "EmployeeId": "49004", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Minal Bodas", "EmployeeId": "45084", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Navnath Kharat", "EmployeeId": "48699", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Parth More", "EmployeeId": "48457", "SpentTime": "06:21", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Pooja Shirwadkar", "EmployeeId": "46868", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rahul Baikar", "EmployeeId": "44882", "SpentTime": "06:49", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rajeev Kumar1", "EmployeeId": "46415", "SpentTime": "00:00", "MinimumHours": "08:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rajesh Kumar", "EmployeeId": "45851", "SpentTime": "06:56", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rakesh Verma", "EmployeeId": "40621", "SpentTime": "06:52", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Ramashish Goud", "EmployeeId": "48709", "SpentTime": "06:24", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Reshmi Nair", "EmployeeId": "40262", "SpentTime": "05:07", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rishabha Jha", "EmployeeId": "48556", "SpentTime": "06:40", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Ritesh Kanojiya", "EmployeeId": "49231", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rohini Govale", "EmployeeId": "46711", "SpentTime": "06:43", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rohit Bind", "EmployeeId": "48721", "SpentTime": "00:00", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rohit Maurya", "EmployeeId": "49111", "SpentTime": "06:28", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rohit Nayak", "EmployeeId": "41302", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Rutik Wayal", "EmployeeId": "48167", "SpentTime": "00:00", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Sakshi Chavan", "EmployeeId": "48688", "SpentTime": "06:18", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Saloni Yadav", "EmployeeId": "47659", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Sanchit Dalvi", "EmployeeId": "49148", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Sanuj Upadhyay", "EmployeeId": "48803", "SpentTime": "06:10", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Saturam Patil", "EmployeeId": "44947", "SpentTime": "06:54", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Shreyas Acharya", "EmployeeId": "47698", "SpentTime": "06:55", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Siddhesh Gosavi", "EmployeeId": "47469", "SpentTime": "06:52", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Snehal Pendurkar", "EmployeeId": "45901", "SpentTime": "06:56", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Somesh Kelshikar", "EmployeeId": "48769", "SpentTime": "06:56", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Subrato Gauda", "EmployeeId": "49221", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Suhas Pawar", "EmployeeId": "46705", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Tushar Patil", "EmployeeId": "49086", "SpentTime": "07:23", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Vaishnavi Vedante", "EmployeeId": "48717", "SpentTime": "06:37", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Veena Khavale", "EmployeeId": "46725", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Vikas Yadav", "EmployeeId": "47845", "SpentTime": "06:40", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Vinayak Bhelekar", "EmployeeId": "44034", "SpentTime": "00:00", "MinimumHours": "07:00", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Vishnu Suthar", "EmployeeId": "48657", "SpentTime": "05:59", "MinimumHours": "07:30", "RoleName": "User"}, {"ManagerName": "Seema Balan", "UserName": "Yaswant Kashyap", "EmployeeId": "46651", "SpentTime": "05:59", "MinimumHours": "07:30", "RoleName": "User"}], "row_counts": {"users": 63}}

Stage 3 — Rendered

Rendered 2026-06-04 06:38:10.208771 · 22841 bytes

Subject: Minimum Required Working Hours Not Met Jun 03, 2026

Attachments
[{"name": "Minimum Working Hours Report - 2026-06-03.csv", "path": "runs/7fb1101d-1d3a-4c29-b330-67c4f739fb5d-attachments/90139A1E-5F0E-4A4D-B85B-7D8953D31A0C-Minimum Working Hours Report - 2026-06-03.csv", "sizeBytes": 2433, "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> Jun 03, 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
353C8147-1754-432F-B877-359886531EC1
Skip reason
Error
At
2026-06-04 06:38:10.824782

Events

AtStageLevelMessagemsWorker
2026-06-04 06:38:08.214747 DataFetch Info --- Stage 2 begin --- template=InsufficientHours recipient=seema.balan@kwglobal.com userId=90139A1E-5F0E-4A4D-B85B-7D8953D31A0C thr-18580
2026-06-04 06:38:08.218743 DataFetch Info >>> EXEC USP_EmailComp_InsufficientHoursUsers(@LineManagerId='90139A1E-5F0E-4A4D-B85B-7D8953D31A0C', @Date='2026-06-03') thr-18580
2026-06-04 06:38:10.173771 DataFetch Info <<< USP_EmailComp_InsufficientHoursUsers returned 63 row(s) in 1952ms; cols=[ManagerName,UserName,EmployeeId,SpentTime,MinimumHours,RoleName]; first_row={ManagerName=Seema Balan, UserName=Aarti Patade, EmployeeId=43075, SpentTime=00:00, MinimumHours=07:30, RoleName=User} 1952 thr-18580
2026-06-04 06:38:10.184771 DataFetch Info Wrote EmailComp_Job_Data (9536 bytes); shape=dict, top-level=['users', 'row_counts'] 1964 thr-18580
2026-06-04 06:38:10.192770 Render Info --- Stage 3 begin --- template=InsufficientHours recipient=seema.balan@kwglobal.com thr-18580
2026-06-04 06:38:10.194770 Render Info dbo.HtmlTemplates lookup 'InsufficientHours': OK (14803 chars, batch-cache hit) thr-18580
2026-06-04 06:38:10.211772 Render Info Rendered (22841 bytes, subject='Minimum Required Working Hours Not Met Jun 03, 2026', attachments=1) 18 thr-18580
2026-06-04 06:38:10.709779 QA Info QA passed (15 check(s)) 483 thr-18580
2026-06-04 06:38:10.720779 Dispatch Info >>> EXEC USP_EmailComp_InsertMail(@From='anuradha.bhardwaj@kwglobal.com', @To='seema.balan@kwglobal.com', @Subject='Minimum Required Working Hours Not Met Jun 03, 2026...', @AttachmentCount=1, @SiteAddress='kwglobal', @TrackingId='e3b4b0f1-fd88-42f6-99af-6a2787fe96ba') thr-18580
2026-06-04 06:38:10.733776 Dispatch Info <<< USP_EmailComp_InsertMail returned MailId=353c8147-1754-432f-b877-359886531ec1 in 9ms (inserted) 9 thr-18580
2026-06-04 06:38:10.800788 Dispatch Info >>> EXEC USP_EmailComp_InsertMailAttchment(@MailId=353c8147-1754-432f-b877-359886531ec1, @AttacchmentPath='https://timechampv2storage.blob.core.windows.net/6e919cfe-74dd-4ebc-8665-3c0d44866649/MailAttachments/7b48b147f1ad459186e4613b1d55e039_90139A1E-5F0E-4A4D-B85B-7D8953D31A0C-Minimum%20Working%20Hours%20Report%20-%202026-06-03.csv') thr-18580
2026-06-04 06:38:10.816778 Dispatch Info <<< USP_EmailComp_InsertMailAttchment OK in 11ms 11 thr-18580
2026-06-04 06:38:10.819784 Dispatch Info Inserted into SentMail. MailId=353c8147-1754-432f-b877-359886531ec1 thr-18580