fct_trainer_class_appointments


Description

DEPRECATED. Use fct_trainer_appointment instead. Stores all appointments for trainers

Columns

Column Type Size Nulls Auto Default Children Parents Comments
trainer_class_appointments_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_class_appointments_organization_unit_id_fkey R

The id of a studio where appointment take place
start_date_id int4 10 √ null
dim_date.date_id fct_trainer_class_appointments_start_date_id_fkey R

The date when appointment starts
end_date_id int4 10 √ null
dim_date.date_id fct_trainer_class_appointments_end_date_id_fkey R

The date when appointment ends
employee_id int8 19 √ null
dim_employee.employee_id fct_trainer_class_appointments_employee_id_fkey R

The employee responsible for this appointment
class_id int8 19 √ null
dim_class.class_id fct_trainer_class_appointments_class_id_fkey R

The id of a related class of the appointment
appointment_id int8 19 √ null
dim_appointment.appointment_id fct_trainer_class_appointments_appointment_id_fkey R

Appointment properties, e.g status of the appointment, number of max participants, planned participants, etc
trainer_appointment_status_id varchar 256 √ null
dim_trainer_appointment_status.trainer_appointment_status_id fct_trainer_class_appointments_trainer_appointment_status_id_fkey R

Status of the employee for a specific appointment
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