• KPVIEW_PREASSESS_RUNTIME
  • KPVIEW_PREASSESS_RUNTIME
  • "007ad6aa-b52d-4795-b72d-9884e5ac8f03
  • This view provides tracking summary of pre-assessments. Note that pre-assessment can be taken only once by a user.
  • For installations upgraded from Professional edition 6.1, this view replaces the KPVIEW_PREASSESS_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 pre-assessment.
  • 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 pre-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 pre-assessment.
  • This field is a primary key.
  • ASSESSTYPE
  • (Oracle = number (3, 0)), (SQL = tinyint)
  • This value is always 1 for a pre-assessment.
  • This field is a primary key.
  • ACCESS_NAME (Oracle = nvarchar2), (SQL = nvarchar)
  • The name of the pre-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 pre-assessment.
  • TOTAL_QUESTION (Oracle = number), (SQL = int)
  • Total number of questions in the pre-assessment
  • CORRECT_QUESTIONS (Oracle = number), (SQL = int)
  • The number of questions in the pre-assessment that the user answered correctly.
  • RESULT_DATE (Oracle = timestamp (6)), (SQL = datetime)
  • The date and time that the user completed the pre-assessment.