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 bridge_company_to_organization_unit_organization_unit_id_fkey R
bridge_discount_campaign_to_organization_unit.organization_unit_id bridge_discount_campaign_to_organization_unit_organization_unit_id_fkey R
bridge_organization_unit_to_organization_unit_code.organization_unit_id bridge_organization_unit_to_organization_unit_code_organization_unit_id_fkey R
bridge_product_to_organization_unit.organization_unit_id bridge_product_to_organization_unit_organization_unit_id_fkey R
bridge_service_to_organization_unit.organization_unit_id bridge_service_to_organization_unit_organization_unit_id_fkey R
dim_cash_register.organization_unit_id dim_cash_register_organization_unit_id_fkey R
dim_closing_hours.organization_unit_id dim_closing_hours_organization_unit_id_fkey R
dim_customer_communication_consent.organization_unit_id dim_customer_communication_consent_organization_unit_id_fkey R
dim_customer_group.organization_unit_id dim_customer_group_organization_unit_id_fkey R
dim_idle_period_property.organization_unit_id dim_idle_period_property_organization_unit_id_fkey R
dim_opening_hours.organization_unit_id dim_opening_hours_organization_unit_id_fkey R
dim_purchased_contingent.organization_unit_id dim_purchased_contingent_organization_unit_id_fkey R
dim_studio_starter_package_adjustment.organization_unit_id dim_studio_starter_package_adjustment_organization_unit_id_fkey R
fct_checkin.customer_organization_unit_id fct_checkin_customer_organization_unit_id_fkey R
fct_checkin.organization_unit_id fct_checkin_organization_unit_id_fkey R
fct_class_appointment.organization_unit_id fct_class_appointment_organization_unit_id_fkey R
fct_class_event.organization_unit_id fct_class_event_organization_unit_id_fkey 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 fct_contract_cancellation_organization_unit_id_fkey R
fct_contract_price_history.organization_unit_id fct_contract_price_history_organization_unit_id_fkey R
fct_contract_term_dates.organization_unit_id fct_contract_term_dates_organization_unit_id_fkey R
fct_customer_appointment.organization_unit_id fct_customer_appointment_organization_unit_id_fkey R
fct_customer_studio_history.organization_unit_id fct_customer_studio_history_organization_unit_id_fkey R
fct_employee_access.organization_unit_id fct_employee_access_organization_unit_id_fkey R
fct_idle_period.organization_unit_id fct_idle_period_organization_unit_id_fkey 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 fct_lead_lifetime_organization_unit_id_fkey R
fct_lead_stage_history.organization_unit_id fct_lead_stage_history_organization_unit_id_fkey R
fct_payment.organization_unit_id fct_payment_organization_unit_id_fkey R
fct_payment_instrument_status_history.organization_unit_id fct_payment_instrument_status_history_organization_unit_id_fkey 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 fct_pos_saleposition_organization_unit_id_fkey R
fct_rate_bundle_term_availability.organization_unit_id fct_rate_bundle_term_availability_organization_unit_id_fkey R
fct_rate_term_payment_frequency_price.organization_unit_id fct_rate_term_payment_frequency_price_organization_unit_id_fkey R
fct_revenue.organization_unit_id fct_revenue_organization_unit_id_fkey R
fct_revenue_cash_based.organization_unit_id fct_revenue_cash_based_organization_unit_id_fkey 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 fct_service_usage_organization_unit_id_fkey R
fct_trainer_appointment.organization_unit_id fct_trainer_appointment_organization_unit_id_fkey R
fct_trainer_class_appointments.organization_unit_id fct_trainer_class_appointments_organization_unit_id_fkey 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()

Relationships

Close relationships within degrees of separation