Edge Import - Curriculum Transcript Load and Feed

The Curriculum Transcript load and feed enable organizations to load transcript data specific to curriculum learning objects.

PERMISSION NAME PERMISSION DESCRIPTION CATEGORY
Access LMS - Curriculum Transcripts Load Grants access to the Curriculum Transcripts data load via Edge Import. This permission can be constrained by OU and Provider. This is an administrator permission. Edge Import

Starter Guide

Select this link to download the Edge Import Starter Guide.

Select this link to download the Edge Import - Learning Guide.

Unique Identifiers

When loading curriculum transcript data, the following can be used as the unique identifier for each curriculum:

  • Curriculum ID - Select this option when you have Curriculum IDs available and want to import new transcripts or update existing transcripts.
    • The final unique key fields will be User ID, Curriculum ID, and Transcript Key.
    • In Custom Reports, the Curriculum ID is displayed as Training ID.
    • Curricula created via the user interface will not have a Curriculum ID. To update transcript records for curricula created via the user interface, you must use the system-generated Learning Object ID.
  • Learning Object ID - Select this option if you have the unique system generated Learning Object IDs available and want to import new transcripts or update existing transcripts.
    • The final unique key fields will be User ID, Learning Object ID, and Transcript Key.
    • You can create a custom report to locate the Learning Object ID of each curriculum.

When updating existing transcript data, the following can be used as the unique identifier for each transcript record:

  • Registration Date/Time - Select this option to create new or update existing transcript records with previously loaded registration date. Recurrence must be enabled for the learning object in the Course Catalog before adding multiple registrations. The final unique key fields will be User ID, Learning Object ID, and Registration Date/Time.
  • Registration Number - Select this option to update existing transcript registrations. A new transcript registration cannot be added using this option. The final unique key fields will be User ID, Learning Object ID, and Registration Number.

How to Make a Curriculum and all Child Items Complete

  1. Load the child LOs first (i.e., Materials, Online Courses etc.).
  2. Load the curriculum LO.
  3. Load the curriculum parts by assigning the child LOs to the curriculum LO.
  4. Load the transcript records for each child LO in Completed status. If all child LOs are in Completed status, the curriculum LO will be in Completed status.

Supported Transcript Statuses

The following transcript statuses are supported with this load type:

  • Completed
  • Exempt
  • Registered

Note: Edge Import can be used to update a transcript status to "Completed" even if the current transcript status is not supported in Edge Import. For example, Edge Import can update a transcript status from "Registered/Past Due" to "Completed." Some restrictions apply and are included in the updated template guide.

Due Date - Acceptable Format and Default Value

The Due Date field accepts the following format: DATE HH:MM:SS +/- UTC offset.

  1. If the Due Date time is not provided, the time defaults to 23:59:00.
  2. If the UTC offset is not provided, the offset defaults to UTC.

The following Due Date formats are accepted and available in the template guide:

  1. Valid Date Only
    1. Due date provided in the file: 01-01-2023
    2. Due date complete value processed by system: DATE: 01-01-2023 TIME: 23:59:00 OFFSET: UTC
  2. Valid Date and Time
    1. Due date provided in the file: 01-01-2023 11:11
    2. Due date complete value processed by system: DATE: 01-01-2023 TIME: 11:11:00 OFFSET: UTC
  3. Valid Date with Offset
    1. Case 1: Valid offset
      1. Due date provided in the file: 01-01-2023 +5
      2. Due date complete value processed by system: DATE: 01-01-2023 TIME: 23:59:00 OFFSET: +5
    2. Case 2: Offset provided as 0; because 0 is not valid, UTC is used.
      1. Due date provided in the file: 01-01-2023 +0
      2. Due date complete value processed by system: DATE: 01-01-2023 TIME: 23:59 OFFSET: UTC
  4. Valid Date and Time with Offset
    1. Case 1: Valid offset
      1. Due date provided in the file: 01-01-2023 11:11 +5
      2. Due date complete value processed by system: DATE: 01-01-2023 TIME: 11:11 PM OFFSET: +5
    2. Case 2: Offset provided as 0; because 0 is not valid, UTC is used.
      1. Due date provided in the file: 01-01-2023 11:11 +0
      2. Due date complete value processed by system: DATE: 01-01-2023 TIME: 11:11 OFFSET: UTC

Considerations

The following considerations apply to this load type:

  • A post process to apply transcript rules will be triggered if transcript records are eligible to apply additional business logic. Review the latest template guideline for examples.
  • For curricula completion, child items need to be uploaded in Completed status. If all child items are in Completed status, this triggers the curricula transcript status to be completed.

Frequently Asked Questions (FAQs)

Yes.

No, this is not supported.