Custom Reporting Field Descriptions - Training Fields

Custom Reports Deprecation: Cornerstone has begun deprecating the legacy reporting solution "Custom Reports" as of August 2022, continuing with the November '22 Release. See Deprecation of Custom Reports - Phase 2.

Click here to download the list of Reporting 2.0 field descriptions, updated November 9, 2022. This Excel spreadsheet provides descriptions for the fields in Reporting 2.0. This list is updated when there are changes to existing fields or new fields are added. Currently, the list is in English only. Note that it may be necessary to scroll through the sheets on the Excel spreadsheet in order to access the first sheet.

Each of the fields below corresponds to data from the course catalog. Unless otherwise noted, the data that resides in these fields is managed through the Course Catalog or ILT Events and Sessions.

Field Description Type
Active
  • Indicates whether or not the learning object is active or inactive.
  • Displays as "Y" for active.
  • Displays "N" for inactive.
 Yes/No
Advanced Reg. Deadline The date and time the advanced registration period will end. Date
Allow Download Offline

This field indicates whether a training item is configured to be available offline. Possible values include:

  • Yes
  • No

With the August 2020 release, this field was updated to apply to material training items, which can be made available offline with this release. Materials can now receive a Yes value from this field.

Yes/No
Auto-Launch This field displays a yes/no value, indicating whether or not the Auto-Launch option was selected for the training. (Only applicable to the Curriculum Training report type) Yes/No
Auto-Management of Waitlist
  • Displays "True" if waitlists are auto-managed for an event.
  • Displays "False" if waitlists are not auto-managed.
 True/False
Auto-Register This field displays a yes/no value, indicating whether or not the Auto-Register option was selected for the training. (Only applicable to the Curriculum Training report type) Yes/No
Cohort Title This is the title of the cohort that a training item is contained within. Text
Cohort Section Title This is the title of the section in the cohort that a training item is contained within. Text
Cohort Instructor Name This is the first and last name of the instructor associated with a cohort. Text
Competencies
  • Lists all competencies associated with the learning object, via the course catalog. The localized values for the competencies are displayed.
  • All competencies are listed in the same cell separated by a comma.
 Text
Contact
  • The name of the person who ILT training participants can contact for more information about the training.
  • The name will display as last name, first name.
 Text
Course Browser Compatibility

This field displays the Compatibility Mode setting associated with an online course. Possible values include:

  • IE7 Compatibility
  • IE8 Compatibility
  • IE9 Compatibility
  • IE 10 Compatibility
  • None
  • Default (this means the Course Compatibility setting was never configured for the course)
 Text
Course Code The unique code generated for each LO on the backend during creation (available if course codes have been activated in the portal).  
Course Publication Created By The name of the user who published the online course. Text
Course Publication Creation Date The date the online course was published. Date
Course Publication Published?
  • Displays "True" if the course has been published.
  • Displays "False" if the course has been uploaded through Course Publisher but has not been published.
 True/False
Course Publication Title The title that was entered when the new online course publication was created via course publisher. Text
Created by (name)
  • The name of the person who created the learning object.
  • Name will display as last name, first name.
 Text
Creation Date
  • The date and time the learning object was created.
  • Time will display in the time zone of the user who created the training.
 Date
Credits
  • The number of credits a user will receive once they complete the training.
  • This is a standard field from the course catalog.
 Numeric
Custom Fields
  • One or more custom training fields may have been created in the portal through Custom Field Administration.
  • These custom training fields will be listed by name in Analytics.
  • The report results will provide the value, text, or date that resides in the field.
 Varies
Default Currency Code The currency code selected for the default training price. Text
Description The description provided for the learning object. Text
Display Sequence This field is not visible in the field section and cannot be added as a report column, but administrators can use this field as a sorting option. It allows administrators to organize the report according to the order in which the sections and child training items are configured in the curriculum structure. (Only applicable to the Curriculum Training report type) Numeric
Due Date Criteria

This field displays the due date option selected at the training level. There are six possible values for this field:

  • No Due Dates
  • Relative to Initial Assignment Date
  • Relative to Most Recent Assignment Date
  • Relative to Hire Date
  • Relative to Previous Step
  • Fixed Date

(Only applicable to the Curriculum Training report type)

 Text
Email Configuration

The email configuration selected for a learning object. The following are the possible values:

  • System Defaults
  • Custom Emails
  • No emails

The values are localized for portals with multiple languages enabled.

