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)
Unique identifier of the activity on the server.
This field is a primary key.
ACTIVITY_NAME (Oracle = nvarchar2), (SQL = nvarchar)
Name of the activity as it appears to the user.
PARENT_ACTIVITY_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier of the parent activity.
PATH_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier of the knowledge path that the activity is in.
PATH_NAME (Oracle = nvarchar2), (SQL = nvarchar)
Name of the knowledge path that the activity is in.
ORGANIZATIONAL (Oracle = number (1, 0)), (SQL = bit)
Indicates whether the activity is for organizational purposes only.
0 = the activity has a subject and/or assessments
1 = the activity is organizational and contains no subject or assessments
HAS_PREASSESS (Oracle = number (1, 0)), (SQL = bit)
Indicates whether the activity has a pre-assessment defined.
0 = the activity has no pre-assessment
1 = the activity has a pre-assessment
PREASSESS_AU_SID (Oracle = number (10, 0)), (SQL = int)
There is no server ID in the current database, so this field is always 0.
PREASSESS_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier of the pre-assessment on the server.
PREASSESS_REQUIRED_SCORE (Oracle = float), (SQL = real)
The score required to pass the pre-assessment.
HAS_SUBJECT (Oracle = number (1, 0)), (SQL = bit)
Indicates whether the activity has a subject, or only assessments.
0 = the activity contains only assessments and the subject has been suppressed
1 = the activity has a subject (LO)
SUBJECT_AU_SID (Oracle = number (10, 0)), (SQL = int)
There is no server ID in the current database, so this field is always 0.
SUBJECT_AU_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier of the subject on the server.
HAS_POSTASSESS (Oracle = number (1, 0)), (SQL = bit)
Indicates whether the activity has a post-assessment defined.
0 = the activity has no post-assessment
1 = the activity has a post-assessment
POSTASSESS_AU_SID (Oracle = number (10, 0)), (SQL = int)
There is no server ID in the current database, so this field is always 0.
POSTASSESS_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier of the post-assessment on the server.
POSTASSESS_REQUIRED_SCORE (Oracle = float), (SQL = real)
The score required to pass the post-assessment.
SORT_ORDER (Oracle = number (10, 0)), (SQL = int)
Sort order of the activity.