Create Transcript Custom Report

This field displays the ILT facility address line 2. The value is pulled from the Address #2 field when configuring the facility in Facilities & Resources.

This field indicates whether or not approval is required in order to schedule the facility. The value is pulled from the Approval Required field when configuring the facility in Facilities & Resources.

This field displays the city in which the ILT facility is located. The value is pulled from the Town/City field when configuring the facility in Facilities & Resources.

This field displays the name of the contact for the ILT facility. The value is pulled from the Contact field when configuring the facility in Facilities & Resources.

This field displays the name of the country in which the ILT facility is located. The value is pulled from the Country field when configuring the facility in Facilities & Resources.

This field displays the email address of the contact for the ILT facility. The value is pulled from the Email field when configuring the facility in Facilities & Resources.

This field displays the fax number of the contact for the ILT facility. The value is pulled from the Fax field when configuring the facility in Facilities & Resources.

This field displays the ID for the ILT facility. The value is pulled from the ID field when configuring the facility in Facilities & Resources.

This field displays the name of the ILT facility. The value is pulled from the Name field configuring the facility in Facilities & Resources.

This field displays the occupancy for the ILT facility. The value is pulled from the Occupancy field when configuring the facility in Facilities & Resources.

This field indicates whether or not the ILT facility is on site. The value is pulled from the On Site field when configuring the facility in Facilities & Resources.

This field displays the name of the owner for the ILT facility. The value is pulled from the Owner field when configuring the facility in Facilities & Resources.

This field displays the ID of the parent for the ILT facility. The value is pulled from the Parent field when configuring the facility in Facilities & Resources.

This field displays the phone number for the ILT facility. The value is pulled from the Phone field when configuring the facility in Facilities & Resources.

This field displays the postal code for the ILT facility. The value is pulled from the Postal Code field when configuring the facility in Facilities & Resources.

This field displays the state/province in which the ILT facility is located. The value is pulled from the Province field when configuring the facility in Facilities & Resources.

This field displays the time zone in which the ILT facility is located. The value is pulled from the Time Zone field when configuring the facility in Facilities & Resources.

This field displays the type of ILT facility, such as building, floor, room, etc. The value is pulled from the Facility Type field when configuring the facility in Facilities & Resources.

This field indicates that enrollment restrictions have been defined for the event. The report displays "Place Enrollment Restrictions" or "Manage Reservations and Restrictions," depending on the option selected in the Place Enrollment Restrictions field or the Manage Reservations and Restrictions field in the Enrollment Reservations and Restrictions section when configuring the Session Defaults tab for the event.

Note: If you add this field to the report, you will also want to add other fields in the ILT Seat Allocation section so that your report will display the specific enrollment restrictions data, such as the number of seats restricted and the organizational unit (OU) and OU type that is being restricted.

This field indicates whether or not the Include Subordinates option was selected when configuring enrollment options for an event. The option can be selected when defining settings for the Place Enrollment Restrictions field and the Manage Reservations and Restrictions field in the Enrollment section when configuring the Session Defaults tab for the event.

Note: If you add this field to the report, you will also want to add other fields in the ILT Seat Allocation section so that your report will display the additional data related to this field.

This field indicates the number of seats that have been reserved for a specific organizational unit (OU). Each OU displays in a separate line on the report. The value is pulled from the Place Enrollment Restrictions field or the Manage Reservations and Restrictions field in the Enrollment Reservations and Restrictions section when configuring the Session Defaults tab for the event.

Note: If you add this field to the report, you will also want to add other fields in the ILT Seat Allocation section so that your report will display the specific enrollment reservations/restrictions data, such as the number of seats reserved and the OU and OU for which the seats are reserved.

This field indicates the number of seats that have been restricted for an organizational unit (OU) or OU type. The value is pulled from the Place Enrollment Restrictions field in the Enrollment section when configuring the Session Defaults tab for the event. If multiple OUs are restricted, then each OU displays in a separate line on the report.

Note: If you add this field to the report, you will also want to add other fields in the ILT Seat Allocation section so that your report will display the specific enrollment restrictions data, such as the number of seats restricted and the OU and OU type that is being restricted.

This field indicates the order of the organizational units (OU) that are selected in the Manage Reservations and Restrictions field in the Enrollment Reservations and Restrictions section when configuring the Session Defaults tab for the event.

Note: If you add this field to the report, you will also want to add other fields in the ILT Seat Allocation section so that your report will display the specific enrollment reservations/restrictions data, such as the number of seats restricted and the OU and OU type that is being restricted.

This field displays the name of the organizational units (OU) for which seats have been reserved. Each OU displays on a separate line in the report. The value is defined when selecting the OUs in the Place Enrollment Restrictions field or the Manage Reservations and Restrictions field in the Enrollment Reservations and Restrictions section when configuring the Session Defaults tab for the event.

Note: If you add this field to the report, you will also want to add other fields in the ILT Seat Allocation section so that your report will display the specific enrollment reservations/restrictions data, such as the number of seats reserved.

This field displays the name of the organizational units (OU) for which seats have been restricted. Each OU displays on a separate line in the report. The value is defined when selecting the OUs in the Place Enrollment Restrictions field or the Manage Reservations and Restrictions field in the Enrollment Reservations and Restrictions section when configuring the Session Defaults tab for the event.

Note: If you add this field to the report, you will also want to add other fields in the ILT Seat Allocation section so that your report will display the specific enrollment reservations/restrictions data, such as the number of seats restricted.

