TCSI Error Code - 10070

The Student Resource Key (UID8) already exists for the Course Resource Key (UID5), which is incomplete.


TCSI Error Description

Please check the Student Resource Key (UID8) and the Course Resource Key (UID5). A record with this combination already exists. A student cannot be reported for a course a second time where the Course Outcome Code (E599) for the existing record indicates that the student is still enrolled (blank) or is on approved leave ('4').

Error Logic

If there is an active record in the database with a given Student Resource Key (UID8)/Course Resource Key (UID5) combination and the Course Outcome Code (E599) is blank (null) or '4', then another record with the same Student Resource Key (UID8)/Course Resource Key (UID5) must not be created.

Paradigm Error Resolution

This error occurs when the student has already been reported to TCSI as being enrolled in the course and where a course outcome has not been reported against the already existing course enrolment record.
The most common scenario for this is when more than one base course record shares the same value for UID 3 and UID 5. In practical terms, the most likely cause is changing the structure of a course that requires existing students to be internally transferred into the new course, resulting in a new course enrolment being created within Paradigm.

Prevention

To prevent this error entirely, ensure that base course records are given a unique value for the field HEIMS Course Code (E307), (see Edit Base Course Record), which results in a unique Course Resource Key (UID5).

The best way to resolve changes to the structure of a course is to use the Paradigm course plan rule type “substitute”, which is the practice of recognising an old unit as the equivalent to a new unit (see Course Plan Constraints).

Resolution

Where the duplicate course enrolment has already been created within Paradigm, then there is a slightly complicated series of steps that must be undertaken to report both course enrolments without triggering any validation errors.

 

Assumptions

  • Course A is the original student course enrolment

  • Course B is the newly created course enrolment that triggered the error

 

Workflow

  1. Load Course B

  2. Update all TCSI reportable unit enrolments in Course B so they are reported to TCSI with a unit enrolment status linked to an element 355 outcome of withdrawn without penalty

  3. Update Course B and set it to a course enrolment status that will report a withdrawn outcome via element 599

  4. Load Course A

  5. Ensure that all TCSI reportable unit enrolments in Course A are set to an enrolment status linked to a 355 outcome that is not 4 - Unit of study to be commenced later in the year or still in process of completing or completion status not yet determined​

  6. Update all Course A unit enrolments and set them to read-only

  7. Update Course A and set it to a course enrolment status that will report a suitable 599 outcome such as 7 - Transfer to continue a related course

  8. Update Course A and mark it as read-only

  9. Load Course B

  10. Update all TCSI reportable unit enrolments and set the enrolment status as required to reflect the student circumstances, for example setting them to enrolled, completed, failed etc.

 


 

Main Page >> TCSI Validation Errors FAQs