This view provides tracking summary of post-assessments. Note that post-assessments can be taken multiple times and all of the results are available in this view. These can then be filtered by highest score, lowest score, average score, latest score, or result date.
Upgrade Note: For installations upgraded from Professional edition 6.1, this view replaces the KPVIEW_POSTASSESS_SUMMARY view. Previous views still appear with their original column names to preserve any existing reports based on these views.
RUNTIMEID (Oracle = number (10, 0)), (SQL = int)
A server-generated unique value identifying a user attempt to take the post-assessment.
This field is a primary key.
USER_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier for the user.
USERNAME (Oracle = nvarchar2), (SQL = nvarchar)
The name that the user enters to log in to the server.
FIRST_NAME (Oracle = nvarchar2), (SQL = nvarchar)
User's first name.
LAST_NAME (Oracle = nvarchar2), (SQL = nvarchar)
User's last name.
GUIDMAPID (Oracle = number (10, 0)), (SQL = int)
This unique identifier correlates to the primary key in the GUIDMAP table for the post-assessment Learning Object and is used to join this table to other tables.
ASSESS_LO_ID (Oracle = number (10, 0)), (SQL = int)
The unique identifier for the post-assessment.
This field is a primary key.
ASSESSTYPE (Oracle = number (3, 0)), (SQL = tinyint)
This value is always 2 for a post-assessment.
This field is a primary key.
ACCESS_NAME (Oracle = nvarchar2), (SQL = nvarchar)
The name of the post-assessment.
COMPLETION_STATUS (Oracle = number (3, 0)), (SQL = tinyint)
Indicates whether the user has completed the subject.
1 = Completed
2 = Incomplete
3 = Not Attempted
4 = Unknown
SCORE (Oracle = float), (SQL = real)
The score that the user attains when he or she completes the post-assessment.
TOTAL_QUESTION (Oracle = number), (SQL = int)
Total number of questions in the post-assessment
CORRECT_QUESTIONS (Oracle = number), (SQL = int)
The number of questions in the post-assessment that the user answered correctly.
RESULT_DATE (Oracle = timestamp (6)), (SQL = datetime)
The date and time that the user completed the post-assessment.