| key |
id |
string(250)* |
= |
It 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. |
|
ciqCompanyId |
long(-2147483648,2147483647) |
|
A unique identifier assigned to each fund or firm within the CIQ database. It facilitates the tracking and management of firm-specific information related to fixed income securities. This identifier is crucial for linking firms with their respective investment holdings and performance data. |
|
dateEndedStandard |
date |
|
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. |
|
debtCapitalizationGroupType |
string(100) |
|
The debt capitalization emphasis for a given security. It groups debt held by a particular holder based on the type of capitalization approach such as senior or subordinated debt. |
|
fiAssetsMarketValue |
long(-9223372036854775807,9223372036854775806) |
|
The current total market valuation of all fixed income securities held by a specific investor or holder. This value reflects the price at which these securities can be sold in the market providing crucial information for assessing the worth of fixed income investments within that holders portfolio and their contribution to overall investment performance. |
|
fiAssetsStandardizedMarketValue |
decimal{32,4} |
|
The current total market valuation of all fixed income securities held by a specific investor or holder. This value reflects the price at which these securities can be sold in the market providing crucial information for assessing the worth of fixed income investments within that holders portfolio and their contribution to overall investment performance. |
|
formOrder |
long(-32768,32767) |
|
It represents the rows of output are to be displayed in ascending order by this value. This item should have no absolute value. It is used for relative ordering. |
|
groupId |
long(-2147483648,2147483647) |
|
A unique identifier assigned to each group within Orion database. It facilitates the tracking and management of group-specific information related to fixed income securities. This identifier is crucial for linking groups and their respective firms with the investment holdings and performance data. |
|
holderId |
long(-9223372036854775807,9223372036854775806) |
|
A unique identifier assigned to each fund or firm or group holder for a security. |
|
holderTurnOverStyle |
string(100) |
|
The trading turnover style of investors for a particular security. It categorizes the frequency and style of trading activities of a particular holder for a specific calendar quarter end date. |
|
institutionalInvestment |
boolean |
|
The value indicates whether an owner type is classified as an institutional investor or not. |
|
instnName |
string(100) |
|
The company which shall be displayed to arrange the companies of the group in ascending or descending order basis the alphabetical order. |
|
isDeleted |
boolean |
|
The row is (logically) deleted or not. |
|
keyDebtCapitalizationGroupType |
long(-32768,32767) |
|
The primary key of the debt based on capitalization emphasis. It provides a breakdown of debt types for a particular holder in a specific calendar quarter end date. |
|
keyHolderTurnOverStyle |
long(-32768,32767) |
|
The primary key of the turnover style of holders. It categorizes trading styles and frequencies of each holder for a specific calendar quarter end date. |
|
keyHoldingInvestmentType |
long(-32768,32767) |
|
The primary key for the holding investment type of security holders. |
|
lastModifiedDateTime |
dateTime* |
|
Date and time of a physical row when last modified in UTC timezone. |
|
latestFlag |
boolean |
|
The aggregate calculations in the table are made based on the latest available active portfolio only in which case the value will be true. If the calculations are made based on historical portfolios the value will be false. |
|
miKeyInstn |
long(-2147483648,2147483647) |
|
A unique identifier for funds and firms in the MI 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. |
|
portfolioTurnOverRatio |
decimal{9,6} |
|
The frequency at which assets within a portfolio are bought and sold over a specific period indicating the level of trading activity. A higher ratio suggests a more actively managed portfolio while a lower ratio indicates a more passive investment strategy. |