Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-3339

Mesquite Gaming - ACA hours load

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      Data Load
    • Reported by:
      Support
    • Company:
      Mesquite Gaming
    • Module:
      BenAdmin

      Description

      I don't see a ticket open for this. We get ACA hour files from the client. has the templates been setup and tested already? I have saved all the files we have received to date on the Y drive here: Y:\1.CLIENT\Mesquite Gaming\5. EDI\ACA hours

      please let me know if we can get these loaded in to bring current and what you need from the AE team to get them on process load process.

        Attachments

          Activity

          Hide
          Cindy.Wibbing Cindy Wibbing (Inactive) added a comment -

          Hi Nathaniel,
          Let's go over this.
          Thanks!

          Show
          Cindy.Wibbing Cindy Wibbing (Inactive) added a comment - Hi Nathaniel, Let's go over this. Thanks!
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Nathaniel Cornejo-Walker
          Can you update Jira for all the loads you did in Stage?

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Nathaniel Cornejo-Walker Can you update Jira for all the loads you did in Stage?
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          All hours are update in Production. Kick outs are in Bad file.
          Y:\1.CLIENT\Mesquite Gaming\5. EDI\ACA hours

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - All hours are update in Production. Kick outs are in Bad file. Y:\1.CLIENT\Mesquite Gaming\5. EDI\ACA hours
          Hide
          amjohnson Amannda Johnson added a comment -

          Kristi Smith please review kick outs and work with mesquite to help resolve if need be.

          Monika Demla- client provided another file for loading on 7/11. file is saved here: Y:\1.CLIENT\Mesquite Gaming\5. EDI\ACA hours\20160626 please load and report any kick outs.
          Cindy WibbingI think monica is out on vacation please let us know who will be loading the file.

          Show
          amjohnson Amannda Johnson added a comment - Kristi Smith please review kick outs and work with mesquite to help resolve if need be. Monika Demla - client provided another file for loading on 7/11. file is saved here: Y:\1.CLIENT\Mesquite Gaming\5. EDI\ACA hours\20160626 please load and report any kick outs. Cindy Wibbing I think monica is out on vacation please let us know who will be loading the file.
          Hide
          amjohnson Amannda Johnson added a comment -

          Monika Demlaplease confirm the 06/26 file was loaded and please now help load the 7/10 file. I added in the same location adding a new folder titled 20160710. Thank you!

          Show
          amjohnson Amannda Johnson added a comment - Monika Demla please confirm the 06/26 file was loaded and please now help load the 7/10 file. I added in the same location adding a new folder titled 20160710. Thank you!
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment - - edited

          ACA hours from 6/26 and 7/10 are updated in WT production. 2 Kick outs from each date are saved in respective folders.
          Error(s) : Invalid Record: Employee does not exists

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - - edited ACA hours from 6/26 and 7/10 are updated in WT production. 2 Kick outs from each date are saved in respective folders. Error(s) : Invalid Record: Employee does not exists
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Amannda Johnson
          Please advise If I should close this ticket.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Amannda Johnson Please advise If I should close this ticket.
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Amannda Johnson
          The format on original file sent is correct, and I tested records for automation, we are ready to make these ACA hours for automation.
          Y:\1.CLIENT\Mesquite Gaming\5. EDI\ACA hours\20160710
          Files are saved here.
          Template used: ACA Timesheet Import Without PTO

          Please let me know if you need more information.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Amannda Johnson The format on original file sent is correct, and I tested records for automation, we are ready to make these ACA hours for automation. Y:\1.CLIENT\Mesquite Gaming\5. EDI\ACA hours\20160710 Files are saved here. Template used: ACA Timesheet Import Without PTO Please let me know if you need more information.
          Hide
          kristi.smith Kristi Smith (Inactive) added a comment -

          Monika Demla Client is sending these reports manually. Do I need to forward them to the EDI team for load?

          THank you.

          Show
          kristi.smith Kristi Smith (Inactive) added a comment - Monika Demla Client is sending these reports manually. Do I need to forward them to the EDI team for load? THank you.
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Yes Please.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Yes Please.
          Hide
          kristi.smith Kristi Smith (Inactive) added a comment -

          ok Monika Demla edienrollment@ebsbenefits.com or edi@ebsbenefits.com?

          Show
          kristi.smith Kristi Smith (Inactive) added a comment - ok Monika Demla edienrollment@ebsbenefits.com or edi@ebsbenefits.com?
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          At my email address and you can cc Cindy.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - At my email address and you can cc Cindy.
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          I will import aca hours from 7/24 and 8/7

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - I will import aca hours from 7/24 and 8/7
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Importing hours from 8/8 to 8/21, it is updated.
          Files are saved here:
          Y:\1.CLIENT\Mesquite Gaming\5. EDI\ACA hours\20160830
          Two kicked out. Please advise one they are in WT so I can push those Bad file.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Importing hours from 8/8 to 8/21, it is updated. Files are saved here: Y:\1.CLIENT\Mesquite Gaming\5. EDI\ACA hours\20160830 Two kicked out. Please advise one they are in WT so I can push those Bad file.
          Hide
          kristi.smith Kristi Smith (Inactive) added a comment -

          Monika Demla Attached is the newest file. Please load. THank you. T&A Final 9-4& 9-18, 2016.xls

          Show
          kristi.smith Kristi Smith (Inactive) added a comment - Monika Demla Attached is the newest file. Please load. THank you. T&A Final 9-4& 9-18, 2016.xls
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          This is done and files are saved here:
          Y:\1.CLIENT\Mesquite Gaming\5. EDI\ACA hours\20160925

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - This is done and files are saved here: Y:\1.CLIENT\Mesquite Gaming\5. EDI\ACA hours\20160925
          Hide
          kristi.smith Kristi Smith (Inactive) added a comment -

          Hi Monika,

          Newest file is saved in your EDI folders dates 1002. Thank you.

          Show
          kristi.smith Kristi Smith (Inactive) added a comment - Hi Monika, Newest file is saved in your EDI folders dates 1002. Thank you.
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Hi Kristi,
          This is updated

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Hi Kristi, This is updated
          Hide
          kristi.smith Kristi Smith (Inactive) added a comment -

          New file attached. Password is MG2016

          Show
          kristi.smith Kristi Smith (Inactive) added a comment - New file attached. Password is MG2016
          Hide
          kristi.smith Kristi Smith (Inactive) added a comment -

          Saved in following folder dated 10.13.16. Will not let me attach

          Y:\1.CLIENT\Mesquite Gaming\ACA

          Show
          kristi.smith Kristi Smith (Inactive) added a comment - Saved in following folder dated 10.13.16. Will not let me attach Y:\1.CLIENT\Mesquite Gaming\ACA
          Hide
          kristi.smith Kristi Smith (Inactive) added a comment -

          Hi Monika,

          there is another file in the folder Y:\1.CLIENT\Mesquite Gaming\ACA\20161030

          Show
          kristi.smith Kristi Smith (Inactive) added a comment - Hi Monika, there is another file in the folder Y:\1.CLIENT\Mesquite Gaming\ACA\20161030
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Hi Kristi Smith
          Whats the password?

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Hi Kristi Smith Whats the password?
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Kristi Smith
          I am unable to open the file. Can you please share password?

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Kristi Smith I am unable to open the file. Can you please share password?
          Hide
          kristi.smith Kristi Smith (Inactive) added a comment -

          MG2016

          Show
          kristi.smith Kristi Smith (Inactive) added a comment - MG2016
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Y:\1.CLIENT\Mesquite Gaming\5. EDI\ACA hours\20161030
          This is Done. Files are saved at this location.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Y:\1.CLIENT\Mesquite Gaming\5. EDI\ACA hours\20161030 This is Done. Files are saved at this location.
          Hide
          kristi.smith Kristi Smith (Inactive) added a comment -

          Monika Demla The final report for 2016 is in this folder Y:\1.CLIENT\Mesquite Gaming\5. EDI\ACA hours\2016111316. Thank you.

          Show
          kristi.smith Kristi Smith (Inactive) added a comment - Monika Demla The final report for 2016 is in this folder Y:\1.CLIENT\Mesquite Gaming\5. EDI\ACA hours\2016111316. Thank you.
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          This is processed and Updated.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - This is processed and Updated.
          Hide
          kristi.smith Kristi Smith (Inactive) added a comment -

          Monika Demla New files have been posted in

          Show
          kristi.smith Kristi Smith (Inactive) added a comment - Monika Demla New files have been posted in
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          hi Kristi Smith
          This is processed.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - hi Kristi Smith This is processed.

            People

            Assignee:
            Monika.Demla Monika Demla (Inactive)
            Reporter:
            amjohnson Amannda Johnson
            Account Executive:
            Kristi Smith (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: