• 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)
  • 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), 11 (audio book)
  • Default Value: All available

• Description: Provides the ability to specify a completion status. You cannot select 'Any' if another value is also selected.
• Control Type: Multi-select
• BCS Parameter: completion_status
  • Possible Values: 1 (completed), 2 (in progress/accessed), 3 (waived), 4 (not started/not accessed)
  • Default Value: Any

• 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 specify one or more Development Plan statuses (Approved, Not Approved, Pending Approval, Denied).
• Control Type: Multi-select
• BCS Parameter: development_status
  • Possible Values: 1 (pending approval), 2 (not approved), 3 (denied), 4 (approved)
  • Default Value: pending approval, not approved, approved

• 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: first_access_date, last_access_date, completion_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 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 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: 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 only show assignments that have not been started, started (in progress), or completed and waived after due date.
• Control Type: Single-select check box
• BCS Parameter: only_assignments_exceeding_due_date
  • 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: 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 asset.
• BCS Value: asset_title

• Description: The current status of the assignment. If an assignment has been both Completed and Waived, whichever event happened first will be reported.
• BCS Value: assignment_status

• Description: The date on which the user is required to complete the asset assigned in his or her My Plan.
• BCS Value: myplan_due_date

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

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

• Description: The date the Development Plan was approved.
• BCS Value: development_plan_approval_date

• Description: Whether approval of the asset is required (Yes or No).
• BCS Value: approval_required

• Description: The login of the user who approved the asset.
• BCS Value: approved_by_username

• Description: The type of the asset.
• BCS Value: asset_category

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

• Description: The date the asset was assigned to the User/Group My Plan (or Development Plan).
• BCS Value: myplan_assigned_date

• Description: Displays the date the asset was completed only if the completion is prior to the last day of the date range.
• BCS Value: course_completion_date

• Description: The current status of the Development Plan (Approved, Not Approved, or Pending Approval).
• BCS Value: development_plan_status

• Description: The user's first access to the course during the report's time span. If the course was not launched (no access) during the date range of the report, this field will return no data.
• BCS Value: course_first_access

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

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

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

• Description: The highest score achieved by the user on or before the report end date.
• BCS Value: arl_high_score

• Description: The user's last access during the report's time span. If the course was not launched (no access) during the date range of the report, this field will return no data.
• BCS Value: course_last_access

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

• Description: The last score posted by the user on or before the report end date.
• BCS Value: course_current_score

• Description: The highest pre-assessment score achieved by the user on or before the report end date.
• BCS Value: course_pretest_score

• Description: The number of times that the user accessed (launched) the asset during the report's time span.
• BCS Value: course_access_count

• Description: The number of times the user has restarted the course when recurrence is enabled on the site.
• BCS Value: course_track

• 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: The first name of the user who assigned the asset to the User/Group My Plan (or Development Plan).
• BCS Value: myplan_assigned_by_first_name

• Description: The last name of the user who assigned the asset to the User/Group My Plan (or Development Plan).
• BCS Value: myplan_assigned_by_last_name

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

• Description: The date the student was registered (created) in Books24x7.
• BCS Value: cud_books_registration_dtm

• 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 user's last download on or before the end date of the report.
• BCS Value: course_last_download

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

• Description: The date enrollment in the asset was approved. Blank if not approvable, "-" if required but not yet approved.
• BCS Value: enrollment_approval_date

• Description: The expected duration of the asset. 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: asset_expected_duration

• 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 goal as entered into the My Plan (or Development Plan) entry.
• BCS Value: myplan_goal

• Description: The group from which the assignment was inherited.
• BCS Value: myplan_inherited_from

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

• Description: The number of page views during the specified time range.
• BCS Value: count_of_pages_viewed

• Description: The most recent date that a student logged into the Books24x7 website.
• BCS Value: cud_last_books24x7_login

• Description: The most recent date that a user logged into SkillPort.
• BCS Value: cud_last_skillport_login

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

• Description: Indicates the recurrence type for the corresponding assignment. Possible values include: By Completion Date, By Due Date, or None.
• BCS Value: recurrence_type

• Description: Indicates whether the asset is required (Yes or No).
• BCS Value: myplan_required

• Description: The date that the learner was registered (created) in SkillPort.
• BCS Value: cud_skillport_registration_dtm

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

• Description: The number of times that the user downloaded the asset during the report's time span.
• BCS Value: course_download_count

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

• Description: The first name of the user that waived completion of the asset.
• BCS Value: waived_by_first_name

• Description: The login of the user that waived completion of the asset.
• BCS Value: waived_by_username

• Description: The last name of the user that waived completion of the asset.
• BCS Value: waived_by_last_name

• Description: The user's note associated with the waiver request.
• BCS Value: waiver_learner_notes

• Description: The note associated with the completion waiver.
• BCS Value: waiver_notes

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