Macromedia breeze-managing external breeze reports User Manual

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

URL

STATUS SCORE DATE_

VISITED

brice@adobe.com /r18595812/ completed 8.0

12/15/2004
11:17:38 PM

122

ccarr@adobe.com /p7096354/ in-

progress

0.0

12/06/
2004
11:18:48 PM

150

lblue@adobe.com /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