| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
|
activePositionFlag |
boolean |
|
The Active Position Flag determines whether the position corresponds to an active issuer 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. |
|
annualHoldingChangeFromDate |
date |
|
The Annual Holding Change From Date tracks the change in the nominal or face value of fixed income securities held by firms over a one-year period from a specified start date. It provides insights into the investment changes within the annual cycle. This metric is crucial for analyzing yearly investment performance. |
|
assetType |
string |
|
The Asset Type categorizes the nature of fixed income securities held by funds such as bonds notes or other debt instruments. It defines the type of assets within the portfolio. This classification is important for analyzing portfolio composition and investment strategy. C- Cash O-Other D-Debt are the asset types which are denoted using these notations. |
| 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 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. |
|
ciqCompanyIdIssuer |
long |
|
The CIQ Company ID Issuer is a unique identifier for the issuer company within the Capital IQ Database used to track investments in their fixed income securities. It ensures accurate identification of the issuer for data management and analysis. This ID is important for linking investment data to the issuer. |
|
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. |
|
holderRank |
long |
|
The Holder Rank represents the relative position or significance of a firm's holding in a given issuer's fixed income securities within the overall investment landscape. It indicates the prominence of the firm's investment compared to others. This ranking is crucial for evaluating the influence and size of holdings. |
|
holdingFromDate |
date |
|
The Holding From Date denotes the beginning of the holding period of a firm's investment in a given issuer's combined fixed income securities. This date is essential for assessing investment duration. |
|
holdingToDate |
date |
|
The Holding To Date specifies the holding period date of a firm's investment in a given issuer's fixed income securities. This date is crucial for portfolio analytics and assessing investment duration. |
|
isDeleted |
boolean |
|
Indicates whether the row is (logically) deleted or not. |
|
lastModifiedDateTime |
dateTime* |
|
Last modification date and time of a physical row in UTC timezone. |
|
marketValue |
long |
|
The Market Value is the current valuation of a fixed income security held by firms investing in a given issuer's securities. It reflects the price based on current market conditions in USD. This value is crucial for assessing the real-time worth of the securities within the investment portfolio. |
|
marketValueChange |
long |
|
The Market Value Change measures the variation in the market value of a fixed income security over a specified period in USD. It captures how the value has fluctuated due to market conditions. This change is essential for tracking investment performance and volatility. |
|
miKeyInstn |
long |
|
The MI Key Instn is a unique identifier for 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. |
|
miKeyInstnIssuer |
long |
|
The MI Key Instn Issuer is a unique identifier for issuers within the Market Intelligence Database. This key is important for detailed analysis of investments by issuer. |
|
parHeld |
long |
|
The Par Held represents the nominal or face value of fixed income securities held by firms investing in a given issuer’s combined securities in USD. It indicates the total amount of the security’s face value that is currently held. This metric is crucial for understanding the scale of investment in terms of nominal value. |
|
parHeldChange |
long |
|
The Par Held Change tracks the variation in the nominal or face value of fixed income securities held by firms over a specified period in USD. It shows the increase or decrease in holdings. This change is important for evaluating adjustments in investment positions and their impact on the portfolio. |
|
parHeldChangePercentage |
decimal{20,6} |
|
The Par Held Change Percentage tracks the percentage change in the nominal or face value of fixed income securities held by a firm over a specified period. It shows the relative increase or decrease in holdings. This percentage is essential for analyzing changes in investment positions. |
|
portfolioWeightPercentage |
decimal{9,6} |
|
The Portfolio Weight Percentage measures the proportion of a specific fixed income security relative to the total portfolio value of firms investing in a given issuer’s securities. It quantifies the security's share within the overall portfolio. This percentage is key for understanding investment concentration and allocation. |
|
standardPortfolioWeightPercentage |
decimal{9,6} |
|
The Standard Portfolio Weight Percentage represents the proportion of a specific fixed income security relative to a standardized benchmark portfolio. It normalizes the weight to facilitate comparative analysis. This metric is important for evaluating how the security aligns with standard investment practices. |
|
standardizedmarketvalue |
decimal{32,4} |
|
The Standardized Market Value represents the market value of fixed income securities normalized to facilitate comparison across different firms or portfolios in USD. It standardizes values to enable benchmarking and comparative analysis. This metric is crucial for evaluating investment performance on a consistent basis. |
|
totalDebtOutstandingPercentage |
decimal{19,6} |
|
The Total Debt Outstanding Percentage represents the proportion of a fixed income issuer's 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 issuer's debt levels and financial health. |
|
totalParHeldPercent |
decimal{9,6} |
|
The Total Par Held Percent measures the percentage of the total nominal or face value of fixed income securities held by a firm relative to the issuer’s total securities. It reflects the firm’s share of the issuer's debt portfolio. This percentage is important for understanding the firm's investment concentration. |
|
yearToYearMarketValueChange |
long |
|
The Year To Year Market Value Change measures the annual variation in the market value of fixed income securities held by firms in USD. It reflects how the value has changed from one year to the next in USD. This metric is important for assessing long-term performance trends and investment growth. |
|
yearToYearParHeldChange |
long |
|
The Year To Year Par Held Change quantifies the annual change in the nominal or face value of fixed income securities held by firms in USD. It tracks how the amount held has varied over the year. This change is essential for understanding long-term investment adjustments and trends. |