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

Importing Waived Benefit Type data

    Details

    • Type: Enhancement
    • Status: Production Complete
    • Priority: Low
    • 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:
      Enhancements: March-June 2017, WT Sprint 27

      Description

      We cannot import waived benefit type data with the current import functionality.
      We are receiving this request quite frequently to import benefit waive data.
      We have think story WT-4881 for this. Analysis document is attached herewith

        Attachments

        1. Affected Files.txt
          0.8 kB
        2. WaiveDataImport.docx
          15 kB
        3. Waive data Import-Test Cases.xls
          15 kB
        4. WaiveMapping.jpg
          WaiveMapping.jpg
          18 kB
        5. WaiveMapping.jpg
          WaiveMapping.jpg
          17 kB

          Issue Links

            Activity

            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            We need to consider below points for above enhancement :

            1) Waiver Reason
            2) Waive Contingency

            CC - Rakesh Roy Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - We need to consider below points for above enhancement : 1) Waiver Reason 2) Waive Contingency CC - Rakesh Roy Sachin Hingole
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Hi Jaideep Vinchurkar,

            PFA test cases Waive data Import-Test Cases.xls and let me know if anything is needs to add in it.

            CC - Sachin Hingole

            Thanks & Regards,
            Meghana Kulkarni

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Hi Jaideep Vinchurkar , PFA test cases Waive data Import-Test Cases.xls and let me know if anything is needs to add in it. CC - Sachin Hingole Thanks & Regards, Meghana Kulkarni
            Hide
            dkulling Debbie Kulling added a comment -

            Is there any ETA on when this is going to be put into development?

            Show
            dkulling Debbie Kulling added a comment - Is there any ETA on when this is going to be put into development?
            Hide
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            Hi Debbie Kulling,

            We are planning to pick up this next sprint that is Sprint 27, starting from 10th April.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - Hi Debbie Kulling , We are planning to pick up this next sprint that is Sprint 27, starting from 10th April.
            Hide
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            This is done. Code is under review.
            This will be deployed on LB tomorrow.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - This is done. Code is under review. This will be deployed on LB tomorrow.
            Hide
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            Affected Files:
            Affected Files.txt

            Impacted Areas:

            • Template Management
              -Template Information
              -Sub Template
              -Field Mapping
              -DTS
            • Manual Import
              -New Import Type

            Unit Testing Done:
            -New Import Type On Template Page
            -Only Waived Data fields for New Import Type Fields mapping screen
            -Sub template page after mapping
            -DTS for Benefit Type and Waiver Reason
            -Import With Benefit Type and Plan design both mapped
            -Import with either plan design or benefit Type mapped
            -AllowMultiplePlanEnrollment True and False combinations

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - Affected Files: Affected Files.txt Impacted Areas: Template Management -Template Information -Sub Template -Field Mapping -DTS Manual Import -New Import Type Unit Testing Done: -New Import Type On Template Page -Only Waived Data fields for New Import Type Fields mapping screen -Sub template page after mapping -DTS for Benefit Type and Waiver Reason -Import With Benefit Type and Plan design both mapped -Import with either plan design or benefit Type mapped -AllowMultiplePlanEnrollment True and False combinations
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Tested attached test scenarios on LB.

            Found Issues :
            WT-9321
            WT-9327
            WT-9329
            WT-9330
            WT-9333

            Hence assigning to dev team.

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Tested attached test scenarios on LB. Found Issues : WT-9321 WT-9327 WT-9329 WT-9330 WT-9333 Hence assigning to dev team. CC - Sachin Hingole
            Hide
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            On hold for priority bugs

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - On hold for priority bugs
            Hide
            dkulling Debbie Kulling added a comment -

            Do we have an ETA for completion?

            Show
            dkulling Debbie Kulling added a comment - Do we have an ETA for completion?
            Hide
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            CC: Rashmita Dudhe Prasad Pise

            WT-9291 and all issues related to this enhancement are deployed on LB

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - CC: Rashmita Dudhe Prasad Pise WT-9291 and all issues related to this enhancement are deployed on LB
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            verified on stage.
            Company - city of bellevue for hspl.

            Verified all linked jira's
            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 - verified on stage. Company - city of bellevue for hspl. Verified all linked jira's Working fine Marking item state as Ready for production Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            verified on Production
            Company - Je dunn for hspl

            Verified all linked jira's
            Working fine
            Marking item state as Production complete

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - verified on Production Company - Je dunn for hspl Verified all linked jira's Working fine Marking item state as Production complete Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            Hide
            amitthorve Amit Thorve (Inactive) added a comment -

            Jayshree Nagpure Can you please provide a sample specs on how to import waive benefit data?

            Show
            amitthorve Amit Thorve (Inactive) added a comment - Jayshree Nagpure Can you please provide a sample specs on how to import waive benefit data?
            Hide
            amitthorve Amit Thorve (Inactive) added a comment -

            Yogesh Chaudhari and Revansiddha Gaur The feature to import waive benefit data is deployed on production. Please check this ticket.

            Show
            amitthorve Amit Thorve (Inactive) added a comment - Yogesh Chaudhari and Revansiddha Gaur The feature to import waive benefit data is deployed on production. Please check this ticket.
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Amit Thorve

            Waive benefit data import Steps :

            1)Create new template
            -Select Import type as Waive Data Import
            -Select Plan Design
            2)Template setting customization is same as Election data import
            3)Sub-Template Fields
            -Employee SSN/Employee ID (uniquee)
            -Waive Effective date (Uniquee)
            -Waive Plan design Identifier (To waive plan) OR Waive benefit type (To Waive Benefit type)(Uniquee)
            -Waiver Reason (Not mandatory, depends on benefit customization)
            -Waive Termination date(Not mandatory)
            4)Field Mapping : Map fields according to sub template field.
            For Mapping field Refer Attached Screen shot :

            Note : 1)To waive single plan - Multiple selection Flag set to Yes(Customization in benefit type builder)
            2)To waive benefit - Multiple selection Flag set to No(Customization in benefit type builder)

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Amit Thorve Waive benefit data import Steps : 1)Create new template -Select Import type as Waive Data Import -Select Plan Design 2)Template setting customization is same as Election data import 3)Sub-Template Fields -Employee SSN/Employee ID (uniquee) -Waive Effective date (Uniquee) -Waive Plan design Identifier (To waive plan) OR Waive benefit type (To Waive Benefit type)(Uniquee) -Waiver Reason (Not mandatory, depends on benefit customization) -Waive Termination date(Not mandatory) 4)Field Mapping : Map fields according to sub template field. For Mapping field Refer Attached Screen shot : Note : 1)To waive single plan - Multiple selection Flag set to Yes(Customization in benefit type builder) 2)To waive benefit - Multiple selection Flag set to No(Customization in benefit type builder) Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            Hide
            amitthorve Amit Thorve (Inactive) added a comment -

            Thanks Jayshree Nagpure.

            Can we add Waiver Reason in the import?

            Show
            amitthorve Amit Thorve (Inactive) added a comment - Thanks Jayshree Nagpure . Can we add Waiver Reason in the import?
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited

            Yes Amit Thorve we can add waiver reason in waive import

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited Yes Amit Thorve we can add waiver reason in waive import
            Hide
            amitthorve Amit Thorve (Inactive) added a comment -

            Jayshree Nagpure Which field we should map for waiver reason and can we do the data transformation for the same?

            Show
            amitthorve Amit Thorve (Inactive) added a comment - Jayshree Nagpure Which field we should map for waiver reason and can we do the data transformation for the same?
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            In above comments I have attached screen shot for all mapping fields.
            Please find in attached screenshot highlighted to map waiver reason :
            And Yes we can do the Data Transformation for the same.

            While creating template select Import type as : "Waive Data import"
            Then in mapping field it will show only waive benefit fields which needs to be mapped.

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - In above comments I have attached screen shot for all mapping fields. Please find in attached screenshot highlighted to map waiver reason : And Yes we can do the Data Transformation for the same. While creating template select Import type as : "Waive Data import" Then in mapping field it will show only waive benefit fields which needs to be mapped.

              People

              Assignee:
              jayshree.nagpure Jayshree Nagpure (Inactive)
              Reporter:
              jaideep.vinchurkar Jaideep Vinchurkar (Inactive)
              Developer:
              Suraj Sokasane (Inactive)
              QA:
              Rashmita Dudhe (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Pre-Prod Due Date:
                Production Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 43h Original Estimate - 43h
                  43h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 79.25h
                  79.25h