dim_class_event_property


Description

The table contains simple properties of class events. This is a junk dimension that stores distinct combinations of event status, source, and booked_for_free flag.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
class_event_property_id varchar 256 null
fct_class_event.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

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

Status of the event, e.g., BOOKED, CANCELED, etc.
source varchar 256 √ null

The system from which the event was triggered, e.g., MYSPORTS, INTERNAL_API, etc.
booked_for_free bool 1 √ null

Is this booking event for free, that is, no contingent was used for booking a class
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