Database schemas

This page under review : Schema requires relocation

If you wish to arrange for access to these, please lodge a request via our Service Desk Portal including some details surrounding yourself and the reason for requesting access, and we will process your request further.

Common Database Views

The Synergetic development team have developed views from the Synergetic database tables to make querying the Synergetic database an easier process.

The views contain links between several base tables, that include related information that can be used in similar queries. The information can be from single fields or generated fields.

Main Synergetic database. See Main Synergetic views.

Finance database. See Main Finance views.