Employee Fields

The Employee Fields screen is used to set up the categories and employee fields that display in the employee's record via Human Resources > Employee. Each of the categories set up in the Employee Fields screen display as a separate tab in the employee's record. In addition to displaying in the employee's record, the employee fields are available to create reports or search for users throughout Focus.

Adding a Category

Each of the categories set up in the Employee Fields screen display as a separate tab in the employee's record.

1. From the Human Resources menu, click Employee Fields.

Employee Fields

The Categories tab is displayed by default.

Employee Fields

2. In the blank row at the top of the screen, enter a Title for the category.

Employee Fields

3. Leave the Schools pull-down empty. The Schools field doesn't apply to employee fields.

Employee Fields

4. Select the Profiles that can view this category in the Employee screen. One or multiple can be selected.

Employee Fields

5. Select the Default View Profiles and the Default Edit Profiles.

Employee Fields

When new fields are assigned to the category, the profiles selected in Default View Profiles will have view permissions for those fields by default. The profiles selected in Default Edit Profiles will have edit permissions for those fields by default. You can leave these fields blank, if desired. Profiles who can view or edit fields can be added or changed on a specific field when editing the field in the Fields tab. Please see Adding a Field for more information.

If an existing field is moved to a category with the Default View Profiles and Default Edit Profiles set, the view and edit permissions for the field will not be automatically updated.

If the category already has fields assigned, selecting Default View Profiles and Default Edit Profiles on the category will only affect new fields assigned to the category after the profiles are set, not fields that have previously been assigned to the category.

6. If the category will be used as a form in Focus, select the Form check box.

Employee Fields

When a category is designated as a form, this allows users to store multiple, unique instances of information in that tab of the employee's record.

Once a category is designated as a form, it should not be deselected.

7. Select the SIS check box to make this category available in Users > User Info in SIS. Select the ERP check box to make this category available in Human Resources > Employee in ERP.

Employee Fields

8. In the Sort Order field, use the minus and plus icons to select the sort order. This determines the order the categories will appear in More Search Options when searching for an employee.

Employee Fields

The list of categories always displays in alphabetical order when viewing an employee's record in Employee.

9. Press Enter to add the new category.

Employee Fields

The category is added to the list and is auto-saved.

10. To add an icon that will display when viewing the category in the employee's record, click Add Icon next to the category.

Employee Fields

a. In the Change Icon for [Category Name] pop-up window, select the icon color and the desired icon.

Employee Fields

11. Click Save.

The selected icon will display in the Icon column next to the category.

Employee Fields

Example in the employee's record:

Employee
Editing a Category

1. From the Human Resources menu, click Employee Fields.

Employee Fields

2. In the Categories tab, locate the category in the list and make the desired changes. The Title, Schools, Profiles, Default View Profiles, Default Edit Profiles, Form, SIS, ERP, Sort Order, and Icon can be edited.

Employee Fields

The changes will auto-save.

Deleting a Category

The fields in a category should be moved to another category or deleted before the category is deleted. A warning message will display if you attempt to delete a category that has fields assigned.

1. From the Human Resources menu, click Employee Fields.

Employee Fields

2. In the Categories tab, locate the category in the list and click the red minus sign to the left of the Title.

Employee Fields

3. In the confirmation message, click OK.

The category is deleted.

Viewing the Fields Within a Category

1. From the Human Resources menu, click Employee Fields.

Employee Fields

2. In the Categories tab, locate the category in the list and click Edit Fields at the right side of the screen.

Employee Fields

The Fields tab opens, displaying the fields that are assigned to the category.

Employee Fields

6. To view the full list of fields, click the View all fields link at the top of the screen.

Employee Fields
Adding a Field

1. In the Human Resources menu, click Employee Fields.

Employee Fields

2. Click the Fields tab.

Employee Fields

3. In the blank row at the top of the screen, enter a Title for the field.

Employee Fields

The Alias is auto-populated once all other information is saved. Only aliases of custom fields can be edited.

4. Select the field Type.

Cursor
Field Type Description
Text Text fields work best for capturing information that has an unlimited number of potential answers. Text fields accommodate short answers, usually less than 50 characters in length, and can include numeric data, like email address, street addresses and zip codes.
Long Text While text fields work well for short entries, long text is best suited to note-like entries.
Checkbox Use check boxes to record information where a single option is going to be selected. This data type stores a "Y" or null and cannot be changed to a different data type once created.
Number Number fields include information like ID numbers, Social Security numbers, and other purely numeric data. This data type works best when the combination of numbers is virtually unlimited, rather than strictly limited, like a range of zip codes in a school district. If a number field type is selected, the user will not be able to enter non-numeric characters into the field.
Date For date fields, users can type in the date or select the date from the calendar. The date format stored is yyyy-mm-dd.
Time Time fields allow users to enter a time. Users can only enter time in the hh:mm format.
Select One This field type allows the user to select only one option from the pre-defined list. The list of options can be manually entered when setting up the field or defined with a query.
Select Multiple This field type allows the user to select one or multiple options from the pre-defined list. The list of options can be manually entered when setting up the field or defined with a query.
Logging Field Logging fields are used when several pieces of data make up a single record of information.The data points are part of a single record, and the user could have multiple records. Logging fields work best for providing comprehensive records of activity.

