Returns List Of CIQ CC6 Codes By CompanyId

The following sample SQL query returns a one-to-one mapping of the CUSIP6 or CINS6 (CC6) to the Company ID using the BECRS packages. Note: We have used a single companyId for the query to run faster.

Enhancement Date: 4/26/2022

  • SourceMarket Intelligence
  • Data Packages Required
    Base CompanyBECRS BIC Code DailyBECRS CUSIP/CINS6 DailyCRS Cross Reference Core
  • Associated Datasets
    Business Entity Cross Reference Service (BECRS)

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake