Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 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 |
||||
| INSTRUCTOR_FACILITY_ID | int | 4 | √ | null |
|
|
Facility ID |
||||
| 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 |
||||
| 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 |
||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
ID of the system user who made 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 |
||||
| 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 |
||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ACTIVITY_PRIVATE_LESSONS_ACTIVE_HUB_KEY_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| ACTIVITY_PRIVATE_LESSONS_ACTIVITY_ID_IX | Performance | Asc | ACTIVITY_ID |
| ACTIVITY_PRIVATE_LESSONS_CUSTOMER_ID_IX | Performance | Asc | CUSTOMER_ID |
| ACTIVITY_PRIVATE_LESSONS_FACILITY_SCHEDULE_ID_ORG_ID_IX | Performance | Asc/Asc | FACILITY_SCHEDULE_ID + ORG_ID |
| ACTIVITY_PRIVATE_LESSONS_INSTRUCTOR_FACILITY_ID_IX | Performance | Asc | INSTRUCTOR_FACILITY_ID |
| ACTIVITY_PRIVATE_LESSONS_LOCATION_FACILITY_ID_IX | Performance | Asc | LOCATION_FACILITY_ID |
| ACTIVITY_PRIVATE_LESSONS_PARENT_FACILITY_SCHEDULE_ID_IX | Performance | Asc | PARENT_FACILITY_SCHEDULE_ID |
| ACTIVITY_PRIVATE_LESSONS_ROOT_TRANSACTION_ID_IX | Performance | Asc | ROOT_TRANSACTION_ID |
| ACTIVITY_PRIVATE_LESSONS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| ACTIVITY_PRIVATE_LESSONS_SYSTEMUSER_ID_IX | Performance | Asc | SYSTEMUSER_ID |
| ACTIVITY_PRIVATE_LESSONS_TRANSACTION_ID_IX | Performance | Asc | TRANSACTION_ID |
| ACTIVITY_PRIVATE_LESSONS_TRANSACTION_SITE_ID_IX | Performance | Asc | TRANSACTION_SITE_ID |