-
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
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 Nandkumar Prabhakar Karlekar Is this open?
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 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. 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. 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. 
Please Update this ticket. this is completed