FACILITIES

0 rows


Description

Master table showing facility details

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ACTIVE_HUB_KEY int identity 4 √ null

The Hub record ID
FACILITY_ID int 4 √ null
ACTIVITIES.FACILITY_ID Defined in XML R
ACTIVITY_DATES.FACILITY_ID Defined in XML R
ACTIVITY_PRIVATE_LESSONS.INSTRUCTOR_FACILITY_ID Defined in XML R
ACTIVITY_PRIVATE_LESSONS.LOCATION_FACILITY_ID Defined in XML R
ACTIVITY_RESERVATION_PATTERNS.FACILITY_ID Defined in XML R
AR_SCHEDULED_DETAILS.FACILITY_ID Defined in XML R
CUSTOM_QUESTION_ANSWERS.FACILITY_ID Defined in XML R
DEFERRED_REVENUE_PROJECTIONS.FACILITY_ID Defined in XML R
ENTRY_POINTS.FACILITY_ID Defined in XML R
FACILITY_AVAILABILITY.FACILITY_ID Defined in XML R
FACILITY_HOURS.FACILITY_ID Defined in XML R
FACILITY_LINKS.FACILITY_ID Defined in XML R
FACILITY_OPEN_TIMES.FACILITY_ID Defined in XML R
FACILITY_OVERLAPS.FACILITY_ID Defined in XML R
FACILITY_OVERLAPS.PARENT_FACILITY_ID Defined in XML R
FACILITY_PREREQUISITES.FACILITY_ID Defined in XML R
FACILITY_RENTAL_BLOCKS.FACILITY_ID Defined in XML R
FACILITY_RESERVATION.FACILITY_ID Defined in XML R
FACILITY_USAGE_REVENUE.FACILITY_ID Defined in XML R
FACILITY_USERS.FACILITY_ID Defined in XML R
INSTRUCTORS.INSTRUCTOR_FACILITY_ID Defined in XML R
INTEREST_LISTS.FACILITY_ID Defined in XML R
LEAGUE_FACILITIES.FACILITY_ID Defined in XML R
LEAGUE_SCHEDULE_FACILITIES.FACILITY_ID Defined in XML R
LEAGUE_SCHEDULE_PAIRINGS.FACILITY_ID Defined in XML R
LEAGUE_SCHEDULE_TIMESLOTS.FACILITY_ID Defined in XML R
PACKAGE_ENTRY_POINTS.FACILITY_ID Defined in XML R
RESERVATION_DATE_RANGES.FACILITY_ID Defined in XML R
SESSIONS.FACILITY_ID Defined in XML R
STAGE_SEQUENCE_LINKS.FACILITY_ID Defined in XML R
STANDARD_CHARGES.FACILITY_ID Defined in XML R
TEAMS.HOME_FACILITY_ID Defined in XML R
TRANSACTIONS.FACILITY_ID Defined in XML R
WORKSTATIONS.FACILITY_ID Defined in XML R

Facility ID.
FACILITY_NAME varchar 255 √ null

Facility name.
FACILITY_NUMBER varchar 255 √ null

Facility number.
MAXIMUM_CAPACITY int 4 √ null

The maximum attendance allowed for rentals in this facility.
MINIMUM_CAPACITY int 4 √ null

The minimum attendance required before this facility can be rented.
MODIFIED_DATE datetime 16,3 √ null

The date and time of the last modification to the facility information
LAST_SYNC_TIME datetime 16,3 (getdate())

Date and time Hub record was last modified
ACTIVE_HUB_PROCESS_ID bigint 8 √ null

The Hub sync process ID
MODIFIED_DATE_ONLY date 20 √ null

The date of the last modification to the facility information (date only)
ORG_ID int 4 √ null

Your organization’s unique identifier in the Active Net system
RESOURCE_TYPE varchar 10 √ null

Facility resource type (Facility, Equipment or Instructor).
RETIRED varchar 5 √ null

Whether the facility record has been retired (Yes or No)
FACILITY_TYPE_ID int 4 √ null
FACILITY_TYPES.FACILITY_TYPE_ID Defined in XML R

The ID of the facility type of this facility.
CENTER_ID int 4 √ null
CENTERS.CENTER_ID Defined in XML R

