Retrieving daily release times for DataScope Select integration data

  • Updated on Oct 23, 2024
  • Published on Aug 20, 2024

The Refinitiv.DataScopeSelect.FileCode provider enables you to write a Luminesce SQL query that retrieves file release times and other information on the DataScope Select integration data that can be retrieved. You can use this information to help you schedule 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.

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

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';
SQL

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

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

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

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.

select * from Refinitiv.DataScopeSelect.FileCode where Region = ‘EMEA’
SQL
select * from Refinitiv.DataScopeSelect.FileCode where AssetType = 'EQUITY'
SQL