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

          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: