Reporting Fields - Learning

The following enhancements have been made to Learning Reporting:

  • Additional user-specific constraints available for Reporting 2.0 Certification Removal History permissions
  • Reporting 2.0 "Greatest Registration Number" field output change to Bit type (Yes/No)
  • New Reporting 2.0 Report Type: Certification Approval History Report
  • New Reporting 2.0 Report Type: ILT Interest Tracking Report

Additional user-specific constraints available for Reporting 2.0 Certification Removal History permissions

Customers want to constrain certification removal history reporting further with additional user constraints

Granular permission "Reporting - Learning - Certification Removal History - View" and Report level permission "Reporting - Learning - Certification Removal History Report - View" can now be constrained using the following additional constraints:

  • Restrict to User’s Self Only
  • Restrict to User Self and Subordinates
  • Restrict to User (e.g., specifying a user)

Reporting 2.0 "Greatest Registration Number" field output change to Bit type (Yes/No)

The "Greatest Registration Number" field output is updated to display as "Yes" or "No" rather than "1" or "0" to ensure consistency and accuracy across all aspects of the Cornerstone platform.

This change impacts all Reporting 2.0 reports that contain the "Greatest Registration Number" field. "0" is replaced with "No," and "1" is replaced with "Yes" in all report outputs, including FTP, email delivery, scheduled reports, dashboards, and calculated fields. This change impacts both existing and new reports. This change does not affect field values in filters because they are already consistent with the actual data type and already display Bit values ("Yes" or "No").

New Reporting 2.0 Report Type: Certification Approval History Report

Access the new Reporting 2.0 Certification Approval History report type for historical pending or past certification approval requests.

The following new fields are available to use in Reporting 2.0 with the Certification Approval History report type:

Field Name Field Description Field Type

Solution/Suite

Entity
Owner This field displays the name of the certification owner who approved or denied the request. Text Learning Certification Approval History
Requester This field displays the user who requested the certification approval. Text Learning Certification Approval History
Certification Title This field displays the title of the certification that requires approval. Text Learning Certification Approval History
Comment This field displays any comments provided during the approval or denial process. Text Learning Certification Approval History
Decision This field displays whether the certification approval request was approved or denied. Text Learning Certification Approval History
Decision Date This field displays the date the approval or denial decision was made. Date Learning Certification Approval History
Request Date This field displays the date the certification approval was requested. Date Learning Certification Approval History
Request Type This field displays the type of approval request that was made. Text Learning Certification Approval History

The following new granular permissions apply to the Certification Approval History report type:

  • Reporting - Learning - Certification Approval History - View
  • Reporting - Learning - Certification Approval History - Manage

The following new report-level permissions apply to the Certification Approval History report type:

  • Reporting - Learning - Certification Approval History Report - View
  • Reporting - Learning - Certification Approval History Report - Manage

The View permissions can be constrained using the following constraint types:

  • Restrict to OU
  • Restrict to User's OU
  • Restrict to User Self And Subordinates
  • Restrict to User
  • Restrict to User's Self
  • Restrict to User's Manager
  • Restrict to User's Subordinates
  • Restrict to User's Direct Reports

New Reporting 2.0 Report Type: ILT Interest Tracking Report

Use the new Reporting 2.0 ILT Interest Tracking report type to report on users who have shown interest in an event when no session is available.

The following new fields are available to use in Reporting 2.0 with the ILT Interest Tracking report type:

Field Name Field Description Field Type

Solution/Suite

Entity
Interest Location This field displays the OU location the learner selected when indicating interest. Text Learning ILT Interest Tracking
Interest location ID This field displays the ID of the OU location the learner selected when indicating interest. Text Learning ILT Interest Tracking
Interest comments This field displays any comments the learner entered when indicating interest. Text Learning ILT Interest Tracking
Interest location parent This field displays the parent of the OU location the learner selected when indicating interest. Text Learning ILT Interest Tracking
Interest location parent ID This field displays the ID of the parent of the OU location the learner selected when indicating interest. Text Learning ILT Interest Tracking
Interest date submitted This field displays the date on which the learner indicated interest. Date Learning ILT Interest Tracking

The following new granular permissions apply to the ILT Interest Tracking report type:

  • Reporting - Learning - ILT Interest Tracking - View
    • Restrict to User
    • Restrict to User Self And Subordinates
    • Restrict to OU
    • Restrict to User's OU
  • Reporting - Learning - ILT Interest Tracking - Manage
  • Reporting - Learning - ILT Interest Tracking - Training - View
    • Restrict to Training Item
    • Restrict to Training Provider
    • Restrict to Training Type
    • Restrict to Instructor
    • Restrict to Facility
  • Reporting - Learning - ILT Interest Tracking - Training - Manage

The following new report-level permissions apply to the ILT Interest Tracking report type:

  • Reporting - Learning - ILT Interest Tracking Report - View
    • Restrict to User
    • Restrict to User Self And Subordinates
    • Restrict to OU
    • Restrict to User's OU
    • Restrict to Training Item
    • Restrict to Training Provider
    • Restrict to Training Type
    • Restrict to Instructor
    • Restrict to Facility
  • Reporting - Learning - ILT Interest Tracking Report - Manage

Implementation

This functionality is automatically enabled for all organizations.

Click here to download the Reporting 2.0 Adoption Kit.

Permissions

For more information about Reporting 2.0 permissions, see the following:

  • Permissions in Reporting 2.0 - This provides detailed information about Reporting 2.0 permissions.
  • Permissions List - This provides the list of permissions and their relationships so that you know which permissions users need to have to create and view reports.