Type PlansServiceProvider
Type category Entity
Description The PlansServiceProvider table contains data for MMD Plans and Insurance service providers.
Timeseries key id, assetValuationDateavailable from 2007-01-31
Fields
Name Type Filters Description
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.
19 rows of 19 total
API Open API Specification