Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PEAK_LOAD_PERIOD_ID | int | 4 | null |
|
|
Unique ID of the table |
||
| PEAK_LOAD_PERIOD | varchar | 50 | √ | null |
|
|
Rush event name |
|
| START_DATESTAMP | datetime | 16,3 | √ | null |
|
|
Rush event start date and time |
|
| END_DATESTAMP | datetime | 16,3 | √ | null |
|
|
Rush event end date and time |
|
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
ID of the user who created the rush event |
|
| SYSTEM_USER_NAME | varchar | 511 | null |
|
|
Name of the user who created the rush event |
||
| DATESTAMP | datetime | 16,3 | √ | null |
|
|
Rush event creatred date and time |
|
| IS_ANNUAL_EVENT | varchar | 5 | √ | null |
|
|
Is this annual event (Yes/No) |
|
| PREVIOUS_YEAR_REG_DATE | datetime | 16,3 | √ | null |
|
|
Previous year registration date |
|
| FIRST_10MIN | smallint | 2 | √ | null |
|
|
Number of registrations in the first 10 minutes |
|
| FIRST_1HOUR | smallint | 2 | √ | null |
|
|
Number of registrations in the first 10 hour |
|
| PRINT_MEDIA | varchar | 5 | √ | null |
|
|
Whether Print Media was used for this peak period (Yes/No) |
|
| ONLINE_MEDIA | varchar | 5 | √ | null |
|
|
Whether Online Media was used for this peak period (Yes/No) |
|
| SOCIAL_MEDIA | varchar | 5 | √ | null |
|
|
Whether Social Media was used for this peak period (Yes/No) |
|
| MASS_MEDIA | varchar | 5 | √ | null |
|
|
Whether Mass Media was used for this peak period (Yes/No) |
|
| FOR_TYPE | varchar | 50 | √ | null |
|
|
Rush event type |
|
| 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 |
||
| source_id | int | 4 | null |
|
|
The ID value from the Active Net system |