Introduction
The Facility Booking Definition Summary report provides a comprehensive overview of how club facilities and zones are configured for bookings. It delivers key insights into booking rules, duration settings, pricing structures, and historical contract charges associated with different facility areas. The primary purpose of this document is to help staff audit facility setups, ensuring that availability, pricing, and restrictions are correctly applied across the business. This report is best for club managers and facility administrators who need to review booking definitions, usage rules, and pricing history to maintain accurate club operations.
Before you start
To access this report, please add the following employee permissions to the suitable employee roles in PGM->Clubs->Employee permissions.
- Reports
- Facility Booking
- Facility booking definition summary report
- Facility Booking
Feature description
To access the report, go to PGM-> Reports ->All
Either using the search filter, find 'Facility booking definition summary' or select Facility booking tab and find the report.
Understanding the Filters
When generating the report, you will be prompted to select filters to narrow down your data.
Club: Select the specific club location you wish to run the report for. For example, selecting "Downtown Fitness" will only show booking configurations for that specific club.
Club Zone Types: Select one or more categories of club zones you want to review. For example, you can select "Tennis Courts" or "Swimming Pools" to only see booking rules related to those specific facility types.
Press XLSX to generate the report.
Report Output
Tab 1: ByClubZoneType
This section groups facility booking definitions and rules by the overarching category of the club zone.
ClubName: Displays the name of the club.
ClubZoneTypeId: The unique system identification number for the zone type.
Club Zone Type Name: The descriptive name of the zone category, such as 'Squash Court'.
FacilityBookingDefinitionId: The unique system identifier for the booking configuration.
Facility Booking Definition Name: The descriptive name of the booking rule setup.
FacilityBookingRuleId: The unique system identification number for the specific rule applied to the booking.
FacilityBookingDefinitionIsActive: Indicates whether this booking definition is currently turned on.
BookingAvailableForApps: Lists the names of the applications where this booking can be made.
BoookingPurpose: The intended use of the booking, such as 'Recreation' or 'Competition'.
IsEntireZoneBooking: Indicates if this setup books the entire zone.
NumberOfRequiredSlots: Shows how many booking slots are needed for a standard reservation.
MaxNumberOfSlotsPerBooking: Shows the maximum number of slots a user can book at one time.
BookingDuration: Displays the length of the booking in hours and minutes.
BookingIntervalInMinutes: The time block interval used on the booking calendar.
SetupTimeInMinutes: The buffer time allocated before a booking begins.
CooldownInMinutes: The buffer time allocated after a booking ends.
DailyAvailability: Shows the specific days the facility is available.
HourlyAvailability: Shows the specific hours during the day the facility is available.
RequiredContract: Indicates if a specific membership contract is required to make the booking.
RequiredPaymentPlanName: Displays the name of the payment plan required, if applicable.
AdditionalCharge: Shows any extra fees associated with this booking rule.
ContractPaymentMethod: Details the method used to pay for the required contract.
CurrentCharge: The gross price currently charged for the facility booking.
IsDebtAllowed: Indicates whether a user can book the facility with an outstanding balance.
ProductId: The unique system identification number for the booking product.
ProductName: The name of the product linked to this booking.
CurrentPrice: The standard price of the linked product.
ProductSoldAtClub: Lists the clubs where this booking product can be purchased.
ProductSoldAtApp: Lists the apps where this booking product can be purchased.
SharedBookingLimitName: This column shows the name of a booking limit if it applies across multiple areas. For example, if the rule is marked as a shared limit in the system (IsSharedLimit = 1), it will output the limit's name; otherwise, it will be left blank.
BookingLimitCount: The maximum number of times the facility can be booked under this rule.
BookingLimitPeriods: The time frame that the booking limit count applies to.
BookingLimitType: The category of the booking limit (e.g., per week, per month).
RefundLimitType: The category of restrictions placed on refunds.
RefundLimitCount: The maximum number of refunds allowed.
RefundPolicy: Describes the rules regarding how and when refunds are issued.
MakeUpProductName: The name of the product granted as compensation if a booking is missed or canceled.
MinimumNoticePeriod: The required warning time in minutes before a booking occurs.
MaxTimeToCancelForReturn: The deadline in minutes to cancel a booking and still receive a return.
MaxTimeToBookInAdvance: The furthest time in advance a user is allowed to make a booking.
AgeLimitName: Displays combined age restrictions. For example, it pieces together the minimum age, maximum age, and limit type to output text like '18-99 Adult'.
Tab 2: ByClubZone
This section breaks down the facility booking definitions by the specific physical zones within the club.
ClubName: Displays the name of the club.
ClubZoneTypeId: The unique identifier for the zone's overarching category.
Club Zone Type Name: The descriptive category name.
ClubZoneId: The unique system identification number for the specific physical zone.
Club Zone Name: The name of the specific physical zone, such as 'Tennis Court 1'.
FacilityBookingDefinitionId: The system identifier for the booking configuration.
Facility Booking Definition Name: The descriptive name of the booking setup.
FacilityBookingRuleId: The system identifier for the booking rule.
FacilityBookingDefinitionIsActive: Shows if the booking definition is currently on.
BookingAvailableForApps: Names of applications where this can be booked.
BoookingPurpose: The intended use of the booking.
IsEntireZoneBooking: Shows if this books the entire zone.
NumberOfRequiredSlots: The standard number of slots needed.
MaxNumberOfSlotsPerBooking: The maximum slots allowed at once.
BookingDuration: The length of the booking.
BookingIntervalInMinutes: The calendar interval block.
SetupTimeInMinutes: Preparation time before a booking.
CooldownInMinutes: Clean-up time after a booking.
DailyAvailability: Available days.
HourlyAvailability: Available hours.
RequiredContract: Any contract required to book.
RequiredPaymentPlanName: Any payment plan required to book.
AdditionalCharge: Any extra fees applied.
ContractPaymentMethod: The method of paying for the contract.
CurrentCharge: The active gross price.
IsDebtAllowed: If users in debt can book.
ProductId: Identifier for the related product.
ProductName: The name of the related product.
CurrentPrice: The price of the related product.
ProductSoldAtClub: Locations selling this product.
ProductSoldAtApp: Apps selling this product.
SharedBookingLimitName: This column shows the name of a booking limit if it applies across multiple areas. For example, if the rule is marked as a shared limit in the system (IsSharedLimit = 1), it will output the limit's name; otherwise, it will be blank.
BookingLimitCount: Max bookings allowed.
BookingLimitPeriods: Time period for the max bookings limit.
BookingLimitType: Category of the booking limit.
RefundLimitType: Category of refund restrictions.
RefundLimitCount: Max refunds allowed.
RefundPolicy: The rules for issuing refunds.
MakeUpProductName: Compensation product for missed bookings.
MinimumNoticePeriod: Warning time required.
MaxTimeToCancelForReturn: Cancellation deadline for a refund.
MaxTimeToBookInAdvance: Furthest advance booking time allowed.
AgeLimitName: Displays combined age restrictions (e.g., minimum and maximum age ranges).
Tab 3: ContractPriceHistory
This section provides a historical log of the pricing schedule for facility booking contracts.
ClubName: Displays the name of the club.
ClubZoneTypeId: The unique identifier for the overarching zone category.
Club Zone Type Name: The descriptive category name of the zone.
FacilityBookingDefinitionId: The system identifier for the booking configuration.
Facility Booking Definition Name: The descriptive name of the booking setup.
FacilityBookingRuleId: The system identifier for the booking rule tied to this price.
ContractPaymentMethod: Details the method used to pay for the required contract.
FacilityBookingRulePricingScheduleItemId: The unique system identifier for this specific pricing history entry.
PriceEffectiveFrom: Displays the date when this specific price became active.
GrossPrice: Shows the total charge amount for the facility booking on that date.
IsCurrentPrice: Identifies the active price on the account. For example, if the system determines the schedule date is today or earlier and is the most recent entry, it outputs '1' (True/Yes), otherwise, it outputs '0' (False/No) for historical prices.
Hints
To easily review active configurations versus historical ones, apply a filter in Excel on the IsCurrentPrice column in the 'ContractPriceHistory' tab.
Cross-reference the FacilityBookingDefinitionIsActive column in the first two tabs to quickly weed out old or discontinued booking rules.