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.

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk