[NF-5533] Superheat - Billing Summary Report - Premium is not calculating correctly - Workterra Jira

Details

Type: Bug
Status: Closed
Priority: Medium
Resolution: Bug Fixed
Affects Version/s: None
Fix Version/s: None
Component/s: UI Refresh
Labels:
- Sprint_41

Environment:

Production
Bug Type:
Functional
Bug Severity:
Critical
Module:
BenAdmin - Report
Reported by:
Client
Company:
All Clients/Multiple Clients
Item State:
Stage QA - Production Deployment on Hold
Sprint:
WT Sprint 41

Dev Estimates:
35
QA Estimates:
4
Code Reviewed By:

Prasanna Karlekar
Development Approval:
Yes

Description

Please review the Billing Summary Report in Production - Client Name - Superheat FGH. This needs to be corrected as soon as possible, this is affecting the client and they as many other clients use this report to submit their volume and counts to their Life carriers to pay their premiums.

The following plan premiums are not calculating correctly:
Plan 1:
Basic Life - Basic Life - Lincoln Financial Group
Rate Name: 2016 - 2018 Basic Life-Basic Life
Report shows $3,134.56, but when you manually calculate it the premium comes out to be $3,134.05 (volume*rate/coverage divisor) (16072050.00*0.1950/1000). There is a difference of $0.51.

Plan 2:
Plan: Basic AD&D-Basic AD&D-Lincoln Financial Group
Rate Name: 2016 - 2018 Basic AD&D-Basic AD&D
Report shows $401.33, but when you manually calculate it the premium comes out to be $400.83 (volume*rate/coverage divisor) (16033050.00*0.0250/1000). There is a difference of $0.50.

Plan 3:
Plan: Voluntary Child Life-Voluntary Child Life-Lincoln Financial Group
Rate Name: 2016 - 2018 Vol Child life-Child Life
Report shows $75.62, but when you manually calculate it the premium comes out to be $75.73 (volume*rate/coverage divisor) (380000.00*0.1993/1000). There is a difference of $0.11.

This is also similar to WT 9738.

Deborah Mascot
lisa davison

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

1.png
74 kB
19/Dec/17 06:45 AM
2.png
72 kB
19/Dec/17 06:45 AM
3.png
57 kB
19/Dec/17 06:45 AM
4.png
97 kB
19/Dec/17 06:45 AM
Basic Life.png
36 kB
27/Dec/17 11:58 AM
BillingReportServerError.txt
3 kB
20/Dec/17 08:35 AM
BillingReportServerError (a8f1a507-2238-45d4-aaf3-e3f9e544869c).txt
3 kB
20/Dec/17 08:36 AM
BillingSummary_1.jpg
263 kB
20/Dec/17 08:34 AM
BillingSummary_2.jpg
208 kB
20/Dec/17 08:34 AM
BillingSummaryReport.xls
12 kB
19/Dec/17 06:45 AM
FW 1211 Sprint - Development Approval.msg
51 kB
19/Dec/17 06:45 AM
NF-5533_1.png
45 kB
13/Mar/18 07:07 AM
NF-5533_2.png
43 kB
13/Mar/18 07:07 AM
optional child life.png
63 kB
27/Dec/17 11:58 AM
Superheat - Billing Summary Report - Calc is not correct - Basic Life_Basic ADD.PNG
113 kB
19/Dec/17 06:45 AM
Superheat - Billing Summary Report - Calc is not correct - Child Life.PNG
57 kB
19/Dec/17 06:45 AM
WT-11470_Discrepancy.xlsx
21 kB
19/Dec/17 06:45 AM
WT-11470.jpg
256 kB
19/Dec/17 06:45 AM
WT-11470 - Superheat - Billing Summary Report_Test Scenarios.xls
10 kB
19/Dec/17 06:45 AM

Issue Links

causes

WT-12096 Functional | Any company |ACA |Measurement stability period | An error is occurring during report process

Production Complete

clones

WT-11470 Superheat - Billing Summary Report - Premium is not calculating correctly

Closed

is caused by

NF-5395 Southern Regional>"From Date" and "To Date" validation messages are not similar

Closed

Activity

Ascending order - Click to sort in descending order

Parmeshwar Jumbad (Inactive) created issue - 19/Dec/17 06:45 AM

