Type Fund
Type category Entity
Description The Fund table contains data on MMD funds.
Timeseries key id, assetValuationDateavailable from 2009-12-31
Fields
Name Type Filters Description
key id string(500)* = The id field uniquely identifies the entity record.
timeline assetValuationDate date* =< >= Fund Asset Valuation Date as per most recently reported data. This date will always reflect the last day of the month for reporting period.
active boolean Indicates if fund is active.
link batch Batch = The batch that provided the data
link batchRun BatchRun = The batchRun that provided the data
ciqCompanyId long Used to map an MMD entity to corresponding data in other SP Global datasets. Field length up to 12 digits. NULL value indicates no mapping available.
link company Company MMD Company id, foreign key that links to the Company entity.
currencyCode string(3) Local currency conversion code.
fundAssets long Investment Fund Assets in USD.
fundAssetsLoc long Investment Fund Assets in local currency.
fundId long ID Number for the Manager attached to this plan. 9004780 is the number for in-house management.
fundName string(140) Investment Fund Name.
fundPct decimal Percentage of Investment Fund Assets for the Overall Plan.
globalAllocationId string(50) Global Allocation id uniquely identifies the allocation connected to the fund.
globalAllocationText string(500) The description of the allocation connected to the fund.
managerId long ID Number for the Manager attached to this plan. 9004780 is the number for in-house management.
planSeqNo long Plan Sequence Number - There are often several pension plan records associated.
updateDate dateTime Date the Fund record was last updated on.
18 rows of 18 total
API Open API Specification