Retrieving daily release times for Horizon: DataScope Select data

The Refinitiv.DataScopeSelect.FileCode provider enables you to write a Luminesce SQL query that retrieves file release times and other information on the Horizon: DataScope Select data that can be retrieved. You can use this information to help you schedule Horizon: DataScope Select jobs to load the data you need at an appropriate time each day.  

Note: The LUSID user running the query must have sufficient access control permissions to both use the provider and read DataScope Select data in LUSID. This should automatically be the case if you are the domain owner.

Basic usage

select * from Refinitiv.DataScopeSelect.FileCode where <filter-expression>;

Data fields

By default, Refinitiv.DataScopeSelect.FileCode returns a table of data populated with particular fields (columns). You can return a subset of these fields.

To list fields available to return, their data types, whether fields are considered 'main', and an explanation for each, run the following query using a suitable tool:

select FieldName, DataType, IsMain, IsPrimaryKey, SampleValues, Description from Sys.Field where TableName = 'Refinitiv.DataScopeSelect.FileCode' and FieldType = 'Column';

Note: Fields marked 'main' are returned by queries that start select ^ from Refinitiv.DataScopeSelect.FileCode...

Examples

Note: For more example Luminesce SQL queries, visit our Github repo.

Example 1: Retrieving all file names and release times for a particular exchange

select * from Refinitiv.DataScopeSelect.FileCode where ExchangeCode = ‘LSE’

This query returns a table of data which you can examine for import information on each exchange, such as FirstFileReleaseTimeGmt and SecondFileReleaseTimeGmt. You can use these values to configure each regional daily schedule to run at an appropriate time. Read more on configuring the EOD pricing job.

Example 2: Retrieving all file names and release times for a particular region

select * from Refinitiv.DataScopeSelect.FileCode where Region = ‘EMEA’

Example 3: Retrieving all file names and release times for a particular asset type

select * from Refinitiv.DataScopeSelect.FileCode where AssetType = 'EQUITY'