Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
|||||||
| SKIP_DATE_ID | int | 4 | √ | null |
|
|
The ID of the skip date |
|||||||
| SKIP_DATE_NAME | varchar | 50 | √ | null |
|
|
The name of the skip date |
|||||||
| SITE_ID | int | 4 | √ | null |
|
|
The ID of the site that this skip date applies to (NULL for all sites) |
|||||||
| START_DATE | date | 20 | √ | null |
|
|
The start date of the skip date |
|||||||
| START_TIME | time | 16 | √ | null |
|
|
The time on the start date that this skip date begins |
|||||||
| END_DATE | date | 20 | √ | null |
|
|
The end date of the skip date |
|||||||
| END_TIME | time | 16 | √ | null |
|
|
The time on the end date that this skip date ends |
|||||||
| APPLY_EVERY_YEAR | varchar | 5 | √ | null |
|
|
Whether this skip date should be applied on the same dates every year (Yes/No) |
|||||||
| ACTIVITY_DEPARTMENT_ID | int | 4 | √ | null |
|
|
The ID of the activity department that this skip date applies to |
|||||||
| APPLY_MODULE_ACTIVITY | varchar | 5 | √ | null |
|
|
Whether this skip date applies to activities (Yes/No) |
|||||||
| APPLY_MODULE_DAYCARE | varchar | 5 | √ | null |
|
|
Whether this skip date applies to daycare sessions (Yes/No) |
|||||||
| APPLY_MODULE_FACILITY | varchar | 5 | √ | null |
|
|
Whether this skip date applies to facilities (Yes/No) |
|||||||
| APPLY_MODULE_EQUIPMENT | varchar | 5 | √ | null |
|
|
Whether this skip date applies to equipment (Yes/No) |
|||||||
| APPLY_MODULE_INSTRUCTOR | varchar | 5 | √ | null |
|
|
Whether this skip date applies to instructors (Yes/No) |
|||||||
| SELECT_ALL_FACILITIES | varchar | 5 | √ | null |
|
|
Whether this skip date should have all facilities selected (Yes/No) |
|||||||
| SELECT_NO_FACILITIES | varchar | 5 | √ | null |
|
|
Whether this skip date should have no facilities selected (Yes/No) |
|||||||
| SELECT_ALL_EQUIPMENT | varchar | 5 | √ | null |
|
|
Whether this skip date should have all equipment selected (Yes/No) |
|||||||
| SELECT_NO_EQUIPMENT | varchar | 5 | √ | null |
|
|
Whether this skip date should have no equipment selected (Yes/No) |
|||||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
|||||||
| 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 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| SKIP_DATES_ACTIVE_HUB_KEY_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| SKIP_DATES_ACTIVITY_DEPARTMENT_ID_IX | Performance | Asc | ACTIVITY_DEPARTMENT_ID |
| SKIP_DATES_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| SKIP_DATES_SITE_ID_IX | Performance | Asc | SITE_ID |
| SKIP_DATES_SKIP_DATE_ID_ORG_ID_UQ | Must be unique | Asc/Asc | SKIP_DATE_ID + ORG_ID |