The ID of the center to which this facility belongs.
GEOGRAPHIC_AREA_ID int 4 √ null
GEOGRAPHIC_AREAS.GEOGRAPHIC_AREA_ID Defined in XML R

The ID of the geographic area of this facility
HAS_RESERVATION_DATE_RANGES varchar 5 √ null

Whether this facility is reserved using reservation date range blocks (Yes/No)
ROW_VERSION binary 8 √ null

System timestamp (for internal use)
ITEM_TYPE_ID int 4 √ null

The type of resource that this facility is (0=facilities, 1=equipment, 2=human resource)
OVERRIDE_CENTER_ADDRESS varchar 5 √ null

Whether this facility has an address that is distinct from its center (Yes/No)
ADDRESS1 varchar 35 √ null

The first address line of the facility
ADDRESS2 varchar 35 √ null

The second address line of the facility
CITY varchar 30 √ null

The city of the facility address
STATE varchar 15 √ null

The state of the facility address
ZIPCODE varchar 10 √ null

The postal code of the facility address
COUNTRY varchar 2 √ null

The country code of the facility address
LATITUDE numeric 11,6 √ null

The latitude for the facility location
LONGITUDE numeric 11,6 √ null

The longitude for the facility location
FACILITY_DESCRIPTION varchar 8000 √ null

The facility description
FACILITY_NOTES varchar 8000 √ null

Notes related to the facility
OPEN_24_HOURS varchar 5 √ null

Whether the facility is open 24 hours per day (Yes/No)
DEFAULT_OPEN_TIME time 16 √ null

The default opening time for the facility
DEFAULT_CLOSE_TIME time 16 √ null

The default closing time for the facility
MONDAY_CLOSED varchar 5 √ null

Whether the facility is closed on Mondays (Yes/No)
TUESDAY_CLOSED varchar 5 √ null

Whether the facility is closed on Tuesdays (Yes/No)
WEDNESDAY_CLOSED varchar 5 √ null

Whether the facility is closed on Wednesdays (Yes/No)
THURSDAY_CLOSED varchar 5 √ null

Whether the facility is closed on Thursdays (Yes/No)
FRIDAY_CLOSED varchar 5 √ null

Whether the facility is closed on Fridays (Yes/No)
SATURDAY_CLOSED varchar 5 √ null

Whether the facility is closed on Saturdays (Yes/No)
SUNDAY_CLOSED varchar 5 √ null

Whether the facility is closed on Sundays (Yes/No)
RESERVATION_PERIOD_UNIT varchar 20 √ null

The reservation period unit to be used when booking this facility of this type (Use Default / Minute / Hour / Day / Week / Month / Defined Date Range / Rental Block / Overnight)
MINIMUM_RESERVATION_TIME_UNITS int 4 √ null

The minimum number of reservation time units that may be booked
MAXIMUM_RESERVATION_TIME_UNITS int 4 √ null

The maximum number of reservation time units that may be booked
WEEKLY_RESERVATION_STARTS_ON varchar 10 √ null

Day of the week that weekly reservations start on
EXCLUDE_FROM_LEAGUE_SCHEDULING varchar 5 √ null

Whether this facility should be excluded from league scheduling (Yes/No)
ALLOW_CONFLICTS varchar 5 √ null

Whether this facility should allow conflicting bookings (Yes/No)
ALLOW_OVERLAPPED_RENTAL_BLOCKS varchar 5 √ null

Whether this facility should allow overlapping rental blocks (Yes/No)
MAX_RESERVATIONS_PER_CUSTOMER_PER_DAY int 4 √ null

Maximum reservations per customer per day at this facility
DISCLAIMER_ID int 4 √ null
DISCLAIMERS.DISCLAIMER_ID Defined in XML R

The ID of the disclaimer required for this facility
PREP_CODE_ID int 4 √ null
PREP_CODES.PREP_CODE_ID Defined in XML R

The prep code ID for required setup and teardown time
SEND_SUPERVISOR_EMAIL_RESERVATION_NOTIFICATION varchar 15 √ null

Whether the supervisor should be sent a notification email for reservations created at this facility (Yes, No, Use Default)
RESERVATION_NOTIFICATION_EMAIL_ADDRESS varchar 8000 √ null

Additional email addresses that should be included in the reservation notification email
DEFAULT_CHECKIN_TIME time 16 √ null

