Type FixedIncomeOwnershipCompanyHoldings
Type category Entity
Description The Fixed Income Ownership Company Holdings provides a comprehensive view of all Fixed Income Ownership Positions held by Firms at the individual Security level. This detailed dataset includes critical information such as the currency of the holdings, holding dates, the Par Value held, and the corresponding market values.
Fields
Name Type Filters Description
key id string(100)* = The id field 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.
annualHoldingChangeFromDate date 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(-2147483648,2147483647) 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 identifier is crucial for linking firms with their respective investment holdings and performance data.
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.
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 firms 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.
filingDate date The latest date on which any of the underlying funds of a specific firm has filed a given fixed income security. At the firm level, this date is determined by identifying the maximum filing date among all the funds that have reported the security within the relevant reporting period of two years.
fundCounts long(-32768,32767) The number of distinct funds managed by a specific firm that have invested in a given security as of a specific reporting period. This metric helps quantify the breadth of investment interest in the security across the firm's fund portfolio.
groupId long(-2147483648,2147483647) A unique identifier assigned to each group within Orion database. It facilitates the tracking and management of group-specific information related to fixed income securities. This identifier is crucial for linking groups and their respective firms with the investment holdings and performance data.
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 for the fixed income security. This date is essential for assessing investment duration.
holdingPositionChange string(100) The nature of the change in a firm’s holding of a given security as of a specific reporting period. It reflects the firm’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 a firm. 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 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) 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 firms with their investment holdings and performance metrics.
miKeyInstn long(-2147483648,2147483647) A unique identifier for firms in the MI 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(-9223372036854775807,9223372036854775806) The nominal or face value of fixed income securities held by a firm 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 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(-9223372036854775807,9223372036854775806) The variation in the nominal or face value of fixed income securities held by funds over a specified period in the native 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 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 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 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 firm. 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.
40 rows of 40 total
API Open API Specification