|
|
|
User Privilege Detailed by Group
Displays the roles and privileges assigned to each user for each selected group.
- BCS Parameter: user_privilege_detailed_by_group
Filter Controls
- 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: skillport_registration_dtm, last_login
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
- Possible Values: valid numeric value with the following maximum value for each report_date_period:
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 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 included User Privileges.
- Control Type: Multi-Select List
- BCS Parameter: user_privilege
- Possible Values: 1 (Learner Record Assigner), 2 (Curriculum Assigner), 4 (Curriculum Builder), 8 (User Manager), 64 (Course Eval Builder), 512 (RUM Access)*, 1024 (Admin Presentation), 2048 (Admin Reports), 4096 (Admin System), 8192 (Admin Management), 16384 (Books24x7 Assigner), 32768 (Learning Programs), 65536 (Delete User)*, 131072 (Enrollment), 262144 (License)*, 1048576 (Remove Allocation)*, 2097512 ( Multiple Completion Access), 4194304 (Users and Groups), 8388608 (Assignment Group Access), 16777216 (Ingenius Settings), -2147483647 (ILT Administrator), -2147483646 (ILT Instructor), -2147483644 (ILT Session Administrator), -2147483642 (ILT Session Approver), -2147483640 (ILT Course Administrator), 33554432 (Delete Email Template), 67108864 (Notification Access), 268435456 (Keywords)
- Default Value: All
* Visibility of this value is only available to users that have the Super Administrator role.
- 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 ability to select included User Roles.
- Control Type: Multi-select
- BCS Parameter: user_role
- Possible Values: 0 (End User), 1 (Manager), 2 (Administrator), 3 (Company Administrator), 4 (Super Administrator)*
- Default Value: All, except for End User
* Visibility of this value is only available to users that have the Super Administrator role.
- 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.
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: 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
Required Columns
- Description: User's login name.
- BCS Value: skillport_username
Default Columns
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_admin_management_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_admin_presentation_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_admin_reports_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_admin_system_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_books24x7_assigner_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_course_eval_builder_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_curriculum_assigner_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_curriculum_builder_privilege
Delete Email Template Privilege
- Description: Indicates whether or not the user have this privilege.
- BCS Value: has_delete_email_template_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_delete_user_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_enrollment_privilege
- Description: The user's first name.
- BCS Value: user_first_name
- Description: The organization code associated with the group.
- BCS Value: group_orgcode
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_ilt_administrator
ILT Course Administrator Privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_ilt_course_administrator
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_ilt_instructor
ILT Session Administrator Privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_ilt_session_administrator
ILT Session Approver Privilege
- Description: Indicates whether or not the user has this privilege, or the total number of users with the privilege.
- BCS Value: has_ilt_session_approver_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_ingenius_settings_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_keywords_privilege
- Description: The user's last name.
- BCS Value: user_last_name
Learner Record Assigner Privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_learner_record_assigner_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_learning_programs_privilege
- Description: Indicates whether or not the user has this privilege. User must be Super Administrator.
- BCS Value: has_license_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_multiple_completion_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_notification_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_remove_allocation_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_rum_access_privilege
- Description: Indicates whether or not the user has this privilege.
- BCS Value: has_user_manager_privilege
- 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
Optional Columns
- 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: 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 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 most recent date that a user accessed a book or video during the report's time span.
- BCS Value: cud_last_books_asset_launch
- 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 accessed (launched) a course during the report's time span.
- BCS Value: cud_last_skillport_asset_launch
- 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: 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 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
Last Updated:
8/24/2012 4:02:38 PM