This view is inherited from Professional edition 6.1 and only appears for upgraded installations; however, the column descriptions correspond to the new database views. To review the original descriptions for a view, please consult your Professional edition 6.1 documentation.
ASSESS_RESULT_ID (Oracle = number (10, 0)), (SQL = int)
The unique identifier for the pre-assessment result.
This field is a primary key.
USER_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier for the user.
USERNAME (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.
PREASSESS_AU_SID (Oracle = number (10, 0)), (SQL = int)
There is no server ID in the current database, so this field is always 0.
PREASSESS_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier of the pre-assessment on the server.
ACCESS_NAME (Oracle = nvarchar2), (SQL = nvarchar)
The name of the pre-assessment.
COMPLETE (Oracle = number (1, 0)), (SQL = bit)
Indicates whether the user has completed the subject.
1 = Completed
0 = Incomplete
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.