dim_trainer_appointment_status


Description

Lookup table for status values of trainer assignments to appointments

Columns

Column Type Size Nulls Auto Default Children Parents Comments
trainer_appointment_status_id varchar 256 null
fct_trainer_class_appointments.trainer_appointment_status_id fct_trainer_class_appointments_trainer_appointment_status_id_fkey R

The primary key of this table. System column calculated by DataOps.
status varchar 256 √ null

Status of trainer assignment to appointment: * BOOKED: the trainer is available for the appointment * DESIRED: the trainer is planned/not available for the appointment * APPOINTMENT_CANCELED: appointment was cancelled
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