dim_employee


Description

Table contains all employees and their relevant information

Columns

Column Type Size Nulls Auto Default Children Parents Comments
employee_id int8 19 null
fct_contract.employee_id fct_contract_employee_id_fkey R
fct_employee_access.employee_id fct_employee_access_employee_id_fkey R
fct_service_usage.employee_id fct_service_usage_employee_id_fkey R
fct_trainer_appointment.employee_id fct_trainer_appointment_employee_id_fkey R
fct_trainer_class_appointments.employee_id fct_trainer_class_appointments_employee_id_fkey R

The primary key of this table. System column calculated by the source System.
firstname varchar 256 √ null

First name Can be null if data is anonymized, because the entry is not directly related to your organizations (from another FRANCHISE or you have a FRANCHISE_SYSTEM).
lastname varchar 256 √ null

Last name Can be null if data is anonymized, because the entry is not directly related to your organizations (from another FRANCHISE or you have a FRANCHISE_SYSTEM).
date_of_birth date 13 √ null

Date of birth. For unknown values, the default value is 1900-01-01 Can be null if data is anonymized, because the entry is not directly related to your organizations (from another FRANCHISE or you have a FRANCHISE_SYSTEM).
gender varchar 256 √ null

Gender Can be null if data is anonymized, because the entry is not directly related to your organizations (from another FRANCHISE or you have a FRANCHISE_SYSTEM).
employee_number varchar 256 null

Employee number
username varchar 256 √ null

The username of the employee in the ERP system. Can be null if data is anonymized, because the entry is not directly related to your organizations (from another FRANCHISE or you have a FRANCHISE_SYSTEM).
phone varchar 256 √ null

Phone Can be null if data is anonymized, because the entry is not directly related to your organizations (from another FRANCHISE or you have a FRANCHISE_SYSTEM).
additional_phone varchar 256 √ null

Additional phone Can be null if data is anonymized, because the entry is not directly related to your organizations (from another FRANCHISE or you have a FRANCHISE_SYSTEM).
email varchar 256 √ null

Email Can be null if data is anonymized, because the entry is not directly related to your organizations (from another FRANCHISE or you have a FRANCHISE_SYSTEM).
address_country varchar 256 null

Country where employee lives
address_city varchar 256 √ null

City where employee lives Can be null if data is anonymized, because the entry is not directly related to your organizations (from another FRANCHISE or you have a FRANCHISE_SYSTEM).
address_street varchar 256 √ null

Street where employee lives Can be null if data is anonymized, because the entry is not directly related to your organizations (from another FRANCHISE or you have a FRANCHISE_SYSTEM).
address_house_number varchar 256 √ null

House number where employee lives Can be null if data is anonymized, because the entry is not directly related to your organizations (from another FRANCHISE or you have a FRANCHISE_SYSTEM).
address_zip varchar 256 √ null

Zip where employee lives Can be null if data is anonymized, because the entry is not directly related to your organizations (from another FRANCHISE or you have a FRANCHISE_SYSTEM).
working_time_model varchar 256 null

Working model of the employee
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags behind source system).

Relationships

Close relationships within degrees of separation