| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
|
activePortfolio |
boolean |
|
The Active Portfolio determines whether the position corresponds to an active security with a holding to date within the last 2 years and included in the most recent portfolio of investments in which case the value will be true. In any other case the flag will be false. |
|
amountOutstandingIssueCurrency |
long |
|
The amountOutstandingIssueCurrency field represents the total outstanding amount of a fixed income security, expressed in the currency of the issued instrument. It indicates the total value of the security that remains to be repaid to the bondholders. |
|
annualHoldingChangeFromDate |
date |
|
The Annual Holding Change From Date measures the change in the nominal or face value of a fixed income security held by a firm over a one-year period starting from a specified date. It captures how the holding amount has increased or decreased within the annual cycle. This metric is crucial for assessing yearly investment adjustments and portfolio performance. |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the ParHeld is reported. |
|
ciqCompanyId |
long |
|
The CIQ Company ID is a unique identifier assigned to each firm within the CIQ Database. It facilitates the tracking and management of firm-specific information related to fixed income securities. This ID is crucial for linking firms with their respective investment holdings and performance data. |
|
ciqCurrencyId |
long |
|
The CIQ Currency ID is a unique identifier used to denote a specific currency in the CIQ Database. It allows for precise tracking and management of currency details related to fixed income securities investments. This ID is essential for accurate currency-based financial analysis. |
|
ciqSecurityId |
long |
|
The CIQ Security ID is a unique identifier for each security in the CIQ Database. It is used to track and manage individual fixed income securities ensuring accurate data aggregation and analysis. This ID is essential for linking securities to their respective firms and portfolios. |
|
ciqTradingItemId |
long |
|
The CIQ Trading Item ID is a unique identifier for trading items in the CIQ Database including fixed income securities. It facilitates the tracking and management of trading activities related to specific securities. This ID is crucial for detailed analysis of trading patterns and positions. |
|
holderRank |
long |
|
The Holder Rank ranks the significance or position of a holder in relation to the total holdings of fixed income securities. It reflects the relative importance of the holder based on their investment size or value. This ranking helps in understanding the influence of different holders within a portfolio. |
|
holdingFromDate |
date |
|
The Holding From Date represents the beginning of the holding period for the fixed income security. This date is essential for assessing investment duration. |
|
holdingRank |
long |
|
The Holding Rank is a metric that ranks the significance or size of a particular fixed income security within a portfolio. It reflects the relative importance of the security based on factors such as value or proportion of the total holdings. This ranking aids in investment decision-making and portfolio management. The higher the par held the lower the rank. |
|
holdingToDate |
date |
|
The Holding To Date denotes the holding period date of a fixed income security in the portfolio of a firm. This date is crucial for portfolio analytics and assessing investment duration. |
|
isDeleted |
boolean |
|
Indicates whether the row is (logically) deleted or not. |
|
lastModifiedDateTime |
dateTime* |
|
Last modification date and time of a physical row in UTC timezone. |
|
marketValue |
long |
|
The Market Value represents the current value of a fixed income security based on market conditions and prices in USD. It reflects the price at which the security could be traded or sold in the market. This value is essential for portfolio valuation and investment performance assessment. |
|
marketValueChange |
long |
|
The Market Value Change denotes the difference in the market value of a fixed income security over a specified period in USD. It tracks how the value has increased or decreased due to market fluctuations. This change is important for evaluating performance and investment impacts. |
|
marketValueIssueCurrency |
decimal{28,8} |
|
The Market Value Issue Currency specifies the currency in which the market value of a fixed income security is denominated. It provides context for the valuation and conversion of securities based on their issuing currency. This detail is crucial for accurate financial analysis and reporting. |
|
miKeyCurrency |
string(3) |
|
The MI Key Currency is a unique identifier for currencies used in the Market Intelligence Database. It helps track and manage currency-specific information related to fixed income securities. This key is essential for accurate currency conversion and financial analysis. |
|
miKeyFndg |
long |
|
The MI Key Fndg is a unique identifier for Securities within the Market Intelligence Database. It facilitates tracking and management of specific details related to fixed income securities. This key is crucial for linking firms with their investment holdings and performance metrics. |
|
miKeyInstn |
long |
|
The MI Key Instn is a unique identifier for firms in the Market Intelligence Database. It is used to manage and track firm investment details related to fixed income securities. This key aids in associating firms with their investment activities and holdings. |
|
parHeld |
long |
|
The Par Held represents the nominal or face value of fixed income securities held by a firm in USD. It indicates the amount of the security's principal that is currently owned. This metric is important for assessing the total value of holdings and portfolio composition. |
|
parHeldChange |
long |
|
The Par Held Change tracks the variation in the nominal or face value of fixed income securities held by a firm over a specified period in USD. It measures how the amount of securities held has increased or decreased. This change is important for evaluating adjustments in portfolio positions. |
|
parHeldChangeIssueCurrency |
long |
|
The Par Held Change Issue Currency tracks the variation in the nominal or face value of fixed income securities held by funds over a specified period in the native currency referred by ciqCurrencyId or MiKeyCurrency field of the security. It provides context for understanding adjustments in holdings based on the issuing currency. This detail is crucial for accurate financial reporting and analysis. |
|
parHeldChangePercentage |
decimal{20,6} |
|
The Par Held Change Percentage measures the percentage change in the nominal or face value of fixed income securities held over a specified period. It tracks how the amount held has increased or decreased relative to the previous value. This percentage is crucial for assessing changes in investment positions. |
|
parHeldIssueCurrency |
long |
|
The Par Held Issue Currency denotes the nominal or face value of fixed income securities based on the currency in which the security is denominated. It is used to track and manage the value of holdings in terms of their issuing currency referred by ciqCurrencyId field. |
|
portfolioWeightPercentage |
decimal{9,6} |
|
The Portfolio Weight Percentage indicates the proportion of a fixed income security's value relative to the total value of the portfolio. It shows how much weight the security holds within the overall investment portfolio. This percentage is vital for understanding asset allocation and investment concentration. |
|
standardPortfolioWeightPercentage |
decimal{9,6} |
|
The Standard Portfolio Weight Percentage represents the standardized proportion of a fixed income security's value within a portfolio adjusted for comparison across different portfolios. It allows for consistent analysis and benchmarking of portfolio allocations. This percentage aids in performance evaluation and strategic planning. |
|
standardizedMarketValue |
decimal{32,4} |
|
The Standardized Market Value refers to the market value of fixed income securities adjusted for consistency and comparability across different portfolios or firms in USD. It normalizes values to facilitate benchmarking and comparative analysis. This metric is important for evaluating relative investment performance. |
|
standardizedMarketValueIssueCurrency |
decimal{32,4} |
|
The Standardized Market Value Issue Currency refers to the market value of fixed income securities adjusted for consistency and comparability across different portfolios or firms, expressed in the respective issuing currency. It normalizes values to facilitate benchmarking and comparative analysis across various currencies, making it essential for evaluating relative investment performance. |
|
totalDebtOutstandingPercentage |
decimal{19,6} |
|
The Total Debt Outstanding Percentage represents the proportion of a fixed income security's total debt that is currently outstanding. It indicates the amount of debt relative to the total debt issued. This percentage is crucial for assessing the issuer's debt levels and financial health. |
|
totalParHeldPercent |
decimal{9,6} |
|
The Total Par Held Percent denotes the percentage of the total nominal or face value of fixed income securities held by a firm. It reflects the proportion of the security's face value relative to the total holdings. This percentage is important for understanding portfolio concentration. |
|
yearToYearMarketValueChange |
long |
|
The Year To Year Market Value Change measures the change in the market value of fixed income securities from one year to the next in USD. It tracks how the value has increased or decreased over the annual period. This metric is important for assessing long-term performance and market trends. |
|
yearToYearParHeldChange |
long |
|
The Year To Year Par Held Change denotes the variation in the nominal or face value of fixed income securities held from one year to the next in USD. It reflects how the amount of securities held has changed over the annual period. This change is crucial for evaluating long-term portfolio adjustments. |
|
yearToYearParHeldChangeIssueCurrency |
long |
|
The Year To Year Par Held Change Issue Currency tracks the change in the nominal or face value of fixed income securities held from one year to the next denominated in the issuing currency. It reflects the annual variation in holdings adjusted for currency. This metric is important for evaluating long-term investment changes and currency impacts. |