Parmeshwar Jumbad (Inactive) made changes - 19/Dec/17 06:45 AM

Field	Original Value	New Value
Link		This issue clones ~~WT-11470~~ [ ~~WT-11470~~ ]

Parmeshwar Jumbad (Inactive) made changes - 19/Dec/17 06:45 AM

Link

This issue causes ~~WT-12096~~ [ ~~WT-12096~~ ]

Parmeshwar Jumbad (Inactive) made changes - 19/Dec/17 06:46 AM

Component/s		UI Refresh [ 10902 ]
Component/s	BenAdmin [ 10000 ]
Environment_Old	Production [ 10005 ]
Key	~~WT-12815~~	~~NF-5533~~
Project	WORKTERRA [ 10000 ]	New Features 2017 [ 11000 ]

Parmeshwar Jumbad (Inactive) made changes - 19/Dec/17 06:46 AM

Assignee

Sanjana Jadhav [ sanjana.jadhav ]

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Hide

Permalink

Parmeshwar Jumbad (Inactive) added a comment - 19/Dec/17 06:47 AM

For all details please refer ~~WT-11470~~.

Show

Parmeshwar Jumbad (Inactive) added a comment - 19/Dec/17 06:47 AM For all details please refer WT-11470 .

Parmeshwar Jumbad (Inactive) made changes - 19/Dec/17 06:47 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)

Parmeshwar Jumbad (Inactive) made changes - 19/Dec/17 06:47 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Parmeshwar Jumbad (Inactive) made changes - 19/Dec/17 06:47 AM

Summary

CLONE - Superheat - Billing Summary Report - Premium is not calculating correctly

Superheat - Billing Summary Report - Premium is not calculating correctly

Khandu Kshirsagar (Inactive) made changes - 19/Dec/17 10:08 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parmeshwar Jumbad (Inactive) made changes - 19/Dec/17 11:59 AM

Assignee

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Sachin Hingole [ sachin.hingole ]

Permalink

Parmeshwar Jumbad (Inactive) logged work - 19/Dec/17 03:27 PM

Time Spent:

0.75h

JIRA creation and Update
Code check-in into UI refresh LB and trunk branch

Parmeshwar Jumbad (Inactive) made changes - 19/Dec/17 03:28 PM

Remaining Estimate	35h [ 126000 ]	34.25h [ 123300 ]
Time Spent		0.75h [ 2700 ]
Worklog Id		96997 [ 96997 ]

Sachin Hingole (Inactive) made changes - 20/Dec/17 07:17 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Sachin Hingole (Inactive) made changes - 20/Dec/17 07:18 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Priya Dhamande (Inactive) made changes - 20/Dec/17 08:34 AM

Attachment

BillingSummary_2.jpg [ 70462 ]

Priya Dhamande (Inactive) made changes - 20/Dec/17 08:34 AM

Attachment

BillingSummary_1.jpg [ 70463 ]

Priya Dhamande (Inactive) made changes - 20/Dec/17 08:35 AM

Attachment

BillingReportServerError.txt [ 70464 ]

Permalink

Priya Dhamande (Inactive) logged work - 20/Dec/17 08:36 AM

Time Spent:

2h

Codemap testing

Priya Dhamande (Inactive) made changes - 20/Dec/17 08:36 AM

Attachment

BillingReportServerError (a8f1a507-2238-45d4-aaf3-e3f9e544869c).txt [ 70465 ]

Hide

Permalink

Priya Dhamande (Inactive) added a comment - 20/Dec/17 08:36 AM

Environment: Codemap
Company: For QA Town of Carry, For QA Kindercare ASML
Reports: Billing Details report and Billing Summary report

The bug is tested for attached scenarios. Screen capture for the same is attached with jira.

During testing last test case for Billing report is failed. As Billing report when run is giving server error.

Error log for the same is attached with jira.
Unable to embed resource: BillingReportServerError.txt of type text/plain

So, re-opening the jira for the same.

Sachin Hingole Hrishikesh Deshpande

Show

Priya Dhamande (Inactive) added a comment - 20/Dec/17 08:36 AM Environment: Codemap Company: For QA Town of Carry, For QA Kindercare ASML Reports: Billing Details report and Billing Summary report The bug is tested for attached scenarios. Screen capture for the same is attached with jira. During testing last test case for Billing report is failed. As Billing report when run is giving server error. Error log for the same is attached with jira. Unable to embed resource: BillingReportServerError.txt of type text/plain So, re-opening the jira for the same. Sachin Hingole Hrishikesh Deshpande

