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.
AU_SID (Oracle = number (10, 0)), (SQL = int)
There is no server ID in the current database, so this field is always 0.
AUNODE_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier of the node on the server.
This field is a primary key.
SUBJECT_AU_SID (Oracle = number (10, 0)), (SQL = int)
There is no server ID in the current database, so this field is always 0.
SUBJECT_AU_ID (Oracle = number (10, 0)), (SQL = int)
The tracking of a learning object in this database is not tied to a course anymore. The tracking data of a learning object is shared no matter the item with the same GUID is taken from different activities, or from different learning package, or either from KPATH or from the Player. Therefore, this field is always 0.
TRACK_DATE (Oracle = timestamp (6)), (SQL = datetime)
The date and time that the user accessed the subject Learning Object.
TIME_SPENT (Oracle = float), (SQL = real)
Indicates how much time (in seconds) the user has spent on the Learning Object.