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

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) created issue -
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Field Original Value New Value
            Assignee Vijay Siddha [ vijays ] Nandkumar [ satyap ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Link This issue relates to WT-4762 [ WT-4762 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Sprint WT Sprint 13 [ 27 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Rank Ranked lower
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            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.
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            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
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Skip benefittype of login completed employee.sql ]
            Transition Time In Source Status Execution Times
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            New Request Pending for Approval
            24d 20h 16m 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Pending for Approval Approved for Development
            5s 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Approved for Development In Development
            3s 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            In Development In LB Testing
            18d 4h 26m 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            4s 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            3s 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Approved for Stage Stage Testing
            3s 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Stage Testing Pending for Production Approval
            4s 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Pending for Production Approval Approved for production
            3s 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            Approved for production In Production Testing
            2s 1
            Nandkumar Prabhakar Karlekar (Inactive) made transition -
            In Production Testing Production Complete
            4m 41s 1

              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: