Exports

The Exports utility is used to save learner transcripts to a downloadable data file. The exported file contains the following information:

  • Personal Information, including EmployeeID, SSN (if selected), First and Last Name
  • Course Information (Title, abbreviation, HR link and class title)
  • Transcript information (Completion Date, Grades and Credits)

  1. If you want to include Social Security Numbers in your exported transcript file, select the Include SSN check box.

  2. Specify the time frame you want to export records within by choosing an option in Date Range.

    Note: If you choose Custom, specify the custom date range in the From and Through fields.

  3. Type a filename for the transcript file in the text box under Enter a name for the file.
  4. Specify the file format you want to save the file as in the Choose an export type section.
  5. Click Export. The File Download window displays prompting you to choose an application in which to save the file.
  6. Choose whether to Open or Save the file and follow the prompts to complete that choice of action.

Although you can choose between four different file types, the resulting data in the file will be the same for the range you specified (although formatted differently according to the file format chosen).

The columns in the exported transcript are:

EmployeeId The learner's employee ID.
CourseAbbr The abbreviated name for the course the learner completed.
CourseLink A link (url) to the online course (if applicable).
CourseName The full name of the course that the learner completed.
ShortTitle The short title of the class corresponding to the course.
CmpDate The date the course was completed.
ClassName The full title of the class corresponding to the course.
LastName The learner's last name.
FirstName The learner's first name.
Credits The credits that the learner earned by completing the course.
Grade The grade that the learner earned upon completing the course.
MI The learner's middle initial.
SSN The learner's Social Security Number.