This view provides information about the user's performance in assessments questions in subjects.
RUNTIMEID (Oracle = number (10, 0)), (SQL = int)
A server-generated unique value identifying a user attempt to take assessment questions in subjects.
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 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 subject assessment.
This field is a primary key.
ASSESSTYPE (Oracle = number (10, 0)), (SQL = int)
This value is always 0 for subject assessments.
This field is a primary key.
ACCESS_NAME (Oracle = nvarchar2), (SQL = nvarchar)
The name of the subject assessment.
COMPLETION_STATUS (Oracle = number (10, 0)), (SQL = int)
Indicates whether the user has completed the subject assessment.
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 subject assessment.
TOTAL_QUESTION (Oracle = number (10, 0)), (SQL = int)
Total number of questions in the subject assessment.
CORRECT_QUESTIONS (Oracle = number (10, 0)), (SQL = int)
The number of questions in the subject assessment that the user answered correctly.
RESULT_DATE (Oracle = timestamp (6)), (SQL = datetime)
The date and time that the user completed the subject assessment.