This field displays the name of the organizational unit (OU) type for which seats have been reserved. Each OU type displays on a separate line in the report. The value is defined when selecting the OU type in the Place Enrollment Restrictions field or the Manage Reservations and Restrictions field in the Enrollment Reservations and Restrictions section when configuring the Session Defaults tab for the event.

Note: If you add this field to the report, you will also want to add other fields in the ILT Seat Allocation section so that your report will display the specific enrollment reservations/restrictions data, such as the number of seats reserved.

This field displays the name of the organizational unit (OU) type for which seats have been restricted. Each OU type displays on a separate line in the report. The value is defined when selecting the OU type in the Place Enrollment Restrictions field or the Manage Reservations and Restrictions field in the Enrollment Reservations and Restrictions section when configuring the Session Defaults tab for the event.

Note: If you add this field to the report, you will also want to add other fields in the ILT Seat Allocation section so that your report will display the specific enrollment reservations/restrictions data, such as the number of seats restricted.

This field displays the length of an ILT session part break (in minutes). If there is more than one break for a part, each break will appear in a separate row on the report. The value for this field is pulled from the Duration field in the Part Break section when configuring the Parts Schedule tab for sessions.

This field displays the name of an ILT session part break. If there is more than one break for a part, each break will appear in a separate row on the report. The value for this field is pulled from the text field in the Part Break section when configuring the Parts Schedule tab for sessions.

This field displays the date and time the ILT session part ends; usually entered in the time zone of the location where the part is scheduled. The value for this field is pulled from the End field when configuring the Parts Schedule tab for sessions.

Note: To view the time zone associated with this part, include the Part Time Zone field in your report.

This field displays the facility/location OU where the ILT session part was/will be held. The value for this field is pulled from the Name field when configuring the facility in Facilities & Resources.

Part Location Address 1

Part Location Address 2

Part Location City

Part Location Fax

Part Location State

Part Location Zip

Part Training Minutes

Part Instructor ID

Subject ID

This field indicates whether or not the event has been configured to allow administrators and managers to select sessions for end users. The value is pulled from the Ability to Select Sessions field when configuring the Properties tab for the event.

This field indicates whether or not the event has been configured to allow end users to select sessions. The value is pulled from the Ability to Select Sessions field when configuring the Properties tab for the event.

This field indicates whether or not the waitlist will be auto-managed. The value is pulled from the Allow Auto-Management of Waitlist field when configuring the Properties tab for the event or the Details tab for the session.

This field indicates whether or not users on the waitlist will be auto-registered upon granting the user a session seat. The value is pulled from the Auto-Register User upon Granting of Waitlist field when configuring the Properties tab for the event or the Details tab for the session.

This field displays the currency that is defined for the learning object (LO). The value for this field is pulled from the applicable currency field for the LO. For example, the session currency is pulled from the Price field on the Details tab when configuring the session.

This field displays the unique identifier for the learning object (LO). This value is automatically generated for LOs when they are created if the Course Code functionality is enabled via Course Code Preferences. This value can be modified by administrators on the General tab of the Course Catalog.

This field displays the name of the user who created the publication. The value displays as [Last Name], [First Name]. The value is pulled from the Created By column on the Course Publisher page.

This field displays the date on which the course was published. The value is pulled from the Date Created column on the Course Publisher page.

This field indicates whether or not the publication is published. The possible values are "Published" and "Pending Published." The value is pulled from the Status column on the Course Publisher page.

This field the title of the publication. The value is pulled from the Title field on the Publication Information page, which is the page on which administrators create online courses.

This field indicates whether or not the review is anonymous. When the user rates the course anonymously, the report output displays "True." When the user does not rate the course anonymously, the report output displays "False."

The value is pulled from the Make my review anonymous checkbox on the training review pop-up. Users can check the box so that their name does not appear when they submit their training review.

This field displays the name of the user who reviewed the course. The value displays as [Last Name], [First Name]. The value is pulled from the user record of the user who submitted the review.

If the user checked the Rate Anonymously box when reviewing, then the field will be blank on the report output.

This field displays the name of the user who created the training. The value displays as [Last Name], [First Name]. The value is pulled from the user record of the user who created the training.

For sessions, the user in this field is the same user as the Training Session Admin.

This field displays the user ID of the user who created the training. The value is pulled from the User ID field on the user record of the user who created the training.

For sessions, the user in this field is the same user as the Training Session Admin.

This field displays the message configured with the electronic signature at the Course Catalog. The value is pulled from the Signature Message field on the General tab of the Course Catalog.

This field indicates whether or not an electronic signature is required for a learning object (LO). The report displays "Yes" if an electronic signature is required and "No" if an electronic signature is not required. The value is pulled from the Required Electronic Signature field on the General tab of the Course Catalog.

This field displays the option that was selected when deciding the type of emails for the training. The following are the possible values:

• System Defaults
• Custom Emails
• No Emails

This field applies to all learning object (LO) types for which emails can be configured.

This field displays the learning objects (LO) that are defined as equivalent training. The LOs display in one line on the report output, with each LO title separated by a comma. The value for this field is pulled from the Training Equivalence field on the General tab of the Course Catalog.

This field displays the subjects that are associated with the learning object (LO). The value for this field is pulled from the Subjects tab in the Course Catalog for the LO. Each subject displays on the same line in the report output, separated by a comma.

This field displays the value from the Event Number field on the Properties tab when configuring events.

This field indicates whether or not the learning object (LO) is part of a curriculum. The value in the report output is either Yes or No. LOs are added to curricula from the Structure tab when configuring curricula.

This field displays the value from the Allow interest tracking field on the Properties tab when configuring events. The value in the report output is either Yes or No.