Text
End Date
  • The date and time the part ends; usually entered in the time zone of the location where the training occurred.
  • To view the time zone associated with this part, include the Time Zone field in your report.
 Date
Eval 1 The evaluation ID of the Level one evaluation associated with the learning object. Numeric
Eval 2 The evaluation ID of the Level two evaluation associated with the learning object. Numeric
Eval 3 The evaluation ID of the Level three evaluation associated with the learning object. Numeric
Event Number The ILT Event ID entered by the event creator. Text
Equivalent Subject This field displays the equivalent subject of the Training Subject (the subject associated with the training). This field separates subjects into individual rows and supports localization. Text
Equivalent Training Object ID This field is the ID of the equivalent training (associated with the Training Title field). Text
Equivalent Training Title This field is the title of the equivalent training (associated with the Training Title field). Text
Equivalent Training Version This field is the version number of the equivalent training (associated with the Training Title field). Numeric
Exclude from Course Recommendations This field indicates whether the Exclude from Course Recommendations option has been selected for a training item via the Course Catalog. Yes/No
File Size (MB) The file size for online courses published in the portal. Numeric
Fixed Due Date This field displays the fixed date selected for the training. The date will display with its time stamp. (Only applicable to the Curriculum Training report type) Date
Hours
  • The total number of hours dedicated to training delivery.
  • For ILT sessions, training hours are calculated by subtracting the total break duration from the training duration of all scheduled parts.
  • For other LO types, training hours is a numeric entry made by the administrator when creating or editing the learning object, to display expected hours it will take users to complete the training.
 Numeric
Training ID
  • For ILT sessions, the Session ID entered by the administrator when creating or editing the session.
  • For other LO types, an ID is generated by the system on the back end when the learning object was created.
 Text
Inside Curriculum?
  • Displays "Yes" if a learning object is part of a curriculum.
  • Displays "No" if the learning object is not part of a curriculum.
  • Takes the version number of the LO into account.
  • Does not display "Yes" for any Session LOs, because they cannot be added to the structure of a curriculum.

Note: This field is not available in this section for the Curriculum Training report type.

Yes/No
Instructor The first primary instructor listed for an ILT session if one was provided. Text
Interest Tracking Allowed
  • Displays "True" if interest tracking is allowed for an ILT event.
  • Displays "False" if interest tracking is not allowed.
 True/False
Keyword
  • The keywords associated with the learning object.
  • All keyword are listed in the same cell separated by a comma.
 Text
Language
  • The languages in which the learning object is offered.
  • If the training is provided in multiple languages, all languages appear in the same cell separated by a comma.
 Text
Language Equivalent Training Object ID This field is the ID of the language equivalent training (associated with the Training Title field). Text
Language Equivalent Training Title This field is the title of the language equivalent training (associated with the Training Title field). Text
Language Equivalent Training Version This field is the version number of the language equivalent training (associated with the Training Title field). Numeric
Last Modified By
  • The full name of the user who last modified the learning object.
  • Name displays as last name, first name.
 Text
Last Modified Date The date the learning object was last modified. Date
Location Fax The facility/location's fax number as identified in the Facility Information section of the Define Location page. Text
Location ID The facility/location OU ID as identified in the Facility Information section of the Define Location page. Text
Locator Number The unique, sequential number assigned to an ILT session by the system when created. Numeric
Material Type Active
  • Displays "True" if the learning object is a material and the material type it belongs to is active.
  • Displays "False" if the material type is inactive.
 True/False
Material Type Name
  • The material type assigned to a material learning object.
  • If the learning object is not a material this field will be blank.
 Text
Material URL The web address where a material learning object can be accessed. This field supports localization. Text
Max Attempts This field displays the maximum number of times a user may attempt a test. (Only applicable to the Curriculum Training report type) Numeric
Max Registration The maximum number of users who can register for an instructor led training session. Numeric
Max Score The highest score that can be achieved for a learning object. Numeric
Min Registration The minimum number of users required to register for an instructor led training session to ensure the session is not cancelled. Numeric
Minimum part attendance The number of parts of an instructor led training session that must be attended by registered students in order to achieve a "completed" transcript status for the session. Numeric
Mobile Compatible Yes/No

This field displays whether or not a training item has been flagged as Mobile Compatible in the Course Catalog. Of the supported training types, Curriculum is the only type which does not show a checkbox in the Cornerstone interface.

Considerations:

