• New programs will be added only if Create any non-existent Programs checkbox is checked.
  • New departments will be added only if Create any non-existent Departments checkbox is checked.
  • New periods are always added and logged.
  • Duplicates are eliminated both before and after matching.
  • Matching is on course number, section, and period. Section is not required.
  • Matching does not consider the database.
  • Active flag defaults to YES if empty.
  • Active flag is set to YES if the word in the column starts with ‘Y’ or ‘y’
  • Student year is set to 1 if not supplied in the import or not an integer.
  • Start date and end date are validated to be valid dates based on YYYYMMDD format. If invalid, a warning is issued.
  • New course designators are always added and logged
  • New course types are always added and logged
  • Responsible Faculty
    • Up to 3 columns can be used to look up the Responsible Faculty: UserName, SchoolId, Email
    • The lookup is done in this order: UserName, SchoolId, Email
    • If the Responsible Faculty is entered and not matched in Course Evaluations a warning is issued (not an error)
    • The Responsible Faculty role is added to all people matched if they do not have it already.
    • If the Responsible Faculty is looked up successfully and the checkbox is checked to Overwrite the Responsible Faculty for the course, remove any existing Responsible Faculty from the course and add the new Responsible Faculty.
    • If the Responsible Faculty is supplied and not looked up, the overwrite Responsible Faculty is skipped for the course.
  • Lock-step schools
    • If the school is setup as lock-step, the student year is a required field.
    • If the school is setup as lock-step, Student/course enrollment is refreshed (in full) after every course import.
    • If the school is setup as lock-step, the lockstep flag is set to YES if the word in the column starts with ‘Y’ or ‘y’ and is not empty. It is set to ‘N’ if empty or not lockstep.
    • The lock-step field is not updatable because the user could have changed this flag in the UI and it may be set to ‘NO’ by the import business rules.