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

Data Analysis: Prime Duplicate employees

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Reported by:
      Harbinger
    • Module:
      BenAdmin - EDS

      Description

      Hi SamirSamir,Jennifer Johnson,Jennifer Leugers

      We have found more then 4000 employees are duplicated across all prime group ,
      Please find the attached report for the same and provide the decision.

      This is already disccued with Samir over call,

      Important:
      1.Need to resolved ASAP this data will generate different problems over all modeules.
      2. ACA files are already affected from this..

      shyam sharma

        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 ] Samir [ samir ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Link This issue relates to WT-6178 [ WT-6178 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Description
            Hi @Samir,[~jjsassy99],[~jennifer.leugers]

            We have found more then 4000 employees are duplicated across all prime group ,
            Please find the attached report for the same and provide the decision.

            This is already disccued with Samir over call,

            Important:
            1.Need to resolved ASAP this data will generate different problems over all modeules.
            2. ACA files are already affected from this..

            [~shyam.sharma]
            Hi [~samir]Samir,[~jjsassy99],[~jennifer.leugers]

            We have found more then 4000 employees are duplicated across all prime group ,
            Please find the attached report for the same and provide the decision.

            This is already disccued with Samir over call,

            Important:
            1.Need to resolved ASAP this data will generate different problems over all modeules.
            2. ACA files are already affected from this..

            [~shyam.sharma]
            samir Samir made changes -
            Assignee Samir [ samir ] Satya [ ID10004 ]
            satyap Satya made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            satyap Satya made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            Hide
            satyap Satya added a comment -

            Hi Jennifer,

            Please find attached list of duplicate employees in Prime Healthcare. Prime Duplicate employee.zip

            Sharing password through mail. Below is the summary for count across companies:

            Company name Total
            AH 33
            CHMC 15
            DMC 1
            EHMC 1
            GGH 4
            HMC 10
            KMC 8
            PMC 1
            Prime Healthcare 2049
            PrimeHealthcare 2045
            Southern Regional 1
            SRMC 43
            Grand Total 4211

            Can we have approval to get the duplicates deleted?

            Regards,
            Satya Prakash

            Cc: Amber Love-Jones Samir Nandkumar Prabhakar Karlekar Vijay Siddha

            Show
            satyap Satya added a comment - Hi Jennifer, Please find attached list of duplicate employees in Prime Healthcare. Prime Duplicate employee.zip Sharing password through mail. Below is the summary for count across companies: Company name Total AH 33 CHMC 15 DMC 1 EHMC 1 GGH 4 HMC 10 KMC 8 PMC 1 Prime Healthcare 2049 PrimeHealthcare 2045 Southern Regional 1 SRMC 43 Grand Total 4211 Can we have approval to get the duplicates deleted? Regards, Satya Prakash Cc: Amber Love-Jones Samir Nandkumar Prabhakar Karlekar Vijay Siddha
            satyap Satya made changes -
            Assignee Satya [ ID10004 ] Jennifer Fernandes [ jjsassy99 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello,

            Please delete all duplicate employees.

            Thank you!

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello, Please delete all duplicate employees. Thank you!
            Hide
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Satya

            *Problem Statement: *

            Some employees are present in more than one company so we need to delete these employees from one of the company.

            What we need:

            which employee need to be deleted from which company. we need the excel sheet that specifying following information so we will delete these employees from specified company.

            SSN Company
            999999999 Prime Healthcare

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Satya *Problem Statement: * Some employees are present in more than one company so we need to delete these employees from one of the company. What we need: which employee need to be deleted from which company. we need the excel sheet that specifying following information so we will delete these employees from specified company. SSN Company 999999999 Prime Healthcare
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Please send Amber Love-Jones the password.

            Thank you.

            Show
            alov Amber Love-Jones (Inactive) added a comment - Please send Amber Love-Jones the password. Thank you.
            jjsassy99 Jennifer Johnson (Inactive) made changes -
            Attachment Prime Duplicate employee_Jenni.xls [ 34916 ]
            Hide
            jjsassy99 Jennifer Johnson (Inactive) added a comment -

            Prime Duplicate employee_Jenni.xls

            Please see full list - Password will be send in email -

            for the Possible transfers - Please leave as is - do not remove

            Jenni

            Show
            jjsassy99 Jennifer Johnson (Inactive) added a comment - Prime Duplicate employee_Jenni.xls Please see full list - Password will be send in email - for the Possible transfers - Please leave as is - do not remove Jenni
            satyap Satya made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            satyap Satya made changes -
            Assignee Jennifer Fernandes [ jjsassy99 ] Nandkumar [ satyap ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 13/Dec/16 08:20 AM - edited
            • Time Spent:
              1h
               
              <No comment>
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 28h [ 100800 ]
            Original Estimate 28h [ 100800 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 28h [ 100800 ] 24h [ 86400 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 12890 [ 12890 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 24h [ 86400 ] 20h [ 72000 ]
            Time Spent 4h [ 14400 ] 8h [ 28800 ]
            Worklog Id 12891 [ 12891 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 20h [ 72000 ] 23h [ 82800 ]
            Time Spent 8h [ 28800 ] 5h [ 18000 ]
            Worklog Id 12890 [ 12890 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 14/Dec/16 11:22 AM
            • Time Spent:
              4h
               
              <No comment>
            satyap Satya made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: EDS(10108)
            Hide
            mandark Mandar Kulkarni (Inactive) added a comment -

            Hi Nandkumar Prabhakar Karlekar,
            Shall we close this ticket now?

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

            Show
            mandark Mandar Kulkarni (Inactive) added a comment - Hi Nandkumar Prabhakar Karlekar , Shall we close this ticket now? --------------------------------------- CC: Vijay Siddha , Satya
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Nandkumar Prabhakar Karlekar,

            Yes, please close the ticket.

            Thank you!

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Nandkumar Prabhakar Karlekar , Yes, please close the ticket. Thank you! Amber
            mandark Mandar Kulkarni (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            mandark Mandar Kulkarni (Inactive) made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Satya made transition -
            Open In Progress
            28d 8h 41m 1
            Satya made transition -
            In Progress Waiting for Customer Input
            6s 1
            Satya made transition -
            Waiting for Customer Input In Progress
            3d 21h 26m 1
            Mandar Kulkarni (Inactive) made transition -
            In Progress Resolved
            283d 11h 27m 1
            Mandar Kulkarni (Inactive) made transition -
            Resolved Closed
            16s 1

              People

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

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 28h
                  28h
                  Remaining:
                  Time Spent - 5h Remaining Estimate - 23h
                  23h
                  Logged:
                  Time Spent - 5h Remaining Estimate - 23h
                  5h