Type Plans
Type category Entity
Description The Plans table contains data for MMD plans.
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* =< >= Plan 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 plan is active.
annualContributions long Annual Contributions to this plan from employers & employees in USD.
annualContributionsLoc long Same as annualContributions. Figures shown in local currency.
assets long Plan or Fund Assets-Amount of assets in USD for given employee pension plan, or endowment/foundation fund.
assetsLoc long Same as assets. Figures shown in local currency.
assumedInterestRate decimal Assumed Interest Rate for defined benefit plan, i.e. 5.25 = 5.25%.
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.
definedBenefitAssets long Defined Benefit Assets in USD.
definedBenefitAssetsLoc long Same as definedBenefitAssets. Figures shown in local currency.
definedContributionAssets long Defined Contribution Assets Total in USD.
definedContributionAssetsLoc long Same as definedContributionAssets. Figures shown in local currency.
domiciledState string(2) State where the insurer is incorporated or organized.
einPl1 string(12) Plan ID: Plan EIN# + 3 digit plan # on DOL 5500 form.
eligibleEmployeesCount long Number of Eligible Employees for pension plan.
endowmentFoundationAssets long Total assets of an endowment (Category 20) or foundation Category 25, 28, 38) in USD. There are also some corporations, hospitals and public retirement systems (Category 05, 15 & 30) included which have foundation assets. Plan Types 0400 & 0500 assets are included in this total.
endowmentFoundationAssetsLoc long Same as endowmentFoundationAssets. Figures shown in local currency.
fundedPct decimal Amount over or under Projected Benefit Obligation (PBO). Shown as %.
inHouseAssets long Assets managed in-house total in USD.
inHouseAssetsLoc long Same as inHouseAssets. Figures shown in local currency.
isAssetAllocationStudy boolean Indicates if the consultant services provided to the plan include Asset Allocation Study..
isManagerSearch boolean Indicates if the consultant services provided to the plan include Manager Search..
isParticipantDirected boolean Indicates if the plan investments are Participant Directed.
isPerformanceEvaluation boolean Indicates if is Performance Evaluation.
isSelfDirectedBrokerageOptions boolean Indicates if the organization offers self-directed brokerage options.
liabilities long Includes Benefit Claims Payable, Operating Payables, Acquisition Indebtedness and Other Liabilities., in USD.
liabilitiesLoc long Same as liabilities. Figures shown in local currency.
managersCount long Number of investment management firms managing this organization's tax-exempt funds. Duplicates (the same manager listed under several plans) have been eliminated.
naic string(30) North American Industry Classification code assigned by government if dataset is Plan Sponsor, National association of insurance companies if dataset is Insurance.
otherAssets long Total other assets in USD consisting of plan types 0444 (Nuclear Decommissioning Funds), 0600 (Sovereign Wealth Funds),  0800 (Other Tax-exempt assets) and 0900 (Miscellaneous Retirement Funds). These assets are not necessarily Pension or Endowment/Foundations.
otherAssetsLoc long Same as otherAssets. Figures shown in local currency.
participantsCount long Number of participants in an employee pension plan.
pensionAssets long Total employee benefit assets of sponsoring organization in USD.
pensionAssetsLoc long Same as pensionAssets. Figures shown in local currency.
planName string(130) Plan or Fund Name - Text field with name of this employee pension plan or endowment/foundation fund. For Tax-Exempt and Health Service Orgs. there will be a record that reads
planSeqNo long Plan Sequence Number - There are often several pension plan records associated
planType string(120) Type of plan.
projectedBenefitObligation long Firm’s Projected Benefit Obligation in USD.
projectedBenefitObligationLoc long Same as projectedBenefitObligation. Figures shown in local currency.
segAssets long Segregated Assets from Parent Insurance Company in USD.
updateDate dateTime Plan record last updated on.
46 rows of 46 total
API Open API Specification