| key |
id |
string(250)* |
= |
The id field uniquely identifies the entity record. |
| 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 fund or 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. |
|
dateEndedStandard |
date |
|
The Date Ended Standard refers to 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 Group Type categorizes 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. |
|
fiAssetsMarketValue |
long |
|
The Fixed Income Assets Market Value at the holder level represents the current total market valuation of all fixed income securities held by a specific investor or holder. This value reflects the price at which these securities can be sold in the market, providing crucial information for assessing the worth of fixed income investments within that holder's portfolio and their contribution to overall investment performance. |
|
fiAssetsStandardizedMarketValue |
decimal{32,4} |
|
The Fixed Income Assets Standardized Market Value at the holder level represents the normalized total market valuation of all fixed income securities held by a specific investor or holder, adjusted for consistency and comparability across different portfolios or funds. This value facilitates benchmarking and comparative analysis, providing essential insights into the worth of fixed income investments within that holder's portfolio and their contribution to overall investment performance. |
|
holderTurnOverStyle |
string(100) |
|
The Holder Turn Over Style represents the trading turnover style of investors for a particular security. It categorizes the frequency and style of trading activities of a particular holder for a specific Calendar Quarter End Date. |
|
isDeleted |
boolean |
|
Indicates whether the row is (logically) deleted or not. |
|
keyDebtCapitalizationGroupType |
long |
|
The Key Debt Capitalization Group Type determines the Primary Key of the debt based on capitalization emphasis. It provides a breakdown of debt types for a particular holder in a specific Calendar Quarter End Date. |
|
keyHolderTurnOverStyle |
long |
|
The Key Holder Turn Over Style determines the Primary Key of the turnover style of holders. It categorizes trading styles and frequencies of each holder for a specific Calendar Quarter End Date. |
|
lastModifiedDateTime |
dateTime* |
|
Last modification date and time of a physical row in UTC timezone. |
|
latestFlag |
boolean |
|
The Latest Flag determines whether the aggregate calculations from the table were made based on the latest available active portfolio only in which case the value will be true. If the calculations were made based on historical portfolios the value will be false. |
|
miKeyInstn |
long |
|
The MI Key Instn is a unique identifier for funds and 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. |
|
portfolioTurnOverRatio |
decimal{9,6} |
|
The Portfolio Turnover Ratio measures the frequency at which assets within a portfolio are bought and sold over a specific period, indicating the level of trading activity. A higher ratio suggests a more actively managed portfolio, while a lower ratio indicates a more passive investment strategy. |