Priya Dhamande (Inactive) made changes - 20/Dec/17 08:36 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Priya Dhamande (Inactive) made changes - 20/Dec/17 08:36 AM

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

Priya Dhamande (Inactive) made changes - 20/Dec/17 08:36 AM

Assignee

Sachin Hingole [ sachin.hingole ]

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Priya Dhamande (Inactive) made changes - 20/Dec/17 08:37 AM

Remaining Estimate	34.25h [ 123300 ]	32.25h [ 116100 ]
Time Spent	0.75h [ 2700 ]	2.75h [ 9900 ]
Worklog Id		97089 [ 97089 ]

Hide

Permalink

Parmeshwar Jumbad (Inactive) added a comment - 20/Dec/17 09:03 AM - edited

Hi Priya Dhamande,

The report throwing an exception due to ~~NF-5395~~ check is pending for localization files.

CC: Prasanna Karlekar Gaurav Sodani

Show

Parmeshwar Jumbad (Inactive) added a comment - 20/Dec/17 09:03 AM - edited Hi Priya Dhamande , The report throwing an exception due to NF-5395 check is pending for localization files. CC: Prasanna Karlekar Gaurav Sodani

Parmeshwar Jumbad (Inactive) made changes - 20/Dec/17 09:05 AM

Link

This issue is caused by ~~NF-5395~~ [ ~~NF-5395~~ ]

Permalink

Priya Dhamande (Inactive) logged work - 20/Dec/17 09:50 AM - edited

Time Spent:

2h

Codemap testing

Hide

Permalink

Priya Dhamande (Inactive) added a comment - 20/Dec/17 09:50 AM

The jira testing is kept on Hold till related ~~NF-5395~~ is deployed on Codemap.

Sachin Hingole Hrishikesh Deshpande

Show

Priya Dhamande (Inactive) added a comment - 20/Dec/17 09:50 AM The jira testing is kept on Hold till related NF-5395 is deployed on Codemap. Sachin Hingole Hrishikesh Deshpande

Priya Dhamande (Inactive) made changes - 20/Dec/17 09:50 AM

Remaining Estimate	32.25h [ 116100 ]	29.75h [ 107100 ]
Time Spent	2.75h [ 9900 ]	5.25h [ 18900 ]
Worklog Id		97110 [ 97110 ]

Permalink

Priya Dhamande (Inactive) logged work - 21/Dec/17 08:00 AM

Time Spent:

0.5h

<No comment>

Hide

Permalink

Nidhi Kaul (Inactive) added a comment - 22/Dec/17 05:12 AM

[~parmeshwar.jumbade]
Why is this JIRA with you? What work is pending here?

Nidhi.

Show

Nidhi Kaul (Inactive) added a comment - 22/Dec/17 05:12 AM [~parmeshwar.jumbade] Why is this JIRA with you? What work is pending here? Nidhi.

Parmeshwar Jumbad (Inactive) made changes - 22/Dec/17 05:24 AM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Parmeshwar Jumbad (Inactive) made changes - 22/Dec/17 05:24 AM

Item State

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parmeshwar Jumbad (Inactive) made changes - 22/Dec/17 05:24 AM

Assignee

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Sachin Hingole [ sachin.hingole ]

Hide

Permalink

Parmeshwar Jumbad (Inactive) added a comment - 22/Dec/17 05:27 AM

Hi Nidhi Kaul,

No work pending on this. Updated with proper status now.

CC: Prasanna Karlekar

Show

Parmeshwar Jumbad (Inactive) added a comment - 22/Dec/17 05:27 AM Hi Nidhi Kaul , No work pending on this. Updated with proper status now. CC: Prasanna Karlekar

Sachin Hingole (Inactive) made changes - 22/Dec/17 07:29 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Sachin Hingole (Inactive) made changes - 22/Dec/17 07:30 AM

Assignee

Sachin Hingole [ sachin.hingole ]

Priya Dhamande [ priya.dhamande ]

Priya Dhamande (Inactive) made changes - 26/Dec/17 01:15 PM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Priya Dhamande (Inactive) made changes - 27/Dec/17 04:56 AM

