This view provides tracking results of all the Learning Objects.
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.
LO_ID (Oracle = number (10, 0)), (SQL = int)
The unique identifier of the LO.
This field is a primary key.
ASSESSTYPE (Oracle = number (3, 0)), (SQL = tinyint)
The value indicates the assessment type of the Learning Object.
0 = Not an assessment
1 = Pre-assessment type
2 = Post-assessment type
This field is a primary key.
COMPLETION_STATUS (Oracle = number (10, 0)), (SQL = int)
Indicates whether the user has completed the subject.
1 = Completed
2 = Incomplete
3 = Not Attempted
4 = Unknown
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 and time that the user started the subject Learning Object.
COMPLETE_DATE (Oracle = timestamp (6)), (SQL = datetime)
The date and time 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.
SUCCESS_STATUS (Oracle = number (3, 0)), (SQL = tinyint)
The success status of the user taking the subject Learning Object.
1 = Passed
2 = Failed
3 = Unknown
SCORE_SCALED (Oracle = float), (SQL = real)
The score of the user taking the Learning Object.