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.