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
          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
          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
          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
          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
          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

            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