User Guide

Database views and data relationships 13
EXT_TRANSACTION_DETAILS sample entries
Constraints
The EXT_TRANSACTION_DETAILS view excludes the following fields:
■ Correct or Incorrect, which can be determined by checking for a non-zero score
■ Date answered, which does not exist in the version 5.1 schema
EXT_TRANSACTIONS_VIEWS
This view manages data about the slides or pages viewed by users. The
EXT_TRANSACTIONS_VIEWS view uses the data listed in the following table:
Data is generated in this view whenever a user views content or a course.
EXT_TRANSACTIONS_VIEWS sample entries
TRANSACTION_ID QUESTION RESPONSE SCORE
334 What is the RAM requirement? 1 10.0
340 What is the RAM requirement? 1 10.0
531 How many current users are there? 1 0.0
Column name Data type Description
TRANSACTION_ID INT Unique ID for this transaction (can be merged with
TRANSACTION_DETAILS to summarize by URL)
PAGE NVARCHAR The slide or page number that was viewed
DATE_VIEWED DATETIME The date this view occurred
TRANSACTION_ID PAGE DATE_VIEWED
334 11 12/15/2004 11:17:38 PM
340 2 01/06/2004 12:17:38 PM
531 3 02/11/2004 08:17:38 AM