Interaction Annotation View
Any notes added on an interaction will be displayed in this view. Notes can be added to an interaction using Interaction Desktop.
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| IntxAnnoID | int (4) | False | No | An identifier to identify an IntxAnnotation record. Notes can be added to an interaction on a per-segment basis. |
17.4.0.0 | Added for data extraction from IntxAnnotation table. |
| IntxID | char (22) | False | No | A Globally Unique Identifier(GUID) to uniquely identify an interaction segment. Refer to the IntxSegment table for matching segment records. |
17.4.0.0 | Added for data extraction from IntxAnnotation table. |
| IndivID | char (22) | False | Yes | This column stores the IndivId for the individual who entered this note. |
17.4.0.0 | Added for data extraction from IntxAnnotation table. |
| IsPrivate | tinyint (1) | False | No | This column stores a value indicating whether or not the note is private. |
17.4.0.0 | Added for data extraction from IntxAnnotation table. |
| Annotation | nvarchar (3900) | True | Depends on customer usage | This column stores the actual annotation/notes added to an interaction. |
17.4.0.0 | Added for data extraction from IntxAnnotation table. |
| Version | int (4) | False | No | Stores the version of the annotation. The version field is used to track changes to annotations. |
17.4.0.0 | Added for data extraction from IntxAnnotation table. |
| StartDateTime | datetime2 (7) | False | No | This column stores the start date time-stamp of an interaction segment. |
17.4.0.0 | Added for data extraction from IntxAnnotation table. |
| SiteID | smallint (2) | True | No | This column stores the site identifier for an interaction segment. This is a way to differentiate between interaction segments that existed on different sites. |
17.4.0.0 | Added for data extraction from IntxAnnotation table. |
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| INTXANNOID | number (22) | False | No | An identifier to identify an IntxAnnotation record. Notes can be added to an interaction on a per-segment basis. |
17.4.0.0 | Added for data extraction from IntxAnnotation table. |
| INTXID | char (22) | False | No | A Globally Unique Identifier(GUID) to uniquely identify an interaction segment. Refer to the IntxSegment table for matching segment records. |
17.4.0.0 | Added for data extraction from IntxAnnotation table. |
| INDIVID | char (22) | False | Yes | This column stores the IndivId for the individual who entered this note. |
17.4.0.0 | Added for data extraction from IntxAnnotation table. |
| ISPRIVATE | number (22) | False | No | This column stores a value indicating whether or not the note is private. |
17.4.0.0 | Added for data extraction from IntxAnnotation table. |
| ANNOTATION | nvarchar2 (3800) | True | Depends on customer usage | This column stores the actual annotation/notes added to an interaction. |
17.4.0.0 | Added for data extraction from IntxAnnotation table. |
| VERSION | number (22) | False | No | Stores the version of the annotation. The version field is used to track changes to annotations. |
17.4.0.0 | Added for data extraction from IntxAnnotation table. |
| STARTDATETIME | timestamp | False | No | This column stores the start date time-stamp of an interaction segment. |
17.4.0.0 | Added for data extraction from IntxAnnotation table. |
| SITEID | number (22) | True | No | This column stores the site identifier for an interaction segment. This is a way to differentiate between interaction segments that existed on different sites. |
17.4.0.0 | Added for data extraction from IntxAnnotation table. |