| key |
id |
string(500)* |
= |
The id field uniquely identifies the entity record. |
| 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. |
|
mandateId |
long |
|
Mandate Unique ID. |
|
planAssets |
long |
|
Assets of the Pension Plan in USD. |
|
planAssetsLoc |
long |
|
Assets of the pension Plan in local currency. |
|
planCurrencyCode |
string(6) |
|
Currency of the pension plan. |
|
planName |
string(260) |
|
Name of the Pension Plan. |
|
planSeqNo |
long |
|
Sequence of MMD Plan. |
|
planType |
string(100) |
|
Type of Pension Plan. |
|
planValuationDate |
string(7) |
|
Validation Date of Pension Plan at time of Mandate. |
|
updateDate |
dateTime |
|
Most recent update status of mandate. |