- KPVIEW_LO_RESULT
- KPVIEW_LO_RESULT
- "ca292e3b-06e0-443f-9634-5f2b88ae6b87
- 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 = Learning object in the subject tree that is not a pre-assessment or post-assessment.
- 1 = Pre-assessment type
- 2 = Post-assessment type
- COMPLETE (Oracle = number (3, 0)), (SQL = tinyint)
- COMPLETE_PERCENT
- (Oracle = float), (SQL = real)
- TOTAL_TIME_SPENT
- (Oracle = float), (SQL = real)
- 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.