The default check-in time for the facility
DEFAULT_CHECKOUT_TIME time 16 √ null

The default checkout time for facilities for the facility
FIXED_DEFAULT_CHECKIN_TIME varchar 5 √ null

Whether there is a fixed check-in time for online reservations (Yes/No)
FIXED_DEFAULT_CHECKOUT_TIME varchar 5 √ null

Whether there is a fixed checkout time for online reservations (Yes/No)
LIGHTING_ID varchar 25 √ null

The lighting system integration ID for this facility
CENTER_LIGHTING_ID_OVERRIDE varchar 25 √ null

The lighting system integration ID to be used for the center, rather than the one defined at the center
MAX_DRESSING_ROOM_NUMBER int 4 √ null

The maximum dressing room number for this facility
HIDE_ON_INTERNET varchar 5 √ null

Whether the facility should be hidden from display online (Yes/No)
PROHIBIT_INTERNET_PERMITS varchar 5 √ null

Whether the facility should prohibit permit bookings (Yes/No)
INTERNET_RESERVATION_TYPE varchar 25 √ null

The type of reservation process that should be used online for this facility (Regular Reservation, Continuous Reservation, Use Site Reservation Type)
INTERNET_RESERVATION_PROCESS varchar 20 √ null

The reservation process that should be used online for this facility (Reservation Request, Permit, –No Override–)
OVERRIDE_SYSTEM_ONLINE_SETTINGS varchar 5 √ null

Whether system level settings should be overridden for online reservations (Yes/No)
ONLINE_MIN_RESERVATION_ADVANCE_UNITS int 4 √ null

The number of time units used for determining the advanced online reservation minimum period for this equipment
ONLINE_MIN_RESERVATION_ADVANCE_UNIT_TYPE varchar 10 √ null

The type of time unit used for determining the advanced online reservation minimum period for this equipment (Days, Hours)
ONLINE_NON_RESIDENT_MIN_RESERVATION_ADVANCE_UNITS int 4 √ null

The number of time units used for determining the advanced online reservation minimum period for non-residents for this equipment
ONLINE_NON_RESIDENT_MIN_RESERVATION_ADVANCE_UNIT_TYPE varchar 10 √ null

The type of time unit used for determining the advanced online reservation minimum period for non-residents for this equipment (Days, Hours)
ONLINE_MAX_RESERVATION_ADVANCE_UNITS int 4 √ null

The number of time units used for determining the advanced online reservation maximum period for this equipment
ONLINE_MAX_RESERVATION_ADVANCE_UNIT_TYPE varchar 10 √ null

The type of time unit used for determining the advanced online reservation maximum period for this equipment (Days, Hours)
ONLINE_NON_RESIDENT_MAX_RESERVATION_ADVANCE_UNITS int 4 √ null

The number of time units used for determining the advanced online reservation maximum period for non-residents for this equipment
ONLINE_NON_RESIDENT_MAX_RESERVATION_ADVANCE_UNIT_TYPE varchar 10 √ null

The type of time unit used for determining the advanced online reservation maximum period for non-residents for this equipment (Days, Hours)
ONLINE_MAX_RESERVATION_EXTEND_UNITS int 4 √ null

The number of time units used for determining the advanced online extended reservation period for this equipment
ONLINE_MAX_RESERVATION_EXTEND_UNIT_TYPE varchar 10 √ null

The type of time unit used for determining the advanced online extended reservation period for this equipment (Days, Hours)
ONLINE_NON_RESIDENT_MAX_RESERVATION_EXTEND_UNITS int 4 √ null

The number of time units used for determining the advanced online extended reservation period for non-residents for this equipment
ONLINE_NON_RESIDENT_MAX_RESERVATION_EXTEND_UNIT_TYPE varchar 10 √ null

The type of time unit used for determining the advanced online extended reservation period for non-residents for this equipment (Days, Hours)
OVERRIDE_SYSTEM_STAFF_SETTINGS varchar 5 √ null

Whether system level settings should be overridden for staff reservations (Yes/No)
STAFF_MIN_RESERVATION_ADVANCE_UNITS int 4 √ null

The number of time units used for determining the advanced staff reservation minimum period for this equipment
STAFF_MIN_RESERVATION_ADVANCE_UNIT_TYPE varchar 10 √ null

