WORKTERRAProject Type: software

WORKTERRA

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

Export > Already reported employee termination in OE again exported on OE file

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      Stage
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Export
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      LB QA - On Hold
    • Issue Importance:
      Must Have
    • Browser:
      Google Chrome
    • Sprint:
      WT Sprint 38 - Bugs, WT Sprint 40 - Bugs

      Description

      Hi Vinayak Kulkarni,

      Found an issue as below

      Issue : Already reported employee termination in OE (Current :Yes , Future:Yes) on export file again exported on OE file(Current :No , Future:Yes)

      Scenario : Employee Terminated in OE with 12/31/2017 (EOY) Date and is exported on file which ran in ongoing OE. When flags are switched to Current Year and exported as OE file . The same termination is reported on OE file as well

      Expected Result : Already reported termination should not export on file again.

      Can you please look into this and update accordingly ?

      CC:Rajendra Pawar Hrishikesh Deshpande

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          punam.satpute Punam Satpute (Inactive) added a comment - - edited

          Concern : WT-11189 Export > Already reported employee termination in OE again exported on OE file
          Cause : Scenario is not checked for terminated employee on OE file.
          Correction : Scenario is checked(Condition added)
          Affected Areas : Any Company--->Manual Import/Export

          Show
          punam.satpute Punam Satpute (Inactive) added a comment - - edited Concern : WT-11189 Export > Already reported employee termination in OE again exported on OE file Cause : Scenario is not checked for terminated employee on OE file. Correction : Scenario is checked(Condition added) Affected Areas : Any Company--->Manual Import/Export
          Hide
          Permalink
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Hi Punam Satpute,

          Created below Scenarios to test this fix on LB on For QA ASML for HSPL

          1) SA utility Plan Term in ongoing OE,
          2) Employee Termination ongoing OE ,
          3) OE enrollment for next year.

          Exported file in OE (Current yes and Future YES) and observed that Employee Termination is not exported on file .
          The Employee's plans were previously terminated with OE set up component (-13) . Now in OE when employee is terminated . It is expected to pull all the terminations of employee on file but getting no records found on template

          Template name: Test OE

          Can you please check this and update accordingly ?

          CC:Hrishikesh Deshpande Vinayak Kulkarni Rajendra Pawar

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Hi Punam Satpute , Created below Scenarios to test this fix on LB on For QA ASML for HSPL 1) SA utility Plan Term in ongoing OE, 2) Employee Termination ongoing OE , 3) OE enrollment for next year. Exported file in OE (Current yes and Future YES) and observed that Employee Termination is not exported on file . The Employee's plans were previously terminated with OE set up component (-13) . Now in OE when employee is terminated . It is expected to pull all the terminations of employee on file but getting no records found on template Template name: Test OE Can you please check this and update accordingly ? CC: Hrishikesh Deshpande Vinayak Kulkarni Rajendra Pawar
          Hide
          Permalink
          punam.satpute Punam Satpute (Inactive) added a comment - - edited

          Concern : WT-11189 Export > Already reported employee termination in OE again exported on OE file is reopened on LB.

          Cause : Scenario is missed for Employee whose plans were terminated with OE setup component(Before OE period), and whose employment is terminated during OE period.

          Correction : We have added check for considering those employee.

          Affected files : 1.OES_SP_Export_ForceAlreadyTerminatedEnrollmentsForEmployementTerm.StoredProcedure.Sql
          2.CommonExportRoutines.vb
          3.ExportProcess.vb
          4.ExportProcessRowwise.vb
          5.ExportProcessXML.vb

          Impacted Areas : Any Company --> Manual Import/Export

          Show
          punam.satpute Punam Satpute (Inactive) added a comment - - edited Concern : WT-11189 Export > Already reported employee termination in OE again exported on OE file is reopened on LB. Cause : Scenario is missed for Employee whose plans were terminated with OE setup component(Before OE period), and whose employment is terminated during OE period. Correction : We have added check for considering those employee. Affected files : 1.OES_SP_Export_ForceAlreadyTerminatedEnrollmentsForEmployementTerm.StoredProcedure.Sql 2.CommonExportRoutines.vb 3.ExportProcess.vb 4.ExportProcessRowwise.vb 5.ExportProcessXML.vb Impacted Areas : Any Company --> Manual Import/Export
          Hide
          Permalink
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Created scenarios and terminated enrollments through OE set component . Started OE on for QA for ASML for HSPL Company on stage. Will check the scenarios on file tomorrow and update accordingly

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Created scenarios and terminated enrollments through OE set component . Started OE on for QA for ASML for HSPL Company on stage. Will check the scenarios on file tomorrow and update accordingly
          Hide
          Permalink
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Continuing with yesterday's testing Verified the file in Ongoing OE with below scenarios

          1) Terminating Employees with 12/31/2017 in OE
          2) Terminating Plans in Ongoing OE from Employee Benadmin with 12/31/2017
          3) Terminating Plans in Ongoing OE through SA Utility 12/31/2017
          4) Next Year Enrollment Basic Life

          Exported the file in Ongoing OE with current Yes and Future YES flag settings and observed only Terminated Employee's Medical and Basic Life enrollments exported on file . Which is as expected.

          Will continue testing with OE file testing tomorrow.

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Continuing with yesterday's testing Verified the file in Ongoing OE with below scenarios 1) Terminating Employees with 12/31/2017 in OE 2) Terminating Plans in Ongoing OE from Employee Benadmin with 12/31/2017 3) Terminating Plans in Ongoing OE through SA Utility 12/31/2017 4) Next Year Enrollment Basic Life Exported the file in Ongoing OE with current Yes and Future YES flag settings and observed only Terminated Employee's Medical and Basic Life enrollments exported on file . Which is as expected. Will continue testing with OE file testing tomorrow.
          Hide
          Permalink
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Observed that . No Records getting exported on OE Files. So Reopened WT-9992 and keeping this on hold till it gets fixed

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Observed that . No Records getting exported on OE Files. So Reopened WT-9992 and keeping this on hold till it gets fixed
          Hide
          Permalink
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - - edited

          Verified these scenarios again on LB and confirmed that records on the file during OE and after OE (OE file) are proper and as expected for below tested scenarios

          1) During OE Election Termination - EOY and Before EOY
          2) Employee Termination during OE
          3) SA utility terminations during OE
          4) Enrollment changes in OE
          5) New year enrollments in OE
          6) OE Set Up component terminations

          Ready for Stage Deployement

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - - edited Verified these scenarios again on LB and confirmed that records on the file during OE and after OE (OE file) are proper and as expected for below tested scenarios 1) During OE Election Termination - EOY and Before EOY 2) Employee Termination during OE 3) SA utility terminations during OE 4) Enrollment changes in OE 5) New year enrollments in OE 6) OE Set Up component terminations Ready for Stage Deployement
          Hide
          Permalink
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

          Issue fixed with Pre-prod Build.

          Show
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Issue fixed with Pre-prod Build.

            People

            Assignee:
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive)
            Reporter:
            aniruddha.dev Aniruddha Dev (Inactive)
            Developer:
            Punam Satpute (Inactive)
            QA:
            Aniruddha Dev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

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

                Time Tracking

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