-
Type:
Support Activity
-
Status: Closed
-
Priority:
Medium
-
Resolution: Done
-
Labels:None
-
Support Task Type:ACA IRS Report
-
Environment:Production
-
Company:Marquette
-
Categories:ACA
-
Reported by:Client
- clones
-
-
- Closed
-
Smita Pawar (Inactive)
created issue -
Smita Pawar (Inactive)
made changes -
Smita Pawar (Inactive)
made changes -
| Description | All companies are linked to this Jira which will get processed for IRS submission in year 2018 |
Smita Pawar (Inactive)
made changes -
| Company | All Clients/Multiple Clients [ 18434 ] | Marquette [ 10495 ] |
Smita Pawar (Inactive)
made changes -
| Account Executive | Deborah Mascot [ deborah.mascot@ebsbenefits.com ] |
Smita Pawar (Inactive)
made changes -
| Summary | ACA_2018_Marquette | ACA_2018_Marquette_- Gulf |
| Assignee | Jennifer Leugers [ jennifer.leugers ] | Smita Pawar [ smita.pawar ] |
Ramya Tantry (Inactive)
made changes -
| Assignee | Smita Pawar [ smita.pawar ] | Ramya Tantry [ ramya.tantry ] |
Ramya Tantry (Inactive)
made changes -
| Status | Open [ 1 ] | In Progress [ 3 ] |
Hi Jennifer Leugers,
This group has been run. Please refer latest run dated "12/5/2017 1:55:01 AM" for verification
Ramya Tantry (Inactive)
added a comment - Hi Jennifer Leugers ,
This group has been run. Please refer latest run dated "12/5/2017 1:55:01 AM" for verification Ramya Tantry (Inactive)
made changes -
| Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
Ramya Tantry (Inactive)
logged work - 05/Dec/17 12:03 PM -
- Time Spent:
- 0.5h
-
ACA Customization verification
Report run
Analysis report verification
Sample pdf verification
Ramya Tantry (Inactive)
made changes -
| Assignee | Ramya Tantry [ ramya.tantry ] | Jennifer Leugers [ jennifer.leugers ] |
Ramya Tantry (Inactive)
made changes -
| Remaining Estimate | 0h [ 0 ] | |
| Time Spent | 0.5h [ 1800 ] | |
| Worklog Id | 94729 [ 94729 ] |
Attaching all the corrections for Marquette - JIRA 12575 and 12577. Sending the password via email.
| Attachment | Marquette_1095C Corrections_Gulf1.xls [ 71048 ] |
| Attachment | Marquette_1095C Corrections_Gulf2.xls [ 71049 ] |
| Attachment | Marquette_1095C Corrections_Claims.xls [ 71050 ] |
| Attachment | Marquette_1095C Corrections_River.xls [ 71051 ] |
| Attachment | Marquette_1095C Corrections_Offshore.xls [ 71052 ] |
| Assignee | Jennifer Leugers [ jennifer.leugers ] | Smita Pawar [ smita.pawar ] |
| Assignee | Smita Pawar [ smita.pawar ] | Revansiddha Gaur [ revansiddha.gaur ] |
| Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
Hi Jennifer Leugers,
This is inprogress. We will update you tomorrow EOD.
Thanks,
Revan
CC- Nandkumar Prabhakar Karlekar, Smita Pawar
Smita Pawar (Inactive)
made changes -
| Time Spent | 0.5h [ 1800 ] | 40m [ 2400 ] |
| Worklog Id | 99389 [ 99389 ] |
All - need this done ASAP. I can't send the client only part of their EINs done.
| Attachment | Marquette_1095C Corrections_Gulf1_Part2.zip [ 71352 ] |
| Attachment | Marquette_1095C Corrections_Gulf2_Part2.zip [ 71353 ] |
| Attachment | Marquette_1095C Corrections_Claims_Part2.zip [ 71354 ] |
Hi Jennifer Leugers,
Please find the latest final report runs for all as per below..
| 1095 C Report Name | Report Run Time |
|---|---|
| 1095 C Marquette Transportation Co LLC- GULF | 1/5/2018 1:10:05 AM |
| 1095 C Marquette Transportation Co LLC- RIVER | 1/5/2018 1:15:04 AM |
| 1095 C Marquette Transportation Co LLC- OFFSHORE | 1/5/2018 1:19:42 AM |
We found the below employee's Line 14 code,Line 16 code as invalid. The employee record is present in the file of ''Marquette_1095C Corrections_Gulf1_Part2" but we imported by correcting the same in the file.
Wrong record:
4616XX795,03,2017,1H,100,2C,01,870790014
Corrected as:
4616XX795,03,2017,1E,100,2C,01,870790014
Please find the below files which are converted in csv format & updated to import the corrections in the system.
Marquette_1095C Corrections_Claims_Part2.zip
Marquette_1095C Corrections_Gulf2_Part2.zip
Marquette_1095C Corrections_Gulf1_Part2.zip
Password has been set as per our communicated password convention.
Thanks,
Revan
-----------------------------------------------------------------------------------------
CC- Ramya Tantry, Kumar Chhajed, Smita Pawar, Sachin Hingole, Nandkumar Prabhakar Karlekar, Gaurav Sodani
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Jennifer Leugers [ jennifer.leugers ] |
| Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
| Time Spent | 40m [ 2400 ] | 5h 10m [ 18600 ] |
| Worklog Id | 99490 [ 99490 ] |
-
- Time Spent:
- 4.5h
-
Import correction, report run.
Hi all - made additional changes from the UI; please re-run final forms. Thanks!
| Assignee | Jennifer Leugers [ jennifer.leugers ] | Revansiddha Gaur [ revansiddha.gaur ] |
Hi Jennifer Leugers,
This group has been run by applying user correciton. Please download latest run for the below report(s) for verification.
| Report Name | Run details | Remark |
|---|---|---|
| 1095 C Marquette Transportation Co LLC- GULF | 1/15/2018 1:38:08 PM | - |
Thanks,
Revan
-----------------------------------------------------------------------------------------
CC- Ramya Tantry, Kumar Chhajed, Smita Pawar, Sachin Hingole, Nandkumar Prabhakar Karlekar, Gaurav Sodani
| Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Jennifer Leugers [ jennifer.leugers ] |
| Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
-
- Time Spent:
- 1h
-
Report run,verification,eligibility run.
| Time Spent | 5h 10m [ 18600 ] | 6h 10m [ 22200 ] |
| Worklog Id | 100646 [ 100646 ] |
Did corrections through the UI; please re-run. Thanks!
| Assignee | Jennifer Leugers [ jennifer.leugers ] | Revansiddha Gaur [ revansiddha.gaur ] |
Ramya Tantry (Inactive)
made changes -
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Smita Pawar [ smita.pawar ] |
Hi Jennifer Leugers,
We have rerun '1095 C Marquette Transportation Co LLC- GULF'report.
Please refer latest run '1/23/2018 10:23:48 PM' to download.
Observation: MEC indicator is marked as 'NO' for Jan to Nov 2017.
Thanks!
Smita Pawar (Inactive)
added a comment - - edited Hi Jennifer Leugers ,
We have rerun '1095 C Marquette Transportation Co LLC- GULF'report.
Please refer latest run '1/23/2018 10:23:48 PM' to download.
Observation: MEC indicator is marked as 'NO' for Jan to Nov 2017.
Thanks! Smita Pawar (Inactive)
made changes -
| Assignee | Smita Pawar [ smita.pawar ] | Jennifer Leugers [ jennifer.leugers ] |
Hi all - I've done the attached corrections through the import and manually and when the forms are run, they default back to the codes prior to (example is the first one listed on the attached River file. Could you please upload both the River and Gulf files, re-run these two EINs and verify the changes are showing? Thanks!
| Attachment | Corrections.zip [ 72409 ] |
| Assignee | Jennifer Leugers [ jennifer.leugers ] | Smita Pawar [ smita.pawar ] |
| Assignee | Smita Pawar [ smita.pawar ] | Revansiddha Gaur [ revansiddha.gaur ] |
| Status | Waiting for Customer Input [ 10500 ] | In Progress [ 3 ] |
| Attachment | Bad_ACA 1095C Correction Import- LONG201_25_2018 03_42_40 AM.zip [ 72448 ] |
| Attachment | VerificationDetails_Gulf_Correction.zip [ 72449 ] |
Hi Jennifer Leugers,
We have found issue with only for River. Please let us know if any feedback on Gulf EIN 1095 C Report below run which we have attached verification details meanwhile of solving the issue for River.
| Report Name | Run details |
|---|---|
| 1095 C Marquette Transportation Co LLC- GULF | 1/28/2018 12:57:37 AM |
Verification Details for GULF: VerificationDetails_Gulf_Correction.zip
Observation on Analysis Report:
1. Codes are valid
2. A.Qualifying Offer Method=No, D.98% Offer Method=No
3. MECIndicator=No for all 12 months.
---------------------------------------------------------------------------------------------
| Report Name | Run details |
|---|---|
| 1095 C Marquette Transportation Co LLC- RIVER | 1/28/2018 2:03:28 AM |
Verification Details For River:
As per expected attache correction sheet,codes are not reflecting rather showing 1G codes even though the correction import successfully & run by "Apply User Correction=Yes". So we are looking into this and we will let you know on tomorrow EOD.
Observation on Analysis Report:
1. Codes are valid
2. A.Qualifying Offer Method=No, D.98% Offer Method=No
3. MECIndicator=Yes for all 12 months.
Password is based on standard convention.
Thanks,
Revan
CC- Satya, Nandkumar Prabhakar Karlekar, Ramya Tantry, Smita Pawar, Sachin Hingole, Gaurav Sodani,Samir
-
- Time Spent:
- 1.5h
-
Import corrections for Gulf & River EIN,100% verification for imported employee correction & feedback for the same,Discussion with team member for correction are not reflecting even though imported properly for river ein, draft reply.
| Time Spent | 6h 10m [ 22200 ] | 7h 40m [ 27600 ] |
| Worklog Id | 102198 [ 102198 ] |
Ramya Tantry (Inactive)
made changes -
| Time Spent | 7h 40m [ 27600 ] | 9h 10m [ 33000 ] |
| Worklog Id | 102268 [ 102268 ] |
Hi Jennifer Leugers,
This group has been re-run by applying correction. Please find the below run details for verification.
| Report Name | Run details | Remark |
|---|---|---|
| 1095 C Marquette Transportation Co LLC- RIVER | 1/28/2018 8:47:40 PM | EE count is reduced by 1 i.e. 1279 from 1280. The reason is explained below |
These employees were cobra employees and were enrolled in Cobra ACA plan since 2016.So these employees defaulted back to 1G even after code correction as priority for code 1G is higher.We have changed this and re-run the River report.Now employee is getting 1H/2B for whole month instead of 1G.Please refer latest run for verification.As one of the employees was corrected to code 1H/2A for all 12 months,he got deleted in latest run.We do not furnish form for employee whose codes are 1H/2A for all 12 months as it depicts that the employee was not with the company for whole year.
Thanks,
Revan
CC- Ramya Tantry,Smita Pawar, Sachin Hingole, Satya, Nandkumar Prabhakar Karlekar, Samir, Gaurav Sodani
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Jennifer Leugers [ jennifer.leugers ] |
| Status | In Progress [ 3 ] | Waiting for Customer Input [ 10500 ] |
-
- Time Spent:
- 1.5h
-
Draft reply, internal discussion on issue.
| Time Spent | 9h 10m [ 33000 ] | 10h 40m [ 38400 ] |
| Worklog Id | 102768 [ 102768 ] |
| Status | Waiting for Customer Input [ 10500 ] | Open [ 1 ] |
| Status | Open [ 1 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Waiting for Input [ 11502 ] |
| Workflow | WB - Workterra BenAdmin Support workflow [ 65464 ] | 0803 Copy of WB - Workterra BenAdmin Support workflow [ 65816 ] |
Closing this ticket
| Resolution | Done [ 10000 ] | |
| Status | Waiting for Input [ 11502 ] | Closed [ 6 ] |
| Transition | Time In Source Status | Execution Times |
|---|
Ramya Tantry (Inactive)
made transition
-
|
4d 1h 38m | 1 |
|
50d 20h 35m | 3 |
|
4d 5h 40m | 4 |
|
35d 18h 53m | 1 |
|
2m 27s | 1 |
|
1m 59s | 1 |
|
48d 22h 13m | 1 |
Ok to run 1095 C Marquette Transportation Co LLC- GULF. Thanks!