Initial Data Imports for Faculty Success: Faculty Accomplishments

Creating an initial user accounts file and course prefix file  are the first steps of the Faculty Success implementation. These files build the foundation of the instrument.

Creating Initial User Accounts File

Prerequisites

  • You must have your user data available from your SIS, HR System, or other campus data source.
  • Download the attached User Account Creation template file.

Note: While some fields like Middle Name, Tenure Status, and Faculty Rank are optional, providing complete data during this step will enhance the initial setup of your Faculty Success instrument.

CSV Columns Overview

An excel table showing CSV headers and sample rows with faculty details.

The following columns are core user data for account creation:

  • Last Name
  • First Name
  • Middle Name/Initial (Optional)
  • Email Address
  • Username

The next set of columns are focused at capturing the initial appointment information, or administrative data, for Faculty Success.

  • Academic Year (Use the current Academic Year)
  • College(s)
    • If users are assigned to multiple colleges or departments, add columns as needed (e.g., "College1", "Department1", "College2", "Department2")
    • If your institution uses a term other than College, you can label it as 
      such in your file (e.g., School)
  • Department(s)
  • Tenure Status (Optional)
    • This field is a drop-down with the following default options:
      • Non-Tenure Track
      • Tenure-Track
      • Tenured
  • Faculty Rank (Optional)
    • This field is a drop-down with the following default values:
      • Academic Staff
      • Adjunct Faculty
      • Assistant Professor
      • Associate Professor
      • Clinical Faculty
      • Distinguished Professor
      • Emeritus
      • Executive-in-Residence
      • Full Professor
      • Instructor
      • Lecturer
      • Master's Student
      • PhD Candidate
      • PhD Student
      • Senior Lecturer
      • Staff
      • Teaching Assistant
      • Visiting Faculty

Guide to Completing this Document

Confirm Data Source: Ensure that the SIS, HR System, or other campus data storage system is up to date before importing data into Faculty Success.

Check for Continuity: Look for duplicate values with different naming conventions (e.g., & vs. and) or spelling errors.

Avoid Abbreviations: The data provided in the User Creation File will appear on reports. Best practice is to spell out abbreviations (i.e., use "College of Business" instead of "COB").

Confirm Verbiage: These fields will be displayed to users in Faculty Success; ensure understandable language is used.

Secondary Identifiers: If additional unique identifiers are needed to import data from other campus systems (e.g., when the campus username is not identical to the email prefix), include an additional column. The column header should be named as it should appear in Faculty Success (e.g., BannerID, EMPLID, UID, etc.).

Watermark Campus: If a file has been created for another product (Planning & Self Study, Outcomes Assessment Projects, Student Learning & Licensure), that file can be modified to create the Faculty Success file.

AACSB Reports: For institutions with AACSB accreditation for business, additional data can be provided as part of the initial user creation import, but is not required. If configuring the system to run AACSB reports, it is recommended to include columns for AACSB Discipline, AACSB Specialty, and other AACSB fields. Discipline values are decided by the institution; specialty values are determined by AACSB. Review Supporting AACSB's 2020 Standards for more information. 

Refer to the “UserTemplateIncludingAACSB.csv” file template at the bottom of the article for the AACSB user template. If not including AACSB data during initial user creation, refer to the “UserTemplate.csv” user template.

Creating Course Prefix File

Please list all course prefixes that match the course information that will be loaded in your faculty's Scheduled Teaching screen. List how the course prefixes appear in your SIS or your data single source of truth.

Download the attached Course Prefix Creation template file.

Was this article helpful?
0 out of 1 found this helpful

Articles in this section

How to Contact Support
There are many ways to reach out! Click the icon above for our support options.
Watermark Academy
Click the icon above to access the Watermark Academy for consultation, training, and implementation companion courses.
Customer Community
Can’t find the answer? Ask fellow users how they’re making the most of Watermark in our Community!