This field displays the value from the Keywords field for learning objects (LO) that include keywords. Each keyword displays on the same line, separated by a comma. Keywords can be added from the General tab in the Course Catalog. They can also be added for individual LOs.

This field displays the language equivalent learning object (LO) for the training. The value is pulled from the Language Equivalents field on the General tab in the Course Catalog.

This field displays the languages defined for the learning object (LO). The value is pulled from the Available Languages field on the General tab in the Course Catalog. Each language displays on the same line in the report output, separated by a comma.

This field displays the user ID of the user who last modified the learning object (LO). The value is pulled from the user record of the user who modified the training.

This field displays the name of the user who last modified the learning object (LO). The value for this field is pulled from the modification history for the LO. The name displays as [Last Name], [First Name].

This field displays the date and time on which the training was last modified. The value for this field is pulled from the modification history for the learning object (LO).

This field indicates whether or not the material is active. The value is pulled from the Active column on the Material Administration page. The value in the report output is either Yes or No.

This field displays the material type. The value is pulled from the Material Type field when configuring materials.

Note: Material types are created on the Manage Material Types page in Materials Management.

This field displays the material URL. The value is pulled from the Material Source field when "URL" is selected as the option when configuring materials.

Note: Material types are created on the Manage Material Types page in Materials Management.

This field displays the maximum score that a user can receive for the learning object (LO). The value is defined for an individual LO. This field applies to multiple LO types.

This field displays the maximum number of times a user can take the test to attempt a passing score before they are locked out of the test and are unable to take it again. The value for this field is pulled from the Attempts Allowed field on the General page when creating the test. This value only applies to tests.

This field displays the minimum number of parts a user must attend in order for the session to be marked completed in their transcript. The value is pulled from the Attendance field on the Details tab when configuring sessions.

This field indicates whether the event is configured to allow users to attend multiple sessions for the event. The value for this field is pulled from the Allow Users to Attend Multiple Sessions option on the Properties page when creating the event.

This field displays the maximum number of times that a user can take the test. The value is pulled from the Attempts Allowed field on the General step when configuring tests.

This field displays the objectives for the event. The value is pulled from the Objectives field when configuring the Properties tab for the event.

This field indicates whether or not subordinate organizational units (OU) were included in the availability for the learning object (LO). The value for this field is pulled from the Include Subordinates column on the Availability page when configuring training in the Course Catalog.

The report output displays "Yes" if subordinates are included or is blank if the checkbox is not selected in the Include Subordinates column.

Note: This field only applies to the OU criteria that is defined on the Availability tab; it does not apply to individual user criteria that is defined on the Availability tab. To include the availability data for individual users who are defined in the availability criteria on the Availability tab, you must include the User Training Availability fields in the report output.

This field indicates whether or not users within the organizational unit (OU) are pre-approved for the training. The value for this field is pulled from the Include Pre-Approved column on the Availability page when configuring training in the Course Catalog.

The report output displays "Yes" if box is checked in the Pre-Approved column. The report displays "No" if the box is not checked.

Note: This field only applies to the OU criteria that is defined on the Availability tab; it does not apply to individual user criteria that is defined on the Availability tab. To include the availability data for individual users who are defined in the availability criteria on the Availability tab, you must include the User Training Availability fields in the report output.

This field indicates whether or not users within the organizational unit (OU) are automatically registered for the training when they are approved for the training. The value for this field is pulled from the Register Upon Approval column on the Availability page when configuring training in the Course Catalog.

The report output displays "Yes" if box is checked in the Register Upon Approval column. The report displays "No" if the box is not checked.

Note: This field only applies to the OU criteria that is defined on the Availability tab; it does not apply to individual user criteria that is defined on the Availability tab. To include the availability data for individual users who are defined in the availability criteria on the Availability tab, you must include the User Training Availability fields in the report output.

This field displays the training availability type for the organizational unit (OU). The following are the possible values that will appear in the report:

• Featured
• Required
• Suggested
• Visible - Note: This value only appears in the report if "None" is selected in the Availability Type field.

The value is defined in the Availability Type column on the Availability tab in the Course Catalog. The column displays a drop-down, from which the administrator selects an option to define the availability type.

Note: This field only applies to the OU criteria that is defined on the Availability tab; it does not apply to individual user criteria that is defined on the Availability tab. To include the availability data for individual users who are defined in the availability criteria on the Availability tab, you must include the User Training Availability fields in the report output.

This field displays the organizational unit (OU) availability criteria that is configured for the training. The value is pulled from the Criteria column on the Availability page in the Course Catalog whenan OU is selected in the Select Criteria drop-down.

Note: This field only applies to the OU criteria that is defined on the Availability tab; it does not apply to individual user criteria that is defined on the Availability tab. To include the availability data for individual users who are defined in the availability criteria on the Availability tab, you must include the User Training Availability fields in the report output.

This field displays the name of the training request form that was selected for the learning object (LO) for the organizational unit (OU). The value for this field is pulled from the Training Request Form column on the Availability page when configuring training in the Course Catalog.

Note: This field only applies to the OU criteria that is defined on the Availability tab; it does not apply to individual user criteria that is defined on the Availability tab. To include the availability data for individual users who are defined in the availability criteria on the Availability tab, you must include the User Training Availability fields in the report output.

This field displays the Learning Object ID for any learning objects (LOs) that are set as post-work for the associated LO. The value for this field is pulled from the Post-Work field on the General page of the Course Catalog.

This field displays the names of the post-work training that is configured for the learning object (LO). This field applies to multiple LO types.

This field displays the Learning Object ID of the prerequisite training.

Note: The object ID for a learning object (LO) is a unique, system-generated value that is created for all LOs.