Unlike the other field types, logging fields can be more extensive, involving a set of fields for entering data. View and edit permissions are set for the logging field and for each individual column.
Computed This field type allows users to define a query that will be executed and the results displayed to the user when viewing the field.
Computed Table This field type allows users to define a query that will be executed and the results displayed in a table. The table can have multiple columns of data.
File Upload The File field type allows users to upload a file into Focus. Focus integrates with most commonly used formats, including Word, Excel, and PDF documents, as well as .rtf and .csv file formats. Once uploaded into Focus, users can click the file to download and view it.
Signature The signature field allows users to digitally sign their acknowledgement or consent in Focus. Users can use their mouse to sign. When using a tablet, users can use their finger or stylus to sign. This field can be set up to require the user to enter their username and password to authenticate the signature.
Placeholder Placeholder fields are used to separate sections on a page. A placeholder can function as a heading, or can include a URL.

5. Press Enter to add the new field.

Employee Fields

The field is added to the list and is auto-saved.

6. Click Edit Field next to the new field.

The Edit Field pop-up window is displayed. The setup for the field depends on the field type.

Employee Fields

If you already know the category a field will be assigned to, you can click Edit Fields next to the appropriate category in the Categories tab, and then add the new field in the blank row at the top of the screen. This will automatically select the category when setting up the field.

All Field Types

1. If this field will be included in a category that has been designated as a form, select Form Categories.

Employee Fields

The form categories are now available for selection in the Select Categories pull-down.

2. Use the Select Categories pull-down to select the categories this field will appear on. One or multiple categories can be selected.

Employee Fields

When Form Categories is selected, you will only be able to select one form category.

3. In the (Category) Sort Order pull-down, select where the new field should appear within the category. You can select to place it before an existing field, at the end of the category, or unsorted. If multiple categories were selected in the Select Categories field, a Sort Order pull-down will display for each category.

Employee Fields

4. In the Options section on the right side of the screen, select New User to display this field on the Add Employee screen.

Employee Fields

When New User is selected, the New User Sort Order pull-down is displayed. Select where to place the field in the list of existing fields on the Add Employee screen.

5. Select Required to make the field required.

Employee Fields

If the field is required, it must have either a default value, display when adding a new user, or both. The field will only be required for profiles with edit permissions to the field.

6. Select Visible on Add a User Search to have this field display in the search results when searching for a user on the Add Employee screen.

Employee Fields

7. Enter a Help URL ? in the text box to attach a URL to the field. Once entered, the URL displays as an attachment to the field that users can view and click to follow the URL. If a URL is inserted, a paperclip icon displays next to the field.

Employee Fields

The link displays as a paperclip that users can click to open the URL in a new tab or window.

Employee

8. Enter a Description if desired.

Employee Fields

When the user hovers the mouse over the question mark icon on the field in the employee's record, the description will display.

9. Select the profiles that will be able to view the field in the Profiles (View Access) pull-down. One or multiple profiles can be selected.

Employee Fields

10. Select the profiles that will be able to edit the field in the Profiles (Edit Access) pull-down. One or multiple profiles can be selected.

For logging fields, select the profiles that will have the ability to add records (new rows) to the logging field in the Profiles (Add Record) pull-down and select the profiles that will have the ability to delete records (rows) from the logging field in the Profiles (Delete Record) pull-down. One or multiple profiles can be selected. These do not provide permissions for individual columns, but for adding or deleting log entries (rows).

11. When finished setting up the field, click Save at the bottom of the window.

Employee Fields
Number, Checkbox, Date, File, Time

1. In the Defaults section of the window, select or enter a default Value for New Users, if applicable. When defined, the selected value will default into the field when adding a new employee.

Employee Fields

2. Select or enter a State Reporting Fallback Value, if applicable. When defined, the selected value will be included in extracts for state reporting unless the employee has a value already selected in their record.

Select One and Select Multiple

1. In the Select Options section of the window, either define the Select Options manually or enter a Select Options Query.

Select Options:

Employee Fields

a. In the blank row, enter a Code and Label (what will display for the user) for the option.

