| key |
id |
string(250)* |
= |
It uniquely identifies the entity record. |
|
aggregatedParHeld |
long(-9223372036854775807,9223372036854775806) |
|
The total par value held grouped by the count of funds or companies that are holders of a specific security at a given calendar quarter end date in USD. |
|
aggregatedParHeldChange |
long(-9223372036854775807,9223372036854775806) |
|
The variation in the aggregated par held value between two different calendar quarter end dates in USD. It shows the increase or decrease in holdings. |
|
aggregatedParHeldChangeIssueCurrency |
long(-9223372036854775807,9223372036854775806) |
|
The variation in the aggregated par held value between two different calendar quarter end dates in the issuing currency of the security. It shows the increase or decrease in holdings. |
|
aggregatedParHeldChangePercentage |
decimal{20,6} |
|
The proportion of variation in the aggregated par held value between two different calendar quarter end dates. It indicates the percentage increase or decrease in holdings over that period. |
|
aggregatedParHeldIssueCurrency |
long(-9223372036854775807,9223372036854775806) |
|
The total par value held grouped by the count of funds or companies that are holders of a specific security at a given calendar quarter end date in the issuing currency of the security. |
| link |
batch |
Batch* |
= |
The batch for which this batchrun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The batchrun in which the parheld is reported. |
|
buyCount |
long(-2147483648,2147483647) |
|
The total number of distinct transactions where investors have purchased a specific security or issuer. It provides an overview of the frequency of buying activity for the security reflecting investor engagement and acquisition trends for a specific calendar quarter end date. |
|
buyInCount |
long(-2147483648,2147483647) |
|
The total number of distinct holders who have newly acquired positions in a specific security or issuer. This count highlights the number of new or additional investors entering their positions for the security for a specific calendar quarter end date. |
|
buyInParHeld |
long(-9223372036854775807,9223372036854775806) |
|
The total par value of securities newly acquired by distinct investors for a specific security or issuer. This metric highlights the aggregate value of new or additional investments for the security or issuer for a specific calendar quarter end date in USD. |
|
buyInParHeldIssueCurrency |
long(-9223372036854775807,9223372036854775806) |
|
The total par value of securities newly acquired by distinct investors for a specific security or issuer. This metric highlights the aggregate value of new or additional investments for the security or issuer for a specific calendar quarter end date in the issuing currency of the security. |
|
buyParHeld |
long(-9223372036854775807,9223372036854775806) |
|
The total par value of securities purchased by investors for a specific security or issuer. It provides an overview of the aggregate value of buying activity reflecting investor engagement and acquisition trends for the security for a specific calendar quarter end date in USD. |
|
buyParHeldIssueCurrency |
long(-9223372036854775807,9223372036854775806) |
|
The total par value of securities purchased by investors for a specific security or issuer. It provides an overview of the aggregate value of buying activity reflecting investor engagement and acquisition trends for the security for a specific calendar quarter end date in the issuing currency of the security. |
|
ciqSecurityId |
long(-2147483648,2147483647) |
|
A unique identifier for each security in the CIQ database. It is used to track and manage individual fixed income securities ensuring accurate data aggregation and analysis. This identifier is essential for linking securities to their respective firms and portfolios. |
|
dateEndedStandard |
date |
|
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. |
|
holdersCount |
long(-2147483648,2147483647) |
|
The total number of distinct holders for a specific security or issuer. It provides an overview of the number of unique investors holding the security for a specific calendar quarter end date. This count is essential for understanding the breadth of investor base and market reach. |
|
isDeleted |
boolean |
|
The row is (logically) deleted or not. |
|
isFirmLevelAggregate |
boolean |
|
The true value suggest that aggregation are done for firm owners. |
|
isFundLevelAggregate |
boolean |
|
The true value suggest that aggregation are done for fund owners. |
|
isInstitutionalLevelAggregate |
boolean |
|
The true value suggest that aggregation are done for institutional owners. |
|
lastModifiedDateTime |
dateTime* |
|
Date and time of a physical row when last modified in UTC timezone. |
|
latestFlag |
boolean |
|
The aggregate calculations in the table are made based on the latest available active portfolio only in which case the value will be true. If the calculations are made based on historical portfolios the value will be false. |
|
miKeyCurrency |
string(3) |
|
A unique identifier(3 character ISO code) for currencies used in the MI database. It helps track and manage currency-specific information related to fixed income securities. This key is essential for accurate currency conversion and financial analysis. |
|
miKeyfndg |
long(-2147483648,2147483647) |
|
A unique identifier for securities within the MI database. It facilitates tracking and management of specific details related to fixed income securities. This key is crucial for linking firms with their investment holdings and performance metrics. |
|
sellCount |
long(-2147483648,2147483647) |
|
The total number of distinct transactions where investors have sold a specific security or issuer. It provides insight into the frequency of selling activity and divestment trends among investors for a specific calendar quarter end date. |
|
sellOutCount |
long(-2147483648,2147483647) |
|
The total number of distinct holders who have completely sold their holdings of a specific security or issuer. This count offers an overview of the number of investors who have exited their positions entirely for the security for a specific calendar quarter end date. |
|
sellOutParHeld |
long(-9223372036854775807,9223372036854775806) |
|
The total par value of securities that distinct holders have completely sold for a specific security or issuer. This metric provides an overview of the aggregate value of positions exited entirely by investors for the security or issuer for a specific calendar quarter end date in USD. |
|
sellOutParHeldIssueCurrency |
long(-9223372036854775807,9223372036854775806) |
|
The total par value of securities that distinct holders have completely sold for a specific security or issuer. This metric provides an overview of the aggregate value of positions exited entirely by investors for the security or issuer for a specific calendar quarter end date in the issuing currency of the security. |
|
sellParHeld |
long(-9223372036854775807,9223372036854775806) |
|
The total par value of securities sold by investors for a specific security or issuer. It provides insight into the aggregate value of selling activity and divestment trends among investors for a specific calendar quarter end date in USD. |
|
sellParHeldIssueCurrency |
long(-9223372036854775807,9223372036854775806) |
|
The total par value of securities sold by investors for a specific security or issuer. It provides insight into the aggregate value of selling activity and divestment trends among investors for a specific calendar quarter end date in the issuing currency of the security. |