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

ILG | Data Correction on Termination Date on all Plans

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Environment:
      Production, Stage
    • Reported by:
      Implementation
    • Company:
      ILG
    • Module:
      BenAdmin - Enrollment
    • Severity:
      Simple

      Description

      Hi,
      According to IGT. Group has Date of Termination for Termination rule. Somehow during implementation End of Month was set, which is notcorrect. While attempting to re-enroll and fix his termination date to the correct date of termination through UI and waive and terminate members accordingly, it takes lot of time and and creates room for error. Which I think is not the most efficient way.

      We are gathering information on correcting enrollments for all subscriber which were affected.
      Possible steps to take:
      1. Term Rules update –Updating build documents, IGT, CIS, and BOSS
      a. Update Rule on stage( done ) Production (in progress)
      b. Delete the other rule in stage ( done ) Production (in progress)
      c. Subscriber’s corrections on each enrollment to be* Date of Termination. –*
      d. Contact carriers to ensure the proper term has been passed.
      i. UMR,
      ii. UNUM,
      iii. AFLAC,
      iv. COMPASS

      Could you please do the analysis and find out if there is anything else we need to check to make sure that nothing else is affected.

      Thanks.
      Monika
      cc Kiyo Takahashi Jackie Sivigny Robyn Adkison

        Attachments

          Activity

          Monika.Demla Monika Demla (Inactive) created issue -
          Monika.Demla Monika Demla (Inactive) made changes -
          Field Original Value New Value
          Attachment MD EnrollmentMD Enrollment28878_2472.xlsx [ 73819 ]
          Monika.Demla Monika Demla (Inactive) made changes -
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment - - edited

          MD EnrollmentMD Enrollment28878_2472.xlsx
          Please see file attached. I Ran report and there are 18 people affected as of 2.26.18. Let me know who is looking into this ticket. I will send password to that person. Please drop in email at :- monika.demla@workterra.com

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - - edited MD EnrollmentMD Enrollment28878_2472.xlsx Please see file attached. I Ran report and there are 18 people affected as of 2.26.18. Let me know who is looking into this ticket. I will send password to that person. Please drop in email at :- monika.demla@workterra.com
          Monika.Demla Monika Demla (Inactive) made changes -
          Description Hi,
           According to IGT. Group has *Date of Termination* for Termination rule. Somehow during implementation End of Month was set, which is in correct. While attempting to re-enroll and waive and terminate members accordingly takes lot of time and and creates room for error.

          We are gathering information on correcting enrollments for all subscriber which were affected.
          Possible steps to take:
          1. Term Rules update –Updating build documents
          a. Update Rule on stage( done ) Production (in progress)
          b. Delete the other rule in stage ( done ) [^MD EnrollmentMD Enrollment28878_2472.xlsx] Production (in progress)
          c. Subscriber’s corrections on each plan to be Date of Termination. – Ran report and there are 18 people affected as of 2.26.18
          d. Contact carriers to ensure the proper term has been passed.
                               i. UMR,
                              ii. UNUM,
                              iii. AFLAC,
                              iv. COMPASS

          Could you please do the analysis and find out if there is anything else we need to check to make sure that nothing else is affected.

          Thanks.
          Monika
          cc [~ktak] [~jackie.sivigny] [~Robyn.Adkison]
          Hi,
           According to IGT. Group has *Date of Termination* for Termination rule. Somehow during implementation _End of Month_ was set, which is notcorrect. While attempting to re-enroll and fix his termination date to the correct date of termination through UI and waive and terminate members accordingly, it takes lot of time and and creates room for error. Which I think is not the most efficient way.

          We are gathering information on correcting enrollments for all subscriber which were affected.
          Possible steps to take:
          1. Term Rules update –Updating build documents, IGT, CIS, and BOSS
          a. Update Rule on stage( done ) Production (in progress)
          b. Delete the other rule in stage ( done ) Production (in progress)
          c. Subscriber’s corrections on each enrollment to be* Date of Termination. –*
          d. Contact carriers to ensure the proper term has been passed.
                               i. UMR,
                              ii. UNUM,
                              iii. AFLAC,
                              iv. COMPASS

          Could you please do the analysis and find out if there is anything else we need to check to make sure that nothing else is affected.

          Thanks.
          Monika
          cc [~ktak] [~jackie.sivigny] [~Robyn.Adkison]
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Satya [ ID10004 ] Jyoti Mayne [ jyoti.mayne ]
          jyoti.mayne Jyoti Mayne made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          jyoti.mayne Jyoti Mayne made changes -
          Attachment EE List.xlsx [ 73848 ]
          Hide
          jyoti.mayne Jyoti Mayne added a comment -

          Hi Monika Demla,

          We have scanned all elections active as of 2/26/18 and found attached 11 employees elections (election count 57) need to be corrected. EE List.xlsx

          Also in your list election terminated with 1/31/2018 date are also mentioned.
          We found 85 elections for 14 employees.

          Please confirm which election needs to be corrected.

          Export Team Comment:
          Even if these terminations are already sent to provider, they will reappear on file with correct term date after data correction. Let us know if we do not want to send them again.

          Cc: Rohan J Khandave, Van Nguyen, Vinayak Kulkarni

          Show
          jyoti.mayne Jyoti Mayne added a comment - Hi Monika Demla , We have scanned all elections active as of 2/26/18 and found attached 11 employees elections (election count 57) need to be corrected. EE List.xlsx Also in your list election terminated with 1/31/2018 date are also mentioned. We found 85 elections for 14 employees. Please confirm which election needs to be corrected. Export Team Comment: Even if these terminations are already sent to provider, they will reappear on file with correct term date after data correction. Let us know if we do not want to send them again. Cc: Rohan J Khandave , Van Nguyen , Vinayak Kulkarni
          jyoti.mayne Jyoti Mayne made changes -
          Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Jyoti Mayne [ jyoti.mayne ] Monika Demla [ monika.demla ]
          jyoti.mayne Jyoti Mayne made changes -
          Remaining Estimate 3h [ 10800 ]
          Original Estimate 3h [ 10800 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 27/Feb/18 02:52 PM
          • Time Spent:
            2h
             
            <No comment>
          jyoti.mayne Jyoti Mayne logged work - 27/Feb/18 05:45 PM
          • Time Spent:
            3h
             

            data scanning and JIRA Update

          Hide
          Monika.Demla Monika Demla (Inactive) added a comment - - edited

          I am looking at the Members those who are only Terminated. Actives should not be touched.

          To my understanding this should be corrected to all the members who are Terminated with Correct termination date, it should be the Date of Termination not the End of Month.
          Please look into the the members terminated since 1/1/2018. Kiyo Takahashi Please confirm and let me know if I am incorrect.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - - edited I am looking at the Members those who are only Terminated. Actives should not be touched. To my understanding this should be corrected to all the members who are Terminated with Correct termination date, it should be the Date of Termination not the End of Month. Please look into the the members terminated since 1/1/2018. Kiyo Takahashi Please confirm and let me know if I am incorrect.
          Prashant.samal Prashant Samal (Inactive) made changes -
          Assignee Monika Demla [ monika.demla ] Jyoti Mayne [ jyoti.mayne ]
          Prashant.samal Prashant Samal (Inactive) made changes -
          Status Waiting for Customer Input [ 10500 ] Open [ 1 ]
          jyoti.mayne Jyoti Mayne made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          jyoti.mayne Jyoti Mayne made changes -
          Attachment EE List Needs Correction.xlsx [ 73894 ]
          Hide
          jyoti.mayne Jyoti Mayne added a comment -

          Hi Monika Demla,

          Today we again scanned all employees who where terminated since 1/1/18. PFA list. EE List Needs Correction.xlsx

          For attached employees, we will update election termed date as per value mentioned in column 'Required Termination Date as per Date of Plan Termination Rule'.

          Please confirm shall these elections needs to be roll out on file or not ?

          Cc: Rohan J Khandave

          Show
          jyoti.mayne Jyoti Mayne added a comment - Hi Monika Demla , Today we again scanned all employees who where terminated since 1/1/18. PFA list. EE List Needs Correction.xlsx For attached employees, we will update election termed date as per value mentioned in column 'Required Termination Date as per Date of Plan Termination Rule'. Please confirm shall these elections needs to be roll out on file or not ? Cc: Rohan J Khandave
          jyoti.mayne Jyoti Mayne made changes -
          Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Jyoti Mayne [ jyoti.mayne ] Monika Demla [ monika.demla ]
          jyoti.mayne Jyoti Mayne logged work - 28/Feb/18 05:48 PM - edited
          • Time Spent:
            3h
             

            data scanning and JIRA Update

          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Hi Jyoti Mayne
          The report looks correct and has the same number of counts as i expected.
          *Yes,*These updated Term dates needs to roll out on Carrier files. Is that what you are confirming.. or on some other file?
          Thanks!
          cc Kiyo TakahashiRobyn Adkison

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Hi Jyoti Mayne The report looks correct and has the same number of counts as i expected. *Yes,*These updated Term dates needs to roll out on Carrier files. Is that what you are confirming.. or on some other file? Thanks! cc Kiyo Takahashi Robyn Adkison
          jyoti.mayne Jyoti Mayne made changes -
          Remaining Estimate 3h [ 10800 ] 0h [ 0 ]
          Time Spent 3h [ 10800 ]
          Worklog Id 106820 [ 106820 ]
          jyoti.mayne Jyoti Mayne made changes -
          Status Waiting for Customer Input [ 10500 ] Open [ 1 ]
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Monika Demla [ monika.demla ] Jyoti Mayne [ jyoti.mayne ]
          Status Open [ 1 ] In Progress [ 3 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 3h [ 10800 ] 5h [ 18000 ]
          Worklog Id 106824 [ 106824 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 5h [ 18000 ] 6h [ 21600 ]
          Worklog Id 106824 [ 106824 ]
          Hide
          jyoti.mayne Jyoti Mayne added a comment - - edited

          Hi Monika Demla,

          We have corrected enrollment termination date as stated above from 'EE List Needs Correction.xlsx' sheet and these elections will roll out on file.

          Yes, we were just confirming that these elections will out on carrier files.

          Cc: Rohan J Khandave

          Show
          jyoti.mayne Jyoti Mayne added a comment - - edited Hi Monika Demla , We have corrected enrollment termination date as stated above from 'EE List Needs Correction.xlsx' sheet and these elections will roll out on file. Yes, we were just confirming that these elections will out on carrier files. Cc: Rohan J Khandave
          jyoti.mayne Jyoti Mayne made changes -
          Original Estimate 3h [ 10800 ] 9h [ 32400 ]
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Jyoti Mayne [ jyoti.mayne ] Monika Demla [ monika.demla ]
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Thank you Jyoti Mayne
          Appreciate your every effort!
          Thanks.
          Monika

          Kiyo Takahashi Could you please inform client that Termination rule setup and corrections are done.
          cc Robyn Adkison Jackie Sivigny

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Thank you Jyoti Mayne Appreciate your every effort! Thanks. Monika Kiyo Takahashi Could you please inform client that Termination rule setup and corrections are done. cc Robyn Adkison Jackie Sivigny
          jyoti.mayne Jyoti Mayne logged work - 01/Mar/18 06:06 PM
          • Time Spent:
            3h
             

            data correction,verification on HSPL and main company

          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Kiyo Takahashi Could you please inform client that Termination rule setup and corrections are done. This was done last week.
          cc Kiyo Takahashi

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Kiyo Takahashi Could you please inform client that Termination rule setup and corrections are done. This was done last week. cc Kiyo Takahashi
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Time Spent 6h [ 21600 ] 8h [ 28800 ]
          Worklog Id 107706 [ 107706 ]
          jyoti.mayne Jyoti Mayne made changes -
          Time Spent 8h [ 28800 ] 11h [ 39600 ]
          Worklog Id 107803 [ 107803 ]
          Transition Time In Source Status Execution Times
          Jyoti Mayne made transition -
          In Progress Waiting for Customer Input
          10h 44m 2
          Jyoti Mayne made transition -
          Waiting for Customer Input Open
          1d 6h 59m 2
          Jyoti Mayne made transition -
          Open In Progress
          15h 56m 3
          Jyoti Mayne made transition -
          In Progress Resolved
          5h 42m 1

            People

            Assignee:
            Monika.Demla Monika Demla (Inactive)
            Reporter:
            Monika.Demla Monika Demla (Inactive)
            Account Executive:
            Kiyo Takahashi
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 9h Original Estimate - 9h
                9h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 11h
                11h