b. Enter a Sort Order for the option. This will display the options in the defined order.

c. If desired, enter the Min School Year and Max School Year, which are used to make these options only available for selection within the range of school years. Existing data will be maintained.

d. Press Enter to add the option.

The added row turns yellow. A new, blank row will display where you can add the next option.

e. Select the Inactive check box next to an option to inactivate it. Inactive options will not display for selection when the user opens the pull-down.

f. To delete an option, click the red minus sign to the left of the option and in the confirmation message, click OK.

Select Options Query:

Enter a query that defines the options in the pull-down.

The highlighted area provides instructions and an example query.

In order to search on the select options defined by the query, they must also be added in the Select Options section of the screen.

2. In the Defaults section of the window, select a default Value for New Users, if applicable. When defined, the selected value will default into the field when adding a new employee.

Employee Fields

3. Select a State Reporting Fallback Value, if applicable. When defined, the selected value will be included in extracts for state reporting unless the employee has a value already selected in their record.

The Value for New Users and State Reporting Fallback Value pull-downs will be empty until select options are defined.

Signature

For signature fields, select Requires Authentication to require the user to enter a username and password in order to save the signature. When this option is turned off, the user can save the signature without entering a username and password.

Employee Fields
Placeholder

For placeholder fields, you may include a URL if desired. When the user clicks the placeholder title in the employee's record, the URL will open.

Text

1. In the Options section of the window, enter the Maximum Length of the field. The default maximum length is 255 characters. The length cannot be set to 0 or users will not be able to enter any text into the field.

2. To display suggestions when a user enters text into the field, enter a query in the Suggestions Query section of the screen.

The highlighted area provides instructions and an example query.

Long Text

1. In the Options section of the window, select Rich Text to provide a rich text editor for the field.

2. Enter the Maximum Length of the field. The length cannot be set to 0 or users will not be able to enter any text into the field.

Logging Fields

1. In the Options section of the window, select Show school year to add a School Year column to the logging field.

The "Show school year" option is automatically enabled on the Industry Certifications logging field.

2. In the Columns section of the window, replace the New Column text with the column name.

3. In the column that will be the primary sort, select Ascending or Descending in the Primary Sort pull-down.

4. In the column that will be the secondary sort, select Ascending or Descending in the Secondary Sort pull-down.

Log entries can be sorted in ascending or descending order using one column as the primary sort (entries will be sorted by this column first) and one column as the secondary sort (entries will be sorted by this column second). Only one column can be set as the Primary Sort and only one column can be set as the Secondary Sort.

5. Select the Fixed Left check box to freeze the field in place when the user scrolls over to the right.

6. Select the field Type: checkbox, computed, date, file upload, long text, number, select multiple, select one, text, or time.

7. Click the Edit Field icon to set up or edit the field options, including profiles who can view and edit the specific field.

8. To delete a column, click the red X.

9. To add a column, click the green +.

10. To rearrange the order of the columns, click the left and right arrows.

Hover the mouse over the column name to view the log_field ID.

Computed

1. Enter the query for the computed field in the provided area.

The highlighted area provides instructions and an example query.

2. Either define the Search Options or enter a Filtering Options Query.

By supplying the select options or defining a filtering options query, users will be able to search on the computed field the same way other fields are searched on. If these options are not set up, then users will not be able to use More Search Options on the computed field as they can with other select field types.

Search Options:

a. In the blank row, enter a Code and Label (what will display for the user) for the first option.

b. Enter a Sort Order for the option. This will display the options in the defined order.

c. If desired, enter the Min School Year and Max School Year, which are used to make these options only active within the range of school years.

d. Press Enter to add the option.

The added row turns yellow. A new, blank row will display where you can add the next option.

e. Select the Inactive check box next to an option to inactivate it. Inactive options will not display for selection when the user opens the pull-down.

f. To delete an option, click the red minus sign to the left of the option and in the confirmation message, click OK.

Filtering Options Query:

Enter a query that defines the options in the pull-down.

The highlighted area provides instructions and an example query.

Computed Table

Enter a query for the computed table.

The highlighted area provides instructions and an example query.

Editing a Field

1. From the Human Resources menu, click Employee Fields.

Employee Fields

2. Click the Fields tab.

Employee Fields

3. Locate the field in the list and click Edit Field.

Employee Fields

4. Make the desired changes and click Save.

Cursor
Deleting a Field

Only Local fields (fields created by the district) can be deleted. System fields cannot be deleted.

1. From the Human Resources menu, click Employee Fields.

Employee Fields

2. Click the Fields tab.

Employee Fields

3. Locate the field in the list and click the red minus sign to the left of the field.

Employee Fields

4. In the confirmation message, click OK.

The field is deleted.