Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-12730

Deep South - Basic Life and AD&D Salary Increases Did not Work and Auto Enroll

    Details

    • Type: Bug
    • Status: Rejected
    • Priority: High
    • Resolution: System Behaviour
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      White Label
    • Company:
      Deep South
    • Item State:
      Development - On Hold

      Description

      We have the "next fiscal year" set on salary increases. The salaries were imported before OE on 9/20 with an effective date of 11/1/2017 but the amounts did not update. Please correct the coverage amounts. Employee example Gary Atkins.

      Also there appears to be employees with Basic Life and do not have Basic AD&D. This should have auto enrolled with the Basic Life. Please correct the records missing Basic AD&D and research root cause. Employee Examples: Daniel Carey, Zachary Hatcher

        Attachments

          Issue Links

            Activity

            vinanti.yadav Vinanti Yadav (Inactive) logged work - 04/Dec/17 12:51 PM
            • Time Spent:
              2h
               

              Data Correction For Duplicate Rates.
              Verification.

            vinanti.yadav Vinanti Yadav (Inactive) logged work - 08/Dec/17 04:34 PM
            • Time Spent:
              7h
               

              Analysis.
              data scanning.
              Discussion with Jyoti.
              writing query for scanning.
              call.

            umesh.kadam Umesh Kadam (Inactive) logged work - 08/Dec/17 05:30 PM
            • Time Spent:
              2h
               

              Analysis

            dkulling Debbie Kulling created issue -
            dkulling Debbie Kulling made changes -
            Field Original Value New Value
            Description We have the "next fiscal year" set on salary increases. The salaries were imported before OE on 9/20 with an effective date of 11/1/2017 but the amounts did not update. Please correct the coverage amounts. Employee example Gary Atkins.

            Also there appears to be employees with Basic Life and do not have Basic AD&D. This should have auto enrolled with the Basic Life. Please correct the records missing Basic AD&D and research root cause
            We have the "next fiscal year" set on salary increases. The salaries were imported before OE on 9/20 with an effective date of 11/1/2017 but the amounts did not update. Please correct the coverage amounts. Employee example Gary Atkins.

            Also there appears to be employees with Basic Life and do not have Basic AD&D. This should have auto enrolled with the Basic Life. Please correct the records missing Basic AD&D and research root cause. Employee Examples: Daniel Carey, Zachary Hatcher
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Assignee Satya [ ID10004 ] Umesh Kadam [ umesh.kadam ]
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 95483 [ 95483 ]
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Umesh Kadam [ umesh.kadam ] Amruta Lohiya [ amruta.baheti ]
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Amruta Lohiya [ amruta.baheti ] Vinanti Yadav [ vinanti.yadav ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Developer Vinanti Yadav [ vinanti.yadav ]
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107)
            Original Estimate 0h [ 0 ]
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 11/Dec/17 12:56 PM
            • Time Spent:
              8h
               

              Discussion with Amruta.
              Analysis.
              data correction on Main and HSPL.
              Service execution on HSPL and Main.
              JIRA updates.
              mail communication.

            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Time Spent 2h [ 7200 ] 10h [ 36000 ]
            Worklog Id 95659 [ 95659 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Attachment SalaryChangesEnrollmentRecords.xls [ 69789 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Hide
            vinanti.yadav Vinanti Yadav (Inactive) added a comment -

            Hi Debbie Kulling,

            We have corrected the affected records for
            1. Salary is changed but coverage is not updated. PFA for affected Employee deatils. SalaryChangesEnrollmentRecords.xls
            2. Employee having Election in auto core plan Basic Life and do not have in Basic AD&D. PFA for Affected Employee details. BasicAD&D_AutoCorePlanAffectedRecords.xls
            Please verify this at your end.

            We will update you root cause for this once analysis gets complete.

            Thanks,
            Vinanti

            CC : Amruta Lohiya

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi Debbie Kulling , We have corrected the affected records for 1. Salary is changed but coverage is not updated. PFA for affected Employee deatils. SalaryChangesEnrollmentRecords.xls 2. Employee having Election in auto core plan Basic Life and do not have in Basic AD&D . PFA for Affected Employee details. BasicAD&D_AutoCorePlanAffectedRecords.xls Please verify this at your end. We will update you root cause for this once analysis gets complete. Thanks, Vinanti CC : Amruta Lohiya
            Hide
            vinanti.yadav Vinanti Yadav (Inactive) added a comment -

            Hi Debbie Kulling,

            Analysis is in progress. we will let you know once its completed.

            Thanks,
            Vinanti

            CC :Amruta Lohiya

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi Debbie Kulling , Analysis is in progress. we will let you know once its completed. Thanks, Vinanti CC : Amruta Lohiya
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Time Spent 10h [ 36000 ] 12h [ 43200 ]
            Worklog Id 95793 [ 95793 ]
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 12/Dec/17 12:58 PM
            • Time Spent:
              2h
               

              try to reproduce Auto core plan issue on Production.
              disscusion with amruta

            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Time Spent 12h [ 43200 ] 14h [ 50400 ]
            Worklog Id 95799 [ 95799 ]
            Hide
            vinanti.yadav Vinanti Yadav (Inactive) added a comment -

            Hi Hrishikesh Deshpande,

            Concern 1 : Salary is changed but coverage is not updated.
            Cause : During first date of open enrollment period the service 'Next Fiscal Year Salary Changes' updates the coverage for the respective employees whose salaries got changed and they avail the new coverage from 01/01/Next Year.
            This service is not run on OE start day due to this Coverage of employee(whose salary is changed) is not updated.

            we are not able to find why service is not run on OE first Day.
            below are the customization for fiscal year

            OE Start Date : 22/09/2017
            OE End Date : 10/06/2017
            Fiscal Year Start Date : 11/01/2017
            Fiscal Year End Date : 10/31/2018

            Concern 2 : Auto Core Plan 'Basic AD&D' is not allocated to some employee.
            we tried below scenario to reproduce this issue.
            1. Changing demographics details of EE.
            2. Add new EE (which is eligibile to auto core plan)
            but in above all cases EE get auto core plan.

            so we need QA help reproduce above two issue.

            Thanks,
            Vinanti

            CC : Amruta Lohiya

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi Hrishikesh Deshpande , Concern 1 : Salary is changed but coverage is not updated. Cause : During first date of open enrollment period the service 'Next Fiscal Year Salary Changes' updates the coverage for the respective employees whose salaries got changed and they avail the new coverage from 01/01/Next Year. This service is not run on OE start day due to this Coverage of employee(whose salary is changed) is not updated. we are not able to find why service is not run on OE first Day. below are the customization for fiscal year OE Start Date : 22/09/2017 OE End Date : 10/06/2017 Fiscal Year Start Date : 11/01/2017 Fiscal Year End Date : 10/31/2018 Concern 2 : Auto Core Plan 'Basic AD&D' is not allocated to some employee. we tried below scenario to reproduce this issue. 1. Changing demographics details of EE. 2. Add new EE (which is eligibile to auto core plan) but in above all cases EE get auto core plan. so we need QA help reproduce above two issue. Thanks, Vinanti CC : Amruta Lohiya
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Assignee Vinanti Yadav [ vinanti.yadav ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            Hide
            vinanti.yadav Vinanti Yadav (Inactive) added a comment -

            Hi Debbie Kulling,

            Correction is done for both the issues.

            #1 : Salary is changed but coverage is not updated.
            Cause: As per discussion with Amruta Lohiya,
            Fiscal year service is not yet automatically schedule. So before OE if you are loading salary data and
            want coverage update from fiscal year then you need to convey dev team. So they will do it in OE setup

            #2 : Auto Core Plan 'Basic AD&D' is not allocated to some employee.
            Cause: We have observed that basic AD&D did not get allocated through import in initial load.
            Because when we are trying from screen. Basic AD&D is getting properly.
            So assigning this ticket to import team.

            Thanks,
            Vinanti

            CC : Amruta Lohiya, Suraj Sokasane

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi Debbie Kulling , Correction is done for both the issues. #1 : Salary is changed but coverage is not updated. Cause: As per discussion with Amruta Lohiya, Fiscal year service is not yet automatically schedule. So before OE if you are loading salary data and want coverage update from fiscal year then you need to convey dev team. So they will do it in OE setup #2 : Auto Core Plan 'Basic AD&D' is not allocated to some employee. Cause: We have observed that basic AD&D did not get allocated through import in initial load. Because when we are trying from screen. Basic AD&D is getting properly. So assigning this ticket to import team. Thanks, Vinanti CC : Amruta Lohiya , Suraj Sokasane
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Suraj Sokasane [ suraj.sokasane ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Snehal Katkar [ snehal.katkar ]
            Hide
            snehal.katkar Snehal Katkar (Inactive) added a comment -

            Hi Debbie Kulling,

            I checked the file imported on 09/20. Import type of template is 'Salary Change' and not 'Employee Data'. We don't do core plan allocation for salary change template type, but we only update coverage of already existing enrollments of salary based plans. Hence, core plan 'Basic AD&D' did not get allocated to employees by this import.

            Thanks,
            Snehal

            CC: Jaideep Vinchurkar, Amruta Lohiya

            Show
            snehal.katkar Snehal Katkar (Inactive) added a comment - Hi Debbie Kulling , I checked the file imported on 09/20. Import type of template is 'Salary Change' and not 'Employee Data'. We don't do core plan allocation for salary change template type, but we only update coverage of already existing enrollments of salary based plans. Hence, core plan 'Basic AD&D' did not get allocated to employees by this import. Thanks, Snehal CC: Jaideep Vinchurkar , Amruta Lohiya
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 14/Dec/17 03:39 PM
            • Time Spent:
              0.5h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 14h [ 50400 ] 14.5h [ 52200 ]
            Worklog Id 96209 [ 96209 ]
            jyoti.mayne Jyoti Mayne logged work - 15/Dec/17 09:33 AM - edited
            • Time Spent:
              1.5h
               

              analysis, scanning and discussion

            vinanti.yadav Vinanti Yadav (Inactive) logged work - 15/Dec/17 11:44 AM
            • Time Spent:
              5h
               

              Analysis.
              Discussion with Jyoti.
              data scanning on Production.

            jyoti.mayne Jyoti Mayne made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: On Hold(10207)
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 14.5h [ 52200 ] 15.75h [ 56700 ]
            Worklog Id 96476 [ 96476 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 15.75h [ 56700 ] 45.5h [ 163800 ]
            Worklog Id 96476 [ 96476 ]
            jyoti.mayne Jyoti Mayne made changes -
            Remaining Estimate 0h [ 0 ] 29.5h [ 106200 ]
            Time Spent 45.5h [ 163800 ] 16h [ 57600 ]
            Worklog Id 96476 [ 96476 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Remaining Estimate 29.5h [ 106200 ] 22.5h [ 81000 ]
            Time Spent 16h [ 57600 ] 23h [ 82800 ]
            Worklog Id 96725 [ 96725 ]
            Hide
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            Hi Amruta Lohiya,

            From import side this is system behavior and can be reject. Please check what should be the action from enrollments team.

            CC: Gaurav Sodani, Satya

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Hi Amruta Lohiya , From import side this is system behavior and can be reject. Please check what should be the action from enrollments team. CC: Gaurav Sodani , Satya
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Snehal Katkar [ snehal.katkar ] Amruta Lohiya [ amruta.baheti ]
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Amruta Lohiya [ amruta.baheti ] Umesh Kadam [ umesh.kadam ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Remaining Estimate 22.5h [ 81000 ] 17.5h [ 63000 ]
            Time Spent 23h [ 82800 ] 28h [ 100800 ]
            Worklog Id 97547 [ 97547 ]
            jyoti.mayne Jyoti Mayne made changes -
            Root Cause Configuration Error [ 18427 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Link This issue is cloned by WT-13051 [ WT-13051 ]
            Hide
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - - edited

            Hi Debbie Kulling,

            There are concerns in this ticket,
            Concern 1 : Salary is changed but coverage is not updated.
            Cause: Fiscal year service is not yet automatically schedule. So before OE if you are loading salary data and
            want coverage update from fiscal year then you need to convey dev team. So they will do it in OE setup

            Concern 2: Auto Core Plan 'Basic AD&D' is not allocated to some employee.
            Cause: the file imported on 09/20. Import type of template is 'Salary Change' and not 'Employee Data'.
            We don't do core plan allocation for salary change template type, but we only update coverage of already existing enrollments of salary based plans. Hence, core plan 'Basic AD&D' did not get allocated to employees by this import.

            Both these concerns are as expected system behavior.

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - - edited Hi Debbie Kulling , There are concerns in this ticket, Concern 1 : Salary is changed but coverage is not updated. Cause: Fiscal year service is not yet automatically schedule. So before OE if you are loading salary data and want coverage update from fiscal year then you need to convey dev team. So they will do it in OE setup Concern 2: Auto Core Plan 'Basic AD&D' is not allocated to some employee. Cause: the file imported on 09/20. Import type of template is 'Salary Change' and not 'Employee Data'. We don't do core plan allocation for salary change template type, but we only update coverage of already existing enrollments of salary based plans. Hence, core plan 'Basic AD&D' did not get allocated to employees by this import. Both these concerns are as expected system behavior.
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Umesh Kadam [ umesh.kadam ] Debbie Kulling [ dkulling ]
            Resolution System Behaviour [ 10100 ]
            Status In Development [ 10007 ] Rejected [ 10004 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 11/Jan/18 10:20 AM
            • Time Spent:
              0.5h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 17.5h [ 63000 ] 17h [ 61200 ]
            Time Spent 28h [ 100800 ] 28.5h [ 102600 ]
            Worklog Id 100008 [ 100008 ]
            Transition Time In Source Status Execution Times
            Umesh Kadam (Inactive) made transition -
            Open In Development
            1h 28m 1
            Jaideep Vinchurkar (Inactive) made transition -
            In Development Rejected
            33d 13h 26m 1

              People

              Assignee:
              dkulling Debbie Kulling
              Reporter:
              dkulling Debbie Kulling
              Account Executive:
              Debbie Kulling
              Developer:
              Vinanti Yadav (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Time Spent - 28.5h Remaining Estimate - 17h
                  17h
                  Logged:
                  Time Spent - 28.5h Remaining Estimate - 17h
                  28.5h