[WT-7705] Cobra Coverage Tier label is populating blank - Implementation - Workterra Jira

Details

Type: Enhancement
Status: Closed
Priority: Medium
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: BenAdmin
Labels:
None

Module:
BenAdmin - EDS
Reported by:
Client
Company:
Prime Healthcare
Item State:
Production Complete - Closed
Sprint:
WT Sprint 23, WT Sprint 24

Dev Estimates:
70
Code Reviewed By:

Vinalyak Kulkarni

Description

Please refer to ~~WT-1850~~ for analysis document, estimation & further details.

Attachments

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

Attachments

Export_Test Scenarios_WT-7705.xls
21 kB
27/Feb/17 01:18 PM
Macro Details.xls
10 kB
17/Feb/17 09:18 AM
WT-7705_MemberType Event Builder Enhancement.xls
18 kB
24/Feb/17 11:30 AM

Issue Links

blocks

WT-7303 Prime_Healthcare: Hospital Business Services COBRA Notice

Production Complete

relates to

WT-7303 Prime_Healthcare: Hospital Business Services COBRA Notice

Production Complete

WT-8679 WT -> Cobra Coverage Tier Label Enhancement -> For existing COBRA eligible event builders, EventMemberTypeId is NULL

Closed

WT-8681 WT -> Cobra Coverage Tier Label Enhancement -> EventMemberTypeId is not getting updated after editing the the existing event builder's eligibility

Closed

Activity

Ascending order - Click to sort in descending order

Satya created issue - 11/Jan/17 12:23 PM

Vinayak Kulkarni (Inactive) made changes - 06/Feb/17 01:49 PM

Field	Original Value	New Value
Link		This issue blocks ~~WT-7303~~ [ ~~WT-7303~~ ]

Hide

Permalink

Vinayak Kulkarni (Inactive) added a comment - 06/Feb/17 01:49 PM - edited

We can not complete ~~WT-7303~~ without getting this done ~~WT-7705~~

Show

Vinayak Kulkarni (Inactive) added a comment - 06/Feb/17 01:49 PM - edited We can not complete WT-7303 without getting this done WT-7705

Hide

Permalink

Sheetal Bodhale (Inactive) added a comment - 07/Feb/17 05:16 AM

Due to low bandwidth can not take this enhancement now.
CC:Satya
Thanks,
Sheetal Bodhale

Show

Sheetal Bodhale (Inactive) added a comment - 07/Feb/17 05:16 AM Due to low bandwidth can not take this enhancement now. CC: Satya Thanks, Sheetal Bodhale

Satya made changes - 10/Feb/17 01:57 PM

Sprint

WT Sprint 23 [ 43 ]

Sheetal Bodhale (Inactive) made changes - 13/Feb/17 05:50 AM

Assignee

Sheetal Bodhale [ sheetal.bodhale ]

Aarati Sabnis [ aarati.sabnis ]

Hide

Permalink

Sheetal Bodhale (Inactive) added a comment - 13/Feb/17 05:51 AM

Hi Aarati Sabnis,

Please start with this enhancement.
CC:Satya
Thanks,
Sheetal Bodhale

Show

Sheetal Bodhale (Inactive) added a comment - 13/Feb/17 05:51 AM Hi Aarati Sabnis , Please start with this enhancement. CC: Satya Thanks, Sheetal Bodhale

Aarati Sabnis (Inactive) made changes - 13/Feb/17 08:29 AM

Status

New Request [ 10029 ]

Pending for Approval [ 10002 ]

Aarati Sabnis (Inactive) made changes - 13/Feb/17 08:29 AM

Status

Pending for Approval [ 10002 ]

Approved for Development [ 10003 ]

Aarati Sabnis (Inactive) made changes - 13/Feb/17 08:29 AM

Status

Approved for Development [ 10003 ]

In Development [ 10007 ]

Aarati Sabnis (Inactive) made changes - 13/Feb/17 08:45 AM

Item State

Parent values: Development(10200)Level 1 values: Development Backlog(10205)

Parent values: Development(10200)Level 1 values: In Progress(10206)

Aarati Sabnis (Inactive) made changes - 13/Feb/17 09:03 AM

Dev Due Date		24/Feb/2017
Remaining Estimate		70h [ 252000 ]
Original Estimate		70h [ 252000 ]

Aarati Sabnis (Inactive) made changes - 13/Feb/17 12:51 PM

Remaining Estimate	70h [ 252000 ]	64.5h [ 232200 ]
Time Spent		5.5h [ 19800 ]
Worklog Id	24598 [ 24598 ]

Sheetal Bodhale (Inactive) made changes - 13/Feb/17 01:01 PM

Remaining Estimate	64.5h [ 232200 ]	64h [ 230400 ]
Time Spent	5.5h [ 19800 ]	6h [ 21600 ]
Worklog Id	24604 [ 24604 ]

Permalink

Aarati Sabnis (Inactive) logged work - 14/Feb/17 12:49 AM - edited

Time Spent:

5.5h

Internal discussion with Chaitali
Enhancement understanding
Unit testing
Checking database entries
Checking different tables
Checking different stored procedures
Making correction script according to macro
Internal discussion with Sheetal

Permalink

