WORKTERRAProject Type: software

WORKTERRA

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

Production: Data Correction for Effective date service to be executed on 1st Jan 2018.

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Environment:
      Production
    • Reported by:
      Harbinger
    • Company:
      CSE
    • Module:
      BenAdmin - Enrollment
    • Severity:
      Simple

      Description

      14 companies whose Rates are not moved properly.

      Sr. No Company Name
      1 CVHP
      2 Softchoice
      3 FDU
      4 Prime Healthcare
      5 Liberty Hospital
      6 Groendyke TransportInc
      7 Ohio Northern University
      8 ElCamino Hospital
      9 Lily
      10 Symphony
      11 ATC
      12 UniversityHealth
      13 CSE
      14 Caring Healthcare

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          Permalink
          vinanti.yadav Vinanti Yadav (Inactive) logged work - 02/Jan/18 01:50 PM
          • Time Spent:
            6h
             

            Analysis.
            Attached to DB to Production Environment.
            data correction and verification.
            Discussion with Jyoti.

          Permalink
          jyoti.mayne Jyoti Mayne logged work - 02/Jan/18 03:29 PM
          • Time Spent:
            5.25h
             

            effective date service root cause and correction

          Permalink
          vinanti.yadav Vinanti Yadav (Inactive) logged work - 03/Jan/18 09:54 AM - edited
          • Time Spent:
            8h
             

            Analysis.
            Attached to DB to Production Environment.
            data correction and verification on
            1. FDU_1466
            2. Prime_Healthcare_Services_11614

          Permalink
          jyoti.mayne Jyoti Mayne logged work - 03/Jan/18 11:36 AM
          • Time Spent:
            1h
             

            discussion with Vinanti about scenarios and verified corrections

          Permalink
          vinanti.yadav Vinanti Yadav (Inactive) logged work - 04/Jan/18 09:04 AM
          • Time Spent:
            8h
             

            Analysis.
            Attached to DB to Production Environment.
            data correction and verification on

            • Liberty_Hosp_11803
            • GroendykeTransportInc_12007
            • OhioNorthernUniversity_12063
            • ElCaminoHospital_12099
            • Lily_12175
            • ATC_13122
            • CaringHealthcare_13712
          Permalink
          jyoti.mayne Jyoti Mayne logged work - 04/Jan/18 11:55 AM
          • Time Spent:
            0.25h
             

            data correction discussion with Vinanti

          Permalink
          vinanti.yadav Vinanti Yadav (Inactive) logged work - 05/Jan/18 09:11 AM
          • Time Spent:
            4h
             

            Analysis.
            Attached to DB to Production Environment.
            data correction and verification on
            1. UniversityHealth_13593
            2. CSE_13624

          vinanti.yadav Vinanti Yadav (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 -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Description 14 companies whose Rates are not moved properly.
          |Sr. No.|Company Name|
          |1||
          |2||
          |3||
          |4||
          |4||
          |4||
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Description 14 companies whose Rates are not moved properly.
          |Sr. No.|Company Name|
          |1||
          |2||
          |3||
          |4||
          |4||
          |4||           		14 companies whose Rates are not moved properly.
          |Sr. No.|Company Name|
          |1|CVHP|
          |2|[Softchoice|
          |3|FDU|
          |4|Prime Healthcare|
          |5|Liberty Hospital|
          |6|Groendyke TransportInc|
          |7|Ohio Northern University|
          |8|ElCamino Hospital|
          |9|Lily|
          |10|[Symphony|
          |11|ATC|
          |12|UniversityHealth|
          |13|CSE|
          |14|Caring Healthcare|
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Description 14 companies whose Rates are not moved properly.
          |Sr. No.|Company Name|
          |1|CVHP|
          |2|[Softchoice|
          |3|FDU|
          |4|Prime Healthcare|
          |5|Liberty Hospital|
          |6|Groendyke TransportInc|
          |7|Ohio Northern University|
          |8|ElCamino Hospital|
          |9|Lily|
          |10|[Symphony|
          |11|ATC|
          |12|UniversityHealth|
          |13|CSE|
          |14|Caring Healthcare|           		14 companies whose Rates are not moved properly.
          |*Sr. No*|*Company Name*|
          |1|CVHP|
          |2|[Softchoice|
          |3|FDU|
          |4|Prime Healthcare|
          |5|Liberty Hospital|
          |6|Groendyke TransportInc|
          |7|Ohio Northern University|
          |8|ElCamino Hospital|
          |9|Lily|
          |10|[Symphony|
          |11|ATC|
          |12|UniversityHealth|
          |13|CSE|
          |14|Caring Healthcare|
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Description 14 companies whose Rates are not moved properly.
          |*Sr. No*|*Company Name*|
          |1|CVHP|
          |2|[Softchoice|
          |3|FDU|
          |4|Prime Healthcare|
          |5|Liberty Hospital|
          |6|Groendyke TransportInc|
          |7|Ohio Northern University|
          |8|ElCamino Hospital|
          |9|Lily|
          |10|[Symphony|
          |11|ATC|
          |12|UniversityHealth|
          |13|CSE|
          |14|Caring Healthcare|           		14 companies whose Rates are not moved properly.
          |*Sr. No*|*Company Name*|
          |1|CVHP|
          |2|[Softchoice|
          |3|FDU|
          |4|Prime Healthcare|
          |5|Liberty Hospital|
          |6|Groendyke TransportInc|
          |7|Ohio Northern University|
          |8|ElCamino Hospital|
          |9|Lily|
          |10|Symphony|
          |11|ATC|
          |12|UniversityHealth|
          |13|CSE|
          |14|Caring Healthcare|
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Description 14 companies whose Rates are not moved properly.
          |*Sr. No*|*Company Name*|
          |1|CVHP|
          |2|[Softchoice|
          |3|FDU|
          |4|Prime Healthcare|
          |5|Liberty Hospital|
          |6|Groendyke TransportInc|
          |7|Ohio Northern University|
          |8|ElCamino Hospital|
          |9|Lily|
          |10|Symphony|
          |11|ATC|
          |12|UniversityHealth|
          |13|CSE|
          |14|Caring Healthcare|           		14 companies whose Rates are not moved properly.
          |*Sr. No*|*Company Name*|
          |1|CVHP|
          |2|Softchoice|
          |3|FDU|
          |4|Prime Healthcare|
          |5|Liberty Hospital|
          |6|Groendyke TransportInc|
          |7|Ohio Northern University|
          |8|ElCamino Hospital|
          |9|Lily|
          |10|Symphony|
          |11|ATC|
          |12|UniversityHealth|
          |13|CSE|
          |14|Caring Healthcare|
          Hide
          Permalink
          vinanti.yadav Vinanti Yadav (Inactive) added a comment - - edited

          Hi Nandkumar Prabhakar Karlekar,

          Concern: Effective Date Service is not moving rate properly.

          Cause: this issue is came due to
          1.duplicate rates
          if enrollment has duplicate rate then service is not added duplicate rate.
          2.enrollment having 2 or more of same rate with different effective date and termination date.
          like

          Effective Data Termination Date
          01/01/2018 NULL
          01/01/2016 2017-12-31

          then system is inserting only one rate against enrollment which is 1/1/2016 to 12/31/2017.

          Correction: We have done data analysis & correction for all mentioned companies.

          for this Issue will create separate JIRA NF-5685.

          Thanks,
          Vinanti

          CC : Jyoti Mayne, Umesh Kadam, Amruta Lohiya

          Show
          vinanti.yadav Vinanti Yadav (Inactive) added a comment - - edited Hi Nandkumar Prabhakar Karlekar , Concern: Effective Date Service is not moving rate properly. Cause: this issue is came due to 1.duplicate rates if enrollment has duplicate rate then service is not added duplicate rate. 2.enrollment having 2 or more of same rate with different effective date and termination date. like Effective Data Termination Date 01/01/2018 NULL 01/01/2016 2017-12-31 then system is inserting only one rate against enrollment which is 1/1/2016 to 12/31/2017. Correction: We have done data analysis & correction for all mentioned companies. for this Issue will create separate JIRA NF-5685. Thanks, Vinanti CC : Jyoti Mayne , Umesh Kadam , Amruta Lohiya
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopen [ 4 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Status Reopen [ 4 ] In Progress [ 3 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Remaining Estimate 40h [ 144000 ] 34h [ 122400 ]
          Time Spent 6h [ 21600 ]
          Worklog Id 100180 [ 100180 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Remaining Estimate 34h [ 122400 ] 26h [ 93600 ]
          Time Spent 6h [ 21600 ] 14h [ 50400 ]
          Worklog Id 100182 [ 100182 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Worklog Id 100182 [ 100182 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Remaining Estimate 26h [ 93600 ] 18h [ 64800 ]
          Time Spent 14h [ 50400 ] 22h [ 79200 ]
          Worklog Id 100183 [ 100183 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Remaining Estimate 18h [ 64800 ] 14h [ 50400 ]
          Time Spent 22h [ 79200 ] 26h [ 93600 ]
          Worklog Id 100184 [ 100184 ]
          jyoti.mayne Jyoti Mayne made changes -
          Remaining Estimate 14h [ 50400 ] 8.75h [ 31500 ]
          Time Spent 26h [ 93600 ] 31.25h [ 112500 ]
          Worklog Id 101444 [ 101444 ]
          jyoti.mayne Jyoti Mayne made changes -
          Remaining Estimate 8.75h [ 31500 ] 7.75h [ 27900 ]
          Time Spent 31.25h [ 112500 ] 32.25h [ 116100 ]
          Worklog Id 101565 [ 101565 ]
          jyoti.mayne Jyoti Mayne made changes -
          Remaining Estimate 7.75h [ 27900 ] 7.5h [ 27000 ]
          Time Spent 32.25h [ 116100 ] 32.5h [ 117000 ]
          Worklog Id 101583 [ 101583 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Link This issue relates to NF-5685 [ NF-5685 ]
          Transition Time In Source Status Execution Times
          Vinanti Yadav (Inactive) made transition -
          Open In Progress
          		19s 1
          Vinanti Yadav (Inactive) made transition -
          Resolved Closed
          		1h 12m 1
          Vinanti Yadav (Inactive) made transition -
          Closed Reopen
          		9s 1
          Vinanti Yadav (Inactive) made transition -
          Reopen In Progress
          		4s 1
          Vinanti Yadav (Inactive) made transition -
          In Progress Resolved
          		6h 31m 2

            People

            Assignee:
            vinanti.yadav Vinanti Yadav (Inactive)
            Reporter:
            vinanti.yadav Vinanti Yadav (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 40h
                40h
                Remaining:
                Time Spent - 32.5h Remaining Estimate - 7.5h
                7.5h
                Logged:
                Time Spent - 32.5h Remaining Estimate - 7.5h
                32.5h