Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| FACILITY_ID | int | 4 | √ | null |
|
Facility ID. |
|||||
| FACILITY_NAME | varchar | 255 | √ | null |
|
|
Facility name. |
||||
| FACILITY_NUMBER | varchar | 255 | √ | null |
|
|
Facility number. |
||||
| ITEM_TYPE_ID | int | 4 | √ | null |
|
|
The type of resource that this facility is (0=facilities, 1=equipment, 2=human resource) |
||||
| RESOURCE_TYPE | varchar | 10 | √ | null |
|
|
Facility resource type (Facility, Equipment or Instructor). |
||||
| FACILITY_TYPE_ID | int | 4 | √ | null |
|
|
The ID of the facility type of this facility. |
||||
| FACILITY_TYPE | varchar | 80 | √ | null |
|
|
Facility type. |
||||
| CENTER_ID | int | 4 | √ | null |
|
|
The ID of the center to which this facility belongs. |
||||
| CENTER_NAME | varchar | 255 | √ | null |
|
|
Name of the center to which this facility belongs. |
||||
| 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 |
||||
| GEOGRAPHIC_AREA_ID | int | 4 | √ | null |
|
|
The ID of the geographic area of this facility |
||||
| GEOGRAPHIC_AREA | varchar | 80 | √ | null |
|
|
Geographic Area description |
||||
| 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) |
||||
| 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. |
||||
| 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) |
||||
| 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) |
||||
| DISPLAY_FULL_DAY_SWITCH_ONLINE | varchar | 5 | √ | null |
|
|
Whether the ‘Full day booking’ switch should be displayed online for this facility (Yes/No) |
||||
| ALLOW_OVERLAPPED_RENTAL_BLOCKS | varchar | 5 | √ | null |
|
|
Whether this facility should allow overlapping rental blocks (Yes/No) |
||||
| MAX_ATTENDANCE_AT_ONE_TIME | int | 4 | √ | null |
|
|
The total quantity of this equipment |
||||
| MAX_RESERVATIONS_PER_CUSTOMER_PER_DAY | int | 4 | √ | null |
|
|
Maximum reservations per customer per day at this facility |
||||
| DISCLAIMER_ID | int | 4 | √ | null |
|
|
The ID of the disclaimer required for this facility |
||||
| DISCLAIMER_NAME | varchar | 30 | √ | null |
|
|
The name of the disclaimer required for this facility |
||||
| PREP_CODE_ID | int | 4 | √ | null |
|
|
The prep code ID for required setup and teardown time |
||||
| PREP_CODE_NAME | varchar | 30 | √ | null |
|
|
The prep code name for required setup and teardown time |
||||
| 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) |
||||
| 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 |
||||
| 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 |
|
|
The ID of the image that should be shown on the ACTIVE Net Captivate App for this facility |
||||
| CAPTIVATE_APP_IMAGE | varchar | 50 | √ | null |
|
|
The name of the image that should be shown on the ACTIVE Net Captivate App for this facility |
||||
| HAS_RESERVATION_DATE_RANGES | varchar | 5 | √ | null |
|
|
Whether this facility is reserved using reservation date range blocks (Yes/No) |
||||
| MODIFIED_DATE | datetime | 16,3 | √ | null |
|
|
The date and time of the last modification to the facility information |
||||
| MODIFIED_DATE_ONLY | date | 20 | √ | null |
|
|
The date of the last modification to the facility information (date only) |
||||
| RETIRED | varchar | 5 | √ | null |
|
|
Whether the facility record has been retired (Yes or No) |
||||
| RESOURCE_ALERT_CONTENT | varchar | 4000 | √ | null |
|
|
The Pop-up alert content for facility and equipment |
||||
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |
||||
| LAST_SYNC_TIME | datetime | 16,3 | null |
|
|
Date and time Hub record was last modified |
|||||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
The Hub sync process ID |
||||
| source_id | int | 4 | √ | null |
|
|
The ID value from the Active Net system |