Employee

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.

Idx	Field	Type	Maximum Length	Required
1	Employee_Code	Alphanumeric	20	Yes
2	Employee_Long_Name	Alphanumeric	100	Yes
3	Employee_Last_Name	Alphanumeric	100	No
4	Employee_First_Name	Alphanumeric	100	No
5	Employee_Class_Year	Alphanumeric	4	No

Summary

Employee	Used as the core source for loading the Employee or Timekeeper dimension; it maintains a list of employees/timekeepers for the organization.
Columns
Employee_Code	Uniquely identifying code associated to the employee; this is often the system-generated employee ID or number from the source system. Required.
Employee_Long_Name	Employee’s full name, often used to build the employee member. Required.
Employee_Last_Name	Employee’s last name. Optional.
Employee_First_Name	Employee’s first name. Optional.
Employee_Class_Year	The year the employee graduated. Optional.
Documentation
Business Rules	These rules govern creation of this table and cover what the column does and how it may be calculated.
Sample CSV Load File	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

Employee_Code

Employee_Code varchar(

20

) NOT NULL

Uniquely identifying code associated to the employee; this is often the system-generated employee ID or number from the source system. Required.

Field Load File Format
Type	Alphanumeric
Maximum Length	20
Required	Yes

Employee_Long_Name

Employee_Long_Name varchar(

100

) NOT NULL

Employee’s full name, often used to build the employee member. Required.

Field Load File Format
Type	Alphanumeric
Maximum Length	100
Required	Yes

Employee_Last_Name

Employee_Last_Name varchar(

100

) NULL

Employee’s last name. Optional.

Field Load File Format
Type	Alphanumeric
Maximum Length	100
Required	No

Employee_First_Name

Employee_First_Name varchar(

100

) NULL

Employee’s first name. Optional.

Field Load File Format
Type	Alphanumeric
Maximum Length	100
Required	No

Employee_Class_Year

Employee_Class_Year varchar(

4

) NULL

The year the employee graduated. Optional.

Field Load File Format
Type	Alphanumeric
Maximum Length	4
Required	No

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.