• KPVIEW_SUBJECT_LO_SUMMARY
  • KPVIEW_SUBJECT_LO_SUMMARY
  • "4c668ce1-9d28-493a-a1b7-d68beadca1a2
  • This view provides a tracking summary of all the Subject Learning Objects in learning activities. The Subject Learning Object is the learning object assigned to the subject of an activity, and it can be any learning object with an "Organization" or "Module" ONDEMANDTYPE in a package.
  • Upgrade Note:
  • USER_ID (Oracle = number (10, 0)), (SQL = int)
  • USERNAME (Oracle = nvarchar2), (SQL = nvarchar)
  • FIRST_NAME (Oracle = nvarchar2), (SQL = nvarchar)
  • LAST_NAME (Oracle = nvarchar2), (SQL = nvarchar)
  • SUBJECT_LO_ID (Oracle = number (10, 0)), (SQL = int)
  • COMPLETION_STATUS (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)
  • COMPLETE_DATE (Oracle = timestamp (6)), (SQL = datetime)
  • LAST_TRACK_DATE (Oracle = timestamp (6)), (SQL = datetime)