Prerequisite Training Title

This field displays the title of prerequisite training that is configured for the learning object (LO). Each prerequisite training title appears on a separate row in the report output.

The value for this field is pulled from the Name column in the Prerequisites table for the prerequisite within the LO type. For example, when configuring an LO in the Course Catalog (all but Library and Program LO types), the prerequisite title appears in the Name column in the Prerequisites table on the Prerequisites tab.

This field displays the Learning Object ID for any learning objects (LOs) that are set as pre-work for the associated LO. The value for this field is pulled from the Pre-Work field on the General page of the Course Catalog.

This field displays the names of the pre-work training that is configured for the learning object (LO). This field applies to multiple LO types.

This field displays the city of the training provider. The value is pulled from the City field on the Vendor Details page when configuring vendors.

Note: If you add this field to the report, you may also want to add the Training Provider field, which is located in the Training section and displays the name of the training provider.

This field displays the address line 1 of the training provider. The value is pulled from the Address #1 field on the Vendor Details page when configuring vendors.

Note: If you add this field to the report, you may also want to add the Training Provider field, which is located in the Training section and displays the name of the training provider.

This field displays the address line 2 of the training provider. The value is pulled from the Address #1 field on the Vendor Details page when configuring vendors.

Note: If you add this field to the report, you may also want to add the Training Provider field, which is located in the Training section and displays the name of the training provider.

This field displays the state for the training provider. The value is pulled from the State, Postal Code field on the Vendor Details page when configuring vendors.

Note: If you add this field to the report, you may also want to add the Training Provider field, which is located in the Training section and displays the name of the training provider.

This field displays the ZIP Code for the training provider. The value is pulled from the State, Postal Code field on the Vendor Details page when configuring vendors.

Note: If you add this field to the report, you may also want to add the Training Provider field, which is located in the Training section and displays the name of the training provider.

This field displays the name of the secondary vendor for the event. The value is pulled from the Secondary Vendor field on the Properties tab when configuring events.

Note: This field is only available for portals with the ability to configure multiple providers for a session. For more information about this feature, see the Session Options Overview topic in Online Help.

This field displays the cost type for the individual cost that has been added to the session, such as materials, travel, catering, or room rental. The value for this field is pulled from the cost type that is selected when a Cost Per Session is added on the Details page when creating the session.

This field displays the cost amount for the individual cost that has been added to the session. The value for this field is pulled from the cost amount that is entered when a Cost Per Session is added on the Details page when creating the session.

This field displays the user ID of the test grader for the test. If there are multiple test graders, the user IDs display on the same line and are separated by a comma. The value is pulled from the user record of the test grader.

This field displays the number of minutes that is the maximum amount of time a user has to take the test. The value is defined on the Structure tab when configured tests.

This field displays the number of users who have requested the training. This field applies to multiple learning object (LO) types.

This field displays the total number of seats that are currently available for the session (i.e., seats that have not yet been registered for). The value is pulled from the Seats Available field on the Roster page.

This field displays the number of seats for which users are registered. The value is calculated by subtracting the total number of registrations from the total number of seats allowed for the session.

This field displays the total of all costs that have been added to the session. The value for this field is pulled from the Total Cost per Session field that is displayed on the Details page when creating the session.

This field indicates whether or not the learning object (LO) is active or inactive. The report displays "Y" for active and "N" for inactive. The value is pulled from the Active field for the LO.

This field displays the date and time the advanced registration period will end for the event or session. For events, the value is pulled from the Advance Registration lasts for X days after session is created field on the Session Defaults tab. For sessions, the value is pulled from the X is the number of days Advanced Registration lasts after the session is created field on the Details tab.

This field displays all competencies associated with the learning object (LO), via the course catalog. The localized values for the competencies are displayed. All competencies are listed in the same cell in the report, separated by a comma. The value is pulled from the list of competencies that are defined for the LO.

This field displays the user ID of the person who ILT training participants can contact for more information about the training. The value is pulled from the user record of the user who is the training contact.

Note: This field only applies to Event and Session learning object types.

This field displays the name of the person who ILT training participants can contact for more information about the training. The value displays as [Last Name], [First Name]. The value is pulled from the Training Contact field for the learning object. This field applies to both sessions and events.

There may be a different training contact for the event than for the session, and vice versa. If your report includes both Event and Session training types, the contact for the event will display on a separate row from the contact for the session. If there are multiple sessions for an event, there may be a different contact for each session. The contact for each session will appear on a separate row in the report.

Note: This field only applies to Event and Session learning object types.

This field displays the date and time the learning object was created. Time will display in the time zone of the user who created the training.

This field displays the number of credits a user will receive once they complete the training. The value is pulled from the Credits field on the General tab in the Course Catalog.

This field displays the date on which the training will be deactivated. The value for this field is pulled from the Deactivate this course on X date on the General tab when configuring training in the Course Catalog.

This field displays the description provided for the learning object. The value is pulled from the Description field for the learning object.

Training End Date

This field displays the date and time the session part ends. The value displays in the time zone of the user running the report. If you would also like to view the time zone associated with the part, include the Part Time Zone field in your report.

The value for the Training End Date field is pulled from the End field in the DATE AND TIME section on the Parts Schedule tab for the session.

This field displays the total number of hours dedicated to training delivery. This field applies to all training types.

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, the training hours are defined by the administrator in the Training Hours field on the General tab of the Course Catalog. The purpose of entering a value is to display the expected hours it will take users to complete the training.

For ILT sessions, this field displays the Session ID entered by the administrator in the Session ID field on the Details tab when configuring the session.