Sheetal Bodhale (Inactive) logged work - 14/Feb/17 01:01 AM

Time Spent:

0.5h

internal discussion

Aarati Sabnis (Inactive) made changes - 14/Feb/17 04:16 AM

Worklog Id

24598 [ 24598 ]

Permalink

Aarati Sabnis (Inactive) logged work - 14/Feb/17 12:45 PM

Time Spent:

4h

Unit testing
Debugging stored procedure
Changing stored procedure regarding event builder
Internal discussion with Sheetal
Different return codes are used in stored procedure

Aarati Sabnis (Inactive) made changes - 14/Feb/17 12:47 PM

Remaining Estimate	64h [ 230400 ]	60h [ 216000 ]
Time Spent	6h [ 21600 ]	10h [ 36000 ]
Worklog Id	24947 [ 24947 ]

Permalink

Aarati Sabnis (Inactive) logged work - 15/Feb/17 12:53 PM

Time Spent:

4h

Unit testing
Changing stored procedures
Changing stored procedure of event builder
Unit testing
Updating event builder table with new column
Unit testing for adding new event
Changing SP for updating table according to class

Aarati Sabnis (Inactive) made changes - 15/Feb/17 12:57 PM

Remaining Estimate	60h [ 216000 ]	56h [ 201600 ]
Time Spent	10h [ 36000 ]	14h [ 50400 ]
Worklog Id	25228 [ 25228 ]

Hide

Permalink

Aarati Sabnis (Inactive) added a comment - 16/Feb/17 02:27 PM

Due to priority issue ~~WT-7378~~ , I worked 5.5hr on 13th Feb and 3hr on 16th Feb.

Thanks,
Aarati R. Sabnis

CC Satya,Sheetal Bodhale

Show

Aarati Sabnis (Inactive) added a comment - 16/Feb/17 02:27 PM Due to priority issue WT-7378 , I worked 5.5hr on 13th Feb and 3hr on 16th Feb. Thanks, Aarati R. Sabnis CC Satya , Sheetal Bodhale

Permalink

Aarati Sabnis (Inactive) logged work - 16/Feb/17 02:28 PM

Time Spent:

3h

Unit testing
Changing stored procedure according class and status
Update event builder table
Changes according to UI
Unit testing

Aarati Sabnis (Inactive) made changes - 16/Feb/17 02:29 PM

Remaining Estimate	56h [ 201600 ]	53h [ 190800 ]
Time Spent	14h [ 50400 ]	17h [ 61200 ]
Worklog Id	25639 [ 25639 ]

Ganesh Sadawarte (Inactive) made changes - 17/Feb/17 09:18 AM

Attachment

Macro Details.xls [ 39983 ]

Hide

Permalink

Aarati Sabnis (Inactive) added a comment - 17/Feb/17 01:00 PM

Due to priority issue ~~WT-5083~~, today(17th Feb) I worked for 4.5hr only.

Thanks,
Aarati R. Sabnis

CC Satya,Sheetal Bodhale

Show

Aarati Sabnis (Inactive) added a comment - 17/Feb/17 01:00 PM Due to priority issue WT-5083 , today(17th Feb) I worked for 4.5hr only. Thanks, Aarati R. Sabnis CC Satya , Sheetal Bodhale

Permalink

Aarati Sabnis (Inactive) logged work - 17/Feb/17 01:01 PM - edited

Time Spent:

4.5h

Unit testing
Internal discussion with Ganesh
Script changes according to macro
SP changes according to macro
Unit testing
Script changes according to third table
Unit testing

Aarati Sabnis (Inactive) made changes - 17/Feb/17 01:01 PM

Remaining Estimate	53h [ 190800 ]	48.5h [ 174600 ]
Time Spent	17h [ 61200 ]	21.5h [ 77400 ]
Worklog Id	25892 [ 25892 ]

Sheetal Bodhale (Inactive) made changes - 20/Feb/17 11:16 AM

Remaining Estimate	48.5h [ 174600 ]	47.5h [ 171000 ]
Time Spent	21.5h [ 77400 ]	22.5h [ 81000 ]
Worklog Id	26107 [ 26107 ]

Permalink

Aarati Sabnis (Inactive) logged work - 20/Feb/17 12:58 PM

Time Spent:

8h

Unit testing
Internal discussion with Ganesh
Script changes according to macro
Internal discussion with Sheetal
Script changes according to eligibility
Unit testing
Script changes
SP changes
Unit testing

Aarati Sabnis (Inactive) made changes - 20/Feb/17 01:00 PM

Remaining Estimate	47.5h [ 171000 ]	39.5h [ 142200 ]
Time Spent	22.5h [ 81000 ]	30.5h [ 109800 ]
Worklog Id	26141 [ 26141 ]

Aarati Sabnis (Inactive) made changes - 20/Feb/17 01:01 PM

Worklog Id

25892 [ 25892 ]

Permalink

Sheetal Bodhale (Inactive) logged work - 20/Feb/17 11:16 PM

Time Spent:

1h

internal discussion

Hide

Permalink

Aarati Sabnis (Inactive) added a comment - 21/Feb/17 11:22 AM - edited

Hello Satya,

Dev due date is changed and same approach will be used as per mention in the analysis.

