Project

General

Profile

Actions
Copy link

Support #837

closed

CHUBB (ABA) Rate changes

Added by Greg Krabbenhoft about 1 month ago. Updated 17 days ago.

Status:
Closed
Priority:
High
Assignee:
George Howington
Start date:
03/28/2025
Due date:
04/04/2025
% Done:

0%

Estimated time:

Description

Attached is the new rater spreadsheet for CHUBB. There are rate changes, along with limit changes and one programming change. If you have questions on how the spreadsheet is laid out, please let me know.

The programming change will be for rater results. Currently, if a customer indicates they only have liability insurance, they only receive liability coverage in the quote results. With this change that is no longer valid for CHUBB, we should return liability only and full coverage options.

Files

Download all files
Rater Requirement - ABA-CHUBB - Cotizador 20250315 Propuesta.xlsx (237 KB) Rater Requirement - ABA-CHUBB - Cotizador 20250315 Propuesta.xlsx Greg Krabbenhoft, 03/28/2025 02:35 PM
update_sql_query.txt (38.7 KB) update_sql_query.txt Leo Esaki, 04/04/2025 02:49 PM
509.0 - Rater Requirement - ABA-CHUBB - Cotizador 20250201 Propuesta v.xlsx (227 KB) 509.0 - Rater Requirement - ABA-CHUBB - Cotizador 20250201 Propuesta v.xlsx Greg Krabbenhoft, 04/08/2025 11:54 AM
clipboard-202504080812-hac37.png (198 KB) clipboard-202504080812-hac37.png George Howington, 04/08/2025 03:12 PM
Actions
Copy link
 #1

Updated by Leo Esaki 25 days ago

Hi George.

Please test this query and let me know if you find sth wrong. And Greg wants to prepare staging server with this update.

---------------------------SQL Queries------------------------------

UPDATE limits
SET
boat_maxval = 35000,
boat_trailer_maxval = 100000,
travel_trail_maxval = 100000,
pd_maxval = 100000,
combo_maxval = 200000,
rv_maxval = 200000,
motorcycle_maxval = 50000,
trailer_combo_maxval = 100000,
atv_maxval = 35000
WHERE underwriter_id IN (60, 61);

Thanks,
Leo

Actions
Copy link
 #2

Updated by George Howington 25 days ago

  • Status changed from QA to In Progress
  • Assignee changed from George Howington to Leo Esaki

Hi Leo,

Yes, these updated limits look good and pass QA. Are you ready for me to test all the rate updates? Please include the MR.

Thanks,
--George

Actions
Copy link
 #3

Updated by Leo Esaki 25 days ago

  • Status changed from In Progress to QA
  • Assignee changed from Leo Esaki to George Howington

Hi George.

Here is MR. Please take a look.

https://gitlab.com/nfp-cross-border/polmaker-v3/-/merge_requests/389

Thanks,
Leo

Actions
Copy link
 #4

Updated by George Howington 25 days ago

UPDATE limits
SET
boat_maxval = 35000,
boat_trailer_maxval = 100000,
travel_trail_maxval = 100000,
pd_maxval = 100000,
combo_maxval = 200000,
rv_maxval = 200000,
motorcycle_maxval = 50000,
trailer_combo_maxval = 100000,
atv_maxval = 35000
WHERE underwriter_id IN (3,4,71);

Actions
Copy link
 #5

Updated by George Howington 25 days ago

On hold until Denny and Nate's review is completed.

Actions
Copy link
 #7

Updated by Greg Krabbenhoft 21 days ago

CHUBB has provided another spreadsheet to review. Please look at the term tab and program the discounts indicated in the new spreadsheet as attached.

Actions
Copy link
 #9

Updated by Leo Esaki 21 days ago

  • Status changed from In Progress to QA
  • Assignee changed from Leo Esaki to George Howington

Hi George.

I updated the codebase according to the change of new rater requirement. Please take a look.

https://gitlab.com/nfp-cross-border/polmaker-v3/-/merge_requests/389

Thanks,
Leo

Actions
Copy link
 #10

Updated by George Howington 17 days ago

  • Status changed from QA to Closed

Merged with production. Closing

Actions
Copy link

Also available in: Atom PDF