fct_trainer_appointment

-1 rows


Description

An appointment (class, trial session or personal training) by the trainer(s) leading it. Note: There can be multiple trainers per appointment, leading to multiple entries of the same appointment_id.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
trainer_appointment_id int8 19 null

The primary key of this table. System column calculated by the source System.
organization_unit_id int8 19 null
dim_organization_unit.organization_unit_id fct_trainer_appointment_organization_unit_id_fkey R

The studio where the appointment takes place.
appointment_id int8 19 null
dim_appointment.appointment_id fct_trainer_appointment_appointment_id_fkey R

The unique appointment in the calendar. With useful information about it, eg. its status.
employee_id int8 19 null
dim_employee.employee_id fct_trainer_appointment_employee_id_fkey R

The employee who is the trainer of this appointment.
service_id int8 19 √ null
dim_service.service_id fct_trainer_appointment_service_id_fkey R

The pre-defined service this appointment is about. Or null if no service is assigned.
start_date date 13 null
dim_date.date fct_trainer_appointment_start_date_fkey R

The date when the appointment starts.
end_date date 13 null
dim_date.date fct_trainer_appointment_end_date_fkey R

The date when the appointment ends.
start_date_time timestamp 29,6 null

The local timestamp at which the appointment starts.
end_date_time timestamp 29,6 null

The local timestamp at which the appointment ends.
trainer_status varchar 256 null

BOOKED: the trainer is available for the appointmentDESIRED: the trainer is planned/not available for the appointmentAPPOINTMENT_CANCELED: appointment was cancelled
num_booked_participants int8 19 null

How many customers successfully booked (and didn’t cancel) this appointment
num_booked_waiting_list int8 19 null

How many customers tried to book this appointment, while it already reached its max_participants.
num_anonymous_participants int4 10 null

How many people participated in this appointment, but did not book in advance. Eg. appointment started, they walked in and asked if they can join.
num_confirmed_participants int8 19 null

How many people were reported as physically present when the appointment started. (By their participant_status).
num_confirmed_missing_participants int8 19 null

How many of the booked participants were reported as physically not-present when the appointment started. (By their participant_status).
num_unconfirmed_participants int8 19 null

For how many of the booked participants, nothing about their physical presence was reported. (By their participant_status).
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