-
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 - Report
-
Reported by:Client
-
Company:TIBCO
-
Item State:Production Complete - Closed
-
Sprint:WT Sprint 41
Please see the adjustment issues BCC is having with TIBCO's August bill.
Issue 1: LTD coverage is being unbilled and rebilled at a pro-rated monthly portion. Example: Alec Cross Originally billing for January for Long-Term Disability at $16.25 on the January Invoice. On the August invoice he is being credited for January in the Amount of -$16.25 and being rebilled at $3.67. We did load a new salary effective 1/25/2017, but no billing adjustment should have occurred. The system looks like it is trying to pro-rate for those last 7 days of the month. (16.25/31*7=$3.67)
Other examples: Aaron Shoffa, Adrian Johnson, and many more.
Issue 2: Abay Prajapati terminated 5/31/2017 via a file load that occurred on 6/13/2017. The adjustments on the August invoice look correct with the exception of the COBRA Admin Coverage. COBRA admin did not credit for June or July and COBRA admin is still being billed for August. Even stranger he is being rebilled for January through May which he was previously billed during those billing cycles. Another example of same issue is Shaohua Qu.
Issue 3: Barton Wright his ADD is not age reducing correctly. His age reduction should be the same as life with a volume of $169,000.00. The system for ADD is crediting $110,000 and re-billing at a volume of $260,000 February through current month of August. It looks like the system has not been doing the ADD age reductions correctly from the beginning. The system was reducing the amount to $110,000 versus $169,000
-
- Time Spent:
- 3.5h
-
Issue Analysis
Correction script
Code Fix - In Progress
JIRA status update
-
- Time Spent:
- 2.25h
-
Code fix and unit testing for Retro Add appearing with prorated premiums
JIRA Update
-
- Time Spent:
- 2.5h
-
discussion with Prasanna, analysis of age reduction issue and reply to client
-
- Time Spent:
- 5.5h
-
Discussion with Enrollment Team on Age reduction issue
Discussion on returns to be made by Employee-PlanDesign ID or by EnrollmentID
Code fix and Unit testing for retro term scenario
Discussion with QA for TIBCO - Aug 2017 Invoice testing
Audit script modification for Retro Add records verification
Data audit - Issue found in Retro Terms
-
- Time Spent:
- 2h
-
Code changes and unit testing to fix the retro Term adjustment scenario - Need to check different solution as it is failing in some different scenario
JIRA update for TIBCO audit
-
- Time Spent:
- 1h
-
Generated Invoices with existing procedure and after changing the procedure.
Compared data before and after change
-
- Time Spent:
- 0.5h
-
Issue fix verification
-
- Time Spent:
- 1h
-
Code check in verification
Query reply
-
- Time Spent:
- 0.75h
-
Verified output after applying condition - Scenarios getting failed
-
- Time Spent:
- 0.5h
-
Discussion
JIRA update
-
- Time Spent:
- 2.5h
-
Scenario testing - First Invoice 9 scenarios with different Add/Term Policies combinations completed
Code check in
Scenario analysis and fix when cost is changed as per ageband
Email communication
-
- Time Spent:
- 2.5h
-
3C updates
Scenario Testing - Tier changes (In Progress)
-
- Time Spent:
- 2.5h
-
Scenario discussion and verification for Self Insured Component issue when made non billable
Tier changes verification and Age band change scenario verification
-
- Time Spent:
- 7.5h
-
Testing of Retro Add and Retro Term scenarios.
-
- Time Spent:
- 2.5h
-
Age band scenario repro on LB
Could not repro the scenario on LB
Changes verified on existing data
