• 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 <ilt_course_id> values
  • 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: 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: ilt_session_start_date, ilt_session_end_date, ilt_session_registration_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 the ability to specify an ILT course status.
• Control Type: Single-select
• BCS Parameter: ilt_course_status
  • Possible Values: 1 (active), 0 (inactive)
  • Default Value: All

• Description: Provides the ability to select an ILT session status.
• Control Type: Multi-select
• BCS Parameter: session_status
  • Possible Values: 0 (new), 100 (confirmed), 200 (closed), 400 (completed), -100 (cancelled)
  • Default Value: All

• 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: 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 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: The language in which the course is taught. SkillPort's SEARCH&LEARN feature allows users to search for courses available in a particular language. An ILT course may be offered in more than one language on a per-session basis, but for SkillPort to differentiate by language, each must be entered as a separate course.
• BCS Value: ilt_language

• Description: The title of the ILT course.
• BCS Value: ilt_name

• Description: Indicates whether enrollments in this session require Manager Approval.
• BCS Value: ilt_manager_approval_required

• Description: Describes whether the session is Physical Classroom, Virtual-Dialogue Live or Virtual-Other.
• BCS Value: ilt_session_type

• Description: The total number of users who have completed the session.
• BCS Value: count_of_ilt_session_users_completed

• Description: The owner of the course.
• BCS Value: ilt_course_administrator_1

• Description: The owner of the course.
• BCS Value: ilt_course_administrator_2

• Description: The owner of the course.
• BCS Value: ilt_course_administrator_3

• Description: The identifying course code or course number for the ILT course.
• BCS Value: ilt_number

• Description: The total number of users who are enrolled for the session.
• BCS Value: count_of_ilt_session_users_registered

• Description: The length of time required to complete a course (HH:MM). Duration is also the number of hours of training for which the learner will receive credit. This value is reported to SkillPort and appears in a user's My Progress.
• BCS Value: ilt_scheduled_course_duration

• Description: The total number of users who can be enrolled or registered for the session.
• BCS Value: ilt_session_capacity

• Description: The end date of the ILT session.
• BCS Value: ilt_session_endDate

• Description: Open / Closed to additional enrollments.
• BCS Value: ilt_session_enrollment_status

• Description: The number or unique ID for the ILT session.
• BCS Value: ilt_session_number

• Description: The start date of the ILT session.
• BCS Value: ilt_session_startDate

• Description: The current status of a session: Unconfirmed, Confirmed, Canceled, Completed.
• BCS Value: ilt_session_status

• Description: The total number of users who are waiting for the session.
• BCS Value: count_of_ilt_session_users_waiting

• Description: The total number of users who have withdrawn from the session; not including Late Withdrawals.
• BCS Value: count_of_ilt_session_users_withdrawn

• Description: Number of users with Late-Withdrawn status.
• BCS Value: ilt_late_withdrawal

• Description:  Notes or comments inputted by the administrator to the student record within the session details.
• BCS Value: ilt_session_notes

• Description: The average score given to all users within all sessions associated with the given ILT course.
• BCS Value: ilt_ave_score

• Description: The name of the customized attribute for the ILT session.
• BCS Value: ilt_session_extended_attribute_name

• Description: The cost of the ILT course.
• BCS Value: ilt_cost

• Description: The currency used in the cost of the ILT course.
• BCS Value: ilt_currency

• Description: The description of the ILT course.
• BCS Value: ilt_description

• Description: Indicates whether the instructor can manage the roster.
• BCS Value: ilt_session_instructor_can_manage_roster

• Description: The owner of a session.
• BCS Value: ilt_session_administrator_1

• Description: The owner of a session.
• BCS Value: ilt_session_administrator_2

• Description: The owner of a session.
• BCS Value: ilt_session_administrator_3

• Description: Whether the session requires approval for enrollment.
• BCS Value: ilt_session_approval_required

• Description: The approver of the session.
• BCS Value: ilt_session_approver

• Description: The classroom in which the session will be conducted.
• BCS Value: ilt_session_classroom

• Description: The contact field in the Session Details page of ILT.
• BCS Value: ilt_session_contact

• Description: The facility in which the session will be held.
• BCS Value: ilt_session_facility

• Description: The instructor for the session.
• BCS Value: ilt_session_instructor

• Description: The time zone in which the session will be held.
• BCS Value: ilt_session_tzid