Remaining Estimate	29.75h [ 107100 ]	29.25h [ 105300 ]
Time Spent	5.25h [ 18900 ]	5.75h [ 20700 ]
Worklog Id		97944 [ 97944 ]

Priya Dhamande (Inactive) made changes - 27/Dec/17 04:57 AM

Remaining Estimate	29.25h [ 105300 ]	29.75h [ 107100 ]
Time Spent	5.75h [ 20700 ]	5.25h [ 18900 ]
Worklog Id		97110 [ 97110 ]

Hide

Permalink

Priya Dhamande (Inactive) added a comment - 27/Dec/17 06:10 AM

Environment: Codemap
Company: For QA CHMC and For QA Kindercare
Login: Partner

Issue: Billing Summary report appearing blank

As per discussion with Parmeshwar, the server is not matching. Si, reopening the jira for the same.

Hrishikesh Deshpande Sachin Hingole

Show

Priya Dhamande (Inactive) added a comment - 27/Dec/17 06:10 AM Environment: Codemap Company: For QA CHMC and For QA Kindercare Login: Partner Issue: Billing Summary report appearing blank As per discussion with Parmeshwar, the server is not matching. Si, reopening the jira for the same. Hrishikesh Deshpande Sachin Hingole

Priya Dhamande (Inactive) made changes - 27/Dec/17 06:10 AM

Assignee

Priya Dhamande [ priya.dhamande ]

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Priya Dhamande (Inactive) made changes - 27/Dec/17 06:10 AM

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

Priya Dhamande (Inactive) made changes - 27/Dec/17 06:10 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Hide

Permalink

Parmeshwar Jumbad (Inactive) added a comment - 27/Dec/17 07:08 AM

Hi Priya Dhamande,

Report working properly on this company now.

As per discussion with you, i will check availability of separate report server with Prasanna/Ashwin.

For now we are using same server for development and code-map environment.

CC: Prasanna Karlekar Gaurav Sodani

Show

Parmeshwar Jumbad (Inactive) added a comment - 27/Dec/17 07:08 AM Hi Priya Dhamande , Report working properly on this company now. As per discussion with you, i will check availability of separate report server with Prasanna/Ashwin. For now we are using same server for development and code-map environment. CC: Prasanna Karlekar Gaurav Sodani

Parmeshwar Jumbad (Inactive) made changes - 27/Dec/17 07:08 AM

Assignee

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Priya Dhamande [ priya.dhamande ]

Parmeshwar Jumbad (Inactive) made changes - 27/Dec/17 07:08 AM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Parmeshwar Jumbad (Inactive) made changes - 27/Dec/17 07:08 AM

Item State

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Sachin Hingole (Inactive) made changes - 27/Dec/17 09:20 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Sachin Hingole (Inactive) made changes - 27/Dec/17 09:20 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Prasad Patil (Inactive) made changes - 27/Dec/17 11:58 AM

Attachment

optional child life.png [ 70831 ]

Prasad Patil (Inactive) made changes - 27/Dec/17 11:58 AM

Attachment

Basic Life.png [ 70832 ]

Hide

Permalink

Prasad Patil (Inactive) added a comment - 27/Dec/17 12:01 PM

Hi [~parmeshwar.jumbade],

Checked this issue on Codemap.

Company: For QA CHMC
Login: sa
Billing Summary Report

The Total Premium is calculated correctly for some plans. However, there are discrepancies in Total Premium few plans.

(Please refer the screenshot below)

As discussed, request you to please look into this.
Thank you,
-------------------------------------------------
CC: Mandar Kulkarni, Satya, Prasanna Karlekar, Sachin Hingole

Show

Prasad Patil (Inactive) added a comment - 27/Dec/17 12:01 PM Hi [~parmeshwar.jumbade] , Checked this issue on Codemap. Company: For QA CHMC Login: sa Billing Summary Report The Total Premium is calculated correctly for some plans. However, there are discrepancies in Total Premium few plans. (Please refer the screenshot below) As discussed, request you to please look into this. Thank you, ------------------------------------------------- CC: Mandar Kulkarni , Satya , Prasanna Karlekar , Sachin Hingole

Prasad Patil (Inactive) made changes - 27/Dec/17 12:01 PM

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

