Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| EQUIPMENT_ID | int | 4 | √ | null |
|
|
Equipment ID. |
|
| EQUIPMENT_NAME | varchar | 255 | √ | null |
|
|
Equipment name. |
|
| EQUIPMENT_NUMBER | varchar | 255 | √ | null |
|
|
Equipment number. |
|
| ITEM_TYPE_ID | int | 4 | √ | null |
|
|
The type of resource that this facility is (0=facility, 1=equipment, 2=human resource) |
|
| RESOURCE_TYPE | varchar | 10 | √ | null |
|
|
Facility resource type (Facility, Equipment or Instructor). |
|
| EQUIPMENT_TYPE_ID | int | 4 | √ | null |
|
|
The ID of the equipment type of this equipment. |
|
| EQUIPMENT_TYPE | varchar | 80 | √ | null |
|
|
Equipment type. |
|
| CENTER_ID | int | 4 | √ | null |
|
|
The ID of the center to which this equipment belongs. |
|
| CENTER_NAME | varchar | 255 | √ | null |
|
|
Name of the center to which this equipment belongs. |
|
| EQUIPMENT_DESCRIPTION | varchar | 8000 | √ | null |
|
|
The equipment description |
|
| EQUIPMENT_NOTES | varchar | 8000 | √ | null |
|
|
Notes related to the equipment |
|
| OPEN_24_HOURS | varchar | 5 | √ | null |
|
|
Whether the equipment is available 24 hours per day (Yes/No) |
|
| DEFAULT_OPEN_TIME | time | 16 | √ | null |
|
|
The default opening time for the equipment |
|
| DEFAULT_CLOSE_TIME | time | 16 | √ | null |
|
|
The default closing time for the equipment |
|
| MONDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the equipment is closed on Mondays (Yes/No) |
|
| TUESDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the equipment is closed on Tuesdays (Yes/No) |
|
| WEDNESDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the equipment is closed on Wednesdays (Yes/No) |
|
| THURSDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the equipment is closed on Thursdays (Yes/No) |
|
| FRIDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the equipment is closed on Fridays (Yes/No) |
|
| SATURDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the equipment is closed on Saturdays (Yes/No) |
|
| SUNDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the equipment is closed on Sundays (Yes/No) |
|
| RESERVATION_PERIOD_UNIT | varchar | 20 | √ | null |
|
|
The reservation period unit to be used when booking this equipment 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 |
|
| DISCLAIMER_ID | int | 4 | √ | null |
|
|
The ID of the disclaimer required for this equipment |
|
| DISCLAIMER_NAME | varchar | 30 | √ | null |
|
|
The name of the disclaimer required for this equipment |
|
| 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 |
|
| SEND_SUPERVISOR_EMAIL_RESERVATION_NOTIFICATION | varchar | 15 | √ | null |
|
|
Whether the supervisor should be sent a notification email for reservations created for this equipment (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 equipment |
|
| DEFAULT_CHECKOUT_TIME | time | 16 | √ | null |
|
|
The default checkout time for the equipment |
|
| 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) |
|
| HIDE_ON_INTERNET | varchar | 5 | √ | null |
|
|
Whether the equipment should be hidden from display online (Yes/No) |
|
| PROHIBIT_INTERNET_PERMITS | varchar | 5 | √ | null |
|
|
Whether the equipment should prohibit permit bookings (Yes/No) |
|
| INTERNET_RESERVATION_TYPE | varchar | 25 | √ | null |
|
|
The type of reservation process that should be used online for this equipment (Regular Reservation, Continuous Reservation, Use Site Reservation Type) |
|
| INTERNET_RESERVATION_PROCESS | varchar | 20 | √ | null |
|
|
The reservation process that should be used online for this equipment (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 equipment should be shown on the ACTIVE Net Captivate App (Yes/No) |
|
| MODIFIED_DATE | datetime | 16,3 | √ | null |
|
|
The date and time of the last modification to the equipment information |
|
| MODIFIED_DATE_ONLY | date | 20 | √ | null |
|
|
The date of the last modification to the equipment information (date only) |
|
| RETIRED | varchar | 5 | √ | null |
|
|
Whether the equipment record has been retired (Yes or No) |
|
| 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 |