Identify Database schema - Ringgold Support

Detailed structure of the Identify Database tables for technical staff. Two types of schema documents are available for download:

Complete data set – the full database
Delta data set – records added or modified during the previous weekly
production cycle only

Latest Version 2.4

Identify Database Schema v2.4

Current Version 2.3

Identify Database External Schema v2.3

Identify Database Delta External Schema v2.3

Older Versions

Identify Database External Schema v2.2

Identify Database Delta External Schema v2.2

Service Updates

14 April 2023 On Thursday, 20 April from 7:00 PM EDT until approximately 8:00 PM EDT, the Ringgold Validate Service user interface will be unavailable due to system maintenance updates. This downtime does not impact the Ringgold Validate Service API or any other Ringgold products or services.

16 January 2023 26 January 7:00 PM EST to approximately 8:00 PM EST Ringgold Validate Service will be unavailable due to system maintenance updates

21 December 2022 Planned maintenance window that may affect users of Ringgold’s Identify Online and Validate Service sites on December 22, 7pm EDT (PDT+3, GMT-5) . The following functionality will be impacted for a few minutes:
* Active user sessions may get disconnected
* Users will be unable to change passwords

24 November 2022 Planned maintenance window by Citrix that may affect users of Ringgold’s ShareFile site on November 29th/30th, 11:00pm EDT (PDT+3, GMT-5) to 11:59am EDT (PDT +3, GMT-5).
The following functionality will be impacted for a total duration not exceeding 30 minutes:
* Active user sessions may get disconnected
* User logins may be temporarily disabled
* Some administrative actions may be temporarily unavailable.
> Citrix ShareFile Updates & Info

27 October 2022 Due to essential maintenance, the following services will be unavailable for up-to one hour on Thursday 3 November 8pm EST (5pm PST):
– Identify Online4 October 2022 Due to essential maintenance, the following services will be unavailable for up-to one hour on Friday 14 October 8pm EST (5pm PST):
– Identify Online
– Validate Service & API endpoint
– Consortium Directory Online
– Protoview
– CDO
– IDO
– ISNI lookup

In addition, Consortium Directory Online will be unavailable for up-to one hour on Friday 7 October 8pm EST (5pm PST)

26 Sept 2022 Due to essential maintenance, the Identify Database API service will be unavailable for one hour on Friday 30 September 9pm EST (6pm PST)

17 Aug 2022 Ringgold’s offices will be closed Friday 19 August. Please email us at support@ringgold.com and we will get back to you Monday 22 August.

7 Feb 2022 New support page added for Ringgold FTPS:
> Troubleshooting for Citrix ShareFile

24 Jan 2022 For Identify Database local load customers, ShareFile migrated from FTP to FTPS. Please check your settings:
> ShareFile FTP Settings & SetUp Configuration
> Migration from FTP to FTPS

24 June 2021 Identify Database REST API updated to versions 2.8 and 2.9. Release notes:
> Identify Database API REST v2.8
> Identify Database API REST v2.9

16 Sept 2020 Republic of Kosovo added to Country List. Support documentation updated:
> Identify Database Countries & Regions

13 May 2020 Consortium Directory Online External Schema upgraded for version 2.4. Updated documentation:
> CDO External Schema v2.4

9 March 2020 Consortium Directory Online web interface was upgraded Friday 6 March. Updated help documentation:
> CDO Support

20 November 2019 Identify Database REST API updated to version 2.7. Release notes:
> Identify Database API REST v2.7

16 August 2019 Identify Database Metadata Elements documentation updated:
> Identify Database Metadata Elements

11 July 2019 New Regions to be implemented in Identify Online on 26 July:
> New Regions in Identify Online

10 June 2019 New Ringgold Places mapping documentation available for Local Load clients:
> Ringgold Places mapping

2 May 2019 Identify Database External Schema upgraded to version 2.3. Ringgold Places now added. Updated documentation:
> Identify Database External Schema v2.3
> Identify Database Delta External Schema v2.3

1 May 2019 Identify Database REST API updated to version 2.6. Release notes:
> Identify Database API REST v2.6

1 May 2019 Identify Database REST API operation and usage instructions for STL1.3 added:
> Identify Database API REST Search Tools

5 Jan 2019 Swaziland now known as Eswatini. Support documentation updated:
> Identify Database Country List

3 Dec 2018 FTP Export & Data Exchange users: ShareFile has implemented new authentication methods which requires a password reset. Reset your ShareFile password here
> https://ringgold.sharefile.com/Authentication/Login#ForgotPassword – we strongly recommend the use of unique and complex passwords.

20 Aug 2018 Validate Service upgraded. Updated user documentation:
> Validate online walkthrough
> Validate user guide download

17 Aug 2018 Validate Service upgrade & outage planned Friday 17th August (US) / Saturday 18th August (Europe). Unavailable from the hours of 1200 PDT/1700 EDT/0200 BST/0300 CEST. The service should resume within 6 hours.

10 July 2018 Identify Database API Services & documentation updated:
> REST & SOAP API Services

30 Apr 2018 Privacy Policy updated:
> Ringgold Privacy Policy

11 Apr 2018 Tiers/Types combinations updated:
> Ringgold Tiers

19 Mar 2018 Identify Database External Schema updated. LB alternate names and URLs retired. Updated documents:
> Ringgold Identify Database External Schema 220
> Ringgold Identify Database Delta External Schema 220

26 Feb 2018 Following the introduction of the Ringgold Types */library, these Alternate Name types have now been retired:
– FN LB Former name of Library
– LB Library name
– LB TR Translation of Library name
Updated documentation:
> Ringgold Identify Database Editorial Policy

30 Nov 2017 It has come to our attention that some messages sent to us via the feedback form in the Identify Online account settings area have not reached Ringgold. This fault has now been fixed. Please resend any messages to us if you have not yet received a response via this channel.

16 Nov 2017 Identify Database Web Service technical spec updated for version 2.5
> Download

20 Jul 2017 Identify Database External Schema updated to include multies definition changes to include all of the hierarchy. Updated documents:
> Ringgold Identify Database External Schema 220

15 Jun 2017 New publisher Ringgold Types added: ‘academic/publisher’, ‘corporate/publisher’, ‘govt/publisher’, ‘other/learnedpublisher’, ‘other/publisher’; New library Ringgold Types added: ‘corporate/library’, ‘health/library’, ‘hospital/library’, ‘school/library’. Updated:
> Ringgold Types list
> Ringgold Identify Database Editorial Policy

4 Apr 2017 Ringgold Types ‘school’ and ‘school/special’ added; ‘academic/school’ and ‘academic/special’ retired. Updated:
> Ringgold Types list

22 Mar 2017 Identify Database Web Service technical spec updated
> Download

14 Mar 2017 Identify Database Delta External Schema added
> Download

13 Feb 2017 Identify Database policy update. The following metadata fields have been retired as they were not being used: Alt Names Type BN (Brand Name); Alt Url Type BS (Brand Site). Updated documents:
> Ringgold Identify Database External Schema 220
> Ringgold Identify Database Editorial Policy