Used as the core source for loading the Employee or Timekeeper dimension; it maintains a list of employees/timekeepers for the organization. This should be a list containing either active timekeepers or timekeepers which have fact data from other tables being loaded.
Only current, active employees are necessary for budgeting.
|
Summary
Used as the core source for loading the Employee or Timekeeper dimension; it maintains a list of employees/timekeepers for the organization. |
|
|
|
Uniquely identifying code associated to the employee; this is often the system-generated employee ID or number from the source system. Required. |
|
Employee’s full name, often used to build the employee member. Required. |
|
Employee’s last name. Optional. |
|
Employee’s first name. Optional. |
|
The year the employee graduated. Optional. |
|
|
|
These rules govern creation of this table and cover what the column does and how it may be calculated. |
|
This load file is a small sample of an Employee load. |
Sample CSV Load File
This load file is a small sample of an Employee load.
Filename: Employee.csv
00032,"Aberle, Eun",Aberle,Eun,1987 00006,"Bihari, Loren",Bihari,Loren,1959 00076,"Emmi, Takako",Emmi,Takako,2009 00084,"Heatwole, Lucienne",Heatwole,Lucienne,2000 00094,"Henjes, Franklin",Henjes,Franklin,2001 00046,"Moriarty, Yan",Moriarty,Yan,1970 00075,"Vanartsdalen, Shaun",Vanartsdalen,Shaun,1972
Columns
Business Rules
These rules govern creation of this table and cover what the column does and how it may be calculated.
Calculated Columns
Employee_Long_Name |
Comma-separated concatenation of the employee’s last (<Employee_Last_Name>) and first names <Employee_First_Name>). |
What Data to Load
Only load active employees and employees referenced in other data files.
0 Comments