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.


Table of Contents  Back

KPVIEW_PREASSESS_SUMMARY