GLEIF Enrichment Source

You can enrich your company data with referential attributes from GLEIF.

đź‘‹

Looking to use GLEIF Enrichment?

Contact Tamr at [email protected] to inquire about licensing options.

GLEIF Attributes

When you select GLEIF as the enrichment source in the Tamr Enrich step, the following attributes are returned for mastered entities that have been successfully matched to a Tamr Enrich ID.

Attribute Name Definition
tamr_gleif_enrich_status The status of the GLEIF enrichment:
  • MATCH_NAME_ADDRESS: The enrichment attributes provided by GLEIF were matched to this company based on the company name and full address.
  • MATCH_NAME_COUNTRY: The enrichment attributes provided by GLEIF were matched to this company based on the company name and country.
  • MATCH_PHONE: The enrichment attributes provided by GLEIF were matched to this company based on the cleaned phone number.
  • MATCH_WEBSITE: The enrichment attributes provided by GLEIF were matched to this company based on the cleaned website.
  • NOT_AVAILABLE_IN_SELECTED_SOURCE:GLEIF does not have information associated with this company’s Tamr Enrich ID.
  • UNRECOGNIZED_TAMR_ENRICH ID: Tamr Enrich does not recognize the ID.
  • NO_MATCH_INVALID_NAME: A match was not found due to an invalid company name. Either the company name was empty, or the name contained only special characters or generic legal form information (for example CORP or LLC).
  • NO_MATCH_INVALID_COUNTRY: A match was not found due to an invalid (empty) country.
  • NO_MATCH: A match was not found.


Note: This value may not match the Tamr Enrich ID tamr_firmographic_match_status. This happens when a higher level match is available in one of the other supported data providers. For example, a match based on “MATCH_NAME_ADDRESS” was found in BoldData, and a match based on “MATCH_NAME_COUNTRY” was found in GLEIF (the selected provider). In this case, the value of the Tamr Enrich ID tamr_firmographic_match_status is "MATCH_NAME_ADDRESS" while the value of tamr_gleif_enrich_status is "MATCH_NAME_COUNTRY".
gleif_lei The 20-character Legal Entity Identifier (LEI) of the Legal Entity.
gleif_organization_name The legal name of the entity. If an entity is in a jurisdiction with more than one Legal Name (e.g., in different languages), this is the Primary Legal Name.
gleif_organization_name_alternate_1 First name other than the Primary Legal Name for the entity.
gleif_organization_name_alternate_2 Second name other than the Primary Legal Name for the entity.
gleif_organization_name_alternate_3 Third name other than the Primary Legal Name for the entity.
gleif_organization_name_alternate_4 Fourth name other than the Primary Legal Name for the entity.
gleif_organization_name_alternate_5 Fifth name other than the Primary Legal Name for the entity.
gleif_first_address_line The first address line element.
gleif_address_number Additional structured version of an external house number, or range of numbers, contained in one of the address line elements. This could be a numeral, a letter or code made up of mixed characters (e.g. 221B).
gleif_address_number_within_building Additional structured version of an internal location number, or range of numbers, contained in one of the address line elements.This could be a numeral, a letter or code made up of mixed characters (e.g. 13) of a floor, suite or apartment within a building identified e.g. by an element.
gleif_mail_routing Free text address line to hold content from other address lines containing explicit routing information. This element's presence indicates that this address is a routing / "care of" address.
gleif_address_line_1 First additional address line element.
gleif_address_line_2 Second additional address line element.
gleif_address_line_3 Third additional address line element.
gleif_city Name of the city.
gleif_region The 4- to 6-character ISO 3166-2 region code of the region.
gleif_country The 2-character ISO 3166-1 country code of the country.
gleif_postal_code The postal code of this address as specified by the local postal service.
gleif_headquarters_first_address_line The first address line element of the headquarters.
gleif_headquarters_address_number Additional structured version of an external house number, or range of numbers, contained in one of the address line elements of the headquarters. This could be a numeral, a letter or code made up of mixed characters (e.g. 221B).
gleif_headquarters_address_number_within_building Additional structured version of an internal location number, or range of numbers, contained in one of the address line elements.This could be a numeral, a letter or code made up of mixed characters (e.g. 13) of a floor, suite or apartment within a building identified e.g. by an element.
gleif_headquarters_mail_routing Free text address line to hold content from other address lines containing explicit routing information (this element's presence indicates that this headquarter address is a routing / "care of" address.
gleif_headquarters_address_line_1 First additional address line element of the headquarter.
gleif_headquarters_address_line_2 Second additional address line element of the headquarter.
gleif_headquarters_address_line_3 Third additional address line element of the headquarter.
gleif_headquarters_city Name of the city of the headquarter.
gleif_headquarters_region The (optional) 4- to 6-character ISO 3166-2 region code of the region.
gleif_headquarters_country The 2-character ISO 3166-1 country code of the country.
gleif_headquarters_postal_code The (optional) postal code of this headquarter address as specified by the local postal service.
gleif_registration_authority_id Reference code of the registration authority, taken from the Registration Authorities Code List maintained by GLEIF.
gleif_other_registration_authority_id A legacy / historical reference code of a registration authority which is not yet entered in the Registration Authorities Code List (RA list) maintained by GLEIF, or the designation of an interim register until such time as an entry from RA list can be delivered.
gleif_registration_authority_entity_id The identifier of the entity at the indicated registration authority.
gleif_jurisdiction The jurisdiction of legal formation of the legal entity; i.e. where the Legal Form of the legal entity originates.
gleif_category Indicates (where applicable) the category of legal entity identified by this LEI data record, as a more specific category within the broad definition given in ISO 17442. These categories are based on use cases specified in ROC policies, found here.
gleif_sub_category Indicates and specifies further (where applicable) the sub-category (sub-sector) of Legal Entity identified by this LEI Record and already categorized by the category field.
gleif_legal_form_code The code corresponding to the legal form of the entity, taken from the ISO Entity Legal Form (ELF) code list maintained by GLEIF.
gleif_other_legal_form A legacy code or textual description for the legal entity's legal form, used until a current code from the GLEIF-maintained list can be used.
gleif_entity_status The operational and/or legal registration status of the legal entity (may be ACTIVE, INACTIVE, or NULL).
gleif_successor_lei_1 The LEI of the first successor entity.
gleif_successor_organization_name_1 The name of the first successor entity.
gleif_successor_lei_2 The LEI of the second successor entity.
gleif_successor_organization_name_2 The name of the second successor entity.
gleif_successor_lei_3 The LEI of the third successor entity.
gleif_successor_organization_name_3 The name of the third successor entity.
gleif_successor_lei_4 The LEI of the fourth successor entity.
gleif_successor_organization_name_4 The name of the fourth successor entity.
gleif_successor_lei_5 The LEI of the fifth successor entity.
gleif_successor_organization_name_5 The name of the fifth successor entity.
gleif_initial_registration_date The date of the first LEI assignment, being the date of publication of the identifier and its supporting data record as represented in ISO 8601.
gleif_registration_last_update_date Date/time the LEI record was most recently updated.
gleif_registration_status The status of the legal entity's LEI registration with the Managing LOU.
gleif_validation_sources The level of validation of the reference data provided by the registrant.
gleif_validation_authority_id The reference code of the registration authority, taken from the Registration Authorities Code List (RA list) maintained by GLEIF.
gleif_other_validation_authority_id A legacy / historical reference code of a registration authority which is not yet entered in the Registration Authorities Code List (RA list) maintained by GLEIF, or the designation of an interim register until such time as an entry from RA list can be delivered.
gleif_validation_authority_entity_id The identifier of the entity at the indicated registration authority.
gleif_parent_lei The 20-character Legal Entity Identifier (LEI) of the parent Legal Entity.
gleif_parent_organization_name The legal name of the parent entity. If an entity is in a jurisdiction with more than one Legal Name (e.g., in different languages), this is the Primary Legal Name.
gleif_parent_organization_name_alternate_1 First name other than the Primary Legal Name for the parent entity.
gleif_parent_organization_name_alternate_2 Second name other than the Primary Legal Name for the parent entity.
gleif_parent_organization_name_alternate_3 Third name other than the Primary Legal Name for the parent entity.
gleif_parent_organization_name_alternate_4 Fourth name other than the Primary Legal Name for the parent entity.
gleif_parent_organization_name_alternate_5 Fifth name other than the Primary Legal Name for the parent entity.
gleif_parent_first_address_line The first parent address line element.
gleif_parent_address_number Additional structured version of an external house number, or range of numbers, contained in one of the parent address line elements. This could be a numeral, a letter or code made up of mixed characters (e.g. 221B).
gleif_parent_address_number_within_building Additional structured version of an internal location number, or range of numbers, contained in one of the parent address line elements.This could be a numeral, a letter or code made up of mixed characters (e.g. 13) of a floor, suite or apartment within a building identified e.g. by an element.
gleif_parent_mail_routing Free text address line to hold content from other parent address lines containing explicit routing information. This element's presence indicates that this address is a routing / "care of" address.
gleif_parent_address_line_1 First additional parent address line element.
gleif_parent_address_line_2 Second additional parent address line element.
gleif_parent_address_line_3 Third additional parent address line element.
gleif_parent_city Name of the parent city.
gleif_parent_region The 4- to 6-character ISO 3166-2 region code of the parent region.
gleif_parent_country The 2-character ISO 3166-1 country code of the parent country.
gleif_parent_postal_code The postal code of the parent address as specified by the parent local postal service.
gleif_parent_headquarters_first_address_line The first address line element of the parent headquarters.
gleif_parent_headquarters_address_number Additional structured version of an external house number, or range of numbers, contained in one of the parent headquarters address line elements. This could be a numeral, a letter or code made up of mixed characters (e.g. 221B).
gleif_parent_headquarters_address_number_within_building Additional structured version of an internal location number, or range of numbers, contained in one of the parent headquarters address line elements.This could be a numeral, a letter or code made up of mixed characters (e.g. 13) of a floor, suite or apartment within a building identified e.g. by an element.
gleif_parent_headquarters_mail_routing Free text address line to hold content from other parent headquarters address lines containing explicit routing information (this element's presence indicates that this headquarter address is a routing / "care of" address.
gleif_parent_headquarters_address_line_1 First additional address line element of the parent headquarters.
gleif_parent_headquarters_address_line_2 Second additional address line element of the parent headquarters.
gleif_parent_headquarters_address_line_3 Third additional address line element of the parent headquarters.
gleif_parent_headquarters_city Name of the city of the parent headquarters.
gleif_parent_headquarters_region The (optional) 4- to 6-character ISO 3166-2 region code of the parent headquarters region.
gleif_parent_headquarters_country The 2-character ISO 3166-1 country code of the parent headquarters country.
gleif_parent_headquarters_postal_code The (optional) postal code of this parent headquarter address as specified by the local postal service.
gleif_parent_registration_authority_id Reference code of the registration authority for the parent entity, taken from the Registration Authorities Code List maintained by GLEIF.
gleif_parent_other_registration_authority_id A legacy / historical reference code of a registration authority for the parent company which is not yet entered in the Registration Authorities Code List (RA list) maintained by GLEIF, or the designation of an interim register until such time as an entry from RA list can be delivered.
gleif_parent_registration_authority_entity_id The identifier of the parent entity at the indicated registration authority.
gleif_parent_jurisdiction The jurisdiction of legal formation of the parent legal entity; i.e. where the Legal Form of the parent legal entity originates.
gleif_parent_category Indicates (where applicable) the category of the parent legal entity identified by this LEI data record, as a more specific category within the broad definition given in ISO 17442. These categories are based on use cases specified in ROC policies, found here.
gleif_parent_sub_category Indicates and specifies further (where applicable) the sub-category (sub-sector) of the parent legal entity identified by this LEI Record and already categorized by the category field.
gleif_parent_legal_form_code The code corresponding to the legal form of the parent entity, taken from the ISO Entity Legal Form (ELF) code list maintained by GLEIF.
gleif_parent_other_legal_form A legacy code or textual description for the parent legal entity's legal form, used until a current code from the GLEIF-maintained list can be used.
gleif_parent_entity_status The operational and/or legal registration status of the parent legal entity (may be ACTIVE, INACTIVE, or NULL).
gleif_parent_successor_lei_1 The LEI of the first successor parent entity.
gleif_parent_successor_organization_name_1 The name of the first successor parent entity.
gleif_parent_successor_lei_2 The LEI of the second successor parent entity.
gleif_parent_successor_organization_name_2 The name of the second successor parent entity.
gleif_parent_successor_lei_3 The LEI of the third successor parent entity.
gleif_parent_successor_organization_name_3 The name of the third successor parent entity.
gleif_parent_successor_lei_4 The LEI of the fourth successor parent entity.
gleif_parent_successor_organization_name_4 The name of the fourth successor parent entity.
gleif_parent_successor_lei_5 The LEI of the fifth successor parent entity.
gleif_parent_successor_organization_name_5 The name of the fifth successor parent entity.
gleif_parent_initial_registration_date The date of the first parent LEI assignment, being the date of publication of the identifier and its supporting data record as represented in ISO 8601.
gleif_parent_registration_last_update_date Date/time the parent LEI record was most recently updated.
gleif_parent_registration_status The status of the parent legal entity's LEI registration with the Managing LOU.
gleif_parent_validation_sources The level of validation of the reference data provided by the registrant for the parent entity.
gleif_parent_validation_authority_id The reference code of the registration authority for the parent entity, taken from the Registration Authorities Code List (RA list) maintained by GLEIF.
gleif_parent_other_validation_authority_id A legacy / historical reference code of a registration authority for the parent entity which is not yet entered in the Registration Authorities Code List (RA list) maintained by GLEIF, or the designation of an interim register until such time as an entry from RA list can be delivered.
gleif_parent_validation_authority_entity_id The identifier of the parent entity at the indicated registration authority.
gleif_ultimate_parent_lei The 20-character Legal Entity Identifier (LEI) of the ultimate parent Legal Entity.
gleif_ultimate_parent_organization_name The legal name of the parent entity. If an entity is in a jurisdiction with more than one Legal Name (e.g., in different languages), this is the Primary Legal Name.
gleif_ultimate_parent_organization_name_alternate_1 First name other than the Primary Legal Name for the ultimate parent entity.
gleif_ultimate_parent_organization_name_alternate_2 Second name other than the Primary Legal Name for the ultimate parent entity.
gleif_ultimate_parent_organization_name_alternate_3 Third name other than the Primary Legal Name for the ultimate parent entity.
gleif_ultimate_parent_organization_name_alternate_4 Fourth name other than the Primary Legal Name for the ultimate parent entity.
gleif_ultimate_parent_organization_name_alternate_5 Fifth name other than the Primary Legal Name for the ultimate parent entity.
gleif_ultimate_parent_first_address_line The first ultimate parent address line element.
gleif_ultimate_parent_address_number Additional structured version of an external house number, or range of numbers, contained in one of the parent address line elements. This could be a numeral, a letter or code made up of mixed characters (e.g. 221B).
gleif_ultimate_parent_address_number_within_building Additional structured version of an internal location number, or range of numbers, contained in one of the parent address line elements.This could be a numeral, a letter or code made up of mixed characters (e.g. 13) of a floor, suite or apartment within a building identified e.g. by an element.
gleif_ultimate_parent_mail_routing Free text address line to hold content from other parent address lines containing explicit routing information. This element's presence indicates that this address is a routing / "care of" address.
gleif_ultimate_parent_address_line_1 First additional ultimate parent address line element.
gleif_ultimate_parent_address_line_2 Second additional ultimate parent address line element.
gleif_ultimate_parent_address_line_3 Third additional ultimate parent address line element.
gleif_ultimate_parent_city Name of the ultimate parent city.
gleif_ultimate_parent_region The 4- to 6-character ISO 3166-2 region code of the ultimate parent region.
gleif_ultimate_parent_country The 2-character ISO 3166-1 country code of the ultimate parent country.
gleif_ultimate_parent_postal_code The postal code of the ultimate parent address as specified by the parent local postal service.
gleif_ultimate_parent_headquarters_first_address_line The first address line element of the ultimate parent headquarters.
gleif_ultimate_parent_headquarters_address_number Additional structured version of an external house number, or range of numbers, contained in one of the ultimate parent headquarters address line elements. This could be a numeral, a letter or code made up of mixed characters (e.g. 221B).
gleif_ultimate_parent_headquarters_address_number_within_building Additional structured version of an internal location number, or range of numbers, contained in one of the ultimate parent headquarters address line elements.This could be a numeral, a letter or code made up of mixed characters (e.g. 13) of a floor, suite or apartment within a building identified e.g. by an element.
gleif_ultimate_parent_headquarters_mail_routing Free text address line to hold content from other ultimate parent headquarters address lines containing explicit routing information (this element's presence indicates that this headquarter address is a routing / "care of" address.
gleif_ultimate_parent_headquarters_address_line_1 First additional address line element of the ultimate parent headquarters.
gleif_ultimate_parent_headquarters_address_line_2 Second additional address line element of the ultimate parent headquarters.
gleif_ultimate_parent_headquarters_address_line_3 Third additional address line element of the ultimate parent headquarters.
gleif_ultimate_parent_headquarters_city Name of the city of the ultimate parent headquarters.
gleif_ultimate_parent_headquarters_region The (optional) 4- to 6-character ISO 3166-2 region code of the ultimate parent headquarters region.
gleif_ultimate_parent_headquarters_country The 2-character ISO 3166-1 country code of the ultimate parent headquarters country.
gleif_ultimate_parent_headquarters_postal_code The (optional) postal code of this ultimate parent headquarter address as specified by the local postal service.
gleif_ultimate_parent_registration_authority_id Reference code of the registration authority for the ultimate parent entity, taken from the Registration Authorities Code List maintained by GLEIF.
gleif_ultimate_parent_other_registration_authority_id A legacy / historical reference code of a registration authority for the ultimate parent company which is not yet entered in the Registration Authorities Code List (RA list) maintained by GLEIF, or the designation of an interim register until such time as an entry from RA list can be delivered.
gleif_ultimate_parent_registration_authority_entity_id The identifier of the ultimate parent entity at the indicated registration authority.
gleif_ultimate_parent_jurisdiction The jurisdiction of legal formation of the ultimate parent legal entity; i.e. where the Legal Form of the parent legal entity originates.
gleif_ultimate_parent_category Indicates (where applicable) the category of the ultimate parent legal entity identified by this LEI data record, as a more specific category within the broad definition given in ISO 17442. These categories are based on use cases specified in ROC policies, found here.
gleif_ultimate_parent_sub_category Indicates and specifies further (where applicable) the sub-category (sub-sector) of the ultimate parent legal entity identified by this LEI Record and already categorized by the category field.
gleif_ultimate_parent_legal_form_code The code corresponding to the legal form of the ultimate parent entity, taken from the ISO Entity Legal Form (ELF) code list maintained by GLEIF.
gleif_ultimate_parent_other_legal_form A legacy code or textual description for the ultimate parent legal entity's legal form, used until a current code from the GLEIF-maintained list can be used.
gleif_ultimate_parent_entity_status The operational and/or legal registration status of the ultimate parent legal entity (may be ACTIVE, INACTIVE, or NULL).
gleif_ultimate_parent_successor_lei_1 The LEI of the first successor ultimate parent entity.
gleif_ultimate_parent_successor_organization_name_1 The name of the first successor ultimate parent entity.
gleif_ultimate_parent_successor_lei_2 The LEI of the second successor ultimate parent entity.
gleif_ultimate_parent_successor_organization_name_2 The name of the second successor ultimate parent entity.
gleif_ultimate_parent_successor_lei_3 The LEI of the third successor ultimate parent entity.
gleif_ultimate_parent_successor_organization_name_3 The name of the third successor ultimate parent entity.
gleif_ultimate_parent_successor_lei_4 The LEI of the fourth successor ultimate parent entity.
gleif_ultimate_parent_successor_organization_name_4 The name of the fourth successor ultimate parent entity.
gleif_ultimate_parent_successor_lei_5 The LEI of the fifth successor ultimate parent entity.
gleif_ultimate_parent_successor_organization_name_5 The name of the fifth successor ultimate parent entity.
gleif_ultimate_parent_initial_registration_date The date of the first ultimate parent LEI assignment, being the date of publication of the identifier and its supporting data record as represented in ISO 8601.
gleif_ultimate_parent_initial_last_update_date Date/time the ultimate parent LEI record was most recently updated.
gleif_ultimate_parent_registration_status The status of the ultimate parent legal entity's LEI registration with the Managing LOU.
gleif_ultimate_parent_validation_sources The level of validation of the reference data provided by the registrant for the ultimate parent entity.
gleif_ultimate_parent_validation_authority_id The reference code of the registration authority for the ultimate parent entity, taken from the Registration Authorities Code List (RA list) maintained by GLEIF.
gleif_ultimate_parent_other_validation_authority_id A legacy / historical reference code of a registration authority for the ultimate parent entity which is not yet entered in the Registration Authorities Code List (RA list) maintained by GLEIF, or the designation of an interim register until such time as an entry from RA list can be delivered.
gleif_ultimate_parent_validation_authority_entity_id The identifier of the ultimate parent entity at the indicated registration authority.

GLEIF Enrichment Examples

Example 1

gleif_lei 549300JGNQ01YSWPUY12
gleif_organization_name BHP Manganese Australia Pty Ltd
gleif_organization_name_alternate_1 BILLITON MANGANESE AUSTRALIA PTY LTD
gleif_organization_name_alternate_2
gleif_organization_name_alternate_3
gleif_organization_name_alternate_4
gleif_organization_name_alternate_5
gleif_first_address_line Level 18
gleif_address_number
gleif_address_number_within_building
gleif_mail_routing
gleif_address_line_1 171 Collins Street
gleif_address_line_2
gleif_address_line_3
gleif_city Melbourne
gleif_region AU-VIC
gleif_country AU
gleif_postal_code

3000

gleif_headquarters_first_address_line Level 15
gleif_headquarters_address_number
gleif_headquarters_address_number_within_building
gleif_headquarters_mail_routing
gleif_headquarters_address_line_1 171 Collins Street
gleif_headquarters_address_line_2
gleif_headquarters_address_line_3
gleif_headquarters_city Melbourne
gleif_headquarters_region AU-VIC
gleif_headquarters_country AU
gleif_headquarters_postal_code

3000

gleif_registration_authority_id RA000014
gleif_other_registration_authority_id
gleif_registration_authority_entity_id 084 205 014
gleif_jurisdiction AU
gleif_category GENERAL
gleif_sub_category
gleif_legal_form_code TXVC
gleif_other_legal_form
gleif_entity_status ACTIVE
gleif_successor_lei_1
gleif_successor_organization_name_1
gleif_successor_lei_2
gleif_successor_organization_name_2
gleif_successor_lei_3
gleif_successor_organization_name_3
gleif_successor_lei_4
gleif_successor_organization_name_4
gleif_successor_lei_5
gleif_successor_organization_name_5
gleif_initial_registration_date 2022-11-16T15:32:00.000Z
gleif_registration_last_update_date 2022-11-16T15:33:00.000Z
gleif_registration_status ISSUED
gleif_validation_sources FULLY_CORROBORATED
gleif_validation_authority_id RA000014
gleif_other_validation_authority_id
gleif_validation_authority_entity_id 084 205 014
gleif_parent_lei 549300C116EOWV835768
gleif_parent_organization_name BHP GROUP (UK) LTD
gleif_parent_organization_name_alternate_1 BHP GROUP PLC
gleif_parent_organization_name_alternate_2 BHP BILLITON PLC
gleif_parent_organization_name_alternate_3
gleif_parent_organization_name_alternate_4
gleif_parent_organization_name_alternate_5
gleif_parent_first_address_line NOVA SOUTH
gleif_parent_address_number
gleif_parent_address_number_within_building
gleif_parent_mail_routing
gleif_parent_address_line_1 160 VICTORIA STREET
gleif_parent_address_line_2
gleif_parent_address_line_3
gleif_parent_city LONDON
gleif_parent_region GB-LND
gleif_parent_country GB
gleif_parent_postal_code SW1E 5LB
gleif_parent_headquarters_first_address_line Nova South
gleif_parent_headquarters_address_number
gleif_parent_headquarters_address_number_within_building
gleif_parent_headquarters_mail_routing
gleif_parent_headquarters_address_line_1 160 Victoria Street
gleif_parent_headquarters_address_line_2
gleif_parent_headquarters_address_line_3
gleif_parent_headquarters_city London
gleif_parent_headquarters_region GB-LND
gleif_parent_headquarters_country GB
gleif_parent_headquarters_postal_code SW1E 5LB
gleif_parent_registration_authority_id RA000585
gleif_parent_other_registration_authority_id
gleif_parent_registration_authority_entity_id

3196209

gleif_parent_jurisdiction GB
gleif_parent_category GENERAL
gleif_parent_sub_category
gleif_parent_legal_form_code H0PO
gleif_parent_other_legal_form
gleif_parent_entity_status ACTIVE
gleif_parent_successor_lei_1
gleif_parent_successor_organization_name_1
gleif_parent_successor_lei_2
gleif_parent_successor_organization_name_2
gleif_parent_successor_lei_3
gleif_parent_successor_organization_name_3
gleif_parent_successor_lei_4
gleif_parent_successor_organization_name_4
gleif_parent_successor_lei_5
gleif_parent_successor_organization_name_5
gleif_parent_initial_registration_date 2013-11-07T03:07:00.000Z
gleif_parent_registration_last_update_date 2023-01-25T23:59:00.000Z
gleif_parent_registration_status ISSUED
gleif_parent_validation_sources FULLY_CORROBORATED
gleif_parent_validation_authority_id RA000585
gleif_parent_other_validation_authority_id
gleif_parent_validation_authority_entity_id

3196209

gleif_ultimate_parent_lei WZE1WSENV6JSZFK0JC28
gleif_ultimate_parent_organization_name BHP GROUP LIMITED
gleif_ultimate_parent_organization_name_alternate_1 The Broken Hill Proprietary Company Limited
gleif_ultimate_parent_organization_name_alternate_2 BHP Billiton Limited
gleif_ultimate_parent_organization_name_alternate_3 BHP Limited
gleif_ultimate_parent_organization_name_alternate_4
gleif_ultimate_parent_organization_name_alternate_5
gleif_ultimate_parent_first_address_line Level 16
gleif_ultimate_parent_address_number
gleif_ultimate_parent_address_number_within_building
gleif_ultimate_parent_mail_routing
gleif_ultimate_parent_address_line_1 171 Collins Street
gleif_ultimate_parent_address_line_2
gleif_ultimate_parent_address_line_3
gleif_ultimate_parent_city MELBOURNE
gleif_ultimate_parent_region AU-VIC
gleif_ultimate_parent_country AU
gleif_ultimate_parent_postal_code

3000

gleif_ultimate_parent_headquarters_first_address_line Level 16
gleif_ultimate_parent_headquarters_address_number
gleif_ultimate_parent_headquarters_address_number_within_building
gleif_ultimate_parent_headquarters_mail_routing
gleif_ultimate_parent_headquarters_address_line_1 171 Collins Street
gleif_ultimate_parent_headquarters_address_line_2
gleif_ultimate_parent_headquarters_address_line_3
gleif_ultimate_parent_headquarters_city Melbourne
gleif_ultimate_parent_headquarters_region AU-VIC
gleif_ultimate_parent_headquarters_country AU
gleif_ultimate_parent_headquarters_postal_code

3000

gleif_ultimate_parent_registration_authority_id RA000014
gleif_ultimate_parent_other_registration_authority_id
gleif_ultimate_parent_registration_authority_entity_id 004 028 077
gleif_ultimate_parent_jurisdiction AU
gleif_ultimate_parent_category GENERAL
gleif_ultimate_parent_sub_category
gleif_ultimate_parent_legal_form_code R4KK
gleif_ultimate_parent_other_legal_form
gleif_ultimate_parent_entity_status ACTIVE
gleif_ultimate_parent_successor_lei_1
gleif_ultimate_parent_successor_organization_name_1
gleif_ultimate_parent_successor_lei_2
gleif_ultimate_parent_successor_organization_name_2
gleif_ultimate_parent_successor_lei_3
gleif_ultimate_parent_successor_organization_name_3
gleif_ultimate_parent_successor_lei_4
gleif_ultimate_parent_successor_organization_name_4
gleif_ultimate_parent_successor_lei_5
gleif_ultimate_parent_successor_organization_name_5
gleif_ultimate_parent_initial_registration_date 2012-06-06T15:56:00.000Z
gleif_ultimate_parent_registration_last_update_date 2022-06-14T15:31:00.000Z
gleif_ultimate_parent_registration_status ISSUED
gleif_ultimate_parent_validation_sources FULLY_CORROBORATED
gleif_ultimate_parent_validation_authority_id RA000014
gleif_ultimate_parent_other_validation_authority_id
gleif_ultimate_parent_validation_authority_entity_id 004 028 077

Example 2

Step Output
gleif_lei 549300IK5S73B4LOZ308
gleif_organization_name Argo International Holdings Limited
gleif_organization_name_alternate_1 Argo Acquisition, Limited
gleif_organization_name_alternate_2 Argo UK Holdings, Limited
gleif_organization_name_alternate_3
gleif_organization_name_alternate_4
gleif_organization_name_alternate_5
gleif_first_address_line Exchequer Court
gleif_address_number
gleif_address_number_within_building
gleif_mail_routing
gleif_address_line_1 33 Saint Mary Axe
gleif_address_line_2
gleif_address_line_3
gleif_city London
gleif_region GB-LND
gleif_country GB
gleif_postal_code EC3A 8AA
gleif_headquarters_first_address_line Exchequer Court
gleif_headquarters_address_number
gleif_headquarters_address_number_within_building
gleif_headquarters_mail_routing
gleif_headquarters_address_line_1 33 Saint Mary Axe
gleif_headquarters_address_line_2
gleif_headquarters_address_line_3
gleif_headquarters_city London
gleif_headquarters_region GB-LND
gleif_headquarters_country GB
gleif_headquarters_postal_code EC3A 8AA
gleif_registration_authority_id RA000585
gleif_other_registration_authority_id
gleif_registration_authority_entity_id

6543704

gleif_jurisdiction GB
gleif_category GENERAL
gleif_sub_category
gleif_legal_form_code H0PO
gleif_other_legal_form
gleif_entity_status ACTIVE
gleif_successor_lei_1
gleif_successor_organization_name_1
gleif_successor_lei_2
gleif_successor_organization_name_2
gleif_successor_lei_3
gleif_successor_organization_name_3
gleif_successor_lei_4
gleif_successor_organization_name_4
gleif_successor_lei_5
gleif_successor_organization_name_5
gleif_initial_registration_date 2018-04-06T15:31:00.000Z
gleif_registration_last_update_date 2020-06-26T16:24:00.000Z
gleif_registration_status LAPSED
gleif_validation_sources FULLY_CORROBORATED
gleif_validation_authority_id RA000585
gleif_other_validation_authority_id
gleif_validation_authority_entity_id

6543704

gleif_parent_lei JEV4CRSFSBPHDLYSYJ04
gleif_parent_organization_name ARGO RE LTD.
gleif_parent_organization_name_alternate_1 Peleus Reinsurance Ltd
gleif_parent_organization_name_alternate_2
gleif_parent_organization_name_alternate_3
gleif_parent_organization_name_alternate_4
gleif_parent_organization_name_alternate_5
gleif_parent_first_address_line Wellsley House South, 4th Floor
gleif_parent_address_number
gleif_parent_address_number_within_building
gleif_parent_mail_routing
gleif_parent_address_line_1 90 Pitts Bay Road
gleif_parent_address_line_2
gleif_parent_address_line_3
gleif_parent_city Pembroke
gleif_parent_region
gleif_parent_country BM
gleif_parent_postal_code HM 08
gleif_parent_headquarters_first_address_line Wellsley House South, 4th Floor
gleif_parent_headquarters_address_number
gleif_parent_headquarters_address_number_within_building
gleif_parent_headquarters_mail_routing
gleif_parent_headquarters_address_line_1 90 Pitts Bay Road
gleif_parent_headquarters_address_line_2
gleif_parent_headquarters_address_line_3
gleif_parent_headquarters_city Pembroke
gleif_parent_headquarters_region
gleif_parent_headquarters_country BM
gleif_parent_headquarters_postal_code HM 08
gleif_parent_registration_authority_id RA000028
gleif_parent_other_registration_authority_id
gleif_parent_registration_authority_entity_id

38892

gleif_parent_jurisdiction BM
gleif_parent_category GENERAL
gleif_parent_sub_category
gleif_parent_legal_form_code NAQG
gleif_parent_other_legal_form
gleif_parent_entity_status ACTIVE
gleif_parent_successor_lei_1
gleif_parent_successor_organization_name_1
gleif_parent_successor_lei_2
gleif_parent_successor_organization_name_2
gleif_parent_successor_lei_3
gleif_parent_successor_organization_name_3
gleif_parent_successor_lei_4
gleif_parent_successor_organization_name_4
gleif_parent_successor_lei_5
gleif_parent_successor_organization_name_5
gleif_parent_initial_registration_date 2012-11-20T17:21:00.000Z
gleif_parent_registration_last_update_date 2022-12-28T01:02:00.000Z
gleif_parent_registration_status LAPSED
gleif_parent_validation_sources FULLY_CORROBORATED
gleif_parent_validation_authority_id RA000028
gleif_parent_other_validation_authority_id
gleif_parent_validation_authority_entity_id

38892

gleif_ultimate_parent_lei 549300M4T8Y5TTWI6O03
gleif_ultimate_parent_organization_name ARGO GROUP INTERNATIONAL HOLDINGS, LTD.
gleif_ultimate_parent_organization_name_alternate_1
gleif_ultimate_parent_organization_name_alternate_2
gleif_ultimate_parent_organization_name_alternate_3
gleif_ultimate_parent_organization_name_alternate_4
gleif_ultimate_parent_organization_name_alternate_5
gleif_ultimate_parent_first_address_line 90 Pitts Bay Road
gleif_ultimate_parent_address_number
gleif_ultimate_parent_address_number_within_building
gleif_ultimate_parent_mail_routing
gleif_ultimate_parent_address_line_1
gleif_ultimate_parent_address_line_2
gleif_ultimate_parent_address_line_3
gleif_ultimate_parent_city Pembroke
gleif_ultimate_parent_region
gleif_ultimate_parent_country BM
gleif_ultimate_parent_postal_code HM 08
gleif_ultimate_parent_headquarters_first_address_line 90 Pitts Bay Road
gleif_ultimate_parent_headquarters_address_number
gleif_ultimate_parent_headquarters_address_number_within_building
gleif_ultimate_parent_headquarters_mail_routing
gleif_ultimate_parent_headquarters_address_line_1
gleif_ultimate_parent_headquarters_address_line_2
gleif_ultimate_parent_headquarters_address_line_3
gleif_ultimate_parent_headquarters_city Pembroke
gleif_ultimate_parent_headquarters_region
gleif_ultimate_parent_headquarters_country BM
gleif_ultimate_parent_headquarters_postal_code HM 08
gleif_ultimate_parent_registration_authority_id RA000028
gleif_ultimate_parent_other_registration_authority_id
gleif_ultimate_parent_registration_authority_entity_id

26538

gleif_ultimate_parent_jurisdiction BM
gleif_ultimate_parent_category GENERAL
gleif_ultimate_parent_sub_category
gleif_ultimate_parent_legal_form_code 7AS7
gleif_ultimate_parent_other_legal_form
gleif_ultimate_parent_entity_status ACTIVE
gleif_ultimate_parent_successor_lei_1
gleif_ultimate_parent_successor_organization_name_1
gleif_ultimate_parent_successor_lei_2
gleif_ultimate_parent_successor_organization_name_2
gleif_ultimate_parent_successor_lei_3
gleif_ultimate_parent_successor_organization_name_3
gleif_ultimate_parent_successor_lei_4
gleif_ultimate_parent_successor_organization_name_4
gleif_ultimate_parent_successor_lei_5
gleif_ultimate_parent_successor_organization_name_5
gleif_ultimate_parent_initial_registration_date 2012-12-12T20:06:00.000Z
gleif_ultimate_parent_registration_last_update_date 2022-07-20T15:31:00.000Z
gleif_ultimate_parent_registration_status ISSUED
gleif_ultimate_parent_validation_sources FULLY_CORROBORATED
gleif_ultimate_parent_validation_authority_id RA000028
gleif_ultimate_parent_other_validation_authority_id
gleif_ultimate_parent_validation_authority_entity_id

26538