WORKTERRAProject Type: software

WORKTERRA

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

Back end routines after Waived Import

    Details

    • Type: Enhancement
    • Status: Production Complete
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Import
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 34 - Enhancements
    • Severity:
      Simple

      Description

      After waived data Import, which inserts record in Waived Enrollment, we need to run a routine which will:

      • Terminate the enrollment if needed
      • make the rates dead
      • changes in credit pool if needed.

        Attachments

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-10678 Waive import -> Termination date not properly updating

          • Medium - Has the potential to affect progress.
          • Production Complete

            Activity

            Ascending order - Click to sort in descending order
            suraj.sokasane Suraj Sokasane (Inactive) created issue -
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Field Original Value New Value
            Sprint WT Sprint 32 - Enhancement [ 75 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Rank Ranked lower
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 32 - Enhancement [ 75 ] WT Sprint 33 - Enhancement [ 78 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Dev Due Date 24/Jul/2017
            Permalink
            snehal.katkar Snehal Katkar (Inactive) logged work - 25/Jul/17 01:32 AM
            • Time Spent:
              8h
               

              Discussion with Jaideep, analysis

            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] snehal katkar [ snehal.katkar ]
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 25/Jul/17 04:09 PM
            • Time Spent:
              0.5h
               

              Discussion and KT to snehal

            Permalink
            snehal.katkar Snehal Katkar (Inactive) logged work - 26/Jul/17 01:31 AM
            • Time Spent:
              8h
               

              Analysis, coding, discussion with Jaideep

            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 66314 [ 66314 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            Permalink
            suraj.sokasane Suraj Sokasane (Inactive) logged work - 26/Jul/17 03:07 PM
            • Time Spent:
              1.5h
               

              Discussion with snehal
              KT about Import third table
              code debug
              Discssion with Satya, Gaurav

            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Time Spent 0.5h [ 1800 ] 2h [ 7200 ]
            Worklog Id 66657 [ 66657 ]
            Permalink
            snehal.katkar Snehal Katkar (Inactive) logged work - 27/Jul/17 01:30 AM - edited
            • Time Spent:
              4.5h
               

              Discussion with Suraj and Satya, coding

            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 2h [ 7200 ] 3.5h [ 12600 ]
            Worklog Id 67382 [ 67382 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 3.5h [ 12600 ] 6.5h [ 23400 ]
            Worklog Id 67382 [ 67382 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 6.5h [ 23400 ] 14.5h [ 52200 ]
            Worklog Id 67385 [ 67385 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 14.5h [ 52200 ] 22.5h [ 81000 ]
            Worklog Id 67387 [ 67387 ]
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Dev Due Date 24/Jul/2017 11/Aug/2017
            Original Estimate 0h [ 0 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 33 - Enhancement [ 78 ] WT Sprint 34 - Enhancements [ 80 ]
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 10/Aug/17 03:16 PM
            • Time Spent:
              1h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 22.5h [ 81000 ] 23.5h [ 84600 ]
            Worklog Id 70953 [ 70953 ]
            Permalink
            snehal.katkar Snehal Katkar (Inactive) logged work - 10/Aug/17 08:51 PM
            • Time Spent:
              9.5h
               

              Analysis, discussion with jaideep, coding

            snehal.katkar Snehal Katkar (Inactive) made changes -
            Code Review Date 11/Aug/2017
            Code Reviewed By Jaideep Vinchurkar [ 11908 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Component/s BenAdmin [ 10000 ]
            Developer Suraj Sokasane [ suraj.sokasane ] snehal katkar [ snehal.katkar ]
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            QA Jayshree Nagpure [ jayshree.nagpure ]
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 11/Aug/17 02:44 PM
            • Time Spent:
              1h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Time Spent 23.5h [ 84600 ] 24.5h [ 88200 ]
            Worklog Id 71328 [ 71328 ]
            Permalink
            snehal.katkar Snehal Katkar (Inactive) logged work - 11/Aug/17 08:51 PM - edited
            • Time Spent:
              4.5h
               

              Testing, jira update, code checkin

            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee snehal katkar [ snehal.katkar ] Jayshree Nagpure [ jayshree.nagpure ]
            Hide
            Permalink
            snehal.katkar Snehal Katkar (Inactive) added a comment -

            Enhancement:
            1) Once we waive any enrollment, we insert record into Waived Enrollment. And now, we terminate ongoing enrollment by setting enrollment termination date into Employee_Enrollment table.
            2) Termination date will be, one day prior to waive date for that particular enrollment.
            3) Once we terminate any enrollment, back end routine takes care to make the rates dead, to make changes in credit pool if needed and to terminate all contingent enrollments.

            Files having changes:
            1) 1)https://delta.harbinger.in/svn/WT/trunk/WORKTERRAweb/App/BusinessLogic/ImportExportDTS/ImportValidation.vb

            Scenarios to Test:
            1) After waived import ongoing enrollments should terminate.
            2) Termination date of ongoing enrollments should be one day prior to waive date.
            3) Rates should be dead and credit pool changes if any
            4) Termination of contingent enrollments if there are any. Please refer to WT-9330
            5) On UI - Waived enrollment should not show 'Enrolled' label. Please refer to WT-9327

            Please consider testing scenarios for above mentioned issues. Those were related to this enhancement.

            Show
            snehal.katkar Snehal Katkar (Inactive) added a comment - Enhancement: 1) Once we waive any enrollment, we insert record into Waived Enrollment. And now, we terminate ongoing enrollment by setting enrollment termination date into Employee_Enrollment table. 2) Termination date will be, one day prior to waive date for that particular enrollment. 3) Once we terminate any enrollment, back end routine takes care to make the rates dead, to make changes in credit pool if needed and to terminate all contingent enrollments. Files having changes: 1) 1) https://delta.harbinger.in/svn/WT/trunk/WORKTERRAweb/App/BusinessLogic/ImportExportDTS/ImportValidation.vb Scenarios to Test: 1) After waived import ongoing enrollments should terminate. 2) Termination date of ongoing enrollments should be one day prior to waive date. 3) Rates should be dead and credit pool changes if any 4) Termination of contingent enrollments if there are any. Please refer to WT-9330 5) On UI - Waived enrollment should not show 'Enrolled' label. Please refer to WT-9327 Please consider testing scenarios for above mentioned issues. Those were related to this enhancement.
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment BackenendRoutineWaiveImport.xls [ 58729 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 16/Aug/17 02:03 PM - edited
            • Time Spent:
              6h
               

              Discussion and testing on LB

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 24.5h [ 88200 ] 29.5h [ 106200 ]
            Worklog Id 71819 [ 71819 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 29.5h [ 106200 ] 30.5h [ 109800 ]
            Worklog Id 71819 [ 71819 ]
            Permalink
            snehal.katkar Snehal Katkar (Inactive) logged work - 16/Aug/17 09:06 PM - edited
            • Time Spent:
              4h
               

              jira update, testing, discussion with jayshree and jaideep

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Link This issue relates to WT-10678 [ WT-10678 ]
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Snehal Katkar,

            Verified on LB
            Company - FDU, Wheaton

            Verified below scenario :

            • Termination dates for waived import - Fail
            • Credit pool allocation - Pass

            Once linked jira is resolved assign this ticket back to me

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Snehal Katkar , Verified on LB Company - FDU, Wheaton Verified below scenario : Termination dates for waived import - Fail Credit pool allocation - Pass Once linked jira is resolved assign this ticket back to me Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Assignee Jayshree Nagpure [ jayshree.nagpure ] snehal katkar [ snehal.katkar ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 30.5h [ 109800 ] 40h [ 144000 ]
            Worklog Id 72003 [ 72003 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 40h [ 144000 ] 44h [ 158400 ]
            Worklog Id 72004 [ 72004 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Worklog Id 72004 [ 72004 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 44h [ 158400 ] 44.5h [ 160200 ]
            Worklog Id 72004 [ 72004 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 44.5h [ 160200 ] 48h [ 172800 ]
            Worklog Id 72017 [ 72017 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Worklog Id 72017 [ 72017 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Time Spent 48h [ 172800 ] 48.5h [ 174600 ]
            Worklog Id 72017 [ 72017 ]
            Hide
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            Linked JIRA has been resloved

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Linked JIRA has been resloved
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee snehal katkar [ snehal.katkar ] Jayshree Nagpure [ jayshree.nagpure ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Code Review Date 11/Aug/2017 11/Aug/2017
            Dev Due Date 11/Aug/2017 11/Aug/2017
            Production Due Date 14/Sep/2017
            Stage Due Date 11/Sep/17 [ 2017-09-11 ]
            snehal.katkar Snehal Katkar (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)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited

            Verified on Stage
            Company - city of bellevue for hspl

            Verified below scenario :

            Termination dates for waived import - Pass
            Credit pool allocation - Pass

            Linked jira is also working fine.
            Marking item state as Ready for Production.

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited Verified on Stage Company - city of bellevue for hspl Verified below scenario : Termination dates for waived import - Pass Credit pool allocation - Pass Linked jira is also working fine. Marking item state as Ready for Production. Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 13/Sep/17 12:46 PM
            • Time Spent:
              2h
               

              Stage testing

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 48.5h [ 174600 ] 50.5h [ 181800 ]
            Worklog Id 78526 [ 78526 ]
            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)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            jayshree.nagpure Jayshree Nagpure (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)
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited

            Verified on Production
            Company - Je dunn for hspl

            Verified below scenario :
            Termination dates for waived import - Pass
            Credit pool allocation - Pass

            Linked jira is also working fine.
            Marking item state as Production complete

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited Verified on Production Company - Je dunn for hspl Verified below scenario : Termination dates for waived import - Pass Credit pool allocation - Pass Linked jira is also working fine. Marking item state as Production complete
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 14/Sep/17 12:41 PM
            • Time Spent:
              1.5h
               

              Production testing

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 50.5h [ 181800 ] 52h [ 187200 ]
            Worklog Id 78777 [ 78777 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 14/Sep/17 12:43 PM
            • Time Spent:
              1h
               

              Production testing
              Internal discussion for issue on production

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 52h [ 187200 ] 53h [ 190800 ]
            Worklog Id 78779 [ 78779 ]
            Transition Time In Source Status Execution Times
            Suraj Sokasane (Inactive) made transition -
            New Request Pending for Approval
            		95d 20h 51m 1
            Suraj Sokasane (Inactive) made transition -
            Pending for Approval Approved for Development
            		3s 1
            Suraj Sokasane (Inactive) made transition -
            Approved for Development In Development
            		2s 1
            Jayshree Nagpure (Inactive) made transition -
            In Development In LB Testing
            		21d 9h 33m 1
            Jayshree Nagpure (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		27d 21h 44m 1
            Jayshree Nagpure (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            		3s 1
            Jayshree Nagpure (Inactive) made transition -
            Approved for Stage Stage Testing
            		3s 1
            Jayshree Nagpure (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		21h 24m 1
            Jayshree Nagpure (Inactive) made transition -
            Pending for Production Approval Approved for production
            		8s 1
            Jayshree Nagpure (Inactive) made transition -
            Approved for production In Production Testing
            		5s 1
            Jayshree Nagpure (Inactive) made transition -
            In Production Testing Production Complete
            		3h 31m 1

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              suraj.sokasane Suraj Sokasane (Inactive)
              Developer:
              Snehal Katkar (Inactive)
              QA:
              Jayshree Nagpure (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 53h
                  53h