- KPVIEW_POSTASSESS_RUNTIME
- KPVIEW_POSTASSESS_RUNTIME
- "d60a7d38-5adc-428e-b8ad-cb212f8ae25f
- This view provides tracking summary of post-assessments. Note that post-assessments can be taken multiple times and all of the results are available in this view. These can then be filtered by highest score, lowest score, average score, latest score, or result date.
- For installations upgraded from Professional edition 6.1, this view replaces the KPVIEW_POSTASSESS_SUMMARY view. Previous views still appear with their original column names to preserve any existing reports based on these views.
- Upgrade Note:
- RUNTIMEID (Oracle = number (10, 0)), (SQL = int)
- A server-generated unique value identifying a user attempt to take the post-assessment.
- This field is a primary key.
- USERNAME (Oracle = nvarchar2), (SQL = nvarchar)
- FIRST_NAME (Oracle = nvarchar2), (SQL = nvarchar)
- 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 post-assessment 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 post-assessment.
- This field is a primary key.
- ASSESSTYPE (Oracle = number (3, 0)), (SQL = tinyint)
- This value is always 2 for a post-assessment.
- This field is a primary key.
- ACCESS_NAME (Oracle = nvarchar2), (SQL = nvarchar)
- The name of the post-assessment.
- COMPLETION_STATUS (Oracle = number (3, 0)), (SQL = tinyint)
- Indicates whether the user has completed the subject.
- 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 post-assessment.
- TOTAL_QUESTION (Oracle = number), (SQL = int)
- Total number of questions in the post-assessment
- CORRECT_QUESTIONS (Oracle = number), (SQL = int)
- The number of questions in the post-assessment that the user answered correctly.
- RESULT_DATE (Oracle = timestamp (6)), (SQL = datetime)
- The date and time that the user completed the post-assessment.