The Faculty Import loads faculty demographic information into the system and includes a home department.  This does not prevent faculty from teaching outside of this department and viewing results for the courses taught in that department.


NOTES:

  • Faculty members that are imported will automatically be assigned the roles of Participating Faculty and Responsible Faculty.  There is no need to reload the faculty import unless changes need to be made to faculty records.
  • If a faculty is found in the student import or students are found in the faculty import, the system will automatically switch their primary role to the Student /Faculty role so they may be attached as teacher or student.


Required Import Fields:

Description
Updatable
Notes
LastName
Yes
Last Name
FirstName
Yes
First Name
UserName
No - if matching import on user name. Yes - if matching import on School ID
Must be a unique user name. This value will become the user name for logging into the application. If the school is going to use external authentication in the future, this user name MUST be the network user name.
Department
Yes
This is the 'Home Department' of the faculty member.
Make sure department name is always entered the same (i.e.: Bio on all - NOT Bio then Biology on the next record)
DepartmentAdmin (Recommended)
Yes
This field indicates that the user plays an administrative role in the department specified in the Department Name field. Enter either “Y” or “N."  If a faculty member is accidentally flagged with "N," the system will not remove someone as a department administrator.
Email
Yes
E-mail address


Other non-required fields include:

Description
Updatable
Notes
MiddleInitial
Yes
Middle Initial
SchoolIDNumber
Yes
User’s ID Number - required if using the option to match on ID #
Salutation
Yes
Faculty's Salutation: (i.e. Dr., Mrs., Ms., Mr.)
Gender
Yes
Should contain either “Male” or “Female”
Ethnicity
Yes
Individual’s Ethnicity.
ResearchCodeA
ResearchCodeB
ResearchCodeC
Yes
Valid values are: A1, A2, A3…A10, B1, B2, B3…B10, or C1, C2, C3…C10.
Active
Yes
The field indicates that the faculty is either active "Y" or inactive "N".  Faculty members that are imported with a “N” flag, will automatically be deactivated.
PictureURL
Yes
URL must be either fully qualified with domain name or a relative path that evaluates to a valid link on the target server.
ForceInternal
Yes
Forces a record to internal authentication regardless of whether or not external authentication is setup. : Y/Yes or N/No/(empty)
LocalPassword
No
Pre version 3.89: The value in this field will become the user’s default local password if the school is using internal authentication. This value can be up to 35 characters in length.
Post version 3.89: For added security, users will be forced to set their own password the first time they log in.
BirthDate
Yes
Birth Date in format: YYYYMMDD. Used to determine Age in some cases
FacultyLevel
Yes
Faculty Level: e.g. Adjunct Professor, professor
StartDate
Yes
Start Date in format: YYYYMMDD. Start date can be used to determine years of service or years at institution


Video - Faculty Import


Related Articles

Import Overview

Core Imports
Leading Zero Drop Off