|
|
|
Summary by User
This report is filtered by Enrollment Date, and only includes data for users with enrollment dates on or before the Report End Date. In most cases, you will want to leave the End Date to the default of today and extend the Start Date to a date prior to when any user enrolled in the Learning Program (LP).
Also note that, by default, the report only includes enrolled users who have started or completed the LP. If you want to include users who have enrolled, but not started, or users that have declined enrollment, use the Learning Program Status filter in the Asset Filter tab.
BCS Report Parameter: lp_summary_by_user
Filter Controls
- 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
- Possible Values: valid numeric value with the following maximum value for each report_date_period:
- 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 select one, many, or all assets in the filter criteria.
- Control Type: Multi-select
- BCS Parameter: asset_list
- Possible Values: CSV list of <Learning Program_asset_id> values
- Default Value: All available
Note: In the Matrix by Learning Program report, you are limited to selecting only one Learning Program at a time.
- 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, asset_enrolled_date
Static Dates
To enter static dates, use the following parameters with a specific date for the filter_start_date and filter_end_date parameters:
- BCS Parameter: filter_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: 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. In this instance, the date values are dynamic and will update each time the report is run.
Dynamic Dates
For dynamic dates that change each time the report is run, 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
- Possible Values: valid numeric value with the following maximum value for each report_date_period:
Filter to Date
If you are using filter_date periods, filter_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 filter_to_date=false, the report will only include activity for the requested periods.
- BCS Parameter: filter_to_date (optional)
- Possible Values: true or false
- Default Value: true
- Example:
- If filter_to_date = true, the end date is always the date the report is run, up to and including the most recent database refresh.
- If filter_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.
- Description: Provides the ability to specify one or more learning program statuses.
- Control Type: Multi-select
- BCS Parameter: lp_status
- Possible Values: 1 (completed), 2 (started), 3 (withdrawn), 4 (enrolled but not started), 5 (declined)
- Default Value: Completed, Started
- 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: N/A
Display Options
- 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
Required Columns
- Description: The title of the learning program.
- BCS Value: lp_title
- Description: User's login name.
- BCS Value: skillport_username
Default Columns
- Description: The date the learner enrolled or was administratively enrolled in the Learning Program. The Enrollment Date is always on or before the Report End Date.
- BCS Value: course_enrollment_date
- 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 user's last name.
- BCS Value: user_last_name
Learning Program Completion Date
- Description: TThe date the Learning Program was completed. The Report Date Range is ignored.
- BCS Value: lp_completion_date
Learning Program First Access Date
- Description: The user’s first access to the Learning Program. The Report Date Range is ignored.
- BCS Value: lp_first_access
- Description: The ID of the learning program.
- BCS Value: lp_name
Learning Program Last Access Date
- Description: Date the asset was last accessed. The Report Date Range is ignored.
- BCS Value: lp_last_access
- Description: The current status of the Learning Program as of the date the report is run. Possible values include: Started, Completed, or Enrolled but not started.
- BCS Value: lp_status
- Description: The percentage of completed assets based on the number of completable assets that are required to be completed* in order for the Learning Program (LP) to be considered complete. Only counts assets completed on or before the To date of the Activity Date Range.
*The required number of completed assets can be determined when you create the LP.
- BCS Value: course_progress
Optional Columns
- 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 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