SQL JOINs

General information

• Main menu
• Dashboard
• Backup / Data protection
• Version number of the LDB
• Supported browsers
• Activation of SSO
• Print labels
• Automatic LDB validations
• Create/Edit/Delete Categories
• Status management
• SMTP Configuration
• Konfiguration SMTP via OAuth 2.0
• IT requirements for the use of the Labordatenbank
• Add Dashboard Widgets
• Deleted Records
• Tag management

Supplier evaluation

• Evaluation criteria for suppliers
• Add/Edit Evaluation Criteria for Suppliers
• Evaluate supplier assessment
• Add/Edit/Delete Supplier Evaluation
• Delete supplier evaluation

Material

• Manage materials
• Create/edit/delete material
• Linking materials with parameters
• Reorder Materials Online
• Management of chemicals
• Manage/Create/Edit/Delete Batches
• Use batch samples

Employees

• Manage employees
• Add/edit/archive employee
• Manage employee groups
• Edit employee group
• Create task
• Audit Trail: traceable documentation of all work
• Access rights
• Edit Accessright
• Time tracking - Create hours entry
• Time tracking - Hours per day
• Time tracking - Hours per week
• Time tracking - Annual overview
• Time tracking - Vacation days
• Time tracking - Manage Weekly Hours
• Labordatenbank Login / Logout
• Change password
• activate Multi-Factor-Authentification (MFA) with TOTP
• activate a Security Key for the MFA
• Activation of Passkey
• Install TOTP App
• Import employees (introduction phase)

Customers

• Manage customers
• Customer Detail View
• Create/edit/delete customer
• Merging duplicate customers
• Add / Edit / Delete contact persons at customers
• Outgoing Massages
• Detail view of an email
• E-mail templates for reports and invoices
• Forward emails to the LDB
• Import customers ( introduction phase)

Orders

• Manage orders
• Order Detail View
• Create/edit/delete Order
• Scanning and sending documents to the LDB with QR
• Order schedule

Samples

• Manage samples
• Add/Edit/Delete samples
• Enter values
• Results table
• Charts and Statistical Key Figures
• Manage Filters
• Edit - Search Filters and Column Filters
• Map pooled samples in LIMS
• Manage Stations
• Create / edit / delete station
• Book samples into a station

PDF templates

• Manage PDF Templates
• Create/edit PDF templates
• Create design elements
• Design elements Setting options
• Integrate report tables into PDF template
• Design element for the reason for reissuing test reports
• PDF template for sample labels

Assets

• Manage assets
• Add/edit/archive asset
• Add subassets to asset
• Add Planned Order and Sample
• Add tests to order templates
• Copy assets, order templates, and asset components
• Equipment GPS location
• Add on-site inspection

Recipes

• Manage recipes
• Create/edit recipe
• Recipe detail view and ingredients
• Quality assurance for recipes: testing, evaluating, documenting

Reports

• Manage reports
• Create/Edit/Archive report
• Request signature
• Sign reports
• Reissue of signed reports
• Send reports by e-mail or post
• Protect emails from spam filters
• Verify authenticity of reports and certificates
• Certificate
• Manage signatures
• Create / edit / delete a signature

Report table editor

• Create/edit/delete a report table
• Create / Edit reporttable column
• Creating a parameter table with target values
• Create sample table
• Create table with open structure
• Order of the report tables
• Fonts and character set for PDF reports
• Create checklist with report table editor
• Measurement repetitions value selection

Interfaces

• Import Interfaces Overview
• AI Extension for Import Interfaces
• Edit Attributes in Import Mapping
• Import results from measuring instruments
• Create CSV measurement data import interface
• Import measurement data
• Import of samples
• Mode for measured value import
• Automatic FTP/SFTP Import
• Test SFTP/FTP Connection
• Testing the HTTPS Import Interface
• Transformation code for importing other data formats
• Practical example: Import GC/MS measurement values to your LIMS system
• Practical example: Import Biomerieux Vitek antibiogram into LIMS
• Connect Thermo Fisher Chromeleon to LIMS
• Connect PCR to LIMS with plate assignment
• LIMS connection to DEMIS reporting for pathogen detection
• Tips for import interfaces
• Imort pictures in parameters
• Connection of Essentim data loggers
• SHAPTH - Drinking water database report transmission

AI functions

