| key |
id |
string(250)* |
= |
The id field uniquely identifies the entity record. |
|
aggregatedParHeld |
long |
|
The Aggregated Par Held represents the total par value of fixed income securities held by a specific fund or firm grouped by the coupon rate ranges of the invested securities in USD. It consolidates the investments according to different coupon rate categories. This measure is available for the owner's latest calendar quarter end only. |
|
aggregatedParHeldPercentage |
decimal{9,6} |
|
The Aggregated Par Held Percentage represents the proportion of the total par value of fixed income securities held by a specific fund or firm grouped by the coupon rate ranges of the invested securities. It expresses the percentage distribution of investments across different coupon rate categories. This measure is available for the owner's latest calendar quarter end only. |
| 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. |
|
couponRateRange |
string(100) |
|
The Coupon Rate Range defines the ranges of coupon rates for bonds within the portfolio. It helps categorize bonds based on the interest rates they offer to investors. |
|
holdingToDate |
date |
|
The Holding To Date denotes the holding period date of a fixed income security or issuer in the portfolio of the fund. This date is crucial for portfolio analytics and assessing investment duration. |
|
isDeleted |
boolean |
|
Indicates whether the row is (logically) deleted or not. |
|
keyCouponRateRange |
long |
|
The Key Coupon Rate Range defines the Primary Key of the ranges of coupon rates for bonds in the portfolio. It categorizes bonds based on their interest rate ranges 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 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. |