Laboratory Data

<< Click to Display Table of Contents >>

Navigation:  Master Data >

Laboratory Data

Test criteria can be assigned to the Master data object for each supplier. Select criteria from a list of criteria and provide method, unit, marginal values, and comments. Furthermore, you can define which parameters are to be accepted in the test specifications for quality testing.

masterdata_labdata_zoom70

1.Supplier: Switch between suppliers defined in the Partner tab.

2.These tabs correspond to groups to which the criteria used for laboratory data belong. Click on one of the tabs to display only those parameters that belong to the corresponding group. Tab All displays all criteria.

3.Click and hold mouse pointer on the i icon to display LA, MIN, TV, MAX and UA values for the other suppliers.
masterdata_labdata_infobutton_zoom70

4.Criteria structure: Each criterion belongs to a specific Area and Group. The criteria structure can be defined via Administration/General/Criteria structure.

5.Criterion: This column contains criteria designation and their numbers in square brackets. Both can be defined via Criteria structure. Criteria that contain comment are highlighted. Red text indicates mandatory criteria. This can be defined for individual criteria in Administration/General/Criteria structureMandatory drop-down list.

6.Description: A criteria description can be specified via Criteria structure.

7.The following information can be specified for each criterion:

CT: The criteria type - comes from Criteria structure in Administration.

AT: The acquisition type - comes from Criteria structure in Administration.

Unit: The unit can be manually assigned to the criteria via Criteria structure in Administration.

LA: Define the lower alarm value which must not be undershot.

MIN: Define the minimum required value per standards.

TV: Define the targeting value of the criterion.

MAX: Define the maximum required value per standards.

UA: Define the upper alarm value which must not be exceeded.

Code list: Select appropriate code list. The list and its items are to be defined under Administration/General/Selection lists selection list group Customer LIMS and has to be assigned to each criterion separately in the criteria structure.

Method: Select/assign the analytical method of the utilized procedures from the method selection list. The items of the selection list are to be defined under Administration/Selection lists.

Finding: Insert laboratory findings via right-click in case of zero partner, or enter the finding directly into the field in case of any supplier.

Comment: Enter a comment. It can be also added via right-click → Enter comment.

Comment 2: Enter a comment. It can be also added via right-click → Enter comment.

CoA: To indicate if a Certificate of Analysis is available.

8.Show criteria selection: When the checkbox is selected, the criteria structure is displayed on the left side of the screen. Then, criteria can be added by double-clicking their name.
masterdata_labdata_showcriteria_zoom70
To specify criteria groups and areas that will be available here, the show in lab data checkbox must be selected for the required groups/areas in Administration/General/Criteria structure.
masterdata_labdata_showlabdata_zoom70

9.Values can be predefined via shortcuts under Administration/General/Shortcut lists.
Masterdata_LabData_Shortcuts
Subsequently the shortcut list needs to be assigned to each of the criteria under Administration/General/Criteria structure in the corresponding field where the shortcut lists are to be selected.
masterdata_labdata_shortcutlist_zoom70

10.Right-clicking in the Laboratory data tab opens a context menu with the following options:
Masterdata_LabData_RMB

minus_sign

Delete line: Deletes the criterion and all the data in the row where the mouse pointer was positioned.

 

Status of finding: Enter laboratory finding. This option is available only for criteria with text selected as the Criteria type in Administration/General/Criteria structure.enterfinding_zoom70

sign_document

Enter comment: Add a comment. This option is available only in columns Comment 1 and Comment 2.

sign_document

Comment criterion: View comments associated with criteria (read-only). Users can comment criteria in Administration/General/Criteria structure → field Comment. Criteria with comments have a different color.

sign_document

Document: Assign a document to the selected cell.

sign_up

Criterion upwards: Move the selected criterion one row up.

sign_down

Criterion downwards: Move the selected criterion one row down.

 

Hierarchical criteria: Laboratory data criteria can also be assigned hierarchically via Administration/Hierarchical criteria → criteria type Master data - laboratory data. These criteria will not be displayed unless the user selects this option.

sign_copysupplier

Copy supplier data: Enables transferring the selected type of Master data from one supplier to another. For instructions on how to use this function, please See Master data/Functions & Processes/Copy Supplier Data.

 

Last edit by: Shows details of the last modification (user name, date and time).

 

Recompute microbiology: Recalculates the microbiological criteria only if there is an inspection plan created for this Master data with the corresponding identical test criteria.

sign_show_hide

Fade column in/out: To show or hide columns. It is also possible to rename columns by double-clicking their name.

11.Quick access toolbar: For more information, see Master data/Functions & Processes/Basic Master data Functions.

12.Select data pool and language: Data export settings. The selected data pool appears next to Filters: on the left side.

Exporting laboratory data to Excel

All data can be exported to Excel. To do so, the user needs to have the Laboratory data tab opened and click the XLS icon located on the right side of the main navigation window.

masterdata_labdata_excel_zoom70

Data of each supplier is placed under a separate worksheet.

masterdata_labdata_excel2_zoom70