Core Entities

These are the foundational entities that everything else in the data warehouse revolves around. Every gym location, customer, staff member, and corporate partner is represented here. Understanding these is essential before diving into contracts, revenue, or any other domain.

Term	Definition	Table	Analyst Notes
Organization Unit (Gym/Studio)	A physical gym or studio location — both the place members use and the business entity for contracts. Each gym has a unique studio_prefix (e.g. "AB").	dim_organization_unit	Filter archived = FALSE unless analyzing deleted locations. Use disabled to find temporarily closed gyms.
Customer	A person who has interacted with a gym. Progresses through a lifecycle: Prospect → Member → Former Member. Gets a human-readable number like "AB-123".	dim_customer	Filter archived = FALSE. The customer_number is freed up (set NULL) when archived, so it can be reused.
Employee	A staff member at one or more gyms. Has roles (Studio Owner, Studio Manager, Trainer, Service Employee, etc.). Employees can be managed natively or via Active Directory/SSO.	dim_employee	Filter is_archived = FALSE and status = 'ACTIVE' for current staff. employee_id on contracts = salesperson; NULL = online self-signup.
Company (Corporate Partner)	A business whose employees receive subsidized gym memberships. Companies are "whitelisted" for specific gyms.	dim_company	Filter archived = FALSE. Join to contracts via fct_contract.company_id. Use bridge_company_to_organization_unit for whitelisted gyms.