These table views enable access to retrospective snapshots of the Full release data. The most recent version of every component in the table with an effectiveTime less than or equal to the snapshot date

When the database is imported the snapshot dates are set as follows:

• snap1 views are set as a snapshot date 6 months before the current release
• snap2 views are set as a snapshot date 12 months before the current release

These snapshot times can be changed by calling the stored procedure setSnapshotTime(viewNumber, dateTime).

For example, to set the snap1 date to 31 January 2017

• CALL setSnapshotTime( 1,"20170131");

and to set the snap2 date to 1 May 2016

• CALL setSnapshotTime( 2, "20160501");

When the database is imported the delta date ranges are set as follows:

• delta views are set with a start date 6 months before the current release and an end date matching the current release date (this matches the current Delta release file content).
• delta1 views start 12 months before the current release with an end date 6 months before the current release date.
• delta2 views start 18 months before the current release with an end date 12 months before the current release date.

Delta date ranges can be changed by calling the stored procedure setDeltaRange(viewNumber, startDateTime, endDateTime).

For example, to set the delta view range to start on 31 July 2018 and end a year later

• CALL setDeltaRange(0,"20180731","20190731");

The delta1 and delta2 ranges can also be set in the same way

• CALL setDeltaRange(1,"20170731","20190731");
• CALL setDeltaRange(2,"20020131","20070731");

Searches for acceptable synonyms of active concepts using a MySQL fulltext boolean search for the specified word or words. Word prefixed by "+" must be present, words prefixed by "-" but be absent and words with neither prefix will also be searched for but their absence from a term will not prevent a match.

The filter can be used as follows to filter the search:

• Left blank: no filtering
• < conceptId : only terms of concepts that are subtypes of the concept identifed by conceptid will be included in the search results.
• < shortcutTerm : only terms of concepts that are subtypes of the concept identified by looking up the shortcutTerm in the config_shortcuts table will be included in the search results
• regular-expression : only terms that match the regular expression will be included in the search results
• !regular-expression : only terms that do NOT match the regular expression will be included in the search results

Examples:

CALL snap_SearchPlus('fundus stomach', '');
CALL snap_SearchPlus('+fundus +stomach','');
CALL snap_SearchPlus('+lung +disease -chronic','');

CALL snap_SearchPlus('appendix','<proc');
CALL snap_SearchPlus('hemoglobin','<lab');
CALL snap_SearchPlus('infection','<19829001');

CALL snap_SearchPlus('+fundus', 'ch');
CALL snap_SearchPlus('fundus','!(eye|oculi|uter)');
CALL snap_SearchPlus('+lung +disease +chronic','oe?dema');

Shows the terms associated with a specified conceptId in two languages specified by the language codes.

Example:

CALL `snap_ShowLanguages`(80146002, 'en-GB','en-US');

Allows a fairly simple ECL expression to be processed. Maximum of one focus concept constraint optionally refined by up to two attribute value constraints.

Example:

CALL `eclSimple`('<404684003:363698007=<<39057004,116676008=<<415582006');

Sets the language reference set that determines the terms to be displayed by composite views with names ending _fsn, _pref, _syn, _synall, term. The language and dialect code is used to specify the language (e.g. en-US, en-GB).

If other values are supported by the SNOMED Edition, these will need to be added to the config_languages to provide the refsetId lookup from the language code.

Example:

CALL `setLanguage`(0, "en-GB")

Sets the date range for a specified delta view (viewNumber 0=delta, 1=delta1, 2=delta2)

Examples:

CALL setDeltaRange(0,"20180731","20190731");

CALL setDeltaRange(2,"20020131","20070731");

Sets the date on which a specified snapshot view is based (viewNumber 1=snap1, 2=snap2)

Example:

CALL setSnapshotTime( 1,"20170131");

CALL setSnapshotTime( 2,"20120131");