Thanks & Regards,
Aarati R. Sabnis

CCSheetal Bodhale,Vinayak Kulkarni,Ganesh Sadawarte

Show

Aarati Sabnis (Inactive) added a comment - 21/Feb/17 11:22 AM - edited Hello Satya , Dev due date is changed and same approach will be used as per mention in the analysis. Thanks & Regards, Aarati R. Sabnis CC Sheetal Bodhale , Vinayak Kulkarni , Ganesh Sadawarte

Sheetal Bodhale (Inactive) made changes - 21/Feb/17 12:38 PM

Remaining Estimate	39.5h [ 142200 ]	38.5h [ 138600 ]
Time Spent	30.5h [ 109800 ]	31.5h [ 113400 ]
Worklog Id	26352 [ 26352 ]

Permalink

Nandkumar Prabhakar Karlekar (Inactive) logged work - 21/Feb/17 01:05 PM

Time Spent:

1h

<No comment>

Nandkumar Prabhakar Karlekar (Inactive) made changes - 21/Feb/17 01:06 PM

Remaining Estimate	38.5h [ 138600 ]	37.5h [ 135000 ]
Time Spent	31.5h [ 113400 ]	32.5h [ 117000 ]
Worklog Id	26376 [ 26376 ]

Permalink

Vinayak Kulkarni (Inactive) logged work - 21/Feb/17 01:13 PM

Time Spent:

1h

<No comment>

Vinayak Kulkarni (Inactive) made changes - 21/Feb/17 01:13 PM

Remaining Estimate	37.5h [ 135000 ]	36.5h [ 131400 ]
Time Spent	32.5h [ 117000 ]	33.5h [ 120600 ]
Worklog Id	26386 [ 26386 ]

Permalink

Ganesh Sadawarte (Inactive) logged work - 21/Feb/17 01:31 PM

Time Spent:

1h

Design team meeting

Permalink

Aarati Sabnis (Inactive) logged work - 21/Feb/17 02:58 PM

Time Spent:

5h

Unit testing
Script changes according to macro
Script changes according to additional criteria
Unit testing
Design team meeting
Script changes according to eligibility
Unit testing

Aarati Sabnis (Inactive) made changes - 21/Feb/17 03:00 PM

Remaining Estimate	36.5h [ 131400 ]	31.5h [ 113400 ]
Time Spent	33.5h [ 120600 ]	38.5h [ 138600 ]
Worklog Id	26418 [ 26418 ]

Permalink

Sheetal Bodhale (Inactive) logged work - 22/Feb/17 12:37 AM

Time Spent:

1h

design team meeting

Ganesh Sadawarte (Inactive) made changes - 22/Feb/17 07:33 AM

Remaining Estimate	31.5h [ 113400 ]	30.5h [ 109800 ]
Time Spent	38.5h [ 138600 ]	39.5h [ 142200 ]
Worklog Id	26550 [ 26550 ]

Rakesh Shahane (Inactive) made changes - 22/Feb/17 07:34 AM

Link

This issue relates to ~~WT-7303~~ [ ~~WT-7303~~ ]

Sheetal Bodhale (Inactive) made changes - 22/Feb/17 11:51 AM

Remaining Estimate	30.5h [ 109800 ]	29.5h [ 106200 ]
Time Spent	39.5h [ 142200 ]	40.5h [ 145800 ]
Worklog Id	26630 [ 26630 ]

Permalink

Aarati Sabnis (Inactive) logged work - 22/Feb/17 06:32 PM

Time Spent:

7h

Internal discussion with Ganesh
Adding third table for macro
Changing conditions for macro field
Internal discussion with Rakesh
Changing condition for additional field
Changing condition for cobra eligible employees
Internal discussion with Sheetal
Script changes
Correction script for existing records in event builder table
unit testing

Aarati Sabnis (Inactive) made changes - 22/Feb/17 06:34 PM

Remaining Estimate	29.5h [ 106200 ]	22.5h [ 81000 ]
Time Spent	40.5h [ 145800 ]	47.5h [ 171000 ]
Worklog Id	26747 [ 26747 ]

Permalink

Sheetal Bodhale (Inactive) logged work - 22/Feb/17 11:51 PM

Time Spent:

1h

internal discussion with aarati and ganesh

Aarati Sabnis (Inactive) made changes - 24/Feb/17 09:52 AM

Dev Due Date	24/Feb/2017	28/Feb/2017
Resolution		Fixed [ 1 ]

Permalink

Alankar Chavan (Inactive) logged work - 24/Feb/17 11:28 AM

Time Spent:

6h

discussion
analysis
test case writing completed

Alankar Chavan (Inactive) made changes - 24/Feb/17 11:28 AM

Remaining Estimate	22.5h [ 81000 ]	16.5h [ 59400 ]
Time Spent	47.5h [ 171000 ]	53.5h [ 192600 ]
Worklog Id	27118 [ 27118 ]

Alankar Chavan (Inactive) made changes - 24/Feb/17 11:30 AM

Attachment

WT-7705_MemberType Event Builder Enhancement.xls [ 40709 ]

Hide

Permalink

Alankar Chavan (Inactive) added a comment - 24/Feb/17 11:30 AM

Hello Aarati Sabnis,

