| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
|
activePortfolio |
boolean* |
|
The position corresponds to an active security with a holding to date within the last 2 years and included in the most recent portfolio of investments in which case the value will be true. In any other case the flag will be false. |
| link |
batch |
Batch* |
= |
The batch for which this batchrun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The batchrun in which the sharesheld is reported. |
|
ciqFundId |
long(-2147483648,2147483647)* |
|
A unique identifier assigned to each Fund within the CIQ database. It facilitates the tracking and management of fund-specific information related to equity securities. This identifier is crucial for linking funds with their respective investment holdings and performance data. |
|
ciqTradingItemId |
long(-2147483648,2147483647) |
|
A unique identifier for trading items in the CIQ database including equity securities. It facilitates the tracking and management of trading activities related to specific securities. This identifier is crucial for detailed analysis of trading patterns and positions. |
|
holdingToDate |
date* |
|
The holding period date of a equity security in the portfolio of the fund. This date is crucial for portfolio analytics and assessing investment duration. |
|
isDeleted |
boolean |
|
The row is (logically) deleted or not. |
|
lastModifiedDateTime |
dateTime* |
|
Date and time of a physical row when last modified in UTC timezone. |
|
marketValue |
long(-9223372036854775807,9223372036854775806) |
|
The current USD value of an equity security based on prevailing market conditions and prices. This represents the price at which the security could be traded or sold in the open market. This value is essential for portfolio valuation and investment performance assessment. (Magnitude: $) |
|
paToDate |
date |
|
The end date through which a fund’s holding in a security is considered effective. This date is derived to indicate a continuous series of holding data, typically defined as one day prior to the next holding’s start date, and is primarily used in portfolio analytics to determine holding periods and exposure continuity. |
|
sharesHeld |
long(-9223372036854775807,9223372036854775806) |
|
The number of shares of the fund that are currently held for a given security. (Magnitude: units) |