V_RD_<eventtype>

Business Intelligence (BI) Interface Guide › Business Intelligence Interface › SQL Interfaces › Raw Data and Intermediate Data Interfaces › V_RD_<eventtype>

V_RD_<eventtype>

For each Event Type in the system, a view named V_RD_<eventtype> is created (where <eventtype> is the name of the event type for which the view is created).

This view exposes records of the specific Event Type.
Instead of an XML that contain the data of the Event, this view has an actual column for each Field of the Event. The column name is according to the name of the Field, as defined in the system, and the column type is a string.

These views can be useful when designing reports on a specific Event Type.

The V_RD_<eventtype> interface is able to handle raw data fields with their real types, according to the definition of the event type.

If the Event name and/or the Event Field names contain non-ASCII characters, they are replaced by '_', or removed from the name.

Names longer than 30 characters are truncated. In case the truncation returns a name that already exists, the name is changed to end with a sequence number.

The following table describes the fields in V_RD_<eventtype>.

Name	Type	Content
READER_ID	number	Foreign Key to T_READERS.
READER_NAME	varchar2(30)	Name of the Adapter.
RESOURCE_ID	number	Foreign Key to T_RESOURCES.
RESOURCE_NAME	varchar2(100)	Name of the Resource.
TIME_STAMP	date	Time stamp of the event (UTC time).
READER_TIME_STAMP	date	Time stamp of when the Adapter created the event (UTC time).
CREATED	number	If the event was added by a Correction, contains the ID of the correction.
CORRECTED	number	If the event was deleted by a Correction, contains the ID of the correction.
CREATE_DATE	date	The creation date of the record.
MODIFY_DATE	date	The modification date of the record.
ANNOTATION_USER_ ID	number	Foreign Key to T_USERS. If the event has an annotation, points to the user who created the annotation.
ANNOTATION_USER_ NAME	varchar2(200)	If the event has an annotation, contains the name of the user who created the annotation.
ANNOTATION_TEXT	varchar2(512)	If the event has an annotation, contains the annotation's text.
ANNOTATION_IS_ MANUAL	number	If the event has an annotation: 0 - Annotation created by Business Logic. 1 - Annotation created manually by user.
ANNOTATION_ MODIFY_DATE	date	If the event has an annotation, contains the modification date of the annotation.
F_NAME1	field1type	Value of field #1 in the Event.
F_NAME2	field2type	Value of field #2 in the Event.
F_NAMEX	fieldxtype	Value of field #x in the Event.