-
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
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
Cannot test this reverse functionality so closing the ticket