| 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. |