This view provides tracking summary of pre-assessments. Note that pre-assessment can be taken only once by a user.
Upgrade Note: For installations upgraded from Professional edition 6.1, this view replaces the KPVIEW_PREASSESS_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 pre-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 pre-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 pre-assessment.
This field is a primary key.
ASSESSTYPE (Oracle = number (10, 0)), (SQL = int)
This value is always 1 for a pre-assessment.
This field is a primary key.
ACCESS_NAME (Oracle = nvarchar2), (SQL = nvarchar)
The name of the pre-assessment.
COMPLETION_STATUS (Oracle = number (10, 0)), (SQL = int)
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 pre-assessment.
TOTAL_QUESTION (Oracle = number (10, 0)), (SQL = int)
Total number of questions in the pre-assessment
CORRECT_QUESTIONS (Oracle = number (10, 0)), (SQL = int)
The number of questions in the pre-assessment that the user answered correctly.
RESULT_DATE (Oracle = timestamp (6)), (SQL = datetime)
The date and time that the user completed the pre-assessment.