Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
||||||||||
| FACILITY_ID | int | 4 | √ | null |
|
|
Facility ID |
||||||||||
| SITE_ID | int | 4 | √ | null |
|
|
The facility’s site ID |
||||||||||
| PERMIT_NUMBER | varchar | 255 | √ | null |
|
|
DEPRECATED - The number of the permit |
||||||||||
| PERMIT_DATE | datetime | 16,3 | √ | null |
|
|
DEPRECATED - The date and time when the permit was created |
||||||||||
| EVENT_START_DATE | date | 20 | √ | null |
|
|
Event start date |
||||||||||
| EVENT_START_TIME | time | 16 | √ | null |
|
|
Event start time |
||||||||||
| EVENT_END_DATE | date | 20 | √ | null |
|
|
Event end date |
||||||||||
| EVENT_END_TIME | time | 16 | √ | null |
|
|
Event end time |
||||||||||
| DAY_OF_WEEK | varchar | 10 | √ | null |
|
|
Reserved days in a week |
||||||||||
| ATTENDANCE | int | 4 | √ | null |
|
|
The attendance of the resevation |
||||||||||
| PERMIT_STATUS | varchar | 255 | √ | null |
|
|
DEPRECATED - The current status of the permit (e.g. Approved, Denied, Tentative, Stage Denied, Issued, Cancelled, Waiting Decision, Completed, On Hold) |
||||||||||
| HOURS_RESERVED | decimal | 11,2 | √ | null |
|
|
The total hours that the facility is reserved |
||||||||||
| MINUTES_RESERVED | decimal | 11,2 | √ | null |
|
|
Includes prep time |
||||||||||
| EXPIRATION_DATE | datetime | 16,3 | √ | null |
|
|
The expiration date of the reservation |
||||||||||
| 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 |
||||||||||
| EXPIRATION_DATE_ONLY | date | 20 | √ | null |
|
|
The expiration date of the reservation (date only) |
||||||||||
| PERMIT_DATE_ONLY | date | 20 | √ | null |
|
|
DEPRECATED - The date when the permit was created (date only) |
||||||||||
| FACILITY_SCHEDULE_ID | int | 4 | √ | null |
|
|
The ID of the reservation record |
||||||||||
| PERMIT_ID | int | 4 | √ | null |
|
|
The ID of the permit |
||||||||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer |
||||||||||
| COMPANY_ID | int | 4 | √ | null |
|
|
The ID of the company |
||||||||||
| SETUP_MINUTES | int | 4 | √ | null |
|
|
The number of minutes of setup time prior to the event start time |
||||||||||
| CLEANUP_MINUTES | int | 4 | √ | null |
|
|
The number of minutes of cleanup time after the event end time |
||||||||||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |
||||||||||
| EVENT_DESCRIPTION | varchar | 255 | √ | null |
|
|
The description of the reservation event |
||||||||||
| ACTIVITY_ID | int | 4 | √ | null |
|
|
The ID of the activity that the reserved space belongs to |
||||||||||
| SESSION_ID | int | 4 | √ | null |
|
|
The ID of the daycare session that the reserved space belongs to |
||||||||||
| LEAGUE_SCHEDULE_ID | int | 4 | √ | null |
|
|
The ID of the league schedule that the reserved space belongs to |
||||||||||
| EVENT_TYPE_ID | int | 4 | √ | null |
|
|
ID of the event type of the reservation |
||||||||||
| SCHEDULE_TYPE_ID | int | 4 | √ | null |
|
|
ID of the schedule type of the reservation |
||||||||||
| TRANSACTION_SITE_ID | int | 4 | √ | null |
|
|
ID of the transaction site where the reservation was made |
||||||||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
ID of the system user who made the reservation |
||||||||||
| RESERVATION_START_DATE | date | 20 | √ | null |
|
|
The start date of the overall reservation, including setup time |
||||||||||
| RESERVATION_START_TIME | time | 16 | √ | null |
|
|
The start time of the overall reservation, including setup time |
||||||||||
| RESERVATION_END_DATE | date | 20 | √ | null |
|
|
The end date of the overall reservation, including cleanup time |
||||||||||
| RESERVATION_END_TIME | time | 16 | √ | null |
|
|
The end time of the overall reservation, including cleanup time |
||||||||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| FACILITY_RESERVATION_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| FACILITY_RESERVATION_ACTIVITY_ID_IX | Performance | Asc | ACTIVITY_ID |
| FACILITY_RESERVATION_COMPANY_ID_IX | Performance | Asc | COMPANY_ID |
| FACILITY_RESERVATION_CUSTOMER_ID_IX | Performance | Asc | CUSTOMER_ID |
| FACILITY_RESERVATION_EVENT_START_DATE_EVENT_END_DATE_IX | Performance | Asc/Asc | EVENT_START_DATE + EVENT_END_DATE |
| FACILITY_RESERVATION_EVENT_TYPE_ID_IX | Performance | Asc | EVENT_TYPE_ID |
| FACILITY_RESERVATION_FACILITY_ID_IX | Performance | Asc | FACILITY_ID |
| FACILITY_RESERVATION_FACILITY_SCHEDULE_ID_ORG_ID_IX | Performance | Asc/Asc | FACILITY_SCHEDULE_ID + ORG_ID |
| FACILITY_RESERVATION_PERMIT_ID_IX | Performance | Asc | PERMIT_ID |
| FACILITY_RESERVATION_RESERVATION_START_DATE_RESERVATION_END_DATE_IX | Performance | Asc/Asc | RESERVATION_START_DATE + RESERVATION_END_DATE |
| FACILITY_RESERVATION_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| FACILITY_RESERVATION_SCHEDULE_TYPE_ID_IX | Performance | Asc | SCHEDULE_TYPE_ID |
| FACILITY_RESERVATION_SESSION_ID_IX | Performance | Asc | SESSION_ID |
| FACILITY_RESERVATION_SITE_ID_IX | Performance | Asc | SITE_ID |
| FACILITY_RESERVATION_SYSTEMUSER_ID_IX | Performance | Asc | SYSTEMUSER_ID |
| FACILITY_RESERVATION_TRANSACTION_SITE_ID_IX | Performance | Asc | TRANSACTION_SITE_ID |