The Course ID lookup feature enables you to validate extracted Course IDs of College documents. Therefore, a lookup table is required that holds the information of Course IDs for any institution.
Institution Identifier: The institution ID (and optional an institution Site ID). For more information, refer to Institution ID, Site ID, and Internal Institution ID fields.
Course ID: A unique identifier as string for a course that contains:
-
The Course Subject: Alphabetical part of the course ID. Example: “MATH” for a Course ID: MATH-1234”
-
The Course Number: Integer part of the course ID. Example: “1234” for a Course ID: MATH-1234”
Description: The name of the course
The Course ID and Description must be inserted like the institutions transcripts documents.
The Course ID lookup table is used to validate the Course IDs after the extraction in Runtime Server. Any extracted Course ID is looked up against the Course ID lookup table.
If a match is found (Course ID or Description) for the selected institution, the extracted Course ID is set to valid; if no match is found, the extracted Course ID is set to invalid.
If a match is found for the description, the extracted Course ID is replaced by the Course ID of the lookup table. For more information, refer to Validate Course ID from DB.
To ensure that only validated values are inserted into that table, the records can be inserted automatically while exporting a document, during document validation. For more information, refer to Update the Course ID lookup table on Export.
The Course ID lookup is also used at the time of export for splitting the Course ID (which is not a default export field) into the export fields Course Subject and Course Number into the course subject and the course number forced by the Course ID lookup table. For more information, refer to Split Course ID into the course subject and the course number forced by the Course ID lookup table.