...

• • Archive - Contains the Course Exams Mapping files that have been loaded to the database in the past.
  • Error_Logs - contains the following two files:
    • EXMS_Incorrect_Exams.csv - Contains invalid exams ids in the file when data was last available.
    • EXMS_Incorrect_Students.csv - Contains U-number records which don't match any Health Banner students in the file when data was last loaded.
  • Required file format - Contains the template file 'CourseExamsMapping.xls'. Please use it to generate any files that need to be loaded to the database as it contains the necessary columns in the correct order.Error_Logs - contains the following two files:

    EXMS_Incorrect_Exams.csv - This file has a list of Exams that cannot be found in the Educational Data Warehouse.

    EXMS_Incorrect_Students.csv - This file has a list of Students that cannot be found in the Educational Data Warehouse.

Rules for Data

1. All columns in the template file are required.
2. Must have a valid Exam and Posting ID which can be found within Examsoft.
3. Multiple rows per Exam ID are allowed with different Posting IDs.
4. Must have a valid U-Number for a USF Health Student.
5. Must have a valid term code available in Health Banner.
   1. Example format: 201707
   2. The first 4 digits are the year during which the term begins.
6. Must have a valid Course Abbreviation and Course Number available in Health Banner.
7. Sequence numbers are used to identify the order the exams were administered or types of exams
   1. 1-4
   2. 20-23:Reserved for Anatomy Practical Exams
   3. 30 and 31: EBCR Exams
   4. 75: Remediation exams that may cover more than 1 original exam topic
8. Columns must be in the order indicated on the 'CourseExamsMapping.xls'

...