| key |
id |
string(250)* |
= |
The id field uniquely identifies the entity record. |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the ParHeld is reported. |
|
ciqFundId |
long |
|
The CIQ Fund ID is a unique identifier assigned to a fund within the Capital IQ database used to track and manage investments in fixed income securities. It ensures precise reference and management of the fund’s investment data. This ID is essential for integrating and analyzing fund-specific information. |
|
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. |
|
isDeleted |
boolean |
|
Indicates whether the row is (logically) deleted or not. |
|
keyCiqIndustryTree |
long |
|
The Key CIQ Industry Tree classifies industries based on the CIQ Industry Tree structure. It provides insights into industry activity trends for a specific Calendar Quarter End Date. The corresponding primary industry and sector are provided in primaryIndustryGics and primarySectorGics fields of the entity. |
|
keyMiIndustryTree |
long |
|
The Key Mi Industry Tree represents the Primary Key of the industry sector activity trends for company holdings based on MI Industry Classification. It provides insights into sectoral activity within various industry categories for a specific Calendar Quarter End Date. The corresponding primary industry and sector are provided in primaryIndustryMi and primarySectorMi fields of the entity. |
|
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. |
|
parHeld |
long |
|
The Aggregated Par Held represents the total par value held by all funds within specific industries or sectors based on GICS or MI Industry Classifications at a given quarter end date in USD. |
|
parHeldChange |
long |
|
The Aggregated Par Held Change represents 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. |
|
primaryIndustryGics |
string(250) |
|
The Primary Industry GICS categorizes the primary industry for fund holdings according to GICS. It reflects industry sector activity trends across different fund holdings for a specific Calendar Quarter End Date. |
|
primaryIndustryMi |
string(250) |
|
The Primary Industry MI represents the primary industry classification for fund holdings based on MI Industry Classification. It provides insights into sector activity trends across different fund holdings for a specific Calendar Quarter End Date. |
|
primarySectorGics |
string(250) |
|
The Primary Sector GICS categorizes the primary sector for fund holdings based on GICS. It reflects sector activity trends across different fund holdings for a specific Calendar Quarter End Date. |
|
primarySectorMi |
string(250) |
|
The Primary Sector MI denotes the primary sector classification for fund holdings based on MI Industry Classification. It provides insights into sector activity trends across different fund holdings for a specific Calendar Quarter End Date. |