The type of time unit used for determining the advanced staff reservation minimum period for this equipment (Days, Hours)
STAFF_MAX_RESERVATION_ADVANCE_UNITS int 4 √ null

The number of time units used for determining the advanced staff reservation maximum period for this equipment
STAFF_MAX_RESERVATION_ADVANCE_UNIT_TYPE varchar 10 √ null

The type of time unit used for determining the advanced staff reservation maximum period for this equipment (Days, Hours)
ONLINE_ADVANCE_RESERVATION_DAILY_OPEN_TIME time 16 √ null

The start time that online reservations open on the first advanced booking day
EQUIPMENT_STATUS varchar 10 √ null

The current status of this equipment (Available, Damaged, Lost, Out, Retired, Pending, Unknown)
DEFAULT_LENDING_QUANTITY int 4 √ null

The default lending quantity for this equipment
LENDING_LIMIT_PER_CUSTOMER int 4 √ null

The lending quantity limit per customer for this equipment
DEFAULT_CHECK_OUT_OPTION varchar 25 √ null

The default check-out option for this equipment (Free early check-out, Charge early check-out, No early check-out)
DEFAULT_CHECK_IN_OPTION varchar 25 √ null

The default check-in option for this equipment (Free late check-in, Charge late check-in)
DEFAULT_LENDING_SIGN_IN_STATUS varchar 10 √ null

The default status for this equipment upon check-in (Available, Pending, Unknown)
ALLOW_USE_BY_ACTIVITIES varchar 5 √ null

Whether this equipment can be used for activities (Yes/No)
QUANTITY_USABLE_BY_ACTIVITIES int 4 √ null

The quantity of this equipment can be used for activities
ALLOW_USE_BY_PUBLIC varchar 5 √ null

Whether this equipment can be used by the public (Yes/No)
QUANTITY_USABLE_BY_PUBLIC int 4 √ null

The quantity of this equipment can be used by the public
TOTAL_QUANTITY int 4 √ null

The total quantity of this equipment
QUANTITY_PENDING int 4 √ null

The current quantity of this equipment that is in a pending status
QUANTITY_ON_LOAN int 4 √ null

The current quantity of this equipment that is loaned out
SHOW_ON_CAPTIVATE_APP varchar 5 √ null

Whether this facility should be shown on the ACTIVE Net Captivate App (Yes/No)
CAPTIVATE_APP_IMAGE_ID int 4 √ null
UPLOADED_FILES.UPLOADED_FILE_ID Defined in XML R

The ID of the image that should be shown on the ACTIVE Net Captivate App for this facility
INCLUDE_SETUP varchar 5 √ null

Whether the setup time in the related preparation code should be applied to reservations in this facility (Yes/No)
INCLUDE_CLEANUP varchar 5 √ null

Whether the cleanup time in the related preparation code should be applied to reservations in this facility (Yes/No)
ALLOW_DOUBLE_BOOKING varchar 5 √ null

Whether double booking is allowed for this facility (Yes/No)
DOUBLE_BOOKING_RESTRICTIONS varchar 5 √ null

Whether double booking restrictions should be enforced (Yes/No)
DISPLAY_FULL_DAY_SWITCH_ONLINE varchar 5 √ null

Whether the ‘Full day booking’ switch should be displayed online for this facility (Yes/No)
RESOURCE_ALERT_CONTENT varchar 4000 √ null

The Pop-up alert content for facility and equipment

Indexes

Constraint Name Type Sort Column(s)
FACILITIES_PK Primary key Asc ACTIVE_HUB_KEY
FACILITIES_CENTER_ID_IX Performance Asc CENTER_ID
FACILITIES_FACILITY_ID_ORG_ID_UQ Must be unique Asc/Asc FACILITY_ID + ORG_ID
FACILITIES_FACILITY_TYPE_ID_IX Performance Asc FACILITY_TYPE_ID
FACILITIES_GEOGRAPHIC_AREA_ID_IX Performance Asc GEOGRAPHIC_AREA_ID
FACILITIES_ITEM_TYPE_ID_IX Performance Asc ITEM_TYPE_ID
FACILITIES_ROW_VERSION_IX Performance Asc ROW_VERSION

Relationships

Close relationships within degrees of separation