System


The System menu contains programs that control how processing is defined and done in the system and other options in ESS.

Role: District Manager or Admin role.


App Log

Used by SSDT and ITC to debug issues, but it also stores Auditable Events and logging info that can be useful to ITC / users.  Click image-20240311-175049.png for more details.

image-20240311-175846.png

Batch Job

Displays ESS scheduled or manually run batch job in grid format. Click on image-20240730-213737.png on a specific batch job for further information

Batch job include:

  • syncAbsencesJob: automatically scheduled to run hourly

  • leaveBalancesSyncJob: automatically scheduled to run nightly unless the manual sync has been performed under System>USPS Data Sync

  • positionSyncJob: automatically scheduled to sync weekly unless the manual sync has been performed under System>USPS Data Sync

  • generatePeriodsJob: automatically scheduled to run ??

image-20240730-213127.png

Configuration

Please click here for more information on the system’s Configuration options.


Date Codes

Used with existing Custom Date Codes in USPS’s Core>Date Codes (i.e. FBI check).

Create a Date Code

  1. Once a date code exists in USPS, the user can pull the USPS Date Code into ESS. Next, click ‘Continue’

  2. The Date Code and Description from USPS auto loads. The user can enter the following:

    1. Expiration Terms in Days: Number of days the date code is valid

    2. Days Before Expiration to Notify: Number of days prior to the expiration date that the employee will be notified

    3. Notification Message: Message employee will receive in ESS based on days before it’s set to expire

    4. Active checkbox: uncheck when users needs to disable date code notification.


Kiosk Load

Used to import data extracted from the Legacy Kiosk application.

Do not edit the legacy Kiosk spreadsheets prior to importing into ESS.* Editing them may corrupt the data thus causing the importer not to work.

Please refer to the Employee Self Service Import from Kiosk Guide for detailed information on how to import Kiosk data extracts.

Kiosk Load options include the ability to import:

  • Kiosk District Configuration

  • Kiosk Leave Type Configuration

  • Kiosk Users* - please refer to Employee Self Service Import from Kiosk guide for further information on editing the Kiosk User spreadsheet prior to importing into ESS

  • Kiosk User Time Preferences

  • Kiosk Leave Request Groups

  • Kiosk Leave Request Group Members

  • Kiosk Sub Categories

  • Kiosk Leave Request Workflows

  • Kiosk Leave Request Workflow Group Levels

  • Kiosk URLs

  • Absence Management (AESOP) District

Please follow the steps in the Employee Self Service Import from Kiosk in the order provided. Review any error messages generated from each import as well as the error file generated. Please fix the errors on the generated error file (not the original CSV) and import the updated error file to fix any errors. Repeat until all errors have been resolved.


Mass Load

Used to mass load new information or mass update existing ESS data via a spreadsheet. Once the data is saved in the spreadsheet, the user can then mass load the data via the Mass Load option.

Currently, only User data can be mass loaded into ESS

 

Example of existing ESS User data in a spreadsheet

  • Upload File: Must be in CSV format.

  • Mass Load Option: Currently, only User data is allowed to be mass loaded into ESS.

  • Click Import to load the User data

  • A ‘loader-error.csv' file will be generated displaying any errors and the number of records loaded. Error messages will also be displayed on the screen in the ‘Message’ area.

User Import Criteria:

  • When loading user data, the field names on the spreadsheet must exactly match the Field names listed below.  The field names are not case sensitive.

  • When creating new records, the fields specified below as "Required" must be included in the spreadsheet.  All other fields are optional.  All date formats are accepted (i.e. mm-dd-yyyy, mm/dd/yyyy, mmddyyyy, etc).

  • When updating existing records, use the to extract the desired User data from the User grid. It will generate a CSV formatted file containing the filtered user data as well as automatically includes a ‘user_id' column that contains the existing user record’s UUID.  Leave the 'user_id' column in the spreadsheet and do not edit or remove the data in this column.  This field is needed when loading changes made to existing user record data.

Field

Format

Definition

Field

Format

Definition

USER_ID

Automatically populated when extracting existing ESS User data (via the User grid ‘Export Grid Items’ option)

Required field if updating existing ESS user data.  Otherwise, it is not required for new user imports. **Please see bulleted User Import Criteria above for more information on updating existing ESS User data.**

USERNAME

No maximum number of characters

Required. ESS Username

FIRST_NAME

No maximum number of characters

Required: ESS User’s first name

MIDDLE_NAME

No maximum number of characters

ESS User’s middle name

LAST_NAME

No maximum number of characters

Required. ESS User’s last name

SUFFIX_NAME

No maximum number of characters

ESS User’s Suffix (i.e. Jr, PhD, etc)

EMPLOYEE_NUMBER

If an employee of the district, must use the Employee’s Identification Number from USPS

USPS Employee Identification Number

TITLE

No maximum number of characters

Employee Job Title

EMAIL

must use a valid email format

