Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| QUESTION_TYPE | varchar | 255 | null |
|
|
Type of question |
|||||
| SUBSYSTEM | varchar | 255 | null |
|
|
Subsystem that generated the question |
|||||
| TRANSACTION_TYPE | varchar | 255 | null |
|
|
Type of transaction that generated the question |
|||||
| CUSTOMQUESTION_ID | int | 4 | null |
|
|
Identifier for the source custom question |
|||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
Reference to CUSTOMERS |
||||
| ACTIVITY_ID | int | 4 | √ | null |
|
|
Reference to ACTIVITIES |
||||
| PROGRAM_ID | int | 4 | √ | null |
|
|
Reference to PROGRAMS |
||||
| FACILITY_ID | int | 4 | √ | null |
|
|
Reference to FACILITIES |
||||
| PERMIT_ID | int | 4 | √ | null |
|
|
Reference to FACILITY_RESERVATIONS |
||||
| PACKAGE_ID | int | 4 | √ | null |
|
|
Reference to PACKAGES |
||||
| MEMBERSHIP_ID | int | 4 | √ | null |
|
|
Reference to MEMBERSHIPS |
||||
| POSPRODUCT_ID | int | 4 | √ | null |
|
|
Reference to POS_PRODUCTS |
||||
| QUESTION_GROUP | varchar | 255 | √ | null |
|
|
Description of the group that the question is a member of |
||||
| TITLE | varchar | 40 | √ | null |
|
|
Title of question |
||||
| QUESTION | varchar | 500 | √ | null |
|
|
Question text |
||||
| ANSWER | varchar | 500 | √ | null |
|
|
Answer given. includes blank value for questions skipped or questions not answered. |
||||
| DATESTAMP | datetime | 16,3 | √ | null |
|
|
Date and time answer was last recorded |
||||
| DATESTAMP_DATE_ONLY | date | 20 | √ | null |
|
|
Date answer was last recorded |
||||
| TRANSACTION_ID | int | 4 | √ | null |
|
|
Reference to the transaction that generated the question, if not a customer question |
||||
| ROOT_TRANSACTION_ID | int | 4 | √ | null |
|
|
Reference to the root transaction that generated the question, if not a customer question |
||||
| CUSTOMQUESTIONANSWER_ID | int | 4 | √ | null |
|
|
Identifier for the custom question answer |
||||
| CUSTOMQUESTIONANSWER_I_ID | int | 4 | √ | null |
|
|
Identifier for the unanswered custom question |
||||
| ACTIVE_HUB_SOURCE | varchar | 255 | null |
|
|
The source of the custom question answer data (internal use) |
|||||
| ACTIVE_HUB_KEY | bigint | 8 | null |
|
|
||||||
| LAST_SYNC_TIME | datetime | 16,3 | null |
|
|
||||||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
|||||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |
||||
| CHARGE_ID | int | 4 | √ | null |
|
|
charge fee id |