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

            Ascending order - Click to sort in descending order
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 16/Feb/18 11:23 AM - edited
            • Time Spent:
              6.5h
               

              Data Audit Duplicate Rates

            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) logged work - 16/Feb/18 01:35 PM
            • Time Spent:
              5h
               

              Members Not in Coverage table data analysis and preparing SQl Queries .

            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 16/Feb/18 04:23 PM
            • Time Spent:
              6h
               
              • Discussion.
              • Analysis.
              • Data Correction for NULL Health Tier ID for below Company :
                1. Amherst Central School District.
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 16/Feb/18 06:16 PM
            • Time Spent:
              8h
               

              Data audit

              Duplicate rates analysis
              finding impacted templates and employees.

            sachin.hingole Sachin Hingole (Inactive) created issue -
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Field Original Value New Value
            Status Open [ 1 ] In Progress [ 3 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Developer Vinanti Yadav [ vinanti.yadav ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 19/Feb/18 11:14 AM
            • Time Spent:
              4h
               

              Data Audit Duplicate Rates

            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Remaining Estimate 100h [ 360000 ]
            Original Estimate 100h [ 360000 ]
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) logged work - 19/Feb/18 01:36 PM
            • Time Spent:
              8h
               

              Data correction for Members Not in Coverage table data and execution.

            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Remaining Estimate 100h [ 360000 ] 95h [ 342000 ]
            Time Spent 5h [ 18000 ]
            Worklog Id 105234 [ 105234 ]
            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Remaining Estimate 95h [ 342000 ] 87h [ 313200 ]
            Time Spent 5h [ 18000 ] 13h [ 46800 ]
            Worklog Id 105235 [ 105235 ]
            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 19/Feb/18 04:29 PM - edited
            • Time Spent:
              8h
               
              • Data Analysis and Correction of NULL Health Tier ID for below company: - 4 hour
                1. Memorial Regional Health
                2. MGF
                3. Prime Healthcare
                4. Santa Cruz Medical Group
                5. SBSC
                6. Stimson
                7. Town of Cary
                8. UND
                9. CareerBuilder Account
              • Data Analysis and Correction of Members Not In Coverage Table Data for below company : - 4h
                1. Stimson
                2. University Health
                3. TIBCO
            Permalink
            jyoti.mayne Jyoti Mayne logged work - 19/Feb/18 04:32 PM - edited
            • Time Spent:
              1h
               

              null health tier and member not in coverage tier analysis and discussion with Harsh and Vinanti

            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 19/Feb/18 06:19 PM
            • Time Spent:
              8h
               

              Data audit

              Duplicate rates analysis
              finding impacted templates and employees.
              Updating sheet according to observation.

            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Remaining Estimate 87h [ 313200 ] 81h [ 291600 ]
            Time Spent 13h [ 46800 ] 19h [ 68400 ]
            Worklog Id 105272 [ 105272 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Remaining Estimate 81h [ 291600 ] 73h [ 262800 ]
            Time Spent 19h [ 68400 ] 27h [ 97200 ]
            Worklog Id 105273 [ 105273 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Worklog Id 105273 [ 105273 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Remaining Estimate 73h [ 262800 ] 65h [ 234000 ]
            Time Spent 27h [ 97200 ] 35h [ 126000 ]
            Worklog Id 105280 [ 105280 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Remaining Estimate 65h [ 234000 ] 57h [ 205200 ]
            Time Spent 35h [ 126000 ] 43h [ 154800 ]
            Worklog Id 105281 [ 105281 ]
            Permalink
            Prajakta.belhe Prajakta Belhe (Inactive) logged work - 20/Feb/18 09:27 AM - edited
            • Time Spent:
              4h
               
              <No comment>
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Remaining Estimate 57h [ 205200 ] 53h [ 190800 ]
            Time Spent 43h [ 154800 ] 47h [ 169200 ]
            Worklog Id 105318 [ 105318 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 20/Feb/18 11:16 AM
            • Time Spent:
              6h
               

              Data Audit Duplicate Rates and Duplicate Elections

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Remaining Estimate 53h [ 190800 ] 47h [ 169200 ]
            Time Spent 47h [ 169200 ] 53h [ 190800 ]
            Worklog Id 105320 [ 105320 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Remaining Estimate 47h [ 169200 ] 40.5h [ 145800 ]
            Time Spent 53h [ 190800 ] 59.5h [ 214200 ]
            Worklog Id 105321 [ 105321 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Worklog Id 105321 [ 105321 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Attachment NullHealthTierIDStatus.xls [ 73613 ]
            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
            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
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) logged work - 20/Feb/18 01:15 PM
            • Time Spent:
              8h
               

              Taking back up for Prime and Decurion before correction on production for Duplicate Rate Corrections.
              Dead the duplicate rates from Prime Correction for Plan IDS :- 58,60,69,72,73,74 and RateID - 512
              Total corrections - 3640

            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Attachment MembersNotInCoverageTable-Data.xls [ 73614 ]
            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Remaining Estimate 40.5h [ 145800 ] 32.5h [ 117000 ]
            Time Spent 59.5h [ 214200 ] 67.5h [ 243000 ]
            Worklog Id 105355 [ 105355 ]
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 20/Feb/18 04:24 PM
            • Time Spent:
              8h
               

              Data audit for duplicate elections.
              Updating sheets and providing updates.

            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 20/Feb/18 04:40 PM
            • Time Spent:
              8h
               

              Data Correction of Duplicate Rates on Prime Healthcare & Decurion.
              Issue analysis for Decurion.
              Discussion.

            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Remaining Estimate 32.5h [ 117000 ] 24.5h [ 88200 ]
            Time Spent 67.5h [ 243000 ] 75.5h [ 271800 ]
            Worklog Id 105391 [ 105391 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Attachment DuplicateRates_DuplicateElectionAffectedRecordsDetails.xls [ 73649 ]
            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
            Permalink
            Prajakta.belhe Prajakta Belhe (Inactive) logged work - 21/Feb/18 09:17 AM - edited
            • Time Spent:
              6h
               

              Data Aufit - plan term election efective

            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 21/Feb/18 10:31 AM
            • Time Spent:
              7h
               

              Duplicate Rates analysis

            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 21/Feb/18 12:34 PM
            • Time Spent:
              4h
               

              Data Correction of Duplicate Election on PrimeHealthcare.
              Email Communication : Data Audit Correction Status.

            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Remaining Estimate 24.5h [ 88200 ] 20.5h [ 73800 ]
            Time Spent 75.5h [ 271800 ] 79.5h [ 286200 ]
            Worklog Id 105451 [ 105451 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 21/Feb/18 12:51 PM
            • Time Spent:
              5h
               

              Data Audit Plan End Election Active
              Companies
              Precision
              Miller Sierra
              JCCC
              Intrepid USA
              Hallmark Aviation Services
              Elite staffing

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Remaining Estimate 20.5h [ 73800 ] 15.5h [ 55800 ]
            Time Spent 79.5h [ 286200 ] 84.5h [ 304200 ]
            Worklog Id 105460 [ 105460 ]
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) logged work - 21/Feb/18 03:12 PM
            • Time Spent:
              1h
               

              Discussion and analysis

            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Remaining Estimate 15.5h [ 55800 ] 14.5h [ 52200 ]
            Time Spent 84.5h [ 304200 ] 85.5h [ 307800 ]
            Worklog Id 105481 [ 105481 ]
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 21/Feb/18 04:21 PM
            • Time Spent:
              2h
               

              Plan end election active companies distribution
              Analysis
              And data audit for below companies
              AFFCO
              Alecto

            Permalink
            jyoti.mayne Jyoti Mayne logged work - 21/Feb/18 05:11 PM
            • Time Spent:
              1h
               

              data correction discussion with team

            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Remaining Estimate 14.5h [ 52200 ] 12.5h [ 45000 ]
            Time Spent 85.5h [ 307800 ] 87.5h [ 315000 ]
            Worklog Id 105499 [ 105499 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Remaining Estimate 12.5h [ 45000 ] 4.5h [ 16200 ]
            Time Spent 87.5h [ 315000 ] 95.5h [ 343800 ]
            Worklog Id 105501 [ 105501 ]
            Prajakta.belhe Prajakta Belhe (Inactive) made changes -
            Remaining Estimate 4.5h [ 16200 ] 0h [ 0 ]
            Time Spent 95.5h [ 343800 ] 101.5h [ 365400 ]
            Worklog Id 105569 [ 105569 ]
            Prajakta.belhe Prajakta Belhe (Inactive) made changes -
            Worklog Id 105569 [ 105569 ]
            Prajakta.belhe Prajakta Belhe (Inactive) made changes -
            Time Spent 101.5h [ 365400 ] 105.5h [ 379800 ]
            Worklog Id 105604 [ 105604 ]
            Prajakta.belhe Prajakta Belhe (Inactive) made changes -
            Worklog Id 105604 [ 105604 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 105.5h [ 379800 ] 112.5h [ 405000 ]
            Worklog Id 105698 [ 105698 ]
            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 22/Feb/18 10:53 AM
            • Time Spent:
              1h
               

              Discussion.
              Email communication.

            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Time Spent 112.5h [ 405000 ] 113.5h [ 408600 ]
            Worklog Id 105771 [ 105771 ]
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 22/Feb/18 11:19 AM
            • Time Spent:
              8h
               

              Data Audit : Plan end election active

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 22/Feb/18 11:19 AM
            • Time Spent:
              6h
               

              Data Audit - Plan End Election Active

            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 113.5h [ 408600 ] 121.5h [ 437400 ]
            Worklog Id 105837 [ 105837 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 121.5h [ 437400 ] 127.5h [ 459000 ]
            Worklog Id 105838 [ 105838 ]
            Permalink
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 22/Feb/18 11:42 AM
            • Time Spent:
              1h
               
              <No comment>
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Time Spent 127.5h [ 459000 ] 128.5h [ 462600 ]
            Worklog Id 105894 [ 105894 ]
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 22/Feb/18 12:59 PM
            • Time Spent:
              2.5h
               

              Internal discussion
              Testing

            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Time Spent 128.5h [ 462600 ] 131h [ 471600 ]
            Worklog Id 105972 [ 105972 ]
            Permalink
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 22/Feb/18 01:05 PM
            • Time Spent:
              1h
               

              Testing

            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Time Spent 131h [ 471600 ] 132h [ 475200 ]
            Worklog Id 105981 [ 105981 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Link This issue relates to WT-13438 [ WT-13438 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Link This issue relates to WT-13439 [ WT-13439 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Link This issue relates to WT-13437 [ WT-13437 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Link This issue relates to WT-13436 [ WT-13436 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Link This issue relates to WT-13435 [ WT-13435 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Link This issue relates to WT-13434 [ WT-13434 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Link This issue relates to WT-13433 [ WT-13433 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Link This issue relates to WT-13432 [ WT-13432 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Link This issue relates to WT-13431 [ WT-13431 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Link This issue relates to WT-13430 [ WT-13430 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Link This issue relates to WT-13429 [ WT-13429 ]
            Permalink
            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 23/Feb/18 12:33 PM
            • Time Spent:
              0.5h
               

              Testing
              Internal discussion

            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Time Spent 132h [ 475200 ] 132.5h [ 477000 ]
            Worklog Id 106076 [ 106076 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Comment [ Hi,

            Completed testing for Duplicate rate and duplicate election.Working as expected.
            Testing of NULL Health Tier ID and Member Not In Coverage Table is In progress.

            Thanks,
            Sanjana Jadhav

            CC: [~prasadp] [~hrishikesh.deshpande] [~rakeshr]
            ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Link This issue relates to WT-13447 [ WT-13447 ]
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) logged work - 23/Feb/18 03:23 PM
            • Time Spent:
              8h
               

              Analysis discussion with rohan
              Analysis for Plan end election active
              Document Preparation for Client.
              Review Data

            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Time Spent 132.5h [ 477000 ] 140.5h [ 505800 ]
            Worklog Id 106121 [ 106121 ]
            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Attachment PlanEndElectionActive.xls [ 73797 ]
            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
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) logged work - 26/Feb/18 01:06 PM
            • Time Spent:
              7h
               

              data audit - Plan end election active - correction for non impacted and non UHC/White-label company's ,preparing documents for QA analysis.
              Correction Done on company :
              1. Southland
              2. Prime Healthcare
              3. Ohio Northern University
              4. Superheat FGH - Except 2nd record
              5. HMC
              Discussion with Vinanati and Rohan

            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Time Spent 140.5h [ 505800 ] 147.5h [ 531000 ]
            Worklog Id 106298 [ 106298 ]
            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 26/Feb/18 01:19 PM
            • Time Spent:
              3.75h
               

              Data analysis and correction of Plan End Election Active for below companies:

              1. Karma
              2. CAISO
              3. SRMC
              4. Prime Healthcare
              5. Santa Cruz Medical Group

              Discussion.

            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Time Spent 147.5h [ 531000 ] 151.25h [ 544500 ]
            Worklog Id 106315 [ 106315 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 27/Feb/18 12:36 PM
            • Time Spent:
              5h
               

              Data Audit -Rate beyond end dates

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 151.25h [ 544500 ] 156.25h [ 562500 ]
            Worklog Id 106465 [ 106465 ]
            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 27/Feb/18 01:09 PM
            • Time Spent:
              8h
               

              Data filtration and Analysis of Plan End Election Active.

            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Time Spent 156.25h [ 562500 ] 164.25h [ 591300 ]
            Worklog Id 106472 [ 106472 ]
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 27/Feb/18 04:11 PM
            • Time Spent:
              1.75h
               

              Data audit-Rate beyond end date.

            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) logged work - 28/Feb/18 03:13 PM
            • Time Spent:
              5h
               

              Rates beyond Date data audit analysis for the companies affected and for the records.

            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Time Spent 164.25h [ 591300 ] 169.25h [ 609300 ]
            Worklog Id 106738 [ 106738 ]
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 28/Feb/18 04:13 PM
            • Time Spent:
              6.25h
               

              Data audit-Rate beyond end date
              Updating sheet and providing status on same.

            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 169.25h [ 609300 ] 171h [ 615600 ]
            Worklog Id 106760 [ 106760 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 171h [ 615600 ] 177.25h [ 638100 ]
            Worklog Id 106762 [ 106762 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 177.25h [ 638100 ] 178.25h [ 641700 ]
            Worklog Id 106769 [ 106769 ]
            jyoti.mayne Jyoti Mayne made changes -
            Worklog Id 106769 [ 106769 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 178.25h [ 641700 ] 179.25h [ 645300 ]
            Worklog Id 106795 [ 106795 ]
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) logged work - 01/Mar/18 12:58 PM
            • Time Spent:
              3h
               

              Data Audit for Rate Beyond End date scenario and Preparing document, analysis data ,discussion with Vinanti.

            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Time Spent 179.25h [ 645300 ] 182.25h [ 656100 ]
            Worklog Id 106887 [ 106887 ]
            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 01/Mar/18 01:08 PM
            • Time Spent:
              7h
               

              Data filtration and Analysis of Rates Beyond End Date

            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Time Spent 182.25h [ 656100 ] 189.25h [ 681300 ]
            Worklog Id 106893 [ 106893 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: Enrollment(18482)
            Component/s BenAdmin [ 10000 ]
            Key WT-13391 WB-178
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Status In Progress [ 3 ] In Development [ 10007 ]
            Workflow WT_Support [ 64075 ] WB - Workterra BenAdmin Support workflow [ 64972 ]
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) logged work - 03/Mar/18 01:03 PM
            • Time Spent:
              8h
               

              Production Build issue fixes and testing

            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) logged work - 04/Mar/18 01:04 PM
            • Time Spent:
              8h
               

              Production Build issue fixes and testing

            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Time Spent 189.25h [ 681300 ] 197.25h [ 710100 ]
            Worklog Id 107010 [ 107010 ]
            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Time Spent 197.25h [ 710100 ] 205.25h [ 738900 ]
            Worklog Id 107011 [ 107011 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 05/Mar/18 10:16 AM
            • Time Spent:
              6.5h
               

              Data Audit -Wrong member coverage

              Finding the impact for the employees through backend , discussing the same for the impacted scenarios  

               

            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 05/Mar/18 04:31 PM
            • Time Spent:
              2h
               

              Analysis of Rates Beyond End Date.

            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Time Spent 205.25h [ 738900 ] 207.25h [ 746100 ]
            Worklog Id 107140 [ 107140 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 207.25h [ 746100 ] 214.75h [ 773100 ]
            Worklog Id 107147 [ 107147 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 06/Mar/18 03:28 PM
            • Time Spent:
              7.25h
               

              Billing Data Audit script writing for below Scenarios

              • Duplicate Records
              • Overlapping Billing Records
              • Enrollment Does not exists
              • Rates does not exists
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 06/Mar/18 04:07 PM
            • Time Spent:
              3.5h
               

              Data audit Wrong member coverage

            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 06/Mar/18 04:51 PM
            • Time Spent:
              1h
               

              Data Analysis of Wrong Health Tier Criteria for below company :
              1. Amherst Central School District.
              2. Prime Healthcare.

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 214.75h [ 773100 ] 218.25h [ 785700 ]
            Worklog Id 107311 [ 107311 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Time Spent 218.25h [ 785700 ] 219.25h [ 789300 ]
            Worklog Id 107321 [ 107321 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 07/Mar/18 05:23 AM - edited
            • Time Spent:
              7.5h
               

              Data Audit - Wrong Health Tier
              Amherst Central School District
              City of Lynnwood
              ILG
              Memorial Regional Health
              MGF
              Prime healthcare
              SBSC
              university health
              Tibco
              The Packard Companies
              County of San Luis Obispo

            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 07/Mar/18 03:30 PM
            • Time Spent:
              7h
               

              Billing Data Audit script review and changes for below Scenarios

              • Duplicate Records
              • Overlapping Billing Records
              • Enrollment Does not exists
              • Rates does not exists
              • Rates proper but billing continue
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow WB - Workterra BenAdmin Support workflow [ 64972 ] 0803 Copy of WB - Workterra BenAdmin Support workflow [ 65952 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 08/Mar/18 03:35 PM
            • Time Spent:
              7h
               

              Billing Data Audit scripts writing for suggested scenarios by Amruta

            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 09/Mar/18 03:25 PM
            • Time Spent:
              5h
               

              Billing Data Audit script writing for Scenarios- Overlapping Billing Records but not in rates

            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 09/Mar/18 05:08 PM - edited
            • Time Spent:
              5h
               

              Analysis and data filtration of Wrong Health Tier for below companies :

              1. Amherst Central School District
              2. CareerBuilder Account
              3. City of Lynnwood
              4. County of San Luis Obispo
              5. ILG
              6. Memorial Regional Health
              7. MGF
              8. Prime Healthcare
              9. SBSC
              10. The Packard Companies
              11. TIBCO
              12. UND
              13. University Health
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Time Spent 219.25h [ 789300 ] 224.25h [ 807300 ]
            Worklog Id 107792 [ 107792 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Worklog Id 107792 [ 107792 ]
            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 12/Mar/18 09:42 AM - edited
            • Time Spent:
              4.5h
               
              • Data Audit of Terminated Employee having Active Election for below company.
                1. Virgin
                2. CSE
                3. Optimum
                Data correction and verification on Optimum(2 Records)
              • JIRA Updates.
              • Discussions.
            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
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 12/Mar/18 02:23 PM - edited
            • Time Spent:
              3.5h
               

              Billing Data audit for all companies on Production

            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Time Spent 224.25h [ 807300 ] 228.75h [ 823500 ]
            Worklog Id 108075 [ 108075 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Worklog Id 108075 [ 108075 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 228.75h [ 823500 ] 232.25h [ 836100 ]
            Worklog Id 108139 [ 108139 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Worklog Id 108139 [ 108139 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 232.25h [ 836100 ] 237.25h [ 854100 ]
            Worklog Id 108140 [ 108140 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 237.25h [ 854100 ] 244.5h [ 880200 ]
            Worklog Id 108141 [ 108141 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 244.5h [ 880200 ] 251.5h [ 905400 ]
            Worklog Id 108142 [ 108142 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 14/Mar/18 02:33 PM - edited
            • Time Spent:
              3.5h
               

              Cross verification of Billing Audit Data
              Scenario wise Billing Data Sheet creation

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 251.5h [ 905400 ] 255h [ 918000 ]
            Worklog Id 108594 [ 108594 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 255h [ 918000 ] 262h [ 943200 ]
            Worklog Id 108595 [ 108595 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 16/Mar/18 02:20 PM
            • Time Spent:
              2.5h
               

              Script for Billing Duplicate records correction and script testing on HSPL company

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 262h [ 943200 ] 264.5h [ 952200 ]
            Worklog Id 108860 [ 108860 ]
            Permalink
            vinanti.yadav Vinanti Yadav (Inactive) logged work - 25/Mar/18 10:20 PM
            • Time Spent:
              6h
               
              • Written scanning script for below criteria :
              1. Find total number of count Generic eligibility rules.
              2. Find total number of count Generic eligibility rules having additional criteria more than 9.
              3. Find active election count of medical benefit type for all companies(Plan wise). 
              4. Find active election count of medical benefit type for all companies(Provider wise). 
              5. Find count of election according to employee age for medical benefit.
              6. Find count of election according to employee salary for medical benefit.
              • Data scanning for above all criteria.

               

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Worklog Id 107147 [ 107147 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 264.5h [ 952200 ] 271h [ 975600 ]
            Worklog Id 109896 [ 109896 ]
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Time Spent 271h [ 975600 ] 277h [ 997200 ]
            Worklog Id 109902 [ 109902 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Worklog Id 108594 [ 108594 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Status In Development [ 10007 ] On Hold [ 10507 ]
            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
            vinanti.yadav Vinanti Yadav (Inactive) made changes -
            Assignee Vinanti Yadav [ vinanti.yadav ] Prashant Samal [ prashant.samal ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Assignee Prashant Samal [ prashant.samal ] Vinanti Yadav [ vinanti.yadav ]
            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
            satyap Satya made changes -
            Status On Hold [ 10507 ] In Development [ 10007 ]
            satyap Satya made changes -
            Resolution Done [ 10000 ]
            Status In Development [ 10007 ] Resolved [ 5 ]
            satyap Satya made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Vinanti Yadav (Inactive) made transition -
            Open In Progress
            		9m 52s 1
            Prashant Samal (Inactive) made transition -
            In Progress In Development
            		11d 23h 16m 1
            Prashant Samal (Inactive) made transition -
            In Development On Hold
            		47d 13h 44m 1
            Satya made transition -
            On Hold In Development
            		20d 9h 43m 1
            Satya made transition -
            In Development Resolved
            		35s 1
            Satya made transition -
            Resolved Closed
            		22s 1

              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