-
Type:
Bug
-
Status: Closed
-
Priority:
High
-
Resolution: System Behaviour
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:
-
Environment:Production
-
Bug Severity:Medium
-
Module:BenAdmin - Import
-
Reported by:White Label
-
Company:CSE
We have a couple issues with the data load for CSE. Please correct asap
1. The contingent EE AD&D and the Contingent Spouse AD&D are supposed to exactly match the EE and Sp life plans. When the data was loaded it the system enrolled the employee and spouse AD&D at the minimum coverage instead of matching the coverage amount of the life
2. The basic Life, AD&D and LTD for employees hired before 1/1/2017 should have an effective date of 1/1/2017. When the data was loaded the system gave those benefits a 2/1/2017 effective date.
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Swapnil Pandhare [ swapnil.pandhare ] | Umesh Kadam [ umesh.kadam ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Developer | Umesh Kadam [ umesh.kadam ] | |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
-
- Time Spent:
- 7h
-
Data scanning for given two issues
Preparation of Data Correction Script
Review script from Amruta
Discussion with Amruta regarding data correction
Data correction, Core plan Allocation, rate recalculation on HSPL company
Data verification/Data Audit on HSPL company
Data correction, Core plan Allocation, rate recalculation on main company
Data verification/Data Audit on main company
Hi Debbie Kulling,
Please find below details for #1 :
| Concern | When the data was loaded in, the system enrolled the employees in "Employee Voluntary AD&D" and "Spouse Voluntary AD&D" plans with the minimum coverage instead of matching the coverage amount with respective Voluntary Life Plan |
| Cause | Through import, the functionality of matching the Coverage Contingency is not implemented yet. |
| Correction | We have done data correction as of now. Development team will work to implement matching of Coverage Contingency in Import Module |
Thanks and Regards,
:: Umesh Kadam
CC : Samir, Satya, Amruta Lohiya, Swapnil Pandhare, Ganesh Sadawarte, Jaideep Vinchurkar
| Attachment | Effective_Date_Rule_Flag_For_Import.png [ 66433 ] |
Hi Debbie Kulling,
Please find below details for #2 :
| Concern | When the data was loaded, the system allocated enrollments in Basic Life, LTD and AD & D plans with effective date 02/01/2017 instead of 01/01/2017 |
| Cause | While allocating Core Plan during import, System uses "Effective Date Rule for Newly Eligible Core Elections" flag set on "General Plan Design" tab of a plan. Currently this flag has been set as "First of Month following 30 days" due to which system allocated core plans with effective date 02/01/2017. Please find below screenshot for the same  |
| Correction | We have allocated core plans with effective date 01/01/2017 through back-end. |
Thanks and Regards,
:: Umesh Kadam
CC : Samir, Satya, Amruta Lohiya, Swapnil Pandhare, Ganesh Sadawarte, Jaideep Vinchurkar
Amruta Lohiya
made changes -
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 2h [ 7200 ] | |
| Worklog Id | 88435 [ 88435 ] |
| Assignee | Umesh Kadam [ umesh.kadam ] | Jaideep Vinchurkar [ jaideep.vinchurkar ] |
| Time Spent | 2h [ 7200 ] | 9h [ 32400 ] |
| Worklog Id | 88446 [ 88446 ] |
| Assignee | Jaideep Vinchurkar [ jaideep.vinchurkar ] | snehal katkar [ snehal.katkar ] |
| Module | Parent values: BenAdmin(10100) | Parent values: BenAdmin(10100)Level 1 values: Import(10111) |
| Time Spent | 9h [ 32400 ] | 10h [ 36000 ] |
| Worklog Id | 88637 [ 88637 ] |
| Labels | Manual_import |
Snehal Katkar (Inactive)
logged work - 03/Nov/17 05:21 AM -
- Time Spent:
- 6h
-
Analysis, Discussio with Jaideep
| Attachment | CompanyEffDateRule_CSE.png [ 66801 ] |
Hi All,
In files that we have loaded employee effective date was 01/01/2017. Company level effective date rule is set to first of next month. Hence all employees got coverage from 02/01/2017. Please refer effective date termination date rule from company info 
Data correction is already done. No action items are pending
| Time Spent | 10h [ 36000 ] | 11h [ 39600 ] |
| Worklog Id | 89048 [ 89048 ] |
Snehal Katkar (Inactive)
logged work - 04/Nov/17 05:20 AM -
- Time Spent:
- 4h
-
Analysis, Jira updates, discussion with Jaideep
| Environment_New | Production [ 18442 ] |
Snehal Katkar (Inactive)
made changes -
| Time Spent | 11h [ 39600 ] | 15h [ 54000 ] |
| Worklog Id | 89193 [ 89193 ] |
Snehal Katkar (Inactive)
made changes -
| Time Spent | 15h [ 54000 ] | 21h [ 75600 ] |
| Worklog Id | 89195 [ 89195 ] |
Snehal Katkar (Inactive)
made changes -
| Time Spent | 21h [ 75600 ] | 25h [ 90000 ] |
| Worklog Id | 89218 [ 89218 ] |
Snehal Katkar (Inactive)
made changes -
| Time Spent | 25h [ 90000 ] | 27h [ 97200 ] |
| Worklog Id | 89418 [ 89418 ] |
Data correction is already done. We are rejecting this bug as this is system behavior. Employee got effective date as per rule set on effective date termination date screen. i.e. first of next month.
| Resolution | System Behaviour [ 10100 ] | |
| Status | In Development [ 10007 ] | Rejected [ 10004 ] |
| Status | Rejected [ 10004 ] | Closed [ 6 ] |
Snehal Katkar (Inactive)
made changes -
| Worklog Id | 89418 [ 89418 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
| Transition | Time In Source Status | Execution Times |
|---|
|
2h 11m | 1 |
|
6d 19h 5m | 1 |
|
6s | 1 |
CC : Samir Jaideep Vinchurkar Satya
Hi Umesh Kadam ,
Please check this as discussed.
Thanks,
Swapnil P.