• KPVIEW_SUBJECT_AU_SUMMARY
  • KPVIEW_SUBJECT_AU_SUMMARY
  • "39aff7ad-a6fb-4c97-af78-344e1b28fb94
  • This view is inherited from Professional edition 6.1 and only appears for upgraded installations; however, the column descriptions correspond to the new database views. To review the original descriptions for a view, please consult your Professional edition 6.1 documentation.
  • 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_AU_SID (Oracle = number (10, 0)), (SQL = int)
  • SUBJECT_AU_ID (Oracle = number (10, 0)), (SQL = int)
  • COMPLETE (Oracle = number (1, 0)), (SQL = bit)
  • 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)