Type FOandIMAllocation
Type category Entity
Description The FOandIMAllocation table contains data for MMD Family Office and Investment Manager allocations.
Fields
Name Type Filters Description
key id string(500)* = The id field uniquely identifies the entity record.
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.
31 rows of 31 total
API Open API Specification