Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) |
|||||||
| SITE_NAME | varchar | 255 | √ | null |
|
|
The name 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 |
|||||||
| ACTIVITY_DEPARTMENT_NAME | varchar | 40 | √ | null |
|
|
The name 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) |
|||||||
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
||||||||
| 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 |