Site Master Data
HOW TO SET UP YOUR SITE(s)
The Excel file #1- Site Master Data contains the information required to define the default setting of your site/s.
The Excel file #1- Site Master Data contains 3 worksheets to define the sites, holidays and shifts of your resources. See file attached.
Setting up your locations
The Location can be your company, departments, divisions, laboratories to which employees, instruments and tests are to be assigned.
The Location is also used to assign Optima´ users to it. Locations can also be used to filter/group data, but also to restrict permissions for the visualisation of data.
The worksheet request two type of information
Item / column | What / Used for |
Location Code | This code should be unique for each location (max. 20 characters) |
Location Description | This free text facilitates the naming of every single location (max. 20 characters) |
Setting up your Holidays
This worksheet is used to record the list of dates that are public in the company.
The public holidays should be linked to the locations, as the company’s laboratories may be located in different countries with different public holidays.
Item / column | What / Used for |
Location Code | Refer to the one(s) created in previous worksheet |
Holiday Date | Enter the dates of holidays for every specific location |
Holiday Description | This free text facilitates the naming of every single Holiday (max. 20 characters) |
Setting up your Shifts.
This worksheet is used to compile all possible shifts that can be assigned to an instrument or an employee.
A maximum of three slots can be configured in a 24-hour day shift. It is strongly recommended to limit the number of slots to ensure the engine finds sufficient availability for long-duration tasks.
The engine will refer to the employee and instrument shifts to assess their availability throughout the day.
When determining the working hours of each employee, you can assign different shifts to each day of the week.
Item / column | What/ Used for |
Location Code | Refer to the one(s) created in first worksheet |
Shift Description | This free text facilitates the naming of every single shift (max. 20 characters). Should be used as a code to refer to when setting up instruments and employees. |
Instrument / Employee | Use I for instrument, T for employee ( technician) |
Start Time slot 1 | Format should be HH24:MI format |
End Time slot 1 | Format should be HH24:MI format |
Start Time slot 2 | Format should be HH24:MI format |
End Time slot 2 | Format should be HH24:MI format |
Start Time slot 3 | Format should be HH24:MI format |
End Time slot 3 | Format should be HH24:MI format |
Defining Night Shift
Note that the shift needs to be defined within the single day.
For someone starting his/her shift from 22:00 to 06:30 from Monday to Wednesday, you would need to create 3 shifts and applied them in employees configuration as follow.
Monday= shift night A, from 22:00 to 23:59
Tuesday = shift night B, from 00:01 to 06:30 and 22:00 to 23:59
Wednesday = shift night B, from 00:01 to 06:30 and 22:00 to 23:59
Thursday = shift night C, from 00:01 to 06:30
Related Articles
Employees Master Data
HOW TO SET UP YOUR EMPLOYEES The Excel file #4 - Employees Master Data contains the information required to define the employees to be scheduled by Optima. An employee may not be a User of Optima, a User may not be set as employee. The Excel file #4 ...Tests Master Data
HOW TO SET UP YOUR TESTS The Excel file #5 - Tests contains the information required to define all your tests to be scheduled by Optima. The Excel file #5 - Tests contains 6 worksheets to define the Tests Groups, Tests Series, Tests, Test Steps and ...Tests Management Section
HOW TO CREATE AND REVIEW YOUR TESTS This article explains how to configure your Test Groups, Test Series, and Tests from the configuration. During the implementation phase, a complete set of Test Groups and related information is uploaded at once by ...Instruments Master Data
HOW TO SET UP YOUR INSTRUMENTS The Excel file #3 - Instruments Master Data contains the necessary information to categorise and define your instruments. See attached file The Excel file #3 - Instruments Master Data contains 5 worksheets to define ...Introduction to designing your Master Data
HOW TO CONFIGURE YOUR OPTIMA LRMS® There is a range of information that needs to be uploaded into your system so that the different types of tasks can be planned and executed correctly according to the skills of your employees, the technical ...