WORKTERRAProject Type: software

WORKTERRA

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

ACA: Metso- Incremental transactions on Full file when period is more than one month.

    Details

    • Type: Change Request
    • Status: Resolution Setting
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
    • Environment:
      Production
    • Module:
      ACA - 2017
    • Reported by:
      Client
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have
    • Severity:
      Simple

      Description

      1. Every Year of first month event should be of Open Enrollment.

      2. Should have offer specific coverage element on the file. (OFFR=COVG)
      Ex.
      If OFFR IS open enrollment then should coverage event must be of Open Enrollment.

      3. Employee has Continuous enrollment from last year his enrollment effective must be
      reflected as current year start date.
      Ex.
      Employee Name - Abc
      Actual Enrollment Effective Date- 01/01/2016 or 05/01/2016
      Termination Date- Null
      Expected on the file -Effective Date as - 01/01/2017 & Termination Date as Null.

      4.Should be identifiable eligibility records associated with offer as unique

      5.WEF Process Flag whether to run or not.

      Current Implementation : If Employee has Continuous enrollment from last year, his effective date was populating his actual enrollment effective date in the system.
      New Implementation : If Employee has Continuous enrollment from last year, his enrollment effective date must be reflected as current year start date.

        Attachments

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. NF-3271 UI Refresh > Manual Import/Export > Functional > Getting server error while export

          • High - Serious problem that could block progress.
          • Closed

          Change Request - Change Request WT-9320 ACA: Mid month termination record should be pulled out on the file.

          • Medium - Has the potential to affect progress.
          • Closed

          Change Request - Change Request WT-10032 ACA: Performance Issue-Getting too much time to export the prime files.

          • High - Serious problem that could block progress.
          • Production Complete

          Bug - A problem which impairs or prevents the functions of the product. WT-10081 Metso Benefits | Server Errror on Exporting Metso ADP-ACA Employee template

          • Medium - Has the potential to affect progress.
          • Resolution Setting

          Bug - A problem which impairs or prevents the functions of the product. WT-10131 Metso Benefits | COVG and OFFR row count doesn't match

          • Medium - Has the potential to affect progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-10132 MetsoBenefits | Employee getting coverages without eligibility

          • Medium - Has the potential to affect progress.
          • Rejected

            Activity

            Ascending order - Click to sort in descending order
            revansiddha.gaur Revansiddha Gaur (Inactive) created issue -
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Field Original Value New Value
            Assignee Nandkumar [ satyap ] Revansiddha Gaur [ revansiddha.gaur ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Description 1. Every Year of first month event should be of Open Enrollment.

            2. Should have offer specific coverage element on the file. (OFFR=COVG)
            Ex.
            If OFFR IS open enrollment then should coverage event must be of Open Enrollment.

            3. Employee has Continuous enrollment from last year his enrollment effective must be
            reflected as current year start date.
            Ex.
            Employee Name - Abc
            Actual Enrollment Effective Date- 01/01/2016 or 05/01/2016
            Termination Date- Null
            Expected on the file -Effective Date as - 01/01/2017 & Termination Date as Null.

            4.Should be identifiable eligibility records associated with offer as unique
            		1. Every Year of first month event should be of Open Enrollment.

            2. Should have offer specific coverage element on the file. (OFFR=COVG)
            Ex.
            If OFFR IS open enrollment then should coverage event must be of Open Enrollment.

            3. Employee has Continuous enrollment from last year his enrollment effective must be
            reflected as current year start date.
            Ex.
            Employee Name - Abc
            Actual Enrollment Effective Date- 01/01/2016 or 05/01/2016
            Termination Date- Null
            Expected on the file -Effective Date as - 01/01/2017 & Termination Date as Null.

            4.Should be identifiable eligibility records associated with offer as unique

            5.WEF Process Flag whether to run or not.
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 24h [ 86400 ] 18h [ 64800 ]
            Time Spent 6h [ 21600 ]
            Worklog Id 53752 [ 53752 ]
            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 09/Jun/17 09:00 PM
            • Time Spent:
              6h
               

              Testing,Code merge,Review Requested.

            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 12/Jun/17 09:00 PM
            • Time Spent:
              0.5h
               

              local trunk checkins.

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 18h [ 64800 ] 17.5h [ 63000 ]
            Time Spent 6h [ 21600 ] 6.5h [ 23400 ]
            Worklog Id 54374 [ 54374 ]
            Hide
            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited

            Affected Files :
            D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_WEFGetProcessTypeID_Rule.sql
            D:\WTBranches\LB\Database Objects\MasterCompanyDB\03_Views\dbo.OES_VIEW_ACA_1_Export_WaivedEnrollment.sql
            D:\WTBranches\LB\Database Objects\MasterCompanyDB\03_Views\dbo.OES_VIEW_ACA_Export_Eligibility.View.sql
            D:\WTBranches\LB\App\BusinessLogic\ImportExportDTS\ACAExportProcessRowwise.vb
            D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_Update_WEFEmployeeEligibility_IneligibleEEUpdate.sql
            D:\WTBranches\LB\Database Objects\MasterCompanyDB\01_DDL\573_WT-9760_WTB_ACA_NewTable_ACA_WEFEmployeeEligibilityLockRun.sql
            D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_ExportProcessedEventData.StoredProcedure.sql
            D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_EligibilityForExport.sql
            D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_Export_GetBillingDetailsWithDatewise.StoredProcedure.sql

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited Affected Files : D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_WEFGetProcessTypeID_Rule.sql D:\WTBranches\LB\Database Objects\MasterCompanyDB\03_Views\dbo.OES_VIEW_ACA_1_Export_WaivedEnrollment.sql D:\WTBranches\LB\Database Objects\MasterCompanyDB\03_Views\dbo.OES_VIEW_ACA_Export_Eligibility.View.sql D:\WTBranches\LB\App\BusinessLogic\ImportExportDTS\ACAExportProcessRowwise.vb D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_Update_WEFEmployeeEligibility_IneligibleEEUpdate.sql D:\WTBranches\LB\Database Objects\MasterCompanyDB\01_DDL\573_ WT-9760 _WTB_ACA_NewTable_ACA_WEFEmployeeEligibilityLockRun.sql D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_ExportProcessedEventData.StoredProcedure.sql D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_EligibilityForExport.sql D:\WTBranches\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_Export_GetBillingDetailsWithDatewise.StoredProcedure.sql
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Code Review Date 12/Jun/2017
            Code Reviewed By Nandkumar Karlekar [ 11904 ]
            Dev Due Date 14/Jun/2017
            Developer Revansiddha Gaur [ revansiddha.gaur ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Smita Pawar [ smita.pawar ]
            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 14/Jun/17 09:00 PM
            • Time Spent:
              2h
               

              File checkins to lb & uirefresh.

            smita.pawar Smita Pawar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            smita.pawar Smita Pawar (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)
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 17.5h [ 63000 ] 15.5h [ 55800 ]
            Time Spent 6.5h [ 23400 ] 8.5h [ 30600 ]
            Worklog Id 55628 [ 55628 ]
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 16/Jun/17 05:14 AM
            • Time Spent:
              6h
               

              Template creation
              Testing
              Internal discussion

            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 20/Jun/17 09:54 AM
            • Time Spent:
              3h
               

              analysis

            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 22/Jun/17 09:46 AM
            • Time Spent:
              3h
               

              Customization
              Testing

            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 15.5h [ 55800 ] 9.5h [ 34200 ]
            Time Spent 8.5h [ 30600 ] 14.5h [ 52200 ]
            Worklog Id 58438 [ 58438 ]
            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 30/Jun/17 12:52 AM
            • Time Spent:
              3h
               
              <No comment>
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 9.5h [ 34200 ] 6.5h [ 23400 ]
            Time Spent 14.5h [ 52200 ] 17.5h [ 63000 ]
            Worklog Id 59825 [ 59825 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 6.5h [ 23400 ] 3.5h [ 12600 ]
            Time Spent 17.5h [ 63000 ] 20.5h [ 73800 ]
            Worklog Id 59952 [ 59952 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 3.5h [ 12600 ] 0.5h [ 1800 ]
            Time Spent 20.5h [ 73800 ] 23.5h [ 84600 ]
            Worklog Id 59965 [ 59965 ]
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 03/Jul/17 12:15 PM
            • Time Spent:
              3h
               

              Full file testing

            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Smita Pawar Please update test case and update testing status.

            Sachin HingoleRevansiddha Gaur

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Smita Pawar Please update test case and update testing status. Sachin Hingole Revansiddha Gaur
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue relates to NF-3271 [ NF-3271 ]
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 06/Jul/17 04:56 AM - edited
            • Time Spent:
              5.5h
               

              Tesing on LB

            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 0.5h [ 1800 ] 0h [ 0 ]
            Time Spent 23.5h [ 84600 ] 27.5h [ 99000 ]
            Worklog Id 61011 [ 61011 ]
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have started testing after restoring production data on LB.
            When have deleted run rate maintenance, we receive server error,
            Server error issue on manual import export is already reported.(Jira NF-3271 for reference.)

            Testing status

            1. Every Year of first month event should be of Open Enrollment. Tested working fine.
            5. WEF Process Flag whether to run or not. As discussed this point can not be tested by UI

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have started testing after restoring production data on LB. When have deleted run rate maintenance, we receive server error, Server error issue on manual import export is already reported.(Jira NF-3271 for reference.) Testing status 1. Every Year of first month event should be of Open Enrollment. Tested working fine. 5. WEF Process Flag whether to run or not. As discussed this point can not be tested by UI
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 10/Jul/17 01:57 PM
            • Time Spent:
              1h
               

              Internal discussion
              Scenario verification

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 27.5h [ 99000 ] 28.5h [ 102600 ]
            Worklog Id 62111 [ 62111 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Link This issue relates to WT-10081 [ WT-10081 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Link This issue relates to WT-10131 [ WT-10131 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Link This issue relates to WT-10132 [ WT-10132 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 13/Jul/17 05:30 PM
            • Time Spent:
              2h
               

              Exporting the metso ADP ACA Employee file on LB
              testing the file
              reporting associated issues

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 28.5h [ 102600 ] 30.5h [ 109800 ]
            Worklog Id 63227 [ 63227 ]
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Smita Pawar Please update stage and Production ETA.
            Sachin Hingole

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Smita Pawar Please update stage and Production ETA. Sachin Hingole
            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 24/Jul/17 08:00 AM
            • Time Spent:
              2h
               
              <No comment>
            smita.pawar Smita Pawar (Inactive) made changes -
            Production Due Date 16/Aug/2017
            Stage Due Date 9/Aug/17 [ 2017-08-09 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 30.5h [ 109800 ] 33.5h [ 120600 ]
            Worklog Id 66562 [ 66562 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 33.5h [ 120600 ] 38.5h [ 138600 ]
            Worklog Id 67041 [ 67041 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 5h [ 18000 ]
            Time Spent 38.5h [ 138600 ] 33.5h [ 120600 ]
            Worklog Id 67041 [ 67041 ]
            Worklog Time Spent 5h [ 18000 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ] 3h [ 10800 ]
            Time Spent 33.5h [ 120600 ] 35.5h [ 127800 ]
            Worklog Id 61011 [ 61011 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 3h [ 10800 ] 3.5h [ 12600 ]
            Time Spent 35.5h [ 127800 ] 35h [ 126000 ]
            Worklog Id 61011 [ 61011 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 3.5h [ 12600 ] 1.5h [ 5400 ]
            Time Spent 35h [ 126000 ] 37h [ 133200 ]
            Worklog Id 67508 [ 67508 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Revansiddha Gaur [ revansiddha.gaur ]
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            WT-10131 & WT-10132 are open hence assigning back to Dev once all issues will get fixed pl assign to QA

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - WT-10131 & WT-10132 are open hence assigning back to Dev once all issues will get fixed pl assign to QA
            smita.pawar Smita Pawar (Inactive) made changes -
            Production Due Date 16/Aug/2017 14/Sep/2017
            Stage Due Date 9/Aug/17 [ 2017-08-09 ] 7/Sep/17 [ 2017-09-07 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Stage Due Date 7/Sep/17 [ 2017-09-07 ] 6/Sep/17 [ 2017-09-06 ]
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 06/Sep/17 11:03 AM - edited
            • Time Spent:
              0.5h
               

              Analysis of client email

            Hide
            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            There is no outstanding blockage to fix the issue. So I am assigning to you back.

            Thanks,
            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - There is no outstanding blockage to fix the issue. So I am assigning to you back. Thanks, Revan
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Smita Pawar [ smita.pawar ]
            Hide
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) added a comment -

            Testing of above incremental transactions is done

            Testing status :

            1. Every Year of first month event should be of Open Enrollment - Done
            2. Should have offer specific coverage element on the file. (OFFR=COVG)
            Ex.
            If OFFR IS open enrollment then should coverage event must be of Open Enrollment - Done
            3. Employee has Continuous enrollment from last year his enrollment effective must be
            reflected as current year start date.
            Ex.
            Employee Name - Abc
            Actual Enrollment Effective Date- 01/01/2016 or 05/01/2016
            Termination Date- Null - Done
            Expected on the file -Effective Date as - 01/01/2017 & Termination Date as Null.
            4.Should be identifiable eligibility records associated with offer as unique - Done Checked for random employees.
            5.WEF Process Flag whether to run or not - Unable to check by UI

            This is working as expected . Hence marking it as ready for stage.

            Thanks,
            Yogita

            CC - Mandar Kulkarni Smita Pawar Prajakta Belhe

            Show
            yogita.bhadane Yogita Bhadane (Inactive) added a comment - Testing of above incremental transactions is done Testing status : 1. Every Year of first month event should be of Open Enrollment - Done 2. Should have offer specific coverage element on the file. (OFFR=COVG) Ex. If OFFR IS open enrollment then should coverage event must be of Open Enrollment - Done 3. Employee has Continuous enrollment from last year his enrollment effective must be reflected as current year start date. Ex. Employee Name - Abc Actual Enrollment Effective Date- 01/01/2016 or 05/01/2016 Termination Date- Null - Done Expected on the file -Effective Date as - 01/01/2017 & Termination Date as Null. 4.Should be identifiable eligibility records associated with offer as unique - Done Checked for random employees. 5.WEF Process Flag whether to run or not - Unable to check by UI This is working as expected . Hence marking it as ready for stage. Thanks, Yogita CC - Mandar Kulkarni Smita Pawar Prajakta Belhe
            yogita.bhadane Yogita Bhadane (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)
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 13/Sep/17 04:47 PM
            • Time Spent:
              2.5h
               

              Testing of incremental transactions on LB

            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Remaining Estimate 1.5h [ 5400 ] 0h [ 0 ]
            Time Spent 37h [ 133200 ] 39.5h [ 142200 ]
            Worklog Id 78615 [ 78615 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Stage Due Date 6/Sep/17 [ 2017-09-06 ] 17/Sep/17 [ 2017-09-17 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Production Due Date 14/Sep/2017 21/Sep/2017
            smita.pawar Smita Pawar (Inactive) made changes -
            Stage Due Date 17/Sep/17 [ 2017-09-17 ] 18/Sep/17 [ 2017-09-18 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Yogita Bhadane [ yogita.bhadane ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue relates to WT-10032 [ WT-10032 ]
            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)
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 19/Sep/17 10:07 AM
            • Time Spent:
              0.5h
               

              Template verification

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 39.5h [ 142200 ] 40h [ 144000 ]
            Worklog Id 79656 [ 79656 ]
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 19/Sep/17 04:59 PM
            • Time Spent:
              3.5h
               

              Template creation on stage.
              Testing scenarios.
              Discussion with ACA team.

            Hide
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) added a comment -

            Revansiddha Gaur

            Hi Revan,

            While testing the incremental transactions on metso we found below issues

            1. OFFER != COVG(Some employees got multiple offers and single COVG).
            2. ELIG seg is not rolled out for some employees even they are eligible for plans.

            Please check.

            Please find below template details for same:

            Environment - Stage
            Company - Metso benefits
            Template name - Metso_ADP_ACA_WT9760

            Let me know if something else needed.

            Thanks,
            Yogita

            CC - Mandar Kulkarni Prajakta Belhe Smita Pawar

            Show
            yogita.bhadane Yogita Bhadane (Inactive) added a comment - Revansiddha Gaur Hi Revan, While testing the incremental transactions on metso we found below issues 1. OFFER != COVG(Some employees got multiple offers and single COVG). 2. ELIG seg is not rolled out for some employees even they are eligible for plans. Please check. Please find below template details for same: Environment - Stage Company - Metso benefits Template name - Metso_ADP_ACA_WT9760 Let me know if something else needed. Thanks, Yogita CC - Mandar Kulkarni Prajakta Belhe Smita Pawar
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 40h [ 144000 ] 43.5h [ 156600 ]
            Worklog Id 80368 [ 80368 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Assignee Yogita Bhadane [ yogita.bhadane ] Revansiddha Gaur [ revansiddha.gaur ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: On Hold(10215)
            Hide
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) added a comment - - edited

            Revansiddha Gaur

            Hi Revan,

            Below employees got multiple offers but only one COVG segment:

            Tester Holt
            Mario Test
            Gertrude Testton
            Bruce Tester

            I have attached exported file of date range 01/01/2017 - 09/27/2017.

            Sending you password of file in mail.

            Below are the template details:

            Environment - Stage
            Company - Metso benefits
            Template name - Metso_ADP_ACA_WT9760

            Let me know if something else needed.

            Thanks,
            Yogita

            CC - Mandar Kulkarni | Smita Pawar | Prajakta Belhe

            Show
            yogita.bhadane Yogita Bhadane (Inactive) added a comment - - edited Revansiddha Gaur Hi Revan, Below employees got multiple offers but only one COVG segment: Tester Holt Mario Test Gertrude Testton Bruce Tester I have attached exported file of date range 01/01/2017 - 09/27/2017. Sending you password of file in mail. Below are the template details: Environment - Stage Company - Metso benefits Template name - Metso_ADP_ACA_WT9760 Let me know if something else needed. Thanks, Yogita CC - Mandar Kulkarni | Smita Pawar | Prajakta Belhe
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 27/Sep/17 08:30 AM
            • Time Spent:
              1h
               

              Discussion with ACA team.
              Verification of file.

            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 43.5h [ 156600 ] 44.5h [ 160200 ]
            Worklog Id 81854 [ 81854 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 44.5h [ 160200 ] 45h [ 162000 ]
            Worklog Id 81871 [ 81871 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Worklog Id 81871 [ 81871 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 45h [ 162000 ] 47h [ 169200 ]
            Worklog Id 83933 [ 83933 ]
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 09/Oct/17 01:15 PM
            • Time Spent:
              0.5h
               

              Internal discussion

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 47h [ 169200 ] 47.5h [ 171000 ]
            Worklog Id 83943 [ 83943 ]
            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 09/Oct/17 09:00 PM
            • Time Spent:
              2h
               

              Analysis for the cause.

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Smita Pawar [ smita.pawar ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 47.5h [ 171000 ] 49h [ 176400 ]
            Worklog Id 84228 [ 84228 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 10/Oct/17 09:00 PM
            • Time Spent:
              1.5h
               

              Analysis & issue fixed.

            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 12/Oct/17 09:00 PM
            • Time Spent:
              3h
               

              Approval Pending condition issue fixed & checkin to trunk,ui-refresh,lb checkin

            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 12/Oct/17 09:00 PM
            • Time Spent:
              2h
               

              Eligibility process run for 2016 & 2017 year to speed up the testing.

            Permalink
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 12/Oct/17 11:55 PM
            • Time Spent:
              3h
               

              Worked and discussion with revan about this issue.

            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 49h [ 176400 ] 52h [ 187200 ]
            Worklog Id 85179 [ 85179 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 52h [ 187200 ] 54h [ 194400 ]
            Worklog Id 85180 [ 85180 ]
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Revansiddha Gaur,

            Check in was needs to be done against Jira 'WT-10131' as its status is Reopen.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Revansiddha Gaur , Check in was needs to be done against Jira ' WT-10131 ' as its status is Reopen.
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Time Spent 54h [ 194400 ] 57h [ 205200 ]
            Worklog Id 86991 [ 86991 ]
            smita.pawar Smita Pawar (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)
            smita.pawar Smita Pawar (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)
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Description 1. Every Year of first month event should be of Open Enrollment.

            2. Should have offer specific coverage element on the file. (OFFR=COVG)
            Ex.
            If OFFR IS open enrollment then should coverage event must be of Open Enrollment.

            3. Employee has Continuous enrollment from last year his enrollment effective must be
            reflected as current year start date.
            Ex.
            Employee Name - Abc
            Actual Enrollment Effective Date- 01/01/2016 or 05/01/2016
            Termination Date- Null
            Expected on the file -Effective Date as - 01/01/2017 & Termination Date as Null.

            4.Should be identifiable eligibility records associated with offer as unique

            5.WEF Process Flag whether to run or not.             		1. Every Year of first month event should be of Open Enrollment.

            2. Should have offer specific coverage element on the file. (OFFR=COVG)
            Ex.
            If OFFR IS open enrollment then should coverage event must be of Open Enrollment.

            3. Employee has Continuous enrollment from last year his enrollment effective must be
            reflected as current year start date.
            Ex.
            Employee Name - Abc
            Actual Enrollment Effective Date- 01/01/2016 or 05/01/2016
            Termination Date- Null
            Expected on the file -Effective Date as - 01/01/2017 & Termination Date as Null.

            4.Should be identifiable eligibility records associated with offer as unique

            5.WEF Process Flag whether to run or not.



            Current Implementation : If Employee has Continuous enrollment from last year, his effective date was populating his actual enrollment effective date in the system.
            New Implementation : If Employee has Continuous enrollment from last year, his enrollment effective date must be reflected as current year start date.
            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)
            smita.pawar Smita Pawar (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)
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 15/Nov/17 05:52 PM - edited
            • Time Spent:
              2h
               

              Discussion with smita.
              Stage testing.

            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 57h [ 205200 ] 59h [ 212400 ]
            Worklog Id 91062 [ 91062 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Worklog Id 91062 [ 91062 ]
            Permalink
            smita.pawar Smita Pawar (Inactive) logged work - 17/Nov/17 01:54 PM
            • Time Spent:
              0.5h
               

              Internal discussion
              Data given to developer
              Scenario verification

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 59h [ 212400 ] 59.5h [ 214200 ]
            Worklog Id 91469 [ 91469 ]
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on Stage [Metso for Hspl.
            Its working fine.]
            Verified points are as follows.
            1. Every Year of first month event should be of Open Enrollment - Done
            This is only for open enrollment changes
            2. Should have offer specific coverage element on the file. (OFFR=COVG)
            Ex.
            If OFFR IS open enrollment then should coverage event must be of Open Enrollment - Done
            3. Employee has Continuous enrollment from last year his enrollment effective must be
            reflected as current year start date.
            Ex.
            Employee Name - Abc
            Actual Enrollment Effective Date- 01/01/2016 or 05/01/2016
            Termination Date- Null - Done
            4.Should be identifiable eligibility records associated with offer as unique - Done Checked for random employees.

            This change request is ready for Production

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Stage [Metso for Hspl. Its working fine.] Verified points are as follows. 1. Every Year of first month event should be of Open Enrollment - Done This is only for open enrollment changes 2. Should have offer specific coverage element on the file. (OFFR=COVG) Ex. If OFFR IS open enrollment then should coverage event must be of Open Enrollment - Done 3. Employee has Continuous enrollment from last year his enrollment effective must be reflected as current year start date. Ex. Employee Name - Abc Actual Enrollment Effective Date- 01/01/2016 or 05/01/2016 Termination Date- Null - Done 4.Should be identifiable eligibility records associated with offer as unique - Done Checked for random employees. This change request is ready for Production
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            Production Due Date 21/Sep/2017 25/Nov/2017
            Stage Due Date 18/Sep/17 [ 2017-09-18 ] 11/Nov/17 [ 2017-11-11 ]
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Approval status Approved for production deployment [ 18457 ]
            Epic/Theme ACA
            Labels ACA
            Hide
            Permalink
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,
            Attaching production deployment approval email for reference:
            !Re Request for Production deployment - 25 Nov 2017.msg
            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching production deployment approval email for reference: !Re Request for Production deployment - 25 Nov 2017.msg Regards Gaurav
            gaurav.sodani Gaurav Sodani (Inactive) made changes -
            Company All Clients/Multiple Clients [ 18434 ]
            Environment Production [ 18442 ]
            Permalink
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 24/Nov/17 10:00 PM
            • Time Spent:
              6h
               

              Production artifact check-in to newly created branch.
              Discussion with Gaurav and team about check-in issues.

            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)
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            smita.pawar Smita Pawar (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)
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 59.5h [ 214200 ] 65.5h [ 235800 ]
            Worklog Id 92792 [ 92792 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue relates to WT-9320 [ WT-9320 ]
            rakeshr Rakesh Roy (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)
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Sachin Hingole [ sachin.hingole ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Closed [ 6 ] Resolution Setting [ 11616 ]
            Transition Time In Source Status Execution Times
            Revansiddha Gaur (Inactive) made transition -
            New Request Pending for Approval
            		4d 23h 8m 1
            Revansiddha Gaur (Inactive) made transition -
            Pending for Approval Approved for Development
            		3s 1
            Revansiddha Gaur (Inactive) made transition -
            Approved for Development In Development
            		2s 1
            Smita Pawar (Inactive) made transition -
            In LB Testing Reopen in Local
            		49d 2h 21m 1
            Sachin Hingole (Inactive) made transition -
            Reopen in Local In Development
            		42d 23m 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		1d 3h 37m 2
            Smita Pawar (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		59d 23h 51m 1
            Smita Pawar (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            		4s 1
            Smita Pawar (Inactive) made transition -
            Approved for Stage Stage Testing
            		3s 1
            Smita Pawar (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		11d 23h 32m 1
            Smita Pawar (Inactive) made transition -
            Pending for Production Approval Approved for production
            		5s 1
            Smita Pawar (Inactive) made transition -
            Approved for production In Production Testing
            		3s 1
            Rakesh Roy (Inactive) made transition -
            In Production Testing Production Complete
            		75d 22h 59m 1
            Rakesh Roy (Inactive) made transition -
            Production Complete Closed
            		9s 1
            Sachin Hingole (Inactive) made transition -
            Closed Resolution Setting
            		75d 15h 56m 1

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              revansiddha.gaur Revansiddha Gaur (Inactive)
              Developer:
              Revansiddha Gaur (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 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 - 24h Original Estimate - 24h
                  24h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 65.5h
                  65.5h