-
Type:
Enhancement
-
Status: Closed
-
Priority:
Critical
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Module:BenAdmin - Export
-
Reported by:Support
-
Item State:Production Complete - Closed
-
Issue Importance:Must Have
-
Sprint:WT Sprint 34 - Enhancements, WT Sprint 36 - Enhancement
-
Feature Category:New
-
Severity:Simple
-
Reported by Customer:Abhay Patil
Rule Engine: Ability to specify a field (rather than a hard coded value) as result.
This is a top priority requirement.
- causes
-
WT-10951 Export > Rule Engine - FIELD as RESULT > 'Select Field Name' drop down Is getting displayed in empty space on ANSI 834 Template
-
- Closed
-
-
-
- Closed
-
- is cloned by
-
-
- Resolution Setting
-
- is duplicated by
-
-
- Closed
-
| Field | Original Value | New Value |
|---|---|---|
| Description |
*Rule Engine: Ability to specify a field (rather than a hard coded value) as result. * {color:#d04437}This is a top priority requirement.{color} |
*Rule Engine: Ability to specify a field (rather than a hard coded value) as result. * {color:#d04437}This is a top priority requirement.{color} [~samir] [~amitthorve] [~Cindy.Wibbing] |
| Description |
*Rule Engine: Ability to specify a field (rather than a hard coded value) as result. * {color:#d04437}This is a top priority requirement.{color} [~samir] [~amitthorve] [~Cindy.Wibbing] |
*Rule Engine: Ability to specify a field (rather than a hard coded value) as result.* {color:#d04437}This is a top priority requirement.{color} [~samir] [~amitthorve] [~Cindy.Wibbing] |
| Assignee | Vijay Siddha [ vijays ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
| Module | Parent values: BenAdmin(10100)Level 1 values: Customization(10113) | Parent values: BenAdmin(10100)Level 1 values: Export(10110) |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT Sprint 33 - Enhancement [ 78 ] |
| Dev Due Date | 28/Jul/2017 |
-
- Time Spent:
- 3.5h
-
1)Discussion and analysis
| Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Rakesh Shahane [ rakesh.shahane ] |
| Status | New Request [ 10029 ] | Pending for Approval [ 10002 ] |
| Status | Pending for Approval [ 10002 ] | Approved for Development [ 10003 ] |
| Status | Approved for Development [ 10003 ] | In Development [ 10007 ] |
| Item State | Parent values: Development(10200) | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
| Dev Estimates | 70 | |
| Remaining Estimate | 70h [ 252000 ] | |
| Original Estimate | 70h [ 252000 ] |
| Remaining Estimate | 70h [ 252000 ] | 66.5h [ 239400 ] |
| Time Spent | 3.5h [ 12600 ] | |
| Worklog Id | 66971 [ 66971 ] |
-
- Time Spent:
- 8h
-
1)7h Analysis.
2)1h Development discussion.
| Remaining Estimate | 66.5h [ 239400 ] | 58.5h [ 210600 ] |
| Time Spent | 3.5h [ 12600 ] | 11.5h [ 41400 ] |
| Worklog Id | 66988 [ 66988 ] |
-
- Time Spent:
- 2h
-
Internal Discussion and Design Team Meeting.
| Remaining Estimate | 58.5h [ 210600 ] | 57.5h [ 207000 ] |
| Time Spent | 11.5h [ 41400 ] | 12.5h [ 45000 ] |
| Worklog Id | 67759 [ 67759 ] |
-
- Time Spent:
- 4h 5m
-
1)WBS creation.
2)Analysis document Creation.
| Remaining Estimate | 57.5h [ 207000 ] | 53h 24m [ 192241 ] |
| Time Spent | 12.5h [ 45000 ] | 16h 35m [ 59759 ] |
| Worklog Id | 68164 [ 68164 ] |
| Attachment | WT-9237 Rule Engine - FIELD as RESULT.doc [ 57223 ] |
| Attachment | RuleEnginFieldAsResult_WBS.xls [ 57224 ] |
-
- Time Spent:
- 2h
-
1)WBS document review.
2)WBS document Review correction.
| Remaining Estimate | 53h 24m [ 192241 ] | 51h 24m [ 185041 ] |
| Time Spent | 16h 35m [ 59759 ] | 18h 35m [ 66959 ] |
| Worklog Id | 68319 [ 68319 ] |
| Remaining Estimate | 51h 24m [ 185041 ] | 49h 24m [ 177841 ] |
| Time Spent | 18h 35m [ 66959 ] | 20h 35m [ 74159 ] |
| Worklog Id | 68326 [ 68326 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: On Hold(10207) |
| Remaining Estimate | 49h 24m [ 177841 ] | 42h 24m [ 152641 ] |
| Time Spent | 20h 35m [ 74159 ] | 27h 35m [ 99359 ] |
| Worklog Id | 68780 [ 68780 ] |
| Assignee | Rakesh Shahane [ rakesh.shahane ] | Rajendra Pawar [ rajendra.pawar ] |
| Account Executive | Abhay Patil [ abhay.patil ] | |
| Dev Due Date | 28/Jul/2017 | |
| Dev Estimates | 70 | 174 |
| Developer | Rajendra Pawar [ rajendra.pawar ] | |
| 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 ] | |
| Reported by Customer | Abhay Patil | |
| Remaining Estimate | 42h 24m [ 152641 ] | 0h [ 0 ] |
| Original Estimate | 70h [ 252000 ] | 174h [ 626400 ] |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT Sprint 33 - Enhancement [ 78 ] | WT Sprint 34 - Enhancements [ 80 ] |
| Time Spent | 27h 35m [ 99359 ] | 35h 35m [ 128159 ] |
| Worklog Id | 70253 [ 70253 ] |
| Time Spent | 35h 35m [ 128159 ] | 43h 5m [ 155159 ] |
| Worklog Id | 70564 [ 70564 ] |
| Time Spent | 43h 5m [ 155159 ] | 51h 5m [ 183959 ] |
| Worklog Id | 70581 [ 70581 ] |
| Time Spent | 51h 5m [ 183959 ] | 59h 5m [ 212759 ] |
| Worklog Id | 70582 [ 70582 ] |
| Time Spent | 59h 5m [ 212759 ] | 67h 5m [ 241559 ] |
| Worklog Id | 70909 [ 70909 ] |
| Dev Due Date | 25/Aug/2017 |
| Dev Due Date | 25/Aug/2017 | 30/Aug/2017 |
| Time Spent | 67h 5m [ 241559 ] | 75h 5m [ 270359 ] |
| Worklog Id | 71230 [ 71230 ] |
| Time Spent | 75h 5m [ 270359 ] | 83h 5m [ 299159 ] |
| Worklog Id | 71493 [ 71493 ] |
| Time Spent | 83h 5m [ 299159 ] | 91h 5m [ 327959 ] |
| Worklog Id | 72045 [ 72045 ] |
| Time Spent | 91h 5m [ 327959 ] | 99h 5m [ 356759 ] |
| Worklog Id | 72046 [ 72046 ] |
| Time Spent | 99h 5m [ 356759 ] | 100h 5m [ 360359 ] |
| Worklog Id | 72221 [ 72221 ] |
| Time Spent | 100h 5m [ 360359 ] | 101h 5m [ 363959 ] |
| Worklog Id | 72878 [ 72878 ] |
| Time Spent | 101h 5m [ 363959 ] | 109h 5m [ 392759 ] |
| Worklog Id | 72918 [ 72918 ] |
| Time Spent | 109h 5m [ 392759 ] | 115h 5m [ 414359 ] |
| Worklog Id | 73116 [ 73116 ] |
| Time Spent | 115h 5m [ 414359 ] | 123h 5m [ 443159 ] |
| Worklog Id | 74014 [ 74014 ] |
| Time Spent | 123h 5m [ 443159 ] | 131h 5m [ 471959 ] |
| Worklog Id | 74015 [ 74015 ] |
| Time Spent | 131h 5m [ 471959 ] | 139h 5m [ 500759 ] |
| Worklog Id | 74016 [ 74016 ] |
Gaurav Sodani (Inactive)
made changes -
| Sprint | WT Sprint 34 - Enhancements [ 80 ] | WT Sprint 34 - Enhancements, WT Sprint 36 - Enhancement [ 80, 85 ] |
We are considering implementation in ANSI member level details page and DTS on rule engine page for DTS applicable fields. So changing Dev Due Date to 01-August-2017.
| Dev Due Date | 30/Aug/2017 | 01/Sep/2017 |
| Time Spent | 139h 5m [ 500759 ] | 146h 35m [ 527759 ] |
| Worklog Id | 74488 [ 74488 ] |
| Time Spent | 146h 35m [ 527759 ] | 146h 55m [ 528959 ] |
| Worklog Id | 74489 [ 74489 ] |
| Time Spent | 146h 55m [ 528959 ] | 154h 55m [ 557759 ] |
| Worklog Id | 74835 [ 74835 ] |
| Time Spent | 154h 55m [ 557759 ] | 155h 55m [ 561359 ] |
| Worklog Id | 74891 [ 74891 ] |
| Time Spent | 155h 55m [ 561359 ] | 163h 25m [ 588359 ] |
| Worklog Id | 75455 [ 75455 ] |
| Time Spent | 163h 25m [ 588359 ] | 170h 55m [ 615359 ] |
| Worklog Id | 75460 [ 75460 ] |
| Time Spent | 170h 55m [ 615359 ] | 171h 25m [ 617159 ] |
| Worklog Id | 76177 [ 76177 ] |
| Attachment | WT-9237 Affected Files.txt [ 60347 ] |
| Time Spent | 171h 25m [ 617159 ] | 179h 25m [ 645959 ] |
| Worklog Id | 76374 [ 76374 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: Ready for Review(10208) |
| Attachment | Rule Engine Fields.xls [ 60516 ] |
Below are the Note :
1) Current all Live feeds rule engine will work as it is.
2) Only direct database and additional fields are working currently (Please see attached fileRule Engine Fields.xls
).
3) DTS feature has been provided for available direct DTS applicable fields at rule engine page.
4) ANSI member level details conditional rule engine has been implemented as per new approach.
5) Macro fields will not work, we will plan them after some days.
6) For Date type fields, specified date format has been applied as per settings.
7) Amount with decimal has also been applied for applicable fields.
| Code Review Date | 04/Sep/2017 | |
| Code Reviewed By | Vinalyak Kulkarni [ 12100 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: Ready for Review(10208) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Time Spent | 179h 25m [ 645959 ] | 187h 25m [ 674759 ] |
| Worklog Id | 76646 [ 76646 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Assignee | Rajendra Pawar [ rajendra.pawar ] | Aniruddha Dev [ aniruddha.dev ] |
Testing is in progress with Comparison of Current Live feeds on Production and same company templates on LB after deploying this implementation
| Production Due Date | 21/Sep/2017 | |
| QA Estimates | 60 | |
| Stage Due Date | 18/Sep/17 [ 2017-09-18 ] |
| Time Spent | 187h 25m [ 674759 ] | 189h 25m [ 681959 ] |
| Worklog Id | 76869 [ 76869 ] |
| Attachment | Rule Engines as Field Result_Test Scenarios .xls [ 60838 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Stage Due Date | 18/Sep/17 [ 2017-09-18 ] | 20/Sep/17 [ 2017-09-20 ] |
Testing is in Progress with All types of fields as a result along with DTS. Will update tomorrow
| Stage Due Date | 20/Sep/17 [ 2017-09-20 ] | 22/Sep/17 [ 2017-09-22 ] |
| Production Due Date | 21/Sep/2017 | 26/Sep/2017 |
-
- Time Spent:
- 4.5h
-
verifying this on LB , Logging issues, discussion
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
| Time Spent | 189h 25m [ 681959 ] | 193h 55m [ 698159 ] |
| Worklog Id | 80079 [ 80079 ] |
| Worklog Id | 80079 [ 80079 ] |
| Time Spent | 193h 55m [ 698159 ] | 196h 25m [ 707159 ] |
| Worklog Id | 80090 [ 80090 ] |
| Time Spent | 196h 25m [ 707159 ] | 198h 55m [ 716159 ] |
| Worklog Id | 80139 [ 80139 ] |
Verified this implementation and its bug fixes for Field As a Result on Rule Engine for random fields of in attached sheet on Rowise, Columnwise , ANSI 834 File types . Fields are getting exported as per mapped rule engine. Working as expected on LB . Ready for Stage
| 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) |
| Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
| Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
| Time Spent | 198h 55m [ 716159 ] | 199h 55m [ 719759 ] |
| Worklog Id | 80413 [ 80413 ] |
| Worklog Id | 80413 [ 80413 ] |
Khandu Kshirsagar (Inactive)
made changes -
| 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) |
-
- Time Spent:
- 1h
-
Stage code check in
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
| Time Spent | 199h 55m [ 719759 ] | 201h 55m [ 726959 ] |
| Worklog Id | 80807 [ 80807 ] |
| Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
| 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) |
Verified this implementation on stage. Working as expected. Ready for Production
| Time Spent | 201h 55m [ 726959 ] | 202h 55m [ 730559 ] |
| Worklog Id | 81249 [ 81249 ] |
| Worklog Id | 81249 [ 81249 ] |
Khandu Kshirsagar (Inactive)
made changes -
| 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) |
| Time Spent | 202h 55m [ 730559 ] | 205h 25m [ 739559 ] |
| Worklog Id | 81279 [ 81279 ] |
| Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
| Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
-
- Time Spent:
- 1h
-
Production Code check in
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
Hi Abhay Patil ,
We have deployed and verified this implementation on Production Today . You may now close this JIRA.
Note: Only direct database and additional fields are working for this implementation as of now.
Please let us know in case of any queries/issues .
Thanks & Regards,
Aniruddha Dev
| Assignee | Aniruddha Dev [ aniruddha.dev ] | Abhay Patil [ abhay.patil ] |
| Resolution | Done [ 10000 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Resolution | Done [ 10000 ] | Fixed [ 1 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Time Spent | 205h 25m [ 739559 ] | 206h 55m [ 744959 ] |
| Worklog Id | 82269 [ 82269 ] |
| Time Spent | 206h 55m [ 744959 ] | 207h 55m [ 748559 ] |
| Worklog Id | 82283 [ 82283 ] |
| Worklog Id | 82283 [ 82283 ] |
Hi Alex Nguyen,
Here is the new enhancement that you can use for Dakotaland's Lincoln file.
Thanks, Van. I already finished building the file and sent it off. I decided not to send any of the dependents on file, because it's not required. Only the plans were sent, but if carrier requires them then I will look into getting the spouse to come out on file with the new enhancement.
Alex
| Transition | Time In Source Status | Execution Times |
|---|
|
98d 12h 6m | 1 |
|
4s | 1 |
|
2s | 1 |
|
40d 28m | 1 |
|
16d 20h 27m | 1 |
|
21h 48m | 1 |
|
7h 26m | 1 |
|
2d 23h 22m | 1 |
|
17h 47m | 1 |
|
2s | 1 |
|
5h 15m | 1 |
|
1d 10h 42m | 1 |
Analysis done and WBS is attached, would pick this up in upcoming sprint. Thanks.