Site Master Data

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.
Info
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. 
Info
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 ...

    • Instruments Master Data

      HOW TO SET UP YOUR INSTRUMENTS There are 2 Excel files in relation to defining your instruments. The Excel file #3 - Instruments Master Data contains the necessary information to categorise and define your instruments. see attached file The Excel ...

    • 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 ...

    • Users Master Data

      HOW TO SET UP YOUR OPTIMA´ USERS The Excel file #2 - USERS MASTER DATA contains the information required to define the categories of your users´ and assign them a full or limited licence. The Excel file #2 - USERS MASTER DATA contains 5 worksheets to ...

    • 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 ...