| key |
id |
string(250)* |
= |
The id field uniquely identifies the entity record. |
|
aggregatedParHeld |
long |
|
The Aggregated Par Held represents the total par value of a specific security grouped by the geographic location of its owners at a given calendar quarter end date in USD. It consolidates holdings based on the geographic distribution of the owners. |
|
aggregatedParHeldChange |
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. |
|
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. |
|
ciqSecurityId |
long |
|
The CIQ Security ID is 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 ID is essential for linking securities to their respective firms and portfolios. |
| 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. |
|
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. |
| link |
geographyTree |
GeographyTree |
|
The GeographyTree provides the linkage to the references present in the GeographyTree entity. |
|
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. |
|
miKeyfndg |
long |
|
The MI Key Fndg is a unique identifier for Securities within the Market Intelligence 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. |