Faculty Data

Data residing in faculty records in Schooltool will only pass to ConnectEd if and only if the following is true:

  • The "Faculty ID" and/or "Universal FacultyID" field(s) must contain a value - records are not considered as valid faculty records until this data is available.



The following table lists out the Faculty data that is provided to Blackboard Connect by the Schooltool Data Sync program, and provides a brief explanation of where each data item comes from in Schooltool.

**The images at the bottom of this article can assist you with mapping where the information below, actually comes from on the Faculty Record itself.

RowID

Data Column Name

Data Description

1

ContactType

This is set based on what is on file in the Schooltool Faculty record as follows:


· FACULTY – Any faculty record where the "type" or "department" selected contains the word "teach" --or-- where the length of the value entered into the UniversalFacultyID field, is 7 characters or greater.

· OTHER – Any faculty records where the “type” field is set to “Other”

· STAFF - Any faculty records where the “type” selected contains the word “Staff” anywhere in it (i.e. Staff-Office, Staff TA), or in situations where none of the scenarios above otherwise apply.


**Hint: Because Blackboard Connects requires a "ContactType" in order for data to flow into it automatically, the data sync system will generally assume "Staff" if none of the scenarios above applies.


2

Institution

The Institution ID is set to the ID of the building(s) the faculty member is assigned to which will then correlate to the same “Site” in Blackboard Connect

3

ReferenceCode

Unique "Person ID" that is generated automatically by Schooltool for each faculty record which cannot be viewed or edited using Schooltool

4

FirstName

Faculty's First name

5

LastName

Faculty's Last Name

6

PrimaryPhone

The Lowest Ranked Phone Number of any type (e.g. Rank 1) for the staff member in their Faculty Record

7

HomePhone

The Lowest Ranked Phone Number with Type "Home" that appears in the staff member's Faculty Record

8

MobilePhone

The Lowest Ranked Phone Number with Type "Cell" that appears in the staff member's Faculty Record

9

SMSPhone

The Lowest Ranked Phone Number that appears in the staff member's Faculty Record with a Type that contains the word "SMS" somewhere in it

10

EmailAddress

Email Address that appears in the "Email" field in the Faculty Record for each staff member

11

HomeAddress

Faculty's Home Street Address

12

HomeCity

Faculty's Home City

13

HomeState

Faculty's Home State

14

HomeZip

Faculty's Home Zip

15

RefreshGroup

This is set to the DEPARTMENT that the faculty member is assigned to


Faculty Summary Screen (visible only when viewing Staff Records)




Faculty Details Screen (visible only when Staff Record is in in Edit Mode)