WORKTERRAProject Type: software

WORKTERRA

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

Data Audit on Five Guys

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Reported by:
      Support
    • Company:
      Five Guys
    • Module:
      Exchange
    • Issue Importance:
      Must Have
    • Severity:
      Simple

      Attachments

        Issue Links

        relates to

        Support Activity - Support Activity WT-8310 Five Guys - Duplicate STD/LTD Enrollments

        • Critical - This problem will block progress.
        • Closed

          Activity

          Ascending order - Click to sort in descending order
          avnish.yadav Avnish Yadav (Inactive) created issue -
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Field Original Value New Value
          Link This issue relates to WT-8310 [ WT-8310 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Comment [ Hi [~aniruddha.dev],

          We have done our correction on Five Guys For HSPL company for following scenario:-

          ||Scenario|| Data Count||Status||Remark||
          |Duplicate Elections|8|Done| |
          |Duplicate Rates|0| | |
          |Member Deleted Entry in Coverage|7|No Correction Required|Enrollment are Dead|

            ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Hide
          Permalink
          avnish.yadav Avnish Yadav (Inactive) added a comment - - edited

          Hi Aniruddha Dev,

          We have Scanned following scenario on Five Guys For HSPL company and corrected data for highlight scenario:-

          Sr No Scenario Data Count Status Remark
          1 Duplicate Elections 8 Done  
          2 Member Deleted
          Entry in Coverage          		 7 No Correction Required Enrollments are Dead
          3 Orphan Rates 98 Done  
          4 Rates Beyond End Date 17 No Correction Required Rates are Dead
          5 Plan End Election Active 0    
          6 Duplicate Rates 0    
          7 Wrong Member Coverage 0    
          8 Members Not
          In Coverage Table          		 0    
          9 Terminated Employees
          Active Election          		 0    

          Please verify above correction on Five Guys for HSPL and let us know in case of any issue/concern.

          Please refer attached Correction report for employees records.

          Thanks,
          Avnish Y

          CC- Jyoti Mayne,Satya

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - - edited Hi Aniruddha Dev , We have Scanned following scenario on Five Guys For HSPL company and corrected data for highlight scenario:- Sr No Scenario Data Count Status Remark 1 Duplicate Elections 8 Done   2 Member Deleted Entry in Coverage 7 No Correction Required Enrollments are Dead 3 Orphan Rates 98 Done   4 Rates Beyond End Date 17 No Correction Required Rates are Dead 5 Plan End Election Active 0     6 Duplicate Rates 0     7 Wrong Member Coverage 0     8 Members Not In Coverage Table 0     9 Terminated Employees Active Election 0     Please verify above correction on Five Guys for HSPL and let us know in case of any issue/concern. Please refer attached Correction report for employees records. Thanks, Avnish Y CC- Jyoti Mayne , Satya
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Assignee Avnish Yadav [ avnish.yadav ] Aniruddha Dev [ aniruddha.dev ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Attachment Correction_Reports.xls [ 39309 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Attachment Correction_Reports.xls [ 39309 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Attachment Correction_Reports.zip [ 39310 ]
          Permalink
          aniruddha.dev Aniruddha Dev (Inactive) logged work - 08/Feb/17 01:28 PM
          • Time Spent:
            0.5h
             

            analysis and template creation before correction

          Permalink
          avnish.yadav Avnish Yadav (Inactive) logged work - 08/Feb/17 06:22 PM
          • Time Spent:
            8h
             
            <No comment>
          Hide
          Permalink
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Hi Avnish Yadav,

          Verified the above corrections on export payroll file (for all plans) pulled out from Five Guys for HSPL company on Production.

          No impact/changes observed on files after correction. Compared and Verified the changes on UI (on Main and HSPL company) for Duplicate Enrollments and Costs allocated and it is proper.
          Orphan rates have no impact on export file.

          You can proceed with the correction on main Five Guys on production.

          CC:Hrishikesh Deshpande Jyoti Mayne Vinayak Kulkarni Satya

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Hi Avnish Yadav , Verified the above corrections on export payroll file (for all plans) pulled out from Five Guys for HSPL company on Production. No impact/changes observed on files after correction. Compared and Verified the changes on UI (on Main and HSPL company) for Duplicate Enrollments and Costs allocated and it is proper. Orphan rates have no impact on export file. You can proceed with the correction on main Five Guys on production. CC: Hrishikesh Deshpande Jyoti Mayne Vinayak Kulkarni Satya
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Assignee Aniruddha Dev [ aniruddha.dev ] Avnish Yadav [ avnish.yadav ]
          Hide
          Permalink
          avnish.yadav Avnish Yadav (Inactive) added a comment -

          Hi Aniruddha Dev,

          We have completed correction on Five Guys main company for following scenario:-
          1. Duplicate Elections
          2. Orphan Rates

          Can you please verify this correction on file and UI. Please let us know in case of any issue/concern.

          Thanks,
          Avnish Y

          CC-- Jyoti Mayne,Satya

          Show
          avnish.yadav Avnish Yadav (Inactive) added a comment - Hi Aniruddha Dev , We have completed correction on Five Guys main company for following scenario:- 1. Duplicate Elections 2. Orphan Rates Can you please verify this correction on file and UI. Please let us know in case of any issue/concern. Thanks, Avnish Y CC-- Jyoti Mayne , Satya
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Assignee Avnish Yadav [ avnish.yadav ] Aniruddha Dev [ aniruddha.dev ]
          Hide
          Permalink
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Hi Jennifer Johnson ,

          We have scanned data for below mentioned scenarios on Five Guys production and corrected data for highlighted scenarios (Please refer the table in Avnish's above comment)

          • Duplicate Elections
          • Member Deleted Entry in Coverage
          • Orphan Rates
          • Rates Beyond End Date
          • Plan End Election Active
          • Duplicate Rates
          • Wrong Member Coverage
          • Members Not In Coverage Table
          • Terminated Employees Active Election

          We have verified this on UI as well as on Payroll file. Password for Correction_Reports.zip is sent you in separate email .

          Can you please verify this at your end and close this JIRA ?

          Please let us know in case of any queries/issues.

          Thanks & Regards,
          Aniruddha Dev

          CC:Hrishikesh Deshpande Vinayak Kulkarni Satya

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Hi Jennifer Johnson , We have scanned data for below mentioned scenarios on Five Guys production and corrected data for highlighted scenarios (Please refer the table in Avnish's above comment) Duplicate Elections Member Deleted Entry in Coverage Orphan Rates Rates Beyond End Date Plan End Election Active Duplicate Rates Wrong Member Coverage Members Not In Coverage Table Terminated Employees Active Election We have verified this on UI as well as on Payroll file. Password for Correction_Reports.zip is sent you in separate email . Can you please verify this at your end and close this JIRA ? Please let us know in case of any queries/issues. Thanks & Regards, Aniruddha Dev CC: Hrishikesh Deshpande Vinayak Kulkarni Satya
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Assignee Aniruddha Dev [ aniruddha.dev ] Jennifer Fernandes [ jjsassy99 ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Remaining Estimate 5h [ 18000 ]
          Original Estimate 5h [ 18000 ]
          Permalink
          aniruddha.dev Aniruddha Dev (Inactive) logged work - 09/Feb/17 01:29 PM
          • Time Spent:
            3.5h
             
            <No comment>
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Remaining Estimate 5h [ 18000 ] 4.5h [ 16200 ]
          Time Spent 0.5h [ 1800 ]
          Worklog Id 24109 [ 24109 ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Remaining Estimate 4.5h [ 16200 ] 1h [ 3600 ]
          Time Spent 0.5h [ 1800 ] 4h [ 14400 ]
          Worklog Id 24110 [ 24110 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Remaining Estimate 1h [ 3600 ] 0h [ 0 ]
          Time Spent 4h [ 14400 ] 12h [ 43200 ]
          Worklog Id 24230 [ 24230 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Issue Category Harbinger [ 10700 ] EBS [ 10350 ]
          Hide
          Permalink
          mandark Mandar Kulkarni (Inactive) added a comment -

          Hi Jennifer Johnson,
          Could you please update on this?

          --------------------------------------
          CC: Vijay Siddha, Satya

          Show
          mandark Mandar Kulkarni (Inactive) added a comment - Hi Jennifer Johnson , Could you please update on this? -------------------------------------- CC: Vijay Siddha , Satya
          Hide
          Permalink
          mandark Mandar Kulkarni (Inactive) added a comment -

          Confirmed with Avnish Yadav, this is already taken care of.
          Closing this ticket now, thanks.

          ------------------------------------------------------------
          CC: Vijay Siddha, Satya, Jaideep Vinchurkar

          Show
          mandark Mandar Kulkarni (Inactive) added a comment - Confirmed with Avnish Yadav , this is already taken care of. Closing this ticket now, thanks. ------------------------------------------------------------ CC: Vijay Siddha , Satya , Jaideep Vinchurkar
          mandark Mandar Kulkarni (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          mandark Mandar Kulkarni (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Avnish Yadav (Inactive) made transition -
          Open In Progress
          		6h 21m 1
          Mandar Kulkarni (Inactive) made transition -
          In Progress Resolved
          		134d 17h 51m 1
          Mandar Kulkarni (Inactive) made transition -
          Resolved Closed
          		3s 1

            People

            Assignee:
            jjsassy99 Jennifer Johnson (Inactive)
            Reporter:
            avnish.yadav Avnish Yadav (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 5h Original Estimate - 5h
                5h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 12h
                12h