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