• Enable/disable AI integration
• AI Explorer
• Query Explorer
• AI Import: Automatically assign external calibration certificates
• Enable and Use Audit Assistant
• Connect your AI system to the LDB

Introductory phase

• Labordatenbank introduction checklist
• Labordatenbank data structure
• Implementing the QM-Database
• Import parameters (Introduction phase)
• Import sample master data (Introduction phase)
• Benefits of the LDB Cloud
• Configurable attribute fields in the LDB
• Transfer files securely to the LDB

Query reports

• Create query reports using a template
• SQL Basic Course
• SQL JOINs
• SQL Basics
• Create / Edit query reports
• Parameter columns
• Variables in query reports
• Export data from query reports
• Link Evaluations
• Query report tables (SQL table and SQL bar chart)
• Save and Display MySQL Backup Locally
• Link evaluations with import interface

Templates

• Create order templates
• Manage templates for samples
• Create/Edit/Add Sample template
• Templates for orders, customers, materials, and other data types

Client zone (optional)

• Activating the Customer Zone
• Create Online Analysis Order
• Sampling with online analysis order
• Hide parameter columns in customer portal
• Provide files in the customer zone

Offers

• Create offer
• Add prices and price items
• Appendix with Terms and Conditions and Service Catalog
• Send Offer

Invoices

• Create Invoice
• Sending Invoices
• The English translation for "Teilzahlungen bei einer Rechnung erfassen
• Manage price list
• Exporting invoices
• Import billing items (Introduction phase)
• Create revenue centers for prices
• Activate X-invoice / E-invoice for Germany
• Create Collective Invoices
• Cancel invoice
• QR code for online banking on invoices
• Suggest billing items

Parameters

• Manage Parameters
• Parameter Detail View
• Add/Edit/Delete Parameter
• Create/edit/delete parameter group
• Daily Parameter List: What has to be done in the laboratory
• Parameter usage statistics
• Labeling of subcontracting and accreditation
• Parameter data types
• portray proficiency tests
• Manage examination packages
• Create/Edit examination packages

Calculating with parameters

• Deposit formulas with parameters
• Calculating with number sequences
• Calculation of dry matter and annealing loss
• Calculating with Date/Time Information
• Example: Weighing in and weighing out
• Example: Calculation of annealing loss with validity check
• Example: Determination of Chemical Oxygen Demand
• Example: Determination of TVC - aerobic mesophilic total viable count
• Bsp.: Drinkingwater-Legionella since March 2023 (German Regulation)

Webservices

• LDB Webservices
• Provide data as web services for external systems
• Send data to an external web service
• Send data to the Labordatenbank
• Example: Send eTermin to the LDB
• Example: JSON file for creating samples

Transformationscode

• General structure of a transformation code
• Transformation code for evaluations
• Export transformation code
• Webservice Response Handler
• Import transformation code

Test plans / limit values / specifications

• Create test plan / limit value table / specification
• Add specification limits / reference ranges
• Measurement value evaluation based on reference range values
• Detect and filter reference range deviations
• Parameter-specific text modules according to limit tables

Documents control

• Create a New Document
• Create new version
• Validate document
• Release Document
• Request read confirmation
• Import documents (Introduction phase)
• Change the document creator afterwards
• Delete documents

Questions and answers

• IT requirements
• Where can I find the current version number of the _LABORDATENBANK__?
• How can I calculate the average from five measured values?
• How can I change the order of parameters in the packages?
• Querious: Delete archived reports
• Download files in the Edge browser instead of opening them directly
• Transfer the status of the production system to the test system

Equipment

• Test Equipment Management
• Test equipment detailed view
• Add/edit/delete Test Equipment
• Import test equipment (introduction phase)
• Create control charts
• Import control values from test equipment
• Print labels for test equipment
• Forward emails to test equipment
• Booking Test Equipment
• Test Equipment Calendar

Trainings

• TrainingSchedule: Document Training Sessions, Demonstrate Competencies
• Add/edit/delete training
• Import Trainings (Introduction phase)

8D-report

• Create 8D Report: Generate Quality Deviation Reports

Others

• Barcode / QR-Code Scanner
• On-Site Sampling with Input Form (Online and Offline)

File management

• Add Files (to Samples, Customers, Orders)
• Add Files (Test Equipment, Material, Batches, Specifications)
• File Management
• Search data

Processes

• Process management