WORKTERRAProject Type: software

WORKTERRA

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

New Hire enrollment import - input eff date v/s new hire rule

    Details

    • Type: Change Request
    • 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 37 - Enhancement
    • Severity:
      Simple

      Description

      Following is the scenario as of now.

      • New hire is added, say with new hire date as 3/14.
      • An health enrollment is uploaded on 3/14.
      • The new hire rule specifies that new hire becomes eligible on 1st of next month,
      • System figures that based on the new hire rule, effective date for this benefit needs to be 4/1. But on file it is 3/14. System successfully imports the file and sets the effective date of the enrollment as 4/1.

      The requirement is that the enrollment should be rejected and should show up in the bad file with the reason that the effective date doesn't follow the system rules.

      Cindy Wibbing - please edit the description if necessary.

      CC Samir Amit Thorve

        Attachments

        1. Enrollment.jpg
          184 kB
          Jayshree Nagpure
        2. Testcases.xls
          16 kB
          Jayshree Nagpure
        3. UpdatedTestcases.xls
          19 kB
          Jayshree Nagpure

          Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. WT-11154 Import/Export template management -> Server Error on Stage

          • Critical - This problem will block progress.
          • Production Complete

            Activity

            Ascending order - Click to sort in descending order
            abhay.patil Abhay Patil (Inactive) created issue -
            suraj.sokasane Suraj Sokasane (Inactive) made changes -
            Field Original Value New Value
            Assignee Vijay Siddha [ vijays ] Suraj Sokasane [ suraj.sokasane ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 36 - Enhancement [ 85 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Suraj Sokasane [ suraj.sokasane ] snehal katkar [ snehal.katkar ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Dev Due Date 08/Sep/2017
            Developer snehal katkar [ snehal.katkar ]
            QA Jayshree Nagpure [ jayshree.nagpure ]
            Remaining Estimate 20h [ 72000 ]
            Original Estimate 20h [ 72000 ]
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 07/Sep/17 01:57 PM
            • Time Spent:
              0.5h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 20h [ 72000 ] 19.5h [ 70200 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 77480 [ 77480 ]
            Permalink
            snehal.katkar Snehal Katkar (Inactive) logged work - 08/Sep/17 01:13 AM
            • Time Spent:
              4h
               

              Analysis

            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Sprint WT Sprint 36 - Enhancement [ 85 ] WT Sprint 37 - Enhancement [ 86 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Permalink
            snehal.katkar Snehal Katkar (Inactive) logged work - 12/Sep/17 01:07 AM
            • Time Spent:
              6h
               

              analysis, coding

            snehal.katkar Snehal Katkar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Assignee snehal katkar [ snehal.katkar ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 12/Sep/17 09:28 AM
            • Time Spent:
              0.5h
               
              <No comment>
            Hide
            Permalink
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            Good to LB Checkin

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Good to LB Checkin
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] snehal katkar [ snehal.katkar ]
            Code Review Date 12/Sep/2017
            Code Reviewed By Jaideep Vinchurkar [ 11908 ]
            Dev Due Date 08/Sep/2017 12/Sep/2017
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 19.5h [ 70200 ] 19h [ 68400 ]
            Time Spent 0.5h [ 1800 ] 1h [ 3600 ]
            Worklog Id 78160 [ 78160 ]
            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)
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 19h [ 68400 ] 15h [ 54000 ]
            Time Spent 1h [ 3600 ] 5h [ 18000 ]
            Worklog Id 78279 [ 78279 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 15h [ 54000 ] 9h [ 32400 ]
            Time Spent 5h [ 18000 ] 11h [ 39600 ]
            Worklog Id 78281 [ 78281 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 9h [ 32400 ] 5h [ 18000 ]
            Time Spent 11h [ 39600 ] 15h [ 54000 ]
            Worklog Id 78285 [ 78285 ]
            Permalink
            snehal.katkar Snehal Katkar (Inactive) logged work - 13/Sep/17 01:07 AM
            • Time Spent:
              4h
               

              Testing, Coding, code check in, Jira update, discussion with Jaideep

            snehal.katkar Snehal Katkar (Inactive) made changes -
            Assignee snehal katkar [ snehal.katkar ] Jayshree Nagpure [ jayshree.nagpure ]
            Hide
            Permalink
            snehal.katkar Snehal Katkar (Inactive) added a comment -

            Concern: Import is successful even if enrollment effective date do not follow new hire rules.

            Cause: There are two dates, enrollment effective date(given in file) and new hire effective date. System was considering greater date amongst these two dates. So, if date given in file is less than new hire effective date, system was considering new hire effective date as enrollment effective date and hence import was getting successful. Records were getting added into Enrollment_Intermidiate table.

            Correction: Added a check for date given in file. If it doesn't follow new hire rules then that record will get showed up in bad file. There won't be any changes in database for such enrollments.

            Show
            snehal.katkar Snehal Katkar (Inactive) added a comment - Concern: Import is successful even if enrollment effective date do not follow new hire rules. Cause: There are two dates, enrollment effective date(given in file) and new hire effective date. System was considering greater date amongst these two dates. So, if date given in file is less than new hire effective date, system was considering new hire effective date as enrollment effective date and hence import was getting successful. Records were getting added into Enrollment_Intermidiate table. Correction: Added a check for date given in file. If it doesn't follow new hire rules then that record will get showed up in bad file. There won't be any changes in database for such enrollments.
            Hide
            Permalink
            snehal.katkar Snehal Katkar (Inactive) added a comment -

            Files Having Changes:
            1)https://delta.harbinger.in/svn/WT/trunk/WORKTERRAweb/App/BusinessLogic/ImportExportDTS/ImportEmployeeEnrollment.vb

            Impacted Areas:
            1) Election Import

            Scenarios to Check:
            1) Consider any date as Enrollment effective date, less than new hire effective date for election import. Bad file should get generate saying, effective date doesn't follow new hire rules.
            2) Enter enrollment effective date as per the new hire effective rule. Import should be successful.

            Show
            snehal.katkar Snehal Katkar (Inactive) added a comment - Files Having Changes: 1) https://delta.harbinger.in/svn/WT/trunk/WORKTERRAweb/App/BusinessLogic/ImportExportDTS/ImportEmployeeEnrollment.vb Impacted Areas: 1) Election Import Scenarios to Check: 1) Consider any date as Enrollment effective date, less than new hire effective date for election import. Bad file should get generate saying, effective date doesn't follow new hire rules. 2) Enter enrollment effective date as per the new hire effective rule. Import should be successful.
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Production Due Date 21/Sep/2017
            Stage Due Date 18/Sep/17 [ 2017-09-18 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment Testcases.xls [ 61397 ]
            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
            snehal.katkar Snehal Katkar (Inactive) logged work - 13/Sep/17 11:45 PM
            • Time Spent:
              2h
               

              Testing, code check in, jira update

            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment UpdatedTestcases.xls [ 61507 ]
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited

            Hi Snehal Katkar,

            Verified on LB
            Company - Qa City of durham for hspl.

            Verified scenario's are below :
            1) Consider any date as Enrollment effective date, less than new hire effective date for election import- File kicked out to bad with message "Enrollment effective date cannot set prior to new hire effective date"
            2) Enter enrollment effective date as per the new hire effective rule- Import done successfully

            Other additional scenario's with all New hire rule's are attached in checklist : UpdatedTestcases.xls

            Working fine

            Marking item state as Ready for Stage

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited Hi Snehal Katkar , Verified on LB Company - Qa City of durham for hspl. Verified scenario's are below : 1) Consider any date as Enrollment effective date, less than new hire effective date for election import- File kicked out to bad with message "Enrollment effective date cannot set prior to new hire effective date" 2) Enter enrollment effective date as per the new hire effective rule- Import done successfully Other additional scenario's with all New hire rule's are attached in checklist : UpdatedTestcases.xls Working fine Marking item state as Ready for Stage Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 14/Sep/17 01:06 PM
            • Time Spent:
              3h
               

              Testing On LB
              Internal discussion with dev team

            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 -
            Remaining Estimate 5h [ 18000 ] 2h [ 7200 ]
            Time Spent 15h [ 54000 ] 18h [ 64800 ]
            Worklog Id 78793 [ 78793 ]
            snehal.katkar Snehal Katkar (Inactive) made changes -
            Remaining Estimate 2h [ 7200 ] 0h [ 0 ]
            Time Spent 18h [ 64800 ] 20h [ 72000 ]
            Worklog Id 78984 [ 78984 ]
            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)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Link This issue is blocked by WT-11154 [ WT-11154 ]
            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 ]
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 19/Sep/17 12:46 PM
            • Time Spent:
              2.5h
               

              Stage testing

            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on Stage
            Company - City of bellevue for hspl

            Verified all scenario attached in Test cases
            Working fine.

            Marking item state as Ready for Production

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Stage Company - City of bellevue for hspl Verified all scenario attached in Test cases Working fine. Marking item state as Ready for Production
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 20h [ 72000 ] 22.5h [ 81000 ]
            Worklog Id 79765 [ 79765 ]
            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)
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Attachment Enrollment.jpg [ 61976 ]
            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 -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            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 ]
            Hide
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on Production
            Company - ASML for hspl

            Verified all scenario attached in Test cases
            Working fine.

            Hence marking item state as Production complete

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Production Company - ASML for hspl Verified all scenario attached in Test cases Working fine. Hence marking item state as Production complete
            Permalink
            jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 21/Sep/17 11:06 AM
            • 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 -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
            Time Spent 22.5h [ 81000 ] 24h [ 86400 ]
            Worklog Id 80239 [ 80239 ]
            Transition Time In Source Status Execution Times
            Snehal Katkar (Inactive) made transition -
            New Request Pending for Approval
            		144d 9h 21m 1
            Snehal Katkar (Inactive) made transition -
            Pending for Approval Approved for Development
            		2s 1
            Snehal Katkar (Inactive) made transition -
            Approved for Development In Development
            		1s 1
            Jayshree Nagpure (Inactive) made transition -
            In Development In LB Testing
            		1d 21h 57m 1
            Jayshree Nagpure (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		5d 21h 49m 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
            		2d 2h 49m 1
            Jayshree Nagpure (Inactive) made transition -
            Pending for Production Approval Approved for production
            		2s 1
            Jayshree Nagpure (Inactive) made transition -
            Approved for production In Production Testing
            		2s 1
            Jayshree Nagpure (Inactive) made transition -
            In Production Testing Production Complete
            		3h 35m 1

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              abhay.patil Abhay Patil (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 - 20h Original Estimate - 20h
                  20h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 24h
                  24h