For other LO types, an ID is generated by the system on the back end when the learning object is created.

This field displays the unique, sequential number that is assigned to a session by the system when the session is created. The value is pulled from the Locator Number field on the Details tab for the session.

This field displays the maximum number of users who can register for the session. The value is pulled from the Details tab when configuring the session.

This field displays the minimum number of users who can register for the session. The value is pulled from the Details tab when configuring the session.

This field displays 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.

This field displays the price charged to register for a learning object (LO). This field contains numeric values only and does not include the currency associated with the price. The value is pulled from the Default Price Field from Pricing tab in the Course Catalog when configuring the LO.

Training Purpose

This field displays the purpose for the training, as defined by the administrator in the Training Purpose field on the General tab of the Course Catalog.

Training purposes are created by the administrator in Admin > Tools > Learning > Catalog Management > Training Purpose.

Note: The Training Purpose field in the Transcript section of custom reports is an end user field. The value in the report is the training purpose selected by the user when they requested the training.

This field displays the time and date when users may no longer register for a session. Time is displayed in the user's time zone using a 24-hour clock. The value is pulled from the Registration Deadline field on the Details tab when configuring the session.

This field displays the resume skills associated with a learning object (LO). The value is pulled from the Skills tab when configuring the LO in the Course Catalog. All skills appear on the report in the same cell separated by a comma.

Skills are created by the administrator in Admin > Tools > succession management > resume. See Define Attributes.

This field displays the date and time the part begins. The value displays in the time zone of the user running the report. If you would also like to view the time zone associated with the part, include the Part Time Zone field in your report.

The value for the Training Start Date field is pulled from the Start Date field in the DATE AND TIME section on the Parts Schedule tab for the session.

This field displays the status of the learning object (i.e., Approved, Expired, Tentative, Completed). This field does not display user transcript status for the learning object. For that, be sure to include the Transcript Status field in your report.

For a list of training statuses and descriptions, see the Transcripts Troubleshooting Guide topic in Online Help.

This field displays the name of the subjects that are configured for the learning object. This field separates subjects into individual rows and supports localization. The value is pulled from the Subjects tab in the Course Catalog.

This field displays the title of the learning object (LO). The value is pulled from the Title field for the LO.

Training Type

This field displays the type of learning object (LO), such as Online Course, Event, Program, Cohort, Test. The value for this field is determined by the type of LO that was created by the administrator or uploaded via the data load wizard.

This field displays the comments that were entered by the administrator when the version was created. The value for this field is pulled from the Comments field that is available when creating a new version of a learning object (LO). The location of the field varies by LO.

This field displays the date on which the version is effective. The location and name of the field in the system will vary based on the learning object type. For example, the value for this field for certifications is pulled from the Effective Date field on the Confirm page when configuring a new version of a certification.

This field displays the version number, if the learning object (LO) has multiple versions. The value for this field is usually pulled from the Version column on the Administration/Management page for the associated LO, such as the Certification Administration page and the Curricula Administration page.

This field displays the user's review of the training. The value is pulled from the Write your review for this training here field on the training review pop-up.

This field displays the title that the user entered for their review of the training. The value is pulled from the Enter review title here field on the training review pop-up.

This field indicates whether or not subordinates of the user are included in the availability for the learning object (LO). The value for this field is pulled from the Include Subordinates option on the Availability page when configuring training in the Course Catalog.

The report output displays "Yes" if subordinates are included or is blank if the checkbox is not selected in the Include Subordinates column.

Note: This field only applies to individual users who are added to the Availability tab; it does not apply to organizational unit (OU) criteria that is defined on the Availability tab. To include OU training availability criteria data, you must include the OU Training Availability fields in the report output.

This field indicates whether or not the user on the Availability tab is pre-approved for the training. The value for this field is pulled from the Include Pre-Approved column on the Availability page in the Course Catalog.

The report output displays "Yes" if box is checked in the Pre-Approved column. The report displays "No" if the box is not checked.

Note: This field only applies to individual users who are added to the Availability tab; it does not apply to organizational unit (OU) criteria that is defined on the Availability tab. To include OU training availability criteria data, you must include the OU Training Availability fields in the report output.

This field indicates whether or not the user on the Availability tab is automatically registered for the training when they are approved for the training. The value for this field is pulled from the Register Upon Approval column on the Availability page when configuring training in the Course Catalog.

The report output displays "Yes" if box is checked in the Register Upon Approval column. The report displays "No" if the box is not checked.

Note: This field only applies to individual users who are added to the Availability tab; it does not apply to organizational unit (OU) criteria that is defined on the Availability tab. To include OU training availability criteria data, you must include the OU Training Availability fields in the report output.

This field displays the training availability type for the user availability criteria that is configured for the training. The following are the possible values that will appear in the report:

• Featured
• Required
• Suggested
• Visible - Note: This value only appears in the report if "None" is selected in the Availability Type field.

The value is defined in the Availability Type column on the Availability tab in the Course Catalog. The column displays a drop-down, from which the administrator selects an option to define the availability type.

Note: This field only applies to individual users who are added to the Availability tab; it does not apply to organizational unit (OU) criteria that is defined on the Availability tab. To include OU training availability criteria data, you must include the OU Training Availability fields in the report output.

This field displays the user availability criteria that is configured for the training. The value is pulled from the users in the Criteria column on the Availability page in the Course Catalog when "Users" is selected in the Select Criteria drop-down.

Note: This field only applies to individual users who are added to the Availability tab; it does not apply to organizational unit (OU) criteria that is defined on the Availability tab. To include OU training availability criteria data, you must include the OU Training Availability fields in the report output.

