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 combination of 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 the course outcome has not yet been reported against that 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: Substitute).

Resolution

Where the duplicate course enrolment has already been created within Paradigm, a slightly complicated series of steps must be undertaken to report both course enrolments, so that the changes do not trigger any TCSI 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 Status in Course B so they are reported to TCSI with a Unit Enrolment status that is linked to an Element E355 outcome value of (1) "Withdrawn Without Penalty".

  3. Update Course B and set the Course Enrolment Status to a value that will report a (2) "Withdrawn" outcome via Element E599

  4. The above 3 steps make it look like in TCSI that nothing has been reported for Course B Enrolment

  5. Load Course A

  6. Ensure that ALL TCSI-reportable Unit Enrolment Statuses in Course A are set to an enrolment status linked to an E355 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​"

  7. Update ALL Course A Unit Enrolments and set them to Read-Only, see Make a record Read-Only

  8. Update Course A and set it to a Course Enrolment Status that will report a suitable E599 outcome such as (7) - "Transfer to continue a related course"

  9. Update Course A and mark it as Read-Only, see Make a record Read-Only

  10. This makes Course A look like it has been completed with a Course Enrolment Status of "Transferred to continue a related course".

  11. Load Course B

  12. Update ALL TCSI-reportable Unit Enrolments and set the Unit Enrolment Status as required to reflect the student circumstances, for example setting them to enrolled, completed, failed etc.

  13. Set Course B to have the Course Enrolment Status of ENROLLED

  14. This will make Course B look like it is the currently enrolled course, in the eyes of TCSI

Last updated