Type FIOFundToManagerRelationship
Type category Entity
Description The FIOFundToManagerRel is an entity that captures the relationship between a fund and its respective fund manager within the Fixed Income Ownership framework. This table includes key details such as the start and end dates of the relationship, providing a timeline for the association.
Fields
Name Type Filters Description
key id string(100)* = It uniquely identifies the group 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 firm within the CIQ database. This identifier is essential for establishing connections between funds and their corresponding fund manager data.
ciqFundId long(-2147483648,2147483647) A unique identifier assigned to each fund within the CIQ database. This identifier is vital for linking funds to their respective performance data fund managers and other relevant attributes.
endDate date The final date when a specific event period or record ceases to be effective or applicable.
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.
isDeleted boolean The row is (logically) deleted or not.
isLatest boolean The most recent entry for a specific entity within the database. This boolean value helps in identifying the latest data point ensuring that users and systems reference the most current information without ambiguity.
isPrimary boolean The primary entry for a particular entity or relationship within the database. This boolean value is essential for distinguishing the main record from possible duplicates or secondary entries ensuring that users can easily identify the principal data associated with an entity.
keyInstn long(-2147483648,2147483647) A unique identifier for 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.
keyInstnFund long(-2147483648,2147483647) A unique identifier for funds in the MI database. It is used to manage and track fund investment details related to fixed income securities. This key aids in associating funds with their investment activities and holdings.
lastModifiedDateTime dateTime* Date and time of a physical row when last modified in UTC timezone.
startDate date The initial date when a specific event period or record becomes effective or applicable.
14 rows of 14 total
API Open API Specification