Please find the attached test cases for above implementation which might be helpful for your at component level testing.

WT-7705_MemberType Event Builder Enhancement.xls

Hello Hrishikesh Deshpande,

The test cases are related to the testing we can do at our end in the system (through UI and back end)

This enhancement is specially for Export Module.
Handing over this to you, so as you / Aniruddha Dev can add up the Export scenarios in the existing sheet and test the same once the changes are deployed.

CC - Sheetal Bodhale Vinayak Kulkarni Rakesh Roy Prasad Pise Ganesh Sadawarte Satya

Show

Alankar Chavan (Inactive) added a comment - 24/Feb/17 11:30 AM Hello Aarati Sabnis , Please find the attached test cases for above implementation which might be helpful for your at component level testing. WT-7705_MemberType Event Builder Enhancement.xls Hello Hrishikesh Deshpande , The test cases are related to the testing we can do at our end in the system (through UI and back end) This enhancement is specially for Export Module. Handing over this to you, so as you / Aniruddha Dev can add up the Export scenarios in the existing sheet and test the same once the changes are deployed. CC - Sheetal Bodhale Vinayak Kulkarni Rakesh Roy Prasad Pise Ganesh Sadawarte Satya

Permalink

Aarati Sabnis (Inactive) logged work - 25/Feb/17 05:33 AM

Time Spent:

4h

Unit testing
Correction script
Internal discussion with Vinayak
Changes in stored procedure
SP testing

Aarati Sabnis (Inactive) made changes - 25/Feb/17 05:35 AM

Remaining Estimate	16.5h [ 59400 ]	12.5h [ 45000 ]
Time Spent	53.5h [ 192600 ]	57.5h [ 207000 ]
Worklog Id	27398 [ 27398 ]

Hide

Permalink

Aarati Sabnis (Inactive) added a comment - 27/Feb/17 07:22 AM

Hello Alankar Chavan,

As per our discussion with Vinayak Kulkarni, following are the slight changes in analysis.

1. Default value of column : EventMemberTypeID is null.
2. It is only for cobra-eligible employees.
3. Some companies are using zip table entries in event builder.
So if zip number is used then EventMemberTypeID=1 as zip number is related to employee.

Thanks & Regards,
Aarati R. Sabnis
CC Satya,Sheetal Bodhale,Vinayak Kulkarni

Show

Aarati Sabnis (Inactive) added a comment - 27/Feb/17 07:22 AM Hello Alankar Chavan , As per our discussion with Vinayak Kulkarni , following are the slight changes in analysis. 1. Default value of column : EventMemberTypeID is null. 2. It is only for cobra-eligible employees. 3. Some companies are using zip table entries in event builder. So if zip number is used then EventMemberTypeID=1 as zip number is related to employee. Thanks & Regards, Aarati R. Sabnis CC Satya , Sheetal Bodhale , Vinayak Kulkarni

Sheetal Bodhale (Inactive) made changes - 27/Feb/17 12:11 PM

Remaining Estimate	12.5h [ 45000 ]	12h [ 43200 ]
Time Spent	57.5h [ 207000 ]	58h [ 208800 ]
Worklog Id	27561 [ 27561 ]

Satya made changes - 27/Feb/17 12:18 PM

Sprint

WT Sprint 23 [ 43 ]

WT Sprint 23, WT Sprint 25 [ 43, 46 ]

Satya made changes - 27/Feb/17 12:21 PM

Sprint

WT Sprint 23, WT Sprint 25 [ 43, 46 ]

WT Sprint 23, WT Sprint 24 [ 43, 45 ]

Permalink

Aniruddha Dev (Inactive) logged work - 27/Feb/17 01:18 PM

Time Spent:

3h

Analysis and Test Scenarios writing

Aniruddha Dev (Inactive) made changes - 27/Feb/17 01:18 PM

Attachment

Export_Test Scenarios_WT-7705.xls [ 40821 ]

Aniruddha Dev (Inactive) made changes - 27/Feb/17 01:18 PM

Remaining Estimate	12h [ 43200 ]	9h [ 32400 ]
Time Spent	58h [ 208800 ]	61h [ 219600 ]
Worklog Id	27621 [ 27621 ]

Permalink

Aarati Sabnis (Inactive) logged work - 27/Feb/17 07:07 PM

Time Spent:

7.5h

Unit testing
Correction script
Internal discussion with Vinayak
Unit testing
Script changes
Internal discussion with Sheetal
Script changes
Unit testing
Correction script

Aarati Sabnis (Inactive) made changes - 27/Feb/17 07:09 PM

Remaining Estimate	9h [ 32400 ]	1.5h [ 5400 ]
Time Spent	61h [ 219600 ]	68.5h [ 246600 ]
Worklog Id	27665 [ 27665 ]

Permalink

Sheetal Bodhale (Inactive) logged work - 28/Feb/17 12:10 AM

Time Spent:

0.5h

internal discussion

Hide

Permalink

Aarati Sabnis (Inactive) added a comment - 28/Feb/17 11:01 AM

Hello Alankar Chavan,

I am done with LB check-in.

Thanks & Regards,
Aarati R. Sabnis

CC Satya,Sheetal Bodhale

Show