This field displays the name of the training request form that was selected for the user availability criteria for an individual user. The value for this field is pulled from the Training Request Form column on the Availability page in the Course Catalog.

Note: This field only applies to individual users who are added to the Availability tab; it does not apply to organizational unit (OU) criteria that is defined on the Availability tab. To include OU training availability criteria data, you must include the OU Training Availability fields in the report output.

This field displays the rating submitted by the user for the training. The value is pulled from the star rating that is given by the user on the training review pop-up. The report displays a number based on the number of stars the user selected as the rating.

This field indicates whether or not the event or session allows waitlists. The report displays "True" if waitlists are allowed and displays "False" waitlists are not allowed. For events, the value is pulled from the Allow waitlist for sessions in this event field on the Session Defaults tab. For sessions, the value is pulled from the Allow waitlist for sessions in this event field on the Details tab when configuring the session.

This field displays the description provided for the training request form associated with a learning object on the user's transcript. The value is pulled from the Description field when configuring training request forms.

This field displays the text that appears at the top of the training request form as instructions. The value is pulled from the Instructions field when configuring training request forms.

This field displays the names of the users who own the training request form that is associated with a learning object on the user's transcript. Owners have access to the form and can modify all user forms. The value is pulled from the Form Owners field when configuring training request forms.

This field displays the status of the training request form associated with a learning object on the user's transcript. The standard statuses are Not Started, Submitted, Modified, Completed, and Cancelled. However, the statuses may appear differently in your portal, since they can be renamed on the Manage Form Status Names page.

The value for the Form Submission Status field is pulled from the Status field on the transcript page.

This field displays the text that appears at the top of the training request form as instructions. The value is pulled from the Title field when configuring training request forms.

This field displays 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" appears in this field on the report output.

Comments are entered by the assignor in the Add a Comment field on the Assign Training page.

This field displays the user ID of the user who assigned the training. The value is pulled from the user record of the user who assigned the training.

This field displays the name of the user who assigned the training. The value displays as [Last Name], [First Name]. The value is pulled from the user record of the user who assigned the training.

This field indicates whether or not the learning object (LO) was assigned to the user (rather than the user requesting the LO). The report displays "Yes" if the LO was assigned and displays "No" if the LO was not assigned.

This field displays the comments entered when canceling the session. The value is pulled from the Additional Comment field on the Session Details page.

Sessions are canceled by clicking the Cancel Session icon in the Session Options column on the Search All Sessions page.

This field displays the reason selected for canceling the session. The value is pulled from the Please select a reason drop-down on the Session Details page.

Sessions are canceled by clicking the Cancel Session icon in the Session Options column on the Search All Sessions page.

Note: Deleted cancellation reasons will persist in reporting in order to allow reporting on cancellation reasons used in the past.

This field enables reporting on the completion percentage of curricula. The completion percentage for each user is calculated once the user completes the first training item in the curriculum. The value is pulled from the Curriculum Progress field in the Curricula Player.

Use Case

1. Ella wants to report on the progress of students who are taking a particular curriculum so that her customer’s account managers can be prepared for conversations with their clients.
2. Ella creates a new custom Transcript report and adds the Curriculum Percentage Completion field to the report builder.
3. When Ella views the report output, she can see how much of a curriculum a student has completed based on the students who are registered for a curriculum and have opened the curriculum in the Curricula Player. She also sorts the column by percentage to see which students are at the highest and lowest completion percentage.

Note: Upon implementation of this field for the October '15 release, for existing curricula, users will need to re-access the Curricula Player for a particular curriculum in order for completion percentage to calculate. For new curricula created after this enhancement, completion percentage will be calculated when the user accesses the curriculum in the Curricula Player.

This field displays the user ID of the person who approved or denied the exemption request for a learning object on the user's transcript. The value is pulled from the user record of the user who exempted the training.

This field displays the name of the person who approved or denied the exemption request for a learning object on the user's transcript. The value displays as [Last Name], [First Name]. The value is pulled from the user record of the user who approved or denied the exemption request.

This field displays the comments entered by the person who approved or denied the exemption request. The value is pulled from the Comments field on the Exempt Response pop-up.

This field displays 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. The value is pulled from the Date column on the Completed tab of the Exemption Requests page.

This field displays the reason selected by the exemptor when they approved or denied the exemption request for a learning object on a user's transcript. The value is pulled from the Indicate Reason field on the Exempt Response pop-up.

This field displays the reason selected by the user when they requested an exemption for a learning object on their transcript. The value is pulled from the Indicate Reason field on the Exemption Request pop-up.

This field displays 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. The value is pulled from the Approval History section on the Training Details page of the transcript.

This field displays the number of days a learning object is past due for completion by a user, if a due date was assigned. The value is calculated by subtracting the current date from the due date.

This field displays the comments provided by the person who removed a learning object from a user's transcript, if comments were provided and the training was removed. The value is pulled from the comments box on the remove training page.

This field displays the reason provided by the person who removed a learning object from a user's transcript, if comments were provided and the training was removed. The value is pulled from the comments box on the remove training page.

This field displays the point value for the Learning badge that was automatically awarded to the user for completing the training. The badge appears on the Training Completion page in the user’s transcript.

The point value for a Learning badge is configured by the administrator in Badge & Points Preferences. Learning badges are added to individual learning objects on the General tab of the Course Catalog.

The value for the Training Badge Point Value field is pulled from the Points field on the Add Badge pop-up in Badge & Points Preferences.

This field displays the title of the Learning badge that was automatically awarded to the user for completing the training. The badge appears on the Training Completion page in the user’s transcript.

