Dual Role or Teaching Assistant Import
This role represents individuals who teach and take courses. The role of a Teaching Assistant is usually a graduate student at a college who acts as an instructor for an undergraduate course in his or her field. Enrolling them as a T/A will allow students to evaluate them with a set of multiple type questions on the survey like a faculty level instructor. T/As will be able to access their results the same way faculty does with restrictions available to what they are able to see.
At this time, when a T/A is imported, they will be assigned the Responsible Faculty and Participating Faculty roles in addition to the T/A role. Some schools have T/As that are responsible for courses, so this option was left in place. If the school does not use T/As on courses, then there is no need to do this import.
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) |
GraduationYear | Yes | If the curriculum is lock step this is a required field. This represents the year the student is expected to complete their coursework. For schools that do not have a ‘lock step’ curriculum, this field will mainly be used to separate groups of students. If the year of graduation is not known, it should be set at four years from the current year. |
Yes | E-mail address up to 75 characters long. |
Other non-required fields include:
Description | Updatable | Notes |
MiddleInitial | Yes | Middle Initial |
SchoolIDNumber | Yes | User’s ID Number |
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 |
Course Load | Yes | Student course load. Point in time. Used for SETE |
Credits Earned | Yes | Student credits earned. Point in time. Used for SETE |
GPA | Yes | Student GPA. Point in time. Used for SETE |
Major | Yes | Student major |
StartDate | Yes | Start Date in format: YYYYMMDD. Start date can be used to determine years of service or years at institution |
StudentLevel | Yes | Student Level: e.g. Freshman, Sophomore, Doctoral |
FacultyLevel | Yes | Faculty Level: e.g. Adjunct Professor, professor |