Supported training types show a value of Yes when they have been mobile enabled, but unsupported training types will always show a value of No. Supported training types include:

  • Material
  • Online course
  • Quick course
  • Video (Only if transcoding is enabled for the video OR the video is a YouTube-embedded video
  • Curriculum (If at least one training within the curriculum structure is mobile enabled, the curriculum is automatically marked as Mobile Compatible in reporting, even if the curriculum itself is not designated as Mobile Enabled via the Course Catalog)
Multiple Session Enrollment Allowed
  • Displays "True" if users may enroll in more than one session of the same ILT event.
  • Displays "False" if multiple session enrollments are not allowed.
 True/False
Number of Seats Taken The number of users currently registered for an instructor led training session. Numeric
Object ID
  • The unique, system generated learning object ID that is created for all learning objects.
  • This object ID is used to identify learning objects for historical data loads of transcript information.
 Text
Objectives
  • The objectives provided for an instructor led training event.
  • All objectives will appear in a single cell.
 Text
Online Course Protocol

This field displays the online course launch type. Available field outputs include:

  • AICC
  • SCORM 1.2
  • SCORM 2004
  • xAPI
  • Null (if no launch type value is available for the training item)
 Text
Parent Equivalent Subject This field displays the parent subject of the Equivalent Subject. This field will only display the immediate parent of the subject. It will not display as a hierarchy. This report field separates subjects into individual rows and supports localization. Text
Parent Subject Active This field indicates whether the parent subject is currently set as Active in the portal. Text
Parent Training Subject This field displays the parent subject of the Training Subject (the subject that is associated with the training). This field will only display the immediate parent of the subject. It will not display as a hierarchy. This report field now also separates subjects into individual rows and supports localization. Text
Pay-Upfront This field displays a yes/no value, indicating whether or not the Pay-Upfront option was selected for the training. (Only applicable to the Curriculum Training report type) Yes/No
Penalty For No-Show The additional fee charged if a registered student doesn't attend an ILT session they are registered for, but also did not withdraw from. Numeric
Post-Work Training Object IDs A comma separated list of IDs of all learning objects added as Post-work for another learning object. Text
Pre-Approved This field displays a yes/no value, indicating whether or not the Pre-Approved option was selected for the training. (Only applicable to the Curriculum Training report type) Yes/No
Prerequisites The title(s) of training listed as prerequisites for another learning object. Text
Pre-Work Training Object IDs A comma separated list of IDs of all learning objects added as Pre-work for another learning object. Text
Price
  • The price charged to register for a learning object.
  • This field contains numeric values only and will not indicate the currency associated with the price.
 Numeric
Primary Instructor ID This displays the ID of the person who is the primary instructor for the session part. If the instructor is external, then the value is "N/A." If there is no instructor set for a session or if this field does not apply, then the value is blank. Text
Program Title This is the title of the program that a training item is contained within. Text
Secondary Instructor ID This displays the ID of the person who is the secondary instructor for the session part. If the instructor is external, then the value is "N/A." If there is no instructor set for a session or if this field does not apply, then the value is blank. Text
Provider The name of the training provider/vendor associated with a learning object. Text
Provider City The city entered as part of the vendor/provider's address as identified in the ILT > Add New Vendor page. Text
Provider Location Address 1 The first line of the vendor/provider's address as identified in the ILT > Add New Vendor page. Text
Provider Location Address 2 The second line of the vendor/provider's address as identified in the ILT > Add New Vendor page. Text
Provider Mailstop The mailstop entered as part of the vendor/provider's address as identified in the ILT > Add New Vendor page. Text
Provider State The State entered as part of the vendor/provider's address as identified in the ILT > Add New Vendor page. Text
Provider Zip The Zip Code entered as part of the vendor/provider's address as identified in the ILT > Add New Vendor page. Text
Reassign Curriculum This field displays a yes/no value, indicating whether or not the Reassign Curriculum Upon Test Failure option was selected for the training. (Only applicable to the Curriculum Training report type) Yes/No
Reg Deadline
  • The time and date when users may no longer register for an instructor led training session.
  • Time is displayed in the user's time zone using a 24 hour clock.
 Date
Relative Days (Due Date) This field displays the number of days configured for each relative due date options, such as Initial Assignment Date, Most Recent Assignment Date, Hire Date, Previous Step, etc. (Only applicable to the Curriculum Training report type) Numeric
Required Training Per Section This field displays the number of required training items per section. (Only applicable to the Curriculum Training report type) Numeric
Section Parent This field displays the section title for the training, indicating what training belongs to which section. If a training item does not have sections, the curriculum title will display. (Only applicable to the Curriculum Training report type) Text
Sequence This field displays the order of training items within the curriculum structure. (Only applicable to the Curriculum Training report type) Numeric
Session Admin The name of the user who created the ILT session. Text
Session Cost
  • The monetary cost of necessary items, such as materials, travel, catering, or room rental, associated with an instructor led training session.
  • This field returns numeric values only.
 Numeric
Session Cost Type The type of cost, such as materials, travel, catering, or room rental, associated with an instructor led training session. Text
Skills
  • The resume skills associated with a learning object, via the course catalog.
  • All skills appear in the same cell separated by a comma.
 Text
Standalone on Transcript Allows administrators to report on whether training on a learner’s transcript is a standalone training. When a training item exists as a standalone item on a learner’s transcript, this field displays a value of True. When a training item exists as a child item within a curriculum, this field displays a value of False. Yes/No
Start Date
  • The date and time an ILT session part begins; usually entered in the time zone of the location where the training is scheduled.
  • To view the time zone associated with this part, include the Time Zone field in your report.
 Date
Status
  • The status of the learning object, i.e., approved, expired, tentative, or completed.
  • This field does not display user transcript statuses for the learning object. For that, see the transcript status field.
 Text
Subject Active This field indicates whether the subject is currently set as Active in the portal. Text
Subjects
  • The subjects associated with the learning object, via the course catalog.
  • All subjects appear in the same cell separated by a comma.
 Text
Subscription Description This is the description of the learning content subscription. More than one subscription may be associated with an online course, online content, or playlist. Note: The user must have the Reporting 2.0 permission to view subscription fields in order to see this field. Text
Subscription ID This is the unique identifier of the learning content subscription. More than one subscription may be associated with an online course, online content, or playlist. Note: The user must have the Reporting 2.0 permission to view subscription fields in order to see this field. Text
Subscription Name This is the name of the learning content subscription. More than one subscription may be associated with an online course, online content, or playlist. Note: The user must have the Reporting 2.0 permission to view subscription fields in order to see this field. Text
Title The title of the learning object. Text
Total Number of Requesting Users
  • The total number of users who have requested a learning object.
  • Learning objects that are assigned to users or are part of a curriculum or certification are not considered requested and therefore users associated with learning objects for these reasons will not be included.
 Numeric
Total Seats Available The total number of seats available for all sessions of an event. Numeric
Training Created Date The web address where a Material learning object can be accessed. This field now supports localization. Date
Training ID Common Across All Versions?

This field will allow the administrator to connect different versions of a training item together, helping to show which versions of the training have been distributed to which users at any time for a specific training. This is particularly useful if the training title has changed from one version to the next. This field applies to the following training types:

  • Curricula
  • Materials
  • Online courses
  • Tests

Note: If a supported training type only has one version, this field returns a blank value.

Text
Training Latest Version? This field displays a yes/no value to indicate whether or not training items in the curriculum are the latest versions from the Course Catalog. (Only applicable to the Curriculum Training report type) Yes/No
Training Provider Active

This field indicates the status of the provider associated with the training. Possible values include:

  • Active
  • Inactive
 Text
Training Roster Commented By (Name) This field is the full name of the user that added the comments to the roster. Text
Training Roster Commented By (User ID) This field is the User ID of the user that added the comments to the roster. Text
Training Roster Commented Date This field is the date that the user added the comments to the roster. Date
Training Roster Comments This field displays the comments that were added to the roster. Text
Training Start Date For sessions, this displays the start date and time. For external training, this displays the start date. In custom reporting, this field is not populated for any other learning object type. Date
Training Subject
  • Displays the subject that is associated with the training.
  • Separates subjects into individual rows and supports localization.
 Text
Type The type of learning object e.g., online course, event, session, test, etc. Text
User's Course Rating Date This field indicates the date the user submitted a course rating. Date
Version If the learning object has multiple versions, the version number is displayed here. Text
Waitlists Allowed
  • Displays "True" if waitlists are allowed for an ILT event.
  • Displays "False" waitlists are not allowed.
 True/False
Withdrawal Deadline
  • The time and date when users may no longer withdraw from an instructor led training session.
  • Time is displayed in the user's time zone using a 24 hour clock.
 Date