| 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 issuers 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. |
|
aggregatedParHeld |
long(-9223372036854775807,9223372036854775806) |
|
The total par value of a specific security grouped by the calculated debt capitalization emphasis of its holders at a given calendar quarter end date in USD. It aggregates the par holdings across different debt capitalization 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 debt capitalization emphasis of its holders at a given calendar quarter end date. It calculates the percentage distribution of par holdings across different debt capitalization types. This measure provides insight into the relative investment distribution among various debt capitalization 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. |
|
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. |
|
debtCapitalizationGroupType |
string(100) |
|
The debt capitalization emphasis for a given security. It groups debt held by a particular holder based on the type of capitalization approach such as senior or subordinated debt. |
|
holdersCount |
long(-2147483648,2147483647) |
|
The total number of distinct holders investing in a given company's securities grouped by debt capitalization emphasis. It provides an overview of the number of unique investors in different debt capitalization categories for a specific calendar quarter end date. This count is crucial for understanding investor distribution and engagement. |
|
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. |
|
keyCurrency |
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. |
|
keyDebtCapitalizationGroupType |
long(-32768,32767) |
|
The identifier for the debt capitalization group type value. |
|
keyFndg |
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. |
|
lastModifiedDateTime |
dateTime* |
|
Last modification date and time of a physical row in UTC time zone. |
|
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. |
|
securityId |
long(-2147483648,2147483647) |
|
Unique identifier created by S&P Global for securities. 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. |