Go and select your employer. We’ll use SR1 for today for employer. And then just as with financial reporting, you’re going to see the data link contains all the tables for the personnel data, the payroll data. You’ll see the payroll income data. You’ll see tax and deduction data, and payroll history in the payroll area.
In HR area, you’re going to see benefits, safety and health, absence data, and then today we’re going to spend some time in the employee master file. Now the great thing here is that all the joins have been done for you. So if you were joining multiple tables, you wouldn’t have to do that work yourself. You’re going to see that right here in the next step, where you’re looking at all the tables for the master file but you also have the route master file joined in as a drop down.
Now you can go through and, if you want to grab division, well in my system that’s level one. You want to grab employee name. You can do first last, or you can do employee complete name. Let’s grab gender, and this time I’m going to double click to grab gender and double click to grab ethnicity. So point and click, drag and drop, multi select, all of those work the same way as any Windows type application. So it’s really easy to grab the column headings that you’re after.