- KPVIEW_ASSESSINSUBJECT_RUNTIME
- KPVIEW_ASSESSINSUBJECT_RUNTIME
- "ee829bef-2ef8-49b2-bfe2-679224246afc
- This view provides a tracking summary of inline assessments (assessments in the subject learning object).
- RUNTIMEID (Oracle = number (10, 0)), (SQL = int)
- A server-generated unique value identifying a user attempt to take assessment questions in subjects.
- This field is a primary key.
- USER_ID (Oracle = number (10, 0)), (SQL = int)
- Unique identifier for the user.
- 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.
- GUIDMAPID (Oracle = number (10, 0)), (SQL = int)
- This unique identifier correlates to the primary key in the GUIDMAP table for the Learning Object and is used to join this table to other tables.
- ASSESS_LO_ID (Oracle = number (10, 0)), (SQL = int)
- The unique identifier for the subject assessment.
- This field is a primary key.
- ASSESSTYPE
- (Oracle = number (3, 0)), (SQL = tinyint)
- This value is always 0 for subject assessments.
- This field is a primary key.
- ACCESS_NAME (Oracle = nvarchar2), (SQL = nvarchar)
- The name of the subject assessment.
- COMPLETION_STATUS
- (Oracle = number (3, 0)), (SQL = tinyint)
- Indicates whether the user has completed the subject assessment.
- 1 = Completed
- 2 = Incomplete
- 3 = Not Attempted
- 4 = Unknown
- SCORE (Oracle = float), (SQL = real)
- The score that the user attains when he or she completes the subject assessment.
- TOTAL_QUESTION (Oracle = number), (SQL = int)
- Total number of questions in the subject assessment.
- CORRECT_QUESTIONS (Oracle = number), (SQL = int)
- The number of questions in the subject assessment that the user answered correctly.
- RESULT_DATE (Oracle = timestamp (6)), (SQL = datetime)
- The date and time that the user completed the subject assessment.