User Guide

12 Using Breeze Reporting Views
EXT_TRANSACTIONS sample entries
Constraints
The EXT_TRANSACTIONS view excludes the following fields:
■ Certificate number, which does not exist in the database
■ Max score, which is often unavailable
EXT_TRANSACTION_DETAILS
The EXT_TRANSACTIONS_DETAILS view manages questions and answers per user
transcript. This view retrieves data from meeting polls, user forms, and quizzes. The
EXT_TRANSACTIONS_DETAILS view uses the data listed in the following table:
A multiple-answer question is returned as one row for every answer chosen. For example,
when the user answers 1 and 4, there are two separate rows. One row contains the value 1 and
the other row contains the value 4.
Data is generated in this view whenever a user does any of the following:
■ Answers a question in a quiz within a course
■ Answers a poll within a meeting
■ Adds a custom form to a meeting or course
TRANSACTION
_ID
LOGIN URL STATUS SCORE DATE_
VISITED
26 [e-mail] /r18595812/ completed 8.0 12/15/2004
11:17:38 PM
122 [e-mail] /p7096354/ in-
progress
0.0 12/06/
2004
11:18:48 PM
150 [e-mail] /p8145026/ user-
passed
10.0 12/05/2004
11:22:44 AM
Column name Data type Description
TRANSACTION_ID INT Unique ID for this transaction
QUESTION NVARCHAR Text of the question
RESPONSE NVARCHAR User’s response to the question
SCORE FLOAT Number of points awarded for the response