User Guide

Database views and data relationships 11

Unique identifiers and data relationships

Relationships between views are defined by unique identifiers, which are columns that share

the same name. The following table shows the columns that are mapped between views.

EXT_TRANSACTIONS

A unique transaction ID is generated each time a user accesses an object. The

EXT_TRANSACTIONS view uses the data listed in the following table:

The following user actions generate data in this view:

■ Attending a meeting

■ Viewing a piece of content

■ Tak in g a c o ur se

Unique identifiers View(s) used in

URL EXT_OBJECTS

EXT_TRANSACTIONS

TRANSACTION_ID EXT_TRANSACTIONS

EXT_TRANSACTIONS _DETAILS

EXT_TRANSACTIONS _VIEWS

EXT_TRANSACTIONS

EXT_USER_GROUPS

EXT_USER_FIELDS

Column name Data type Description

TRANSACTION_ID INT Unique ID for this transaction.

transaction.

URL NVARCHAR The object that the user accessed.

STATUS NVARCHAR Can be passed, failed, complete, or in-progress.

SCORE FLOAT How the user scored.

DATE_VISITED DATETIME The date this transaction was taken or viewed.