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 Implied Constraint 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
lastname varchar 256 √ null

Last name
date_of_birth date 13 √ null

Date of birth. For unknown values, the default value is 1900-01-01
gender varchar 256 √ null

Gender
employee_number varchar 256 √ null

Employee number
username varchar 256 √ null

The username of the employee in the ERP system.
phone varchar 256 √ null

Phone
additional_phone varchar 256 √ null

Additional phone
email varchar 256 √ null

Email
address_country varchar 256 √ null

Country where employee lives
address_city varchar 256 √ null

City where employee lives
address_street varchar 256 √ null

Street where employee lives
address_house_number varchar 256 √ null

House number where employee lives
address_zip varchar 256 √ null

Zip where employee lives
working_time_model varchar 256 √ null
dim_organization_unit.organization_unit_id dim_employee_working_time_model_fkey R

Working model of the employee
last_updated timestamptz 35 √ null

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

Relationships

Close relationships within degrees of separation