| 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 grouped by the owner type of its holders at a given calendar quarter end date in USD. |
|
aggregatedParHeldPercentage |
decimal{9,6} |
|
The Aggregated Par Held Percentage represents the proportion of the total par value of all fixed income securities issued by a specific issuer grouped by the owner type of its holders at a given calendar quarter end date. It calculates the percentage distribution of holdings according to different owner types. |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the ParHeld is reported. |
|
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 investing in the combined securities of a specific issuer company categorized by investment type for a specific Calendar Quarter End Date. It offers a view of the diversity and number of unique investors in different investment categories. This count helps in understanding the distribution of investment strategies. |
|
holdingInvestmentType |
string(100) |
|
The Holding Investment Type categorizes the types of investments held by companies in issuer securities. It provides an overview of the investment strategies or types used by holders for a specific Calendar Quarter End Date. |
|
isDeleted |
boolean |
|
Indicates whether the row is (logically) deleted or not. |
|
keyHoldingInvestmentType |
long |
|
The Key Holding Investment Type specifies Primary Key of the types of investments held by companies in issuer securities. It categorizes investment approaches used by holders 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. |
|
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. |