• KPVIEW_ACTIVITY_LO
  • KPVIEW_ACTIVITY_LO
  • "40da8237-609e-404d-8933-9351ac4974bc
  • This view displays information about all of the learning activities (units of learning) in the knowledge paths, including the course, pre-assessment and post-assessment in the activity and Learning Object identifier.
  • For installations upgraded from a previous Knowledge Pathways version, this view replaces the KPVIEW_ACTIVITY view. Previous views still appear with their original column names to preserve any existing reports based on these views.
  • Upgrade Note:
  • 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)
  • 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)
  • PREASSESS_LO_ID (Oracle = number (10, 0)), (SQL = int)
  • PREASSESS_REQUIRED (Oracle = number (1, 0)), (SQL = bit)
  • Indicates if the pre-assessment of the activity is required.
  • PREASSESS_REQUIRED_SCORE
  • (Oracle = number), (SQL = numeric)
  • HAS_SUBJECT (Oracle = number (1, 0)), (SQL = bit)
  • SUBJECT_LO_ID (Oracle = number (10, 0)), (SQL = int)
  • HAS_POSTASSESS (Oracle = number (1, 0)), (SQL = bit)
  • 1 = the activity has a post-assessment
  • POSTASSESS_LO_ID (Oracle = number (10, 0)), (SQL = int)
  • POSTASSESS_REQUIRED (Oracle = number (1, 0)), (SQL = bit)
  • Indicates if the post-assessment of the activity is required.
  • (Oracle = number), (SQL = numeric)
  • SORT_ORDER (Oracle = number (10, 0)), (SQL = int)