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

ACA_2018_Mesquite Gaming - Casa Blanca

    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

            smita.pawar Smita Pawar (Inactive) created issue -
            smita.pawar Smita Pawar (Inactive) made changes -
            Field Original Value New Value
            Link This issue clones WT-12484 [ WT-12484 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Company All Clients/Multiple Clients [ 18434 ] Mesquite Gaming [ 10605 ]
            smita.pawar 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 Smita Pawar (Inactive) made changes -
            Account Executive Kristi Smith [ kristi.smith ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Casa Blanca 1095C is ready to run. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Casa Blanca 1095C is ready to run. Thanks!
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Smita Pawar [ smita.pawar ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Ramya Tantry [ ramya.tantry ]
            Status Open [ 1 ] In Progress [ 3 ]
            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:20:32 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.I n 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:20:32 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.I n case if timesheet data is not to be considered,please let us know.
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Open [ 1 ] Waiting for Customer Input [ 10500 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 14/Dec/17 08:59 AM
            • Time Spent:
              0.5h
               

              ACA Customization verification
              Measurement and Stability verification
              Time sheet verification
              1095C report run
              Analysis report verification
              sample 1095C report verification
              draft reply

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 0.5h [ 1800 ]
            Worklog Id 96080 [ 96080 ]
            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!
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
            Hide
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment -

            Hi Jennifer Leugers

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

            Show
            sanjana.jadhav Sanjana Jadhav (Inactive) added a comment - Hi Jennifer Leugers We have run Casa Blanca 1095C report on Mesquite Gaming. Please refer run '1/2/2018 1:40:29 AM' to download. PFA QA verification list. Thanks!!
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment ACA_2018_Mesquite Gaming - Casa Blanca.ods [ 71082 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Attachment ACA_2018_Mesquite Gaming - Casa Blanca.ods [ 71082 ]
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            sanjana.jadhav Sanjana Jadhav (Inactive) logged work - 03/Jan/18 04:11 AM
            • Time Spent:
              1h
               
              • Testing
              • Internal discussion
              • Jira update
            sanjana.jadhav Sanjana Jadhav (Inactive) made changes -
            Time Spent 0.5h [ 1800 ] 1.5h [ 5400 ]
            Worklog Id 99119 [ 99119 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi all - Mesquite has some questions on their overall groups (there are three EINs). The first person they are questioning is Ana Abarca and I cannot understand her codes per the history of this employee. Also, they are saying that their reason for not sending the time and attendance for December 2017 is because their part time and Extra Board members measurement for eligibility is based on the hours in 2016 so the 2017 hours shouldn’t be affecting any of the reporting. She thinks we are very wrong and need to make sure the coding is looking at last year’s hours (2016) instead of 2017.

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi all - Mesquite has some questions on their overall groups (there are three EINs). The first person they are questioning is Ana Abarca and I cannot understand her codes per the history of this employee. Also, they are saying that their reason for not sending the time and attendance for December 2017 is because their part time and Extra Board members measurement for eligibility is based on the hours in 2016 so the 2017 hours shouldn’t be affecting any of the reporting. She thinks we are very wrong and need to make sure the coding is looking at last year’s hours (2016) instead of 2017.
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Sanjana Jadhav [ sanjana.jadhav ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Also - there are some employees that have multiple lines (example Josue Barraza with Casa Blanca is showing two lines for October & November).

            Show
            jennifer.leugers Jennifer Leugers added a comment - Also - there are some employees that have multiple lines (example Josue Barraza with Casa Blanca is showing two lines for October & November).
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Sanjana Jadhav [ sanjana.jadhav ] Ramya Tantry [ ramya.tantry ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            Please find my analysis of the employee Ana Abarca:
            This Employee's EIN is changed due to class change.So She will have two 1095C's.One from Virgin River and other from Casa Blanca.
            Virgin river 1095C :
            She was hired in December,2016.So she was in limited assessment period in Jan,2017 month.Her Class 2 was Virgin River when she was hired and she was not eligible for any plan till April.
            Hence 1H was displayed for the month of Feb and March.She had offer from April and so appropriate codes got displayed.
            She was not present in this EIN for later months hence 1H-2A is displayed.
            Casa Blanca 1095C :
            Employee was not in this EIN till March.Hence 1H-2A is displayed.From April to Oct,This employee got codes as per system data and in Oct she was terminated.Hence for later months,1H-2A is displayed.

            In-case if you feel that these codes need to be corrected,it can be done through code correction.Codes as per the EIN need to be imported or manually corrected.Changes will be reflected in next run.

            TimeSheet data:
            The observation in my earlier comment was just initial analysis of measurement and stability rules and timesheet present in the system. We require 2016 hours data for 2017 stability period.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.
            Please load the timesheets of periods mentioned.

            Employees with Multiple lines : This does occur for some of the employees,but this does not affect any codes nor it is updated anywhere in the system. Even if two records are shown their codes are same.This comes only in analysis report.1095C Reports are not affected by this.
            We have added this in our learning(WT-12408) and will analyze it further after the execution.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , Please find my analysis of the employee Ana Abarca : This Employee's EIN is changed due to class change.So She will have two 1095C's.One from Virgin River and other from Casa Blanca. Virgin river 1095C : She was hired in December,2016.So she was in limited assessment period in Jan,2017 month.Her Class 2 was Virgin River when she was hired and she was not eligible for any plan till April. Hence 1H was displayed for the month of Feb and March.She had offer from April and so appropriate codes got displayed. She was not present in this EIN for later months hence 1H-2A is displayed. Casa Blanca 1095C : Employee was not in this EIN till March.Hence 1H-2A is displayed.From April to Oct,This employee got codes as per system data and in Oct she was terminated.Hence for later months,1H-2A is displayed. In-case if you feel that these codes need to be corrected,it can be done through code correction.Codes as per the EIN need to be imported or manually corrected.Changes will be reflected in next run. TimeSheet data: The observation in my earlier comment was just initial analysis of measurement and stability rules and timesheet present in the system. We require 2016 hours data for 2017 stability period.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. Please load the timesheets of periods mentioned. Employees with Multiple lines : This does occur for some of the employees,but this does not affect any codes nor it is updated anywhere in the system . Even if two records are shown their codes are same.This comes only in analysis report.1095C Reports are not affected by this. We have added this in our learning( WT-12408 ) and will analyze it further after the execution.
            ramya.tantry Ramya Tantry (Inactive) logged work - 04/Jan/18 07:49 AM
            • Time Spent:
              2h
               

              Analysis
              Draft reply

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status In Progress [ 3 ] Open [ 1 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Open [ 1 ] Waiting for Customer Input [ 10500 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 1.5h [ 5400 ] 3.5h [ 12600 ]
            Worklog Id 99289 [ 99289 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            For Ana Abarca, why are we showing a 1H / blank for February and March? Shouldn't it be 1H/2D?

            Show
            jennifer.leugers Jennifer Leugers added a comment - For Ana Abarca, why are we showing a 1H / blank for February and March? Shouldn't it be 1H/2D?
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 05/Jan/18 08:40 AM
            • Time Spent:
              0.75h
               

              Discussion and analysis
              Draft reply

            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Jennifer Leugers,

            Ana Abarca was employed on 12/01/2016. As per the New hire rules set on the company,she was eligible to enroll for benefits effective 02/01/2017.But she was not eligible to any medical plans in Feb and March month. So 1H is populated which depicts that there is no offer.
            She was in limited Assessment period till Jan,2017.Hence 1H/2D is shown only for Jan Month.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Jennifer Leugers , Ana Abarca was employed on 12/01/2016. As per the New hire rules set on the company,she was eligible to enroll for benefits effective 02/01/2017.But she was not eligible to any medical plans in Feb and March month. So 1H is populated which depicts that there is no offer. She was in limited Assessment period till Jan,2017.Hence 1H/2D is shown only for Jan Month.
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 3.5h [ 12600 ] 4.25h [ 15300 ]
            Worklog Id 99418 [ 99418 ]
            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!
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Ramya Tantry [ ramya.tantry ]
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            Hi Jennifer Leugers,

            To get stability in year 2017, we need to upload time sheets for year 2016.
            We observed time sheet data is uploaded for Dec 2017 in the system.
            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 - - edited Hi Jennifer Leugers , To get stability in year 2017, we need to upload time sheets for year 2016. We observed time sheet data is uploaded for Dec 2017 in the system. 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!
            smita.pawar Smita Pawar (Inactive) logged work - 11/Jan/18 01:20 PM
            • Time Spent:
              20m
               

              Internal discussion
              Jira updates
              Draft

            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 4.25h [ 15300 ] 4h 35m [ 16500 ]
            Worklog Id 100091 [ 100091 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Jennifer Leugers [ jennifer.leugers ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 11/Jan/18 04:08 PM
            • Time Spent:
              0.5h
               

              Analysis on timesheet and discussion with Smita

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 4h 35m [ 16500 ] 5h 5m [ 18300 ]
            Worklog Id 100138 [ 100138 ]
            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!
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Revansiddha Gaur [ revansiddha.gaur ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited

            Hi Jennifer Leugers,

            This group has been run by applying user correction. Please download latest run as per below reports for verification.

            Report Name Run details Remark
            Casa Blanca 1095C 1/16/2018 10:43:44 AM In this run, two employees are less(MARIA E. DELGADO HERMOSILLO,MARIA F ROMERO) by comparison with run date 1/16/2018 1:04:12 AM
            CAROL WHITEHURST- This employee's codes are reflected as 1K and 2B for 9 months. Please do the corrections.

            Thanks,
            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited Hi Jennifer Leugers , This group has been run by applying user correction. Please download latest run as per below reports for verification. Report Name Run details Remark Casa Blanca 1095C 1/16/2018 10:43:44 AM In this run, two employees are less(MARIA E. DELGADO HERMOSILLO,MARIA F ROMERO) by comparison with run date 1/16/2018 1:04:12 AM CAROL WHITEHURST- This employee's codes are reflected as 1K and 2B for 9 months. Please do the corrections. Thanks, Revan
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Jennifer Leugers [ jennifer.leugers ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 5h 5m [ 18300 ] 6h 5m [ 21900 ]
            Worklog Id 100632 [ 100632 ]
            Hide
            jennifer.leugers Jennifer Leugers added a comment -

            Hi there - I corrected Whitehurst. Please re-run. Thanks!

            Show
            jennifer.leugers Jennifer Leugers added a comment - Hi there - I corrected Whitehurst. Please re-run. Thanks!
            jennifer.leugers Jennifer Leugers made changes -
            Assignee Jennifer Leugers [ jennifer.leugers ] Revansiddha Gaur [ revansiddha.gaur ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Jennifer Leugers,

            This group has been run by applying user correction. Please download latest run as per below reports for verification.

            Report Name Run details Remark
            Casa Blanca 1095C 1/16/2018 11:42:56 AM Now there is no one records of code as 1K & 2B but two employees are not found (MARIA E. DELGADO HERMOSILLO,MARIA F ROMERO) by comparison with previous run date 1/16/2018 1:04:12 AM

            Thanks,
            Revan

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Jennifer Leugers , This group has been run by applying user correction. Please download latest run as per below reports for verification. Report Name Run details Remark Casa Blanca 1095C 1/16/2018 11:42:56 AM Now there is no one records of code as 1K & 2B but two employees are not found (MARIA E. DELGADO HERMOSILLO,MARIA F ROMERO) by comparison with previous run date 1/16/2018 1:04:12 AM Thanks, Revan
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 6h 5m [ 21900 ] 6h 35m [ 23700 ]
            Worklog Id 100634 [ 100634 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 16/Jan/18 10:00 PM
            • Time Spent:
              1h
               

              Report run & verification.

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 16/Jan/18 10:00 PM
            • Time Spent:
              0.5h
               

              Report re-run & verification.

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Jennifer Leugers [ jennifer.leugers ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Component/s ACA [ 10004 ]
            Description NA
            Key WT-12519 WB-62
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Support [ 59192 ] WB - Workterra BenAdmin Support workflow [ 64856 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Key WB-62 WT-13541
            Project Workterra BenAdmin [ 11501 ] WORKTERRA [ 10000 ]
            Workflow WB - Workterra BenAdmin Support workflow [ 64856 ] WT_Support [ 65293 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Status Waiting for Customer Input [ 10500 ] Open [ 1 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Categories Parent values: ACA(18524)
            Key WT-13541 WB-374
            Project WORKTERRA [ 10000 ] Workterra BenAdmin [ 11501 ]
            Workflow WT_Support [ 65293 ] WB - Workterra BenAdmin Support workflow [ 65417 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Status In Development [ 10007 ] Waiting for Input [ 11502 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Workflow WB - Workterra BenAdmin Support workflow [ 65417 ] 0803 Copy of WB - Workterra BenAdmin Support workflow [ 66024 ]
            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Closing this ticket

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Closing this ticket
            Prashant.samal Prashant Samal (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Waiting for Input [ 11502 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Ramya Tantry (Inactive) made transition -
            Open In Progress
            12d 20h 46m 1
            Ramya Tantry (Inactive) made transition -
            In Progress Open
            4h 9m 2
            Ramya Tantry (Inactive) made transition -
            Open Waiting for Customer Input
            44s 2
            Revansiddha Gaur (Inactive) made transition -
            Waiting for Customer Input In Progress
            33d 7h 51m 3
            Ramya Tantry (Inactive) made transition -
            In Progress Waiting for Customer Input
            8h 52m 2
            Prashant Samal (Inactive) made transition -
            Waiting for Customer Input Open
            48d 3h 15m 1
            Prashant Samal (Inactive) made transition -
            Open In Development
            2m 27s 1
            Prashant Samal (Inactive) made transition -
            In Development Waiting for Input
            1m 59s 1
            Prashant Samal (Inactive) made transition -
            Waiting for Input Closed
            48d 22h 13m 1

              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 - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 6h 35m
                  6h 35m