Custom Reporting Field Descriptions - Transcript Fields

Each of the fields below correspond to data from user transcripts. Unless otherwise noted, the data that resides in these fields is managed through actions the user takes from their transcript.

Field Description Type
Archived from Transcript?
  • Displays "True" if a learning object has been moved to the user's archived transcript.
  • Displays "False" if the learning object is not archived.
True/False
Assign Comments
  • Displays any comments or instructions entered by the assignor, if the training was assigned.
  • If no comments were entered at the time of the assignment, "Initial Request" will appear in this field.
Text
Assigned
  • Indicates if the training was assigned to the user.
  • Displays as Yes or No.
Yes/No
Assigned by (ID) The User ID of the person who assigned the training. Text
Assigned by (name)
  • The name of the person who assigned the training.
  • Name displays as last name, first name.
Text
Assigned Date
  • The date and time the learning object was added to the user's transcript.
  • Time is displayed in the user's time zone using a 12 or 24 hour clock, based on the user's culture setting.
Date
Assignment User Criteria (OU Type) This is the organizational unit (OU) type of the user criteria that was included in the assignment. Users are displayed individually on separate rows. Text
Assignment User Criteria (OU Description) This is the OU description of the users included in the user criteria for the assignment. Users are displayed individually on separate rows. Text
Assignment User Criteria (OU Owner - Name) This is the OU owner name of the users included in the user criteria for the assignment. Users are displayed individually on separate rows. Text
Assignment User Criteria (OU Owner - User ID) This is the OU owner user ID of the users included in the user criteria for the assignment. Users are displayed individually on separate rows. Text
Assignment User Criteria (OU Parent) This is the OU Parent of users included in the user criteria for the assignment. Users are displayed individually on separate rows. Text
Available Date
  • Displays the date on which the training is available for users who have been assigned a training item and the learning assignment is configured to have an available date.
  • The Available Date field is only visible to users who have permission to manage the available date setting for learning assignments.
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
Completed SCOs %
  • For online courses, tests, and quick courses.
  • Displays the user's progress towards completion of the course.
Numeric
Curriculum Completion Percentage

This field enables reporting on the completion percentage of curricula. The completion percentage for each user is calculated once the user opens the curriculum in the Curricula Player.

Numeric
Curriculum Latest Registration? This field indicates whether or not the instance of a curriculum on the user's transcript is the most recent registration. This value is propagated to the child training within the curriculum. Yes/No
Curriculum Title (Transcript) This field displays the training title of the curriculum that an LO a user completed is contained within. Text
Curriculum Section Title (Transcript) This field displays the title of the section within the curriculum that an LO a user completed is contained within. Text
Curriculum Version (Transcript) This field displays the version number of the curriculum that an LO a user completed is contained within. Text
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 as found in the user's transcript.
Varies
Due Date The date by which the user must complete the learning object, if a due date was assigned. Date
Exempted By (ID) The User ID of the person who approved or denied the exemption request for a learning object on the user's transcript. Text
Exempted By (Name)
  • The name of the person who approved or denied the exemption request for a learning object on the user's transcript.
  • The name displays as last name, first name.
Text
Exemption Comments (Exemptor) Any comments entered by the exemptor when they approved or denied the exemption request for a learning object on the user's transcript. Text
Exemption Comments (User) Any comments entered by the user when they requested an exemption for a learning object on their transcript. Text
Exemption Date
  • The date and time an exemption request was approved or denied.
  • Time is displayed in UTC (Coordinated Universal Time) using either a 12 or 24 hour clock, based on the user's culture setting.
Date
Exemption Reasons (Exemptor) The reason selected by the exemptor when they approved or denied the exemption request for a learning object on a user's transcript. Text
Exemption Reasons (User) The reason selected by the user when they requested an exemption for a learning object on their transcript. Text
Is Express Class? This column will contain a Y/N depending on whether or not the training was facilitated via Express Class. Yes/No
Last Transcript Status Change Date
  • The date and time of the most recent change to the user's transcript status in regards to a learning object.
  • Time is displayed in the user's time zone using a 12 or 24 hour clock, based on the user's culture setting.
Date
Observed Training Attempt Number

This column will contain the attempt number for the On the Job Training attempt. For Express Class, the attempt number will always be 1.