Aarati Sabnis (Inactive) added a comment - 28/Feb/17 11:01 AM Hello Alankar Chavan , I am done with LB check-in. Thanks & Regards, Aarati R. Sabnis CC Satya , Sheetal Bodhale

Aarati Sabnis (Inactive) made changes - 28/Feb/17 11:31 AM

Code Reviewed By

Vinalyak Kulkarni [ 12100 ]

Khandu Kshirsagar (Inactive) made changes - 28/Feb/17 11:47 AM

Item State

Parent values: Development(10200)Level 1 values: In Progress(10206)

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

Aarati Sabnis (Inactive) made changes - 28/Feb/17 12:00 PM

Assignee

Aarati Sabnis [ aarati.sabnis ]

Alankar Chavan [ alankar.chavan ]

Aarati Sabnis (Inactive) made changes - 28/Feb/17 12:00 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Permalink

Aarati Sabnis (Inactive) logged work - 28/Feb/17 12:01 PM

Time Spent:

7h

Unit testing
Correction script
Internal discussion with Vinayak
Unit testing
Script changes
Internal discussion with Sheetal
Code review by Vinayak
Review changes
LB check-in

Aarati Sabnis (Inactive) made changes - 28/Feb/17 12:02 PM

Remaining Estimate	1.5h [ 5400 ]	0h [ 0 ]
Time Spent	68.5h [ 246600 ]	75.5h [ 271800 ]
Worklog Id	28030 [ 28030 ]

Permalink

Aarati Sabnis (Inactive) logged work - 28/Feb/17 12:58 PM

Time Spent:

0.5h

LB testing for Prime companies where EventBuilderType column is present.
LB testing for default constraint.

Aarati Sabnis (Inactive) made changes - 28/Feb/17 01:00 PM

Time Spent	75.5h [ 271800 ]	76h [ 273600 ]
Worklog Id	28111 [ 28111 ]

Permalink

Vinayak Kulkarni (Inactive) logged work - 28/Feb/17 03:30 PM

Time Spent:

2h

code review.

Hide

Permalink

Alankar Chavan (Inactive) added a comment - 01/Mar/17 12:25 PM

We will shortly take this enhancement to test.
We are testing some of the prioritized task currently like [WT-8581 WT-8047 WT-7644 WT-8381]

CC - Rakesh Roy Prasad Pise

Show

Alankar Chavan (Inactive) added a comment - 01/Mar/17 12:25 PM We will shortly take this enhancement to test. We are testing some of the prioritized task currently like [WT-8581 WT-8047 WT-7644 WT-8381] CC - Rakesh Roy Prasad Pise

Alankar Chavan (Inactive) made changes - 02/Mar/17 06:23 AM

Link

This issue relates to ~~WT-8679~~ [ ~~WT-8679~~ ]

Hide

Permalink

Alankar Chavan (Inactive) added a comment - 02/Mar/17 07:44 AM

Hello Aarati Sabnis / Vinayak Kulkarni,

Are there only 2 macros (Spouse Age & Child Age - according to the document attached with this JIRA) where the member type id becomes 2 or 3 (ie, the column gets the values for Spouse and Child) ?
Please let me know, are we supposed to see the Child and Spouse scenarios only with these 2 macros ? If No, please let us know which macros we have considered for this implementations - we can test them accordingly..

We can start testing further scenarios once above query is resolved.

CC - Rakesh Roy Prasad Pise Hrishikesh Deshpande Sachin Hingole Satya

Show

Alankar Chavan (Inactive) added a comment - 02/Mar/17 07:44 AM Hello Aarati Sabnis / Vinayak Kulkarni , Are there only 2 macros (Spouse Age & Child Age - according to the document attached with this JIRA) where the member type id becomes 2 or 3 (ie, the column gets the values for Spouse and Child) ? Please let me know, are we supposed to see the Child and Spouse scenarios only with these 2 macros ? If No, please let us know which macros we have considered for this implementations - we can test them accordingly.. We can start testing further scenarios once above query is resolved. CC - Rakesh Roy Prasad Pise Hrishikesh Deshpande Sachin Hingole Satya

Hide

Permalink

Vinayak Kulkarni (Inactive) added a comment - 02/Mar/17 08:00 AM

Hi Alankar,

This enhancement is related only for cobra events. So while doing analysis we tried to find out macros that can be used in cobra event builder and we came up with attached four macros.

So as of now, you should use only these given macros for testing. You are free to test with any non-macro fields like system fields, additional fields etc.

Please let us know if you have more questions on this. Thanks.

Show

Vinayak Kulkarni (Inactive) added a comment - 02/Mar/17 08:00 AM Hi Alankar, This enhancement is related only for cobra events. So while doing analysis we tried to find out macros that can be used in cobra event builder and we came up with attached four macros. So as of now, you should use only these given macros for testing. You are free to test with any non-macro fields like system fields, additional fields etc. Please let us know if you have more questions on this. Thanks.

Alankar Chavan (Inactive) made changes - 02/Mar/17 09:30 AM

Link

This issue relates to ~~WT-8681~~ [ ~~WT-8681~~ ]

Permalink

Alankar Chavan (Inactive) logged work - 02/Mar/17 01:50 PM - edited

Time Spent:

6h

