Database Configuration

The Database Configuration feature allows the administrator with work request permissions to customize the default field settings for two key areas in Faculty Success. By using this utility, the administrator may select fields available to faculty in CV Imports, as well as the columns that appear for faculty on their Summary Screen activities. Through both options, the administrator will be able to better tailor Faculty Success to meet the specific needs of the institution.

Database Configuration can be accessed through the Tool utility from your Navigation Bar.

The Home page showing top navigation with Manage Data, Reports, Workflow, and Tools. Tools dropdown opens showing options Home, Usage Statistics, Users and Security, Work Requests, Course Evaluation Management, and Database Configuration. Arrow pointing at the Database Configuration option.

When you access the database configuration, you will see two tabs: one for CV import and another for Summary Screen Columns. Each tab will have a help category that describes the types of changes that you can make. Continue reading this article to learn more about the two tabs.

CV Import

When you select this tab, the landing page will be the help category, which notes the three methods for prioritizing and managing the fields that will be displayed for users to populate when they attempt a CV Import, which are to make the fields Required, Included, or Optional.

The Database Configuration page showing CV Import tab selected with left menu sections including General Credentials / Expertise through Administrative Data. Main panel summarizing Required, Included, and Optional field behavior. The Save button appears in the top right.

The other categories in the left-hand side panel correspond to the summary screen activities in your Faculty Success. By selecting a category on the left-hand side panel, you can view the summary screen activity and use the radio buttons on each to customize the fields that users will see as required, included, or optional when attempting to import a CV for that activity.

Although the field settings for Included and Optional fields are configurable, it is our recommendation that only fields that are primary components of high-usage reports be set as Included. This will streamline the import process for faculty, while ensuring that administrators are gathering key information for their reporting needs through CV Imports.

The Database Configuration page showing CV Import tab with Presentations selected in the left menu. Main table shows columns Field, Required, Included, and Optional. Rows include Presentation Title, Presentation Type, Explanation of Other, Conference/Meeting Name, and Sponsoring Organization with radio selections under Required, Included, and Optional. The Save button appears in the top right.

When you are finished modifying any of the field settings, press “Save” in the top right corner of the Database Configuration screen.

The Database Configuration for Activities Database - Your University page showing CV Import tab. Table displays fields Prefix, First Name, and Preferred First Name with radio options under Required, Included, and Optional. Left menu shows profile sections. Arrow pointing at the Save button in the top right.

Note: While static screens appear in Database Configuration, CV Imports currently only supports data entry through dynamic screens. Learn more about Static and Synamic Screens Types.

Summary Screen Columns

The columns displayed in the summary screen activities are there to help users quickly identify what they already have in the system and where there are gaps. The summary screen column tab allows you to customize the default columns displayed so that when your users log in for the first time, they are met with enough information to know which records they have and what they need to add. It is also an opportunity for you to communicate your institution's point of view on what is most important to capture about each type of activity.

When you select the Summary Screen Columns tab, the landing page will be the help category, which states that users can save their own column customizations. Being that, with dynamic summary screens, users can adjust which columns they would like to see.

The Database Configuration for Activities Database - Your University page showing Summary Screen Columns tab selected. The left menu shows Help and section categories. Main panel displays a description stating that Summary Screen Columns fields display when a user navigates to a summary screen for the first time and that saving a user’s own summary view overrides the default. The Save button appears in the top right.

To get started, expand on one of the categories on the left-hand side panel that correspond to the summary screen activities, and select an activity to start customizing the default columns for that summary screen. You will then be able to choose what fields on that screen should be displayed by default by checking the box next to the field and unchecking the checkbox for any fields you don't want to be displayed.

The Database Configuration page showing Summary Screen Columns tab with Publications selected in the left menu. Main panel lists checkboxes for Contribution Type, Explanation of Other, Current Status, Title of Contribution, If this is part of a larger work, Journal Name, Publisher/Proceedings Publisher, City and State of Journal/Publisher, Country of Journal/Publisher, Volume, and Issue Number/Edition. Some fields are checked. The Save button appears in the top right.

Dynamic-Sub Answer (DSA) Fields

Columns for dynamic-sub answer (DSA) fields may also be customized for each screen by selecting the field(s) you would like to display from the DSA, then choose between displaying the first row, first three rows, or the last row of the component to display

The Authors/Editors/Translators section showing Select Columns list with checkboxes for Count of Rows, People at Demo, First Name, Middle Name/Initial, Last Name, Institution/Company, Role, and if a student, what is his/her level?. The Count of Rows is checked. The Choose Display Option section shows radio buttons for First Row, First Three Rows, and Last Row, with First Row selected.

Once you save, your settings will be active across the system for users who have not already selected their own preferred columns through the dynamic features on their summary screen views.

Note: As a reminder, the default settings for field settings are based upon the most commonly-utilized reporting structures for faculty activities accomplishments. If you have any questions on best-practices for Database Configuration, please feel free to contact our Support team.

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!