Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
|
| SITE_ID | int | 4 | √ | null |
|
|
The id of site table |
|
| FACILITY_SCHEDULE_ID | int | 4 | null |
|
|
Facility schedule ID |
||
| DCSESSION_ID | int | 4 | √ | null |
|
|
||
| FACILITY_ID | int | 4 | √ | null |
|
|
The ID of the parent facility |
|
| PERMIT_ID | int | 4 | √ | null |
|
|
The Permit ID |
|
| ACTIVITY_ID | int | 4 | √ | null |
|
|
The Activity ID |
|
| TRANSACTION_ID | int | 4 | √ | null |
|
|
The Transaction ID |
|
| STATION_ID | int | 4 | √ | null |
|
|
The Station ID |
|
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The System ID |
|
| STARTSCHEDULEDATE | datetime | 16,3 | √ | null |
|
|
The Start schedule date. |
|
| ENDSCHEDULEDATE | datetime | 16,3 | √ | null |
|
|
The end schedule date. |
|
| STARTSCHEDULETIME | datetime | 16,3 | √ | null |
|
|
The start schedule time. |
|
| ENDSCHEDULETIME | datetime | 16,3 | √ | null |
|
|
The end schedule time. |
|
| ATTENDANCE | int | 4 | √ | null |
|
|
The attendance of this schedule |
|
| CONFLICTING | varchar | 3 | √ | null |
|
|
The conflicting of the schedule |
|
| EVENTNAME | varchar | 255 | √ | null |
|
|
The event name. |
|
| STARTEVENTDATE | datetime | 16,3 | √ | null |
|
|
The start event date |
|
| ENDEVENTDATE | datetime | 16,3 | √ | null |
|
|
The end event date |
|
| STARTEVENTTIME | datetime | 16,3 | √ | null |
|
|
The start event time |
|
| ENDEVENTTIME | datetime | 16,3 | √ | null |
|
|
The end event time |
|
| HOLDEXPIRATIONDATE | datetime | 16,3 | √ | null |
|
|
The hold expitation date |
|
| HOLDTYPE | varchar | 3 | √ | null |
|
|
The hold type |
|
| HOLDUSERID | int | 4 | √ | null |
|
|
The id of hold user |
|
| MODULE | varchar | 2 | √ | null |
|
|
The module of the schedule |
|
| OVERLAP | varchar | 3 | √ | null |
|
|
The overlap of the schedule |
|
| RELATIONID | varchar | 128 | √ | null |
|
|
The relation ID |
|
| TENTATIVEOWNER | varchar | 30 | √ | null |
|
|
The tentative owner of the schedule |
|
| WAITLISTDATETIME | datetime | 16,3 | √ | null |
|
|
The wait list date time |
|
| CHECKOUTDATETIME | datetime | 16,3 | √ | null |
|
|
The check out date time |
|
| CHECKOUTCUSTOMER_ID | int | 4 | √ | null |
|
|
The check ou customer ID |
|
| CHECKINDATETIME | datetime | 16,3 | √ | null |
|
|
The check in date time |
|
| CHECKOUTFIRSTNAME | varchar | 25 | √ | null |
|
|
The check out first name |
|
| CHECKOUTLASTNAME | varchar | 25 | √ | null |
|
|
The check ou last name. |
|
| LEAGUESCHEDULE_ID | int | 4 | √ | null |
|
|
The league schedule ID |
|
| PARENT_FACILITY_SCHEDULE_ID | int | 4 | √ | null |
|
|
The parent facility schedule ID |
|
| RESCHEDULE | varchar | 3 | √ | null |
|
|
The reschedule |
|
| RESCHEDULED_FACILITY_SCHEDULE_ID | int | 4 | √ | null |
|
|
The rescheduled facility schedule ID |
|
| MAKE_UP_LESSON_DATES_ID | int | 4 | √ | null |
|
|
The make up lesson date ID |
|
| REFUNDED | varchar | 3 | √ | null |
|
|
The refund of the schedule |
|
| PRIVATE_LESSON_GROUP_ID | int | 4 | √ | null |
|
|
The private lesson group ID |
|
| ORIGINAL_LESSON_DURATION | int | 4 | √ | null |
|
|
The original lesson duration |
|
| NON_EXCLUSIVE | varchar | 3 | √ | null |
|
|
The non exclusive |
|
| DATE_RANGE_DESCRIPTION | varchar | 100 | √ | null |
|
|
The date range description |
|
| HOLD_HUMAN_RESOURCE_CUSTOMER_ID | int | 4 | √ | null |
|
|
The hold human resource ID |
|
| HUMAN_RESOURCE_DEFAULT_FACILITY_ID | int | 4 | √ | null |
|
|
The human resource default facility ID |
|
| ENROLLMENT_PENDING_ADDS_PK | int | 4 | √ | null |
|
|
The enrollment pending adds PK |
|
| EVENT_ATTENDANCE | int | 4 | √ | null |
|
|
The event attendance |
|
| RENTAL_BLOCK_ID | int | 4 | √ | null |
|
|
The rental block ID |
|
| DATE_RANGE_ID | int | 4 | √ | null |
|
|
The date range ID |
|
| TENTATIVE_WORKSTATION_ID | int | 4 | √ | null |
|
|
The tentative workstation ID |
|
| TENTATIVE_SEARCH_ID | int | 4 | √ | null |
|
|
The tentative search ID |
|
| TENTATIVE_TIME_SLOT_INDEX | int | 4 | √ | null |
|
|
The tentative time slot index |
|
| MASTER_FACILITY_SCHEDULE_ID | int | 4 | √ | null |
|
|
The master facility schedule ID |
|
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for INTernal use) |
|
| ORG_ID | int | 4 | null |
|
|
Your organization’s unique identifier in the Active Net system |
||
| 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 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_FACILITY_SCHEDULES | Primary key | Asc/Asc | FACILITY_SCHEDULE_ID + ORG_ID |