| key |
id |
string(100)* |
= |
Uniquely identifies the entity record. |
|
activePortfolio |
boolean |
|
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(-9223372036854775807,9223372036854775806) |
|
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. |
| link |
batch |
Batch* |
= |
The batch for which this batchrun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The batchrun in which the parheld is reported. |
|
ciqCurrencyId |
long(-2147483648,2147483647) |
|
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 identifier is essential for accurate currency-based financial analysis. |
|
ciqFundId |
long(-2147483648,2147483647) |
|
A unique identifier assigned to each Fund within the CIQ database. It facilitates the tracking and management of fund-specific information related to fixed income securities. This identifier is crucial for linking funds with their respective investment holdings and performance data. |
|
ciqSecurityId |
long(-2147483648,2147483647) |
|
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 identifier is essential for linking securities to their respective funds and portfolios. |
|
ciqTradingItemId |
long(-2147483648,2147483647) |
|
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 identifier is crucial for detailed analysis of trading patterns and positions. |
|
holderRank |
long(-2147483648,2147483647) |
|
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 beginning of the holding period of the fixed income security. This date is essential for assessing investment duration. |
|
holdingPositionChange |
string(100) |
|
The nature of the change in a fund’s holding of a given security as of a specific reporting period. It reflects the fund’s investment action compared to the previous period and helps interpret the masked value of the Keys. The allowable values for this field are: 2 = Decreased, 4 = Increased, 8 = New, 16 = Sold Out, 24 = New + Sold Out, 32 = Unchanged. These values indicate whether the position has Increased, Decreased, is New, has been Exited (Sold Out), is a combination of New + Sold Out, or remains Unchanged. |
|
holdingRank |
long(-2147483648,2147483647) |
|
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 period date of a fixed income security in the portfolio of the fund. This date is crucial for portfolio analytics and assessing investment duration. |
|
isDeleted |
boolean |
|
The row is (logically) deleted or not. |
|
lastModifiedDateTime |
dateTime* |
|
Date and time of a physical row when last modified in UTC timezone. |
|
marketValue |
long(-9223372036854775807,9223372036854775806) |
|
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(-9223372036854775807,9223372036854775806) |
|
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 current valuation of a fixed income security held by funds investing in a given issuers securities in the currency of the security. 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) |
|
A unique identifier for currencies used in the MI 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(-2147483648,2147483647) |
|
A unique identifier for securities within the MI database. It facilitates tracking and management of specific details related to fixed income securities. This key is crucial for linking funds with their investment holdings and performance metrics. |
|
miKeyInstn |
long(-2147483648,2147483647) |
|
A unique identifier for funds in the MI database. It is used to manage and track fund investment details related to fixed income securities. This key aids in associating funds with their investment activities and holdings. |
|
paId |
long(-9223372036854775807,9223372036854775806) |
|
A unique identifier created for the specific use case of portfolio analytics. |
|
paToDate |
date |
|
The next holdingtodate minus 1 date for any funding holding indicating the continuous series of holding data of funds. This is specific to portfolio analytics use case. |
|
parHeld |
long(-9223372036854775807,9223372036854775806) |
|
The nominal or face value of fixed income securities held by a fund in USD. It indicates the amount of the securitys principal that is currently owned. This metric is important for assessing the total value of holdings and portfolio composition. |
|
parHeldChange |
long(-9223372036854775807,9223372036854775806) |
|
The variation in the nominal or face value of fixed income securities held by a fund 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(-9223372036854775807,9223372036854775806) |
|
The variation in the nominal or face value of fixed income securities held by funds over a specified period in the currency 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 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(-9223372036854775807,9223372036854775806) |
|
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. |
|
portfolioWeightPercentage |
decimal{9,6} |
|
The proportion of a fixed income securitys 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 standardized proportion of a fixed income securitys 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 market value of fixed income securities adjusted for consistency and comparability across different portfolios or funds 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 market value of fixed income securities adjusted for consistency and comparability across different portfolios or funds 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 proportion of a fixed income securitys 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 issuers debt levels and financial health. |
|
totalParHeldPercent |
decimal{9,6} |
|
The percentage of the total nominal or face value of fixed income securities held by a fund. It reflects the proportion of the securitys face value relative to the total holdings. This percentage is important for understanding portfolio concentration. |
|
yearToYearMarketValueChange |
long(-9223372036854775807,9223372036854775806) |
|
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(-9223372036854775807,9223372036854775806) |
|
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(-9223372036854775807,9223372036854775806) |
|
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. |