Numeric
Observed Training Result This column will contain a value of Completed, Failed, or Incomplete, depending on the result recorded via Express Class. The Completed result maps to a Complete transcript status, while Failed and Incomplete map to an Incomplete transcript status. Text
Observer/ Facilitator ID This column will contain the User ID of the facilitator who recorded the Express Class, or the observer who recorded the On the Job Training. Text
Observer/ Facilitator First Name This column will contain the first name of the facilitator who recorded the Express Class, or the observer who recorded the On the Job Training. Text
Observer/ Facilitator Last Name This column will contain the last name of the facilitator who recorded the Express Class, or the observer who recorded the On the Job Training. Text
On the Job Training This field allows administrators to flag OJT items contained within the course catalog. OJT items included in the report display "Yes" in this field. Yes/No
Date Observed This field displays the date the OJT attempt was recorded by the observer. Date
Observed Training Hours This column will contain the Training Hours for On the Job Training, and is not applicable to Express Class. Training Hours relative to Express Class can be identified using the Training Hours field within the Training section in reporting. The column will be formatted as (HHHH:MM), and is not available for filtering. Text
Observed Training Score This column will contain the score recorded by the facilitator or observer for the Express Class or On the Job Training. Percentage
Observed Training Comments This column will contain comments added by the facilitator or observer for the Express Class or On the Job Training. Text
Passed This field relates to On the Job Training (OJT), and it displays whether the observer has marked a completion for the learner and they passed the OJT observation. This field only considers Pass and Fail statuses. If the transcript status is Incomplete, this field returns an empty value, as the Incomplete status is not included in either the Pass or Fail statuses. Yes/No
Program Title This is the title of the program that a training item is contained within. Text
Progress Maintained This field indicates whether users were assigned the training via a Learning Assignment Tool using the Maintain Progress option. Yes/No
Quiz Attempt Status Indicates whether the learner has mastered the SCO (only applicable to SCORM courses). Text
Registration Date
  • The time and date the learning object moved to registered status on the user's transcript.
  • Time is displayed in the user's time zone using a 12 or 24 hour clock, based on the user's culture setting.
Date
Registration Number The number of times a learning object has been requested or assigned and moved to a registered status on the user's transcript. (Recurrence) Numeric
Removal Comments Comments provided by the person who removed a learning object from a user's transcript, if comments were provided and the training was removed. Text
Removal Date
  • The date and time a learning object was removed from a user's transcript.
  • Time is displayed in the user's time zone using a 12 or 24 hour clock, based on the user's culture setting.
Date
Removed from Transcript?

Displays whether or not a training item is currently removed from a user's transcript.

Yes/No
Removed Status
  • Indicates if a learning object was removed from a user's transcript.
  • Displays as "1" if the training was removed.
  • Displays as "0" if the training has not been removed.
Text
Required
  • Indicates if a learning object has been identified as required training for the user.
  • Displays "Yes" if the learning object is required.
  • Displays "No" if the learning object is not required.
Yes/No
Response Status Judgment of the correctness of the learner response (refers to a learner's responses to the quiz portion of a SCORM course). Text
Response Time The time the user responded to the interaction (refers to a learner's responses to the quiz portion of a SCORM course). Time
SCO ID SCO ID as it appears on the course manifest. Varies
SCO Name SCO name as it appears on the course manifest. Text
Score Displays the score the user received on a learning object completion attempt. Numeric
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
Status The user's transcript status with regards to a learning object. Text
Suggested
  • Indicates if a learning object has been identified as suggested training for a user.
  • Displays "Yes" if the learning object is suggested training.
  • Displays "No" if the learning object is not suggested training.
Yes/No
Time in Training (min)
  • The number of minutes spent in training.
  • For ILT sessions, Time in Training is the duration of the training minus any breaks.
  • For online courses, time in training displays the number of minutes the user had the course open.
Numeric
Training Edited By (Name) This field is the full name of the user that modified the user's transcript. Text
Training Edited By (User ID) This field is the User ID of the user that modified the user's transcript. Text
Training Edited Date This field is the date that the user modified the transcript. Date
Training Edited Comments This field displays the comments that were entered when the transcript was modified. Text
Training Purpose
  • The Training Purpose selected by the user when they requested the learning object.
  • Training Purpose only applies if Training Purpose functionality is activated for the portal.
Text
Training Purpose Category
  • The Training Purpose category selected by the user who approved the learning object.
  • Training Purpose only applies if Training Purpose functionality is activated for the portal.
Text
Transcript Completed Date Displays the date a training item was marked as Complete on a user's transcript. Date
Transcript Delivery Method

This field displays the method by which a training item was added to the user's transcript. Possible values include:

  • Self-Requested
  • System Assignment (LAT)
  • Direct Assignment
  • Express Class
  • Assignment (This category is representative of historical data records prior to the Feb '19 release which are not reliable and therefore have been contained separately to preserve data quality. Over time, this category will be deprecated.
  • Other
    • The Other status appears for all other miscellaneous transcript delivery cases, including:

      • Assignment via Inventory

      • Added by Training Plan

      • Historical Data Loads (except in certain cases described in above values)

      • Data Load Wizard

Text
Transcript Due Date (Curriculum) This is the due date that appears in the user's transcript for the curriculum. Note: This field only allows you to report on due dates for a specific curriculum. If the training is also in other curriculum with different due dates, you must use the Transcript Due Date field to report on these alternate due dates. Date
Transcript Removed Date Displays the date a training item was removed from a user's transcript. Date
Transcript Status (From Curriculum) This is the status of the curriculum or the child training within the curriculum on the user's transcript. Text
User Attended Part? This field indicates whether or not the user attended the individual Part. Yes/No
User Response Data generated when a learner responds to an interaction (refers to a learner's interaction with the quiz portion of a SCORM course). Text

Transcript Transcript Transcript Transcript Transcript Transcript Transcript Transcript Transcript