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

Move existing eligibility rule to generic eligibility rule (Utility tool)-Analysis

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have 25
    • Sprint:
      WT Sprint 5

      Description

      Affected Files:

      Workterra Utility
      Form1.vb

      Database :

      SP's
      1. OES_SP_CreateDefaultGenericEligibilityRules.sql
      2.OES_SP_MigrationScriptForPlanDesignFromDemograhicEligibilityRuleToGenericEligibilityRule.sql
      3. OES_SP_MigrationScriptForRate_SubNameFromSubRatesEligibilityRulesToGenericEligibilityRule.sql
      4. OES_SP_MigrationScriptForCreditPoolFromCreditPoolEligibilityRulesToGenericEligibilityRule.sql
      5. OES_SP_MigrationScriptFromPlanDesignHealthTierMappingToGenericEligibilityRule.sql
      6. OES_SP_MigrationScriptForNewHireReHireRulesFromNewHireRehireRulesEligibilityRulesToGenericEligibilityRule.sql
      7. OES_SP_MigrationScriptForEffectiveDateTerminationDateRulesFromEffectiveDateTerminationDateRulesToGenericEligibilityRule.sql
      8.OES_SP_MigrationScriptForLandingPageFromLandingPageEligibilityRulesToGenericEligibilityRule.StoredProcedure.sql
      9.OES_SP_MigrationScriptForQualifyingEventFromQualifyingEventEligibilityRulesToGenericEligibilityRule.sql
      10.OES_SP_MigrationScriptForAdditionalFieldInfoFromAdditionalFieldEligibilityRulesToGenericEligibilityRule.StoredProcedure.sql

        Attachments

          Issue Links

            Activity

            Hide
            neelam.yangal Neelam Yangal (Inactive) added a comment -

            Hi shyam sharma,

            As this enhancement is related with common eligibility change.
            This item contains many module,We are releasing this all module step by step.
            With each release we are updating this ticket accordingly with proper comments.

            Recently we have released "Classwise Open Enrollment Effective Date Rules" Migration.
            so we again set there status as LB deployed.

            For any further details just ask to Vinanti Yadav, as she is the owner of this ticket.

            Thanks & Regards,
            Neelam A. Yangal

            Show
            neelam.yangal Neelam Yangal (Inactive) added a comment - Hi shyam sharma , As this enhancement is related with common eligibility change. This item contains many module,We are releasing this all module step by step. With each release we are updating this ticket accordingly with proper comments. Recently we have released "Classwise Open Enrollment Effective Date Rules" Migration. so we again set there status as LB deployed. For any further details just ask to Vinanti Yadav , as she is the owner of this ticket. Thanks & Regards, Neelam A. Yangal
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Neelam and Vinanti,

            Please create a separate ticket for the points which you deploy on LB because this ticket is ready for Stage so please do not change the item status of this ticket.

            For Classwise Open enrollment effective date rules please refer WT-3747.

            Thanks,
            Venkatesh.

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Neelam and Vinanti, Please create a separate ticket for the points which you deploy on LB because this ticket is ready for Stage so please do not change the item status of this ticket. For Classwise Open enrollment effective date rules please refer WT-3747 . Thanks, Venkatesh.
            Hide
            vinanti.yadav Vinanti Yadav (Inactive) added a comment -

            Hi Venkatesh Pujari and Neelam Yangal,

            Migration scripts are missing form stage branch which must be present in stage branch.
            I have done check in stage branch.

            Thanks,
            vinanti

            Show
            vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi Venkatesh Pujari and Neelam Yangal , Migration scripts are missing form stage branch which must be present in stage branch. I have done check in stage branch. Thanks, vinanti
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Neelam,

            I have verified the enhancement of moving existing eligibility rule to generic eligibility rule through utility and observed that rules are moved properly. I have checked this through the option you had mentioned in the earlier comments. The below are the steps which I have followed:-

            1) Restored one of company from Production on stage.
            2) Run scripts and did migration on Stage company.
            3) Refered old eligibility rule from production and new one from Stage.

            These changes have been tested on Rates,New Hire/ Rehire Rules,Effective termination rules and Plans.

            Thanks,
            Venkatesh.

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Neelam, I have verified the enhancement of moving existing eligibility rule to generic eligibility rule through utility and observed that rules are moved properly. I have checked this through the option you had mentioned in the earlier comments. The below are the steps which I have followed:- 1) Restored one of company from Production on stage. 2) Run scripts and did migration on Stage company. 3) Refered old eligibility rule from production and new one from Stage. These changes have been tested on Rates,New Hire/ Rehire Rules,Effective termination rules and Plans. Thanks, Venkatesh.
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Cannot test this on production so closing this ticket

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Cannot test this on production so closing this ticket

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              neelam.yangal Neelam Yangal (Inactive)
              Developer:
              Vinanti Yadav (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date: