-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Environment:Production
-
Bug Severity:Medium
-
Module:BenAdmin - Enrollment
-
Reported by:Support
-
Company:Town of Cary
-
Item State:Production Complete - Closed
Hi,
Attached is the original payroll file exported from the global template called _Town of Cary Payroll Export.and the correct payroll file based on the enrollments in Workterra.
There are records exporting on the file that are unexpected. I have highlighted in yellow these records and added comments.
Thanks!
Cindy
- relates to
-
-
- Closed
-
| Field | Original Value | New Value |
|---|---|---|
| Component/s | BenAdmin [ 10000 ] |
| Description |
Hi, Attached is the original payroll file exported from the template called _Town of Cary Payroll Export.and the correct payroll file based on the enrollments in Workterra. There are records exporting on the file that are exporting on the file that are unexpected. I have highlighted in yellow these records and added comments. Thanks! Cindy |
Hi, Attached is the original payroll file exported from the global template called _Town of Cary Payroll Export.and the correct payroll file based on the enrollments in Workterra. There are records exporting on the file that are exporting on the file that are unexpected. I have highlighted in yellow these records and added comments. Thanks! Cindy |
| Description |
Hi, Attached is the original payroll file exported from the global template called _Town of Cary Payroll Export.and the correct payroll file based on the enrollments in Workterra. There are records exporting on the file that are exporting on the file that are unexpected. I have highlighted in yellow these records and added comments. Thanks! Cindy |
Hi, Attached is the original payroll file exported from the global template called _Town of Cary Payroll Export.and the correct payroll file based on the enrollments in Workterra. There are records exporting on the file that are unexpected. I have highlighted in yellow these records and added comments. Thanks! Cindy |
| Module | Parent values: BenAdmin(10100) | Parent values: BenAdmin(10100)Level 1 values: Export(10110) |
| Assignee | Sonali Punse [ sonali.punse ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Jyoti Mayne [ jyoti.mayne ] |
| Status | In Progress [ 3 ] | Open [ 1 ] |
Thank you!
| Remaining Estimate | 4h [ 14400 ] | |
| Original Estimate | 4h [ 14400 ] |
| Remaining Estimate | 4h [ 14400 ] | 2h [ 7200 ] |
| Time Spent | 2h [ 7200 ] | |
| Worklog Id | 26079 [ 26079 ] |
Hello Cindy Wibbing,
Due to short of bandwidth, we were unable to work on this task. We will update you once we schedule it.
Cc: Satya, Jaideep Vinchurkar
| Module | Parent values: BenAdmin(10100)Level 1 values: Export(10110) | Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107) |
| Attachment | TOC Payroll201703151647 original without names.xls [ 42359 ] |
| Attachment | TOC Payroll201703151647 original without names corrected and sent to client.xls [ 42360 ] |
Hi,
I have attached additional examples of files. Do you have an ETA on this. Currently this is a manual process.
Thanks!
Cindy
| Issue Type | Support Activity [ 10301 ] | Bug [ 1 ] |
| Support Task Type | Customization [ 11204 ] | |
| Workflow | WT_Support [ 32675 ] | WT_Defects [ 35014 ] |
| Assignee | Jyoti Mayne [ jyoti.mayne ] | Umesh Kadam [ umesh.kadam ] |
Thank you!
| Remaining Estimate | 2h [ 7200 ] | 0h [ 0 ] |
| Time Spent | 2h [ 7200 ] | 12h [ 43200 ] |
| Worklog Id | 34373 [ 34373 ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Dev Due Date | 05/Apr/2017 | |
| Developer | Umesh Kadam [ umesh.kadam ] | |
| Issue Category | EBS [ 10350 ] | Harbinger [ 10700 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
| Time Spent | 12h [ 43200 ] | 12.5h [ 45000 ] |
| Worklog Id | 36406 [ 36406 ] |
| Time Spent | 12.5h [ 45000 ] | 15.5h [ 55800 ] |
| Worklog Id | 36407 [ 36407 ] |
| Remaining Estimate | 0h [ 0 ] | 10h [ 36000 ] |
| Time Spent | 15.5h [ 55800 ] | 5.5h [ 19800 ] |
| Worklog Id | 34373 [ 34373 ] | |
| Worklog Time Spent | 10h [ 36000 ] |
| Issue Category | Harbinger [ 10700 ] | EBS [ 10350 ] |
-
- Time Spent:
- 1h
-
scenario discussion and code review, unit testing discussion
-
- Time Spent:
- 7h
-
Code debugging
Discussion with Jyoti and Amruta
| Code Review Date | 06/Apr/2017 | |
| Code Reviewed By | Jyoti Mayne [ 11910 ] | |
| Dev Due Date | 05/Apr/2017 | 07/Apr/2017 |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
| Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: Ready for Review(10208) |
| Item State | Parent values: Development(10200)Level 1 values: Ready for Review(10208) | Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) |
Khandu Kshirsagar (Inactive)
made changes -
| 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) |
| Attachment | Affected_Files_WT_8485.txt [ 44755 ] |
Hi Prasad Pise,
Please find 3Cs given by Vinayak Kulkarni above. We have done code fix for this issue. Please find affected areas below :
- Enroll Now scenarios for Force Contingency.
- Pending Queue scenarios for parent and child plans.
- Demographic changes while elections are pended/approved.
Thanks and Regards,
:: Umesh Kadam
CC : Jyoti Mayne, Vinayak Kulkarni
| Assignee | Umesh Kadam [ umesh.kadam ] | Prasad Pise [ prasadp ] |
| Assignee | Prasad Pise [ prasadp ] | Alankar Chavan [ alankar.chavan ] |
| Remaining Estimate | 10h [ 36000 ] | 9.75h [ 35100 ] |
| Time Spent | 5.5h [ 19800 ] | 5.75h [ 20700 ] |
| Worklog Id | 37047 [ 37047 ] |
| Remaining Estimate | 9.75h [ 35100 ] | 2.75h [ 9900 ] |
| Time Spent | 5.75h [ 20700 ] | 12.75h [ 45900 ] |
| Worklog Id | 37055 [ 37055 ] |
| Worklog Id | 37055 [ 37055 ] |
| Production Due Date | 20/Apr/2017 | |
| Stage Due Date | 17/Apr/17 [ 2017-04-17 ] |
| Assignee | Alankar Chavan [ alankar.chavan ] | Mandar Kulkarni [ mandark ] |
Please get me the refreshed copy of Town of Cary from production to LB for testing.
The company which is existing on the LB is too old and doesn't have new plans as well for proper testing, also as per my discussion with Umesh, we don't know whether the correction script has been executed on LB company or not.
So, please get the refreshed company down on LB for testing.
Thanks,
Prashant
-----------------------------------------------
Mandar Kulkarni Umesh Kadam
-
- Time Spent:
- 5.5h
-
Testing of all the scenarios is in progress,
current scenarios tested :
Scenarios Tested Till Now : Current Scenarios tested.xlsDiscussion with Hrishikesh for the tested scenarios - Consulting with Umesh for the requrired test cases.
All the cases tested are updated on the ticket
| Attachment | Scenarios Tested Till Now.PNG [ 45028 ] |
| Attachment | Scenarios Tested Till Now.PNG [ 45028 ] |
| Attachment | Scenarios Tested Till Now.PNG [ 45030 ] |
Testing of all the scenarios is in progress,
current scenarios tested :
!Scenarios Tested Till Now : Current Scenarios tested.xls
Thanks,
Prashant
| Attachment | Current Scenarios tested.xls [ 45032 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Assignee | Mandar Kulkarni [ mandark ] | Prashant Samal [ prashant.samal ] |
| Remaining Estimate | 2.75h [ 9900 ] | 2.25h [ 8100 ] |
| Time Spent | 12.75h [ 45900 ] | 13.25h [ 47700 ] |
| Worklog Id | 37831 [ 37831 ] |
| Remaining Estimate | 2.25h [ 8100 ] | 1.75h [ 6300 ] |
| Time Spent | 13.25h [ 47700 ] | 13.75h [ 49500 ] |
| Worklog Id | 37831 [ 37831 ] |
| Assignee | Prashant Samal [ prashant.samal ] | Vijay Siddha [ vijays ] |
| Assignee | Vijay Siddha [ vijays ] | Hrishikesh Deshpande [ hrishikesh.deshpande ] |
| Attachment | Scenarios tested.xls [ 45331 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Remaining Estimate | 1.75h [ 6300 ] | 0h [ 0 ] |
| Time Spent | 13.75h [ 49500 ] | 19.25h [ 69300 ] |
| Worklog Id | 38243 [ 38243 ] |
| Stage Due Date | 17/Apr/17 [ 2017-04-17 ] | 18/Apr/17 [ 2017-04-18 ] |
| Production Due Date | 20/Apr/2017 | 19/Apr/2017 |
| Time Spent | 19.25h [ 69300 ] | 19h 25m [ 69900 ] |
| Worklog Id | 38853 [ 38853 ] |
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) |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
This is working as expected on Stage. Ready for Production.
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| Time Spent | 19h 25m [ 69900 ] | 21h 25m [ 77100 ] |
| Worklog Id | 39615 [ 39615 ] |
| 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 | 21h 25m [ 77100 ] | 23h 25m [ 84300 ] |
| Worklog Id | 42658 [ 42658 ] |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
| Assignee | Hrishikesh Deshpande [ hrishikesh.deshpande ] | Cindy Wibbing [ cindy.wibbing ] |
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Attachment | screenshot-1.png [ 48375 ] |
Hrishikesh Deshpande
This is still an issue. Please see latest file TOC Payroll201705101648_06943235650.xls under group template _Town of Cary Payroll Export
Past enrollments records are still pulling on payroll file.
| Assignee | Cindy Wibbing [ cindy.wibbing ] | Hrishikesh Deshpande [ hrishikesh.deshpande ] |
| Assignee | Hrishikesh Deshpande [ hrishikesh.deshpande ] | Umesh Kadam [ umesh.kadam ] |
Hi Vinayak Kulkarni,
Could you please look into this?
Please check if it is still persist.
Thanks and Regards,
:: Umesh Kadam
| Assignee | Umesh Kadam [ umesh.kadam ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
Please take this forward.
| Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Aniruddha Dev [ aniruddha.dev ] |
| Assignee | Aniruddha Dev [ aniruddha.dev ] | Hrishikesh Deshpande [ hrishikesh.deshpande ] |
Hi Cindy Wibbing,
We have verified this issue and observe that there is no issue in file. Can you please confirm the issue if still exist. also let us know sample records in case of issue.
Thanks,
Hrishikesh.
| Assignee | Hrishikesh Deshpande [ hrishikesh.deshpande ] | Cindy Wibbing [ cindy.wibbing ] |
| Time Spent | 23h 25m [ 84300 ] | 24h 55m [ 89700 ] |
| Worklog Id | 62013 [ 62013 ] |
| Bug Severity | Medium [ 16702 ] | |
| Code Review Date | 06/Apr/2017 | 06/Apr/2017 |
| Dev Due Date | 07/Apr/2017 | 07/Apr/2017 |
| Production Due Date | 19/Apr/2017 | 19/Apr/2017 |
| Stage Due Date | 18/Apr/17 [ 2017-04-18 ] | 18/Apr/17 [ 2017-04-18 ] |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Environment_New | Production [ 18442 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
3h 58m | 1 |
|
3h 53m | 1 |
|
47d 33m | 1 |
|
7d 2h 48m | 1 |
|
7d 17h 54m | 1 |
|
13d 1h 5m | 1 |
|
52s | 1 |
|
151d 9h 52m | 1 |
Hi Cindy,
Please find below details,
Concern: Unexpected records populated on file.
Cause: As we checked, all highlighted unexpected records are from plan Vision and Basic Dependent Life. Both of this plans are forced plan. Vision is forced contingent upon medical and Basic Dependent Life is force contingent on Medical, dental,vision and Basic life.
There is an issue in enrollment system due to which these force contingent enrollments are getting updated by employee data change and there is no actual change in enrollment, it is just updating enrollment date-time stamp.
As there is no actual change in enrollment data, it is not showing up on view history screens but export change file tracks date-time of enrollment which is updated due to above said error and records are populating on file.
Correction: We have assigned this to enrollment team and they will check this issue further.
let us know if you have any questions on this.
Jyoti Mayne Hi Jyoti, please check this, as this is high priority and can cause errors at payroll vendors for any client.