Uploaded image for project: 'Workterra BenAdmin'
  1. Workterra BenAdmin
  2. WB-370

ACA_2018_Mesquite Gaming - Virginia River

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Labels:
      None
    • Support Task Type:
      ACA IRS Report
    • Environment:
      Production
    • Company:
      Mesquite Gaming
    • Categories:
      ACA
    • Reported by:
      Client

      Description

      NA

        Attachments

          Issue Links

            Activity

            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Virginia River 1095C is ready to run. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Virginia River 1095C is ready to run. Thanks!
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers

            This group has been run.Please refer latest run dated "12/13/2017 11:32:06 PM" for verification.

            Observation: Measurement and stability rules are set and as timesheet data till 12th Nov,2017 is also present, so we are considering timesheet data for to determine whether employee is part time or full time. Please update the timesheet data for whole year of 2017.In case if timesheet data is not to be considered,please let us know.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers This group has been run.Please refer latest run dated "12/13/2017 11:32:06 PM" for verification. Observation : Measurement and stability rules are set and as timesheet data till 12th Nov,2017 is also present, so we are considering timesheet data for to determine whether employee is part time or full time. Please update the timesheet data for whole year of 2017.In case if timesheet data is not to be considered,please let us know.
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Changed to at least MEC offered to dependent(s); and at least MEC conditionally offered to spouse. Please re-run their forms. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Changed to at least MEC offered to dependent(s); and at least MEC conditionally offered to spouse. Please re-run their forms. Thanks!
            Hide
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

            Hi Jennifer Leugers

            We have run Virginia River 1095C report on Mesquite Gaming.
            Please refer run '1/2/2018 3:57:29 AM' to download.
            PFA QA verification list.
            Thanks!!

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Hi Jennifer Leugers We have run Virginia River 1095C report on Mesquite Gaming. Please refer run '1/2/2018 3:57:29 AM' to download. PFA QA verification list. Thanks!!
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - client has uploaded hours for December. Please re-run forms. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - client has uploaded hours for December. Please re-run forms. Thanks!
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Jennifer Leugers,

            To get stability in year 2017, we need to upload time sheets for year 2016.
            We observed that time sheet data is uploaded for Dec 2017.
            Please upload time sheet data as mentioned in previous comment.
            Adding previous comment by Ramya again.

            Looking at the time sheet data present there are some periods for which timesheet is missing. The periods are 04/18/2016 - 04/30/2016,08/22/2016 - 09/04/2016, 11/28/2016 - 12/25/2016.

            Thanks!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , To get stability in year 2017, we need to upload time sheets for year 2016. We observed that time sheet data is uploaded for Dec 2017. Please upload time sheet data as mentioned in previous comment. Adding previous comment by Ramya again. Looking at the time sheet data present there are some periods for which timesheet is missing. The periods are 04/18/2016 - 04/30/2016,08/22/2016 - 09/04/2016, 11/28/2016 - 12/25/2016. Thanks!
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - the client is stating that when an employee is moved from one EIN to the other, they are getting a new waiting period and should not as their benefits are continuous. Example is David Taylor who went from Casa Blanca to Virgin River (first three are 541 in case there are more than one).

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - the client is stating that when an employee is moved from one EIN to the other, they are getting a new waiting period and should not as their benefits are continuous. Example is David Taylor who went from Casa Blanca to Virgin River (first three are 541 in case there are more than one).
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            When an Employee moves from one EIN to another,his company is changed.So ideally he would be new hire.So waiting period is shown.
            However,this is not the case for every EIN change.
            If EE is not enrolled in any ACA medical plan,but just has offer,then he will get 1H/2D.
            If EE is enrolled in ACA medical plan,he will get 1A or 1E and 2C.
            For eg: BRADLEY DAVIS : Changed from Virginia river to Casa Blanca effective August and he was enrolled in ACA medical plan.
            His codes for Virginia River : Jan-Aug: 1A/2C and Sept-Dec: 1H/2A
            His codes for Casa Blanca : Jan-Aug:1H/2A and Sept-Nov : 1A/2C ,Dec : 1H/2A as he was terminated in Nov.

            ALEXIS THOMPSON : Changed from Virginia river to Casa Blanca effective March and she was not enrolled in ACA medical plan,but had offer.
            Her codes for Virginia River : Jan-March: 1H/2A,Apr-Jun:1H/2D and Jul-Dec: 1A/2F
            Her codes for Casa Blanca : Jan-March:1A/2F and Apr-Dec : 1H/2A

            Please change the codes if required through import or manually.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , When an Employee moves from one EIN to another,his company is changed.So ideally he would be new hire.So waiting period is shown. However,this is not the case for every EIN change. If EE is not enrolled in any ACA medical plan,but just has offer,then he will get 1H/2D. If EE is enrolled in ACA medical plan,he will get 1A or 1E and 2C. For eg: BRADLEY DAVIS : Changed from Virginia river to Casa Blanca effective August and he was enrolled in ACA medical plan. His codes for Virginia River : Jan-Aug: 1A/2C and Sept-Dec: 1H/2A His codes for Casa Blanca : Jan-Aug:1H/2A and Sept-Nov : 1A/2C ,Dec : 1H/2A as he was terminated in Nov. ALEXIS THOMPSON : Changed from Virginia river to Casa Blanca effective March and she was not enrolled in ACA medical plan,but had offer. Her codes for Virginia River : Jan-March: 1H/2A,Apr-Jun:1H/2D and Jul-Dec: 1A/2F Her codes for Casa Blanca : Jan-March:1A/2F and Apr-Dec : 1H/2A Please change the codes if required through import or manually.
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            All - what is driving the new waiting period? The client is saying there is not a waiting period when they move from one to the other. Please check the example of David Taylor (as mentioned in the above comment). When I kick off an event for 12.1.17 he is indeed showing has having a Medical offer yet we have him coded as 2D which isn't accurate for what the system is showing.

            Show
            jennifer.leugers Jennifer Leugers added a comment - All - what is driving the new waiting period? The client is saying there is not a waiting period when they move from one to the other. Please check the example of David Taylor (as mentioned in the above comment). When I kick off an event for 12.1.17 he is indeed showing has having a Medical offer yet we have him coded as 2D which isn't accurate for what the system is showing.
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            While system implementation, it was assumed that when EE's EIN is changed,he will be new hire in that company.
            We have added this scenario in our Learning(WT-12408) and will analyze on this more after ACA execution.

            For now,we have made changes in our code and bypassed the code providing waiting period for EE's whose EIN is changed.
            We have re-run all 3 reports. Please refer latest run for verification.

            Note: Eligibility rule on reports and EIN mapping have been changed. EE count are less in latest report run.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , While system implementation, it was assumed that when EE's EIN is changed,he will be new hire in that company. We have added this scenario in our Learning( WT-12408 ) and will analyze on this more after ACA execution. For now,we have made changes in our code and bypassed the code providing waiting period for EE's whose EIN is changed. We have re-run all 3 reports. Please refer latest run for verification. Note : Eligibility rule on reports and EIN mapping have been changed. EE count are less in latest report run.
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            HI all - the timesheets have been loaded, I removed the conditional offer on the customization and entered some code corrections from the UI. Please re-run these forms. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - HI all - the timesheets have been loaded, I removed the conditional offer on the customization and entered some code corrections from the UI. Please re-run these forms. Thanks!
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Hi Jennifer Leugers,

            We re-run "Virginia River 1095C" report from Mesquite Gaming from production. Please refer latest run (Run Date - 1/16/2018 11:01:24 AM) for reveiw

            NOTE - This run has 17 EE with 1K and 2B codes as these codes are added from "1095C correction forms" tab of "ACA Customization".

            Example EE are "ALEXIS ALVARADO" and "ROSEANNE VIDAURRI".

            Thanks,
            Sachin Hingole

            Nandkumar Prabhakar Karlekar Rakesh Roy Revansiddha Gaur Ramya Tantry Smita Pawar

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Hi Jennifer Leugers , We re-run "Virginia River 1095C" report from Mesquite Gaming from production. Please refer latest run (Run Date - 1/16/2018 11:01:24 AM) for reveiw NOTE - This run has 17 EE with 1K and 2B codes as these codes are added from "1095C correction forms" tab of "ACA Customization". Example EE are "ALEXIS ALVARADO" and "ROSEANNE VIDAURRI". Thanks, Sachin Hingole Nandkumar Prabhakar Karlekar Rakesh Roy Revansiddha Gaur Ramya Tantry Smita Pawar
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            I overrode other codes in the corrections sheet but as others were still showing as 1K, they aren't being modified even though we changed the conditional value? I looked at the run and there were only two EEs that had 1K which I've changed. Are the 17 across all EINs?

            Show
            jennifer.leugers Jennifer Leugers added a comment - I overrode other codes in the corrections sheet but as others were still showing as 1K, they aren't being modified even though we changed the conditional value? I looked at the run and there were only two EEs that had 1K which I've changed. Are the 17 across all EINs?
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - I changed all of the 1Ks. Could you please re-run the forms? Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - I changed all of the 1Ks. Could you please re-run the forms? Thanks!
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Hi Jennifer Leugers,

            Sorry for the confusion, there were 17 records for "ALEXIS ALVARADO" and "ROSEANNE VIDAURRI" employees showing 1K and not 17 Employee.

            We re-run "Virginia River 1095C" report, Please refer latest run (Run Date - 1/16/2018 11:40:47 AM) for reveiw

            Thanks,
            Sachin Hingole

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Hi Jennifer Leugers , Sorry for the confusion, there were 17 records for "ALEXIS ALVARADO" and "ROSEANNE VIDAURRI" employees showing 1K and not 17 Employee. We re-run "Virginia River 1095C" report, Please refer latest run (Run Date - 1/16/2018 11:40:47 AM) for reveiw Thanks, Sachin Hingole
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - could you please change the naming of this client on their 1094C form?  The same thing happened last year and the IRS rejects the file without the ampersand (I tried again this year but it again rejected for the EIN mismatch).  It's under Jira WT-8604.  Please run tonight so I can refile tomorrow.  Thanks!

             

             

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - could you please change the naming of this client on their 1094C form?  The same thing happened last year and the IRS rejects the file without the ampersand (I tried again this year but it again rejected for the EIN mismatch).  It's under Jira WT-8604 .  Please run tonight so I can refile tomorrow.  Thanks!    
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Revansiddha Gaur,

            Please change name from back end as we are unable to do same from UI due to validation message for special characters.

            as 'Name should contain only alphabetic characters.'

             

            Thanks,

            Smita

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Revansiddha Gaur , Please change name from back end as we are unable to do same from UI due to validation message for special characters. as 'Name should contain only alphabetic characters.'   Thanks, Smita
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Please verify we have done manual change for BusinessNameLine1Text  as 'C&HRV LLC'

            Thanks,

            Revan


            CC- Nandkumar Prabhakar Karlekar, Ramya Tantry

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Please verify we have done manual change for BusinessNameLine1Text  as 'C&HRV LLC' Thanks, Revan CC- Nandkumar Prabhakar Karlekar , Ramya Tantry
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have manually made changes in Virginia Xml file as per last year.
            Please download files from below mentioned path.
            Home >> Company Home >> ACA >> IRS Submission >> VIRGINIA IRS

            We have added same in our learnings 2018.

            Thanks!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , We have manually made changes in Virginia Xml file as per last year. Please download files from below mentioned path. Home >> Company Home >> ACA >> IRS Submission >> VIRGINIA IRS We have added same in our learnings 2018. Thanks!
            Hide
            jennifer.leugers Jennifer Leugers added a comment - - edited

            Hi all - the file still rejected by the IRS.  Could you take a look and see if you can figure out if there is any other issues?  The client is saying the name we filed it under last year is the same this year (and was successful last year).  The ticket form last year is in a prior comment but it is WT-8604.

            Show
            jennifer.leugers Jennifer Leugers added a comment - - edited Hi all - the file still rejected by the IRS.  Could you take a look and see if you can figure out if there is any other issues?  The client is saying the name we filed it under last year is the same this year (and was successful last year).  The ticket form last year is in a prior comment but it is WT-8604 .
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Jennifer Leugers,

            We have rerun the IRS submission for Mesquite gaming 'VIRGINIA IRS'.
            Similarly we have updated Receipt ID & Ack file of submission for submission which was created on 03/30/2018.

            In previous file, even though we have changed name 'C&HRV LLC' but we havn't changed the file size for file which was manually changed
            hence that submission got rejected. We have done all required changes in our latest submission file.

            Please download latest submission from below mentioned path and let us know the submission status.

            Path to download submission
            Home >> Company Home >> ACA >> IRS Submission >> VIRGINIA IRS

            Thanks!

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer Leugers , We have rerun the IRS submission for Mesquite gaming 'VIRGINIA IRS'. Similarly we have updated Receipt ID & Ack file of submission for submission which was created on 03/30/2018. In previous file, even though we have changed name 'C&HRV LLC' but we havn't changed the file size for file which was manually changed hence that submission got rejected. We have done all required changes in our latest submission file. Please download latest submission from below mentioned path and let us know the submission status. Path to download submission Home >> Company Home >> ACA >> IRS Submission >> VIRGINIA IRS Thanks!
            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Closing this ticket

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Closing this ticket

              People

              Assignee:
              jennifer.leugers Jennifer Leugers
              Reporter:
              smita.pawar Smita Pawar (Inactive)
              Account Executive:
              Kristi Smith (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 2h Original Estimate - 2h
                  2h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 15h 40m
                  15h 40m