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

          No work has yet been logged on this issue.

            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: