PIP Automation

PRODUCTIONDB: pip_prod

Emails go to the employee's HRBP for each pending "Yes" stage, on one chain per PIP, with daily reminders until done.

Last run
16
2026-08-26 · 14 reminders
Skipped (already sent)
0
same-day dedupe
Failed / No-HRBP
0 / 2
excluded: 6 co · 4 old · 0 inactive
Total emails sent
1354
50 active cases
Emails by stage / task
Task - Final Manager Evaluation687
Stage 1 - HRBP meeting stage356
Task - PIP Extension Evaluation 128
Stage 5 - HRBP Approval66
Stage 3 - Manager PIP Initiation59
Stage 4 - L2 Approval58
Per-HRBP load
Deepali Gupta470
Tanya Sanhotra287
Navya Garg161
Piyush Kumar94
Vikash Kumar81
Yukti Saxena68
Pratik Shelar44
Shivam Mishra25
Brijesh Chauhan24
Manoj Nath13
Shivani Umbarkar12
Smriti Shraddha10
Ashutosh Kumar Jha10
Adesh Srivastava9
Fiza Alam8
Emails per day (last 14)
2026-08-0731
2026-08-1026
2026-08-1126
2026-08-1226
2026-08-1330
2026-08-1425
2026-08-1730
2026-08-1828
2026-08-1927
2026-08-2027
2026-08-2127
2026-08-2421
2026-08-2517
2026-08-2616
Recent runs
DayEnvSentRemindersSkippedFailedMode
2026-08-26production21400live
2026-08-25production31400live
2026-08-24production31800live
2026-08-21production72000live
2026-08-20production72000live
2026-08-19production42300live
2026-08-18production00270dry-run
2026-08-18production22600live
2026-08-17production72300live
2026-08-14production02500live
Active PIP cases (last sent)
EmployeeRequest IDHRBPItems emailed
Dilashwar . Amin (PW32443)CF_REQ_644553Yukti Saxena1
Dheerendra Kumar Patel (PW32493)CF_REQ_727430Navya Garg2
Mandira Dhanaji Gandhure (PW29265)CF_REQ_711623Manoj Nath3
Rashi Jayantilal Kitawat (PW27929)CF_REQ_723703Tanya Sanhotra1
Shivanshu Singh (PW22092)CF_REQ_728423Adesh Srivastava4
Rahul Kumar (PW21259)CF_REQ_719991Shivani Umbarkar3
Pritee Ananta Jagtap (PW21558)CF_REQ_681958Pratik Shelar1
Kunal Vilasrao Khodke (PW18621)CF_REQ_665363Piyush Kumar1
Abhinav Kumar (PW15739)CF_REQ_662010Deepali Gupta1
Vishnu Kant Ojha (PW8839)CF_REQ_677189Piyush Kumar1
Saman Azfar (PW33427)CF_REQ_738680Deepali Gupta1
MD Aftab Alam (PW28441)CF_REQ_738678Deepali Gupta1
Arpita Das (PW26059)CF_REQ_738682Deepali Gupta1
Mahanth S (PW24981)CF_REQ_726802Tanya Sanhotra3
Bushra Nazir (PW18867)CF_REQ_738677Deepali Gupta1
Chansi Chouhan (PW14815)CF_REQ_762212Deepali Gupta1
Sangeeta Parihar (PW12282)CF_REQ_738676Deepali Gupta1
Rakshita Punia (PW1932)CF_REQ_761713Ashutosh Kumar Jha3
Jiya Singh Raghav (PW32088)CF_REQ_725971Tanya Sanhotra3
Umashankar Veerapoor (PW23096)CF_REQ_723709Tanya Sanhotra3
Swati Prabhat Singh (PW21628)CF_REQ_662011Deepali Gupta1
Rohan Rajendra Lalwani (PW14630)CF_REQ_727514Navya Garg1
Sanwik Sagar (PW19796)CF_REQ_763903Mohita Palariya1
Amit Kumar Gupta (PW15285)CF_REQ_761325Ashutosh Kumar Jha4
Priya Sharma (PW31761)CF_REQ_727496Manisha Singh2
Ankit . (PW34021)CF_REQ_762202Ishika Sharma1
Tejas Vilasrao Umak (PW31216)CF_REQ_741649Pratik Shelar1
Suresh Kumar (PW30891)CF_REQ_726855Brijesh Chauhan1
Navya N (PW30572)CF_REQ_741686Tanya Sanhotra1
Manas Ranjan Lenka (PW14438)CF_REQ_741667Navya Garg2
Manish Kumar (PW28346)CF_REQ_702652Vikash Kumar2
Rupali Devgan Sharma (PW23554)CF_REQ_723702Tanya Sanhotra1
Ashutosh Tiwari (PW15944)CF_REQ_695463Tanya Sanhotra3
Satya Deep (PW32161)CF_REQ_741669Swati Jindal2
Atul Mishra (PW15405)CF_REQ_761682Navya Garg1
Mohd Yasir (PW31565)CF_REQ_716583Navya Garg3
Shivansh Mehrotra (PW31603)CF_REQ_689422Vikash Kumar2
Bikram Debnath (PW28484)CF_REQ_710309Fiza Alam4
Vikash Kumar (PW27077)CF_REQ_670592Navya Garg1
Same Ullah Bhat (PW22959)CF_REQ_711782Navya Garg3
Armaan Hussain (PW31530)CF_REQ_693530Tanya Sanhotra4
Nishant Soni (PW30055)CF_REQ_691511Tanya Sanhotra4
Vidhya Yadav (PW29446)CF_REQ_725994Navya Garg1
Shshank Shekhar Chandan (PW14507)CF_REQ_714122Navya Garg4
SANJU YADAV (PW8095)CF_REQ_725991Navya Garg1
Sarika Gupta (PW29870)CF_REQ_696120Tanya Sanhotra4
Kashish Sikka (PW27990)CF_REQ_715924Smriti Shraddha2
Shraddha Jain (PW24355)CF_REQ_696596Vikash Kumar4
Om Prakash Saini (PW7771)CF_REQ_725993Navya Garg1
Richa Sharma (PW29117)CF_REQ_694846Tanya Sanhotra2