WORKTERRAProject Type: software

WORKTERRA

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

Wt -> Rates -> Overlapping age bands are getting added in to the system with rate import functionality - Update

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Bug Severity:
      Low
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Support
    • Item State:
      Production Complete

      Description

      • import a life rate which contains overlapping age bands
      • with import - system is allowing to have overlapping age bands in to the rates - which is not allowed when rates are added through UI

      I am attaching the screenshot and the rate template I used for importing a Rate in to Austin for HSPL - Production

      When such rates are mapped to core plans - and eligible employees are added in to the system, sever error appears. refer WT-8927

      CC - Jyoti Mayne Prasad Pise Sachin Hingole Hrishikesh Deshpande Rakesh Roy Satya Jaideep Vinchurkar

        Attachments

        1. Checklist_WT-8981.doc
          27 kB
          Rohit Shete
        2. Overlapping Age Bands - Reopened.png
          190 kB
          Alankar Chavan
        3. Rate.xlsm
          78 kB
          Alankar Chavan
        5. screenshot-1.png
          180 kB
          Rohit Shete
        6. WT-8981_Affected_Files.txt
          0.2 kB
          Rohit Shete
        7. WT8981_Overlapped.jpg
          150 kB
          Priya Dhamande
        8. WT8981_Proper.jpg
          152 kB
          Priya Dhamande

          Issue Links

          relates to

          Support Activity - Support Activity WT-8927 City of West Covina- Adding EE, ES and Dep in system

          • Critical - This problem will block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            alankar.chavan Alankar Chavan (Inactive) created issue -
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Field Original Value New Value
            Assignee Vijay Siddha [ vijays ] Suraj Sokasane [ suraj.sokasane ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Link This issue relates to WT-8927 [ WT-8927 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Jyoti Mayne [ jyoti.mayne ]
            jyoti.mayne Jyoti Mayne made changes -
            Issue Category Harbinger [ 10700 ] EBS [ 10350 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Module Parent values: BenAdmin(10100)Level 1 values: Import(10111) Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107)
            jyoti.mayne Jyoti Mayne made changes -
            Assignee Jyoti Mayne [ jyoti.mayne ] Rohit Shete [ rohit.shete ]
            jyoti.mayne Jyoti Mayne made changes -
            Developer Rohit Shete [ rohit.shete ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Dev Due Date 25/Apr/2017
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            rohit.shete Rohit Shete (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            jyoti.mayne Jyoti Mayne made changes -
            Dev Due Date 25/Apr/2017 27/Apr/2017
            jyoti.mayne Jyoti Mayne made changes -
            Remaining Estimate 5h [ 18000 ] 4.75h [ 17100 ]
            Time Spent 0.25h [ 900 ]
            Worklog Id 40782 [ 40782 ]
            jyoti.mayne Jyoti Mayne made changes -
            Remaining Estimate 4.75h [ 17100 ] 4.5h [ 16200 ]
            Time Spent 0.25h [ 900 ] 0.5h [ 1800 ]
            Worklog Id 41151 [ 41151 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: In Progress(10206)
            rohit.shete Rohit Shete (Inactive) made changes -
            Dev Due Date 27/Apr/2017 28/Apr/2017
            rohit.shete Rohit Shete (Inactive) made changes -
            Original Estimate 5h [ 18000 ] 16h [ 57600 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Remaining Estimate 4.5h [ 16200 ] 0h [ 0 ]
            Time Spent 0.5h [ 1800 ] 5h [ 18000 ]
            Worklog Id 41444 [ 41444 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 5h [ 18000 ] 6h [ 21600 ]
            Worklog Id 41444 [ 41444 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 6h [ 21600 ] 11.5h [ 41400 ]
            Worklog Id 41455 [ 41455 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 11.5h [ 41400 ] 12.5h [ 45000 ]
            Worklog Id 41455 [ 41455 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 12.5h [ 45000 ] 18.5h [ 66600 ]
            Worklog Id 41469 [ 41469 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Original Estimate 16h [ 57600 ] 25h [ 90000 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 18.5h [ 66600 ] 18.75h [ 67500 ]
            Worklog Id 41537 [ 41537 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            Original Estimate 25h [ 90000 ] 35h [ 126000 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 18.75h [ 67500 ] 19.5h [ 70200 ]
            Worklog Id 42491 [ 42491 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 19.5h [ 70200 ] 19.75h [ 71100 ]
            Worklog Id 42491 [ 42491 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Dev Due Date 28/Apr/2017 02/Apr/2018
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 19.75h [ 71100 ] 26.25h [ 94500 ]
            Worklog Id 42722 [ 42722 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Dev Due Date 02/Apr/2018 03/Apr/2018
            umesh.kadam Umesh Kadam (Inactive) made changes -
            Time Spent 26.25h [ 94500 ] 27.25h [ 98100 ]
            Worklog Id 42758 [ 42758 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Attachment Checklist_WT-8981.doc [ 46911 ]
            Attachment WT-8981_Affected_Files.txt [ 46912 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Original Estimate 35h [ 126000 ] 45h [ 162000 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Code Review Date 03/May/2017
            Code Reviewed By Jyoti Mayne,Umesh Kadam [ 11910, 15302 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Attachment screenshot-1.png [ 46926 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 27.25h [ 98100 ] 31.25h [ 112500 ]
            Worklog Id 42863 [ 42863 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Assignee Rohit Shete [ rohit.shete ] Prasad Pise [ prasadp ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            prasadp Prasad Pise (Inactive) made changes -
            Assignee Prasad Pise [ prasadp ] Alankar Chavan [ alankar.chavan ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Attachment Report Screenshot.zip [ 47047 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Attachment Overlapping Age Bands - Reopened.png [ 47048 ]
            Attachment Rate.xlsm [ 47049 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Assignee Alankar Chavan [ alankar.chavan ] Rohit Shete [ rohit.shete ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            rohit.shete Rohit Shete (Inactive) made changes -
            Assignee Rohit Shete [ rohit.shete ] Alankar Chavan [ alankar.chavan ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Time Spent 31.25h [ 112500 ] 32.75h [ 117900 ]
            Worklog Id 43525 [ 43525 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Summary Wt -> Rates -> Overlapping age bands are getting added in to the system with rate import functionality Wt -> Rates -> Overlapping age bands are getting added in to the system with rate import functionality - Update
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Time Spent 32.75h [ 117900 ] 34.75h [ 125100 ]
            Worklog Id 43771 [ 43771 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 34.75h [ 125100 ] 35.25h [ 126900 ]
            Worklog Id 44415 [ 44415 ]
            jyoti.mayne Jyoti Mayne made changes -
            Time Spent 35.25h [ 126900 ] 35.5h [ 127800 ]
            Worklog Id 45389 [ 45389 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Time Spent 35.5h [ 127800 ] 37h [ 133200 ]
            Worklog Id 46117 [ 46117 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 37h [ 133200 ] 37.5h [ 135000 ]
            Worklog Id 46421 [ 46421 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Worklog Id 46421 [ 46421 ]
            rohit.shete Rohit Shete (Inactive) made changes -
            Time Spent 37.5h [ 135000 ] 38.5h [ 138600 ]
            Worklog Id 42863 [ 42863 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Alankar Chavan [ alankar.chavan ] Priya Dhamande [ priya.dhamande ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Attachment WT8981_Overlapped.jpg [ 48528 ]
            Attachment WT8981_Proper.jpg [ 48529 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Time Spent 38.5h [ 138600 ] 40h [ 144000 ]
            Worklog Id 46766 [ 46766 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Bug Severity Low [ 16703 ]
            Code Review Date 03/May/2017 03/May/2017
            Dev Due Date 03/Apr/2018 03/Apr/2018
            satyap Satya made changes -
            Environment_New Production [ 18442 ]

              People

              Assignee:
              priya.dhamande Priya Dhamande (Inactive)
              Reporter:
              alankar.chavan Alankar Chavan (Inactive)
              Developer:
              Rohit Shete (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 45h
                  45h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 40h Time Not Required
                  40h