Overview of Our Data Models
Data Models for Loading Data into Faculty Activity Reporting
Each of the files attached below are one of our data models used for loading data into Faculty Activity Reporting (FAR). It is critical that you follow the format of each data model to avoid loading erroneous data into the system. Each file contains an excel workbook with the following tabs:
- Instructions: for using the data model, including general information and upload requirements
- Details: A comprehensive list of available fields to load using the data model
- Data Sample: An example of how the file is used. When you're ready to populate your data model, download the data models and clear out the example data.
Populate the file with your institution's data and save your file as a CSV or TSV. Additional files, like Work Experience, can be uploaded, with required fields based on the UI's specifications. Providing as much data as possible reduces faculty input. Therefore, it is recommended to provide us the information you have in the correct file format. If you rename a section in FAR, you can also rename the corresponding file to match, such as changing Work Experience to Professional Experience.
Check out this article About Autoload Information for information about the SFTP folders.
About our Data Models
Download our Data Models
| Product | Details |
|---|---|
| FAR |
Click the links below to download the Faculty Activity Reporting data models.
Check out our Sample Help & Instruction Text! File RequirementsYour data must meet the following conditions:
|
| LM | Download All Lifecycle Management Data Models. |
| FS/RPT |
In RPT and FS, institutions cannot bulk upload new users. If manually adding users is impractical, you can submit a file to us, and we will process the upload on your behalf. |
Non-Base Data
To load Non-base data, contact the Technical Services team by submitting a ticket.
| File Name | Purpose | SFTP Folder |
|---|---|---|
| Activity Distribution (Activity Form) | If this section is active, the Institution may use it to load Teaching, Research, Service, or Other workload percentages. This section is not always shown on the Activity Form, sometimes it is noted as Not Shown and therefore is hidden from view/use on the Activities Form. | Incoming |
| Administrative Appointments (Profile Form) | This file allows the client to include information about a Faculty member's Administrative Appointments such as Chair or past Chair Appointments. Some Institutions add Chair as a Current Position and others add Chair to the Administrative Appointment with no end date for current appointments. | Incoming |
| Advising Load (Activity Form) | Advising Load is the number of Students of any level that a Faculty member may be advising. This section is not always marked as 'Shown'. This file is only used if this data is housed somewhere and can be put into a file format that can be uploaded into FAR. | Incoming |
| Book, Book Chapter, Journal Article (Scholarship) | This is one of the most common Scholarship files that is uploaded. The nice thing about uploading Scholarly Contributions is that you do not need to include answers to the Activity Classifications. The Activity Classifications can be answered by the Faculty member later. There are specific directions for including Co-Author or Co-Contributor data. Please see the Scholarship Data Model Instruction tab for more information. | Incoming |
| Current Positions (Profile Form) | This file allows the client to include the Faculty's Title or Titles on the Current Position section on the Profile Form. The Faculty Rank is visible in the UI in this section, but the rank can not be edited on this file. The Rank is part of the Faculty file and/or the Faculty Classification file. | Autoload |
| Degrees (Profile Form) | The Degrees file is recommended if the client has a list of degrees or even just a terminal degree for each Faculty at the Institution. It's one less thing for the Faculty to enter. One or more degrees can be uploaded for each Faculty. Please refer to the Degree List for a list of available degrees in FAR. | Incoming |
| Grants (Activity Form) |
Grants is for the standard Grants section on the Activity Form and must be loaded by Proposed and/or Awarded grants. Check out this article about Grant Uploads for more information |
Incoming |
| Institutional Committees (Activity Form) | This assigns a Faculty member to standing committees as needed. This information is probably on a spreadsheet somewhere, but can be loaded into FAR if the data can be pulled into the fields that are required. If not, then only the Committee file would be added and then the Faculty would enter their Standing Committee work and the role(s) they have for each Committee they are currently sitting on or have sat on in the past. | Incoming |
| Rank and Promotion History (Profile Form) |
Rank and Promotion History is what gets entered when someone's Rank changes. For example, if someone's current position shows the Rank as Assistant Professor and their Title as Assistant Professor of World History, when this Faculty member is promoted to Associate Professor, their Assistant Professor Rank should move to ‘Rank and Promotion History,’ and a new Current Position file should be uploaded to show the change to the Faculty's Title. The Faculty Classification file will need to be uploaded to change the Rank on the Current Position. This is a manual process. To update Rank and Promotion History:
|
Incoming |
| Scholarly Outlets and Scholarly Outlet Metrics | This is usually housed at the School or College level and is a way for that Unit to keep track of the Faculty's scholarly contributions. This is not used very often, but I have uploaded it before for clients, and once you show them these two files they understand what they need to do. If this information is uploaded then the data can be pulled out into Scholarly Contribution reports. What usually happens is that the IT team loads this information for past terms and then going forward IT will load this data annually. | Incoming |