• Description: Allows the user to determine an end date for the report activity. Selecting 'As of Today' will automatically set the end date to the current date. Selecting 'As of' requires an end date.
• Control Type: Multi-option
• BCS Parameter:
  activity_date_type (This parameter is optional.)
  • Possible Values: 3 ('As of') or 4 ('As of Today')

    If the activity_date_type = 3, then the following parameter is required:

    BCS Parameter: activity_end_date

    Possible Values: <date_value in the format MM/DD/YYYY>

    If activity_date_type = 4, then the date 'As of Today' is automatically selected, and you do not need to provide any date values.

  • Default Values:
    Default value is 4. However, if an activity_end_date is specified, then the activity_date_type defaults to 3.

• Description: Provides the ability to select one, many, or all assets in the filter criteria.
• Control Type: Multi-select list
• BCS Parameter: asset_list
  • Possible Values: CSV list of <any_asset_id> values
  • Default Value: All available

• Description: Provides the ability to select all or specific asset categories.
• Control Type: Multi-select
• BCS Parameter: asset_category
  • Possible Values: 1 (Book), 2 (Course), 3 (Custom Content), 6 (Express Guides), 8 (Instructor Led Training), 9 (Job Aids), 15 (Mentoring), 16 (Practice Labs), 17 (Projects), 18 (Simulations), 19 (SkillBriefs), 20 (TestPrep Exams), 21 (Videos), 24 (Learning Sparks), 25 (Business Impact), 26 (Challenge), 27 (Book Sections), 28 (Course Topics)
  • Default Value: All available
• BCS Parameter: asset_subcategory
  • Possible Values: 0 (chapter), 1 (journal), 2 (reference suite), 3 (execsummary), 4 (execblueprint), 5 (journal style toc), 6 (analyst perspective), 7 (review), 8 (video), 9 (recorded session), 10 (newsletter)
  • Default Value: All available

• Description: Provides the ability to filter on one or two fields that exist in the report definition. You can define either an AND or an OR statement when using two filters. The field selector drop-down will include all fields that are available in the report definition.
• Control Type: Logical filter
• BCS Parameter: you cannot specify custom filters when running this report via BCS

• Description: Provides the ability to select one, many, or all Groups as part of the filter criteria.
• Control Type: Multi-select
• BCS Parameter: group_list
  • Possible Values: CSV list of <group_orgcode> values
  • Default Value: All

• Description: Allows the user to select one event and then filter that event by date.
• Control Type: Single-select
• BCS Parameter: date_filter_field
  • Possible Values: completion_date, due_date

Dynamic Dates

For dynamic dates that change each time the report is accessed, use the following parameters:

• BCS Parameter: filter_start_date
  • Possible Values: <date_value in the format MM/DD/YYYY>
  • Default Value: one month prior to the date the report is run
• BCS Parameter: filter_end_date (optional)
  • Possible Values: <date_value in the format MM/DD/YYYY>
  • Default Value: 'now', or the last successful database refresh

    Note: Default start and end dates will only be used if a date_filter_field value is entered and the date values are left blank.

Static Dates

For static dates, use the following parameters:

• BCS Parameter: filter_date_period (required)
  • Possible Values: 1 (Days), 2 (Weeks), 3 (Months), 4 (Years)
  • Default Value: 3
• BCS Parameter: filter_date_period_count (required)
  • Possible Values: valid numeric value with the following maximum value for each report_date_period:

    Days - 9999

    Weeks - 999

    Months - 999

    Years - 99

  • Default Value: 1

Filter to Date

The filter_to_date parameter allows you to include all activity up to the current date and time, regardless of the report_date_period chosen.

• BCS Parameter: filter_to_date (optional)
  • Possible Values: true or false
  • Default Value: true

• Description: Provides a list of standard time zones so you can determine the presentation of date outputs. When selected, a calculation will be performed on the output during processing to change the date value from UTC to the selected time zone. Default value is GMT.
• Control Type: Single-select
• BCS Parameter: time_zone
  • Possible Values: see BCS SubmitReport Time Zones for a list of acceptable values
  • Default Value: GMT

• Description:  Provides the ability to filter data based on user profile fields that have been configured and enabled on the User Profile page.
• Control Type:  Logical filter
• BCS Parameter: You cannot specify User Profile filters when running this report via BCS.

• Description: Includes timestamps in all date fields in the report.
• Control Type: Single-select check box
• BCS Parameter: show_date_with_time
  • Possible Values: 0 (don’t show), 1 (show)
  • Default Value: Don't show

• Description: Provides the ability to include subgroups within the scope of the report.
• Control Type: Single-select check box
• BCS Parameter: select_subgroups
  • Possible Values: 0 (don’t select), 1 (select)
  • Default Value: Don't select

• Description: The title of the asset.
• BCS Value: asset_title

• Description: The name of the group.
• BCS Value: group_title

• Description: The total number of users in the group who have completed an assignment within the specified date range.
• BCS Value: total_completed

• Description: The total number of users in the group who have not completed an assignment within the specified date range.
• BCS Value: total_not_completed

• Description: The total number of users who have not completed an assignment within the specified date range and have passed the due date.
• BCS Value: total_overdue

• Description: The ID of the learning asset, for example, COMM0101.
• BCS Value: asset_name

• Description: The organization code associated with the group.
• BCS Value: group_orgcode

• Description: The path to the group's location based on the hierarchy configured in SkillPort.
• BCS Value: group_path