dim_employee

-1 rows


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_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
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