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

DATA AUDIT : Benefit type skip. Important after OE.

    Details

    • Type: Enhancement
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Support
    • Item State:
      Development - In Analysis
    • Issue Importance:
      Good To Have
    • Sprint:
      WT Sprint 13

      Description

      Employee is eligible to the plan and employee completed the Employee self service and completed his Login status .

      But Employee neither Enrolled or waive the benefit type.[if Benefit is *required]

        Attachments

          Issue Links

            Activity

            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            we are working on this.

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - we are working on this.
            Hide
            shyam.sharma shyam sharma (Inactive) added a comment -

            Nandkumar Prabhakar Karlekar :any further progress on this front ?
            As this is from last sprint 13. So can you please let me know ETA for this?

            Show
            shyam.sharma shyam sharma (Inactive) added a comment - Nandkumar Prabhakar Karlekar :any further progress on this front ? As this is from last sprint 13. So can you please let me know ETA for this?
            Hide
            shyam.sharma shyam sharma (Inactive) added a comment -

            Nandkumar Prabhakar Karlekar : Can you please let me know your plan for this ?

            Show
            shyam.sharma shyam sharma (Inactive) added a comment - Nandkumar Prabhakar Karlekar : Can you please let me know your plan for this ?
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - - edited

            Hi shyam sharma,

            I have just completed the script and testing this on live company.

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - - edited Hi shyam sharma , I have just completed the script and testing this on live company.
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Hi shyam sharma

            I have completed this script and put it in the SVN @WT\Data Analysis Scripts\Open Enrollment\Data Audit Scripts.
            also tested this script for production symphony company and find the below employees who skipped medical benefit type.

            EmployeeID Firstname Middle Name last Name
            4814 TRACY NULL SPIRES
            4842 ANDREYA S MOORE
            4889 JENNIFER M WILLIAMS
            4987 KEI'SHA NULL KEY-TROTTER
            5104 AARON M BOUDREAU
            5178 JOANNA ROSE NULL RUIZ
            5301 BRYANT NULL YOUNG
            5587 ISAI NULL MEDINA
            6147 ANGELA NULL RINCON
            7519 JULIE M WELKER
            7520 YVONNE NULL LARA
            7542 STEPHANIE NULL HALIHAN
            8523 JUAN NULL RUIZ
            9082 ORLANDO NULL MACASAET
            9161 LILIA NULL CASTRO
            9306 ANTWANETTE T STEGALL

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi shyam sharma I have completed this script and put it in the SVN @WT\Data Analysis Scripts\Open Enrollment\Data Audit Scripts. also tested this script for production symphony company and find the below employees who skipped medical benefit type. EmployeeID Firstname Middle Name last Name 4814 TRACY NULL SPIRES 4842 ANDREYA S MOORE 4889 JENNIFER M WILLIAMS 4987 KEI'SHA NULL KEY-TROTTER 5104 AARON M BOUDREAU 5178 JOANNA ROSE NULL RUIZ 5301 BRYANT NULL YOUNG 5587 ISAI NULL MEDINA 6147 ANGELA NULL RINCON 7519 JULIE M WELKER 7520 YVONNE NULL LARA 7542 STEPHANIE NULL HALIHAN 8523 JUAN NULL RUIZ 9082 ORLANDO NULL MACASAET 9161 LILIA NULL CASTRO 9306 ANTWANETTE T STEGALL
            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Skip benefittype of login completed employee.sql ]

              People

              Assignee:
              nandkumar Nandkumar Prabhakar Karlekar (Inactive)
              Reporter:
              nandkumar Nandkumar Prabhakar Karlekar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: