| key |
id |
string(30)* |
= |
Internally generated unique identifier for the instrument. |
| timeline |
lastModifiedDate |
dateTime* |
=< >= |
Date and time on which the record was last modified. |
|
accretedAmountType |
string(50) |
|
Indicates whether the Accretion Amount is expressed as Per Denomination or Per Maturity Amount(if applicable). |
|
accretionDetails |
AccretionDetails[1000] |
|
Refer to linked entity. |
|
accruedRate |
decimal |
|
Current accrued RFR (Risk-Free Rate) coupon Rate. |
|
accruedRateEffectiveDate |
date |
|
Effective Date of current accrued RFR (Risk-Free Rate) coupon Rate. |
|
accruedRates |
AccruedRates[5000] |
|
Refer to linked entity. |
|
activePriced |
string(10) |
|
Provides the business area for which the security is currently priced. |
|
alternativePrincipalCurrency |
string(3) |
|
Alternative currency for principal payment. Only applicable when issuer has the option to make principal payment in the specific currency. Follows ISO 4217 code |
|
amortizationSchedule |
AmortizationSchedule[1000] |
|
Refer to linked entity. |
|
amountDetails |
AmountDetails[1000] |
|
Refer to linked entity. |
|
amountIssuedPublic |
decimal |
|
Amount issued for treasury securities. |
|
amtFlag |
boolean |
|
Indicates if Alternative Minimum Tax is applicable to a security. |
|
announcementDate |
date |
|
The date of announcement of an instrument. |
| filter_list |
assetClass |
string(500) |
= |
Classification of an instrument based on IHSM Standards. |
|
assetExchange |
AssetExchange[1000] |
|
Refer to linked entity. |
|
assetType |
string(20) |
|
Indicates the broader classification of an instrument (e.g. GSAC, Municipal, Structured Finance or Equity). |
|
auctionType |
string(100) |
|
Type of auction by which the instrument was issued. Applicable for Treasury securities. |
|
austrianId |
string(50) |
|
Austrian Id of the security. |
|
averageLifeDate |
date |
|
The average life date of the maturity that is subject to a sinking fund. The average life can be defined as the amount of time that it takes an issuer to redeem half of the bond debt that is outstanding. This calculation represents the quickness in which an issuer can pay off the principal debt of the security. |
|
awardDate |
date |
|
A date on which the issuer formally accepts a bid for Competitive Issues or, the date the Bond Purchase Agreement is executed for Negotiated Issues. |
|
awardDateStatus |
string(100) |
|
A flag indicating the Award Date status. |
|
bailInOption |
string(50) |
|
Describes the Bail-in Option applicable for the security. |
|
baseIndexDate |
date |
|
Base date of the reference index as stated in the offer document. |
|
baseIndexValue |
decimal |
|
Base value of the reference index as stated in the offer document. |
|
benchmarkIsin |
string(12) |
|
The ISIN code of the benchmark provided by the administrator. |
|
benchmarkSpread |
decimal |
|
Yield spread over a specific benchmark for a security. |
| filter_list |
billingCode |
string(50) |
=timeline |
The billing code of an instrument. |
|
bloombergCompLongName |
string(200) |
|
Bloomberg-generated company's complete name. |
|
bloombergExchangeCode |
string(100) |
|
Exchange code from Bloomberg. |
|
bloombergGlobalCompName |
string(100) |
|
Bloomberg-generated company's global name. |
|
bloombergMarketSectorDescription |
string(100) |
|
Market Sector description from Bloomberg. |
|
bloombergSecurityDescription |
string(200) |
|
Bloomberg-generated security description of the company. |
|
bloombergSecurityType |
string(50) |
|
Bloomberg-generated type of security. |
| filter_list |
bloombergTicker |
string(50) |
= |
Bloomberg ticker is a string of characters or numbers to identify a company or entity uniquely by Bloomberg. |
|
bloombergUniqueId |
string(50) |
|
Unique identifier assigned by Bloomberg to all securities. |
|
brsIdDetails |
BrsIdDetails[1000] |
|
Refer to linked entity. |
|
calculationType |
string(100) |
|
Calculation method or model applied to derive the value of the instrument. |
|
callExecutionDate |
date |
|
Date on which the issuer would exercise the call option. Applicable only for full redemption. |
|
callNoticeDate |
date |
|
Date on which issuer has provided a notice to investor for call execution. |
|
callSchedule |
CallSchedule[5000] |
|
Refer to linked entity. |
|
capitalPurpose |
string(500) |
|
Code indicating what the funds will be used for, like new money, pre-refunding another issue, current refunding or remarketing. |
|
capitalizationDetails |
CapitalizationDetails[1000] |
|
Refer to linked entity. |
|
cashFlowDetails |
CashFlowDetails[4999] |
|
Refer to linked entity. |
|
cavFlag |
boolean |
|
Indicates whether the call_price_f is expressed as a percentage of the CAV price. |
| filter_list |
ccdcId |
string(100) |
= |
Identifier for securities traded on Macau Financial Exchange either issued in Macau or bonds that are cross-listed between Macau and Mainland China. |
|
centralBankDetails |
CentralBankDetails[1000] |
|
Refer to linked entity. |
|
cfiCode |
string(6) |
|
Type of Identifier - Certificate of Financial Instruments |
|
cins |
string(9) |
|
CINS numbers are used to identify international securities and are an extension of the CUSIP system used for U.S. and Canadian securities. |
|
ciqSecurityId |
long |
|
The unique identifier created by S&P Capital IQ to identify a security. |
|
class |
string(50) |
|
class of an instrument generally maintained for sukuks |
|
classification |
string(100) |
|
Classification of an instrument based on its issuer sector for example Corporate, Government etc. |
|
classificationSubType |
string(100) |
|
Classification of an instrument based on its geographical location of an issuer and issuance for example Domestic, Global, Eurobond etc. |
|
cleanupCallPercent |
decimal |
|
Contains the clean up call percentage. As soon as the clean up percentage falls below the original debt volume, the issuer has the right to redeem the outstanding bonds immediately. |
|
clearingSchedule |
ClearingSchedule[1000] |
|
Refer to linked entity. |
|
cmuIssueId |
string(30) |
|
CMU Issue Number of a record. CMU is a central securities depository (CSD) for debt securities in Hong Kong. Values are sourced from https://www.cmu.org.hk/ |
|
collateralType |
string(100) |
|
Type of collateral backing the security. |
|
commonCode |
string(9) |
|
A common code is nine-digit identification code issued jointly by CEDEL and Euroclear. |
|
complexFloaterType |
string(50) |
|
Further describes the type of complex floater security. |
|
convertedCurrentAmountOutstandingInUsd |
decimal |
|
Current amount outstanding for the security converted in USD. |
|
convertedIssueSizeInUsd |
decimal |
|
Original amount issued at issuance converted in USD. |
|
convertedTotalAmountIssuedInUsd |
decimal |
|
Total issued amount for the security converted in USD. |
|
convertibleOrExchangeable |
ConvertibleOrExchangeable[1000] |
|
Refer to linked entity. |
|
couponChangeDate |
date |
|
Date on which the coupon type for a security changes. |
|
couponDeviationType |
string(200) |
|
Indicates if there are an irregular coupon payment period during the tenure of the security such as First short coupon, Long Last coupon, second short coupon etc. |
|
couponExchangeRate |
decimal |
|
Rate used for converting coupon amount from one to currency to another currency, mainly applicable for dual currency bonds. |
|
couponPaymentType |
string(100) |
|
Type of coupon payment made during the current period. Eg: Cash, PIK, Cash & PIK. |
|
covenants |
Covenants |
|
Refer to linked entity. |
|
createdOn |
dateTime |
|
Date and time on which the instrument was created in the system. |
|
creditEnhancement |
CreditEnhancement[1000] |
|
Refer to linked entity. |
|
creditLinkedDetails |
CreditLinkedDetails[1000] |
|
Refer to linked entity. |
|
crossoverRefundedFlag |
boolean |
|
Indicates if a security has been crossover refunded. |
|
csdDetails |
CsdDetails[100] |
|
Refer to linked entity. |
|
csdrDetails |
CsdrDetails[100] |
|
Refer to linked entity. |
|
currentAccruedDayCount |
string(100) |
|
Current day count convention applicable for accrued. |
|
currentAmountOutstanding |
decimal |
|
Current amount outstanding for the security. |
|
currentAmountOutstandingEffDate |
date |
|
Indicates the effective date of current amount outstanding. |
| filter_list |
currentCoupon |
decimal |
=< >= |
Current interest rate for the security. |
|
currentCouponSpread |
decimal |
|
Current spread used in the calculation of interest for floating rate securities. |
|
currentDayCountConvention |
string(100) |
|
Current day count convention for the security. |
|
currentIndexDate |
date |
|
Current date of the reference index |
|
currentIndexRatio |
decimal |
|
Current Index Ratio of inflation linked security |
|
currentIndexValue |
decimal |
|
Current date of the reference index value |
|
currentOutstandingFactor |
decimal |
|
Latest amount outstanding factor |
|
currentPricingDayCount |
string(100) |
|
Current day count convention applicable for Pricing. |
| filter_list |
cusip |
string(9) |
=< >= |
CUSIP stands for Committee on Uniform Securities Identification Procedures. A CUSIP number identifies most financial instruments, including: stocks of all registered U.S. and Canadian companies, commercial paper, and U.S. government and municipal bond. |
|
danishId |
string(50) |
|
Danish Id of the security. |
|
dataQualityDetails |
DataQualityDetails[1000] |
|
Refer to linked entity. |
|
datedDate |
date |
|
Indicates Dated Date of the security. |
|
dayCountRateDetermination |
string(100) |
|
Business/Calendar days convention applicable to day count. |
|
dealInfo |
DealInfo[1000] |
|
Refer to linked entity. |
|
debtTier |
string(100) |
|
Categories by which a bank's capital is divided. |
|
defaultDetails |
DefaultDetails[1000] |
|
Refer to linked entity. |
|
deferredCouponDate |
date |
|
The date a deferred interest/convertible bond starts paying regular interest. |
|
deliveryDate |
date |
|
The actual date on which securities are delivered in exchange for the payment of the purchase price. |
|
denominationIncrease |
decimal |
|
Minimum multiple denomination in which a security may be purchased or held in the secondary market above the minDenomination. |
|
denominationType |
string(200) |
|
Physical form in which the instrument was originally issued. |
|
depositoryType |
string(100) |
|
Type of depository that issues receipts for the security and holds it in deposit. |
|
derivedData |
DerivedData |
|
Refer to linked entity. |
|
derivedRating |
DerivedRating[10] |
|
Refer to linked entity. |
|
documentIssuerName |
string(1000) |
|
Issuer name as given in the offering document. |
|
dtccEligible |
boolean |
|
Indicates if the instrument is eligible for clearing and settlement through DTC |
|
dualCurrencyBusinessDayConvention |
string(300) |
|
Businessor calendar days convention applicable for dual currency instruments. |
|
dummyIsinFlag |
boolean |
|
Defines if a dummy ISIN was added to the security |
|
dutchId |
string(50) |
|
Dutch Id of the security. |
|
emtnFlag |
boolean |
|
Indicates if the instrument is a euro medium term note. |
|
entityDetails |
EntityDetails[1000] |
|
Refer to linked entity. |
|
erisaDetails |
ErisaDetails[1000] |
|
Refer to linked entity. |
|
escrowDetails |
EscrowDetails[1000] |
|
Refer to linked entity. |
|
escrowPercentage |
string(200) |
|
A percentage breakdown of the types of securities in the escrow fund. |
|
escrowType |
string(500) |
|
Indicates the type of securities invested in the escrow fund for an escrowed to maturity security (if applicable). |
|
esgDetails |
EsgDetails |
|
Refer to linked entity. |
|
esgScoreFlag |
boolean |
|
Indicates if ESG score is available for the issuer. |
|
esgSlbDetails |
EsgSlbDetails[100] |
|
Refer to linked entity. |
|
exchangeOfferDetails |
ExchangeOfferDetails[1000] |
|
Refer to linked entity. |
|
exdividendRecordDetails |
ExdividendRecordDetails[1000] |
|
Refer to linked entity. |
|
extendableCouponSubType |
string(100) |
|
Describes the coupon type further applicable during specific extendable period. Used in conjunction with extendableCouponType field. |
|
extendableCouponType |
string(100) |
|
Coupon type applicable during the specific extendable period. |
|
extendableDate |
date |
|
Maturity date of the extendable security. |
|
extendableOption |
string(100) |
|
For an extendable security, this field describes whether the option can be exercised by the holder, issuer or automatically based on a pre-defined criteria. |
|
extendableSchedule |
ExtendableSchedule[1000] |
|
Refer to linked entity. |
|
fallbackRateApplicable |
string(100) |
|
Indicates if the security has a Fallback Rate Option (A rate of interest that can be used if the underlying benchmark reference rate is unavailable). |
|
fallbackRateDetails |
string(4000) |
|
Contains the additional details related to fallback rate option. |
|
figi |
string(50) |
|
Financial Instrument Global Identifier (FIGI) (formerly Bloomberg Global Identifier (BBGID)) is an open standard, unique identifier of financial instruments that is assigned to instrument. |
|
filename |
string(500) |
|
Indicates the filename of the document parsed. |
|
finalCallPrice |
decimal |
|
Price at which the instrument would be called, represented as a percent of par. Only for final redemption. |
|
finalPutPrice |
decimal |
|
Price at which the instrument would be put, represented as a percent of par. Only for final redemption. |
|
firstCallPrice |
decimal |
|
The first call price on which bonds may be called for redemption by the Issuer under the Optional Redemption feature. This field is applicable only for cash call option. |
|
firstCallablePaymentDate |
date |
|
The first date on which bonds may be called for redemption by the Issuer under the optional redemption feature. This field is applicable only for cash call option. |
|
firstCouponDate |
date |
|
Date on which the first coupon payment is made. |
|
firstExecutionDate |
date |
|
Indicates the first date a trade may be executed for the issue. |
|
fisn |
string(100) |
|
Financial Instrument Short Name code of a security |
|
governingLaw |
string(200)[100] |
|
Indicates the applicable governing laws for the security. |
|
governmentAuctionDetails |
GovernmentAuctionDetails[1000] |
|
Refer to linked entity. |
|
greenBondType |
string(50) |
|
Indicates the type of Green Bond. |
| link |
guarantorTicker |
Organization[30] |
|
Refer to linked entity. |
|
has144ARegistrationRight |
boolean |
|
Indicates if the instrument has 144A registration rights. |
|
hasAccretion |
boolean |
|
Indicates if the instrument's value would accrete during its tenure. |
|
hasAmortization |
boolean |
|
Indicates if the instrument has an amortization feature applicable. |
|
hasCreditEnhancement |
boolean |
|
Indicates if the instrument has credit enhancement features. |
|
hasEquityClawback |
boolean |
|
Indicates if the instrument has an equity clawback option. |
|
hasExDividend |
boolean |
|
Indicates if the instrument is traded ex-dividend. |
|
hasExchangeOffer |
boolean |
|
Indicates if the instrument has an exchange offer applicabe. |
|
hasExtendedTerms |
boolean |
|
Indicates if the instrument is extendable. |
|
hasExtraordinaryCall |
boolean |
|
Indicates if the security is subject to an extraordinary call. |
|
hasLiquidityOptions |
boolean |
|
Indicates if the holder is entitled to a share in the distribution of assets in the event of liquidation. |
|
hasPik |
boolean |
|
Indicates if the instrument pays interest in kind. |
|
hasSink |
boolean |
|
Indicates if the instrument has an Sink feature applicable. |
|
hasSinkIncrease |
boolean |
|
An optional coded numeric value that indicates whether the sinking fund provision for an instrument provides for increasing the amount to be redeemed if certain conditions exist. |
|
hasSuperSinker |
boolean |
|
Indicates if the security has a super sinker. |
|
hasWarrants |
boolean |
|
Indicates if warrants are attached to the instrument at issue. |
|
holding |
string(100) |
|
An internal field to indicate if security is part of Intex. |
|
holidaySchedule |
HolidaySchedule[1000] |
|
Refer to linked entity. |
|
hqlaDetails |
HqlaDetails[1000] |
|
Refer to linked entity. |
|
imid |
string(30) |
|
S&P Global generated number unique to the obligor. |
|
inflationDetails |
InflationDetails[22000] |
|
Refer to linked entity. |
|
inflationLag |
string(50) |
|
Provides the number of inflation reporting periods between the effective period of the inflation rate and the period in which the associated determination date occurs. The default is monthly reporting periods denoted by a whole number in months. For Australia and New Zealand, periods are reported quarterly denoted by a whole number in quarters. For Latam markets, periods are reported biweekly denoted by a fractional number, for example 0.5 for Mexico. |
|
instVersion |
long |
|
Internally generated version number of each incremental update |
|
instrumentCategory1 |
string(200) |
|
Indicates the highest level category of Security Type. |
|
instrumentCategory2 |
string(200) |
|
Indicates the mid-level category of Security Type in conjunction with instrumentCategory1. |
|
instrumentCategory3 |
string(200) |
|
Indicates the detailed category of Security Type in conjunction with instrumentCategory1 and instrumentCategory2: This field indicates the mid-level categorization of Security Type in conjunction with instrumentCategory2. |
|
instrumentMarketName |
string(4000) |
|
Market name of the instrument for example Dimsum, Samurai etc. |
| link |
instrumentOidAdjustedDetails |
InstrumentOidAdjustedDetails |
|
Refer to linked entity. |
|
instrumentRatings |
InstrumentRatings[1000] |
|
Refer to linked entity. |
|
instrumentRelation |
InstrumentRelation[1000] |
|
Refer to linked entity. |
|
insuranceDetails |
InsuranceDetails[1000] |
|
Refer to linked entity. |
|
interestAccrualDate |
date |
|
Date from which interest begins to accrue. |
|
interestAccruedDayCount |
string(100) |
|
Day count convention used in the calculation of accrued interest. |
|
interestAlternativeCurrency |
string(3) |
|
Alternative currency of interest payment. Only applicable if the issuer has an option to make interest payments in another currency. Follows ISO 4217 code |
|
interestSchedule |
InterestSchedule[1000] |
|
Refer to linked entity. |
|
interpolationForCpnCalc |
string(20) |
|
Provides the interpolation method used to calculate CPI data between published monthly figures. |
|
isAaoifiCompliant |
boolean |
|
Indicates if an Islamic financial security is compliant with the standards of the Accounting and Auditing Organization for Islamic Financial Institutions (AAOIFI). |
|
isAgencyDiscount |
boolean |
|
Indicates if the security is an agency discount note. |
|
isAnnuity |
boolean |
|
Indicates if the instrument is an annuity bond. |
|
isBankQualified |
boolean |
|
Indicates if the bonds are designated as "qualified tax-exempt obligations". |
|
isBondLinked |
boolean |
|
Indicates if the instrument is linked to the performance of another bond. |
|
isBullet |
boolean |
|
Indicates if the instrument has a normal maturity type and no early redemption. |
| filter_list |
isCallable |
boolean |
= |
Indicates if the instrument has a call feature. |
|
isCapitalization |
boolean |
|
Indicates if the security contains a capitalization feature. |
|
isChill |
boolean |
|
Indicates if the settlement of a security has been blocked. Yes, indicates that the security in question has been placed in a 'chill' status. |
|
isCleanupCall |
boolean |
|
Indicates if a cleap-up call is applicable for the security. |
|
isCommodityLinked |
boolean |
|
Indicates if the instrument is linked to the performance of a commodity index or specific physical commodity. |
|
isComplexFloater |
boolean |
|
Indicates if the interest calculation of an instrument is linked with complex formula. |
|
isConvertibleOrExchangeable |
string(100) |
|
Indicates the instrument may be exchanged or converted into another type of security. |
|
isCorridor |
boolean |
|
Indicates if the instrument has both maximum and minimum interest rates specified. |
|
isCouponCumulative |
boolean |
|
Indicates if the interest/coupon is cumulated. |
|
isCouponDeferrable |
boolean |
|
Indicates whether a coupon payment associated with the specific interest period can be deferred. |
|
isCovered |
boolean |
|
Indicates if the instrument backed by any collateral. |
|
isCurrencyLinked |
boolean |
|
Indicates if the instrument is linked to the performance of currency rates. |
|
isDeathPut |
boolean |
|
Indicates if security is Deathput, an optional redemption feature on a fixed-income security. |
|
isDilutionProtected |
boolean |
|
Indicates if the instrument is protected from dilution. |
|
isDocumentScrubbed |
boolean |
|
Indicates if the security was updated using Document. |
|
isDualCurrency |
boolean |
|
Indicates if this is a dual currency security. |
|
isEmerging |
boolean |
|
Indicates if the instrument was issued in an emerging market. |
|
isEquityLinked |
boolean |
|
Indicates if the instrument is linked to the performance of an equity security, a basket of equity securities or an equity index. |
|
isEsg |
boolean |
|
Indicates whether a security is ESG related. |
|
isEstimatedCoupon |
boolean |
|
Indicates if the InterestSchedule.coupon is an estimated value. |
|
isEuJumbo |
boolean |
|
Indicates if the security is an EU Jumbo security. Applicable on all covered securities having total amount issued greater than 1 billion, denominated in EUR, USD, CAD. |
|
isEusdTap |
boolean |
|
Indicates if the security is complying with EUSD and is a tap issue. |
|
isExchangeListed |
boolean |
|
Indicates if the instrument is listed on an exchange. |
|
isFactorable |
boolean |
|
Indicates if the instrument is currently paying down or capitalizing on a factor basis or has the potential to pay down or capitalize on a factor basis. For for example inflation Indexed Bonds, securities with pro rata sink option, Treasury Inflation Index Linked Securities etc. |
|
isFarEligible |
boolean |
|
Indicates if the instrument is Fully Accessible Route (FAR) eligible. The Reserve Bank, in consultation with the Government of India, introduced this separate channel, for non-resident investment in Government of India dated securities with effect from April 1, 2020. |
|
isFlip |
boolean |
|
Indicates if the issuer has the option to convert the type of coupon payable during the lifetime of the bond. This differs from the usual change of coupon type occurring on a specified date in the terms and conditions. |
| filter_list |
isFloat |
boolean |
= |
Indicates if the instrument would pay a floating rate coupon during it's tenure. |
|
isFundLinked |
boolean |
|
Indicates if the instrument is linked to the performance of a fund, fund of funds or a portfolio of funds. |
|
isFunged |
boolean |
|
Indicates if the instrument has funged (merged) with another instrument. |
|
isGicFlag |
boolean |
|
Indicates whether Notes are secured by funding agreements issued by Insurance Company. |
|
isGlobal |
boolean |
|
Indicates a registered security exchanged from RegS/144A restrictions |
|
isGroupingEligiblePricing |
boolean |
|
Indicates the security is eligible for grouping purpose. Used for internal pricing purpose only. |
|
isGsac |
boolean |
|
Indicates if the type of security is Government, Agency, Corporate or Sovereign. |
|
isGsacPricing |
boolean |
|
Indicates if the type of security is Government, Agency, Corporate or Sovereign. Used for internal pricing purpose only. |
|
isGuarantee |
boolean |
|
Indicates if the instrument's interest and principal are guaranteed by another entity. |
|
isInflationAdjusted |
boolean |
|
Indicates if the instrument is inflation adjusted. |
| filter_list |
isInflationLinked |
boolean |
= |
Indicates if the instrument is linked to the performance of an inflation index. |
|
isInflationProtected |
boolean |
|
Indicates if the instrument's principal is inflation protected. |
|
isInsured |
boolean |
|
Indicates if the security is Insured againsts a specific calamity. |
|
isInterestIndexLinked |
boolean |
|
Indicates if the instrument interest is linked to the performance of an index. |
|
isInterestLinked |
boolean |
|
Indicates if the instrument is linked to the performance of interest rate, such as LIBOR, CMS, etc. |
|
isInverseFloater |
boolean |
|
Indicates if the instrument has inverse coupon structure. |
|
isMapsEligible |
boolean |
|
Indicates that a security is part of Maps 2.0 universe. |
|
isMtn |
boolean |
|
Indicates if the instrument is a medium term note. |
| filter_list |
isMuniFlag |
boolean |
= |
Indicates if a security is municipal security. |
|
isMuniIndexEligible |
boolean |
|
Indicates whether the security is part of muni index constituent. |
| filter_list |
isOffshore |
boolean |
= |
Indicates if the instrument is a Chinese offshore security. |
|
isOriginalIssueDiscount |
boolean |
|
Indices if the security is an original issue discount. |
|
isPartialTaxExempt |
boolean |
|
In the case of institutional investors, this field is marked as yes if the investment in question is subject to the partial income procedure as per Section 3(40) of the Income Tax Act or elgible for tax exemption (95%) as per Section 8b of the Corporation Tax act. |
| filter_list |
isPerpetual |
boolean |
= |
Indicates if the instrument is perpetual. |
|
isPostDetermined |
boolean |
|
Indicates if the coupon for the specific period is calculated on the interest period's end date. |
|
isPreRefunded |
boolean |
|
Indicates if the bond is pre-refunded. |
|
isPrelimFlag |
boolean |
|
Indicates if the security is a preliminary municial security. |
|
isPricedDirty |
boolean |
|
Indicates if the instrument is priced as dirty. |
|
isPricedUnit |
boolean |
|
Indicates if the instrument is priced as unit. |
|
isPricingScrubbed |
boolean |
|
Indicates if the priced security is scrubbed and reviewed. |
|
isPrincipalIndexLinked |
boolean |
|
Indicates if the instrument's principal is linked to performance of an index. |
|
isProvincialDebt |
boolean |
|
Indicates if the security is municipal and issuer outside of US. |
| filter_list |
isPuttable |
boolean |
= |
Indicates if the instrument has a put feature. |
|
isRatingsSensitive |
boolean |
|
Indicates if the instrument is sensitive to rating changes. |
|
isRedenominated |
boolean |
|
Indicates if the instrument has a redenomination feature. |
|
isRegisterSensitive |
boolean |
|
Indicates if the instrument is sensitive to registration. |
|
isRemarketed |
boolean |
|
Indicates if the asset is eligible for remarketing. A remarketing agent will usually participate in any coupon rate adjustments necessary to produce a par bid in the secondary market. If the asset is tendered for remarketing, the purchase will be executed on an interest rate adjustment date. |
|
isReoffer |
boolean |
|
Indicates if the security was reoffered. |
|
isReofferOrReopen |
string(100) |
|
Indicates if the instrument was re-offered or re-opened. |
|
isSecRegistered |
boolean |
|
Identifies whether the security is registered with the U.S. Securities & Exchange Commission (SEC). |
|
isSecuritizedPricing |
boolean |
|
Indicates the security is securitized. Used for internal pricing purpose only. |
|
isShanghaiFtz |
boolean |
|
Indicates if the instrument is a Shanghai FTZ bond. |
|
isSppi |
boolean |
|
Refer to fields sppiReason and sppiTestStatus for SPPI details. |
|
isStateTaxApplicable |
boolean |
|
Indicates if the maturity is taxable by the state where it was issued. |
|
isStepper |
boolean |
|
Indicates if the instrument has multiple coupon steps. |
|
isStrippable |
boolean |
|
Indicates if the instrument may be stripped. |
|
isTappable |
boolean |
|
Indicates if the instrument's original issued amount had increased during its tenure. |
|
isTaxCall |
boolean |
|
Indicates if the instrument has a tax call applicable. |
|
isTbill |
boolean |
|
Indicates if the instrument is treasury bill. |
|
isTermMmi |
boolean |
|
Indicates the security is long term money market instrument. |
|
isTips |
boolean |
|
Indicates if the instrument is a treasury inflation protected security. |
|
isTlac |
boolean |
|
Indicates if the security is issued by Globally Systemically Important Banks (G-SIBs) and satisfies all international standards for minimum amounts of total loss absorbing capital (TLAC). TLAC refers to additional equity and unsecured debt that G-SIBs will be required to issue beyond their existing capital requirements. |
|
isToggle |
boolean |
|
Indicates if the instrument has a toggle feature. |
|
isTotv |
boolean |
|
Indicates if the instrument is traded on trading venue |
|
isTraceEligible |
boolean |
|
Indicates if the instrument is trace eligible. |
|
isTreasury |
boolean |
|
Indicates if the instrument is treasury. |
|
isTrustPreferred |
boolean |
|
Indicates if the instrument is a trust preferred security. |
|
isYulan |
boolean |
|
Indicates if the instrument is a Yulan bond. |
| filter_list |
isin |
string(12) |
= |
Type of Identifier - International Securities Identification Number (ISIN) is a 12-digit alphanumeric code that uniquely identifies a specific security. |
|
islamicSukukDetails |
IslamicSukukDetails[1000] |
|
Refer to linked entity. |
| filter_list |
issueCountry |
string(3) |
= |
Country/territory in which the instrument was issued. Follows ISO 3166-1 alpha-3 code |
| filter_list |
issueCurrency |
string(3) |
= |
Currency in which the instrument was issued. Follows ISO 4217 code |
|
issueDate |
date |
|
Date on which the security is issued. |
|
issueName |
string(4000) |
|
Internally derived short name of an instrument based on Ticker, Coupon and Maturity. |
|
issuePriceQuoteType |
string(100) |
|
Type of quotation applicable for the issue price of the security such as Percentage of par, In Units etc. |
|
issueSize |
decimal |
|
Original amount issued at issuance. |
| filter_list |
issueSubType |
string(200) |
= |
Further describing type of an instrument, used in conjunction with issueType. |
|
issueType |
string(200) |
|
Indicates the type of an instrument for example Bond, Note, Securitized etc. |
|
issueYield |
decimal |
|
Original issue yield to maturity from the initial date of delivery for a particular bond. |
|
issueYieldType |
string(100) |
|
Indicates the type of issue yield. |
| link |
issuer |
Organization |
= |
Refer to linked entity. |
| filter_list |
issuerBrsId |
string(200) |
= |
Indicates the value of associated Issuer's brs id. |
|
issuerLongName |
string(1000) |
|
The Issuer's Long name as per the CUSIP feed. |
|
issuerShortName |
string(1000) |
|
Issuer's Short name as per the CUSIP feed. |
|
italianId |
string(50) |
|
Italian Id of the security. |
|
japaneseDomesticCode |
string(9) |
|
Japanese local domestic code for the security. |
|
lagUnit |
string(1) |
|
Provides the time measurement unit used for inflation lag, indicating whether the lag is expressed in Months or Quarters. |
|
lastChangeDate |
dateTime |
|
Date and time on which this instrument entity was last changed. |
|
latestCoupon |
decimal |
|
Latest interest rate for the security. |
|
lifeMaxCoupon |
decimal |
|
Maximum coupon applicable for an instrument during its tenure. For inflation linked securities, this would reflect the maximum indexation factor allowed for the security. |
|
lifeMinCoupon |
decimal |
|
Minimum coupon applicable for an instrument during its tenure. For inflation linked securities, this would reflect the minimum indexation factor allowed for the security. |
|
localCode |
string(100)[100] |
|
Local code for the security. |
|
luxemburgId |
string(50) |
|
Luxemburg Id of the security. |
|
malaysianId |
string(50) |
|
Malaysian Id of the security. |
|
marketClassification |
string(100) |
|
Geographical region in which the bond is issued for example G-20, G-7 etc. |
|
marketRegion |
string(100) |
|
Geographical region in which the bond is issued for example A, N, MULTI, E etc. |
|
materialEventFlag |
boolean |
|
Indicates if the maturity has any material events associated with it. |
|
maturityAmount |
decimal |
|
Principal amount that would be paid at maturity. |
|
maturityAmountCav |
decimal |
|
Indicates the compunded accreted value of a bond on the maturity date. |
| filter_list |
maturityDate |
date |
=< >= |
Date on which the security would mature and become inactive. |
|
maturityPrice |
decimal |
|
Price of the instrument at maturity. Expressed in percent of nominal value. |
|
maturityType |
string(100) |
|
Maturity type of the security. For example, perpetual or extended maturity. |
|
maturityValueOutstanding |
decimal |
|
Reflects the maturity value outstanding for Municipal Capital Appreciation Bonds, as calculated from AmountDetails. If no Corporate Action events have occurred yet, this field will reflect the Maturity Value of the security as published on the Official Statement. If Corporate Action events have occurred, this field will reflect the maturity value calculated as of the max of effective date of Corporate Action event which is less than or equal to system date in AmountDetails. |
|
maxProgramSize |
decimal |
|
Maximum amount which could be issued, including a tap issue. |
|
mifidDetails |
MifidDetails[1000] |
|
Refer to linked entity. |
|
minDenomination |
decimal |
|
Minimum amount for which an instrument may be purchased or held in the secondary market. |
|
muniCallDefeasedFlag |
boolean |
|
Indicates if the optional calls are defeased for maturities that are ETM or maturities that have optional call dates before the redemption date. |
|
muniIssuanceType |
string(15) |
|
Indicates the type of bond which document obtained. |
|
newIssueScrubbed |
boolean |
|
Value to indicate the New Issue security scrubbed by NI team. This is obsolete field and no longer used. |
|
niScrubbed |
string(100) |
|
Indicates if the newly issued security has been scrubbed by NI team. |
|
norwegianId |
string(50) |
|
Norwegian Id of the security. |
|
notes |
Notes[1000] |
|
Refer to linked entity. |
|
numberOfLeadManagers |
long(0,100) |
|
Indicates the total number of lead managers associated with an instrument. |
| filter_list |
obligorBrsId |
string(200)[300] |
= |
Indicates the value/values of associated Obligor's brs id. |
|
oidTaxEligible |
boolean |
|
Indicates whether the security is OID Tax Eligible. |
|
oldAgencyCusip |
string(9) |
|
Previously used Agency CUSIP of the security. Applicable for recycled Agency CUSIP. |
|
oldAgencyIsin |
string(12) |
|
Previously used Agency ISIN of the security. Applicable for recycled Agency ISIN. |
|
origIssuePremium |
boolean |
|
Indicates if the security is issued on premium. |
|
originalDealAmount |
decimal |
|
Indicates the total offering amount of all securities/series that are offered within a single deal for Municipal Bonds. The field reflects the deal value as of the Issue Date. |
|
originalDealAmountCav |
decimal |
|
Indicates the total offering amount expressed as the compounded accreted value, of all securities/series that are offered within a single deal for Municipal Bonds. The field reflects the deal value as of the Issue Date. |
|
originalIssueDiscount |
string(100) |
|
Indicates if the security is issued at discount for GSAC universe. |
|
otherDenominations |
string(200)[100] |
|
Multiple amounts in which an instrument may be purchased or held in the secondary market in addition to minDenomination and denominationIncrease. |
|
parValue |
decimal |
|
Face value at which the issuer will redeem the instrument. |
|
paymentCategory |
string(200) |
|
Defines the coupon type of the instrument for example Fix, FLT, VAR etc. |
|
paymentCategorySubType |
string(200) |
|
Further define the coupon type of the instrument, used in conjunction with paymentCategory for example Fix - Zero Coupon, Float - Fixed Maring Over Index etc. |
|
penultimateCouponDate |
date |
|
Last coupon date prior to maturity. |
|
pikSchedule |
PikSchedule[1000] |
|
Refer to linked entity. |
|
preferredStockDetails |
PreferredStockDetails[1000] |
|
Refer to linked entity. |
|
preferredStockFlag |
boolean |
|
Indicates if the security is a preferred stock. |
|
priceAtIssue |
decimal |
|
Price at which the instrument was issued. |
|
priceType |
string(100) |
|
Indicates if the security is priced clean, dirty or flat. |
|
primaryExchange |
string(100) |
|
Indicates the Primary Exchange MIC. |
|
primaryExchangeCountry |
string(500) |
|
Indicates Primary Exchange Country/territory. |
|
principalDetails |
PrincipalDetails[1000] |
|
Refer to linked entity. |
|
principalFactorDetails |
PrincipalFactorDetails[1000] |
|
Refer to linked entity. |
|
principalValueAtConversion |
decimal |
|
Principal Value at conversion date for CAB Convertible Bonds. |
|
privatePlacementNumber |
string(9) |
|
Private Placement Number of the security. |
|
programId |
string(100) |
|
Program identifier under which the security was issued. |
|
programIsin |
string(20) |
|
Program ISIN of the security. |
|
project |
string(500) |
|
Project name of the issue/maturity. Applicable for Municipal securities. |
|
putExecutionDate |
date |
|
Date on which the issuer would exercise the put option. Applicable only for full redemption. |
|
putNoticeDate |
date |
|
Date on which notice has been submitted to exercise the put option. |
|
putSchedule |
PutSchedule[1000] |
|
Refer to linked entity. |
|
reallowanceConcessionPerDebt |
decimal |
|
A discount offered by the underwriter(s) that may be paid by an underwriter or a dealer to another dealer if the underwriter wishes to resell the securities. Expressed in percentage form. |
|
recordQuality |
string(100) |
|
Indicates if the terms for the security are final or indicative. Describes the document used to complete the record such as Prospectus, Term Sheet etc. |
|
redenominationDetails |
RedenominationDetails[1000] |
|
Refer to linked entity. |
|
registerMaxCouponIncrease |
decimal |
|
Maximum coupon applicable for an instrument if Issuer does not opt for registering an issue with the Securities Exchange Commission (SEC). |
|
registerSensitiveDetails |
RegisterSensitiveDetails[1000] |
|
Refer to linked entity. |
|
registrationDays |
decimal |
|
The number of days allowed for registering an issue with the Securities Exchange Commission (SEC) by the issuer. |
|
registrationSensitiveGracePeriod |
decimal |
|
Specifies how long the registration sensitive grace period appicable for. |
|
regulationDetails |
RegulationDetails |
|
Refer to linked entity. |
|
remarketingDetails |
RemarketingDetails[1000] |
|
Refer to linked entity. |
|
reofferPrice |
decimal |
|
Price at which the instrument is issued to Investor by Underwriter. |
|
reofferYield |
decimal |
|
The yield at date when the security was reoffered (if applicable). |
|
reofferedDate |
date |
|
The date at which the security was reoffered (if applicable). |
|
saleDate |
date |
|
A date on which the bonds are slated to sell for competitive issues or awarded the issue. |
|
scheduledMaturityDate |
date |
|
Date on which the security is expected or scheduled to mature. |
|
seIssuerName |
string(4000) |
|
Indicates the Issue's name as per the document. |
|
secId |
long |
|
EDI internal identifier for security |
|
secondCouponDate |
date |
|
Date on which the second interest payment is made. |
|
secondarilyInsuredFlag |
boolean |
|
Indicates if the security is Secondarily Insured. |
|
securityCode |
string(500) |
|
A code denoting the type of assets that will pay the debt service (e.g. General Obligation Bonds, Public Improvement Bonds, Revenue Bonds, etc.). |
| filter_list |
securityId |
string(100) |
= |
The unique security identifier created by S&P Capital IQ. |
|
sedolDetails |
SedolDetails[1000] |
|
Refer to linked entity. |
|
sellingConcessionPerDebtSecurity |
decimal |
|
The amount of commissions per debt or unit to be paid to the selling group of underwriters in a public offering. It is a component of the gross spread, which is negotiated between issuer and managing underwriter. |
|
seriesCode |
string(100) |
|
Indicates the Series Code of maturities within a particular issue. |
|
seriesNumber |
string(100) |
|
Series number as per the prospectus. |
|
seriesSize |
decimal |
|
Par amount of the current series. |
|
settlementDate |
date |
|
Date on which the security would be settled. |
|
settlementDateStatus |
string(100) |
|
Indicates the settlement date status. |
|
settlementDaysType |
string(100) |
|
Number of days between transaction/trade date and settlement date. |
|
sfcChapter37 |
boolean |
|
Signifies if the debt security is issued to Professional Investors only as per The Securities and Futures Commission (SFC - an independent statutory body which regulates Hong Kong's securities and futures markets) |
|
sfcComplexFlag |
boolean |
|
Signifies if the security is complex as per The Securities and Futures Commission (SFC - an independent statutory body which regulates Hong Kong's securities and futures markets) |
|
sfcComplexFlagReason |
string(100) |
|
Reason associated with the security marked as 'true' for SFC Complex flag. Used in conjunction with sfcComplexFlag field. |
|
sicovam |
string(6) |
|
Identifier used for French securities. |
|
sinkDefeasedFlag |
boolean |
|
Indicates whether the sinking fund is defeased for maturities that are ETM or maturities that have optional call dates before the redemption date. |
|
sinkSchedule |
SinkSchedule[1000] |
|
Refer to linked entity. |
|
snpMaturityId |
string(20) |
|
Unique identifier for a rated security |
|
softBullet |
boolean |
|
Indicates if the security is soft bullet. |
|
source |
string(30)* |
|
Source from which the Instrument record was last updated. |
|
sourceIssuerName |
string(1000) |
|
Indicates the issuer name from source |
|
sourceOfRepayment |
string(500) |
|
Code specifying the source of funds used for repayment. |
|
spanishId |
string(50) |
|
Spanish Id of the security. |
|
specialMandatoryCall |
string(100) |
|
Code indicating the special mandatory call terms. |
|
specialMandatoryCallCode |
string(500) |
|
A code indicating the special mandatory call terms if applicable. |
|
specialOptionalCall |
string(100) |
|
Code indicating the special optional call terms. |
|
specialOptionalCallCode |
string(500) |
|
A code indicating the special optional call terms if applicable. |
|
sppiReason |
string(80) |
|
The reason associated with an instrument's Fail, Pass or Further Assessment level required for SPPI classification. This is used in conjunction with field sppiTestStatus. |
|
sppiTestStatus |
string(50) |
|
Indicates if the instrument is passing or failing the SPPI test as per IFRS 9. |
|
stateCode |
string(100) |
|
Represents the state where the issuer of the municipal security is located. |
|
stateCode1 |
string(100) |
|
Represents the state where the issuer of the municipal security is located. In case of multi-state issue this will be populated. |
|
stateCode2 |
string(100) |
|
Represents the state where the issuer of the municipal security is located. In case of multi-state issue this will be populated. |
|
statusHistory |
StatusHistory[1000] |
|
Refer to linked entity. |
|
statusIndicator |
string(100) |
|
Indicates if the security's status is Deleted. |
|
statusSubType |
string(200) |
|
Further describing the status of instrument, used in conjunction with status for example value - Issued, Matured, Reopen, To be issued etc. |
| filter_list |
statusType |
string(200) |
= |
Defines the status of instrument for example Active, Inactive etc. |
|
streetTicker |
string(100) |
|
Internally generated ticker that may relate to how the issuer is identified in the market |
|
streetTickerSource |
string(100) |
|
Indicates the source of street ticker |
|
structuredNoteFlag |
boolean |
|
Indicates if the security is structured note. |
|
svm |
string(8) |
|
Identifier used for Belgian securities. |
|
swedishId |
string(50) |
|
Swedish Id of the security. |
|
syndicatedIssuanceIndicator |
boolean |
|
Indicates syndicated issuance. |
|
taxDetails |
TaxDetails[1000] |
|
Refer to linked entity. |
|
taxStatus |
string(100) |
|
Indicates if the municipal instrument is subject to federal or alternative minimum tax or if it is tax exempt. |
|
tenderOfferSchedule |
TenderOfferSchedule[1000] |
|
Refer to linked entity. |
|
termOrSerialMaturityType |
string(100) |
|
Indicates whether a issue is has a Term or Serial Maturity. |
|
termToMaturity |
long |
|
Duration of the security from issue date to maturity date in days. |
| filter_list |
tier |
string(100) |
= |
Defines the ranking struture of the instrument that is used by an issuer to prioritzie debt payout. |
|
toggleSpread |
decimal |
|
Spread above the prevailing interest rate. Applicable only to toggle notes. |
|
totalAmountIssued |
decimal |
|
Defines the total amount issued by an issuer during the life cycle of the bond. |
|
tradingAndSellingRestrictionDetails |
TradingAndSellingRestrictionDetails[1000] |
|
Refer to linked entity. |
|
tradingFlatFlag |
boolean |
|
Indicates that bond is trading without accrued interest. |
|
tranche |
string(50) |
|
Tranche of the security. |
|
underlyingDetails |
UnderlyingDetails[1000] |
|
Refer to linked entity. |
|
useOfProceeds |
string(500) |
|
Code indicating how the money will be spent (housing, general, pcr, idr, etc.). |
|
useOfProceedsSubtype |
string(500) |
|
Indicates in detail how the money will be spent example on housing, general, pcr, idr etc |
|
valoren |
string(20) |
|
Identifier used for Swiss securities. |
|
vendorId |
string(30) |
|
This is a vendor provided identifier used to identify a particular security. |
|
warrantDetails |
WarrantDetails[1000] |
|
Refer to linked entity. |
|
whenIssued |
date |
|
The date when the security is whenIssued |
|
wkn |
string(6) |
|
Wertpapier of the security. |