Prasad Patil (Inactive) made changes - 27/Dec/17 12:01 PM

Assignee

Priya Dhamande [ priya.dhamande ]

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Prasad Patil (Inactive) made changes - 27/Dec/17 12:01 PM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Permalink

Priya Dhamande (Inactive) logged work - 27/Dec/17 12:35 PM

Time Spent:

0.5h
- discussion with Parmeshwar
- test for billing Summary report

Priya Dhamande (Inactive) made changes - 27/Dec/17 12:36 PM

Remaining Estimate	29.75h [ 107100 ]	29.25h [ 105300 ]
Time Spent	5.25h [ 18900 ]	5.75h [ 20700 ]
Worklog Id		98079 [ 98079 ]

Permalink

Prasad Patil (Inactive) logged work - 27/Dec/17 01:00 PM

Time Spent:

1.5h

Checking on Codemap.

Prasad Patil (Inactive) made changes - 27/Dec/17 01:00 PM

Remaining Estimate	29.25h [ 105300 ]	27.75h [ 99900 ]
Time Spent	5.75h [ 20700 ]	7.25h [ 26100 ]
Worklog Id		98100 [ 98100 ]

Parmeshwar Jumbad (Inactive) made changes - 28/Dec/17 05:19 AM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Parmeshwar Jumbad (Inactive) made changes - 28/Dec/17 05:19 AM

Item State

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Khandu Kshirsagar (Inactive) made changes - 28/Dec/17 07:09 AM

Item State

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Hide

Permalink

Parmeshwar Jumbad (Inactive) added a comment - 28/Dec/17 08:46 AM - edited

Hi Prasad Patil,

Have checked above discrepancies in Total premium and below are the reasons for reported issues:
1. Cost not calculated after value/customization changes of mapped rate/plans.

As you mentioned for "Plan: Basic Life/ AD&D (Full Coverage - $500000)-Basic Life-Sun Life Financial" rates showing 1.5000 but actual cost calculated with the value "0.0730000000". So, current Total premium amount (i.e. $1.29) value is correct with the rate amount "0.0730000000". Need to recalculate rates using SA utility. Same needs to be done for "Optional Child Life (CHMC) (Exec)-Optional Life - Child-Sun Life Financial" plan.

Regarding, premium showing incorrect for "Optional Child Life (CHMC) (All Others)-Optional Life - Child-Sun Life Financial" plan because there are elections with zero coverage but premium for elections having some value.

Jyoti Mayne/Umesh Kadam, I tried to recalculate rates through SA Utility but still updated cost not getting to the elections. Please look into this.

CC: Prasanna Karlekar Gaurav Sodani

Show

Parmeshwar Jumbad (Inactive) added a comment - 28/Dec/17 08:46 AM - edited Hi Prasad Patil , Have checked above discrepancies in Total premium and below are the reasons for reported issues: 1. Cost not calculated after value/customization changes of mapped rate/plans. As you mentioned for "Plan: Basic Life/ AD&D (Full Coverage - $500000)-Basic Life-Sun Life Financial" rates showing 1.5000 but actual cost calculated with the value "0.0730000000". So, current Total premium amount (i.e. $1.29) value is correct with the rate amount "0.0730000000". Need to recalculate rates using SA utility. Same needs to be done for "Optional Child Life (CHMC) (Exec)-Optional Life - Child-Sun Life Financial" plan. Regarding, premium showing incorrect for "Optional Child Life (CHMC) (All Others)-Optional Life - Child-Sun Life Financial" plan because there are elections with zero coverage but premium for elections having some value. Jyoti Mayne / Umesh Kadam , I tried to recalculate rates through SA Utility but still updated cost not getting to the elections. Please look into this. CC: Prasanna Karlekar Gaurav Sodani

Sachin Hingole (Inactive) made changes - 28/Dec/17 08:54 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Hide

Permalink

Nidhi Kaul (Inactive) added a comment - 28/Dec/17 09:37 AM

[~parmeshwar.jumbade]
What should be the status of t JIRA in that case?

Prasanna Karlekar
Nidhi.

Show

Nidhi Kaul (Inactive) added a comment - 28/Dec/17 09:37 AM [~parmeshwar.jumbade] What should be the status of t JIRA in that case? Prasanna Karlekar Nidhi.

Parmeshwar Jumbad (Inactive) made changes - 28/Dec/17 10:21 AM

