| key |
id |
string(250)* |
= |
The id field uniquely identifies the entity record. |
|
aggregatedParHeld |
long |
|
The Aggregated Par Held represents the total par value of all fixed income securities issued by a specific issuer aggregated by the count of funds or companies holding these securities at a given calendar quarter end date in USD. |
| 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 |
|
The Buy Count represents the total number of distinct transactions where investors have purchased a specific issuer’s securities. It provides an overview of the frequency of buying activity for the issuer’s securities reflecting investor engagement and acquisition trends for a specific Calendar Quarter End Date. |
|
buyInCount |
long |
|
The Buy In Count indicates the total number of distinct holders who have newly acquired positions in a specific issuer�s securities. This count highlights the number of new or additional investors entering their positions in the issuer�s securities for a specific Calendar Quarter End Date. |
|
buyInParHeld |
long |
|
The Buy In Par Held represents the total par value of securities newly acquired or increased in holdings by distinct investors in a specific issuer�s securities. This metric highlights the aggregate value of new or additional investments in the issuer�s securities for a specific Calendar Quarter End Date in USD. |
|
buyParHeld |
long |
|
The Buy Par Held represents the total par value of securities purchased by investors for a specific issuer’s securities. It provides an overview of the aggregate value of buying activity reflecting investor engagement and acquisition trends for the issuer’s securities for a specific Calendar Quarter End Date in USD. |
|
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. |
|
holdersCount |
long |
|
The Holders Count represents the total number of distinct holders for a specific issuer’s securities. It provides an overview of the number of unique investors holding the issuer’s securities for a specific Calendar Quarter End Date. This count is crucial for assessing the issuer's investor base and market presence. |
|
isDeleted |
boolean |
|
Indicates whether the row is (logically) deleted or not. |
|
isFirmLevelAggregate |
boolean |
|
The "Is Firm Level Aggregate" value represents whether the aggregate calculations from the table were done for firm owners. When it is true its counterpart field value "Is Fund Level Aggregate" will be false. |
|
isFundLevelAggregate |
boolean |
|
The "Is Fund Level Aggregate" value represents whether the aggregate calculations from the table were done for fund owners. When it is true its counterpart field "Is Firm Level Aggregate" will be false. |
|
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. |
|
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. |
|
sellCount |
long |
|
The Sell Count represents the total number of distinct transactions where investors have sold a specific issuer’s securities. It provides insight into the frequency of selling activity and divestment trends among investors for the issuer’s securities for a specific Calendar Quarter End Date. |
|
sellOutCount |
long |
|
The Sell Out Count signifies the total number of distinct holders who have completely sold their holdings of a specific issuer’s securities. This count offers an overview of the number of investors who have exited their positions entirely in the issuer’s securities for a specific Calendar Quarter End Date. |
|
sellOutParHeld |
long |
|
The Sell Out Par Held represents the total par value of securities that distinct holders have completely sold for a specific issuer’s securities. This metric provides an overview of the aggregate value of positions exited entirely by investors in the issuer’s securities for a specific Calendar Quarter End Date in USD. |
|
sellParHeld |
long |
|
The Sell Par Held represents the total par value of securities sold by investors for a specific issuer’s securities. It provides insight into the aggregate value of selling activity and divestment trends among investors for the issuer’s securities for a specific Calendar Quarter End Date in USD. |