Location

\\hscetl\data\ExamSoft

The folder also has the following sub-folders:

• • Archive - Contains the Course Exams Mapping files that have been loaded to the database in the past.
  • 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. Is this true? Section isn't required is it?
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'

...

Educational Data Warehouse required fields

COURSEABBR,COURSENUM ,COURSESEC,SEQ,TERM

COURSEABBR, COURSENUM ,COURSESEC are used to tie the courses to the actual Banner courses, 

...