fct_trainer_class_appointments

-1 rows


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 end

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 int8 19 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 behind source system).

Relationships