All changes done on the content or schema of the PerfectGym next Enterprise Data Warehouse are described in the following list, beginning November 2023.

2025-01-09

Include whitelisted companies in dim_company table.

Misc

• Adapted dim_company table to include companies that are whitelisted for the studios related to this DWH instance.

2025-01-07

Summary

Improvements on fct_contract table regarding is_reversed and company_id columns.

Added

• New column fct_contract.is_reversed moved from dim_contract_property.disabled for better visibility

Misc

• Adapted docs on fct_contract and dim_contract_property.disabled
• Adapted fct_contract.company_id to also include companies associated using contract vouchers

Deprecated

• Deprecate column dim_contract_property.disabled in favor of fct_contract.is_reversed

2024-10-10

Summary

Adding new table fct_contract_term_dates

2024-10-04

Summary

Adding adjustment_type to fct_revenue

Added

• Add new column fct_revenue.adjustment_type to determine adjustment or discount

2024-09-12

Summary

Add imported_contract_number to fct_contract

Added

• Add new column imported_contract_number to fct_contract table, to identify contracts imported from a previous system

2024-09-06

Summary

Adding description to fct_revenue

Added

• Add new column fct_revenue.description to describe the revenue entry

2024-08-29

Summary

Add dim_customer_communication_consent table.

Added

• Add new table dim_customer_communication_consent to enable querying categories and channels over which communication to a customer is allowed.

2024-08-24

Summary

Adapt various references and docs to be more agnostic of the source system data is coming from.

Added

• dim_appointment.source: WEBCLIENT
• dim_contract_property.sales_source: WEBCLIENT
• dim_customer.customer_origin: WEBCLIENT
• fct_customer_appointment.booking_source: WEBCLIENT

2024-07-31

Summary

Fix certain entries in fct_revenue mapping to UNCATEGORIZED/UNKNOWN dim_revenue_group.

2024-07-29

Summary

Add contract price history and current price.

Added

• Add new table fct_contract_price_history to enable analytics on contract prices, price changes and the reasons leading to those changes
• Add new column fct_contract.current_monthly_price to enable easy access to the current (adjusted) normalized price of a contract
• Add new column dim_contract_payment_frequency.payment_frequency_current_price to store the current (adjusted) price that will be booked at related frequency

2024-06-18

Summary

Add contract relation to fct_idle_period and email verification status to dim_customer.

Added

• Add new column fct_idle_period.contract_id to enable uniquely relating to idle periods to contracts
• Add new column dim_customer.email_verification_status to identify email addresses that are verified or unverified

2024-05-06

Summary

Add service period and direct contract relation to fct_revenue.

Added

• Add new column fct_revenue.service_period_start_date to get the service period revenue is generated for
• Add new column fct_revenue.service_period_end_date to get the service period revenue is generated for
• Add new column fct_revenue.contract_id to enable uniquely relating to the contract generating revenue (Fct to Fct join possible here due to n:1 relation)

2024-04-26

Summary

Add studio_prefix and imported_customer_number.

Added

• Add new column dim_organization_unit.studio_prefix as a human-readable identifier of a studio
• Add new column dim_customer.imported_customer_number to identify customers imported from a previous system

2024-04-09

Summary

Add ways to identify customers and contracts by customer codes and Corporate Fitness companies.

Added

• Add new table dim_customer_code for codes that are set on customers
• Add new table bridge_customer_to_customer_code to link between customers and customer codes
• Add new table dim_company for companies of Corporate Fitness program
• Add new column fct_contract.company_id to link between contracts and companies

2024-04-05

Summary

Fix fct_contract.rate_id missing on MODULE/FLAT_FEE contracts

2024-03-11

Summary

Cover essential lead conversion metrics.

Added

• Add new table fct_lead_lifetime

2024-03-08

Summary

Add customer_origin to dim_customer

Added

• Add new column customer_origin to dim_customer table

2024-03-06

Summary

Add locale to dim_customer

Added

• Add new column locale to dim_customer table

2024-02-22

Summary

Add payment_frequency information to contracts.

Added

• Add new table dim_contract_payment_frequency
• Add new columns to fct_contract table:
  • contract_payment_frequency_id
  • original_monthly_price
  • original_total_price

2024-02-05

Summary

Enable this Changelog to inform about updates.

2023-11-16

Summary

Improvements of contract related tables.

Added

• Add following new columns to fct_contract table:
  • cancellation_fee
  • cancellation_date_id
  • cancellation_receipt_date_id
  • pre_cancellation_end_date_id
  • contract_cancellation_reason_id
• Add new column contract_status to dim_contract_property table.
• Add new dim_contract_cancellation_reason table.
• Add column fct_contract.cancellation_date_id (renamed from cancelation_date_id)

Removed

• Remove fct_contract.cancelation_date_id (renamed into cancellation_date_id)

Deprecated

• Mark fct_contract_cancellation table as deprecated.
• Mark dim_contract_cancellation_property table as deprecated.
• Mark dim_cancellation_reason table as deprecated.