Concern -
Difficulty in deleting HSPL related files .
Suggestion -
We must create a separate folder structure for files of HSPL companies when we run any report on HSPL companies.
Benefits -
This will help us to scrub/delete all the HSPL related files in one go.

CC Ramya Tantry

Concern -
Unable to identify downloaded Analysis Report is of which company as the file name is same for each company and also the excel sheet do no contain any company name inside it.
Suggestion -
We must Include the Company name in file name itself or inside the Excel sheet.
Benefits -
This will help us to identify the correct analysis report for each company if have multiple companies reports.

CC Ramya Tantry

Concern -
Increase PDF service licenses.
Suggestion -
There should be at-least 4 PDF service licenses on production and at-least 2 licenses on local. This would increase the performance of PDF's writing.
Benefits -
The 1095C will be processed more efficiently.

CC Nandkumar Prabhakar Karlekar Ramya Tantry

Concern -
Processing Eligibility data for all employees.
Suggestions -
We should run eligibility data as per the Eligibility Rule selected on the report (for that year and plans selected)
Benefits -
This will help us to increase performance of generating 1095C PDF files with eligibility processing.

CC Ramya Tantry

Concern -
When we get any invalid codes after generation 1095C, what we check is there any stability/measurement rules present & if so timesheet data is present.In such scenario time sheet data is incomplete or stability period year start is falling in mid of 1095 C's 'from and to date' period on 1095 c codes will reflect as 1h/2c. To resolve this generally we truncate the table of
"ACAEmployeeData" & rerun the 1095c report which will generate a 1095C report without referring timesheet data.

Suggestitons -
We should provide the option before generating the 1095C report to select that whether should generate a report using timesheet data or without referring a timesheet data.

Benefits -

• Prevents client data access
• Client can also take decision to run 1095c Report without developers help.
• Can able to take inputs to run 1095 C report based on client selected option of with referring timesheet or without timesheet ,which help unnecessary resource utilization if this case is on Cloud base access
• Can take firmly decision because client has given the option exact on which basis report is going to be generated & if any discrepancy found can rectify earlier.

Note: Suggestion came into mind while processing 1095C report for CVHP company.
CC- Nandkumar Prabhakar Karlekar, Ramya Tantry

Concern: If PDF template is not present of future year,server error is thrown
Suggestion: First verify if the template of the year(select year from from date) is present.If not, provide with popup saying template is not present,so report cannot be processed else process with the report.

Concern: Multiple rows of an employee is seen in Analysis report.
Suggestion: Analyze the scenario where two records are coming and resolve.

Concern - Unable to update Line 15 cost on 1095C for particular set of employees with a particular plan
Suggestion - We can add an drop down for selecting plan on ACA 1095C Class Wise Configuration screen, which can help us to achieve this.

This issue occurred on companies like Town of Carry ( WT-12493 ), El Camino Hospital ( WT-12485 ) etc.

Concern: Consolidated for 1095B cannot be generated from system
Suggestion: All the enhancements of correction, download that have been done for 1095C should be done for 1095B

Concern: Should an EE whose EIN is changed be considered as new hire in new EIN
Company: Mesquite Gaming (WT-12521)

CONCERN: is there anyway you can tell me when it was changed to show conditional value and by whom?
Company: FRMC (WT-12408)

CONCERN: ACA 1095C Comparison report takes too much time to show the report & even taking too much time it shows blank report.
Company: WT-12519 ACA_2018_Mesquite Gaming - Casa Blanca

CONCERN: Employee is enrolled in self insured plans for part of the year but user can able to show dependents as self insured in all 12 months by importing the part 3 correction instead of actually he was enrolled for self insured months only which is incorrect. Such business rule violation can cause an error after submitting transmission files on IRS portal which we can get it know by irs reporting an acknowledgement error & again we need to submit 'CORRECTION' submission by correcting the business violation rule.

Resolution: We need to show such discrepancy also in our Analysis Report which will help us to reduce the generation of correction transmission files for IRS Submission.

Company: WT-12548

Suggestion: Customization History need to be maintained to track the changes.
Company: WT-12567

Concern: Employee is getting 1Geven after applying correction as update of 1G is after the updation of correction data.
Correction: Move the updation of 1G before the correction data as correction data will have highest priority over all.

