CENTERS

0 rows


Description

Your organization’s defined centers

Columns

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

The Hub record ID
CENTER_ID int 4 √ null
CHILD_WATCH_ROOMS.CENTER_ID Defined in XML R
FACILITIES.CENTER_ID Defined in XML R
LOCKER_ROOMS.CENTER_ID Defined in XML R
POS_PRODUCTS_CENTER_QUANTITY.CENTER_ID Defined in XML R
RESERVATION_GROUPS.CENTER_ID Defined in XML R
STANDARD_CHARGES.CENTER_ID Defined in XML R
WORKSTATIONS.CENTER_ID Defined in XML R

The center record ID
CENTER_NAME varchar 255 √ null

The name of the center
CENTER_DESCRIPTION varchar 8000 √ null

The description of the center
SITE_ID int 4 √ null
SITES.SITE_ID Defined in XML R

The ID 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
GEOGRAPHIC_AREAS.GEOGRAPHIC_AREA_ID Defined in XML R

The center’s geographic area ID
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
SUPERVISORS.SUPERVISOR_ID Defined in XML R

The ID of the center’s supervisor
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)
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 (getdate())

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
ROW_VERSION binary 8 √ null

System timestamp (for internal use)
WEB_PAGE_URL varchar 3000 √ 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)
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)
CENTER_NOTES varchar 8000 √ null

User entered notes related to the center

Indexes

Constraint Name Type Sort Column(s)
CENTERS_ACTIVE_HUB_KEY_PK Primary key Asc ACTIVE_HUB_KEY
CENTERS_CENTER_ID_ORG_ID_UQ Must be unique Asc/Asc CENTER_ID + ORG_ID
CENTERS_GEOGRAPHIC_AREA_ID_IX Performance Asc GEOGRAPHIC_AREA_ID
CENTERS_ROW_VERSION_IX Performance Asc ROW_VERSION
CENTERS_SITE_ID_IX Performance Asc SITE_ID
CENTERS_SUPERVISOR_ID_IX Performance Asc SUPERVISOR_ID

Relationships

Close relationships within degrees of separation