| key |
id |
string(250)* |
= |
The id field uniquely identifies the entity record. |
|
aggregatedMarketValue |
long(-9223372036854775807,9223372036854775806) |
|
The total current valuation of fixed income securities held by funds or firms investing in a given issuer's securities, expressed in USD and grouped by owner type. This metric offers a comprehensive view of the total value of investments based on their issuing currency across different owner types, which is vital for accurate financial analysis and reporting. |
|
aggregatedMarketValueIssueCurrency |
long(-9223372036854775807,9223372036854775806) |
|
The total current valuation of fixed income securities held by funds or firms investing in a given issuer's securities, expressed in the currency of the securities and grouped by owner type. This metric offers a comprehensive view of the total value of investments based on their issuing currency across different owner types, which is vital for accurate financial analysis and reporting. |
|
aggregatedParHeld |
long(-9223372036854775807,9223372036854775806) |
|
The total par value of a specific security grouped by the owner type of its holders at a given calendar quarter end date in USD. It aggregates the par holdings across different owner types to provide an overview of investment distribution. |
|
aggregatedParHeldIssueCurrency |
long(-9223372036854775807,9223372036854775806) |
|
The total par value of a specific security grouped by the owner type of its holders at a given calendar quarter end date in USD. It aggregates the par holdings across different owner types to provide an overview of investment distribution. |
|
aggregatedParHeldPercentage |
decimal{9,6} |
|
The proportion of the total par value of a specific security grouped by the owner type of its holders at a given calendar quarter end date. It calculates the percentage distribution of par holdings across different owner types. This measure provides insight into the relative investment distribution among various owner types for the specified period. |
|
aggregatedStandardizedMarketValue |
decimal{32,4} |
|
The normalized market value of fixed income securities in USD aggregated by the owner type of its holders, facilitating comparison and analysis across different currencies and portfolios across different owner types. |
|
aggregatedStandardizedMarketValueIssueCurrency |
decimal{32,4} |
|
The normalized market value of fixed income securities in their issuing currency aggregated by the owner type of its holders, facilitating comparison and analysis across different currencies and portfolios across different owner types. |
| link |
batch |
Batch* |
= |
The batch for which this batchrun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The batchrun in which the parheld is reported. |
|
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. |
|
dateEndedStandard |
date |
|
The standardized format used to indicate the quarter end date. It provides a uniform method for documenting when an event or timeframe officially concludes. This standardization ensures accuracy and consistency across records and systems. |
|
holdersCount |
long(-2147483648,2147483647) |
|
The total number of distinct holders investing in a given company's securities grouped by investment type. It provides an overview of the number of unique investors in different investment categories for a specific calendar quarter end date. This count is crucial for understanding investor distribution and engagement. |
|
holdingInvestmentType |
string(100) |
|
The categorization of investments in a specific security based on different investment types held by its owners at a given calendar quarter end date. |
|
institutionalInvestment |
boolean |
|
The value indicates whether an owner type is classified as an institutional investor or not. |
|
institutionalOwnerParHeldPercentage |
decimal{9,6} |
|
The proportion of the total par value of all fixed income securities issued by a specific issuer that is held by institutional investors at a given calendar quarter-end date. It calculates the percentage distribution of holdings specifically attributed to institutional owner types, providing insight into the investment landscape. |
|
isDeleted |
boolean |
|
Indicates whether the row is (logically) deleted or not. |
|
keyHoldingInvestmentType |
long(-32768,32767) |
|
The MI identifier for the holding investment type value. |
|
lastModifiedDateTime |
dateTime* |
|
Last modification date and time of a physical row in UTC timezone. |
|
latestFlag |
boolean |
|
The aggregate calculations in the table are made based on the latest available active portfolio only in which case the value will be true. If the calculations are made based on historical portfolios the value will be false. |
|
miKeyCurrency |
string(3) |
|
A unique identifier(3 character ISO code) 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. |