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. |
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)