-
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
Field | Original Value | New Value |
---|---|---|
Assignee | Neelam Yangal [ neelam.yangal ] | Vinanti Yadav [ vinanti.yadav ] |
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 |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Attachment | EligibilityEngine_tables.xls [ 22910 ] |
Assignee | Vinanti Yadav [ vinanti.yadav ] | Rakesh Roy [ rakeshr ] |
Assignee | Rakesh Roy [ rakeshr ] | Deepali Tidke [ deepalit ] |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Status | New Request [ 10029 ] | Pending for Approval [ 10002 ] |
Status | Pending for Approval [ 10002 ] | Approved for Development [ 10003 ] |
Status | Approved for Development [ 10003 ] | In Development [ 10007 ] |
Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Assignee | Deepali Tidke [ deepalit ] | Venkatesh Pujari [ venkatesh.pujari ] |
Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Vinanti Yadav [ vinanti.yadav ] |
Assignee | Vinanti Yadav [ vinanti.yadav ] | Venkatesh Pujari [ venkatesh.pujari ] |
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) |
Developer | Vinanti Yadav [ vinanti.yadav ] |
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) |
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) |
Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
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) |
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) |
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) |
Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
Resolution | Done [ 10000 ] | |
Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
Resolution | Done [ 10000 ] | Fixed [ 1 ] |
Status | Production Complete [ 10028 ] | Closed [ 6 ] |