• Description: Allows the user to determine the date range for all activity for the report.
• Control Type: Multi-option

Use the following parameters to set start and end dates.

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

Use the following parameters to set dates for a number of previous intervals, such as, "previous 3 months."

• BCS Parameter: report_date_period (required)
  • Possible Values: 1 (Days), 2 (Weeks), 3 (Months), 4 (Years)
  • Default Value: 3
• BCS Parameter: report_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
• BCS Parameter: report_to_date (optional)

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

  • Possible Values: true or false
  • Default Value: true
• BCS Parameter: display_units (optional and used in chart templates only)
  • Possible Values: 1 (Year), 2 (Quarter), 3 (Months), 4 (Weeks), 5 (Days)
  • Default Value: 3

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

• 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: Provides the ability to select one, many, or all users or groups as part of the filter criteria.
• Control Type: Multi-select
• BCS Parameter: user_list
  • Possible Values: CSV list of <username> values
  • Default Value: All
• BCS Parameter: group_list
  • Possible Values: CSV list of <group_orgcode> values
  • Default Value: All

    Note: In some templates the Group or the User filter may not be available. For instance, if the report is group specific then the user filter may be disabled.

• Description: Provides the ability to specify user statuses.
• Control Type: Multi-select
• BCS Parameter: user_status
  • Possible Values: 1 (activated), 2 (deactivated)
  • Default Value: Activated

• 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: Provides the ability to roll up the activity of members of subgroups into higher-level group summary fields.
• Control Type: Single-select check box
• BCS Parameter: rollup_members_of_subgroups
  • Possible Values: 0 (don’t roll up), 1 (roll up)
  • Default Value: Don't roll up

• Description: Used to determine how records that contain field(s) that could have multiple values (such as a user that exists in multiple groups) present or stored the data in the report. If multiple rows are selected, a record will be provided for every instance.
• Control Type: Single-select
• BCS Parameter: show_multiple_groups
  • Possible Values: 1 (multiple rows), 2 (single row)
  • Default Value: Multiple rows

• Description: The title of the KnowledgeCenter.
• BCS Value: kc_title

• Description: User's login name.
• BCS Value: skillport_username

• Description: The total number of launches in the specified date range.
• BCS Value: count_of_kc_launches

• Description: The total cumulative duration for all launches in the specified date range for assets for which duration is tracked. Displayed in hh:mm format for Previewed reports, and reports exported to PDF and HTML. Displayed in minutes for reports exported to CSV and Excel.
• BCS Value: sum_of_durations_via_kc_by_user

• Description: The total number of asset accesses across all users. Not unique by user or asset.
• BCS Value: count_of_launches_via_kc_by_user

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.
• BCS Value: count_of_launches_of_business_impact_via_bes

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.
• BCS Value: count_of_launches_of_challenge_series_via_bes

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.
• BCS Value: count_of_launches_of_courses_via_kc

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.
• BCS Value: count_of_launches_of_custom_category_via_kc

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.
• BCS Value: count_of_launches_of_express_guides_via_kc

• Description: The user's first name.
• BCS Value: user_first_name

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

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.
• BCS Value: count_of_launches_of_job_aids_via_kc

• Description: The total number of accesses to any asset of the specified type during the time period by users matching the filters.
• BCS Value: count_of_launches_of_knowledgecenter_via_kc

• Description: The ID of the KnowledgeCenter.
• BCS Value: kc_name

• Description: The user's last name.
• BCS Value: user_last_name

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.
• BCS Value: count_of_launches_of_learning_sparks_via_kc

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.
• BCS Value: count_of_launches_of_mentoring_via_kc

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.
• BCS Value: count_of_launches_of_practice_lab_via_kc

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.
• BCS Value: count_of_launches_of_projects_via_kc

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.
• BCS Value: count_of_launches_of_simulations_via_kc

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.
• BCS Value: count_of_launches_of_skillbriefs_via_kc

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.
• BCS Value: count_of_launches_of_leadership_advantage_via_kc

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.
• BCS Value: count_of_launches_of_testprep_exam_via_kc

• Description: The total number of accesses to any asset of the specified type during the specified time period by users matching the filters.

• Description: The first line of the address of the user.
• BCS Value: cud_user_address1

• Description: The second line of the address of the user.
• BCS Value: cud_user_address2

• Description: The first name of the approval manager.
• BCS Value: cud_approval_manager_first_name

• Description: The ID of the approval manager.
• BCS Value: cud_approval_manager_skillport_name

• Description: The last name of the approval manager.
• BCS Value: cud_approval_manager_last_name

• Description: This is the user-customizable date field within the User Stat list.
• BCS Value: cud_user_birthdate

• Description: Used to capture the expiration date of the credit card. This is an open, configurable User Stat field.
• BCS Value: cud_user_ccexpr

• Description: Used to capture the credit card number. This is an open, configurable User Stat field.
• BCS Value: cud_user_ccnumber

• Description: Used to capture the type of the credit card. This is an open, configurable User Stat field.
• BCS Value: cud_user_cctype

• Description: The city of the user.
• BCS Value: cud_user_city

• Description: The country of the user.
• BCS Value: cud_user_country

• Description: The email address of the user.
• BCS Value: cud_user_email

• Description: This field is an open, configurable User Stat field.
• BCS Value: cud_user_free1

• Description: The gender of the user.
• BCS Value: cud_user_gender

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

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

• Description: The phone number of the user.
• BCS Value: cud_user_phone

• Description: The user's state
• BCS Value: cud_user_state

• Description: The user's SkillPort role: Super Administrator, Company Administrator, Company Administrator-Custom, Administrator, Administrator-Custom, Manager, Manager-Custom, and End-User.
• BCS Value: user_role

• Description: The user's status: Activated, Deactivated, or Pending.
• BCS Value: user_status

• Description: The zip code or postal code for a user.
• BCS Value: cud_user_zip