LB Testing Started
New Issues : ~~WT-8681~~ ~~WT-8679~~

Alankar Chavan (Inactive) made changes - 02/Mar/17 01:50 PM

Time Spent	76h [ 273600 ]	82.5h [ 297000 ]
Worklog Id	28634 [ 28634 ]

Alankar Chavan (Inactive) made changes - 02/Mar/17 01:53 PM

Remaining Estimate	0h [ 0 ]	0.5h [ 1800 ]
Time Spent	82.5h [ 297000 ]	82h [ 295200 ]
Worklog Id	28634 [ 28634 ]

Alankar Chavan (Inactive) made changes - 03/Mar/17 06:43 AM

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

Alankar Chavan (Inactive) made changes - 03/Mar/17 06:44 AM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Alankar Chavan (Inactive) made changes - 03/Mar/17 06:44 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Hide

Permalink

Alankar Chavan (Inactive) added a comment - 03/Mar/17 11:38 AM

Hello Aniruddha Dev,

This enhancement is tested on WT Stage. Testing is completed at my end.
There were 2 issues observed ~~WT-8679~~ & ~~WT-8681~~. These are fixed and tested on WT Stage too.

Please do the needful export - Testing related to above enhancement, if working well - make it Ready for Stage.

CC - Aarati Sabnis Sheetal Bodhale Rakesh Roy Prasad Pise

Show

Alankar Chavan (Inactive) added a comment - 03/Mar/17 11:38 AM Hello Aniruddha Dev , This enhancement is tested on WT Stage. Testing is completed at my end. There were 2 issues observed WT-8679 & WT-8681 . These are fixed and tested on WT Stage too. Please do the needful export - Testing related to above enhancement, if working well - make it Ready for Stage. CC - Aarati Sabnis Sheetal Bodhale Rakesh Roy Prasad Pise

Alankar Chavan (Inactive) made changes - 03/Mar/17 11:39 AM

Assignee

Alankar Chavan [ alankar.chavan ]

Aniruddha Dev [ aniruddha.dev ]

Permalink

Alankar Chavan (Inactive) logged work - 03/Mar/17 01:46 PM

Time Spent:

2h

lb testing completed

Alankar Chavan (Inactive) made changes - 03/Mar/17 01:46 PM

Remaining Estimate	0.5h [ 1800 ]	0h [ 0 ]
Time Spent	82h [ 295200 ]	84h [ 302400 ]
Worklog Id	28980 [ 28980 ]

Vinayak Kulkarni (Inactive) made changes - 03/Mar/17 03:31 PM

Time Spent	84h [ 302400 ]	86h [ 309600 ]
Worklog Id	29040 [ 29040 ]

Permalink

Aniruddha Dev (Inactive) logged work - 03/Mar/17 07:49 PM

Time Spent:

1.5h

created Templates , Event builders, test Data and Test Scenarios to verify on 6th March

Permalink

Aniruddha Dev (Inactive) logged work - 06/Mar/17 11:12 AM

Time Spent:

2h

Verified Scenarios on LB

Hide

Permalink

Aniruddha Dev (Inactive) added a comment - 06/Mar/17 01:40 PM

Verified the implementation on LB on JE Dunn for HSPL company for New HR Simplied COBRA Templates with following scenarios.

1) Employee Termination
2) Employee Death
3) Employee Retirement
4) Divorce
5) Class Change

Testing is in progress with OAD and Class Change followed by Termination and more scenarios

Note: for Divorce scenario fix will get deploy tomorrow ~~WT-7303~~ . So will continue testing after that

Show

Aniruddha Dev (Inactive) added a comment - 06/Mar/17 01:40 PM Verified the implementation on LB on JE Dunn for HSPL company for New HR Simplied COBRA Templates with following scenarios. 1) Employee Termination 2) Employee Death 3) Employee Retirement 4) Divorce 5) Class Change Testing is in progress with OAD and Class Change followed by Termination and more scenarios Note : for Divorce scenario fix will get deploy tomorrow WT-7303 . So will continue testing after that

Hide

Permalink

Aniruddha Dev (Inactive) added a comment - 07/Mar/17 12:34 PM

Verified all listed scenarios in previous comment with different coverage tiers like

EE+ More than 2 CHN
EE+SP
EE+CH

Along with Divorce and OAD scenarios on JE Dunn for HSPL company on LB for COBRA data type template creating Event Builder for these scenarios. Cobra Coverage Tier Label exporting properly on COBRA file

Working as expected on LB . Ready for Stage

Show

Aniruddha Dev (Inactive) added a comment - 07/Mar/17 12:34 PM Verified all listed scenarios in previous comment with different coverage tiers like EE+ More than 2 CHN EE+SP EE+CH Along with Divorce and OAD scenarios on JE Dunn for HSPL company on LB for COBRA data type template creating Event Builder for these scenarios. Cobra Coverage Tier Label exporting properly on COBRA file Working as expected on LB . Ready for Stage

Aniruddha Dev (Inactive) made changes - 07/Mar/17 12:34 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)

Aniruddha Dev (Inactive) made changes - 07/Mar/17 12:34 PM

Item State

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

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

Aniruddha Dev (Inactive) made changes - 07/Mar/17 12:34 PM

