Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||
| FACILITY_SCHEDULE_ID | int | 4 | √ | null |
|
|
The ID of the reservation record |
||||
| ACTIVITY_ID | int | 4 | √ | null |
|
|
The ID of the activity that the reservation is for |
||||
| ACTIVITY_NAME | varchar | 255 | √ | null |
|
|
The name of the activity that the reservation is for |
||||
| INSTRUCTOR_FACILITY_ID | int | 4 | √ | null |
|
|
Facility ID |
||||
| INSTRUCTOR_FACILITY_NAME | varchar | 255 | √ | null |
|
|
Facility name |
||||
| LESSON_START_DATE | date | 20 | √ | null |
|
|
Lesson start date |
||||
| LESSON_START_TIME | varchar | 255 | √ | null |
|
|
Lesson start time |
||||
| LESSON_END_DATE | date | 20 | √ | null |
|
|
Lesson end date |
||||
| LESSON_END_TIME | varchar | 255 | √ | null |
|
|
Lesson end time |
||||
| DAY_OF_WEEK | varchar | 255 | √ | null |
|
|
Reserved days in a week |
||||
| HOURS_RESERVED | decimal | 11,2 | √ | null |
|
|
The total hours that the lesson is booked for |
||||
| MINUTES_RESERVED | decimal | 11,2 | √ | null |
|
|
The total minutes that the lesson is booked for |
||||
| HOLD_TYPE | varchar | 20 | √ | null |
|
|
The type of hold that is placed on the resource (Booked, Tentative, Placeholder, Rescheduled) |
||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer |
||||
| CUSTOMER_FIRST_NAME | varchar | 255 | √ | null |
|
|
First name of the customer |
||||
| CUSTOMER_LAST_NAME | varchar | 255 | √ | null |
|
|
Last name of the customer |
||||
| RESIDENCY | varchar | 3 | null |
|
|
Customer’s resident status |
|||||
| TRANSACTION_ID | int | 4 | √ | null |
|
|
The ID of the transaction for the reservation |
||||
| ROOT_TRANSACTION_ID | int | 4 | √ | null |
|
|
The ID of the root transaction for the activity registration |
||||
| TRANSACTION_SITE_ID | int | 4 | √ | null |
|
|
The site ID where the transaction took place |
||||
| TRANSACTION_SITE_NAME | varchar | 255 | √ | null |
|
|
The site name where the transaction took place |
||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
ID of the system user who made the reservation |
||||
| SYSTEM_USER_NAME | varchar | 511 | null |
|
|
Name of the system user who made the reservation |
|||||
| 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 |
||||
| PARENT_FACILITY_SCHEDULE_ID | int | 4 | √ | null |
|
|
The ID of the parent record, if the record is for the lesson location rather than the booked instructor facility |
||||
| LOCATION_FACILITY_ID | int | 4 | √ | null |
|
|
The ID of the location facility, if the record is for the lesson location rather than the booked instructor facility |
||||
| LOCATION_FACILITY_NAME | varchar | 255 | √ | null |
|
|
The name of the location facility, if the record is for the lesson location rather than the booked instructor facility |