| key |
id |
string(250)* |
= |
The id field uniquely identifies the entity record. |
|
aggregatedParHeld |
long |
|
The Aggregated Par Held represents the total par value held by a specific fund or company across all fixed income securities categorized by sector at the latest calendar quarter end date in USD. |
|
aggregatedParHeldPercentage |
decimal{9,6} |
|
The Aggregated Par Held Percentage represents the proportion of the total par value held by a specific fund or company across all fixed income securities categorized by sector at the latest calendar quarter end date. It calculates the percentage distribution of holdings by sector. |
| 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. |
|
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. |
|
keyMISector |
long |
|
The Key Mi Sector defines Primary Key of the sector classifications within the portfolio based on MI Industry Classification. It provides insights into sectoral distribution of assets 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. |
|
sectorName |
string(100) |
|
The Sector Name refers to the classification of sectors within the portfolio. It provides details on the various sectors represented in the portfolio for a specific Calendar Quarter End Date. |