| 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 given fund or firm grouped by the geographical location of the issuers of the invested securities in USD. It consolidates the investments based on the issuers' locations. This measure is available for the owner's latest calendar quarter end only. |
|
aggregatedParHeldChange |
long |
|
The Aggregated Par Held Change represents the variation in the aggregated par held value in USD between two different calendar quarter end dates. It shows the increase or decrease in holdings. |
|
aggregatedParHeldChangePercentage |
decimal{20,6} |
|
The Aggregated Par Held Change represents the variation in the aggregated par held value between two different calendar quarter end dates. It shows the increase or decrease in holdings. |
| 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. |
| link |
cityAsReported |
CityAsReported |
|
The CityAsReported provides the linkage to the references present in the CityAsReported entity. |
|
cityLevelAggregateFlag |
boolean |
|
The "City Level Aggregate Flag" value represents whether the aggregate calculations from the table were done based on the CityAsReported for which case it will be true. If the calculations were done based on the GeographyTree value will be false. |
| link |
geographyTree |
GeographyTree |
|
The GeographyTree provides the linkage to the references present in the GeographyTree entity. |
|
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. |
|
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. |