Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||||||||||||||||||||
| CENTER_ID | int | 4 | √ | null |
|
|
The center record ID |
||||||||||||||||||||||
| CENTER_NAME | varchar | 255 | √ | null |
|
|
The name of the center |
||||||||||||||||||||||
| CENTER_DESCRIPTION | varchar | 8000 | √ | null |
|
|
The description of the center |
||||||||||||||||||||||
| CENTER_NOTES | varchar | 8000 | √ | null |
|
|
User entered notes related to the center |
||||||||||||||||||||||
| SITE_ID | int | 4 | √ | null |
|
|
The ID of the site that the center belongs to |
||||||||||||||||||||||
| SITE_NAME | varchar | 255 | √ | null |
|
|
The name of the site that the center belongs to |
||||||||||||||||||||||
| ADDRESS1 | varchar | 255 | √ | null |
|
|
The first address line of the center. |
||||||||||||||||||||||
| ADDRESS2 | varchar | 255 | √ | null |
|
|
The second address line of the center. |
||||||||||||||||||||||
| CITY | varchar | 255 | √ | null |
|
|
The city of the center. |
||||||||||||||||||||||
| STATE | varchar | 255 | √ | null |
|
|
The state of the center. |
||||||||||||||||||||||
| ZIPCODE | varchar | 255 | √ | null |
|
|
The zip code of the center. |
||||||||||||||||||||||
| COUNTRY | varchar | 255 | √ | null |
|
|
The country of the center. |
||||||||||||||||||||||
| PHONE1 | varchar | 255 | √ | null |
|
|
The center’s first phone number |
||||||||||||||||||||||
| PHONE2 | varchar | 255 | √ | null |
|
|
The center’s second phone number |
||||||||||||||||||||||
| PHONE_FAX | varchar | 255 | √ | null |
|
|
The center’s fax phone number |
||||||||||||||||||||||
| GEOGRAPHIC_AREA_ID | int | 4 | √ | null |
|
|
The center’s geographic area ID |
||||||||||||||||||||||
| GEOGRAPHIC_AREA | varchar | 80 | √ | null |
|
|
The center’s geographic area description |
||||||||||||||||||||||
| LATITUDE | money | 21,4 | √ | null |
|
|
The latitude of the center’s address. |
||||||||||||||||||||||
| LONGITUDE | money | 21,4 | √ | null |
|
|
The longitude of the center’s address. |
||||||||||||||||||||||
| SUPERVISOR_ID | int | 4 | √ | null |
|
|
The ID of the center’s supervisor |
||||||||||||||||||||||
| SUPERVISOR_NAME | varchar | 511 | null |
|
|
The name of the center’s supervisor |
|||||||||||||||||||||||
| WEB_PAGE_URL | varchar | 100 | √ | null |
|
|
The web site URL to be displayed for this center |
||||||||||||||||||||||
| THUMBNAIL_URL | varchar | 100 | √ | null |
|
|
The thumbnail URL to be displayed for this center |
||||||||||||||||||||||
| CENTER_SIZE | varchar | 50 | √ | null |
|
|
A description of the size of this center |
||||||||||||||||||||||
| ADA_COMPLIANCE | varchar | 50 | √ | null |
|
|
A description of the ADA compliance of this center |
||||||||||||||||||||||
| PARKING_CAPACITY | int | 4 | √ | null |
|
|
The parking capacity at this center |
||||||||||||||||||||||
| LIGHTING_ID | varchar | 25 | √ | null |
|
|
The lighting system integration ID for this center |
||||||||||||||||||||||
| IS_MAP_ENABLED | varchar | 5 | √ | null |
|
|
Whether map display is enabled for this center (Yes/No) |
||||||||||||||||||||||
| DEFAULT_OPEN_TIME | time | 16 | √ | null |
|
|
The default daily opening time of the center |
||||||||||||||||||||||
| DEFAULT_CLOSE_TIME | time | 16 | √ | null |
|
|
The default daily closing time of the center |
||||||||||||||||||||||
| MONDAY_OPEN_TIME | time | 16 | √ | null |
|
|
The Monday opening time of the center if different than the default |
||||||||||||||||||||||
| MONDAY_CLOSE_TIME | time | 16 | √ | null |
|
|
The Monday closing time of the center if different than the default |
||||||||||||||||||||||
| MONDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the center is closed on Mondays (Yes/No) |
||||||||||||||||||||||
| TUESDAY_OPEN_TIME | time | 16 | √ | null |
|
|
The Tuesday opening time of the center if different than the default |
||||||||||||||||||||||
| TUESDAY_CLOSE_TIME | time | 16 | √ | null |
|
|
The Tuesday closing time of the center if different than the default |
||||||||||||||||||||||
| TUESDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the center is closed on Tuesdays (Yes/No) |
||||||||||||||||||||||
| WEDNESDAY_OPEN_TIME | time | 16 | √ | null |
|
|
The Wednesday opening time of the center if different than the default |
||||||||||||||||||||||
| WEDNESDAY_CLOSE_TIME | time | 16 | √ | null |
|
|
The Wednesday closing time of the center if different than the default |
||||||||||||||||||||||
| WEDNESDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the center is closed on Wednesdays (Yes/No) |
||||||||||||||||||||||
| THURSDAY_OPEN_TIME | time | 16 | √ | null |
|
|
The Thursday opening time of the center if different than the default |
||||||||||||||||||||||
| THURSDAY_CLOSE_TIME | time | 16 | √ | null |
|
|
The Thursday closing time of the center if different than the default |
||||||||||||||||||||||
| THURSDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the center is closed on Thursdays (Yes/No) |
||||||||||||||||||||||
| FRIDAY_OPEN_TIME | time | 16 | √ | null |
|
|
The Friday opening time of the center if different than the default |
||||||||||||||||||||||
| FRIDAY_CLOSE_TIME | time | 16 | √ | null |
|
|
The Friday closing time of the center if different than the default |
||||||||||||||||||||||
| FRIDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the center is closed on Fridays (Yes/No) |
||||||||||||||||||||||
| SATURDAY_OPEN_TIME | time | 16 | √ | null |
|
|
The Saturday opening time of the center if different than the default |
||||||||||||||||||||||
| SATURDAY_CLOSE_TIME | time | 16 | √ | null |
|
|
The Saturday closing time of the center if different than the default |
||||||||||||||||||||||
| SATURDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the center is closed on Saturdays (Yes/No) |
||||||||||||||||||||||
| SUNDAY_OPEN_TIME | time | 16 | √ | null |
|
|
The Sunday opening time of the center if different than the default |
||||||||||||||||||||||
| SUNDAY_CLOSE_TIME | time | 16 | √ | null |
|
|
The Sunday closing time of the center if different than the default |
||||||||||||||||||||||
| SUNDAY_CLOSED | varchar | 5 | √ | null |
|
|
Whether the center is closed on Sundays (Yes/No) |
||||||||||||||||||||||
| OVERRIDE_RETURNING_RENTER_CRITERIA | varchar | 5 | √ | null |
|
|
Whether the returning renter criteria for facilities at this center should override the system setting (Yes/No) |
||||||||||||||||||||||
| FACILITY_RETURNING_RENTER_RESERVATION_CRITERIA | varchar | 40 | √ | null |
|
|
The customer qualifies to be considered as a facility returning renter if they have reserved (None / Same Facility / Same Facility Type, same Center / Same Facility Type, any Center) |
||||||||||||||||||||||
| FACILITY_RETURNING_RENTER_TIME_CRITERIA | varchar | 30 | √ | null |
|
|
The customer qualifies to be considered as a facility returning renter if they have reserved within (Previous Rental Period / Previous Year / Other Period) |
||||||||||||||||||||||
| FACILITY_RETURNING_RENTER_TIME_CRITERIA_OTHER_VALUE | int | 4 | √ | null |
|
|
The customer qualifies to be considered as a facility returning renter if they have reserved within other duration |
||||||||||||||||||||||
| FACILITY_RETURNING_RENTER_TIME_CRITERIA_OTHER_UNIT | varchar | 10 | √ | null |
|
|
The customer qualifies to be considered as a facility returning renter if they have reserved within other unit (Years / Months / Days) |
||||||||||||||||||||||
| LOCKER_RETURNING_RENTER_RESERVATION_CRITERIA | varchar | 40 | √ | null |
|
|
The customer qualifies to be considered as a locker returning renter if they have reserved (None / Same Locker / Same Locker Bank / Same Locker Group / Same Center) |
||||||||||||||||||||||
| LOCKER_RETURNING_RENTER_TIME_CRITERIA | varchar | 30 | √ | null |
|
|
The customer qualifies to be considered as a locker returning renter if they have reserved within (Previous Rental Period / Previous Year / Other Period) |
||||||||||||||||||||||
| LOCKER_RETURNING_RENTER_TIME_CRITERIA_OTHER_VALUE | int | 4 | √ | null |
|
|
The customer qualifies to be considered as a locker returning renter if they have reserved within other duration |
||||||||||||||||||||||
| LOCKER_RETURNING_RENTER_TIME_CRITERIA_OTHER_UNIT | varchar | 10 | √ | null |
|
|
The customer qualifies to be considered as a locker returning renter if they have reserved within other unit (Years / Months / Days) |
||||||||||||||||||||||
| RETIRED | varchar | 5 | √ | null |
|
|
Whether the center record has been retired (Yes/No) |
||||||||||||||||||||||
| HIDE_ON_INTERNET_REGISTRATION | varchar | 5 | √ | null |
|
|
Whether this center should be excluded from display on the internet registration site (Yes/No) |
||||||||||||||||||||||
| HIDE_ON_INTERNET_RESERVATION | varchar | 5 | √ | null |
|
|
Whether this center should be excluded from display on the internet facility reservation site (Yes/No) |
||||||||||||||||||||||
| SHOW_ON_CAPTIVATE_APP | varchar | 5 | √ | null |
|
|
Whether this center should be displayed on the ACTIVENet Captivate app (Yes/No) |
||||||||||||||||||||||
| IMAGE_ON_CAPTIVATE_APP | varchar | 50 | √ | null |
|
|
The name of the image to be displayed on the ACTIVENet Captivate app |
||||||||||||||||||||||
| 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 |
||||||||||||||||||||||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |