-
Type:
Bug
-
Status: Closed
-
Priority:
High
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:
-
Environment:Production
-
Bug Severity:Medium
-
Module:BenAdmin - Import
-
Reported by:Support
-
Company:STSLLC
-
Item State:Production Complete - Closed
-
Sprint:WT Sprint 37 - Bugs, WT Sprint 38 - Bugs, WT Sprint 40 - Bugs, WT- Sprint 43
When importing the same election file multiple times while nothing has change on the import file a new history record is being created for every load.
- relates to
-
-
- Closed
-
-
- Time Spent:
- 5.5h
-
Analysis and code understanding
-
- Time Spent:
- 8h
-
Analysis of election Import.
What data is already available - Employee, Spouse, Child Election.
How members of one elections are maintained and then inserted into Coverage table.
How the decision is taken if the existing election needs to be terminated.
How eligible Employees, Spouse and Child are maintained.
-
- Time Spent:
- 8h
-
Analysis on probable solution,
Discussion with Jaideep
Defining scope of the task
-
- Time Spent:
- 8h
-
Code Analysis
Analyzing how proposed solution can be inserted into existing system.
-
- Time Spent:
- 8h
-
Code analysis, creating document and discussion with Jaideep.
-
- Time Spent:
- 3h
-
Coding, Discussion with Gaurav
-
- Time Spent:
- 8h
-
Working on Hash table to send all related records to bad if one is invalid.
-
- Time Spent:
- 7h
-
Completed Bad file part and started with Same Coverage.
Same coverage has a Enrollment ID discrepancy. The ID's are used in Rate, SubPlan enrollment etc which will not be available in new way. started working on same.
-
- Time Spent:
- 4h
-
Discussion with Jaideep,
debug to analyze Enrollment ID discrepancy
redesign solution to handle termination date issue
analyze why existing coverage and rates are checked
-
- Time Spent:
- 5h
-
Solution re designing,
Discussion with Jaideep, Vinayak,
Debug code
started with new solution
-
- Time Spent:
- 8h
-
Create code skeleton for decisions based on coverage and termination date.
-
- Time Spent:
- 8h
-
Collecting data from Coverage table for current processed employees and store in hashtable
-
- Time Spent:
- 8h
-
Finished with decision making if enrollment needs to be terminated or updated depending upon coverage data, termination etc.
Actual Termination / update query generation is remaining.
-
- Time Spent:
- 8h
-
Generate query for coverage. This coverage will be checked against coverage given in file.
-
- Time Spent:
- 8h
-
Unit testing
Corrections wherever needed
Enrollment key deletion from hashtable if not going to be processed.
Jayshree Nagpure (Inactive)
logged work - 09/Oct/17 12:04 PM -
- Time Spent:
- 4.5h
-
LB testing and discussion
-
- Time Spent:
- 7h
-
Re opened issue analysis and Code checkin
-
- Time Spent:
- 0.25h
-
Internal discussion with jayshree
Jayshree Nagpure (Inactive)
logged work - 24/Jan/18 01:07 PM -
- Time Spent:
- 0.5h
-
Scenarios explanation to sanjana
-
- Time Spent:
- 1h
-
Analysis of document and attached test case
created election import template on LB on "For QA FDU For HSPL" company.
-
- Time Spent:
- 5.5h
-
Testing
Jira update
Internal discussion with jayshree
-
- Time Spent:
- 0.5h
-
Help to sanjana to execute testcases.
-
- Time Spent:
- 5.5h
-
Testing
Internal discussion
Jayshree Nagpure (Inactive)
logged work - 01/Feb/18 10:03 AM -
- Time Spent:
- 1h
-
- Help to sanjana for scenario testing
- Test-cases discussion
-
- Time Spent:
- 1h
-
Discussion with Ganesh and sanjana
