| 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 Service Provider is active. |
| 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 of the entity. |
|
isProviderRKPBundledServices |
boolean |
|
Indicates if the Recordkeeper offers bundled services. |
|
providerAssets |
long |
|
Dollars Managed in USD – The dollar amount for which the Provider is responsible for. |
|
providerAssetsLoc |
long |
|
Same as providerAssets. Figures shown in local currency. |
|
providerId |
long |
|
Permanent ID Number for provider. |
|
providerName |
string(200) |
|
The Provider Firm Name and City. |
|
providerPct |
decimal |
|
Percent Managed –Plan’s assets that the Provider is responsible for. |
|
providerServiceCode |
string(6) |
|
Service Code for the specific service provided. |
|
providerServiceName |
string(200) |
|
The Provider Service name. |
|
providerYearHired |
long |
|
Year this service provider was hired. |
|
seqNo |
long |
|
Sequence Number - There are often several pension plan and Insurance records associated. |
|
updateDate |
dateTime |
|
Date the service provider record was last updated on. |