• KPVIEW_ACTIVITY
  • KPVIEW_ACTIVITY
  • "e66df2cb-356b-4f79-aef4-d599a806db5c
  • 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.
  • ACTIVITY_ID (Oracle = number (10, 0)), (SQL = int)
  • ACTIVITY_NAME (Oracle = nvarchar2), (SQL = nvarchar)
  • PARENT_ACTIVITY_ID (Oracle = number (10, 0)), (SQL = int)
  • PATH_ID (Oracle = number (10, 0)), (SQL = int)
  • PATH_NAME (Oracle = nvarchar2), (SQL = nvarchar)
  • ORGANIZATIONAL (Oracle = number (1, 0)), (SQL = bit)
  • HAS_PREASSESS (Oracle = number (1, 0)), (SQL = bit)
  • There is no server ID in the current database, so this field is always 0.
  • PREASSESS_AU_SID (Oracle = number (10, 0)), (SQL = int)
  • PREASSESS_ID (Oracle = number (10, 0)), (SQL = int)
  • PREASSESS_REQUIRED_SCORE (Oracle = float), (SQL = real)
  • HAS_SUBJECT (Oracle = number (1, 0)), (SQL = bit)
  • SUBJECT_AU_SID (Oracle = number (10, 0)), (SQL = int)
  • SUBJECT_AU_ID (Oracle = number (10, 0)), (SQL = int)
  • HAS_POSTASSESS (Oracle = number (1, 0)), (SQL = bit)
  • POSTASSESS_AU_SID (Oracle = number (10, 0)), (SQL = int)
  • POSTASSESS_ID (Oracle = number (10, 0)), (SQL = int)
  • POSTASSESS_REQUIRED_SCORE (Oracle = float), (SQL = real)
  • SORT_ORDER (Oracle = number (10, 0)), (SQL = int)