Uploaded image for project: 'Workterra BenAdmin'
  1. Workterra BenAdmin
  2. WB-187

Data Audit - Nations - Duplicate rates

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Duplicate
    • Labels:
      None
    • Support Task Type:
      Data Audit
    • Environment:
      Production
    • Company:
      Nations
    • Categories:
      Enrollment
    • Reported by:
      Harbinger

      Description

      Data Audit - Nations - Duplicate rates

      We found duplicate rate on this company PFA Excel Nations.xls

        Attachments

          Issue Links

            Activity

            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Hey Yamilka Coca

            Please find Impacted Data Audit results for Nations

            Please let us know the carrier feedback by Friday 11th May 2018 to proceed with the corrections.

            Thanks,

            -----------------

            Satya Rohan J Khandave] Vinanti Yadav] Monika Demla

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Hey Yamilka Coca Please find Impacted Data Audit results for Nations Please let us know the carrier feedback by Friday 11th May 2018 to proceed with the corrections. Thanks, ----------------- Satya Rohan J Khandave ] Vinanti Yadav ] Monika Demla
            Hide
            Yamilka.Coca Yamilka Coca (Inactive) added a comment - - edited

            Hi Patrick - Per my conversation with Debbie K. today she confirmed this case is aligned to you. Dev completed a data audit and they had some findings that are attached to this ticket that need to be reviewed.  Dev will be looking for direction/approval to proceed with the corrections. In this case they found duplicate rates.  Thank you.

            Show
            Yamilka.Coca Yamilka Coca (Inactive) added a comment - - edited Hi Patrick - Per my conversation with Debbie K. today she confirmed this case is aligned to you. Dev completed a data audit and they had some findings that are attached to this ticket that need to be reviewed.  Dev will be looking for direction/approval to proceed with the corrections. In this case they found duplicate rates.  Thank you.
            Hide
            patrick.carter Patrick Carter added a comment -

            Yamilka Coca,

            I have reviewed the 3 employees with duplicate rates.  Without access to the SA utility, I cannot tell that there are duplicate rates:

            Michael Riley- Terminated 4/30. 

            Melissa Dowdle- Enrolled in LTD back in 2016, but EOI was declined so she never had the plan.

            Stephanie Jones- Currently has STD. 

            How can there be duplicate rates when there is only 1 rate mapped to the plan and this has not changed since implementation?  How do I correct without the SA utility?

            Show
            patrick.carter Patrick Carter added a comment - Yamilka Coca , I have reviewed the 3 employees with duplicate rates.  Without access to the SA utility, I cannot tell that there are duplicate rates: Michael Riley- Terminated 4/30.  Melissa Dowdle- Enrolled in LTD back in 2016, but EOI was declined so she never had the plan. Stephanie Jones- Currently has STD.  How can there be duplicate rates when there is only 1 rate mapped to the plan and this has not changed since implementation?  How do I correct without the SA utility?
            Hide
            vinanti.yadav Vinanti Yadav (Inactive) added a comment -

            Hi Patrick Carter ,

             

            Employee Name Plan Name Current status
            Michael Riley Standard Long Term Disability employee is terminated now on datetime 5/1/2018. due to this election gets terminated by 4/30/2018.
            Melissa Dowdle Standard Long Term Disability Employee election declined on datetime : 2/ 23/2018

            so please do not consider above two records.

            EE 'Stephanie Jones' has duplicate rates all details are maintioned in WB-1426 (May Audit).

            As per the request we have shared this Data sheet (contains rate name, rate effective date, rate termination date,sub rate name )) under May's Data Audit Jira ticket WB-1426 . We have added JAN data to that sheet.

            Please Close this ticket and refer WB-1426 Jira.

            Please revert back if you need anything apart from this.

            CC : Harshawardhan Phalake, Rohan J Khandave,Prashant Samal, Monika Demla, Yamilka Coca,

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi Patrick Carter ,   Employee Name Plan Name Current status Michael Riley Standard Long Term Disability employee is terminated now on datetime 5/1/2018. due to this election gets terminated by 4/30/2018. Melissa Dowdle Standard Long Term Disability Employee election declined on datetime : 2/ 23/2018 so please do not consider above two records. EE 'Stephanie Jones' has duplicate rates all details are maintioned in WB-1426 (May Audit). As per the request we have shared this Data sheet (contains rate name, rate effective date, rate termination date,sub rate name )) under May's Data Audit Jira ticket WB-1426 . We have added JAN data to that sheet. Please Close this ticket and refer WB-1426 Jira. Please revert back if you need anything apart from this. CC : Harshawardhan Phalake , Rohan J Khandave , Prashant Samal , Monika Demla , Yamilka Coca ,
            Hide
            patrick.carter Patrick Carter added a comment -

            Refer to WB-1426

            Show
            patrick.carter Patrick Carter added a comment - Refer to WB-1426

              People

              Assignee:
              patrick.carter Patrick Carter
              Reporter:
              rakeshr Rakesh Roy (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: