Home
Administration
Details on system administration tasks such as setup and maintenance of databases and add-ons, user accounts, access rights, and migration and update procedures.
Databases
Current regulations, such as 21 CFR 11.10 in the pharmaceutical industry, require you to ensure that only authorized individuals can access your systems, perform operations, and sign records. The database-driven approach of PLA 3.0 enables you to take major steps toward meeting these requirements.
Database administration
Use the database administration features to set up, monitor, and maintain your PLA 3.0 database system.
Database monitoring
Monitor user sessions and document locks. Maintain a permanent record of all relevant events related to user access, changes in work environments, and changes to data for each individual PLA 3.0 database and document.
Audit trail
Audit trails provide secure electronic records that you can use to track who changed what, when, and why. Use the audit trail of PLA 3.0 to track and communicate events related to actions such as user access, changes in work environments, and changes to data and documents.
Actions and keys
You can identify each action recorded in the audit trail by a key.
Database maintenance
The following table lists the actions recorded in audit trails for user maintenance and the keys used to represent them.

Get started
Get an overview of PLA 3.0, the end-to-end bioassay analysis software. Learn about its ongoing improvements and version updates, and discover the available trial options.
Key concepts
Learn how the key concepts of PLA 3.0 form the structural foundation for your daily work, supporting method development from initial design to routine production.
Data analysis
Data analysis add-ons offer a wide range of capabilities, ranging from analytical methods over comprehensive analysis to assay workflows and statistical process control.
Data import
Use data acquisition and data import add-ons to import external response values and observation data into PLA 3.0 for further processing and evaluation.
User interface
PLA 3.0 supports you in your daily work by providing a set of graphical and textual user interface elements. Learn about the different elements and how to use them efficiently.
Installation and update
Details on deployment, installation, and update of PLA 3.0, and its initial and advanced setup.
Licensing
Details on the licensing solution of PLA 3.0, the available licensing options, and the activation and management of licenses.
Administration
Details on system administration tasks such as setup and maintenance of databases and add-ons, user accounts, access rights, and migration and update procedures.
- Databases
  Current regulations, such as 21 CFR 11.10 in the pharmaceutical industry, require you to ensure that only authorized individuals can access your systems, perform operations, and sign records. The database-driven approach of PLA 3.0 enables you to take major steps toward meeting these requirements.
  - Database types
    PLA 3.0 supports Microsoft SQL Server and SQLite databases.
  - Database creation
    PLA 3.0 supports local databases, databases shared on a local network, and databases used in a client-server scenario, thus allowing you to create databases for single users and multiple users in a shared environment.
  - Database connections
    You can connect PLA 3.0 to multiple databases. Since most settings in PLA 3.0 apply to individual databases, you can differentiate, for example, between production and test databases, catering to tasks that require different work environments.
  - Database templates
    To enable you to create new databases more efficiently, PLA 3.0 provides a database template feature. This feature allows you to use existing SQLite databases as templates for the creation of new databases.
  - Database administration
    Use the database administration features to set up, monitor, and maintain your PLA 3.0 database system.
    - Database settings
      Establish consistent policies for a range of features, such as passwords, signatures, and traceability, that control and document user access to individual databases.
    - Database monitoring
      Monitor user sessions and document locks. Maintain a permanent record of all relevant events related to user access, changes in work environments, and changes to data for each individual PLA 3.0 database and document.
      - Session management
        View and manage the sessions of all users who are currently connected to the database.
      - Audit trail
        Audit trails provide secure electronic records that you can use to track who changed what, when, and why. Use the audit trail of PLA 3.0 to track and communicate events related to actions such as user access, changes in work environments, and changes to data and documents.
        Event list
        The upper table of the Audit trail tab lists all recorded actions.
        Action details
        The lower table of the Audit trail tab displays all affected elements and their values.
        Actions and keys
        You can identify each action recorded in the audit trail by a key.
        Schemas
        The following table lists the events recorded in audit trails for schemas and the keys used to represent them.
        Information packages
        The following table lists the events recorded in audit trails for information packages and the keys used to represent them.
        Add-ons, components, OQ packages, and OSGI bundles
        The following table lists the events recorded in audit trails for add-ons, components, QQ packages, and OSGI bundles, and the keys used to represent them.
        IQ, OQ, PQ
        The following table lists the actions recorded in audit trails for IQ, OQ, and PQ and the keys used to represent them.
        Users and sessions
        The following table lists the actions recorded in audit trails for users and sessions and the keys used to represent them.
        User groups
        The following table lists the actions recorded in audit trails for user groups and the keys used to represent them.
        User roles
        The following table lists the actions recorded in audit trails for user roles and the keys used to represent them.
        Folder properties, folder restrictions, and security contexts
        The following table lists the actions recorded in audit trails for folder properties, folder restrictions, and security contexts and the keys used to represent them.
        Database policies and database properties
        The following table lists the actions recorded in audit trails for database policies and database properties and the keys used to represent them.
        Database locks and system locks
        The following table lists the actions recorded in audit trails for database locks and system locks and the keys used to represent them.
        Database maintenance
        The following table lists the actions recorded in audit trails for user maintenance and the keys used to represent them.
        Object, data, and document
        The following table lists the actions recorded in audit trails for object, data, and document and the keys used to represent them.
        Attachments
        The following table lists the actions recorded in audit trails for attachments and the keys used to represent them.
        Filter audit trail entries
        Apply filters to view only a subset of the available audit trail entries, for example, entries created on a specific date or by a specific user.
        Export audit trail entries
        Export audit trail entries to make them available in a log file, for example, if you want to print them out.
    - Database maintenance
      Use the database maintenance to update the database tables, which contain data for each document.
- Add-on management
  The add-on management feature of PLA 3.0 provides a central interface to activate, deactivate, or remove add-ons. You can request trials or quotes, and view release dates and dependencies, ensuring consistent and version‑controlled functionality across your PLA 3.0 database.
- Rights and permissions
  PLA 3.0 provides the features you need to control access to your data in a sophisticated and compliant manner. It combines role-based user rights with resource-based permissions, which enables you to exercise fine-grained control over who can perform particular tasks in a given context and which tasks are allowed with particular data.
- Backup and restore
  To keep the integrity of your PLA 3.0 environment and prevent data loss, we recommend regularly backing up your data. Find details on the key areas to consider and practical guidance on backup and restore procedures within your PLA 3.0 environment.
Regulatory compliance
PLA 3.0 supports you in achieving compliance with regulations such as ISPE GAMP^® 5 and 21 CFR Part 11. It also provides options to validate PLA 3.0 in your environment.
PDF downloads
Download PDF guides of current and previous framework and add-on versions.
Sample lab
Meet the team at Stegmann Labs, where PLA 3.0 plays an essential role in every step of bioassay management.
Glossary
Find definitions of terms.

Database maintenance

The following table lists the actions recorded in audit trails for user maintenance and the keys used to represent them.


Action	Description
DB_MAINTENANCE_START	A new database maintenance was started.
DB_MAINTENANCE_COMPLETE	Database maintenance was completed.
DB_MAINTENANCE_INCOMPLETE	Database maintenance remained incomplete because it was canceled by a user or because locked documents were skipped.
DB_MAINTENANCE_CONTINUE	Incomplete database maintenance was resumed.
DB_MAINTENANCE_REGISTRYUPDATED	Database maintenance caused the list of document properties to be reinitialized.