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
21
2026-10-23 · 13 reminders
Skipped (already sent)
0
same-day dedupe
Failed / No-HRBP
0 / 0
excluded: 8 co · 6 old · 17 inactive
Total emails sent
2231
50 active cases
Emails by stage / task
Task - Final Manager Evaluation1159
Stage 1 - HRBP meeting stage572
Task - PIP Extension Evaluation 160
Stage 5 - HRBP Approval127
Stage 3 - Manager PIP Initiation108
Stage 4 - L2 Approval84
Stage 4 - HRBP Approval21
Per-HRBP load
Deepali Gupta545
Tanya Sanhotra377
Navya Garg262
Smriti Shraddha129
Abhishek Chauhan126
Piyush Kumar94
Vikash Kumar93
Rohith Kumar77
Yukti Saxena72
Adesh Srivastava57
Pratik Shelar50
Manoj Nath48
Manvi Goel42
Ashish Mishra37
Manisha Singh28
Emails per day (last 14)
2026-10-0614
2026-10-0724
2026-10-0827
2026-10-0924
2026-10-1219
2026-10-1321
2026-10-1415
2026-10-1515
2026-10-1615
2026-10-1912
2026-10-2012
2026-10-2112
2026-10-2216
2026-10-2321
Recent runs
DayEnvSentRemindersSkippedFailedMode
2026-10-23production81300live
2026-10-22production7900live
2026-10-21production01200live
2026-10-20production5700live
2026-10-19production3900live
2026-10-16production31200live
2026-10-15production6900live
2026-10-14production01500live
2026-10-13production31800live
2026-10-12production71200live
Active PIP cases (last sent)
EmployeeRequest IDHRBPItems emailed
Nitesh Pratap Singh (PW33945)CF_REQ_788115Ashutosh Jha3
Jaya Gautam (PW32223)CF_REQ_805151Smriti Shraddha2
Jiten Mondal (PW31567)CF_REQ_805887Smriti Shraddha2
Sujay Kumar (PW30306)CF_REQ_804374Navya Garg1
Imran Ali (PW31041)CF_REQ_805915Smriti Shraddha1
Namrita Jaiswal (PW30840)CF_REQ_801249Abhishek Chauhan3
Mohd Afzal Rehman (PW29624)CF_REQ_805147Smriti Shraddha3
Ruby Tomar (PW28915)CF_REQ_805165Smriti Shraddha2
Lav Mevalal Gupta (PW27734)CF_REQ_772233Ishika Sharma5
Gaurav Kashyap (PW25051)CF_REQ_805203Manvi Goel3
Deepak Dwivedi (PW25356)CF_REQ_805917Smriti Shraddha1
Abhinav Kumar (PW15739)CF_REQ_662010Smriti Shraddha1
Arijit Dutta (PW35672)CF_REQ_814097Manvi Goel1
Pushpak Sharma (PW34684)CF_REQ_812611Navya Garg2
Krish Srivastava (PW34962)CF_REQ_815366Navya Garg1
Prajawal Singh (PW33515)CF_REQ_815369Navya Garg1
Rishi Shukla (PW29635)CF_REQ_815026Navya Garg1
Gaurav Kumar Mishra (PW28519)CF_REQ_815365Navya Garg1
Riya Raj (PW27115)CF_REQ_815019Navya Garg1
Saloni Saini (PW23332)CF_REQ_815379Navya Garg1
Ashish . (PW22108)CF_REQ_811223Navya Garg2
Huzaifa . (PW34488)CF_REQ_813203Navya Garg1
Saman Azfar (PW33427)CF_REQ_815025Navya Garg1
Banni Massey (PW25908)CF_REQ_795589Manvi Goel3
Md Tabish Ahmad (PW34176)CF_REQ_811225Navya Garg2
Karuna Varma (PW32603)CF_REQ_811224Navya Garg2
Ashtbhuja Shukla (PW31655)CF_REQ_800717Adesh Srivastava3
Pawan Kumar (PW28192)CF_REQ_771359Smriti Shraddha3
Pratik Pandey (PW6601)CF_REQ_784253Adesh Srivastava4
Shivam Mishra (PW23709)CF_REQ_805167Smriti Shraddha3
Mayur Sharma (PW19800)CF_REQ_803795Rohith Kumar2
Nidhi Kumari (PW32298)CF_REQ_723705Rohith Kumar3
Shubham Sharma (PW26050)CF_REQ_788789Navya Garg4
Naveen B R (PW31963)CF_REQ_807814Manvi Goel2
Savya Dwivedi (PW36493)CF_REQ_804426Manvi Goel2
Vikrant Thakur (PW24515)CF_REQ_809190Smriti Shraddha2
Abhinav Kumar (PW15739)CF_REQ_809191Smriti Shraddha2
Dilashwar . Amin (PW32443)CF_REQ_644553Manisha Singh1
Ajmal N (PW27216)CF_REQ_807773Rohith Kumar1
Khushi Sharma (PW3916)CF_REQ_808387Brijesh Chauhan1
Ravi Yadav (PW34298)CF_REQ_790139Navya Garg4
Chanchal Pal (PW32341)CF_REQ_788788Navya Garg3
Deepak Tiwari (PW26968)CF_REQ_809183Manisha Singh1
Ananya . (PW26753)CF_REQ_805886Manvi Goel3
Nitin Vaishnav (PW3755)CF_REQ_805093Manvi Goel2
Mehak Rai (PW34294)CF_REQ_786350Manisha Singh3
Priya . (PW32169)CF_REQ_793013Smriti Shraddha2
Richa Gupta (PW32357)CF_REQ_788133Ashish Mishra2
Masheera Shaikh (PW31828)CF_REQ_793007Smriti Shraddha2
Shariya Anjum (PW30831)CF_REQ_793015Smriti Shraddha2