Workterra BenAdminProject Type: business

Workterra BenAdmin

Uploaded image for project: 'Workterra BenAdmin'
  1. Workterra BenAdmin
  2. WB-178

Data Audit of Jan & Feb 2018

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Labels:
      None
    • Support Task Type:
      Data Audit
    • Environment:
      Production
    • Company:
      All Clients/Multiple Clients
    • Categories:
      Enrollment
    • Reported by:
      Client

      Description

      Data Audit on production for Jan & Feb 2018

        Attachments

          Issue Links

          relates to

          Support Activity - Support Activity WB-173 Data Audit - University Health - Duplicate Election

          • Medium - Has the potential to affect progress.
          • Closed

          Support Activity - Support Activity WB-187 Data Audit - Nations - Duplicate rates

          • Medium - Has the potential to affect progress.
          • Closed

          Support Activity - Support Activity WB-195 Data Audit - Decurion - Duplicate rates

          • Medium - Has the potential to affect progress.
          • Closed

          Support Activity - Support Activity WB-196 Data Audit - CVHP - Duplicate rates and Duplicate Election

          • Medium - Has the potential to affect progress.
          • Closed

          Support Activity - Support Activity WB-197 Data Audit - STEP - Duplicate rates

          • Medium - Has the potential to affect progress.
          • Closed

          Support Activity - Support Activity WB-199 Data Audit - Austin - Duplicate rates

          • Medium - Has the potential to affect progress.
          • Closed

          Support Activity - Support Activity WT-13447 Data Audit - Prime healthcare - Duplicate rates

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Descending order - Click to sort in ascending order
            Hide
            Permalink
            satyap Satya added a comment -

            Closing this ticket since March & April 2018 data audit activity has been started.

             

            Regards,

            Satya Prakash

             

            Cc: Rohan J Khandave Prashant Samal Vinanti Yadav

            Show
            satyap Satya added a comment - Closing this ticket since March & April 2018 data audit activity has been started.   Regards, Satya Prakash   Cc: Rohan J Khandave Prashant Samal Vinanti Yadav
            Hide
            Permalink
            Prashant.samal Prashant Samal (Inactive) added a comment -

            All the linked tickets for Data Audit ON HOLD, we start accordingly on the confirmation of Data Audit final POC.

             

            Rohan J Khandave Satya Monika Demla Abhay Patil

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - All the linked tickets for Data Audit ON HOLD, we start accordingly on the confirmation of Data Audit final POC.   Rohan J Khandave Satya Monika Demla Abhay Patil
            Hide
            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) added a comment -

            Data Audit : Feb 2018 Status

            We have completed data audit for below criteria and correction is done for non impacted data.

            1. Duplicate Elections
            2. Duplicate Rates
            3. Orphan Rates
            4. Null Health Tier ID
            5. Member Not In Coverage Table
            6. Member Deleted Coverage Entry
            7. Plan End Election Active
            8. Rates Beyond End Date
            9. Wrong Health Tier
            10. Wrong Member Coverage
            11. Terminated Employee Active Elections

            CC : Harshawardhan Phalake, Rohan J Khandave, Prashant Samal

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - Data Audit : Feb 2018 Status We have completed data audit for below criteria and correction is done for non impacted data. 1. Duplicate Elections 2. Duplicate Rates 3. Orphan Rates 4. Null Health Tier ID 5. Member Not In Coverage Table 6. Member Deleted Coverage Entry 7. Plan End Election Active 8. Rates Beyond End Date 9. Wrong Health Tier 10. Wrong Member Coverage 11. Terminated Employee Active Elections CC : Harshawardhan Phalake , Rohan J Khandave , Prashant Samal
            Hide
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) added a comment -

            Hi Hrishikesh Deshpande,

            We have done data correction for non impacted company for :
            1. Plan End Election Active Data.
            Please refer attached sheet for the details
            PlanEndElectionActive.xls
            So could you please verify above corrected records.
            let me know if you need more details.
            Thanks,
            Harshawardhan
            CC:
            Vinanti Yadav,Prashant Samal,Jyoti Mayne,Rohan J Khandave,Umesh Kadam

            Show
            harshawardhan Harshawardhan Phalake (Inactive) added a comment - Hi Hrishikesh Deshpande , We have done data correction for non impacted company for : 1. Plan End Election Active Data. Please refer attached sheet for the details PlanEndElectionActive.xls So could you please verify above corrected records. let me know if you need more details. Thanks, Harshawardhan CC: Vinanti Yadav , Prashant Samal , Jyoti Mayne , Rohan J Khandave , Umesh Kadam
            Hide
            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - - edited

            Hi Hrishikesh Deshpande,

            We have done data correction for non impacted company for :

            1. NULL Health Tier ID (Affected Records mention in excel 'NullHealthTierIDStatus.xls)'
            2. Member Not In Coverage Table. (Affected records mentioned in excel 'MembersNotInCoverageTable-Data.xls' )
            3. Duplicate Rates .
            4. Duplicate Election. (PFA for affected records for Duplicate rate and duplicate election DuplicateRates_DuplicateElectionAffectedRecordsDetails.xls .)

            So could you please verify above corrected records.
            let me know if you need more details.

            Thanks,
            Vinanti

            CC : Harshawardhan Phalake , Prashant Samal, Jyoti Mayne, Rohan J Khandave, Satya

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - - edited Hi Hrishikesh Deshpande , We have done data correction for non impacted company for : 1. NULL Health Tier ID (Affected Records mention in excel 'NullHealthTierIDStatus.xls)' 2. Member Not In Coverage Table. (Affected records mentioned in excel 'MembersNotInCoverageTable-Data.xls' ) 3. Duplicate Rates . 4. Duplicate Election. (PFA for affected records for Duplicate rate and duplicate election DuplicateRates_DuplicateElectionAffectedRecordsDetails.xls .) So could you please verify above corrected records. let me know if you need more details. Thanks, Vinanti CC : Harshawardhan Phalake , Prashant Samal , Jyoti Mayne , Rohan J Khandave , Satya
            Hide
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) added a comment - - edited

            Member Note In coverage table Correction is done for below listed companies from document.

            Company Status
            CityofDenton_1365 As impacted data is there not corrected all the record (1 record)
            COSB_12952 Correction is done for all records (1 record)
            GroendykeTransportInc_12007 All data is in correct format no need to do correction
            LHP_Hospital_Group_Inc_11616 Correction is done for all records (4 record)
            Select_Staff_11669 All data is in correct format no need to do correction
            Stimson_12083 Correction is done for all records (9 record)
            TIBCO_12472 Corrected 1 record 3 records are impacted not corrected them
            UniversityHealth_13593 Correction is done for all records (5 record)

            MembersNotInCoverageTable-Data.xls

            Thanks,
            Harshawardhan.
            CC: Rohan J Khandave, Jyoti Mayne

            Show
            harshawardhan Harshawardhan Phalake (Inactive) added a comment - - edited Member Note In coverage table Correction is done for below listed companies from document. Company Status CityofDenton_1365 As impacted data is there not corrected all the record (1 record) COSB_12952 Correction is done for all records (1 record) GroendykeTransportInc_12007 All data is in correct format no need to do correction LHP_Hospital_Group_Inc_11616 Correction is done for all records (4 record) Select_Staff_11669 All data is in correct format no need to do correction Stimson_12083 Correction is done for all records (9 record) TIBCO_12472 Corrected 1 record 3 records are impacted not corrected them UniversityHealth_13593 Correction is done for all records (5 record) MembersNotInCoverageTable-Data.xls Thanks, Harshawardhan. CC: Rohan J Khandave , Jyoti Mayne
            Hide
            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) added a comment -

            Hi All,

            Data correction is completed for below categories:
            1. Null Health Tier ID ( PFA for more details NullHealthTierIDStatus.xls)
            2. Duplicate Rates : data correction is completed for non impacted company records (Prime Healthcare and Decurion).

            Thanks,
            Vinanti

            CC : Jyoti Mayne, Rohan J Khandave, Umesh Kadam, Prashant Samal

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi All, Data correction is completed for below categories: 1. Null Health Tier ID ( PFA for more details NullHealthTierIDStatus.xls ) 2. Duplicate Rates : data correction is completed for non impacted company records (Prime Healthcare and Decurion). Thanks, Vinanti CC : Jyoti Mayne , Rohan J Khandave , Umesh Kadam , Prashant Samal

              People

              Assignee:
              vinanti.yadav Vinanti Yadav (Inactive)
              Reporter:
              sachin.hingole Sachin Hingole (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 100h Original Estimate - 100h
                  100h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 277h
                  277h