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 ]
          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)
          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 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Assignee Vinanti Yadav [ vinanti.yadav ] Venkatesh Pujari [ venkatesh.pujari ]
          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)
          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 ]
          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 ]

            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: