FINBOURNE offers a dedicated Global Legal Entity Identifier Foundation (GLEIF) data provider that allows you to access comprehensive Legal Entity Identifier (LEI) reference data directly within LUSID.
This integration enables you to enrich your data with entity identification and ownership structure information from GLEIF’s global directory.
Prerequisites
Before getting started, ensure you have:
Contacted your FINBOURNE representative to enable the integration in your LUSID domain
Running the integration
You can use Luminesce to build custom queries and bespoke data imports using the Gleif.LegalEntity.MatchFilter data provider, which you can schedule or run on demand.
Example A: Retrieving entity data by LEI
@request = select 'lei' as FilterField, '851WYGNLUQLFZBSYGB56' as FilterValueMatch;
select * from Gleif.LegalEntity.MatchFilter where request = @request;Example B: Finding entities by category
@classification = values
('entity.subCategory','CENTRAL_GOVERNMENT');
@request =
select column1 as FilterField, column2 as FilterValueMatch from @classification;
select * from Gleif.LegalEntity.MatchFilter where request = @request;Example C: Retrieving owner relationships and corporate structures
-- Define entity to retrieve data for
@request = select 'lei' as FilterField, '724500KGJLP14RSC0819' as FilterValueMatch;
@LEIs = select * from Gleif.LegalEntity.MatchFilter where request = @request;
-- Define fields to retrieve data for - in this example, these fields are parent and ultimate parent entities
@linkRequest =
select 'lei' as FilterField,
DirectParentLei as FilterValueMatch
from @LEIs
where DirectParentLei is not null
union
select 'lei' as FilterField,
UltimateParentLei as FilterValueMatch
from @LEIs
where UltimateParentLei is not null;
-- Request the data from GLEIF
@parentLEIs =
select * from Gleif.LegalEntity.MatchFilter where request = @linkRequest;
select * from @LEIs union
select * from @parentLEIs;