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.
USER_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier for the user.
This field is a primary key.
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.
SUBJECT_AU_SID (Oracle = number (10, 0)), (SQL = int)
There is no server ID in the new database, so this field is always 0.
This field is a primary key.
SUBJECT_AU_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier of the subject Learning Object.
This field is a primary key.
COMPLETE (Oracle = number (1, 0)), (SQL = bit)
Indicates whether the user has completed the subject.
1 = Completed
0 = Incomplete
COMPLETE_PERCENT (Oracle = float), (SQL = real)
Indicates the percentage of the subject the user has completed.
TOTAL_TIME_SPENT (Oracle = float), (SQL = real)
Indicates how much time (in seconds) the user has spent on the subject.
START_DATE (Oracle = timestamp (6)), (SQL = datetime)
The date that the user started the subject Learning Object.
COMPLETE_DATE (Oracle = timestamp (6)), (SQL = datetime)
The date that the user completed the subject Learning Object.
LAST_TRACK_DATE (Oracle = timestamp (6)), (SQL = datetime)
The most recent date and time that the user accessed the subject Learning Object.