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

          rakeshr Rakesh Roy (Inactive) created issue -
          neelam.yangal Neelam Yangal (Inactive) made changes -
          Field Original Value New Value
          Assignee Neelam Yangal [ neelam.yangal ] Vinanti Yadav [ vinanti.yadav ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          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
          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









          gokul.sonawane Gokul Sonawane (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Attachment EligibilityEngine_tables.xls [ 22910 ]
          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
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Assignee Vinanti Yadav [ vinanti.yadav ] Rakesh Roy [ rakeshr ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Rakesh Roy [ rakeshr ] Deepali Tidke [ deepalit ]
          vinanti.yadav Vinanti Yadav (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)
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Status New Request [ 10029 ] Pending for Approval [ 10002 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Status Approved for Development [ 10003 ] In Development [ 10007 ]
          deepalit Deepali Tidke (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          deepalit Deepali Tidke (Inactive) made changes -
          Assignee Deepali Tidke [ deepalit ] Venkatesh Pujari [ venkatesh.pujari ]
          gokul.sonawane Gokul Sonawane (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          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
          venkatesh.pujari Venkatesh Pujari (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)
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Assignee Venkatesh Pujari [ venkatesh.pujari ] Vinanti Yadav [ vinanti.yadav ]
          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.
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Assignee Vinanti Yadav [ vinanti.yadav ] Venkatesh Pujari [ venkatesh.pujari ]
          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.
          venkatesh.pujari Venkatesh Pujari (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)
          rakeshr Rakesh Roy (Inactive) made changes -
          Developer Vinanti Yadav [ vinanti.yadav ]
          gokul.sonawane Gokul Sonawane (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)
          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.
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
          gokul.sonawane Gokul Sonawane (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: Stage Deployed(11602)
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
          satyap Satya made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Status Approved for production [ 10034 ] Production Testing [ 10202 ]
          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
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Resolution Done [ 10000 ] Fixed [ 1 ]
          Status Production Complete [ 10028 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Vinanti Yadav (Inactive) made transition -
          New Request Pending for Approval
          6d 22h 44m 1
          Vinanti Yadav (Inactive) made transition -
          Pending for Approval Approved for Development
          5s 1
          Vinanti Yadav (Inactive) made transition -
          Approved for Development In Development
          5s 1
          Deepali Tidke (Inactive) made transition -
          In Development In LB Testing
          2h 1m 1
          Venkatesh Pujari (Inactive) made transition -
          In LB Testing Pending for Stage Approval
          16d 19h 1
          Venkatesh Pujari (Inactive) made transition -
          Pending for Stage Approval Approved for Stage
          2s 1
          Venkatesh Pujari (Inactive) made transition -
          Approved for Stage Stage Testing
          2s 1
          Venkatesh Pujari (Inactive) made transition -
          Stage Testing Pending for Production Approval
          19d 1h 46m 1
          Venkatesh Pujari (Inactive) made transition -
          Pending for Production Approval Approved for production
          5s 1
          Venkatesh Pujari (Inactive) made transition -
          Approved for production In Production Testing
          5s 1
          Venkatesh Pujari (Inactive) made transition -
          In Production Testing Production Complete
          1d 4h 9m 1
          Venkatesh Pujari (Inactive) made transition -
          Production Complete Closed
          11s 1

            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: