FACILITY_PREREQUISITES

0 rows


Description

Contains information on configured prerequisites for facility reservations

Columns

Column Type Size Nulls Auto Default Children Parents Comments
FACILITY_PREREQUISITE_ID int 4 null
FACILITY_PREREQUISITE_ALTERNATE_KEY_STATUSES.FACILITY_PREREQUISITE_ID Defined in XML R

The facility prerequisite ID

FACILITY_ID int 4 null
FACILITIES.FACILITY_ID Defined in XML R

The facility ID

FACILITY_NAME varchar 255 null

The facility name

GROUP_NUMBER int 4 null

The prerequisite group number

PACKAGE_ID int 4 null
PACKAGES.PACKAGE_ID Defined in XML R

The ID of a prerequisite membership package for reserving the facility

PACKAGE_NAME varchar 255 null

The name of a prerequisite membership package for reserving the facility

IMMEDIATE_SALE_PACKAGE varchar 5 null

Whether the prerequisite membership package may be purchased at the time of reservation

ALTERNATE_KEY_TYPE_ID int 4 null
ALTERNATE_KEY_TYPES.ALTERNATE_KEY_TYPE_ID Defined in XML R

The ID of a prerequisite alternate key type for reserving the facility

ALTERNATE_KEY_TYPE varchar 50 null

The name of a prerequisite alternate key type for reserving the facility

ACTIVE_HUB_KEY int 4 null

The Hub record ID

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

Relationships

View Definition


Possibly Referenced Tables/Views