Reporting Database
Reporting Database Guide
The attached documentation describes the organisation, structure and layout of the Symplectic Elements Reporting Database . Use this document as a da...
How to Install the Reporting Database
Symplectic-hosted instances of Elements : This article is not relevant to customers subscribing to Symplectic hosting services for Elements, as the re...
Customising the reporting database
The Elements Reporting Database provides an institution with direct access to the data managed by Elements. It represents the primary data source used...
How is the Reporting Database kept up to date?
The Reporting Synchroniser background service, when running, continuously keeps the Reporting Database in sync with data changes made in the Element...
Using SQL Server Change Tracking in the Reporting Database
As a hosted client, one of the supported ways you can customise your Reporting Database is to enable SQL Server Change Tracking functionality on a per...
HowTo: Use of the Elements Reporting Database to understand ORCID adoption by your researchers
Symplectic have long been a supporter of ORCID and in 2015 we introduced a means for researchers to authorise/link their Elements user account with OR...
Howto Query the Reporting Database for Resolved author affiliations
This query can be used to extract author and publication data from Elements to associate each Publication Record Person Organisation (PRPO) with each ...
Upcoming changes to journal-related columns in publication tables in v6.4
On occasion, it is necessary to improve the structure of the Reporting Database in such a way that existing SQL queries crafted by clients will requir...
Upcoming changes to the [Group].[Type] column in v6.11
On occasion, it is necessary to improve the structure of the Reporting Database in such a way that existing SQL queries crafted by clients may require...
Technical upgrade guide: Elements v6.4 Reporting Database changes
With the release of Elements v6.4, as a part of improving the performance of Elements, the way related journal information is represented for publicat...
Howto: Query for Field of Research (2018) FOR labels
If you're working with FoR labels in the Reporting Database, the following will make sure that only labels from the FoR vocabulary are returned, and g...
HowTo: Query the Reporting Database for Name Based Search Settings
This query will allow you to extract the Name Based Search Settings for all your users, current and non current. This can be useful to determine what ...
HowTo: Find manual only records including verified status
Q.1 How do I find every manual record in Elements, that has no other datasources? ;WITH ManualRecords AS ( SELECT [Publication ID], ID AS 'Manual Rec...
HowTo: Extract publication-grant linkages from ‘funding-acknowledgements’
The Elements Reporting Database is a ‘relational database‘. Relational databases organise information into different tables that are related to one ...