Assignee

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Prasad Patil [ prasad.patil ]

Parmeshwar Jumbad (Inactive) made changes - 28/Dec/17 10:21 AM

Item State

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Permalink

Parmeshwar Jumbad (Inactive) logged work - 28/Dec/17 10:25 AM

Time Spent:

4h

Issue analysis
Internal discussion
JIRA update

Parmeshwar Jumbad (Inactive) made changes - 28/Dec/17 10:26 AM

Remaining Estimate	27.75h [ 99900 ]	23.75h [ 85500 ]
Time Spent	7.25h [ 26100 ]	11.25h [ 40500 ]
Worklog Id		98259 [ 98259 ]

Parmeshwar Jumbad (Inactive) made changes - 28/Dec/17 12:50 PM

Link

This issue is blocked by ~~WT-9147~~ [ ~~WT-9147~~ ]

Permalink

Parmeshwar Jumbad (Inactive) logged work - 29/Dec/17 05:14 AM

Time Spent:

5.75h

Issue analysis for Total amount premium discrepancies
Internal discussions
JIRA update
Email communication

Parmeshwar Jumbad (Inactive) made changes - 29/Dec/17 05:15 AM

Remaining Estimate	23.75h [ 85500 ]	18h [ 64800 ]
Time Spent	11.25h [ 40500 ]	17h [ 61200 ]
Worklog Id		98452 [ 98452 ]

Parmeshwar Jumbad (Inactive) made changes - 29/Dec/17 11:23 AM

Link

This issue is blocked by ~~WT-9147~~ [ ~~WT-9147~~ ]

Permalink

Parmeshwar Jumbad (Inactive) logged work - 29/Dec/17 11:24 AM

Time Spent:

2h

Data analysis
Check reason of issue blocker
Internal discussion

Parmeshwar Jumbad (Inactive) made changes - 29/Dec/17 11:24 AM

Assignee

Prasad Patil [ prasad.patil ]

Umesh Kadam [ umesh.kadam ]

Parmeshwar Jumbad (Inactive) made changes - 29/Dec/17 11:24 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Parmeshwar Jumbad (Inactive) made changes - 29/Dec/17 11:24 AM

Remaining Estimate	18h [ 64800 ]	16h [ 57600 ]
Time Spent	17h [ 61200 ]	19h [ 68400 ]
Worklog Id		98769 [ 98769 ]

Umesh Kadam (Inactive) made changes - 04/Jan/18 09:47 AM

Developer

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Umesh Kadam [ umesh.kadam ]

Hide

Permalink

Snehal Shabade (Inactive) added a comment - 04/Jan/18 11:31 AM

Hi [~parmeshwar.jumbade],

As discussed, we verify the cost and billing data for given EE and it is looking fine.

Thanks,
Snehal Shabade

CC: Umesh Kadam

Show

Snehal Shabade (Inactive) added a comment - 04/Jan/18 11:31 AM Hi [~parmeshwar.jumbade] , As discussed, we verify the cost and billing data for given EE and it is looking fine. Thanks, Snehal Shabade CC: Umesh Kadam

Snehal Shabade (Inactive) made changes - 04/Jan/18 11:32 AM

Assignee

Umesh Kadam [ umesh.kadam ]

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Umesh Kadam (Inactive) made changes - 04/Jan/18 11:41 AM

Remaining Estimate	16h [ 57600 ]	14.5h [ 52200 ]
Time Spent	19h [ 68400 ]	20.5h [ 73800 ]
Worklog Id		99337 [ 99337 ]

Permalink

Snehal Shabade (Inactive) logged work - 04/Jan/18 11:45 AM

Time Spent:

2h
- Discussion with Umesh and parmeshwar regarding issue
- analysis on back end data

Snehal Shabade (Inactive) made changes - 04/Jan/18 11:46 AM

Remaining Estimate	14.5h [ 52200 ]	12.5h [ 45000 ]
Time Spent	20.5h [ 73800 ]	22.5h [ 81000 ]
Worklog Id		99338 [ 99338 ]

Permalink

Umesh Kadam (Inactive) logged work - 04/Jan/18 05:30 PM

Time Spent:

1.5h

Initial Analysis and discussion with Jyoti
Discussion with Snehal and Parmeshwar regarding issue and customization

