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
        2. Overlapping Age Bands - Reopened.png
          Overlapping Age Bands - Reopened.png
          190 kB
        3. Rate.xlsm
          78 kB
        4. Report Screenshot.zip
          1.01 MB
        5. screenshot-1.png
          screenshot-1.png
          180 kB
        6. WT-8981_Affected_Files.txt
          0.2 kB
        7. WT8981_Overlapped.jpg
          WT8981_Overlapped.jpg
          150 kB
        8. WT8981_Proper.jpg
          WT8981_Proper.jpg
          152 kB

          Issue Links

            Activity

            rohit.shete Rohit Shete (Inactive) logged work - 25/Apr/17 01:36 PM
            • Time Spent:
              6h
               

              Code Analysis And Debug Working Import Excel

            jyoti.mayne Jyoti Mayne logged work - 25/Apr/17 04:37 PM
            • Time Spent:
              0.25h
               

              discussion

            rohit.shete Rohit Shete (Inactive) logged work - 26/Apr/17 01:26 PM - edited
            • Time Spent:
              6.5h
               

              Issue Analysis and Code Debug

            jyoti.mayne Jyoti Mayne logged work - 26/Apr/17 05:56 PM
            • Time Spent:
              0.25h
               

              discussion

            rohit.shete Rohit Shete (Inactive) logged work - 27/Apr/17 01:20 PM - edited
            • Time Spent:
              5.5h
               

              Code Debug And Analysis And Development

            jyoti.mayne Jyoti Mayne logged work - 27/Apr/17 04:17 PM
            • Time Spent:
              0.25h
               

              discussion

            jyoti.mayne Jyoti Mayne logged work - 28/Apr/17 02:40 PM - edited
            • Time Spent:
              1h
               

              discussion and functionality review

            jyoti.mayne Jyoti Mayne logged work - 02/May/17 08:53 AM
            • Time Spent:
              0.25h
               

              discussion

            rohit.shete Rohit Shete (Inactive) logged work - 02/May/17 01:10 PM
            • Time Spent:
              6.5h
               

              Code Analysis And Unit Test and Development And Code Review By Umesh And Jyoti

            umesh.kadam Umesh Kadam (Inactive) logged work - 02/May/17 04:30 PM
            • Time Spent:
              1h
               

              Code review
              Performance related discussion with Rohit and Jyoti

            rohit.shete Rohit Shete (Inactive) logged work - 03/May/17 11:40 AM - edited
            • Time Spent:
              5h
               

              Code Analysis And Code Review by umesh and lb and ui merge

            alankar.chavan Alankar Chavan (Inactive) logged work - 05/May/17 01:19 PM
            • Time Spent:
              1.5h
               

              LB testing

            alankar.chavan Alankar Chavan (Inactive) logged work - 08/May/17 01:24 PM
            • Time Spent:
              2h
               

              LB Testing

            rohit.shete Rohit Shete (Inactive) logged work - 10/May/17 12:25 PM
            • Time Spent:
              0.5h
               

              Stage Check in and unit Test

            alankar.chavan Alankar Chavan (Inactive) logged work - 15/May/17 01:18 PM
            • Time Spent:
              1.5h
               

              stage testing

            rohit.shete Rohit Shete (Inactive) logged work - 16/May/17 12:35 PM - edited
            • Time Spent:
              0.5h
               

              Production Merge

            priya.dhamande Priya Dhamande (Inactive) logged work - 18/May/17 01:05 PM
            • Time Spent:
              1.5h
               

              Production Testing

              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