Type PlansAllocation
Type category Entity
Description The PlansAllocation table contains data for MMD Plan Sponsors/Institutional investor and Insurance allocations.
Timeseries key id, assetValuationDateavailable from 2007-01-31
Fields
Name Type Filters Description
key id string(500)* = The id field uniquely identifies the entity record.
timeline assetValuationDate date* =< >= 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 allocation is active.
allocationId long This field uniquely identifies the allocation.
amixGlobalExemptAssets long Exempt Assets Under Management in USD.
amixGlobalExemptAssetsLoc long Exempt Assets Under Management in local currency.
amixGlobalExemptPct decimal Tax-Exempt Percentage of Assets Under Management.
amixGlobalTaxAssets long Taxable Assets Under Management in USD.
amixGlobalTaxAssetsLoc long Taxable Assets Under Management in local currency.
amixGlobalTaxPct decimal Taxable Percentage of Assets Under Management.
link batch Batch = The batch that provided the data
link batchRun BatchRun = The batchRun that provided the data
link company Company MMD Company id, foreign key that links to the Company entity.
currencyCode string(3) Local currency conversion code.
datasetName string(50) Name of the dataset for the entity.
globalAssets long Dollar amount represented by specific asset type in USD.
globalAssetsLoc long Same as globalAssets. Figures shown in local currency.
globalCollective string(3) 3 digit code for Collective.
globalCollectiveText string(100) Description of the collective for the allocation.
globalDesc string(120) Asset Type description.
globalPct decimal Percent of plan represented by asset type in ##.## format.
globalRegion string(3) 3 digit code for Region.
globalRegionText string(100) Description of the region for the allocation.
globalStyle string(3) 3 digit code for Style.
globalStyleText string(100) Description of the style for the allocation.
globalType string(3) 3 digit code for Type.
globalTypeText string(100) Description of the type for the allocation.
isProvidesCounselingServices boolean Indicates if the investment manager provides counseling services.
isXVal boolean Indicates current use of this AMIX type even if % is unknown.
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 Allocation record last updated on.
32 rows of 32 total
API Open API Specification