Human resources data model
The HR data model is a transactional fact table with discrete events. This includes the employee-related events along with a few financial events that help us measure productivity. We record the following events in this model:
Employee payroll
Employee absences
Employee training
Employee hiring and dismissals
General Journal (GJ) entries related to sales, costs, and expenses
Here is a representation of this model:
We combine these events into one fact table and use the same type of master calendar as in Chapter 12, Sales Perspective. The data model includes a new dimension table called Employees. Let's review the 7Ws of our HR data model.
|
Dimensions | ||
|---|---|---|
|
7Ws |
Fields |
Comments |
|
Who |
|
This is the focus of our HR data model. We include various attributes that are related to their role in the company and general demographic information here. |
|
When |
|
This is where we include a single master calendar that describes the exact date of an event. |
|
Where |
... | |