Learning badges are configured by the administrator in Badge & Points Preferences and are added to individual learning objects on the General tab of the Course Catalog.

The value for the Training Badge Title field is pulled from the Title field on the Add Badge pop-up in Badge & Points Preferences.

This field displays the date on which the user will no longer have access to the learning object (LO) after they register for the LO. The value is pulled from the Default Link Expiration field on the Pricing tab for the LO in the Course Catalog.

This field displays the point value that was awarded to the user for completing the training. The point value is the number of points that were configured for the badge at the time that the user completed the training.

The point value for a Learning badge is configured by the administrator in Badge & Points Preferences. Learning badges are added to individual learning objects on the General tab of the Course Catalog.

The value for the Training Point Value field is pulled from the Training Completion page, which is accessed from the user's Completed transcript page in Universal Profile.

This field displays the training purpose category selected by the user who approved the learning object. The value is pulled from the Select Category drop-down in the Purpose column on the View Pending Requests page.

Training purpose categories are created by the administrator in Admin > Tools > Learning > Catalog Management > Training Purpose.

Training Purpose

This field displays the training purpose selected by the user when they requested the learning object. The value is pulled from the Request pop-up when the user clicks Request to request the training.

The Training Purpose custom reports field only applies if Training Purpose functionality is activated for the portal.

This field displays 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. The value is pulled from the Approval History tab on the Training Details page in the transcript.

This field displays the date by which the user must complete the learning object, if a due date was assigned. The value is pulled from the Due field on the transcript.

This field displays 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. The value is pulled from the Approval History tab on the Training Details page in the transcript.

This field displays the score the user received on a learning object completion attempt. The value is pulled from the Score field on the Training Details page in the transcript.

For sessions, the score that displays is pulled from the Score column on the Roster tab of the Session Roster page.

This field displays the user's transcript status with regards to a learning object. The value is pulled from the Status field on the transcript page.

Waitlist Priority Rank

This field displays the user's priority order on the waitlist. The value is pulled from the Order column on the Waitlist page for the session in Manage Events and Sessions.

Withdrawal Reason Comments

This field displays the comments the user entered when withdrawing from the session. The value is pulled from the Comments field on the Session Details page, which is accessed by clicking Withdraw from the options drop-down for the session on the transcript page.

Withdrawal Reason

This field displays the reason the user selected for withdrawing from the session. The value is pulled from the Please select a reason drop-down on the Session Details page, which is accessed by clicking Withdraw from the options drop-down for the session on the transcript page.

This field displays the user's Address Line 1. The value is pulled from the Address Line 1 field on the user record.

This field indicates whether or not the user's user record should remain active or be deactivated if the user does not appear in the most recent data feed. The value is pulled from the Allow Reconciliation field on the user record.

If reconciliation is allowed, the user's record will be deactivated if it no longer appears in the feed. The report results display "Yes" in these instances.

If reconciliation is NOT allowed, then the user's record will be not be deactivated if it no longer appears in the feed. The report results display "No" in these instances.

This field displays the user's city. The value is pulled from the City field on the user record.

This field displays the user ID of the user's cost center approver. The value is pulled from the User ID field on the user record.

This field displays the name of the user's cost center approver. The value displays as [Last Name], [First Name]. The value is pulled from the Approver field on the Define OU page when configuring OUs.

This field displays the ID of the organizational unit (OU). The value for this field is pulled from the ID field on the OU configuration page in Manage Organizational Unit Hierarchy.

This field displays the owner of the user's assigned Cost Center Organizational Unit (OU). The value is pulled from the Owner field on the Define OU page when configuring the OU.

This field displays the parent of the user's assigned Cost Center Organizational Unit (OU). The value is pulled from the Parent field on the Define OU page when configuring OUs.

This field displays the ID of the user's assigned Cost Center Organizational Unit (OU). The value is pulled from the ID field on the Define Cost Center page when configuring cost centers.

This field displays the name of the user's assigned Cost Center Organizational Unit (OU), as shown on the user record page.

If the Cost Center OU has been renamed for the portal, this value in the report will reflect the updated name.

This field displays the ID of the organizational unit (OU). The value for this field is pulled from the ID field on the OU configuration page in Manage Organizational Unit Hierarchy.

This field displays the owner of the user's assigned Division Organizational Unit (OU). The value is pulled from the Owner field on the Define OU page when configuring the OU.

This field displays the ID of the parent of the user's assigned Division Organizational Unit (OU). The value is pulled from the ID field on the Define OU page of the parent Division OU when configuring OUs.

This field displays the parent of the user's assigned Division Organizational Unit (OU). The value is pulled from the Parent field on the Define OU page when configuring OUs.

This field displays the ID of the user's assigned Division Organizational Unit (OU). The value is pulled from the ID field on the Define OU page when configuring OUs.

This field displays the name of the user's assigned Division Organizational Unit (OU). The value is pulled from the Division field on the user record.

If the Division OU has been renamed for the portal, the value in the report will reflect the updated name.

This field displays the ID of the organizational unit (OU). The value for this field is pulled from the ID field on the OU configuration page in Manage Organizational Unit Hierarchy.

This field displays the owner of the Grade Organizational Unit (OU). The value is pulled from the Owner field on the Define OU page when configuring the OU.

This field displays the parent of the user's assigned Grade Organizational Unit (OU). The value is pulled from the Parent field on the Define OU page when configuring OUs.

This field displays the ID of the user's assigned Grade Organizational Unit (OU). The value is pulled from the ID field on the Define OU page when configuring OUs.

This field displays the name of the user's assigned Grade Organizational Unit (OU). The value is pulled from the Grade field on the user record.

