Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
||||||||
| CUSTOM_QUESTION_ID | int | 4 | √ | null |
|
|
Custom question ID |
|||||||
| SITE_ID | int | 4 | √ | null |
|
|
Site ID |
|||||||
| SITE_NAME | varchar | 255 | √ | null |
|
|
Site name |
|||||||
| QUESTION | varchar | 500 | √ | null |
|
|
The text of the question to be asked |
|||||||
| IS_REQUIRED | varchar | 5 | √ | null |
|
|
Whether an answer is required for the custom question (Yes/No) |
|||||||
| QUESTION_TYPE | varchar | 30 | √ | null |
|
|
The type of control to be used to answer the question (User Entry / Single Selection - Dropdown / Single Selection - Radio / Multi Selection - Checkbox / Multi Selection - Listbox / Auto-fill Conditional) |
|||||||
| NOTE | varchar | 200 | √ | null |
|
|
A user note related to the custom question |
|||||||
| DEFAULT_ANSWER | varchar | 100 | √ | null |
|
|
The optional default answer for the user entry question |
|||||||
| TITLE | varchar | 40 | √ | null |
|
|
The title of the custom question |
|||||||
| ANSWER_FORMAT | varchar | 50 | √ | null |
|
|
The answer format of the user entry question (Free Form / Phone Number / Date / Time / SSN / Postal Code / Upper-case Alpha / Lower-case Alpha / Numbers Only / Alpha Only / Duration) |
|||||||
| IS_RETIRED | varchar | 5 | √ | null |
|
|
Whether the custom question has been retired (Yes/No) |
|||||||
| HIDE_ON_INTERNET | varchar | 5 | √ | null |
|
|
Whether the custom question should be excluded from display on the internet site (Yes/No) |
|||||||
| ADD_TO_NEW_ACTIVITIES | varchar | 5 | √ | null |
|
|
Whether the custom question should be automatically added to new activities (Yes/No) |
|||||||
| QUESTION_SCOPE | varchar | 30 | √ | null |
|
|
The scope of the custom question (Ask for every transaction / Ask once per receipt) |
|||||||
| HIDE_ON_ADMIN | varchar | 5 | √ | null |
|
|
Whether the custom question should be excluded from display on the admin site (Yes/No) |
|||||||
| DO_NOT_SHOW_AFTER | date | 20 | √ | null |
|
|
The last date that the custom question should be displayed |
|||||||
| DO_NOT_EDIT_AFTER | date | 20 | √ | null |
|
|
The last date that the custom question should allow edits |
|||||||
| USE_ANSWER_CODE | varchar | 5 | √ | null |
|
|
Whether the custom question uses answer codes (Yes/No) |
|||||||
| QUESTION_HINT | varchar | 200 | √ | null |
|
|
A hint to be displayed for the custom question |
|||||||
| MESSAGE_FOR_USED_UP_ANSWERS | varchar | 200 | √ | null |
|
|
A message to be displayed for the custom question for answers that have reached their use count limit |
|||||||
| ANSWER_MAX_LENGTH | int | 4 | √ | null |
|
|
The maximum answer length for user entry questions |
|||||||
| EXTRA_ANSWER_TEXT | varchar | 50 | √ | null |
|
|
Additional instruction text to be displayed for a multiple-choice question |
|||||||
| CUSTOM_QUESTION_TYPE_ID | int | 4 | √ | null |
|
|
Custom question type ID |
|||||||
| CUSTOM_QUESTION_TYPE | varchar | 30 | √ | null |
|
|
Custom question type |
|||||||
| APPLY_LATEST_ANSWER_TO_PREVIOUS_TRANSACTIONS | varchar | 5 | √ | null |
|
|
Whether the answer given should replace prior answers to the same question for the customer (Yes/No) |
|||||||
| IS_DEMOGRAPHIC_RELATED_QUESTION | varchar | 5 | √ | null |
|
|
Whether the custom question is related to demographics (Yes/No) |
|||||||
| CUSTOM_QUESTION_FOR | varchar | 15 | √ | null |
|
|
Whether the custom question is for normal use or is specifically for the prospects form on CUI (Normal / Prospects Form) |
|||||||
| DYNAMIC_ANSWER_BASED_ON | varchar | 15 | √ | null |
|
|
The source of the dynamic answer options if applicable (Site Name / Category Name / NULL) |
|||||||
| 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 |