| key |
id |
string(100)* |
= |
Internally generated id for the specific entity. |
| timeline |
lastModifiedDate |
dateTime* |
=< >= |
This is the date and time on which the instrument was last modified. |
|
addressOfDomicile |
string(2000) |
|
Contains the address where the organization is headquartered. |
|
addressOfIncorporation |
string(2000) |
|
Contains the address where the organization is incorporated. |
|
agmAddress |
string(200) |
|
Indicates the address where Annual General Meeting is held. |
|
agmCity |
string(200) |
|
Indicates the City of Annual General Meeting. |
|
agmCountry |
string(200) |
|
Indicates the country/territory of Annual General Meeting. |
|
agmDate |
date |
|
Indicates the date when Annual General Meeting is held. |
|
agmNumber |
string(200) |
|
Indicates the number of Annual General Meeting. |
|
agmTime |
dateTime |
|
Indicates the time when Annual General Meeting is held. |
|
agmType |
string(200) |
|
Indicates the type of Annual General Meeting. |
|
bankruptcy |
OrganizationBankruptcy[1000] |
|
Refer to linked entity. |
|
bloombergTicker |
string(100) |
|
Defines the ticker from Bloomberg. |
|
branchIndicator |
boolean |
|
Indicates whether the organization is a branch organization. |
| filter_list |
category |
string(200) |
= |
Contains the category to which the issuer of the security has been assigned. |
|
cik |
string(100) |
|
Contains the code representing Central Index Key of the issuer. |
|
ciqCompanyId |
long |
|
Unique S&P Capital IQ company identifier. |
|
cityOfDomicile |
string(100) |
|
Contains the city where the organization is primarily headquartered. |
|
cityOfIncorporation |
string(100) |
|
Contains the city where the organization is primarily incorporated. |
| filter_list |
companyId |
string(100) |
= |
Unique identifier created by S&P Capital IQ to identify an entity. |
|
companyNumber |
string(200) |
|
The company number of an entity. |
|
companyNumberType |
string(200) |
|
The description of the registry or organization that issued the company number. |
|
consolidatedFixedAssets |
decimal |
|
Contains the consolidated fixed assets of the organization. |
|
corpStructure |
string(200) |
|
Indicates the corporate structure of an entity. |
|
countryName |
string(3) |
|
Contains the three letter ISO country/territory code where a financial institution is incorporated. |
|
countryOfDomicile |
string(200) |
|
Contains the country/territory issuer's domicile. |
|
countryOfIncorporation |
string(200) |
|
Contains the ISO Alpha 3 country/territory code in which the issuer has been incorporated. |
|
countryOfRisk |
string(200) |
|
Contains the ISO Alpha 3 country/territory risk of the issuer. |
|
countryOfRisks |
string(200) |
|
Contains the ISO Alpha 3 country/territory risk of the issuer. |
|
createdOn |
dateTime |
|
Date and time on which the organization details was created in the system. |
|
cusip6 |
string(6)[100] |
|
Contains the 6 digit CUSIP of the issuer. |
|
economicArea |
long |
|
Indicates the economic area of the quotation place. |
|
email |
string(200) |
|
Indicates the email address of entity. |
|
entityGrade |
string(20) |
|
Indicates if the terms for the entity are final or indicative. Describes the document used to complete the
record such as jurisdition registration site, Companies house etc. |
|
entityIncorporationDate |
date |
|
Indicates the date of incorporation of an entity. |
|
esgScoreDetails |
EsgScoreDetails |
|
Refer to linked entity. |
|
euSavingQualified |
boolean |
|
Indicates if an entity is complying with EUSD. |
|
fatcaEntityType |
string(100) |
|
Contains the organization type of a financial institution as defined by IRS. |
|
fax |
string(60) |
|
Indicates the fax information. |
|
filedForm15 |
boolean |
|
Indicates the company has filed form 15. |
|
filingDate |
date |
|
Indicates the date of filing of an entity. |
|
financialInstitutionName |
string(2000) |
|
Contains the name of the organization for which the GIIN number has been issued. |
|
fiscalYearEnd |
date |
|
Fiscal year-end is the completion of a one-year, or 12-month, accounting period. |
|
gSib |
boolean |
|
Indicates if an Entity is GSIB (Global Systemically Important Bank) |
|
gicsCode |
string(200) |
|
Contains the code representing General Industry Classification Standard. GICS is developed by MSCI and S&P. |
|
gicsLevel1 |
string(200) |
|
Contains the code representing the Sector (Level 1) pursuant to the General Industry Classification Standard (GICS). |
|
gicsLevel2 |
string(200) |
|
Contains the code representing the Industry Group (Level 2) pursuant to the General Industry Classification Standard (GICS). |
|
gicsLevel3 |
string(200) |
|
Contains the code representing the Industry (Level 3) pursuant to the General Industry Classification Standard (GICS). |
|
gicsLevel4 |
string(200) |
|
Contains the code representing the Sub-Industry (Level 4) pursuant to the General Industry Classification Standard (GICS). |
|
giin |
string(19) |
|
Contains the code representing the Global Intermediary Identification Number assigned to a PFFI or Registered Deemed Compliant FFI. |
|
governmentGuaranteedDescription |
string(2000) |
|
The field indicates the guarantor's information of an entity. |
|
governmentGuaranteedFlag |
boolean |
|
Indicates if an instrument is government guaranteed. |
|
grossRevenue |
decimal |
|
Contains the annual gross revenue of the organization. |
|
hierarchyEligibleCriteria |
string(100) |
|
Indicates hierarchy eligible criteria |
|
ibei |
string(50) |
|
Contains the International Business Entity Identifier (IBEI) as per ISO Standard 16372. |
|
icbIndustry |
string(100) |
|
Contains the code representing the Industry level (top level) pursuant to the Industry Classification Benchmark (ICB). |
|
icbSector |
string(100) |
|
Contains the code representing the Sector level (third level) pursuant to the Industry Classification Benchmark (ICB). |
|
icbSubSector |
string(100) |
|
Contains the code representing the Subsector level (fourth level) pursuant to the Industry Classification Benchmark
(ICB). |
|
icbSuperSector |
string(100) |
|
Contains the code representing the Super sector level (second level) as per the Industry Classification Benchmark (ICB). |
|
isConglomerate |
boolean |
|
Indicates if an entity is conglomerate. |
|
isElink |
boolean |
|
Indicates if the organization is part of Elink universe. |
|
isHierarchyEligible |
boolean |
|
Indicates if the entity required Hierarchy data. |
|
isHierarchyScrubbedEntity |
boolean |
|
Indicates if the entity is scrubbed with Hierarchy data. |
|
isHoldCo |
boolean |
|
Indicates if an entity is a Holding entity. |
|
isInBankruptcy |
boolean |
|
Status of bankruptcy for an entity. |
|
isSwapDealer |
boolean |
|
Indicate that an entity is swap dealer. |
|
jurisdiction |
string(200) |
|
Contains the jurisdiction/territory in which the issuer has been incorporated. |
|
lastModifiedBy |
string(200) |
|
Name of the person who modified the organization. |
| filter_list |
lastModifiedisHierarchyEligible |
dateTime |
=< >= |
This is the date on which isHierarchyEligible flag was last modified. |
|
lastReviewDate |
date |
|
Indicates the date the entity was last reviewed by analyst. |
|
legacyAverageRating |
string(50) |
|
Indicates the legacy average rating for the Issuer. |
|
legacyTopParentLegalEntityName |
string(4000) |
|
Legacy Legal entity name of top parent entity. |
|
legacyTopParentTicker |
string(100) |
|
Legacy entity ticker of top parent entity. |
|
legacyparentLegalEntityName |
string(4000) |
|
Legacy Legal entity name of parent entity. |
|
legacyparentTicker |
string(100) |
|
Legacy entity ticker of parent entity. |
| filter_list |
legalName |
string(4000) |
= |
Contains the legal name of the issuer. |
|
legalStructure |
string(200) |
|
Specifies the organization's legal form of business such as Corporation, LLC, Inc., S.A., GMBH etc. |
| filter_list |
lei |
string(200) |
= |
Contains the Legal Entity Identifier as per ISO 17442. |
|
leiAssignDate |
date |
|
Indicates the date on which the LEI record was assigned to the organization. |
|
leiLastUpdate |
dateTime |
|
Indicates the date on which the LEI record was last updated. |
|
leiLegalForm |
string(200) |
|
Contains the Legal Form of the organization, taken from the list of ISO Organization Legal Form (ELF) codes, maintained by GLEIF. |
|
leiRegistrationAddress |
string(2000) |
|
Contains the address of the organization as recorded in the registration of the organization as per its legal jurisdiction. |
|
leiStatus |
string(100) |
|
Indicates the status of the Issuer's Legal Entity Identifier (LEI). |
|
liquidity |
string(20) |
|
Indicates CDS Liquidity of the entity according to the contributions. |
|
mapsCriteria |
string(500) |
|
Indicates the maps criteria for an entity. |
|
markitSectorLevel1 |
string(200) |
|
Contains the code representing the Industry (Level 1) pursuant to the Standard Industrial Classification (SIC). |
|
markitSectorLevel2 |
string(200) |
|
Contains the code representing the Industry (Level 2) pursuant to the Standard Industrial Classification (SIC). |
| filter_list |
markitSectorLevel3 |
string(200) |
= |
Contains the code representing the Industry (Level 3) pursuant to the Standard Industrial Classification (SIC). |
|
markitSectorLevel4 |
string(200) |
|
Contains the code representing the Industry (Level 4) pursuant to the Standard Industrial Classification (SIC). |
|
markitSectorLevel5 |
string(200) |
|
Contains the code representing the Industry (Level 5) pursuant to the Standard Industrial Classification (SIC). |
|
mei |
string(100) |
|
Markit Entity Identifier or MEI uniquely identifies entities in the loan market including counterparties, issuers, funds, sub-funds and borrowers. |
|
meiVerificationDate |
date |
|
Date on which MEI is verified. |
|
mfi |
string(50) |
|
Contains the MFI Code allocated to the issuer of the security in question by the European Central Bank . |
|
naceCode |
string(200) |
|
NACE Code represents the Statistical Classification of Economic Activities in the European Community and is the industry standard classification system used in the European Union. |
|
naceLevel1 |
string(200) |
|
Nace Level 1 represents the industry section and is identified by an alphabetical letter. |
|
naceLevel2 |
string(200) |
|
Nace Level 2 represents the industry division and is identified by two digit numerical codes. |
|
naceLevel3 |
string(200) |
|
Nace Level 3 represents the industry group and is identified by three digit numerical codes. |
|
naceLevel4 |
string(200) |
|
Nace Level 4 represents the industry class and is identified by four digit numerical codes. |
|
naicsCode |
string(200) |
|
North American Industry Classification System (NAICS) is used by businesses and governments to classify and measure economic activity. |
|
naicsLevel1 |
string(200) |
|
NAICS Level 1 is used by businesses and governments to classify and measure economic activity. |
|
naicsLevel2 |
string(200) |
|
NAICS Level 2 is used by businesses and governments to classify and measure economic activity. |
|
naicsLevel3 |
string(200) |
|
NAICS Level 3 is used by businesses and governments to classify and measure economic activity. |
|
naicsLevel4 |
string(200) |
|
NAICS Level 4 is used by businesses and governments to classify and measure economic activity. |
|
naicsLevel5 |
string(200) |
|
NAICS Level 5 is used by businesses and governments to classify and measure economic activity. |
|
name |
string(4000) |
|
Contains the name of the organization. |
|
nativeLongName |
string(4000) |
|
Indicates companies long name in the local language. |
|
nativeShortName |
string(4000) |
|
Indicates companies short name in the local language. |
|
orgJurisdiction |
string(300) |
|
Contains the jurisdiction/territory in which the issuer has been incorporated. |
|
organizationCeasingDetails |
OrganizationCeasingDetails |
|
Refer to linked entity. |
|
organizationCorporateAction |
OrganizationCorporateAction[1000] |
|
Refer to linked entity. |
|
organizationDerivedRating |
OrganizationDerivedRating |
|
Refer to linked entity. |
|
organizationFinancials |
OrganizationFinancials[1000] |
|
Refer to linked entity. |
|
organizationId |
long |
|
Contains the internally generated organization number. |
|
organizationIdentifiers |
OrganizationIdentifiers[1000] |
|
Refer to linked entity. |
|
organizationIndustryClassification |
OrganizationIndustryClassification[1000] |
|
Refer to linked entity. |
|
organizationName |
OrganizationName[1000] |
|
Refer to linked entity. |
|
organizationRelationship |
OrganizationRelationship[1000] |
|
Refer to linked entity. |
|
parentEffectiveFrom |
date |
|
Date from which relation ship is effective with the parent organization. |
|
parentLegalEntityName |
string(4000) |
|
Legal entity name of parent entity. |
| filter_list |
parentTicker |
string(100) |
= |
Internally generated Ticker of the immediate parent issuer entity. |
|
percentOwnership |
decimal |
|
Contains the percent ownership associated with the active chain of relationships of related organizations. |
|
postalCodeOfDomicile |
string(50) |
|
Contains the postal code where the organization is headquartered. |
|
postalCodeOfIncorporation |
string(50) |
|
Contains the postal code where the organization is incorporated. |
|
privatelyRegistered |
boolean |
|
Indicate the entity is privately held registered company. |
|
publiclyTradedFlag |
boolean |
|
Indicates whether the organization is publicly held registered organization. |
|
ratings |
OrganizationRatings[1000] |
|
Refer to linked entity. |
|
redCode |
string(6) |
|
Red6 Code for the Issuer. |
|
registeredDate |
date |
|
Indicates the date the entity was registered. |
|
reportingCurrency |
string(3) |
|
Contains the currency corresponding to the respective financial type. Follows ISO 4217 code |
|
reportingYear |
string(20) |
|
Contains the year for which the financials are reported. |
|
sanctionStatus |
string(200) |
|
Indicates the sanction status of an entity. |
|
sanctionStatusModifiedDate |
date |
|
Indicates the date the sanction status of an entity was modified |
|
secFilingType |
string(200) |
|
Indicates the type of SEC filing. |
|
shortName |
string(4000) |
|
Contains the short name of the issuer. |
|
sicCode |
string(200) |
|
Contains the code representing Standard Industrial Classification. |
|
sicLevel1 |
string(200) |
|
Contains the code representing the major Industry Group (Level 1) pursuant to the Standard Industrial Classification (SIC). |
|
sicLevel2 |
string(200) |
|
Contains the code representing the Industry Group (Level 2) pursuant to the Standard Industrial Classification (SIC). |
|
sicLevel3 |
string(200) |
|
Contains the code representing the Industry (Level 3) pursuant to the Standard Industrial Classification (SIC). |
|
spvIndicator |
boolean |
|
Indicates whether the organization is registered as a special purpose vehicle. |
|
stateIncorporated |
string(200) |
|
Contains the state/province name within the country/territory in which the issuer has been incorporated. |
|
stateProvinceOfDomicile |
string(100) |
|
Contains the state/province name within the country/territory in which the issuer is headquarted. |
|
status |
string(50) |
|
Status of the organization. |
|
taxAuthority |
string(200) |
|
Indicates the tax authority. |
| filter_list |
ticker |
string(100) |
= |
Internally generated Ticker of the issuer entity. |
|
topParentLegalEntityName |
string(4000) |
|
Legal entity name of top parent entity. |
| filter_list |
topParentTicker |
string(100) |
= |
Internally generated Ticker of the top parent issuer entity. |
|
totalDebtOutstanding |
decimal |
|
Total debt outstanding of the issuer/entity as per the financial report. |
|
ultimateParentIndicator |
boolean |
|
Indicates whether the organization is an Ultimate Parent. |
|
unm49Cor |
string(200) |
|
Indicates the unm 49 code for country/territory of risk. |
|
yearOfIncorporation |
long |
|
Indicates year of incorporation. |