|
Code |
_EMP |
|---|---|
|
Name |
Employee |
|
Table Name |
dim_employees |
|
Description |
details on employees |
Source priority
-
HR extract
-
CRM extract
Content
|
Field name |
Data Type |
Description |
|---|---|---|
|
Employee_id |
string |
|
|
employee_manager_id |
string |
|
|
employee_full_name |
string |
if source = HR, concat(first_name, ' ', last_name); if source = CRM, ‘name’ |
|
employee_is_in_crm |
bool |
if employee is in source CRM, then true Else false |
|
employee_is_in_hr_system |
bool |
if employee is in source HR system, then true Else false |
|
snapshot_date |
datetime |
link to point in time table |