Hide

Permalink

Parmeshwar Jumbad (Inactive) added a comment - 08/Jan/18 10:04 AM - edited

Hi Prasad Patil,

Verified data after recalculates rates through SA utility for month Jan 2018 and it is showing as per configurations. Please do verify and let us know.

Snehal Shabade, Please verify coverage and premium for Optional Child Life (CHMC) (Exec) plan and if it is proper then update same here.

Note: If there is any changes in rates and plan customization's it needs to recalculates through SA utility to reflect changes on this report.

CC: Umesh Kadam Prasanna Karlekar Gaurav Sodani

Show

Parmeshwar Jumbad (Inactive) added a comment - 08/Jan/18 10:04 AM - edited Hi Prasad Patil , Verified data after recalculates rates through SA utility for month Jan 2018 and it is showing as per configurations. Please do verify and let us know. Snehal Shabade , Please verify coverage and premium for Optional Child Life (CHMC) (Exec) plan and if it is proper then update same here. Note: If there is any changes in rates and plan customization's it needs to recalculates through SA utility to reflect changes on this report. CC: Umesh Kadam Prasanna Karlekar Gaurav Sodani

Permalink

Parmeshwar Jumbad (Inactive) logged work - 08/Jan/18 10:16 AM

Time Spent:

2.5h

Verified reports after rates recalculation through SA utility.
Internal discussion with Snehal and JIRA Update.

Parmeshwar Jumbad (Inactive) made changes - 08/Jan/18 10:16 AM

Assignee

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Prasad Patil [ prasad.patil ]

Parmeshwar Jumbad (Inactive) made changes - 08/Jan/18 10:18 AM

Remaining Estimate	12.5h [ 45000 ]	10h [ 36000 ]
Time Spent	22.5h [ 81000 ]	25h [ 90000 ]
Worklog Id		99607 [ 99607 ]

Hide

Permalink

Snehal Shabade (Inactive) added a comment - 08/Jan/18 11:12 AM

Hi [~parmeshwar.jumbade],

As discussed ,we verified coverage and premium for Optional Child Life (CHMC) (Exec) plan for given EE and it is looking fine.

Thanks,
Snehal Shabade

CC: Umesh Kadam

Show

Snehal Shabade (Inactive) added a comment - 08/Jan/18 11:12 AM Hi [~parmeshwar.jumbade] , As discussed ,we verified coverage and premium for Optional Child Life (CHMC) (Exec) plan for given EE and it is looking fine. Thanks, Snehal Shabade CC: Umesh Kadam

Permalink

Snehal Shabade (Inactive) logged work - 08/Jan/18 11:31 AM

Time Spent:

0.5h
- discussion with parmeshwar
- analysis on back end data

Snehal Shabade (Inactive) made changes - 08/Jan/18 11:31 AM

Remaining Estimate	10h [ 36000 ]	9.5h [ 34200 ]
Time Spent	25h [ 90000 ]	25.5h [ 91800 ]
Worklog Id		99610 [ 99610 ]

Prasad Patil (Inactive) made changes - 09/Jan/18 09:03 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Prasad Patil (Inactive) made changes - 09/Jan/18 09:03 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Prasad Patil (Inactive) made changes - 09/Jan/18 09:03 AM

Item State

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Parent values: Stage QA(10202)

Prasad Patil (Inactive) made changes - 09/Jan/18 09:03 AM

Item State

Parent values: Stage QA(10202)

Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)

Prasad Patil (Inactive) made changes - 09/Jan/18 09:03 AM

Assignee

Prasad Patil [ prasad.patil ]

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Hide

Permalink

Prasad Patil (Inactive) added a comment - 09/Jan/18 09:04 AM

Hi [~parmeshwar.jumbade],

Verified the Billing summary report on Pre-Prod Environment. Working fine as expected.

Thank you,
----------------------------------
CC: Mandar Kulkarni, Satya, Gaurav Sodani

Show

Prasad Patil (Inactive) added a comment - 09/Jan/18 09:04 AM Hi [~parmeshwar.jumbade] , Verified the Billing summary report on Pre-Prod Environment. Working fine as expected. Thank you, ---------------------------------- CC: Mandar Kulkarni , Satya , Gaurav Sodani

Hrishikesh Deshpande (Inactive) made changes - 09/Jan/18 09:12 AM

Assignee

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Priya Dhamande [ priya.dhamande ]

Permalink

Prasad Patil (Inactive) logged work - 09/Jan/18 12:03 PM

Time Spent:

1.5h

Analysis and resolution verfication on Pre Prod.

Prasad Patil (Inactive) made changes - 09/Jan/18 12:04 PM

Remaining Estimate	9.5h [ 34200 ]	8h [ 28800 ]
Time Spent	25.5h [ 91800 ]	27h [ 97200 ]
Worklog Id		99762 [ 99762 ]

Parmeshwar Jumbad (Inactive) made changes - 06/Feb/18 05:22 AM

Labels

Static_Reports

Sprint_41

Sanjana Jadhav (Inactive) made changes - 13/Mar/18 07:07 AM

Attachment

NF-5533_2.png [ 74543 ]

Sanjana Jadhav (Inactive) made changes - 13/Mar/18 07:07 AM

Attachment

NF-5533_1.png [ 74544 ]

Hide

Permalink

Sanjana Jadhav (Inactive) added a comment - 13/Mar/18 07:07 AM

Verified on production.
Verified all test cases.Working as expected.
PFA,

Thanks,
Sanjana Jadhav

CC: Prasad Pise Sachin Hingole Rakesh Roy

Show

Sanjana Jadhav (Inactive) added a comment - 13/Mar/18 07:07 AM Verified on production. Verified all test cases.Working as expected. PFA, Thanks, Sanjana Jadhav CC: Prasad Pise Sachin Hingole Rakesh Roy

Sanjana Jadhav (Inactive) made changes - 13/Mar/18 07:07 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Permalink

Sanjana Jadhav (Inactive) logged work - 13/Mar/18 07:11 AM

Time Spent:

1.7h

Production testing

Sanjana Jadhav (Inactive) made changes - 13/Mar/18 07:11 AM

Assignee

Priya Dhamande [ priya.dhamande ]

Yamilka Coca [ yamilka.coca ]

Sanjana Jadhav (Inactive) made changes - 13/Mar/18 07:12 AM

Remaining Estimate	8h [ 28800 ]	6.3h [ 22680 ]
Time Spent	27h [ 97200 ]	28.7h [ 103320 ]
Worklog Id		108099 [ 108099 ]

Sanjana Jadhav (Inactive) made changes - 13/Mar/18 07:12 AM

Resolution		Bug Fixed [ 10402 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Sanjana Jadhav (Inactive) made changes - 13/Mar/18 07:12 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Transition	Time In Source Status	Execution Times

Parmeshwar Jumbad (Inactive) made transition - 19/Dec/17 06:47 AM

Open

In Development

1m 57s

Prasad Patil (Inactive) made transition - 27/Dec/17 12:01 PM

In LB Testing

Reopen in Local

5d 2h 41m

Parmeshwar Jumbad (Inactive) made transition - 28/Dec/17 05:19 AM

Reopen in Local

In Development

2d 15h 3m

Prasad Patil (Inactive) made transition - 09/Jan/18 09:03 AM

In Development

In LB Testing

13d 8h 31m

Prasad Patil (Inactive) made transition - 09/Jan/18 09:03 AM

In LB Testing

Stage Testing

Sanjana Jadhav (Inactive) made transition - 13/Mar/18 07:07 AM

Stage Testing

In Production Testing

62d 21h 4m

Sanjana Jadhav (Inactive) made transition - 13/Mar/18 07:12 AM

In Production Testing

Production Complete

5m 2s

Sanjana Jadhav (Inactive) made transition - 13/Mar/18 07:12 AM

Production Complete

Closed

People

Assignee:: Yamilka Coca (Inactive)

Reporter:: Parmeshwar Jumbad (Inactive)

Account Executive:: Yamilka Coca (Inactive)

Developer:: Umesh Kadam (Inactive)

QA:: Sanjana Jadhav (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 19/Dec/17 06:45 AM

Updated:: 13/Mar/18 07:12 AM

Resolved:: 13/Mar/18 07:12 AM

Dev Due Date:: 01/Nov/2017

Pre-Prod Due Date:: 22/Dec/2017

Code Review Date:: 30/Oct/2017

Time Tracking

Estimated:

35h

Remaining:

6.3h

Logged:

28.7h