Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ACTIVITY_ID | int | 4 | √ | null |
|
|
Activity ID |
|
| CUSTOM_QUESTION_GROUP_ID | int | 4 | √ | null |
|
|
Custom question group ID |
|
| GROUP_DESCRIPTION | varchar | 30 | √ | null |
|
|
Custom question group description |
|
| GROUP_HEADER_TEXT | varchar | 50 | √ | null |
|
|
Custom question group heading text |
|
| GROUP_ORDER | int | 4 | √ | null |
|
|
Custom question group display order |
|
| QUESTION_ORDER | int | 4 | √ | null |
|
|
The order number that the question should be presented in |
|
| 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) |
|
| CREATE_TEAM_ONLY_QUESTION | varchar | 5 | √ | null |
|
|
Whether the question should only be displayed when creating a new team (Yes/No) |
|
| JOIN_TEAM_ONLY_QUESTION | varchar | 5 | √ | null |
|
|
Whether the question should only be displayed when joining an existing team (Yes/No) |
|
| NO_TEAM_ONLY_QUESTION | varchar | 5 | √ | null |
|
|
Whether the question should only be displayed when not specifying a team (Yes/No) |