Appendix B: Server installation & data folders

Program Files folders on the server

The server program files are located in the 'Program Files\Pegasus' location.

Folder

Purpose

Metadata

Contains the XML definitions of the data tables and fields used in Opera 3 SQL SE. These are only used for implementations of Opera 3 SQL SE that include bespoke solutions.

ModelLive

Contains the live data dictionary definitions currently in use by Opera 3 SQL SE, the Data Upgrade Health Checker and  Company and system database mapping text files.

ModelNext

This is updated by the Opera 3 SQL SE upgrade program to hold the latest data dictionary definitions, Data Upgrade Health Checker and company and system database mapping text files. These files are then copied to the ModelLive folder by the Pegasus Opera Service at an appropriate point.

ReportDefinitions

Contains the default client-side reports that are installed for Opera 3 SQL SE.

Reports in this folder must not be amended manually.

SAM

The Server Administration & Monitoring application is a server-side application for configuring the Opera 3 SQL SE server software, entering licence and activation details, configuring email settings, database monitoring and other database activities.

To open the Server Administration & Monitoring application, use the Windows Start Menu or the desktop shortcut in the 'Pegasus Opera 3 Server SQL SE' folder.

Server Reports

Contains server-side reports for the Server Data Intensive Processes.

Common Files

The Pegasus Shared folder in the Common Files location contains the various Opera 3 SQL SE DLLs. This folder will also be installed on the client PCs.

Folder

Purpose

Controls

Contains the various Opera 3 SQL SE DLLs. This folder will also be installed on the client.

ProgramData folders on the server

The Windows data folders used by Opera 3 SQL SE are located in the ProgramData location.

Folder

Purpose

Backup

Contains a sub-folder per Opera system and is where backups from each system will be created.

Common

This is the common root folder, which is created during the Opera 3 SQL SE system initialisation in the Server Administration & Monitoring (SAM) application. Each system and company will have its own sub-folder below the common root folder; e.g. \Common\Sys_0\Co_A.

Each company’s common folder includes subfolders where files are created:

  • Company BACS files (\BACS)

  • VAT Return & EC VAT related files (\Tax)

  • Other miscellaneous export files, such as exported NL Matrix Reports files (\Export)

  • Payroll files:

    • BACS files (Payroll\BACS)

    • Pensions files (Payroll\Pensions)

    • RTI files (Payroll\RTI)

    • DEO payment schedules (Payroll\XML)

    • External Nominal transfer files (Payroll\Export).

Network share and permissions

A network share must be created for this location to allow the files to be saved here.

The following network permissions must be given for this location:

  • Full Control permissions for the MSSQLSERVER service.

  • For installations including Payroll, read/write permissions to the Payroll\RTI subfolder for Pegasus Online Filing Manager users who submit Full Payment Submission, Employer Payment Summary and NINO Verification Request files to HMRC.  

  • Read permissions for the users who will need to view or retrieve files that have been saved here.

The instructions for this are included in Stage 3: Configuring the server.

Common\Migration

 

The Migration sub-folder will be created by the migration process from Opera 3 VFP/SQL as required. Migration itself will contain further sub-folders, created as required during the migration process.

ReportDefinitions

Used for storing amended system-wide bespoke reports (where default reports are amended but not renamed). These reports are not overwritten by new installations. Each report will need to be checked for compatibility with new releases.

The default reports installed and upgraded when new releases are installed are located in the Opera 3 SQL SE server’s Program Files location.

Repository

For reports and documents created in Opera 3 SQL SE (invoices and so on), and also for reports saved as PDFs/XLS in Opera 3 SQL SE). These are only accessed from the Opera 3 SQL SE client using the Server Reports form in the System Manager.

Opera 3 SQL SE’s ‘store on server’ reports will be stored in \Spool sub-folders within \PDF and \XLS.

Systems administrators can set a different  location for the Repository folder using the Server Administration & Monitoring application.

Company-specific bespoke reports are stored without a company prefix below the Repository location in the relevant folder for the company. For example, for company A in System 0, the folder will be 'Repository\Sys_0\Co_A\ReportDefinitions'.

Temp

Used by server-side processes.