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