- 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)