-
Type:
Bug
-
Status: Closed
-
Priority:
High
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: ACA
-
Labels:None
-
Environment:QA
-
Module:ACA - 2017
-
Reported by:Harbinger
-
Item State:Production Complete - Closed
1.Login to LB with Partner.
2.Edit company say "ACAautomation".
3.Navigate to Home << Company Home << BenAdmin Home << BenAdmin Company Home << ACA << IRS Report
4.Run already existing report "1095-C code J"
5.Down load Data analysis report and Check 'ACA 1095-C report analytics' tab.
Actual: MEC data based on this run displaying no data
Expected: Data should get reflected on the file
- relates to
-
WT-5809 ACA 2017 : New changes for Tax year 2016.
-
- Closed
-
Concern: ACA_ACA1095-C Analytics report_[MEC Indicator based on this run]Data is not displaying on the report.
Cause: MEC indicator is yes/no based on if ALE Member offered minimum essential coverage to at least 95% of its full-time employees and their dependents. i.e we have checked codes for 1A,1E,1C. But the 1095C report has only 2 employee with 1J/1H codes.
So the temp table come up with null values and Null values are not shown on report.
Correction: Made changes to reflect '-' if Null is present.
Ramya Tantry (Inactive)
added a comment - Concern : ACA_ACA1095-C Analytics report_ [MEC Indicator based on this run] Data is not displaying on the report.
Cause : MEC indicator is yes/no based on if ALE Member offered minimum essential coverage to at least 95% of its full-time employees and their dependents. i.e we have checked codes for 1A,1E,1C. But the 1095C report has only 2 employee with 1J/1H codes.
So the temp table come up with null values and Null values are not shown on report.
Correction : Made changes to reflect '-' if Null is present. Issue 2: Similarly addition of percentages on [MEC Indicator based on this run] is greater than 100.
Same steps to repro
Smita Pawar (Inactive)
added a comment - Issue 2: Similarly addition of percentages on [MEC Indicator based on this run] is greater than 100.
Same steps to repro
For Issue 2:
Distinct Employee was getting considered for calculation of percentage,so the percentage addition was going above 100.
This issue has been resolved and already deployed on LB and Stage.
Ramya Tantry (Inactive)
added a comment - For Issue 2:
Distinct Employee was getting considered for calculation of percentage,so the percentage addition was going above 100.
This issue has been resolved and already deployed on LB and Stage. We have verified above mentioned issue on LB company [ACA Automation].
It working fine.
Tested other scenarios are as follows.
1. Changed label as "No. of records with this Combination" in ACA 1095C Employee Count.
2. Checked whether Percentage is less than 100 for ACA 1095C Code Analysis.
3. Total number of New Hire employees in Run.
4.Checked whether offer methods are displaying correctly on Report or not.
5.Points verified in "MEC Indicator based on this run".
a.Checked whether Month names are getting displayed correctly or not.
b.Not any column is blank or with '-'
Note: Attached Screen shot for additional information
Smita Pawar (Inactive)
added a comment - - edited We have verified above mentioned issue on LB company [ACA Automation] .
It working fine.
Tested other scenarios are as follows.
1. Changed label as "No. of records with this Combination" in ACA 1095C Employee Count.
2. Checked whether Percentage is less than 100 for ACA 1095C Code Analysis.
3. Total number of New Hire employees in Run.
4.Checked whether offer methods are displaying correctly on Report or not.
5.Points verified in "MEC Indicator based on this run".
a.Checked whether Month names are getting displayed correctly or not.
b.Not any column is blank or with '-'
Note: Attached Screen shot for additional information We have verified above mentioned issue on Stage company [ACA Automation].
It working fine.
Tested other scenarios are as follows.
1. Changed label as "No. of records with this Combination" in ACA 1095C Employee Count.
2. Checked whether Percentage is less than 100 for ACA 1095C Code Analysis.
3. Total number of New Hire employees in Run.
4.Checked whether offer methods are displaying correctly on Report or not.
5.Points verified in "MEC Indicator based on this run".
a.Checked whether Month names are getting displayed correctly or not.
b.Not any column is blank or with '-'
Note: Attached Screen shot for additional information
Smita Pawar (Inactive)
added a comment -
We have verified above mentioned issue on Stage company [ACA Automation] .
It working fine.
Tested other scenarios are as follows.
1. Changed label as "No. of records with this Combination" in ACA 1095C Employee Count.
2. Checked whether Percentage is less than 100 for ACA 1095C Code Analysis.
3. Total number of New Hire employees in Run.
4.Checked whether offer methods are displaying correctly on Report or not.
5.Points verified in "MEC Indicator based on this run".
a.Checked whether Month names are getting displayed correctly or not.
b.Not any column is blank or with '-'
Note: Attached Screen shot for additional information We have verified above mentioned issue on Production [For ACA BSGTest ACAAutomation HSPL].
It working fine
Attaching screen shot for additional information.
Smita Pawar (Inactive)
added a comment - We have verified above mentioned issue on Production [For ACA BSGTest ACAAutomation HSPL] .
It working fine
Attaching screen shot for additional information. This issue is fixed.
Smita Pawar (Inactive)
added a comment - This issue is fixed. 
Files Affected:
MasterCompanyDB/04_Stored Procedures/OES_SP_Get_1095CollectiveData.sql