CL_QANSWER_OVTM

Description: |
The CL_QANSWER_OVTM table contains contact-specific information for questionnaire answers.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ANSWER_ID | 1 |
CONTACT_DATE_REAL | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ANSWER_ID | VARCHAR | No |
The unique ID of the answer record.
2 | CONTACT_DATE_REAL | FLOAT | No |
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3 | CONTACT_DATE | DATETIME | No |
The contact date in datetime format.
4 | CM_CT_OWNER_ID | VARCHAR | No |
Store the contact owner for the record.
5 | INSTANT_OF_ENTRY | DATETIME (Attached) | No |
The instant an interval begins.
6 | END_INSTANT | DATETIME (Attached) | No |
The instant an interval ends.