This field displays the ID of the organizational unit (OU). The value for this field is pulled from the ID field on the OU configuration page in Manage Organizational Unit Hierarchy.

This field displays the owner of the user's assigned Location Organizational Unit (OU). The value is pulled from the Location field on the Define OU page when configuring the OU.

This field displays the parent of the user's assigned Location Organizational Unit (OU). The value is pulled from the Parent field on the Define OU page when configuring OUs.

This field displays the ID of the user's assigned Location Organizational Unit (OU). The value is pulled from the ID field on the Define OU page when configuring OUs.

This field displays the user's mailstop, as defined on the user record.

This field displays the numeric value provided through data feed only.

This field indicates whether or not a photo has been uploaded on the user's user record. The report displays "Yes" if a photo has been uploaded and displays "No" if a photo has not been uploaded.

This field displays the ID of the organizational unit (OU). The value for this field is pulled from the ID field on the OU configuration page in Manage Organizational Unit Hierarchy.

This field displays the owner of the user's assigned Position Organizational Unit (OU). The value is pulled from the Owner field on the Define OU page when configuring the OU.

This field displays the parent of the user's assigned Position Organizational Unit (OU). The value is pulled from the Parent field on the Define OU page when configuring OUs.

This field displays the ID of the user's assigned Position Organizational Unit (OU). The value is pulled from the ID field on the Define OU page when configuring OUs.

This field displays the name of the user's assigned Position Organizational Unit (OU). The value is pulled from the Position field on the user record.

If the Position OU has been renamed for the portal, the value in the report will reflect the updated name.

This field displays the user's ZIP or Postal Code. The value is pulled from the Zip field on the user record.

This field displays the number of people (e.g., managers, approvers) from which the user must get approval before being able to register for training. The value is pulled from the Required Training Approvals field on the user record.

This field displays the user's state or province. The value is pulled from the State field on the user record.

This field displays the user's absent status. The report displays "Yes" if the user is marked absent and displays "No" if the user is not absent. The value is pulled from the Absent field on the user record.

This field displays the user's Address Line 2. The value is pulled from the Address Line 2 field on the user record.

This field displays the user ID of the user's approver. The value is pulled from the User ID field on the user record.

This field displays the name of the user's approver. The value displays as [Last Name], [First Name]. The value is pulled from the First Name/Last Name fields on the user record.

This field displays the user's country. The value is pulled from the Country field on the user record.

This field displays the user's email address. The value is pulled from the Email Address field on the user record.

This field displays the user's fax number. The value is pulled from the Fax Number field on the user record.

This field displays the user's first name. The value is pulled from the First Name field on the user record.

This field displays the name of the user's full name. The value displays as [Last Name], [First Name]. The value is pulled from the First Name/Last Name fields on the user record.

This field displays the user GUID. GUID is a Data Load Wizard term. The GUID appears in the User Data Load template and can be mapped in the Data Load Wizard. When the GUID is included in the User data load, the GUID is used as the primary key and validates the user record.

This field displays the user's user ID, which is the unique identifier for the user. The value is pulled from the User ID field on the user record.

This field displays the email address of the user's indirect manager. The value is pulled from the Email Address field on the user record of the user's indirect manager.

This field displays the first name of the user's indirect manager. The value is pulled from the First Name field on the user record of the user's indirect manager.

This field displays the user ID of the user's indirect manager. The value is pulled from the User ID field on the user record of the user's indirect manager.

This field displays the last name of the user's indirect manager. The value is pulled from the Last Name field on the user record of the user's indirect manager.

This field displays the full name of the user's indirect manager. The value displays as [Last Name], [First Name]. The value is pulled from the First Name/Last Name fields on the user record of the user's indirect manager.

This field displays thedate and time of the user's most recent, successful login prior to the analytics data refresh. Date criterion is always implemented using UTC (Coordinated Universal Time).

This field displays the date on which the user was most recently hired. The value is pulled from the Last Hire Date field on the user record.

This field displays the user's last name. The value is pulled from the Last Name field on the user record.

This field displays the email address of the user's manager. The value is pulled from the Email Address field on the user record of the user's manager.

This field displays the user ID of the user's manager. The value is pulled from the User ID field on the user record of the user's manager.

This field displays the full name of the user's manager. The value displays as [Last Name], [First Name]. The value is pulled from the First Name/Last Name fields on the user record of the user's manager.

This field displays the user's middle name. The value is pulled from the Middle Name field on the user record.

This field displays the user's mobile phone number. The value is pulled from the Mobile Phone field on the user record.

This field displays the user's user name, which is used to log in to the portal. The value is pulled from the User Name field on the user record.

This field displays the user's name prefix. Examples of name prefixes include Mr., Mrs., Ms., Miss, Dr. The value is pulled from the Prefix field on the user record.

This field displays the user's name suffix. Examples of name prefixes include II, III, Jr., Sr. The value is pulled from the Suffix field on the user record.

This field displays the date on which the user was most originally hired. The value is pulled from the Original Hire Date field on the user record.

This field displays the user's phone number. The value is pulled from the Phone field on the user record.

This field displays the user's status. The value in the report output is Active, Inactive, Pending Approval, or N/A.

Users with an inactive status are unable to log in to the portal.

Pending approval status applies to users who have submitted self-registration requests that are pending approval by the self-registration group approver. Users pending approval cannot log in to the portal until their records are approved.

N/A status applies to external user's added to peer groups in Performance, and External Candidate for external successors added during Succession Planning tasks.

The value for the User Status field in the report is pulled from the User Status field on the user record.