Company: Marquette : WT-12489

Concern: ACA Analytics - Employee Audit
Suggestion: Revisit logic of this page and re-factor

Concern: Analysis report shows Employee status as part time when he is not employed
Suggestion: To make analysis report more effective in terms of showing information,we think that if an employee is getting 1H/2A code,we would show his employee status as "Not employed", instead of part time/full time. Means if an employee is termed in Sept,then after Sept month,his eligibility stays would show "Not employed" instead of part time.

Concern: 2B is coded for employees who are terminated and do not have offers.
Suggestion: use another flag say "IsPlanEmployeeEligible" to verify if offer is there for employee for that month.Use this flag in 2B case.
*Company *: University Health WT-12945

CONCERN: Import failed error message while importing the election.
CAUSE: Due to absent a value for Generic Eligibility rule column in PlanDesign table for the imported benefit plans.
Company: WT-12533

Concern: For 2B : it doesn't say they have to be part time and offered coverage. It says "if offered for the month". It doesn't say they have to have the offer. For those who are part time for part of the year and go to full time, we are using a 1H on line 14 and a blank on line 16. So we are telling the IRS that the employee didn't have an offer of coverage but we aren't telling them why (the blank on line 16)
Suggestion: Do not check employee eligible condition for part time case
Company: Irvine: WT-12501

Concern: We are having a temporary table "#IRS1095CLineNO15DATA" which contains minimum cost month-wise.We use this table in Left join for final code processing.So other plans whose costs are different are getting assigned with this cost for that month and codes are processed.
For eg: Employee is eligible for Plan1( is minimum value) whose cost is $150 and Plan2(not minimum value) whose cost is $90 for whole year
Table "IRS1095CLineNO15DATA" contains $90 for whole year.This table gets joined with other table for code processing and Plan1 gets assigned with cost $90. So if codes expected is 1E(Plan1 with $150),1A(Plan1 with $90) would come.

Company: SBM WT-12491

Concern: If employee is termed on 1st day of the month,then 2B is displayed for that month
Suggestion: In "[OES_SP_Get_ACAEmployeeStatusInfoMonthly]" SP, consider status change date-1 if status change date is 1st day of month.But in this case,terminated in month flag shows for previous month.

*Company *: Town of Cary WT-12493 and Je Dunn WT-12488

Concern: If process eligibility is done at 5 days interval, there may happen a scenario where terminated employee gets 1A/1E and 2B in terminated month.
For eg : Employee is termed on 05/27/2017 and process eligibility puts term date to plans as 06/01/2017,then it seems that plan is available for whole month of May(1A/1E) and 2B as employee termed.
Suggestion: Make eligibility run everyday instead of 5 days interval.

CONCERN: While election import giving an error as 'Import Failed'.

CAUSE: On 'Benefit Plans' import , generic eligibility rule is found as null in plan design table.

Suggestion: By default should save generic eligibility rule id of 'All Status Rule' whenever benefit plans import.

Company: WT-12533

Concern: Analysis report does not render for reports with large number of employees.
Suggestion: Fork a task when data process is completed to download analysis report in excel.This excel file will be on created on file server and will be downloaded when clicked on download.No different rendering on SSRS report.
Benefits: Report will be available directly in excel format and SSRS rendering time will be saved.
Company: WT-12574 - Elite Staffing

Concern: Is there anyway to get Analysis report and have it show the class they were in the month not as of today?
Company: Je dunn WT-12488

CONCERN:
1. After Importing part3 correction and If part 3 correction import file having multiple child records, not finding the records in a table but shows popup message all records are imported successfully.

2. If corrections are made from ui for part3 - all 12 months checked & later on trying to import the same import giving 'Import failed' error.

Company: WT-12513

Concern: Cobra enrollments that were imported but employees having codes as 1H/2A need to be furnished
Company: Je dunn - WT-12488

Concern: In case if client want to un-mark part III values,system doesn't un-mark it as it considers combination of system generated and correction.
Company: JEDUNN - WT-12488
TOC

Concern: Employees missing in Consolidated report.
Company: Karma and HPB
WB-325

Hi Prashant Samal,

Please close this Jira.

closing per above