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