Required. Recommended to use employee’s Primary Email Address from USPS>Employee record

EXTERNAL_AUTH

true or false

Enter true if user is using External Authentication (Active Directory). Otherwise leave blank and it will default to false.

ENABLED

true or false

Enter true if user account should be disabled.   Otherwise leave blank and it will default to false.

PASSWORD_EXP

accepts ISO_LOCAL_DATE_TIME (yyyy-MM-ddThh:mm:ss) format

EX: 2024-05-01T00:00:00 is May 1st, 2024 at midnight

If entered, date user's password will expire.  The user will be required to change the password after this date.  Does not affect externally authenticated users.

ACCOUNT_EXP

accepts ISO_LOCAL_DATE_TIME (yyyy-MM-ddThh:mm:ss) format

EX: 2024-05-01T00:00:00 is May 1st, 2024 at midnight

If entered, date at which the user account will expire.  After this date, the user will be effectively disabled.  This affects both locally and externally authenticated users.

LOCKED

true or false

Leave blank to default to false for new account creation. Locked accounts are usually temporary situations caused by excessive login failures or other account status problems.  Set the 'enabled' flag to false to disable a user.  

2FA

true or false

Enter true if user is using Two-Factor Authentication.   Otherwise leave blank and it will default to false.

SYNC_TO_AESOP

true or false

Enter true if the user should be synced to AESOP.

ROLES

If multiple roles, separate each ESS role with a hyphen. Role names are case sensitive and must be in UPPERCASE.

NOTE: The USER role does not need to be included in the spreadsheet. The application will add the role by default to the user account.

NOTE: ADMIN role cannot be assigned via mass load.

Please refer to the ‘Roles’ table below for proper format on how role names are to be entered in the ‘Roles’ column

Example below of entering multiple ESS roles for a user.

After import, when viewing the user account in ESS, it will display as follows (automatically added User role by default)

Please reference the available roles table below when entering a role on your user spreadsheet. The role must be in UPPERCASE and match exactly to what is displayed in the ‘Role Name for User Import' column.

Role Name for User Import

Role Name displayed in User account in ESS

Role Name for User Import

Role Name displayed in User account in ESS

ADMIN

Admin

DISTRICT_MANAGER

District Manager

ANNOUNCEMENT

Announcement Board Manager

LEAVE_MANAGER

Leave Manager

LEAVE_APPROVAL_MANAGER

Leave Approval Workflow Manager

LEAVE_CAL_BUILDING

Leave Calendar by Building

LEAVE_CAL_DEPARTMENT

Leave Calendar by Department Code

LEAVE_CAL_DISTRICT_BUILDING

Leave Calendar by District Building

LEAVE_CAL_PAY_GROUP

Leave Calendar by Pay Group

LEAVE_CAL_DISTRICT_STAFF

Leave Calendar for District Staff

LEAVE_REQUEST_APPROVER

Leave Request Approver

LEAVE_SUPERVISOR_STAFF

Leave Supervisor for Staff

DATA_CHANGE_MANAGER

Data Change Manager

SUB_COORDINATOR

Substitute Coordinator

SUB_COORDINATOR_RO

Substitute Coordinator - Read Only

SUB_COORDINATOR_BUILDING

Substitute Coordinator by Building

SUB_COORDINATOR_BUILDING_RO

Substitute Coordinator by Building - Read Only

SUB_COORDINATOR_DEPARTMENT_CODE

Substitute Coordinator by Department Code

SUB_COORDINATOR_PAY_GROUP

Substitute Coordinator by Pay Group

TIMESHEET_APPROVER

Timesheet Approver

TIMESHEET_MANAGER

Timesheet Manager

TIMESHEET_STAFF_SUPERVISOR

Timesheet Supervisor for Staff

WHITELIST_MANAGER

Whitelist Manager

CUSTOM_LINK_MANAGER

Custom Link Manager

METRICS

Metrics API


Organization

The 'Organization' refers to district information such as district address and ID numbers that are unique to a district. Currently, the organization is not included on the Legacy Kiosk load imports. Districts will have to manually add their Organization information into ESS.


Test Connection

Testing the connection between ESS, USPS and Workflows is part of the post-installation procedures from the Employee Self Service Installation Guide.

The Test USPS Connection and Test Workflow Connection buttons are selected to notify the user whether or not ESS is properly connected to the district’s USPS and Workflows applications. If the connection is successful, the user will see "Connection Successful" messages. 


Test Email

May be used to send a test email to an ESS user to ensure email notifications work for their leave request submissions/approvals.

If a user wants to opt out of leave request emails, in their User Profile (located on the Home Screen) they may disable the select to opt out of receiving emails.

Enter the user’s email address in the To: field and click on ‘Send Email’ to send the test email.


USPS Data Sync

This option is available on an as-needed basis if, for some reason, the position or leave balance data from USPS needs refreshed. ESS is set up to always pull the most recent USPS Position and Leave Information upon log in.