Status

Local Testing [ 10200 ]

Pending for Stage Approval [ 10300 ]

Permalink

Aniruddha Dev (Inactive) logged work - 07/Mar/17 06:01 PM

Time Spent:

2.5h

Continued and completed remaining LB testing scenarios

Aarati Sabnis (Inactive) made changes - 08/Mar/17 04:47 AM

Developer

Aarati Sabnis [ aarati.sabnis ]

Akshay Mukkawar (Inactive) made changes - 08/Mar/17 05:20 AM

Code Review Date

28/Feb/2017

Khandu Kshirsagar (Inactive) made changes - 08/Mar/17 07:13 AM

Item State

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

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

Alankar Chavan (Inactive) made changes - 08/Mar/17 10:10 AM

Status

Pending for Stage Approval [ 10300 ]

Approved for Stage [ 10030 ]

Alankar Chavan (Inactive) made changes - 08/Mar/17 10:10 AM

Status

Approved for Stage [ 10030 ]

Stage Testing [ 10201 ]

Alankar Chavan (Inactive) made changes - 08/Mar/17 10:10 AM

Item State

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

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Hide

Permalink

Alankar Chavan (Inactive) added a comment - 08/Mar/17 10:12 AM

Hello Aniruddha Dev,

This enhancement is tested on Stage. Testing is completed at my end.

Please do the needful export - Testing related to above enhancement, if working well - make it Ready for Production.

CC - Aarati Sabnis Sheetal Bodhale Rakesh Roy Prasad Pise Hrishikesh Deshpande Vinayak Kulkarni

Show

Alankar Chavan (Inactive) added a comment - 08/Mar/17 10:12 AM Hello Aniruddha Dev , This enhancement is tested on Stage. Testing is completed at my end. Please do the needful export - Testing related to above enhancement, if working well - make it Ready for Production. CC - Aarati Sabnis Sheetal Bodhale Rakesh Roy Prasad Pise Hrishikesh Deshpande Vinayak Kulkarni

Hide

Permalink

Aniruddha Dev (Inactive) added a comment - 08/Mar/17 01:20 PM

Verified below scenarios on Stage for COBRA data Template by creating event builders

Termination
Divorce
Death
Retirement

All scenarios are working as expected and Cobra Coverage Tier Label exported as expected on COBRA file. Ready for Production

Show

Aniruddha Dev (Inactive) added a comment - 08/Mar/17 01:20 PM Verified below scenarios on Stage for COBRA data Template by creating event builders Termination Divorce Death Retirement All scenarios are working as expected and Cobra Coverage Tier Label exported as expected on COBRA file. Ready for Production

Aniruddha Dev (Inactive) made changes - 08/Mar/17 01:20 PM

Status

Stage Testing [ 10201 ]

Pending for Production Approval [ 10301 ]

Aniruddha Dev (Inactive) made changes - 08/Mar/17 01:20 PM

Item State

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

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

Permalink

Alankar Chavan (Inactive) logged work - 08/Mar/17 01:29 PM

Time Spent:

2h

stage testing of enhancement and related issue

Alankar Chavan (Inactive) made changes - 08/Mar/17 01:29 PM

Time Spent	86h [ 309600 ]	88h [ 316800 ]
Worklog Id	29781 [ 29781 ]

Permalink

Aniruddha Dev (Inactive) logged work - 08/Mar/17 05:08 PM

Time Spent:

2.5h

Stage scenario testing

Permalink

Aarati Sabnis (Inactive) logged work - 09/Mar/17 05:04 AM

Time Spent:

0.5h

Stage check-in

Aarati Sabnis (Inactive) made changes - 09/Mar/17 05:04 AM

Time Spent	88h [ 316800 ]	88.5h [ 318600 ]
Worklog Id	29853 [ 29853 ]

Aniruddha Dev (Inactive) made changes - 09/Mar/17 05:09 AM

Time Spent	88.5h [ 318600 ]	91h [ 327600 ]
Worklog Id	29862 [ 29862 ]

Aniruddha Dev (Inactive) made changes - 09/Mar/17 06:20 AM

Time Spent	91h [ 327600 ]	93.5h [ 336600 ]
Worklog Id	29911 [ 29911 ]

Ashwin Wankhede (Inactive) made changes - 09/Mar/17 07:12 AM

Item State

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

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Permalink

Aniruddha Dev (Inactive) logged work - 09/Mar/17 11:28 AM

Time Spent:

1h

Testing on production

Rakesh Roy (Inactive) made changes - 09/Mar/17 11:48 AM

Status

Pending for Production Approval [ 10301 ]

Approved for production [ 10034 ]

Rakesh Roy (Inactive) made changes - 09/Mar/17 11:48 AM

Status

Approved for production [ 10034 ]

Production Testing [ 10202 ]

Aniruddha Dev (Inactive) made changes - 09/Mar/17 12:47 PM

Item State

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Hide

Permalink

Aniruddha Dev (Inactive) added a comment - 09/Mar/17 12:52 PM

Verified below scenarios for COBRA DATA export template

Termination
Death
Divorce

Scenarios working as expected and COBRA Coverage tier label populating properly.

Hi Alankar Chavan,

Can Please check your scenarios as well and do the needful.

