The following names are used when saving Valuation Set Exhibits or Deterministic Forecast Exhibits to a Microsoft Word document or a Microsoft Access database.
-
In Microsoft Word, these names represent bookmarks that mark the location of ProVal exhibits within the document.
-
In Microsoft Access, these names represent tables within the (Access) database.
In all modes, the following Word Bookmarks are provided automatically: ProVal_ProjBenAcct (projected benefit payments for all years on accounting basis such as EBO, ABO and PBO, split between actives and inactives), ProVal_ProjBenFund (same, on funding basis), ProVal_ValSet_Data (Valuation Set results), ProVal ValSet_Events (Valuation Set results, by Event), and ProVal_ValSet_Params (Valuation Set parameters). For more information, see Saving Results to Access.
The names used for the exhibits are presented in the following lists by ProVal mode of computation.
U.S. Qualified Pension Mode
In the U.S. qualified pension mode, a Valuation Set or Deterministic Forecast may produce the exhibits listed below. Only exhibits applicable to the law type, plan and run are displayed. Accounting exhibits may have alternative forms depending on the selected accounting standard. Furthermore, some exhibits are available only for Valuation Sets (e.g., the census exhibits), while others are available only for Deterministic Forecasts (e.g., the Development of Market Assets exhibits).
Note: Bookmarks annotated as PPA designate single-employer plan exhibits reflecting the Pension Protection Act of 2006 (aka PPA). Bookmarks annotated as pre-PPA designate single-employer plan exhibits reflecting the law in effect prior to PPA and multiemployer plan exhibits under either law.
| ProVal Exhibit | Word Bookmark / Access Table Name |
|
| Census | ||
| Active Participant Data | ProVal_AgeSvc | For Access, see notes below |
| Schedule B - Schedule of Active Participant Data | ProVal_AgeSvcIRS | (Word only) |
| Inactive Benefits Inforce | ProVal_Inact | For Access, see notes below |
| Funding | ||
| Market Assets (Funding Basis) | ProVal_MktVal | For Access, see notes below |
| Actuarial Assets | ProVal_ActAV / ProVal_DevActAssets | For Access, see notes below |
| Employer Contribution | ProVal_ErCtrb | |
| Minimum Required Contribution Limits (Pre-PPA) | ProVal_USMin | |
| Minimum Required Contribution Limits (PPA) | ProVal_USMinPPA | |
| Maximum Tax Deductible Contribution Limits (pre-PPA) | ProVal_USMax | |
| Maximum Tax Deductible Contribution Limits (PPA) | ProVal_USMaxPPA | |
| Funding Amortization Bases, Minimum Basis | ProVal_USMinBase | |
| Funding Amortization Bases, Maximum Basis | ProVal_MaxBase | |
| Minimum Basis Amortization | ProVal_Min_Basis_Amort | |
| Funding Target | ProVal_FundTgt | |
| Max Tax UC Funding Target | ProVal_MaxFundTgt | |
| Shortfall Amortization Charge | ProVal_USShrtflChg | |
| Credit Balances | ProVal_USCredBal | |
| Additional Funding Charge - RPA '94 Law | ProVal_AFCRPA / ProVal_AFC_RPA | |
| Additional Funding Charge – OBRA '87 Law | ProVal_AFCOBRA / ProVal_AFC_OBFA | |
| Schedule of Employer Contributions | ProVal_ContSched | |
| Interest Penalty on Late Quarterly Contributions | ProVal_IntOnLateQ | |
| Full Funding Limits – Minimum Contribution Basis | ProVal_FFLMin | |
| Full Funding Limits – Maximum Contribution Basis | ProVal_FFLMax | |
| Normal Cost [PPA] | ProVal_AggNC | |
| Minimum-basis Normal Cost [pre-PPA] | ProVal_AggNCQual | |
| Individual Aggregate Normal Cost – Minimum Funding Basis | ProVal_INDNCMin / ProVal_DevINDNCMin | |
| Maximum-basis Normal Cost | ProVal_AggNCMax | |
| Individual Aggregate Normal Cost – Maximum Funding Basis | ProVal_INDNCMax / ProVal_DevINDNCMax | |
| PBGC Premium (Pre-PPA) | ProVal_PBGCPrem | |
| PBGC Premium (PPA) | ProVal_PBGCPremPPA | |
| Weighted Average Retirement Age | ProVal_WeightedRetAge | |
| Pre-MAP-21 Minimum Required Contribution | ProVal_USPreMAP21MinPPA | |
| Pre-MAP-21 Shortfall Amortization Charge | ProVal_USPreMAP21ShrtflChg | |
| Accounting | ||
| For asset, expense and funded status exhibits in Access, see notes below. | ||
| Market Assets (Accounting Basis) | ProVal_FairVal | |
| Market-Related Assets | ProVal_MktRelAV / ProVal_DevMktRelAssets | |
| ASC 715: Pension Expense | ProVal_FAS87 / ProVal_DevExpense | |
| IAS 19: Pension Expense | ProVal_IAS19R / ProVal_DevExpense | |
| IAS 19 (2008): Development of Retirement Benefit Expense | ProVal_IAS19 / ProVal_DevExpense |
|
| Expected Return on Contributions Accounting Amortization Bases |
ProVal_ValSet_Acctg_ERACtrb ProVal_AcctgBase |
|
| ASC 715: Balance Sheet | ProVal_RecFAS87_158 / ProVal_Acctg_Funded_Status | |
| FAS87 (2006): Balance Sheet | ProVal_RecFAS87 / ProVal_Acctg_Funded_Status | |
| IAS 19: Balance Sheet | ProVal_RecIAS19R / ProVal_Acctg_Funded_Status | |
| IAS 19 (2008): Balance Sheet | ProVal_RecIAS19 / ProVal_Acctg_Funded_Status | |
| ASC 960: Statement & Reconciliation of PVAB | ProVal_RecFAS35 |
OPEB (Retiree Medical) Mode
In the OPEB (retiree medical) mode, a Valuation Set or Deterministic Forecast may produce the exhibits listed below. Only exhibits applicable to the plan and run are displayed. Accounting exhibits may have alternative forms depending on the selected accounting standard. Furthermore, some exhibits are available only for Valuation Sets (e.g., the census exhibit), while others are available only for Deterministic Forecasts (e.g., the Development of Market Assets exhibits).
| ProVal Exhibit | Word Bookmark / Access Table Name |
|
| Census | ||
| Active Participant Data | ProVal_AgeSvc | For Access, see notes below |
| Funding | ||
| Market Assets (Funding Basis) | ProVal_MktVal | For Access, see notes below |
| Actuarial Assets | ProVal_ActAV / ProVal_DevActAssets | For Access, see notes below |
| Employer Contribution | ProVal_ErCtrb | |
| Normal Cost | ProVal_AggNC | |
| Individual Aggregate Normal Cost | ProVal_INDNC / ProVal_DevINDNC | |
| Weighted Average Retirement Age | ProVal_WeightedRetAge | |
| GASB Accounting | ||
| GASB 43/45: Annual Required Contribution (ARC) | ProVal_ARC | For Access, see notes below |
| GASB 45: Development of Annual OPEB Cost and Net OPEB Obligation | ProVal_GASB | For Access, see notes below |
| Accounting | ||
| For asset, expense and funded status exhibits in Access, see notes below. | ||
| Market Assets (Accounting Basis) | ProVal_FairVal | |
| Market-Related Assets | ProVal_MktRelAV / ProValDevMktRelAssets | |
| ASC 715: OPEB Expense | ProVal_FAS106 / ProVal_DevExpense | |
| CICA 3461: OPEB Expense | ProVal_CICA3461 / ProVal_DevExpense | |
| IAS 19: OPEB Expense | ProVal_IAS19R / ProVal_DevExpense | |
| IAS 19 (2008): OPEB Expense | ProVal_IAS19 / ProVal_DevExpense | |
| GASB 75: OPEB Expense | ProVal_GASB68 / ProVal_DevExpense | |
| Accounting Amortization Bases | ProVal_AcctgBase | |
| ASC 715: Balance Sheet | ProVal_RecFAS106_158 / ProVal_Acctg_Funded_Status | |
| CICA 3461: Balance Sheet | ProVal_RecCICA3461 / ProVal_Acctg_Funded_Status | |
| FAS 106 (2006): Balance Sheet | ProVal_RecFAS106 / ProVal_Acctg_Funded_Status | |
| IAS 19: Balance Sheet | ProVal_RecIAS19R / ProVal_Acctg_Funded_Status | |
| IAS 19 (2008): Balance Sheet | ProVal_RecIAS19 / ProVal_Acctg_Funded_Status | |
| GASB 74/75: Balance Sheet | ProVal_RecGASB6768 / ProVal_Acctg_Funded_Status | |
| ASC 715: Trend Sensitivities | ProVal_TrendFAS106 / ProVal_TrendSensitivity | |
| CICA 3461: Trend Sensitivities | ProVal_TrendCICA3461 / ProVal_TrendSensitivity | |
| IAS 19: Trend Sensitivities | ProVal_TrendIAS19R / ProVal_TrendSensitivity | |
| IAS 19 (2008): Trend Sensitivities | ProVal_TrendIAS19 / ProVal_TrendSensitivity | |
| GASB 74/75: Trend Sensitivities | ProVal_TrendGASB7475 / ProVal_TrendSensitivity |
U.S. Public Pension Mode
In the U.S. public pension mode, a Valuation Set or Deterministic Forecast may produce the exhibits listed below. Only exhibits applicable to the plan and run are displayed. Furthermore, some exhibits are available only for Valuation Sets (e.g., the census exhibits), while others are available only for Deterministic Forecasts (e.g., the Development of Market Assets exhibit).
| ProVal Exhibit | Word Bookmark / Access Table Name |
|
| Census | ||
| Active Participant Data | ProVal_AgeSvc | For Access, see notes below |
| Inactive Benefits Inforce | ProVal_Inact | For Access, see notes below |
| Funding | ||
| Market Assets | ProVal_MktVal | For Access, see notes below |
| Actuarial Assets | ProVal_ActAV / ProVal_DevActAssets | For Access, see notes below |
| Employer Contribution | ProVal_ErCtrb | |
| Normal Cost | ProVal_AggNC | |
| Individual Aggregate Normal Cost | ProVal_INDNC / ProVal_DevINDNC | |
| Weighted Average Retirement Age | ProVal_WeightedRetAge | |
| GASB Accounting | ||
| GASB 25/27: Annual Required Contribution (ARC) | ProVal_ARC | For Access, see notes below |
| GASB 27: Development of Pension Cost and Net Pension Obligation (NPO) | ProVal_GASB | For Access, see notes below |
| Accounting | ||
| Market Assets (Accounting Basis) | ProVal_FairVal | |
| GASB 68: Pension Expense | ProVal_DevExpense | |
| GASB 67/68: Balance Sheet | ProVal_GASB68 / ProVal_Acctg_Funded_Status |
Universal Pension Mode
In the universal pension mode (which can be used for US non-qualified private or SERP pension plans), a Valuation Set or Deterministic Forecast may produce the exhibits listed below. Only exhibits applicable to the plan and run are displayed. Accounting exhibits may have alternative forms (listed below as a., b., etc.), depending on the selected accounting standard. Furthermore, some exhibits are available only for Valuation Sets (e.g., the census exhibits), while others are available only for Deterministic Forecasts (e.g., the Development of Market Assets exhibits).
| ProVal Exhibit | Word Bookmark / Access Table Name |
|
| Census | ||
| Active Participant Data | ProVal_AgeSvc | For Access, see notes below |
| Inactive Benefits Inforce | ProVal_Inact | For Access, see notes below |
| Funding | ||
| Market Assets (Funding Basis) | ProVal_MktVal | For Access, see notes below |
| Actuarial Assets | ProVal_ActAV / ProVal_DevActAssets | For Access, see notes below |
| Employer Contribution | ProVal_ErCtrb | |
| Minimum Contribution - Netherlands funding rules | ProVal_ContNeth | |
| Normal Cost | ProVal_AggNC | |
| Individual Aggregate Normal Cost | ProVal_INDNC / ProVal_DevINDNC | |
| Weighted Average Retirement Age | ProVal_WeightedRetAge | |
| Accounting | ||
| For asset, expense and funded status exhibits in Access, see notes below. | ||
| Market Assets (Accounting Basis) | ProVal_FairVal | |
| Market-Related Assets | ProVal_MktRelAV / ProVal_DevMktRelAssets | |
| ASC 715: Pension Expense | ProVal_FAS87 / ProVal_DevExpense | |
| CICA 3461: Pension Expense | ProVal_CICA3461 / ProVal_DevExpense | |
| IAS 19: Retirement Benefit Expense | ProVal_IAS19R / ProVal_DevExpense | |
| IAS 19 (2008): Retirement Benefit Expense | ProVal_IAS19 / ProVal_DevExpense | |
| Accounting Amortization Bases | ProVal_AcctgBase | |
| ASC 715: Balance Sheet | ProVal_RecFAS87_158 / ProVal_Acctg_Funded_Status | |
| CICA 3461: Balance Sheet | ProVal_RecCICA3461 / ProVal_Acctg_Funded_Status | |
| FAS 87 (2006): Balance Sheet | ProVal_RecFAS87 / ProVal_Acctg_Funded_Status | |
| IAS 19: Balance Sheet | ProVal_RecIAS19R / ProVal_Acctg_Funded_Status | |
| IAS 19 (2008): Balance Sheet | ProVal_RecIAS19 / ProVal_Acctg_Funded_Status | |
| ASC 960: Statement & Reconciliation of PVAB | ProVal_RecFAS35 |
Canadian Registered Pension Mode
In the Canadian registered pension mode, a Valuation Set or Deterministic Forecast may produce the exhibits listed below. Only exhibits applicable to the plan and run are displayed. Accounting exhibits may have alternative forms (listed below as a., b., etc.), depending on the selected accounting standard. Furthermore, some exhibits are available only for Valuation Sets (e.g., the census exhibits), while others are available only for Deterministic Forecasts (e.g., the Development of Market Assets exhibits).
| ProVal Exhibit | Word Bookmark / Access Table Name |
|
| Census | ||
| Active Participant Data | ProVal_AgeSvc | For Access, see notes below |
| Inactive Benefits Inforce | ProVal_Inact | For Access, see notes below |
| Funding | ||
| Market Assets (Funding Basis) | ProVal_MktVal | For Access, see notes below |
| Actuarial Assets | ProVal_ActAV / ProVal_DevActAssets | For Access, see notes below |
| Employer Contribution | ProVal_ErCtrb | |
| Minimum Required Contribution Limits | ProVal_CanMin | |
| Maximum Tax Deductible Contribution Limits | ProVal_CanMax | |
| Funding Amortization Bases | ProVal_CanMinBase | |
| Solvency Deficiency | ProVal_SolvDef | |
| Surplus Threshold | ProVal_FFLCan | |
| Normal Cost | ProVal_AggNCCan | |
| Individual Aggregate Normal Cost | ProVal_INDNC / ProVal_DevINDNC | |
| Weighted Average Retirement Age | ProVal_WeightedRetAge | |
| Accounting | ||
| For asset, expense and funded status exhibits in Access, see notes below. | ||
| Market Assets (Accounting Basis) | ProVal_FairVal | |
| Market-Related Assets | ProVal_MktRelAV / ProVal_DevMktRelAssets | |
| ASC 715: Pension Expense | ProVal_FAS87 / ProVal_DevExpense | |
| CICA 3461: Pension Expense | ProVal_CICA3461 /ProVal_DevExpense | |
| IAS 19: Retirement Benefit Expense | ProVal_IAS19R / ProVal_DevExpense | |
| IAS 19 (2008): Retirement Benefit Expense | ProVal_IAS19 / ProVal_DevExpense | |
| Accounting Amortization Bases | ProVal_AcctgBase | |
| ASC 715: Balance Sheet | ProVal_RecFAS87_158 / ProVal_Acctg_Funded_Status | |
| CICA 3461: Balance Sheet | ProVal_RecCICA3461 / ProVal_Acctg_Funded_Status | |
| FAS 87 (2006): Balance Sheet | ProVal_RecFAS87 / ProVal_Acctg_Funded_Status | |
| IAS 19: Balance Sheet | ProVal_RecIAS19R / ProVal_Acctg_Funded_Status | |
| IAS 19 (2008): Balance Sheet | ProVal_RecIAS19 / ProVal_Acctg_Funded_Status |
German Mode
In the German mode, a Valuation Set or Deterministic Forecast may produce the exhibits listed below. Only exhibits applicable to the plan and run are displayed. Some exhibits are available only for Valuation Sets (e.g., the census exhibits), while others are available only for Deterministic Forecasts (e.g., the Development of Market Assets exhibits).
| ProVal Exhibit | Word Bookmark / Access Table Name |
|
| Census | ||
| Active Participant Data | ProVal_AgeSvc | For Access, see notes below |
| Inactive Benefits Inforce | ProVal_Inact | For Access, see notes below |
| Funding | ||
| Market Assets (Funding Basis) | ProVal_MktVal | For Access, see notes below |
| Actuarial Assets | ProVal_ActAV / ProVal_DevActAssets | For Access, see notes below |
| Employer Contribution | ProVal_ErCtrb | |
| Normal Cost | ProVal_AggNC | |
| Weighted Average Retirement Age | ProVal_WeightedRetAge | |
| Accounting | ||
| For asset, expense and funded status exhibits in Access, see notes below. | ||
| Market Assets (Accounting Basis) | ProVal_AcctgMktAssets | |
| IAS 19: Retirement Benefit Expense | ProVal_IAS19R / ProVal_DevExpense | |
| IAS 19: Balance Sheet | ProVal_RecIAS19R / ProVal_Acctg_Funded_Status |
UK Pension Mode
In the UK pension mode, a Valuation Set or Deterministic Forecast may produce the exhibits listed below. Only exhibits applicable to the plan and run are displayed. Some exhibits are available only for Valuation Sets (e.g., the census exhibits), while others are available only for Deterministic Forecasts (e.g., the Development of Market Assets exhibits).
| ProVal Exhibit | Word Bookmark / Access Table Name |
|
| Census | ||
| Active Participant Data | ProVal_AgeSvc | For Access, see notes below |
| Inactive Benefits Inforce | ProVal_Inact | For Access, see notes below |
| Funding | ||
| Market Assets (Funding Basis) | ProVal_MktVal | For Access, see notes below |
| Actuarial Assets | ProVal_ActAV / ProVal_DevActAssets | For Access, see notes below |
| Employer Contribution | ProVal_ErCtrb | |
| Normal Cost | ProVal_NC_UK | |
| Weighted Average Retirement Age | ProVal_WeightedRetAge | |
| Accounting | ||
| For asset, expense and funded status exhibits in Access, see notes below. | ||
| Market Assets (Accounting Basis) | ProVal_AcctgMktAssets | |
| IAS 19: Retirement Benefit Expense | ProVal_IAS19R / ProVal_DevExpense | |
| IAS 19: Balance Sheet | ProVal_RecIAS19R / ProVal_Acctg_Funded_Status |
-
The naming convention for Valuation Set Exhibits uses the prefix “ProVal_” and the naming convention for Deterministic Forecast Exhibits uses the prefix “ProVal_DetProj_”.
-
The Schedule of Active Participant Data and Distribution of Inactive Benefits (pension modes) exhibits are saved to Access for every integer age and service (for actives) so you have the flexibility to group the data as you see fit (e.g., in five-year or one-year intervals). Also, while these exhibits display average amounts for salaries, benefits, etc. in ProVal, the corresponding Access tables contain totals (which maintains more numeric precision).
-
In the U.S. qualified mode, identical data underlies the Schedule of Active Participant Data and the Schedule B – Schedule of Active Participant Data exhibits, so only one table is saved in Access (with the name ProVal_AgeSvc) even if both exhibits are selected.
-
The tables ProVal_DevActAssets and ProVal_DevMktRelAssets contain a special Asset_Val_Method row that denotes the asset smoothing method:
The Value column contains a code (1-6):
1 = Market Value Method
2 = Spread Gain Method
3 = Weighted Average of Market and Expected Value of Assets
4 = Weighted Average of Market & Book
5 = Corridor Method
6 = Equity Index Method
-
The tables ProVal_DevExpense, ProVal_Acctg.Funded_Status and ProVal_TrendSensitivity contain a special Accounting_Methodology row that denotes the accounting methodology:
The Value column contains a code:
1 = FAS 87 (2006)
11 = FAS 106 (2006)
2 = IAS 19 (2008)
7 = IAS 19
3 = CICA 3460
4 = CICA 3461
5 = GASB 25/27 OR 43/45
6 = ASC 715 (pension)
8 = GASB 67/68
16 = ASC 715 (OPEB)
