• 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 (optional)
  • Possible Values: <date_value in the format MM/DD/YYYY>
  • Default Value: the first day of the preceding calendar month
• 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)

  If you are using report_date periods, report_to_date=true will include all activity for the requested periods plus activity in the current period up to the current date and time.  If report_to_date=false, the report will only include activity for the requested periods.

  • Possible Values: true or false
  • Default Value: true
• Example:
  • If report_to_date = true, the end date is always the date the report is run, up to and including the most recent database refresh.
  • If report_to_date = false, the end date is the last day of the previous interval. For instance, if today is December 31, the ‘Previous [n] Months’ ends on November 30 and the ‘Previous [n] Years’ ends on December 31 of the prior year.
• 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 only show activity for Books and Videos accessed through the Mobile site.
• Control Type: Single-select
• BCS Parameter: books24x7_mobile_usage
  • Possible Values: 0 (unchecked, show all activity), 1 (checked, only show mobile site activity)
  • Default Value: unchecked

• Description: Provides the ability to specify a seat status.
• Control Type: Single-select
• BCS Parameter: seat_status
  • Possible Values: 0 (deleted), 1 (occupied), 2 (Any)
  • Default Value: Any

• 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 specify a Books and Videos subscription for a list of all subscriptions associated with the Skillport site.
• Control Type: Single-select
• BCS Parameter: subscription_id
  • Possible Values: <books_subscription_id>
  • Default Value: Company subscription id

• 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 filter data based on user profile fields that have been configured and enabled on the User Profile page.
• Control Type:  Logical filter
• BCS Parameter: N/A

• 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: Show

• 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: Provides a list of standard time zones so you can display the times in your local time zone. This does not affect the actual UTC time of the activity. Default value is UTC.
• 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: User's login name.
• BCS Value: skillport_username

• Description: The number of Chapters to Go files downloaded by the specified user during the specified time range.

• Description: The list of collections available to the user.
• BCS Value: collections_list

• 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 number of page views during the specified time range.
• BCS Value: course_page_count

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

• Description: The number of downloads by the specified user during the specified time range.
• BCS Value: count_of_other_downloads_for_user

• Description: Unique character string used to identify Books and Videos subscriptions.
• BCS Value: bs_subscription_display_name

• Description: The number of unique titles accessed by the specified user during the specified time range.
• BCS Value: count_of_unique_assets_accessed_for_user

• Description: The number of video files accessed by the specified user during the specified time range. Applies to subscriptions that include LDC only.
• BCS Value: count_of_user_video_downloads_for_user

• Description: The user's first name as it appears in Skillport.
• BCS Value: cud_display_first_name

• Description: The user's last name as it appear in Skillport.
• BCS Value: cud_display_last_name

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

• 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 user's geographic location (for example, where the user's office or branch is located).
• BCS Value: cud_location

• Description: The Skillport database internal userid field.
• BCS Value: cud_user_id

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