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 Implied Constraint R
fct_employee_access.employee_id Implied Constraint R
fct_service_usage.employee_id Implied Constraint R
fct_trainer_appointment.employee_id Implied Constraint R
fct_trainer_class_appointments.employee_id Implied Constraint 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

Working model of the employee
status varchar 256 √ null

Employment status of the employee. Possible values: ACTIVE (currently active), DEACTIVATED (soft-deactivated; triggers appointment and shift cleanup in the application).
managed_by varchar 256 √ null

Indicates how the employee account is managed. Possible values: ERP (native internal account), ACTIVE_DIRECTORY (Azure AD / SSO-managed), ACTIVE_DIRECTORY_CUSTOM (AD with custom configuration).
business_role varchar 256 √ null

Business role of the employee within the studio organisation. Possible values: STUDIO_OWNER, STUDIO_MANAGER, TRAINER, SERVICE_EMPLOYEE, ADMINISTRATION_OR_FINANCE, MARKETING. NULL values are filled with UNKNOWN.
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