Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||||||||
| FACILITY_ID | int | 4 | √ | null |
|
|
Facility ID |
||||||||||
| FACILITY_NAME | varchar | 255 | √ | null |
|
|
Facility name |
||||||||||
| FACILITY_TYPE | varchar | 80 | √ | null |
|
|
Description of the facility’s type |
||||||||||
| CENTER_ID | int | 4 | √ | null |
|
|
The ID of the center where the facility locates |
||||||||||
| CENTER_NAME | varchar | 255 | √ | null |
|
|
The Name of the center where the facility locates |
||||||||||
| SITE_ID | int | 4 | √ | null |
|
|
The facility’s site ID |
||||||||||
| SITE_NAME | varchar | 255 | √ | null |
|
|
The facility’s site name |
||||||||||
| PERMIT_NUMBER | int | 4 | √ | null |
|
|
The number of the permit |
||||||||||
| PERMIT_DATE | datetime | 16,3 | √ | null |
|
|
The date and time when the permit was created |
||||||||||
| EVENT_TYPE | varchar | 102 | √ | null |
|
|
Event type of the reservation |
||||||||||
| 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 | 20 | √ | null |
|
|
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 |
||||||||||
| SCHEDULE_TYPE | varchar | 80 | √ | null |
|
|
The schedule type of the reservation |
||||||||||
| EXPIRATION_DATE | datetime | 16,3 | √ | null |
|
|
The expiration date of the reservation |
||||||||||
| TRANSACTION_SITE | varchar | 255 | √ | null |
|
|
Name of the transaction site where the reservation was made |
||||||||||
| SYSTEM_USER_NAME | varchar | 511 | null |
|
|
Name of the system user who made the reservation |
|||||||||||
| CUSTOMER_FIRST_NAME | varchar | 255 | √ | null |
|
|
First name of the customer |
||||||||||
| CUSTOMER_LAST_NAME | varchar | 255 | √ | null |
|
|
Last name of the customer |
||||||||||
| RESIDENCY | varchar | 255 | √ | null |
|
|
Customer’s resident status |
||||||||||
| COMPANY_NAME | varchar | 255 | √ | null |
|
|
Reservation made by a company |
||||||||||
| 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 |
||||||||||
| EXPIRATION_DATE_ONLY | date | 20 | √ | null |
|
|
The expiration date of the reservation (date only) |
||||||||||
| PERMIT_DATE_ONLY | date | 20 | √ | null |
|
|
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 |
||||||||||
| FACILITY_TYPE_ID | int | 4 | √ | null |
|
|
ID of the facility’s type |
||||||||||
| 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 |
||||||||||
| source_id | int | 4 | √ | null |
|
|
The ID value from the Active Net system |