[WT-2490] Change Reason And Date Time For Election Moved to stored Proc - Workterra Jira

Details

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

Environment:

Production
Module:
BenAdmin - Export
Reported by:
Support
Item State:
Production QA - In Testing
Sprint:
Bugs - In Progress

Description

Concern: Election Change Reason field not exporting reason at time enrollment when its pending for approval

Cause: Election Change Reason is export reason according current enrollment mode and qualifying event.

Correction: We have implemented new below macro to achive this.

1) Enrollment Election Change Reason Of Review Pending:
This field will export reason when enrollment done if its pending for approval, other wise it will work like
(Election Change Reason) exporting reason according to current enrollment.

2) Enrollment Qualifying Event Date of Review Pending:

1) If enrollment is new hire then it will export Employment Date.
2) if enrollment is Re-hire Enrollment and employee status is also rehire, then it will export Rehire Date
3) if enrollment is done using Qualifying Event then event date will export
4) if enrollment done with review change approval mode then it will export date of history according to above scenario

Attachments

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

Attachments

WT-2490 Scenario.xls
10 kB
31/May/16 12:20 PM

Issue Links

relates to

WT-1763 University of Notre Dame-QE Banner Payroll

Closed

Activity

Ascending order - Click to sort in descending order

Rakesh Shahane (Inactive) created issue - 17/May/16 08:51 AM

Rakesh Shahane (Inactive) made changes - 17/May/16 08:51 AM

Field	Original Value	New Value
Assignee	Satya [ ID10004 ]	Rakesh Shahane [ rakesh.shahane ]

Rakesh Shahane (Inactive) made changes - 17/May/16 08:53 AM

Summary

Change Reason And Date Time For Election MOved to stored Proc

Change Reason And Date Time For Election Moved to stored Proc

Rakesh Shahane (Inactive) made changes - 19/May/16 05:17 AM

Item State

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

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

Rakesh Shahane (Inactive) made changes - 19/May/16 12:38 PM

Issue Type	Enhancement [ 4 ]	Bug [ 1 ]
Status	New Request [ 10029 ]	Open [ 1 ]
Workflow	WT_Features [ 16600 ]	WT_Defects [ 16705 ]

Rakesh Shahane (Inactive) made changes - 19/May/16 12:39 PM

Dev Due Date

23/May/2016

Rakesh Shahane (Inactive) made changes - 19/May/16 12:43 PM

Link

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

sam lindberg (Inactive) made changes - 19/May/16 12:58 PM

Priority

Medium [ 3 ]

High [ 2 ]

Aniruddha Dev (Inactive) made changes - 20/May/16 05:11 AM

Production Due Date		26/May/2016
QA Due Date		24/May/2016
Stage Due Date		25/May/16 [ 2016-05-25 ]

Rakesh Shahane (Inactive) made changes - 20/May/16 02:03 PM

Status

Open [ 1 ]

In Development [ 10007 ]

Rakesh Shahane (Inactive) made changes - 23/May/16 06:56 AM

Assignee

Rakesh Shahane [ rakesh.shahane ]

Rohan Khandave [ rohan.khandave ]

Rohan J Khandave (Inactive) made changes - 25/May/16 05:57 AM

Item State

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

Parent values: Development(10200)Level 1 values: On Hold(10207)

Rohan J Khandave (Inactive) made changes - 25/May/16 06:37 AM

Assignee

Rohan Khandave [ rohan.khandave ]

Ganesh Sadawarte [ ganesh.sadawarte ]

Ganesh Sadawarte (Inactive) made changes - 25/May/16 06:43 AM

Developer		Ganesh Sadawarte [ ganesh.sadawarte ]
Item State	Parent values: Development(10200)Level 1 values: On Hold(10207)	Parent values: Development(10200)Level 1 values: In Progress(10206)
QA		Aniruddha Dev [ aniruddha.dev ]

sam lindberg (Inactive) made changes - 25/May/16 11:25 AM

Priority

High [ 2 ]

Highest [ 1 ]

Rohan J Khandave (Inactive) made changes - 25/May/16 11:29 AM

Dev Due Date

23/May/2016

27/May/2016

Rohan J Khandave (Inactive) made changes - 25/May/16 11:29 AM

QA Due Date

24/May/2016

01/Jun/2016

Rohan J Khandave (Inactive) made changes - 25/May/16 11:29 AM

QA Due Date

01/Jun/2016

31/May/2016

Rohan J Khandave (Inactive) made changes - 25/May/16 11:33 AM

Stage Due Date

25/May/16 [ 2016-05-25 ]

1/Jun/16 [ 2016-06-01 ]

Rohan J Khandave (Inactive) made changes - 25/May/16 11:34 AM

Production Due Date

26/May/2016

02/Jun/2016

Satya made changes - 26/May/16 10:39 AM

Sprint

Bugs - In Progress [ 17 ]

Ganesh Sadawarte (Inactive) made changes - 27/May/16 06:32 AM

Item State

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

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Ganesh Sadawarte (Inactive) made changes - 27/May/16 09:54 AM

Description

*Concern*: Election Change Reason field not exporting reason at time enrollment when its pending for approval

*Cause*: Election Change Reason is export reason according current enrollment mode and qualifying event.

*Correction*: We have implemented new below macro to achive this.

  1) Enrollment Election Change Reason Of Review Pending:
      This field will export reason when enrollment done if its pending for approval, other wise it will work like
      (Election Change Reason) exporting reason according to current enrollment.

  2) Enrollment Qualifying Event Date of Review Pending:

       1) If enrollment is new hire then it will export Employment Date.
       2) if enrollment is Re-hire Enrollment and employee status is also rehire, then it will export Rehire Date
      3) if enrollment is done using Qualifying Event then event data will export
       4) if enrollment done with review change approval mode then it will export date of history according to above scenario

Ganesh Sadawarte (Inactive) made changes - 27/May/16 09:55 AM

Code Reviewed By		Rohan Khandave [ 11903 ]
Environment		Production [ 10005 ]

Ganesh Sadawarte (Inactive) made changes - 27/May/16 12:41 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Ganesh Sadawarte (Inactive) made changes - 27/May/16 12:41 PM

Item State

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

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

Ganesh Sadawarte (Inactive) made changes - 27/May/16 12:42 PM

Assignee

Ganesh Sadawarte [ ganesh.sadawarte ]

Aniruddha Dev [ aniruddha.dev ]

Aniruddha Dev (Inactive) made changes - 30/May/16 01:44 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)

Ganesh Sadawarte (Inactive) made changes - 31/May/16 10:39 AM

Description

*Concern*: Election Change Reason field not exporting reason at time enrollment when its pending for approval

*Cause*: Election Change Reason is export reason according current enrollment mode and qualifying event.

*Correction*: We have implemented new below macro to achive this.

  1) Enrollment Election Change Reason Of Review Pending:
      This field will export reason when enrollment done if its pending for approval, other wise it will work like
      (Election Change Reason) exporting reason according to current enrollment.

  2) Enrollment Qualifying Event Date of Review Pending:

       1) If enrollment is new hire then it will export Employment Date.
       2) if enrollment is Re-hire Enrollment and employee status is also rehire, then it will export Rehire Date
      3) if enrollment is done using Qualifying Event then event date will export
       4) if enrollment done with review change approval mode then it will export date of history according to above scenario

Aniruddha Dev (Inactive) made changes - 31/May/16 12:15 PM

Comment

[ Hi,

Verified the scenarios attached in for Rowise and Column wise Templates and observed a doubtful scenario for #9 as below for Qualifying Event _ Divorce. Where the value getting exported for 'Enrollment Election Change Reason Of Review Pending'
'Employee Data Change' and for 'Enrollment Qualifying Event Date of Review Pending ' is enrollment effective date. ]

Aniruddha Dev (Inactive) made changes - 31/May/16 12:20 PM

Attachment

WT-2490 Scenario.xls [ 18833 ]

Aniruddha Dev (Inactive) made changes - 31/May/16 12:21 PM

Assignee

Aniruddha Dev [ aniruddha.dev ]

Ganesh Sadawarte [ ganesh.sadawarte ]

Aniruddha Dev (Inactive) made changes - 31/May/16 12:22 PM

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

Aniruddha Dev (Inactive) made changes - 31/May/16 12:22 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)

Ganesh Sadawarte (Inactive) made changes - 01/Jun/16 01:51 PM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Ganesh Sadawarte (Inactive) made changes - 01/Jun/16 01:51 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Ganesh Sadawarte (Inactive) made changes - 01/Jun/16 01:51 PM

Assignee

Ganesh Sadawarte [ ganesh.sadawarte ]

Aniruddha Dev [ aniruddha.dev ]

Aniruddha Dev (Inactive) made changes - 02/Jun/16 05:40 AM

Item State

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

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

Aniruddha Dev (Inactive) made changes - 02/Jun/16 05:41 AM

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)

Ganesh Sadawarte (Inactive) made changes - 02/Jun/16 08:56 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Ganesh Sadawarte (Inactive) made changes - 02/Jun/16 08:57 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)

Aniruddha Dev (Inactive) made changes - 02/Jun/16 01:07 PM

Item State

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

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

Aniruddha Dev (Inactive) made changes - 02/Jun/16 01:07 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)

Ganesh Sadawarte (Inactive) made changes - 03/Jun/16 07:09 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)

Ganesh Sadawarte (Inactive) made changes - 03/Jun/16 07:09 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Aniruddha Dev (Inactive) made changes - 03/Jun/16 12:39 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)

Aniruddha Dev (Inactive) made changes - 03/Jun/16 12:40 PM

Resolution		Fixed [ 1 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Aniruddha Dev (Inactive) made changes - 03/Jun/16 12:42 PM

Assignee

Aniruddha Dev [ aniruddha.dev ]

sam lindberg [ sam.lindberg@ebsbenefits.com ]

Shubhankar Joshi (Inactive) made changes - 06/Jun/16 06:04 AM

Assignee

sam lindberg [ sam.lindberg@ebsbenefits.com ]

Aniruddha Dev [ aniruddha.dev ]

Aniruddha Dev (Inactive) made changes - 06/Jun/16 08:11 AM

Assignee

Aniruddha Dev [ aniruddha.dev ]

Damion Velasquez [ damion.velasquez ]

Damion M Velasquez made changes - 06/Jun/16 03:42 PM

Assignee

Damion Velasquez [ damion.velasquez ]

Aniruddha Dev [ aniruddha.dev ]

Damion M Velasquez made changes - 07/Jun/16 06:28 PM

Assignee

Aniruddha Dev [ aniruddha.dev ]

Damion Velasquez [ damion.velasquez ]

Damion M Velasquez made changes - 07/Jun/16 06:28 PM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Satya made changes - 04/Nov/17 06:40 AM

Environment_New

Production [ 18442 ]

People

Assignee:: Damion M Velasquez

Reporter:: Rakesh Shahane (Inactive)

Developer:: Ganesh Sadawarte (Inactive)

QA:: Aniruddha Dev (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 17/May/16 08:51 AM

Updated:: 04/Nov/17 06:40 AM

Resolved:: 03/Jun/16 12:40 PM

Dev Due Date:: 27/May/2016

Pre-Prod Due Date:: 01/Jun/2016

Production Due Date:: 02/Jun/2016