fct_class_event


Description

Stores all customer events for class appointments such as booking or cancellations

Columns

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

The studio where the appointment event took place
appointment_id int8 19 √ null
dim_appointment.appointment_id erp_v2_fct_class_event_appointment_id__erp_v2_dim_appointment_appointment_id_fkey_ef6408601227 R

The ID of the appointment where a customer wants to participate
start_date_id int4 10 √ null
dim_date.date_id Implied Constraint R

Start date of appointment
end_date_id int4 10 √ null
dim_date.date_id Implied Constraint R

End date of appointment
event_date_id int4 10 √ null
dim_date.date_id Implied Constraint R

The date when the appointment event was created
event_date_time timestamptz 35 √ null

The timestamp when the appointment event was created
class_id int8 19 √ null
dim_class.class_id erp_v2_fct_class_event_class_id__erp_v2_dim_class_class_id_fkey_608cf7f8dd85 R

The ID of the related class for the appointment
customer_id int8 19 √ null
dim_customer.customer_id erp_v2_fct_class_event_customer_id__erp_v2_dim_customer_customer_id_fkey_a00da0c26bf7 R

The ID of the customer
inclusive_contingent_id int8 19 √ null
dim_inclusive_contingent.inclusive_contingent_id erp_v2_fct_class_event_inclusive_contingent_id__erp_v2_dim_inclusive_contingent_inclusive_contingent_id_fkey_94ae8bcc3b4a R

The ID of the inclusive contingent which was used for booking. If NULL, inclusive contingent was not used to book a class
purchased_contingent_id int8 19 √ null
dim_purchased_contingent.purchased_contingent_id erp_v2_fct_class_event_purchased_contingent_id__erp_v2_dim_purchased_contingent_purchased_contingent_id_fkey_895261d4114d R

The ID of the purchased contingent which was used for booking. If NULL, purchased contingent was not used to book a class
class_event_property_id varchar 256 √ null
dim_class_event_property.class_event_property_id erp_v2_fct_class_event_class_event_property_id__erp_v2_dim_class_event_property_class_event_property_id_fkey_2f246406031f R

Appointment event properties, e.g., status of the event (BOOKED, CANCELED), source - from which system the event was triggered, whether it was booked for free or not
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).
data_landing_time timestamptz 35 getdate()

System column. UTC timestamp assigned when a table batch is applied on Redshift. It represents warehouse landing order at table-batch granularity, not source event order. Usable to filter for incremental extractions.

Relationships

Close relationships within degrees of separation