Regards,
Aniruddha Dev

Show

Aniruddha Dev (Inactive) added a comment - 09/Mar/17 12:52 PM Verified below scenarios for COBRA DATA export template Termination Death Divorce Scenarios working as expected and COBRA Coverage tier label populating properly. Hi Alankar Chavan , Can Please check your scenarios as well and do the needful. Regards, Aniruddha Dev

Aniruddha Dev (Inactive) made changes - 09/Mar/17 12:52 PM

Assignee	Aniruddha Dev [ aniruddha.dev ]	Alankar Chavan [ alankar.chavan ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Hide

Permalink

Alankar Chavan (Inactive) added a comment - 09/Mar/17 01:10 PM

This is tested on Production - Working as expected

CC - Aniruddha Dev Aarati Sabnis Vinayak Kulkarni Sheetal Bodhale Prasad Pise Hrishikesh Deshpande Sachin Hingole Rakesh Roy

Show

Alankar Chavan (Inactive) added a comment - 09/Mar/17 01:10 PM This is tested on Production - Working as expected CC - Aniruddha Dev Aarati Sabnis Vinayak Kulkarni Sheetal Bodhale Prasad Pise Hrishikesh Deshpande Sachin Hingole Rakesh Roy

Alankar Chavan (Inactive) made changes - 09/Mar/17 01:10 PM

Item State

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Alankar Chavan (Inactive) made changes - 09/Mar/17 01:11 PM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Permalink

Alankar Chavan (Inactive) logged work - 09/Mar/17 01:17 PM

Time Spent:

1.5h

prod testing
prod issue testing
closed

Alankar Chavan (Inactive) made changes - 09/Mar/17 01:17 PM

Time Spent	93.5h [ 336600 ]	95h [ 342000 ]
Worklog Id	30063 [ 30063 ]

Permalink

Aarati Sabnis (Inactive) logged work - 09/Mar/17 03:16 PM

Time Spent:

0.5h

Production check-in
Internal discussion with Ashwin

Aarati Sabnis (Inactive) made changes - 09/Mar/17 03:17 PM

Time Spent	95h [ 342000 ]	95.5h [ 343800 ]
Worklog Id	30105 [ 30105 ]

Aniruddha Dev (Inactive) made changes - 16/Mar/17 10:12 AM

Time Spent	95.5h [ 343800 ]	97.5h [ 351000 ]
Worklog Id	31637 [ 31637 ]

Aniruddha Dev (Inactive) made changes - 16/Mar/17 10:28 AM

Time Spent	97.5h [ 351000 ]	98.5h [ 354600 ]
Worklog Id	31646 [ 31646 ]

Aniruddha Dev (Inactive) made changes - 30/Mar/17 06:50 AM

Time Spent	98.5h [ 354600 ]	100h [ 360000 ]
Worklog Id		34591 [ 34591 ]

Transition	Time In Source Status	Execution Times

Aarati Sabnis (Inactive) made transition - 13/Feb/17 08:29 AM

New Request

Pending for Approval

32d 20h 5m

Aarati Sabnis (Inactive) made transition - 13/Feb/17 08:29 AM

Pending for Approval

Approved for Development

Aarati Sabnis (Inactive) made transition - 13/Feb/17 08:29 AM

Approved for Development

In Development

Alankar Chavan (Inactive) made transition - 03/Mar/17 06:43 AM

In LB Testing

Reopen in Local

2d 18h 42m

Alankar Chavan (Inactive) made transition - 03/Mar/17 06:44 AM

Reopen in Local

In Development

1m 15s

Alankar Chavan (Inactive) made transition - 03/Mar/17 06:44 AM

In Development

In LB Testing

15d 3h 31m

Aniruddha Dev (Inactive) made transition - 07/Mar/17 12:34 PM

In LB Testing

Pending for Stage Approval

4d 5h 49m

Alankar Chavan (Inactive) made transition - 08/Mar/17 10:10 AM

Pending for Stage Approval

Approved for Stage

21h 36m

Alankar Chavan (Inactive) made transition - 08/Mar/17 10:10 AM

Approved for Stage

Stage Testing

Aniruddha Dev (Inactive) made transition - 08/Mar/17 01:20 PM

Stage Testing

Pending for Production Approval

3h 10m

Rakesh Roy (Inactive) made transition - 09/Mar/17 11:48 AM

Pending for Production Approval

Approved for production

22h 27m

Rakesh Roy (Inactive) made transition - 09/Mar/17 11:48 AM

Approved for production

In Production Testing

Aniruddha Dev (Inactive) made transition - 09/Mar/17 12:52 PM

In Production Testing

Production Complete

1h 3m

Alankar Chavan (Inactive) made transition - 09/Mar/17 01:11 PM

Production Complete

Closed

18m 56s

People

Assignee:: Alankar Chavan (Inactive)

Reporter:: Satya

Developer:: Aarati Sabnis (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 11/Jan/17 12:23 PM

Updated:: 30/Mar/17 06:50 AM

Resolved:: 24/Feb/17 09:52 AM

Dev Due Date:: 28/Feb/2017

Code Review Date:: 28/Feb/2017

Time Tracking

Estimated:

70h

Remaining:

Logged:

100h