-
Type:
Bug
-
Status: Closed
-
Priority:
High
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: ACA
-
Labels:None
-
Environment:Production
-
Module:ACA - 2017
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
-
Issue Importance:Can Wait
This need to consider for 2017 IRS Reporting.
Production Company - County of Del Norte
Rate Name - EIAHealth PPO 80/60 ACTIVE
Employee Name - Stormy L Borelli
Rates shown on Enroll Now and PDF are different (Please Note Enroll Now rates are correct), refer JIRA WT-2965
Prerequisite
1 Rate is created and also sub rate is created
2 Sub rate has setting Flat Rate + % of Monthly Rate for Calculate Contributions for this Plan by
3 refer customization done for sub rate 
4 employee is created and eligible to plan which is mapped with rate created in above prerequisite and is enrolled in plan (Make sure employee only monthly cost should be greater than 9.5% of FPL (for 2015 FPL amount was about $11777))
steps
1] create 1095C report
2] download 1095C and observe the employee Line 15 cost
Sachin Hingole (Inactive)
created issue -
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Nandkumar [ satyap ] | Sachin Hingole [ sachin.hingole ] |
This issue was related to wrong customization, and its fixed for "County of Del Norte".
But we need to fix this even if some one does wrong customization by mistake then system should consider only valid % amounts for cost calculations.
Sachin Hingole (Inactive)
added a comment - This issue was related to wrong customization, and its fixed for "County of Del Norte".
But we need to fix this even if some one does wrong customization by mistake then system should consider only valid % amounts for cost calculations. Sachin Hingole (Inactive)
made changes -
| Assignee | Sachin Hingole [ sachin.hingole ] | Nandkumar [ satyap ] |
Sachin Hingole Nandkumar Prabhakar Karlekar Is this open?
| Assignee | Nandkumar [ satyap ] | Sachin Hingole [ sachin.hingole ] |
Sachin Hingole (Inactive)
made changes -
| Issue Importance | Must have Additional [ 12201 ] | Can Wait [ 11801 ] |
As ACA 1095C and IRS submissions are completed for current year, But we have to consider this for next year.
As discussed with Nandkumar, assigning this JIRA to Ramya
Sachin Hingole (Inactive)
added a comment - As ACA 1095C and IRS submissions are completed for current year, But we have to consider this for next year.
As discussed with Nandkumar, assigning this JIRA to Ramya Sachin Hingole (Inactive)
made changes -
| Assignee | Sachin Hingole [ sachin.hingole ] | Ramya Tantry [ ramya.tantry ] |
Files affected:
Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095CData.StoredProcedure.sql
Ramya Tantry (Inactive)
added a comment - Files affected:
Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095CData.StoredProcedure.sql Cause: When Sub Rate has setting Flat Amount and % of salary then Line 15 showing wrong cost on 1095C PDF
Concern: When Sub Rate has setting Flat Amount and % of salary and if percentage is mentioned in both pre tax and post tax column,then we used to calculate cost irrespective of value present in monthly pre tax and monthly post tax. So cost was showing up different.
Correction: We have made code correction,that percent value will be considered only if value is present in monthly pre tax/post tax column.
Ramya Tantry (Inactive)
added a comment - Cause : When Sub Rate has setting Flat Amount and % of salary then Line 15 showing wrong cost on 1095C PDF
Concern : When Sub Rate has setting Flat Amount and % of salary and if percentage is mentioned in both pre tax and post tax column,then we used to calculate cost irrespective of value present in monthly pre tax and monthly post tax. So cost was showing up different.
Correction : We have made code correction,that percent value will be considered only if value is present in monthly pre tax/post tax column. 
Gokul Sonawane (Inactive)
made changes -
| Item State | Parent values: Development(10200) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Ramya Tantry (Inactive)
made changes -
| Assignee | Ramya Tantry [ ramya.tantry ] | Sachin Hingole [ sachin.hingole ] |
Ramya Tantry (Inactive)
made changes -
| Status | Open [ 1 ] | In Development [ 10007 ] |
Ramya Tantry (Inactive)
made changes -
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Ramya Tantry (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
Sachin Hingole (Inactive)
made changes -
| Attachment | Stormy L Borelli.png [ 25010 ] |
Sachin Hingole (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
Sachin Hingole (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
Verified on Stage, working fine.
Now it shows correct cost on 1095C PDF.
Sachin Hingole (Inactive)
added a comment - Verified on Stage, working fine.
Now it shows correct cost on 1095C PDF. Sachin Hingole (Inactive)
made changes -
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
Sachin Hingole (Inactive)
made changes -
| Production Due Date | 06/Sep/2016 |
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
Sachin Hingole (Inactive)
made changes -
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
Sachin Hingole (Inactive)
made changes -
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
Sachin Hingole (Inactive)
made changes -
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
Verified on production, working fine.
It shows correct cost on 1095C report.
Sachin Hingole (Inactive)
added a comment - Verified on production, working fine.
It shows correct cost on 1095C report. Sachin Hingole (Inactive)
made changes -
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
Sachin Hingole (Inactive)
made changes -
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Environment_New | Production [ 18442 ] |
| Transition | Time In Source Status | Execution Times |
|---|
Ramya Tantry (Inactive)
made transition
-
|
61d 3h 12m | 1 |
Ramya Tantry (Inactive)
made transition
-
|
41s | 1 |
Sachin Hingole (Inactive)
made transition
-
|
19d 22h 2m | 1 |
Sachin Hingole (Inactive)
made transition
-
|
6d 22h 31m | 1 |
Sachin Hingole (Inactive)
made transition
-
|
57m 1s | 1 |
Sachin Hingole (Inactive)
made transition
-
|
39s | 1 |
Please Update this ticket. this is completed