WORKTERRAProject Type: software

WORKTERRA

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

          Ascending order - Click to sort in descending order
          amjohnson Amannda Johnson created issue -
          Hide
          Permalink
          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!
          Cindy.Wibbing Cindy Wibbing (Inactive) made changes -
          Field Original Value New Value
          Assignee Cindy Wibbing [ cindy.wibbing ] Nathaniel Cornejo-Walker [ nwalker ]
          Hide
          Permalink
          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
          Permalink
          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
          Permalink
          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
          Permalink
          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
          Permalink
          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
          Monika.Demla Monika Demla (Inactive) made changes -
          Assignee Nathaniel Cornejo-Walker [ nwalker ] Monika Demla [ monika.demla ]
          Hide
          Permalink
          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
          Permalink
          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
          Permalink
          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
          Permalink
          Monika.Demla Monika Demla (Inactive) added a comment -

          Yes Please.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Yes Please.
          Hide
          Permalink
          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
          Permalink
          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
          Permalink
          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
          Permalink
          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
          Permalink
          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
          kristi.smith Kristi Smith (Inactive) made changes -
          Attachment T&A Final 9-4& 9-18, 2016.xls [ 27658 ]
          Hide
          Permalink
          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
          Permalink
          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
          Permalink
          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
          Monika.Demla Monika Demla (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          Monika.Demla Monika Demla (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Hide
          Permalink
          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
          kristi.smith Kristi Smith (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Hide
          Permalink
          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
          Permalink
          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
          Permalink
          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
          Permalink
          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
          Permalink
          kristi.smith Kristi Smith (Inactive) added a comment -

          MG2016

          Show
          kristi.smith Kristi Smith (Inactive) added a comment - MG2016
          Hide
          Permalink
          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.
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Reopened [ 4 ] Resolved [ 5 ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Hide
          Permalink
          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.
          kristi.smith Kristi Smith (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Hide
          Permalink
          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.
          rakeshr Rakesh Roy (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Reopened [ 4 ] Resolved [ 5 ]
          kristi.smith Kristi Smith (Inactive) made changes -
          Attachment screenshot-1.png [ 35250 ]
          Hide
          Permalink
          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
          kristi.smith Kristi Smith (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          Hide
          Permalink
          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.
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Reopened [ 4 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Monika Demla (Inactive) made transition -
          Open Resolved
          		101d 20h 48m 1
          Nandkumar Prabhakar Karlekar (Inactive) made transition -
          Resolved Closed
          		5s 2
          Kristi Smith (Inactive) made transition -
          Closed Reopen
          		37d 9h 34m 2
          Rakesh Roy (Inactive) made transition -
          Reopen Resolved
          		24d 12h 25m 2
          Kristi Smith (Inactive) made transition -
          Resolved Reopen
          		3d 23h 39m 1
          Nandkumar Prabhakar Karlekar (Inactive) made transition -
          Reopen Closed
          		3d 11h 16m 1

            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: