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

Create and verify "Reverse Eligibility Migration" script in workterra utility

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Platform
    • Labels:
      None
    • Module:
      Platform
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      1) We are integrating "Reverse Eligibility Migration" script in workterra utility and for testing this tool we need one dedicated resource.
      As this is major and core change in our system so we need to test this utility thoroughly.
      We will let know once this tool is ready for your testing.

      2) We are going to run (Find discrepancies in eligibility rule) script on major stage companies.
      For that we need few companies list from stage.

      Thanks & Regards,
      Neelam A. Yangal

      Affected Files:
      1. CreditPool.vb
      2. EligibilityGeneration.vb
      3. Form1.vb
      Database
      View
      1. dbo.OES_VIEW_AdditionalCriteriaCreditPoolEligibilityComponent.View.sql
      2. dbo.OES_VIEW_AdditionalCriteriaEligibilityComponent.View.sql
      3. dbo.OES_VIEW_AdditionalCriteriaNewHireReHireEligibility.View.sql
      4. dbo.OES_VIEW_AdditionalCriteriaRatesEligibilityComponent.View.sql

      SP's
      1. dbo.OES_SP_MigrationScriptForAdditionalFieldInfoFromGenericEligibilityRulesToAdditionalFieldEligibilityRules.StoredProcedure .sql
      2. dbo.OES_SP_MigrationScriptForCreditPoolFromGenericEligibilityRuleToCreditPoolEligibilityRules.StoredProcedure.sql
      3.dbo.OES_SP_MigrationScriptForEffectiveDateTerminationDateRuleFromGenericEligibilityRulesToEffectiveDateTerminationDateRule.StoredProcedure.sql
      4. dbo.OES_SP_MigrationScriptForLandingPageFromGenericEligibilityRulesToLandingPageEligibilityRules.StoredProcedure.sql
      5.dbo.OES_SP_MigrationScriptForNewHireReHireRulesFromGenericEligibilityRulesToNewHireReHireRulesEligibilityRules.StoredProcedure.sql
      6.dbo.OES_SP_MigrationScriptForOpenEnrollmentRulesFromGenericEligibilityRulesToClasswiseOEEligibilityRules.StoredProcedure .sql
      7.dbo.OES_SP_MigrationScriptForPlanDesignFromGenericEligibilityRulesToDemographicEligibilityRules.StoredProcedure.sql
      8.dbo.OES_SP_MigrationScriptForPlanDesignHealthTierMappingFromGenericEligibilityRulesToPlanDesignHealthTierMappingEligibilityRules.StoredProcedure.sql
      9.dbo.OES_SP_MigrationScriptForQualifyingEventFromGenericEligibilityRulesToQualifyingEventEligibilityRules.StoredProcedure.sql
      10.dbo.OES_SP_MigrationScriptForRate_SubNameFromGenericEligibilityRulesToSubRatesEligibilityRules.StoredProcedure.sql

        Attachments

          Activity

          Hide
          vinanti.yadav Vinanti Yadav (Inactive) added a comment -

          Hi Rakesh Roy,

          Reverse Migration scripts are deployed On LB for Following:

          1. Plan Design
          2. SubRate
          3. CreditPool
          4. PlanDesignHealthTierMapping
          5. NewHireReHireRules
          6. EffectiveDateTerminationDateRule
          7. QualifyingEvent
          8. LandingPage
          9. AdditonalFields
          10. OpenEnrollmentRules

          Steps for Reverse Migration:
          1. select company using dropdown
          2. click Reverse Migration Button.

          after successfull migration you can verify using database

          1.Create New Rule or Update Existing Generic Eligiblity Rule.
          2.Add that Rule to any component like Plan or SubRate or creditPool and so on.
          3.Verify data from All Generic Eligibility Table and old Eligibility table.
          e.g if you add generic rule for Plan then after reverse migration
          verify data from generic Eligibility tables and Plan design Eligibility tables.

          PFA for Table Details EligibilityEngine_tables.xls

          Thanks,
          Vinanti

          Show
          vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi Rakesh Roy , Reverse Migration scripts are deployed On LB for Following: 1. Plan Design 2. SubRate 3. CreditPool 4. PlanDesignHealthTierMapping 5. NewHireReHireRules 6. EffectiveDateTerminationDateRule 7. QualifyingEvent 8. LandingPage 9. AdditonalFields 10. OpenEnrollmentRules Steps for Reverse Migration: 1. select company using dropdown 2. click Reverse Migration Button. after successfull migration you can verify using database 1.Create New Rule or Update Existing Generic Eligiblity Rule. 2.Add that Rule to any component like Plan or SubRate or creditPool and so on. 3.Verify data from All Generic Eligibility Table and old Eligibility table. e.g if you add generic rule for Plan then after reverse migration verify data from generic Eligibility tables and Plan design Eligibility tables. PFA for Table Details EligibilityEngine_tables.xls Thanks, Vinanti
          Hide
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

          Hi Vinanti Yadav,

          Please do the reverse migration for my company and then assign this ticket to me for testing.

          Thanks,
          Venkatesh

          Show
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Vinanti Yadav , Please do the reverse migration for my company and then assign this ticket to me for testing. Thanks, Venkatesh
          Hide
          vinanti.yadav Vinanti Yadav (Inactive) added a comment -

          Hi Venkatesh Pujari,

          Reverse Migration is done for LBSanityCOD on LB.

          Regards,
          Vinanti.

          Show
          vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi Venkatesh Pujari , Reverse Migration is done for LBSanityCOD on LB. Regards, Vinanti.
          Hide
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

          Hi Vinanti,

          As this reverse script done on any company cannot be verified through UI I will require continuous support from You for verification of the eligibility because this has many tables from which the data has to be verified.I do not have so much knowledge of these tables and foreign key for testing.Please let me know what can be done for this.

          Rakesh Roy,Amruta Lohiya,Neelam Yangal,Deepali Tidke

          Thanks,
          Venkatesh

          Show
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Vinanti, As this reverse script done on any company cannot be verified through UI I will require continuous support from You for verification of the eligibility because this has many tables from which the data has to be verified.I do not have so much knowledge of these tables and foreign key for testing.Please let me know what can be done for this. Rakesh Roy , Amruta Lohiya , Neelam Yangal , Deepali Tidke Thanks, Venkatesh
          Hide
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

          Tested this queries provided by Neelam.

          Verified all the rules after reverse migration.

          Ready for Stage.

          Thanks,
          Venkatesh.

          Show
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Tested this queries provided by Neelam. Verified all the rules after reverse migration. Ready for Stage. Thanks, Venkatesh.
          Hide
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

          Tested this by using the queries provided by Neelam.

          Verified all the rules after reverse migration.

          Ready for Production.

          Thanks,
          Venkatesh.

          Show
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Tested this by using the queries provided by Neelam. Verified all the rules after reverse migration. Ready for Production. Thanks, Venkatesh.
          Hide
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

          Cannot test this reverse functionality so closing the ticket

          Show
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Cannot test this reverse functionality so closing the ticket

            People

            Assignee:
            venkatesh.pujari Venkatesh Pujari (Inactive)
            Reporter:
            rakeshr Rakesh Roy (Inactive)
            Account Executive:
            Amruta Lohiya
            Developer:
            Vinanti Yadav (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: