Loading Payroll Files from T&A Trinity Health. All Rights Reserved. 1

Loading Payroll Files from T&A ©2014 Trinity Health. All Rights Reserved. 1 1 Housekeeping • • • • Do not place us on hold Close other programs ...
Author: Marsha Miller
13 downloads 0 Views 3MB Size
Loading Payroll Files from T&A

©2014 Trinity Health. All Rights Reserved.

1

1

Housekeeping • • • •

Do not place us on hold Close other programs Ask questions by raising your hand or by using Chat You may be asked to interact during the session, including: Chat, Status Icons, and Activity Report Outs

©2015Health. Trinity All Health - Livonia, MI ©2014 Trinity Rights Reserved.

22

Reflection

©2014 Trinity Health. All Rights Reserved.

33

Course Introduction

©2014 Trinity Health. All Rights Reserved.

44

Course Objectives – Loading T&A files At the end of this session you, will be able to: •

Load your time and attendance file



Check for Errors



Balance your file to WorkDay

©2014 Trinity Health. All Rights Reserved.

55

How do payments get into WorkDay? There are three places that data lands in WD that generates a payment. 1. Payroll Input (manually or EIB's). Examples: one time earns or T&A file 2. Absence management – Paid time off payments. This depletes balances first, and then gets paid. 3. Compensation (one time payments (OTP's) – sign on bonus, etc. They can either be loaded or requested through a business process.

©2014 Trinity Health. All Rights Reserved.

66

What am I learning today? In this presentation, we will focus on the first way pay data gets in to Workday: 1. Payroll Input (manually or EIB's). Examples: one time earns or Time & Attendance files. More specifically - how to load your T& A file. EIB’s will be covered in another training session.

©2014 Trinity Health. All Rights Reserved.

77

Who & What Each Payroll Manager will be responsible for: •

Creating and loading their time and attendance file in to WorkDay.



Review of the errors on the load, and correct the errors either by EIB files or by manual entry.



Balancing the totals on the file to the totals that loaded in Workday.

©2014 Trinity Health. All Rights Reserved.

88

When and Why The time and attendance files will need to be pulled and loaded on “Payroll Monday”. Time to be announced at a later date. Once the load is complete, the errors must be corrected and the totals must be balanced. We do this to ensure that what we expected to load, in fact loaded, and the time will be correct on all of our employee’s pay checks. The calculation will take place over night so it is critical that these steps are complete on Monday by the end of the business day.

©2014 Trinity Health. All Rights Reserved.

99

Naming Convention for T&A files YYYYMMDD_TK_RHM.txt (or .dat). No spaces or periods will be accepted. Make sure the file is saved on the shared drive under your RHM’s folder.

©2014 Trinity Health. All Rights Reserved.

10 10

Upload the T&A File to the EDI Server The T&A file will be triggered in Kronos. Review, rename and place the file on your local drive as needed. Your file must be named using this convention: YYYYMMDD_TK_RHM.txt (or .dat). No spaces or periods will be accepted. To upload the file: 1.

2.

Access EDI from this URL: https://editransfer.trinityhealth.org/cehttp/html/main.htm

Click the Logon button

Job Aid: Upload the T&A File to the EDI Server

©2014 Trinity Health. All Rights Reserved.

1111

Upload the T&A File to the EDI Server (Cont.) You will log in as the integration. 3.

Enter User Id This would be the numeric account that corresponds to your timekeeping integration (i.e., 5000a Each RHM will have its own timekeeping integration name)

4.

Enter Password Workdaytest (this is a generic password being used for testing purposes only)

5.

Leave Server blank

6.

Click Logon

7.

Click Send

Job Aid: Upload the T&A File to the EDI Server

©2014 Trinity Health. All Rights Reserved.

1212

Upload the T&A File to the EDI Server (Cont.) 8. • •

• •

9.

Complete the following fields: Data Format: Select ASCII Mailbox ID: Enter the integration ID you used for User ID. (This is the timekeeping integration number specific to each RHM). Batch ID: Leave blank File Name: Click Browse and locate the file saved on your local drive. Click Send Note: Your file must be named using this convention: YYYYMMDD_TK_RHM.txt (or .dat). No spaces or periods will be accepted.

EDI will automatically move the file into the directory where Workday will look to retrieve it.

Job Aid: Upload the T&A File to the EDI Server

©2014 Trinity Health. All Rights Reserved.

1313

Upload the T&A File to the EDI Server (Cont.) To verify that your file uploaded: 1.

Click on the Directory button on the left

2.

Click the Directory button at the bottom of the page

Job Aid: Upload the T&A File to the EDI Server

©2014 Trinity Health. All Rights Reserved.

1414

Upload the T&A File to the EDI Server (Cont.) You will see a listing of your files.

20160615_TK_SJRMC.txt

Job Aid: Upload the T&A File to the EDI Server

©2014 Trinity Health. All Rights Reserved.

1515

Loading Time Keeping Files into Workday

1. Type “Launch” in the search box

16 ©2014 Trinity Health. All Rights Reserved.

16

Loading Time Keeping Files into Workday

2. Select Launch / Schedule Integration

17 ©2014 Trinity Health. All Rights Reserved.

17

Loading Time Keeping Files into Workday

3. Select All Integration Systems (Or type in your Integration number)

©2014 Trinity Health. All Rights Reserved.

18 18

4. Search for your RHM’s interface. This will be different depending on your T&A system. 5. Leave Organization BLANK 6. Leave Run as Current User BLANK 7. Click OK

19 ©2014 Trinity Health. All Rights Reserved.

19

Loading Time Keeping Files into Workday

Status of load is displayed here

20 ©2014 Trinity Health. All Rights Reserved.

20

Checking for Errors

Click Output Files

21 ©2014 Trinity Health. All Rights Reserved.

21

Checking for Errors

Check the error log under Output Files

22 ©2014 Trinity Health. All Rights Reserved.

22

Checking for Errors

Click on the file link to open

23 ©2014 Trinity Health. All Rights Reserved.

23

Checking for Errors

This will always display. Click YES.

©2014 Trinity Health. All Rights Reserved.

24 24

Checking for Errors

25 ©2014 Trinity Health. All Rights Reserved.

25

Checking for Errors

©2014 Trinity Health. All Rights Reserved.

26 26

Checking for Errors

27 ©2014 Trinity Health. All Rights Reserved.

27

Checking for Errors

28 ©2014 Trinity Health. All Rights Reserved.

28

Checking for Errors

©2014 Trinity Health. All Rights Reserved.

29 29

30 ©2014 Trinity Health. All Rights Reserved.

30

31 ©2014 Trinity Health. All Rights Reserved.

31

32 ©2014 Trinity Health. All Rights Reserved.

32

33 ©2014 Trinity Health. All Rights Reserved.

33

34 ©2014 Trinity Health. All Rights Reserved.

34

35 ©2014 Trinity Health. All Rights Reserved.

35

Lesson Practice 1.

Login to the training tenant • (login instruction)

2.

Practice

It’s Your Turn!

• task Instructions)

©2014 Trinity Health. All Rights Reserved.

36 36

Course Conclusion

©2014 Trinity Health. All Rights Reserved.

37 37

Summary You should now be be able to: •

Load your time and attendance file



Check for Errors



Balance your file to WorkDay

©2014 Trinity Health. All Rights Reserved.

38 38

Questions

©2014 Trinity Health. All Rights Reserved.

39 39