• 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.