Feb Renewals

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 13

Policy No Endorsement No Previous Policy No Finance LOB

'2866202634108604 '000 '2866202634108603000 RETAIL HEALTH


'2856204532668301 '000 '2856204532668300000 OPTIMA SECURE
'2865204041214802 '000 '2865204041214801000 RETAIL HEALTH
'2825100988517602 '000 '2825100988517601000 RETAIL HEALTH
'2828204017831102 '000 '2828204017831101000 RETAIL HEALTH
'2866202105151905 '000 '2866202105151904000 RETAIL HEALTH
'2828204007928902 '000 '2828204007928901000 RETAIL HEALTH
'2866205261385700 '000 ' RETAIL HEALTH
'2865202111962005 '000 '2865202111962004000 RETAIL HEALTH
'2856205025681800 '004 ' OPTIMA SECURE
'2865202648746704 '000 '2865202648746703000 RETAIL HEALTH
'2856204509557301 '000 '2856204509557300000 OPTIMA SECURE
'2828203976194201 '000 '2828203976194200001 RETAIL HEALTH
'2865204528443601 '000 '2865204528443600000 RETAIL HEALTH
'2865202061795505 '000 '2865202061795504000 RETAIL HEALTH
'2828203976194201 '001 '2828203976194200001 RETAIL HEALTH
'2866204465784301 '000 '2866204465784300000 RETAIL HEALTH
'2866204495540901 '000 '2866204495540900000 RETAIL HEALTH
'2856204553106401 '000 '2856204553106400000 OPTIMA SECURE
Product Name Booked Date Endorsement Date Start Date
MY HEALTH MEDISURE SUPER TOP UP FLOATER 12JAN2023 07FEB2023 2/7/2023
MY: OPTIMA SECURE 16FEB2023 27FEB2023 2/27/2023
MY HEALTH MEDISURE SUPER TOP UP INDIVIDUAL 17FEB2023 24FEB2023 2/24/2023
MY:HEALTH SURAKSHA 09FEB2023 19FEB2023 2/19/2023
MY:HEALTH SURAKSHA 15FEB2023 23FEB2023 2/23/2023
MY HEALTH MEDISURE SUPER TOP UP FLOATER 13FEB2023 15FEB2023 2/15/2023
MY:HEALTH SURAKSHA 08FEB2023 10FEB2023 2/10/2023
MY HEALTH MEDISURE SUPER TOP UP FLOATER 24FEB2023 24FEB2023 2/24/2023
MY HEALTH MEDISURE SUPER TOP UP INDIVIDUAL 15FEB2023 23FEB2023 2/23/2023
MY: OPTIMA SECURE 07FEB2023 03FEB2023 11/1/2022
MY HEALTH MEDISURE SUPER TOP UP INDIVIDUAL 05FEB2023 17FEB2023 2/17/2023
MY: OPTIMA SECURE 22FEB2023 21FEB2023 2/21/2023
MY:HEALTH SURAKSHA 22FEB2023 27FEB2023 2/27/2023
MY HEALTH MEDISURE SUPER TOP UP INDIVIDUAL 13FEB2023 21FEB2023 2/21/2023
MY HEALTH MEDISURE SUPER TOP UP INDIVIDUAL 07FEB2023 10FEB2023 2/10/2023
MY:HEALTH SURAKSHA 23FEB2023 27FEB2023 2/27/2023
MY HEALTH MEDISURE SUPER TOP UP FLOATER 12FEB2023 11FEB2023 2/11/2023
MY HEALTH MEDISURE SUPER TOP UP FLOATER 01FEB2023 01FEB2023 2/1/2023
MY: OPTIMA SECURE 14FEB2023 27FEB2023 2/27/2023
End Date Reporting Date Pol Issue Date Agent Code Agent Name
2/6/2024 2/7/2023 1/12/2023 '201890033453 ASMABEE FARHAN SHAIKH
2/26/2024 2/27/2023 2/16/2023 '201890033453 ASMABEE FARHAN SHAIKH
2/23/2024 2/24/2023 2/17/2023 '201890033453 ASMABEE FARHAN SHAIKH
2/18/2024 2/19/2023 2/9/2023 '201890033453 ASMABEE FARHAN SHAIKH
2/22/2024 2/23/2023 2/15/2023 '201890033453 ASMABEE FARHAN SHAIKH
2/14/2024 2/15/2023 2/13/2023 '201890033453 ASMABEE FARHAN SHAIKH
2/9/2024 2/10/2023 2/8/2023 '201890033453 ASMABEE FARHAN SHAIKH
2/23/2024 2/24/2023 2/24/2023 '201890033453 ASMABEE FARHAN SHAIKH
2/22/2024 2/23/2023 2/15/2023 '201890033453 ASMABEE FARHAN SHAIKH
10/31/2023 2/7/2023 11/4/2022 '201890033453 ASMABEE FARHAN SHAIKH
2/16/2024 2/17/2023 2/5/2023 '201890033453 ASMABEE FARHAN SHAIKH
2/20/2024 2/22/2023 2/22/2023 '201890033453 ASMABEE FARHAN SHAIKH
2/26/2025 2/27/2023 2/22/2023 '201890033453 ASMABEE FARHAN SHAIKH
2/20/2024 2/21/2023 2/13/2023 '201890033453 ASMABEE FARHAN SHAIKH
2/9/2024 2/10/2023 2/7/2023 '201890033453 ASMABEE FARHAN SHAIKH
2/26/2025 2/27/2023 2/22/2023 '201890033453 ASMABEE FARHAN SHAIKH
2/10/2024 2/12/2023 2/12/2023 '201890033453 ASMABEE FARHAN SHAIKH
1/31/2024 2/1/2023 2/1/2023 '201890033453 ASMABEE FARHAN SHAIKH
2/26/2024 2/27/2023 2/14/2023 '201890033453 ASMABEE FARHAN SHAIKH
Branch Name State Name Zone Endorsement Type Business Type
MUM - CORPORATE OFFICE MAHARASHTRA WEST Policy Renewal
MUM - CORPORATE OFFICE MAHARASHTRA WEST Policy Renewal
MUM - CORPORATE OFFICE MAHARASHTRA WEST Policy Renewal
MUM - BORIVALI MAHARASHTRA WEST Policy Renewal
MUM - CORPORATE OFFICE MAHARASHTRA WEST Policy Renewal
MUM - BORIVALI MAHARASHTRA WEST Policy Renewal
MUM - CORPORATE OFFICE MAHARASHTRA WEST Policy Renewal
MUM - CORPORATE OFFICE MAHARASHTRA WEST Policy New
MUM - BORIVALI MAHARASHTRA WEST Policy Renewal
MUM - CORPORATE OFFICE MAHARASHTRA WEST Endorsement New
MUM - CORPORATE OFFICE MAHARASHTRA WEST Policy Renewal
MUM - CORPORATE OFFICE MAHARASHTRA WEST Policy Renewal
MUM - CORPORATE OFFICE MAHARASHTRA WEST Policy Renewal
MUM - CORPORATE OFFICE MAHARASHTRA WEST Policy Renewal
MUM - CORPORATE OFFICE MAHARASHTRA WEST Policy Renewal
MUM - CORPORATE OFFICE MAHARASHTRA WEST Endorsement Renewal
MUM - CORPORATE OFFICE MAHARASHTRA WEST Policy Renewal
MUM - CORPORATE OFFICE MAHARASHTRA WEST Policy Renewal
MUM - CORPORATE OFFICE MAHARASHTRA WEST Policy Renewal
Our Share GWP Share % Sum Insured OD TP SSE Name Vertical
6600.00 100 2000000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
34438.00 100 500000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
8982.00 100 2000000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
23827.00 100 500000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
17157.00 100 300000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
2530.00 100 1000000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
11230.00 100 500000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
6050.00 100 2000000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
4400.00 100 1200000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
2198.00 100 0 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
2200.00 100 2000000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
42275.00 100 1000000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
154475.00 100 800000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
1100.00 100 1000000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
2420.00 100 2000000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
.00 100 0 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
4428.00 100 1000000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
3850.00 100 1000000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
7913.00 100 500000 .00 .00 SHEKHAR LAXMAN POOJARY AGENCY-HEALTH
Sub Vertical Zero Dep Flag Emergency Flag LG Code Customer Name
AGENT N N SANTOSH GUJARE
AGENT N N SUBHASH GOVIND BELE
AGENT N N NARSING RAO PURANAM
AGENT N N NILESH VILAS GHATGE
AGENT N N MAHENDRA MADHUKAR SHENDE
AGENT N N JETHANAND ROHRA
AGENT N N DILRAJ KAUR MOHAN SINGH TITTERIA
AGENT N N SHIVANI GAJANAN NIMKAR
AGENT N N MAHENDRA MADHUKAR SHENDE
AGENT N N SADANANDAN P
AGENT N N SIDDHARTHA R SHANBHAG
AGENT N N DILIP KUMAR JENA
AGENT N N SHUBHADA A KALZUNKAR
AGENT N N MEGHA ROHRA
AGENT N N DILRAJ KAUR MOHAN SINGH TITTERIA
AGENT N N SHUBHADA A KALZUNKAR
AGENT N N KAMLESH PRASAD GUPTA
AGENT N N SYED TAYYAB
AGENT N N PRATHAMESH SUBHASH BELE
User ID NCB POL_ENDORSEMENT_REASON POL_POSP_CODE
PORTAL 0
PAYZAPP.AUTORENEWAL 0
PORTAL 0
ASMABEE.POS 0
PORTAL 0
PORTAL 0
ROHIT.DESHMUKH1 0
AMIT.BANKING1 0
PORTAL 0
PORTAL 0 ONLINE NIL ENDORSEMENT FOR MANDATE ID
PORTAL 0
PAYZAPP.AUTORENEWAL 0
ASMABEE.POS 0
PORTAL 0
PAYZAPP.AUTORENEWAL 0
BUDDYCEMBOT 0 ONLINE NIL ENDORSEMENT
ROHIT.KUMAR6 0
PAYZAPP.AUTORENEWAL 0
PAYZAPP.AUTORENEWAL 0
POL_POSP_NAME POL_VC_PAN_CARD POL_MOT_MANUFACTURER_YEAR
POL_MOT_MODEL_NAME POL_MOT_VEH_REGISTRATION_NUM
POL_MOT_MANUFACTURER_NAME Mot Registration Date CHASSIS NUM ENGINE NUM
CUST_EMAIL POL_FUEL_TYPE POL_GROSS_VEH_WT
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
CUST_MOBILE_NUMBER POL_DISCOUNT_FLAG RTO Location POL_EMI_OPTED
9060214444 N
8767854999 N
9491884322 N
9820727925 N
8283814392 N
9820044068 N
9004075401 N
9702761666 N
8283814392 N
9620434883 N YES
8369657229 N
9320451253 N
9820330904 Y
9820044068 N
9004075401 N
9820330904 Y
9584681980 N
9837210810 N
8767854999 N
POL_PAYMENT_INSTRUMENT_NO KYC ID User Id
LH2301003438 'QG9HYFC842 'PORTAL
3522302085447 ' 'PAYZAPP.AUTORENEWAL
LH2302004396 'CKXM6PJE4Z 'PORTAL
HSR1304724390733 '6NKTZX95V6 'ASMABEE.POS
MH2302006877 '2VEEWEKVKC 'PORTAL
LH2302003257 'P33S3LWPER 'PORTAL
90200011634148 'Z46JB5QDG5 'ROHIT.DESHMUKH1
MSF13069558111435 'PITUPJ9CR8 'ASMABEE.POS
LH2302003846 '2VEEWEKVKC 'PORTAL
pay_LBlQRYXzHtQiVy ' 'PORTAL
LH2302001083 'BU3N1X9GQ7 'PORTAL
902000118298701 ' 'PAYZAPP.AUTORENEWAL
042733 ' 'ASMABEE.POS
LH2302003262 ' 'PORTAL
90200011634174 'Z46JB5QDG5 'PAYZAPP.AUTORENEWAL
' 'BUDDYCEMBOT
902000117074823 ' 'ROHIT.KUMAR6
90200011511606 ' 'PAYZAPP.AUTORENEWAL
3522302084148 'W6N3NCDJBB 'PAYZAPP.AUTORENEWAL

You might also like