dim_organization_unit


Description

A gym. The physical location at which people go to work out. But also the abstract entity to which customers sign up to.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
organization_unit_id int8 19 null
bridge_company_to_organization_unit.organization_unit_id erp_v2_bridge_company_to_organization_unit_organization_unit_id__erp_v2_dim_organization_unit_organization_uni_51e5d48373ee R
bridge_discount_campaign_to_organization_unit.organization_unit_id erp_v2_bridge_discount_campaign_to_organization_unit_organization_unit_id__erp_v2_dim_organization_unit_organi_d2fbb7060fea R
bridge_organization_unit_to_organization_unit_code.organization_unit_id erp_v2_bridge_organization_unit_to_organization_unit_code_organization_unit_id__erp_v2_dim_organization_unit_o_508bb3291f6a R
bridge_product_to_organization_unit.organization_unit_id erp_v2_bridge_product_to_organization_unit_organization_unit_id__erp_v2_dim_organization_unit_organization_uni_7f6dc1b876f7 R
bridge_service_to_organization_unit.organization_unit_id erp_v2_bridge_service_to_organization_unit_organization_unit_id__erp_v2_dim_organization_unit_organization_uni_93f5ab50f16a R
dim_cash_register.organization_unit_id erp_v2_dim_cash_register_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_e6721b9ab5cd R
dim_closing_hours.organization_unit_id erp_v2_dim_closing_hours_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_82c34000fc77 R
dim_customer_communication_consent.organization_unit_id erp_v2_dim_customer_communication_consent_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_17e4f8f0f3bc R
dim_customer_group.organization_unit_id erp_v2_dim_customer_group_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_4fdcd4b09658 R
dim_idle_period_property.organization_unit_id erp_v2_dim_idle_period_property_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_bcec297cd3be R
dim_opening_hours.organization_unit_id erp_v2_dim_opening_hours_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_a8118e8ea847 R
dim_purchased_contingent.organization_unit_id erp_v2_dim_purchased_contingent_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_58fc0abfa10c R
dim_studio_starter_package_adjustment.organization_unit_id erp_v2_dim_studio_starter_package_adjustment_organization_unit_id__erp_v2_dim_organization_unit_organization_u_711bef1b21d1 R
fct_checkin.customer_organization_unit_id erp_v2_fct_checkin_customer_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_add16c7191fc R
fct_checkin.organization_unit_id erp_v2_fct_checkin_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_53f443d15805 R
fct_class_appointment.organization_unit_id erp_v2_fct_class_appointment_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_cde89206a5f0 R
fct_class_event.organization_unit_id erp_v2_fct_class_event_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_e6ab28415bac R
fct_contract.organization_unit_id erp_v2_fct_contract_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_b1c3c75d1a29 R
fct_contract_cancellation.organization_unit_id erp_v2_fct_contract_cancellation_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_de00c0a9ddbb R
fct_contract_price_history.organization_unit_id erp_v2_fct_contract_price_history_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_6f07537a3a43 R
fct_contract_term_dates.organization_unit_id erp_v2_fct_contract_term_dates_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_e13a283163ac R
fct_customer_appointment.organization_unit_id erp_v2_fct_customer_appointment_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_0b29e6e45a12 R
fct_customer_studio_history.organization_unit_id erp_v2_fct_customer_studio_history_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fke_04abcb7d4338 R
fct_employee_access.organization_unit_id erp_v2_fct_employee_access_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_04e45decc79f R
fct_idle_period.organization_unit_id erp_v2_fct_idle_period_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_e20167bbb9db R
fct_invoice.organization_unit_id erp_v2_fct_invoice_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_66c6d57ea319 R
fct_lead_lifetime.organization_unit_id erp_v2_fct_lead_lifetime_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_88dd817d8549 R
fct_lead_stage_history.organization_unit_id erp_v2_fct_lead_stage_history_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_2999e5217846 R
fct_payment.organization_unit_id erp_v2_fct_payment_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_4cd96431adf1 R
fct_payment_instrument_status_history.organization_unit_id erp_v2_fct_payment_instrument_status_history_organization_unit_id__erp_v2_dim_organization_unit_organization_u_0950a3274251 R
fct_payment_run.organization_unit_id erp_v2_fct_payment_run_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_6234eded60eb R
fct_pos_saleposition.organization_unit_id erp_v2_fct_pos_saleposition_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_e2db3f4dc8ab R
fct_rate_bundle_term_availability.organization_unit_id erp_v2_fct_rate_bundle_term_availability_organization_unit_id__erp_v2_dim_organization_unit_organization_unit__3321960f897f R
fct_rate_term_payment_frequency_price.organization_unit_id erp_v2_fct_rate_term_payment_frequency_price_organization_unit_id__erp_v2_dim_organization_unit_organization_u_4c25ab6b3d1a R
fct_revenue.organization_unit_id erp_v2_fct_revenue_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_bab2228f7b9f R
fct_revenue_cash_based.organization_unit_id erp_v2_fct_revenue_cash_based_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_4e9b78b78e53 R
fct_revenue_invoice_based.organization_unit_id erp_v2_fct_revenue_invoice_based_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_f1c5bda0cb26 R
fct_service_usage.organization_unit_id erp_v2_fct_service_usage_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_3e9a8bf6cb0e R
fct_trainer_appointment.organization_unit_id erp_v2_fct_trainer_appointment_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_d785c878b6f4 R
fct_trainer_class_appointments.organization_unit_id erp_v2_fct_trainer_class_appointments_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id__53869137b108 R

The primary key of this table. System column calculated by the source System.
studio_prefix varchar 256 √ null

A unique identifier of the gym that is used as a prefix for the dim_customer.customer_number of it’s customers.
name varchar 256 √ null

The name of the gym.
street varchar 256 √ null

The street name of the gym’s address.
house_number varchar 256 √ null

The house number of the gym’s address.
zip varchar 256 √ null

The postal code of the gym’s address.
city varchar 256 √ null

The city of the gym’s address.
country varchar 256 √ null

The country of the gym’s address.
latitude float8 17,17 √ null

The latitude coordinate of the gym’s location in decimal degrees (WGS84).
longitude float8 17,17 √ null

The longitude coordinate of the gym’s location in decimal degrees (WGS84).
tax_region varchar 256 √ null

The 2-letter ISO 3166 abbreviation of the country the gym is located at.
timezone varchar 256 √ null

The name of the timezone the gym is located at. (Eg. Europe/Berlin)
archived bool 1 √ null

Permanently removed but kept for historic relations.
disabled bool 1 √ null

Temporarily disabled, preventing new customers from signing up to this gym.
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